1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
|
DROP TABLE IF EXISTS bb1_boards;
CREATE TABLE bb1_boards (
boardid int(11) unsigned NOT NULL auto_increment,
styleid int(11) unsigned NOT NULL default '0',
parentid int(11) unsigned NOT NULL default '0',
parentlist text NOT NULL,
childlist text NOT NULL,
boardorder mediumint(7) unsigned NOT NULL default '1',
title varchar(250) NOT NULL default '',
password varchar(25) NOT NULL default '',
description text NOT NULL,
prefixuse tinyint(1) NOT NULL default '0',
prefix text NOT NULL,
threadcount int(11) unsigned NOT NULL default '0',
postcount int(11) unsigned NOT NULL default '0',
lastthreadid int(11) unsigned NOT NULL default '0',
lastposttime int(11) unsigned NOT NULL default '0',
lastposterid int(11) unsigned NOT NULL default '0',
lastposter varchar(50) NOT NULL default '0',
allowratings tinyint(1) NOT NULL default '1',
daysprune smallint(5) unsigned NOT NULL default '0',
sortfield varchar(20) NOT NULL default '',
sortorder varchar(5) NOT NULL default '',
threadsperpage smallint(5) unsigned NOT NULL default '0',
postsperpage smallint(5) unsigned NOT NULL default '0',
postorder tinyint(1) NOT NULL default '0',
countuserposts tinyint(1) NOT NULL default '1',
hotthread_reply smallint(5) unsigned NOT NULL default '0',
hotthread_view smallint(5) unsigned NOT NULL default '0',
moderatenew tinyint(2) NOT NULL default '0',
enforcestyle tinyint(1) NOT NULL default '0',
closed tinyint(1) NOT NULL default '0',
isboard tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
PRIMARY KEY (boardid)
) TYPE=MyISAM; |