#ݿ
create database forums

#ݿ
use forums

#####################
#SYS
#
#sysvisit ϵͳ

create table sys(sysvisit int(255) NOT NULL DEFAULT "0");

#####################
#
#
#num 
#catetitle 
#pri Ա
#cretime ཨʱ

create table categories(
num int(255) NOT NULL AUTO_INCREMENT,
catetitle char(20) NOT NULL,
pri char(24) NOT NULL,
cretime datetime,
PRIMARY KEY(num,catetitle));

#DBTB:
#Insert into categories(num,catetitle,pri,cretime) values('1','̼','hoowa',sysdate());

####################
#
#
#num  
#catenum 
#title 
#logo ͼƬ
#pri1 (Ա)
#pri2 (Ա)
#pri3 (Ա)
#state 鵱ǰ״̬(0|1д)
#bulletin ϵͳ
#filter ˵ȼ(0|1ʹBCODE|2ȫ)
#intro ̳
#cretime ʱ

create table indexbd(
num int(255) NOT NULL AUTO_INCREMENT,
catenum int(255) NOT NULL,
title char(20) NOT NULL,
logo char(50),
pri1 char(24) NOT NULL,
pri2 char(24),
pri3 char(24),
state char(1) NOT NULL,
bulletin char(200),
filter int(1) NOT NULL DEFAULT "2",
intro char(100),
cretime datetime NOT NULL,
PRIMARY KEY(num,title));

#DBTB:
#Insert into categories(num,catenum,title,logo,pri1,pri2,pri3,state,bulletin,filter,intro,cretime)
#values('2','1','2','PHP̳','ilcat.jpg','hoowa','hoowa','','','0','','ۿõϵͳ',sysdate());

#####################
#ûϢ
#
#id ûʶ
#name û
#password ûʶ
#logo ûͷ
#email û
#province ʡ
#city ڳ
#sex Ա
#age 
#job û
#homepage ûҳ
#oicq OICQ
#intro ˽
#uw1 ǩ1
#uw2 ǩ2
#uw3 ǩ3
#exp û
#cretime ʱ
#state ǰ״̬(0|1)
#level ûԱȼ

create table userdata(
id varchar(12) NOT NULL,
name varchar(8),
passwd varchar(50) NOT NULL,
logo varchar(3),
email varchar(50) NOT NULL,
province varchar(8),
city varchar(8),
sex varchar(2),
age int(2),
job varchar(16),
homepage varchar(50),
oicq int(10),
intro varchar(100),
uw1 varchar(200),
uw2 varchar(200),
uw3 varchar(200),
exp int(100) NOT NULL,
cretime date NOT NULL,
state int(1) DEFAULT "0",
level int(1) NOT NULL,
PRIMARY KEY(id));

##################
#ǰûϢ
#
#lgt ½ʱ
#lgcd ½ʱ
#uid ½ID
#unk ½NICK
#ulv ûĵȼ
#act ǰ
#ipc ½ip
#ukey ΨһKey

create table onlines(
lgt char(30) NOT NULL,
lgcd char(30) NOT NULL,
uid char(12) NOT NULL,
unk char(8) NOT NULL,
ulv int(1) NOT NULL,
act char(30),
ipc char(50) NOT NULL,
ukey char(50) NOT NULL,
PRIMARY KEY(lgt,uid));

####################
#ϢSMSݱṹ
#uid ûID
#action ״̬ߣǷϢ
#sms洢ݽṹ
#id|nick|ʱ|

create table sms(
uid char(20) NOT NULL,
action int(1),
sms text,
PRIMARY KEY(uid));

#DBTB:
#

########################
#(Ƚ)
#num 
#subnum ӱ
#count 
#face ʱ
#uw ǩ
#autid ID
#autname ߳ƺ
#subject 
#text 
#cretime ʱ

create table board1(
num int(255) NOT NULL,
subnum int(255) NOT NULL,
count int(50) DEFAULT "0",
face varchar(2),
uw varchar(2),
autid varchar(12) NOT NULL,
autname varchar(8) NOT NULL,
subject varchar(60) NOT NULL,
text text,
cretime datetime,
PRIMARY KEY(subject));


#####################
#ͶƱϵͳ
#
#num ͶƱϵͳ
#bnum 
#ctman  
#polname ͶƱ
#pol1 ͶƱĿ1
#pol2 ͶƱĿ2
#pol3 ͶƱĿ3
#pol4 ͶƱĿ4
#pol5 ͶƱĿ5
#pol6 ͶƱĿ6
#pol7 ͶƱĿ7
#pol8 ͶƱĿ8
#polc1 ͶƱ1
#polc2 ͶƱ2
#polc3 ͶƱ3
#polc4 ͶƱ4
#polc5 ͶƱ5
#polc6 ͶƱ6
#polc7 ͶƱ7
#polc8 ͶƱ8
#sttime ʼʱ
#edtime ʱ
#lastip һͶip

create table poll(
num int(255) NOT NULL AUTO_INCREMENT,
bnum int(255) NOT NULL,
ctman varchar(20) NOT NULL,
polname varchar(60) NOT NULL,
pol1 varchar(12),
pol2 varchar(12),
pol3 varchar(12),
pol4 varchar(12),
pol5 varchar(12),
pol6 varchar(12),
pol7 varchar(12),
pol8 varchar(12),
polc1 varchar(12) NOT NULL DEFAULT "0",
polc2 varchar(12) NOT NULL DEFAULT "0",
polc3 varchar(12) NOT NULL DEFAULT "0",
polc4 varchar(12) NOT NULL DEFAULT "0",
polc5 varchar(12) NOT NULL DEFAULT "0",
polc6 varchar(12) NOT NULL DEFAULT "0",
polc7 varchar(12) NOT NULL DEFAULT "0",
polc8 varchar(12) NOT NULL DEFAULT "0",
sttime date NOT NULL,
edtime date NOT NULL,
lastip varchar(20),
PRIMARY KEY(num,polname));


########################
#ྫ(ͬһͬ)
#num ӱ(ͬӱŲͬ)
#numb 
#autid 
#autname 
#subject 
#text 
#cretime ʱ
#joinname 
#jointime 뾫ʱ

create table note1(
num int(255) NOT NULL AUTO_INCREMENT,
numb int(255) NOT NULL,
autid varchar(12) NOT NULL,
autname varchar(8),
subject varchar(60) NOT NULL,
text text NOT NULL,
cretime datetime,
joinname varchar(24) NOT NULL,
jointime datetime NOT NULL,
PRIMARY KEY(num));


#########################
#½ģ
#constory
#
#num 
#cn 
#state ǰ״̬0|1
#author 
#cretime ʱ
#subject 
#description ¼
#text 

create table constory(
num int(100) NOT NULL AUTO_INCREMENT,
cn int(100) NOT NULL,
state int(1),
author varchar(24) NOT NULL,
cretime datetime,
subject varchar(60) NOT NULL,
description varchar(250) NOT NULL,
text text,
PRIMARY KEY(num,subject));

Create By hoowa