Code : Tout sélectionner
"CREATE ".C_MYSQL_MEMBERS." (
id smallint unsigned ZEROFILL NOT NULL auto_increment,
fname varchar(16) NOT NULL default '',
lname varchar(30) NOT NULL default '',
password char(16) NOT NULL default '',
birthday DATE NOT NULL default '0',
gender tinyint unsigned NOT NULL default '0',
purposes tinyint unsigned NOT NULL default '0',
country tinyint unsigned NOT NULL default '0',
email varchar(64) NOT NULL default '',
url varchar(64) NOT NULL default '',
icq int unsigned NOT NULL default '0',
aim varchar(16) NOT NULL default '',
phone varchar(20) NOT NULL default '',
city varchar(32) NOT NULL default '',
marstat tinyint unsigned NOT NULL default '0',
child tinyint unsigned NOT NULL default '0',
height tinyint unsigned NOT NULL default '0',
weight tinyint unsigned NOT NULL default '0',
hcolor tinyint unsigned NOT NULL default '0',
ecolor tinyint unsigned NOT NULL default '0',
etnicity tinyint unsigned NOT NULL default '0',
religion tinyint unsigned NOT NULL default '0',
smoke tinyint unsigned NOT NULL default '0',
drink tinyint unsigned NOT NULL default '0',
education tinyint unsigned NOT NULL default '0',
job varchar(30) NOT NULL default '',
hobby tinytext NOT NULL default '',
descr text NOT NULL default '',
sgender tinyint unsigned NOT NULL default '0',
setnicity tinyint unsigned NOT NULL default '0',
sreligion tinyint unsigned NOT NULL default '0',
agef tinyint unsigned NOT NULL default '0',
aget tinyint unsigned NOT NULL default '0',
heightf tinyint unsigned NOT NULL default '0',
heightt tinyint unsigned NOT NULL default '0',
weightf tinyint unsigned NOT NULL default '0',
weightt tinyint unsigned NOT NULL default '0',
hdyfu tinyint unsigned NOT NULL default '0',
pic1 varchar(24) NOT NULL default '',
pic2 varchar(24) NOT NULL default '',
pic3 varchar(24) NOT NULL default '',
horo tinyint unsigned NOT NULL default '0',
regdate DATETIME NOT NULL default '0',
editdate DATETIME NOT NULL default '0',
ip int unsigned NOT NULL default '0',
status tinyint unsigned NOT NULL default '0',
req tinyint unsigned NOT NULL default '0',
UNIQUE KEY id (id)
)"
"DROP TABLE ".C_MYSQL_ONLINE_USERS);
$sql = "CREATE TABLE ".C_MYSQL_ONLINE_USERS." (
time time NOT NULL,
user int unsigned NOT NULL default '0',
usertype smallint NOT NULL default '0',
ip int(8) unsigned NOT NULL default '0'
) TYPE = HEAP";
CREATE ".C_MYSQL_MAILLIST." (
id SMALLINT UNSIGNED NOT NULL auto_increment,
uid SMALLINT UNSIGNED NOT NULL default '',
horo tinyint unsigned NOT NULL default '0',
agef tinyint unsigned NOT NULL default '0',
aget tinyint unsigned NOT NULL default '0',
gender tinyint unsigned NOT NULL default '0',
purposes tinyint unsigned NOT NULL default '0',
country tinyint unsigned NOT NULL default '0',
regin tinyint unsigned NOT NULL default '0',
status tinyint unsigned NOT NULL default '0',
mtype tinyint unsigned NOT NULL default '0',
frommail varchar(40) NOT NULL default '',
subject tinytext NOT NULL default '',
message text NOT NULL default '',
confirm tinyint unsigned NOT NULL default '0',
lastid SMALLINT UNSIGNED NOT NULL default '',
maildate DATETIME NOT NULL default '0',
UNIQUE KEY id (id)
)";Code : Tout sélectionner
Erreur
Analyse statique :
5 erreurs trouvées lors de l'analyse.
Début d'énoncé inattendu. (near ""CREATE "" at position 0)
Début d'énoncé inattendu. (near "C_MYSQL_MEMBERS" at position 10)
Début d'énoncé inattendu. (near "" ( id smallint unsigned ZEROFILL NOT NULL auto_increment, fname varchar(16) NOT NULL default '', lname varchar(30) NOT NULL default '', password char(16) NOT NULL default '', birthday DATE NOT NULL default '0', gender tinyint unsigned NOT NULL default '0', purposes tinyint unsigned NOT NULL default '0', country tinyint unsigned NOT NULL default '0', email varchar(64) NOT NULL default '', url varchar(64) NOT NULL default '', icq int unsigned NOT NULL default '0', aim varchar(16) NOT NULL default '', phone varchar(20) NOT NULL default '', city varchar(32) NOT NULL default '', marstat tinyint unsigned NOT NULL default '0', child tinyint unsigned NOT NULL default '0', height tinyint unsigned NOT NULL default '0', weight tinyint unsigned NOT NULL default '0', hcolor tinyint unsigned NOT NULL default '0', ecolor tinyint unsigned NOT NULL default '0', etnicity tinyint unsigned NOT NULL default '0', religion tinyint unsigned NOT NULL default '0', smoke tinyint unsigned NOT NULL default '0', drink tinyint unsigned NOT NULL default '0', education tinyint unsigned NOT NULL default '0', job varchar(30) NOT NULL default '', hobby tinytext NOT NULL default '', descr text NOT NULL default '', sgender tinyint unsigned NOT NULL default '0', setnicity tinyint unsigned NOT NULL default '0', sreligion tinyint unsigned NOT NULL default '0', agef tinyint unsigned NOT NULL default '0', aget tinyint unsigned NOT NULL default '0', heightf tinyint unsigned NOT NULL default '0', heightt tinyint unsigned NOT NULL default '0', weightf tinyint unsigned NOT NULL default '0', weightt tinyint unsigned NOT NULL default '0', hdyfu tinyint unsigned NOT NULL default '0', pic1 varchar(24) NOT NULL default '', pic2 varchar(24) NOT NULL default '', pic3 varchar(24) NOT NULL default '', horo tinyint unsigned NOT NULL default '0', regdate DATETIME NOT NULL default '0', editdate DATETIME NOT NULL default '0', ip int unsigned NOT NULL default '0', status tinyint unsigned NOT NULL default '0', req tinyint unsigned NOT NULL default '0', UNIQUE KEY id (id) )"" at position 26)
Début d'énoncé inattendu. (near ""DROP TABLE "" at position 2222)
Début d'énoncé inattendu. (near "C_MYSQL_ONLINE_USERS" at position 2236)
Requête SQL :
"CREATE ".C_MYSQL_MEMBERS." ( id smallint unsigned ZEROFILL NOT NULL auto_increment, fname varchar(16) NOT NULL default '', lname varchar(30) NOT NULL default '', password char(16) NOT NULL default '', birthday DATE NOT NULL default '0', gender tinyint unsigned NOT NULL default '0', purposes tinyint unsigned NOT NULL default '0', country tinyint unsigned NOT NULL default '0', email varchar(64) NOT NULL default '', url varchar(64) NOT NULL default '', icq int unsigned NOT NULL default '0', aim varchar(16) NOT NULL default '', phone varchar(20) NOT NULL default '', city varchar(32) NOT NULL default '', marstat tinyint unsigned NOT NULL default '0', child tinyint unsigned NOT NULL default '0', height tinyint unsigned NOT NULL default '0', weight tinyint unsigned NOT NULL default '0', hcolor tinyint unsigned NOT NULL default '0', ecolor tinyint unsigned NOT NULL default '0', etnicity tinyint unsigned NOT NULL default '0', religion tinyint unsigned NOT NULL default '0', smoke tinyint unsigned NOT NULL default '0', drink tinyint unsigned NOT NULL default '0', education tinyint unsigned NOT NULL default '0', job varchar(30) NOT NULL default '', hobby tinytext NOT NULL default '', descr text NOT NULL default '', sgender tinyint unsigned NOT NULL default '0', setnicity tinyint unsigned NOT NULL default '0', sreligion tinyint unsigned NOT NULL default '0', agef tinyint unsigned NOT NULL default '0', aget tinyint unsigned NOT NULL default '0', heightf tinyint unsigned NOT NULL default '0', heightt tinyint unsigned NOT NULL default '0', weightf tinyint unsigned NOT NULL default '0', weightt tinyint unsigned NOT NULL default '0', hdyfu tinyint unsigned NOT NULL default '0', pic1 varchar(24) NOT NULL default '', pic2 varchar(24) NOT NULL default '', pic3 varchar(24) NOT NULL default '', horo tinyint unsigned NOT NULL default '0', regdate DATETIME NOT NULL default '0', editdate DATETIME NOT NULL default '0', ip int unsigned NOT NULL default '0', status tinyint unsigned NOT NULL default '0', req tinyint unsigned NOT NULL default '0', UNIQUE KEY id (id) )" "DROP TABLE ".C_MYSQL_ONLINE_USERS)
MySQL a répondu :
#1064 - Erreur de syntaxe près de '"CREATE ".C_MYSQL_MEMBERS." (
id smallint unsigned ZEROFILL NOT NULL auto_inc' à la ligne 1Merci beaucoup