· 9 years ago · Jan 27, 2017, 11:04 PM
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 $result = mysql_query($query,$srv) or die("Nie utworzono tabeli");
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 $result = mysql_query($query,$srv) or die("Nie utworzono tabeli");
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";