ufield TEXT NOT NULL COMMENT '用户定制项目',
credit smallint(6) unsigned NOT NULL default '0' COMMENT '需消耗的积分', PRIMARY KEY (tid),
KEY uid (uid,starttimefrom),
KEY starttimefrom (starttimefrom), KEY expiration (expiration),
KEY applynumber (applynumber)
) ENGINE=MyISAM COMMENT='活动表';
DROP TABLE IF EXISTS pre_forum_activityapply; CREATE TABLE pre_forum_activityapply (
applyid int(10) unsigned NOT NULL auto_increment COMMENT '申请id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', username varchar(255) NOT NULL default COMMENT '用户名',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', message varchar(255) NOT NULL default COMMENT '消息',
verified tinyint(1) NOT NULL default '0' COMMENT '是否审核通过\\n(0:N 1:Y 2:需完善资料)',
dateline int(10) unsigned NOT NULL default '0' COMMENT '申请时间', payment mediumint(8) NOT NULL default '0' COMMENT '每人花销', ufielddata TEXT NOT NULL COMMENT '用户定制项目数据', PRIMARY KEY (applyid), KEY uid (uid), KEY tid (tid),
KEY dateline (tid,dateline)
) ENGINE=MyISAM COMMENT='活动申请表';
DROP TABLE IF EXISTS pre_forum_announcement; CREATE TABLE pre_forum_announcement (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '公告id', author varchar(15) NOT NULL default COMMENT '作者姓名', `subject` varchar(255) NOT NULL default COMMENT '公告标题',
`type` tinyint(1) NOT NULL default '0' COMMENT '公告类型\\n(0:文字公告 1:网址链接)', displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', starttime int(10) unsigned NOT NULL default '0' COMMENT '开始时间', endtime int(10) unsigned NOT NULL default '0' COMMENT '结束时间', message text NOT NULL COMMENT '消息',
groups text NOT NULL COMMENT '接受用户组', PRIMARY KEY (id),
KEY timespan (starttime,endtime)
) ENGINE=MyISAM COMMENT='公告表'; DROP TABLE IF EXISTS pre_forum_threadimage;
CREATE TABLE pre_forum_threadimage (
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', KEY tid (tid)
) ENGINE=MyISAM COMMENT='主题图片表';
DROP TABLE IF EXISTS pre_forum_attachment; CREATE TABLE pre_forum_attachment (
aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '附件id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', tableid tinyint(1) unsigned NOT NULL default '0' COMMENT '附件表id', downloads mediumint(8) NOT NULL default '0' COMMENT '下载次数', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)
) ENGINE=MyISAM COMMENT='附件索引表';
DROP TABLE IF EXISTS pre_forum_attachment_exif; CREATE TABLE pre_forum_attachment_exif (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id', exif text NOT NULL COMMENT 'exif信息', PRIMARY KEY (aid)
) ENGINE=MyISAM COMMENT='Exif缓存表';
DROP TABLE IF EXISTS pre_forum_attachment_unused; CREATE TABLE pre_forum_attachment_unused (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', PRIMARY KEY (aid), KEY uid (uid)
) ENGINE=MyISAM COMMENT='未使用附件表'; DROP TABLE IF EXISTS pre_forum_attachment_0; CREATE TABLE pre_forum_attachment_0 (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',
readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)
) ENGINE=MyISAM COMMENT='附件表';
DROP TABLE IF EXISTS pre_forum_attachment_1; CREATE TABLE pre_forum_attachment_1 (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',
readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)
) ENGINE=MyISAM COMMENT='附件表';
DROP TABLE IF EXISTS pre_forum_attachment_2; CREATE TABLE pre_forum_attachment_2 (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',
readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)
) ENGINE=MyISAM COMMENT='附件表';
DROP TABLE IF EXISTS pre_forum_attachment_3; CREATE TABLE pre_forum_attachment_3 (
aid mediumint(8) unsigned NOT NULL COMMENT '附件id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',
readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid),