chjbEjwT

1$query = "CREATE TABLE IF NOT EXISTS projects (id int unsigned not null AUTO_INCREMENT PRIMARY KEY,name varchar(255),UID int unsigned not null) CHARACTER SET utf8 COLLATE utf8_bin";
2
3    $query = "CREATE TABLE IF NOT EXISTS tasks (id int unsigned not null AUTO_INCREMENT PRIMARY KEY,author varchar(255),name text,description text,Project varchar(255) ,UID int unsigned not null,created date not null,priority varchar(255),type varchar(255),author_email varchar(255)) CHARACTER SET utf8 COLLATE utf8_bin";
4
5    $query = "CREATE TABLE IF NOT EXISTS comments (id int unsigned not null AUTO_INCREMENT PRIMARY KEY,Comment text, Project varchar(255),author varchar(255),author_email varchar(255)) CHARACTER SET utf8 COLLATE utf8_bin";