CREATE TABLE "user"(
id int( 4 ) NOT NULL default '0',
id_owner int( 4 ) NOT NULL ,
grade_en varchar( 20 ) default NULL ,
grade_fr varchar( 50 ) default NULL ,
id_category varchar( 50 ) NOT NULL default '',
position_en varchar( 50 ) NOT NULL default '',
position_fr varchar( 50 ) NOT NULL default '',
user_name varchar( 50 ) NOT NULL default '',
pw varchar( 50 ) NOT NULL default '',
name varchar( 50 ) NOT NULL default '',
first_name varchar( 50 ) NOT NULL default '',
img int( 4 ) NOT NULL default '0',
office varchar( 20 ) NOT NULL default '',
phone varchar( 20 ) NOT NULL default '',
fax varchar( 20 ) NOT NULL default '',
cellular varchar( 20 ) default NULL ,
slogan_en longtext,
slogan_fr longtext,
interest_en longtext,
interest_fr longtext,
permission varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( id_owner )
) AUTO_INCREMENT =13;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax near '"user" (
tid int(4) NOT NULL default '0',
tid_owner int(4) NOT NULL,
tg' at line 1
Partager