4 tables :
CREATE TABLE ForumA_membres (
id tinyint(4) NOT NULL auto_increment,
pseudo varchar(250) NOT NULL default ´´,
email varchar(250) NOT NULL default ´´,
mdp varchar(250) NOT NULL default ´´,
joined varchar(250) NOT NULL default ´´,
ip varchar(250) NOT NULL default ´´,
Posts_total tinyint(9) NOT NULL default ´´,
Last_post varchar(250) NOT NULL default ´´,
bday varchar(250) NOT NULL default ´´,
pays varchar(250) NOT NULL default ´´,
sexe varchar(250) NOT NULL default ´´,
description text,
PRIMARY key ( id)
) TYPE=MyISAM;
CREATE TABLE ForumA_Modero (
id tinyint(4) NOT NULL auto_increment,
pseudo varchar(250) NOT NULL default ´´,
email varchar(250) NOT NULL default ´´,
mdp varchar(250) NOT NULL default ´´,
ip varchar(250) NOT NULL default ´´,
Posts_total tinyint(9) NOT NULL default ´´,
PRIMARY key ( id)
) TYPE=MyISAM;
CREATE TABLE ForumA_Post (
id tinyint(4) NOT NULL auto_increment,
pseudo varchar(250) NOT NULL default ´´,
email varchar(250) NOT NULL default ´´,
titre text NOT NULL,
Topic_id tinyint(4) NOT NULL default ´´,
Post text NOT NULL,
Post_date varchar(250) NOT NULL default ´´,
date date NOT NULL default ´0000-00-00´,
heure time NOT NULL default ´00:00:00´,
PRIMARY key ( id)
) TYPE=MyISAM;
CREATE TABLE ForumA_Topics (
id tinyint(4) NOT NULL auto_increment,
pseudo varchar(250) NOT NULL default ´´,
email varchar(250) NOT NULL default ´´,
titre text NOT NULL,
Posts Smallint(4) NULL default ´NULL´,
Last_post varchar(250) NOT NULL default ´´,
Last_date date NOT NULL default ´0000-00-00´,
Last_heure time NOT NULL default ´00:00:00´,
date date NOT NULL default ´0000-00-00´,
heure time NOT NULL default ´00:00:00´,
PRIMARY key ( id)
) TYPE=MyISAM;
voili : ) il y a biensûr moyen de les optimiser : )