Posté : 25-11-2015 07:40
Bonjour
As tu essayer justement de passer le script par phpmysql:
CREATE TABLE partenaires (
id int(7) NOT NULL auto_increment,
pseudo varchar(15) NOT NULL default '',
password varchar(15) NOT NULL default '',
email varchar(255) NOT NULL default '',
titre varchar(17) NOT NULL default '',
url varchar(255) NOT NULL default '',
urlbouton varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
numCat int(4) NOT NULL default '0',
points int(4) NOT NULL default '0',
hits int(4) NOT NULL default '0',
triche int(4) NOT NULL default '0',
dateCreat datetime NOT NULL default '0000-00-00  ;00:00:00',
statut enum('0','1') NOT NULL default '0',
lastIP varchar(15) NOT NULL default '0.0.0.0',
IPout varchar(15) NOT NULL default '0.0.0.0',
LastUpdate date NOT NULL default '0000-00-00',
pos int(4) NOT NULL default '9999',
PRIMARY KEY (id),
UNIQUE KEY pseudo (pseudo),
UNIQUE KEY id (id)
);
"CREATE TABLE partenaires_conf (
bouton varchar(255) NOT NULL default '',
limitadmin varchar(5) NOT NULL default '10',
limitindex varchar(5) NOT NULL default '10',
limitpart varchar(5) NOT NULL default '10',
toggle enum('0','1') NOT NULL default '1'
);
"INSERT INTO `partenaires_conf` VALUES ('hotfirenet.gif', '10', '10', '10', '0');
|