| drvins |
bon, je te donne un exemple :
### Structure de la table 'xmb_forums'
#DROP TABLE IF EXISTS xmb_forums;
CREATE TABLE xmb_forums (
type varchar(15) NOT NULL,
fid smallint(6) NOT NULL auto_increment,
name varchar(50) NOT NULL,
status varchar(15) NOT NULL,
lastpost varchar(30) NOT NULL,
moderator varchar(100) NOT NULL,
displayorder smallint(6) DEFAULT '0' NOT NULL,
private varchar(30),
description text,
allowhtml char(3) NOT NULL,
allowsmilies char(3) NOT NULL,
allowbbcode char(3) NOT NULL,
guestposting char(3) NOT NULL,
userlist text NOT NULL,
theme varchar(30) NOT NULL,
posts int(100) DEFAULT '0' NOT NULL,
threads int(100) DEFAULT '0' NOT NULL,
fup smallint(6) DEFAULT '0' NOT NULL,
postperm char(3) NOT NULL,
allowimgcode char(3) NOT NULL,
PRIMARY KEY (fid)
)
### Données dans la table 'xmb_forums' (6 enregistrements, 20 champs)
INSERT INTO xmb_forums VALUES ('forum', '1', 'General', 'on', '1003516291|Dr.Vins', '', '0', '', 'To talk about the site.', 'yes', 'yes', 'yes', 'yes', '', 'gray', '11', '3', '0', '1|1', 'yes');
INSERT INTO xmb_forums VALUES ('sub', '3', '', '', '', '', '0', '', '', 'no', 'yes', 'yes', 'no', '', '', '0', '0', '0', '1', 'yes');
INSERT INTO xmb_forums VALUES ('forum', '4', 'Requests', 'on', '1003697032|Dr.Vins', '', '2', '', 'Looking for a video or a album ? Ask in here.', 'yes', 'yes', 'yes', 'yes', '', 'gray', '17', '6', '0', '1|1', 'yes');
INSERT INTO xmb_forums VALUES ('forum', '5', 'Blabla', 'on', '', '', '4', '', 'Just a place to chat.', 'yes', 'yes', 'yes', 'yes', '', 'gray', '2', '1', '0', '1|1', 'yes');
INSERT INTO xmb_forums VALUES ('forum', '6', 'Music', 'on', '1003434969|Psykolio', '', '1', '', 'To chat about music in general.', 'yes', 'yes', 'yes', 'yes', '', 'gray', '0', '0', '0', '1|1', 'yes');
INSERT INTO xmb_forums VALUES ('forum', '7', 'Technics', 'on', '', '', '3', '', 'To talk about the new audio and video compressions.', 'yes', 'yes', 'yes', 'yes', '', 'gray', '0', '0', '0', '1|1', 'yes');
### Structure de la table 'xmb_members'
#DROP TABLE IF EXISTS xmb_members;
CREATE TABLE xmb_members (
uid smallint(6) NOT NULL auto_increment,
username varchar(25) NOT NULL,
password varchar(18) NOT NULL,
regdate bigint(30) DEFAULT '0' NOT NULL,
postnum smallint(6) DEFAULT '0' NOT NULL,
email varchar(60),
site varchar(75),
aim varchar(40),
status varchar(35) NOT NULL,
location varchar(50),
bio text,
sig text,
showemail varchar(15) NOT NULL,
timeoffset int(5) DEFAULT '0' NOT NULL,
icq varchar(30) NOT NULL,
avatar varchar(90),
yahoo varchar(40) NOT NULL,
customstatus varchar(100) NOT NULL,
theme varchar(30) NOT NULL,
bday varchar(50),
langfile varchar(40) NOT NULL,
tpp smallint(6) DEFAULT '0' NOT NULL,
ppp smallint(6) DEFAULT '0' NOT NULL,
newsletter char(3) NOT NULL,
regip varchar(40) NOT NULL,
timeformat int(5) DEFAULT '0' NOT NULL,
msn varchar(40) NOT NULL,
dateformat varchar(10) NOT NULL,
ignoreu2u text,
lastvisit bigint(30),
PRIMARY KEY (uid)
et c'est comme ça pour chacque table. |
