Просмотр архива форум

#
# Table structure for table 'forums'
#
CREATE TABLE forums (
forum_id
int(10) DEFAULT '1' NOT NULL auto_increment,
forum_name varchar(150) NOT
NULL,
forum_desc text NOT NULL,
forum_order int(10) NOT NULL,
forum_icon
varchar(255) DEFAULT 'default.gif' NOT NULL,
PRIMARY KEY
(forum_id)
);

#
# Table structure for table 'posts'
#
CREATE TABLE
posts (
post_id int(11) DEFAULT '1' NOT NULL auto_increment,
forum_id
int(10) DEFAULT '1' NOT NULL,
topic_id int(10) DEFAULT '1' NOT
NULL,
poster_id int(10) DEFAULT '0' NOT NULL,
poster_name varchar(40)
DEFAULT 'Anonymous' NOT NULL,
post_text text NOT NULL,
post_time datetime
NOT NULL,
poster_ip varchar(16) NOT NULL,
post_status tinyint(1) DEFAULT
'0' NOT NULL,
# post_status: 0-clear (available for edit), 1-edited by
author, 2-edited by admin (available only for admin)
KEY post_id
(post_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id),
KEY
poster_id (poster_id),
PRIMARY KEY (post_id)
);

#
# Table structure
for table 'topics'
#
CREATE TABLE topics (
topic_id int(10) DEFAULT '1'
NOT NULL auto_increment,
topic_title varchar(100) NOT NULL,
topic_poster
int(10) DEFAULT '0' NOT NULL,
topic_poster_name varchar(40) DEFAULT
'Anonymous' NOT NULL,
topic_time datetime NOT NULL,
topic_views int(10)
DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '1' NOT NULL,
topic_status
tinyint(1) DEFAULT '0' NOT NULL,
# about status: 0 - opened;
1-locked
topic_last_post_id int(10) DEFAULT '1' NOT NULL,
KEY topic_id
(topic_id),
KEY forum_id (forum_id),
PRIMARY KEY (topic_id)
);

#
#
Table structure for table 'users'
#
CREATE TABLE users (
user_id int(10)
DEFAULT '1' NOT NULL auto_increment,
username varchar(40) DEFAULT '' NOT
NULL,
user_regdate datetime NOT NULL,
user_password varchar(32) DEFAULT
'' NOT NULL,
user_email varchar(50) NOT NULL,
user_icq varchar(15) NOT
NULL,
user_website varchar(100) NOT NULL,
user_occ varchar(100) NOT
NULL,
user_from varchar(100) NOT NULL,
user_interest varchar(150) NOT
NULL,
user_viewemail tinyint(1) NOT NULL,
#sort: 0 - not view; 1 -
view
user_sorttopics tinyint(1) DEFAULT '1' NOT NULL,
#sort: 1 - new
topics; 0 - new answers
user_newpwdkey varchar(32) NOT
NULL,
user_newpasswd varchar(32) NOT NULL,
PRIMARY KEY
(user_id)
);

#
# Table structure for table 'send_mails'
#
CREATE
TABLE send_mails (
id int(11) DEFAULT '1' NOT NULL
auto_increment,
user_id int(10) DEFAULT '1' NOT NULL,
user_email
varchar(50) NOT NULL,
forum_id int(10) DEFAULT '1' NOT NULL,
topic_id
int(10) DEFAULT '1' NOT NULL,
PRIMARY KEY (id)
);

#
# Table structure
for table 'banned'
#
CREATE TABLE banned (
id int(10) DEFAULT '1' NOT
NULL auto_increment,
banip varchar(16) NOT NULL,
PRIMARY KEY (id)
);