Citation :
### Structure de la table 'banlist'
#DROP TABLE IF EXISTS banlist;
CREATE TABLE banlist (
ban_id int(10) NOT NULL auto_increment,
ban_userid int(10),
ban_ip varchar(16),
ban_start int(32),
ban_end int(50),
ban_time_type int(10),
PRIMARY KEY (ban_id),
KEY ban_id (ban_id)
)
### Structure de la table 'catagories'
#DROP TABLE IF EXISTS catagories;
CREATE TABLE catagories (
cat_id int(10) NOT NULL auto_increment,
cat_title varchar(100),
cat_order varchar(10),
PRIMARY KEY (cat_id)
)
### Données dans la table 'catagories' (1 enregistrements, 3 champs)
INSERT INTO catagories VALUES ('1', 'Sujets', '1');
### Structure de la table 'config'
#DROP TABLE IF EXISTS config;
CREATE TABLE config (
config_id int(10) NOT NULL auto_increment,
sitename varchar(100),
allow_html int(2),
allow_bbcode int(2),
allow_sig int(2),
allow_namechange int(2) DEFAULT '0',
admin_passwd varchar(32),
selected int(2) DEFAULT '0' NOT NULL,
posts_per_page int(10),
hot_threshold int(10),
topics_per_page int(10),
allow_theme_create int(10),
override_themes int(2) DEFAULT '0',
email_sig varchar(255),
email_from varchar(100),
default_lang varchar(255),
PRIMARY KEY (config_id),
UNIQUE selected (selected)
)
|
