- create table pre_forum_thread
- (
- tid int unsigned auto_increment
- primary key,
- fid mediumint unsigned default '0' not null,
- posttableid smallint unsigned default '0' not null,
- typeid smallint unsigned default '0' not null,
- sortid smallint unsigned default '0' not null,
- readperm tinyint unsigned default '0' not null,
- price smallint default 0 not null,
- author char(15) default '' not null,
- authorid mediumint unsigned default '0' not null,
- subject varchar(255) default '' not null,
- dateline int unsigned default '0' not null,
- lastpost int unsigned default '0' not null,
- lastposter char(15) default '' not null,
- views int unsigned default '0' not null,
- replies mediumint unsigned default '0' not null,
- displayorder tinyint(1) default 0 not null,
- highlight tinyint(1) default 0 not null,
- digest tinyint(1) default 0 not null,
- rate tinyint(1) default 0 not null,
- special tinyint(1) default 0 not null,
- attachment tinyint(1) default 0 not null,
- moderated tinyint(1) default 0 not null,
- closed mediumint unsigned default '0' not null,
- stickreply tinyint(1) default 0 not null,
- recommends smallint default 0 not null,
- recommend_add smallint default 0 not null,
- recommend_sub smallint default 0 not null,
- heats int unsigned default '0' not null,
- status smallint unsigned default '0' not null,
- isgroup tinyint(1) default 0 not null,
- favtimes mediumint default 0 not null,
- sharetimes mediumint default 0 not null,
- stamp tinyint default -1 not null,
- icon tinyint default -1 not null,
- pushedaid mediumint default 0 not null,
- cover smallint default 0 not null,
- replycredit int default 0 not null,
- relatebytag char(255) default '0' not null,
- maxposition int unsigned default '0' not null,
- bgcolor char(8) default '' not null,
- comments int unsigned default '0' not null,
- hidden smallint unsigned default '0' not null
- )
复制代码
|
|