DROP TABLE IF EXISTS pre_forum_groupfield;
CREATE TABLE pre_forum_groupfield (
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '群组关联fid',
privacy tinyint(1) unsigned NOT NULL default '0' COMMENT '群组隐私设置',
dateline int(10) unsigned NOT NULL default '0' COMMENT '缓存生成时间',
type varchar(255) NOT NULL COMMENT '缓存类型',
data text NOT NULL COMMENT '缓存数据',
UNIQUE KEY types (fid,type),
KEY fid (fid),
KEY type (type)
) ENGINE = MyISAM COMMENT='群组扩展信息缓存';


DROP TABLE IF EXISTS pre_forum_groupinvite;
CREATE TABLE pre_forum_groupinvite (
fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组id',
uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '邀请人id',
inviteuid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '被邀请人id',
dateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '邀请时间',
UNIQUE KEY ids (fid,inviteuid),
KEY dateline (dateline)
) ENGINE = MYISAM COMMENT='群组邀请';


DROP TABLE IF EXISTS pre_forum_groupuser;
CREATE TABLE pre_forum_groupuser (
fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组关联fid',
uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员id',
username CHAR( 15 ) NOT NULL COMMENT '成员名',
level TINYINT( 3 ) UNSIGNED NOT NULL default '0' COMMENT '成员等级\n(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)',
threads MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员主题数',
replies MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员回复数',
joindateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员加入群组时间',
lastupdate INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员最后活动时间',
privacy TINYINT( 1 ) UNSIGNED NOT NULL default '0' COMMENT '成员隐私设置',
PRIMARY KEY (fid,uid),
KEY uid_lastupdate (uid,lastupdate),
KEY userlist (fid,level,lastupdate)
) ENGINE = MYISAM COMMENT='群组成员';


DROP TABLE IF EXISTS pre_common_plugin;
CREATE TABLE pre_common_plugin (
pluginid smallint(6) unsigned NOT NULL auto_increment COMMENT '插件id',
available tinyint(1) NOT NULL default '0' COMMENT '是否启用',
adminid tinyint(1) unsigned NOT NULL default '0' COMMENT '管理员id',
`name` varchar(40) NOT NULL default COMMENT '名称',
identifier varchar(40) NOT NULL default COMMENT '唯一标识符',
description varchar(255) NOT NULL default COMMENT '解释说明',
datatables varchar(255) NOT NULL default COMMENT '插件数据表',
`directory` varchar(100) NOT NULL default COMMENT '插件目录',
copyright varchar(100) NOT NULL default COMMENT '版权信息',
modules text NOT NULL COMMENT '插件信息',
version varchar(20) NOT NULL default COMMENT '插件版本',
PRIMARY KEY (pluginid),
UNIQUE KEY identifier (identifier)
) ENGINE=MyISAM COMMENT='插件表';


DROP TABLE IF EXISTS pre_common_pluginvar;
CREATE TABLE pre_common_pluginvar (
pluginvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '插件变量id',
pluginid smallint(6) unsigned NOT NULL default '0' COMMENT '插件id',
displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',
title varchar(100) NOT NULL default COMMENT '名称',
description varchar(255) NOT NULL default COMMENT '解释说明',
variable varchar(40) NOT NULL default COMMENT '变量名',
`type` varchar(20) NOT NULL default 'text' COMMENT '类型',
`value` text NOT NULL COMMENT '值',
extra text NOT NULL COMMENT '附加',
PRIMARY KEY (pluginvarid),
KEY pluginid (pluginid)
) ENGINE=MyISAM COMMENT='插件变量表';


DROP TABLE IF EXISTS pre_forum_thread_moderate;
CREATE TABLE pre_forum_thread_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='主题审核数据表';


DROP TABLE IF EXISTS pre_forum_post_moderate;
CREATE TABLE pre_forum_post_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='帖子审核数据表';


DROP TABLE IF EXISTS pre_home_blog_moderate;
CREATE TABLE pre_home_blog_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='日志审核数据表';


DROP TABLE IF EXISTS pre_home_pic_moderate;
CREATE TABLE pre_home_pic_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='图片审核数据表';


DROP TABLE IF EXISTS pre_home_doing_moderate;
CREATE TABLE pre_home_doing_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='记录审核数据表';


DROP TABLE IF EXISTS pre_home_share_moderate;
CREATE TABLE pre_home_share_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='分享审核数据表';


DROP TABLE IF EXISTS pre_portal_article_moderate;
CREATE TABLE pre_portal_article_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='文章审核数据表';


DROP TABLE IF EXISTS pre_home_comment_moderate;
CREATE TABLE pre_home_comment_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
idtype varchar(15) NOT NULL default COMMENT 'ID类型',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY idtype (idtype, status, dateline)
) ENGINE=MyISAM COMMENT='家园评论审核数据表';


DROP TABLE IF EXISTS pre_portal_comment_moderate;
CREATE TABLE pre_portal_comment_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
idtype varchar(15) NOT NULL default COMMENT 'ID类型',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY idtype (idtype, status, dateline)
) ENGINE=MyISAM COMMENT='文章/专题评论审核数据表';


DROP TABLE IF EXISTS pre_forum_postlog;
CREATE TABLE pre_forum_postlog (
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`fid` smallint(6) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`action` char(10) NOT NULL DEFAULT ,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (pid, tid),
KEY fid (fid),
KEY uid (uid),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='漫游帖子日志';


DROP TABLE IF EXISTS pre_forum_threadlog;
CREATE TABLE pre_forum_threadlog (
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`fid` smallint(6) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`otherid` smallint(6) unsigned NOT NULL DEFAULT '0',
`action` char(10) NOT NULL,
`expiry` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (tid,fid,uid),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='漫游主题日志';


DROP TABLE IF EXISTS pre_forum_threadpreview;
CREATE TABLE pre_forum_threadpreview (
tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题ID',
relay int(10) unsigned NOT NULL default '0' COMMENT '转播次数',
content text NOT NULL COMMENT '主题内容预览',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='服务于广播';


DROP TABLE IF EXISTS pre_forum_poll;
CREATE TABLE pre_forum_poll (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
overt tinyint(1) NOT NULL default '0' COMMENT '是否公开投票参与人',
multiple tinyint(1) NOT NULL default '0' COMMENT '是否多选',
visible tinyint(1) NOT NULL default '0' COMMENT '是否投票后可见',
maxchoices tinyint(3) unsigned NOT NULL default '0' COMMENT '最大可选项数',
expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
pollpreview varchar(255) NOT NULL default COMMENT '选项内容前两项预览',
voters mediumint(8) unsigned NOT NULL default '0' COMMENT '投票人数',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='投票表';


DROP TABLE IF EXISTS pre_forum_pollvoter;
CREATE TABLE pre_forum_pollvoter (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username varchar(15) NOT NULL default COMMENT '会员名',
`options` text NOT NULL COMMENT '选项 \t 分隔',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',
KEY tid (tid),
KEY uid (uid, dateline)
) ENGINE=MyISAM COMMENT='投票用户表';

DROP TABLE IF EXISTS pre_forum_polloption;
CREATE TABLE pre_forum_polloption (
polloptionid int(10) unsigned NOT NULL auto_increment COMMENT '选项id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
votes mediumint(8) unsigned NOT NULL default '0' COMMENT '票数',
displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',
polloption varchar(80) NOT NULL default COMMENT '选项内容',
voterids mediumtext NOT NULL COMMENT '投票人id',
PRIMARY KEY (polloptionid),
KEY tid (tid,displayorder)
) ENGINE=MyISAM COMMENT='投票选项表';


DROP TABLE IF EXISTS pre_forum_post;
CREATE TABLE pre_forum_post (
pid int(10) unsigned NOT NULL COMMENT '帖子id',
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
`first` tinyint(1) NOT NULL default '0' COMMENT '是否是首贴',
author varchar(15) NOT NULL default COMMENT '作者姓名',
authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者id',
`subject` varchar(80) NOT NULL default COMMENT '标题',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',
message mediumtext NOT NULL COMMENT '消息',
useip varchar(15) NOT NULL default COMMENT '发帖者IP',
invisible tinyint(1) NOT NULL default '0' COMMENT '是否通过审核',
anonymous tinyint(1) NOT NULL default '0' COMMENT '是否匿名',
usesig tinyint(1) NOT NULL default '0' COMMENT '是否启用签名',
htmlon tinyint(1) NOT NULL default '0' COMMENT '是否允许HTML',
bbcodeoff tinyint(1) NOT NULL default '0' COMMENT '是否关闭BBCODE',
smileyoff tinyint(1) NOT NULL default '0' COMMENT '是否关闭表情',
parseurloff tinyint(1) NOT NULL default '0' COMMENT '是否允许粘贴URL',
attachment tinyint(1) NOT NULL default '0' COMMENT '附件',
rate smallint(6) NOT NULL default '0' COMMENT '评分分数',
ratetimes tinyint(3) unsigned NOT NULL default '0' COMMENT '评分次数',
`status` int(10) NOT NULL default '0' COMMENT '帖子状态',
tags varchar(255) NOT NULL default '0' COMMENT '新增字段，用于存放tag',
`comment` tinyint(1) NOT NULL default '0' COMMENT '是否存在点评',
replycredit int(10) NOT NULL default '0' COMMENT '回帖获得积分记录',
`position` int(8) unsigned NOT NULL auto_increment COMMENT '帖子位置信息',
PRIMARY KEY (tid, `position`),
KEY fid (fid),
KEY authorid (authorid,invisible),
KEY dateline (dateline),
KEY invisible (invisible),
KEY displayorder (tid,invisible,dateline),
KEY `first` (tid,`first`),
UNIQUE KEY pid (pid)
) ENGINE=MyISAM COMMENT='帖子表';

DROP TABLE IF EXISTS pre_forum_postcomment;
CREATE TABLE pre_forum_postcomment (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID',
`pid` int(10) unsigned NOT NULL default '0' COMMENT '帖子ID',
`author` varchar(15) NOT NULL default COMMENT '作者',
`authorid` mediumint(8) NOT NULL default '0' COMMENT '作者ID x1.5以后：0为游客　-1为观点',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '时间',
`comment` varchar(255) NOT NULL default COMMENT '点评内容',
`score` tinyint(1) NOT NULL default '0' COMMENT '是否包含点评观点',
`useip` varchar(15) NOT NULL default COMMENT '发帖者IP',
`rpid` int(10) unsigned NOT NULL default '0' COMMENT '关联的帖子ID',
PRIMARY KEY (`id`),
KEY `tid` (`tid`),
KEY authorid (authorid),
KEY score (score),
KEY rpid (rpid),
KEY `pid` (`pid`,`dateline`)
) ENGINE=MyISAM COMMENT='点评帖子表';


DROP TABLE IF EXISTS pre_forum_post_location;
CREATE TABLE pre_forum_post_location (
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(8) unsigned DEFAULT '0',
`uid` mediumint(8) unsigned DEFAULT '0',
`mapx` varchar(255) NOT NULL,
`mapy` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
PRIMARY KEY (`pid`),
KEY `tid` (`tid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM COMMENT='帖子地理位置表';

DROP TABLE IF EXISTS pre_forum_post_tableid;
CREATE TABLE pre_forum_post_tableid (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Post ID',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM COMMENT='post分表协调表';


DROP TABLE IF EXISTS pre_forum_poststick;
CREATE TABLE pre_forum_poststick (
`tid` mediumint(8) unsigned NOT NULL,
`pid` int(10) unsigned NOT NULL,
`position` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL,
PRIMARY KEY (`tid`,`pid`),
KEY `dateline` (`tid`,`dateline`)
) ENGINE=MyISAM COMMENT='回帖置顶表';


DROP TABLE IF EXISTS pre_forum_promotion;
CREATE TABLE pre_forum_promotion (
ip char(15) NOT NULL default COMMENT 'IP地址',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username char(15) NOT NULL default COMMENT '会员名',
PRIMARY KEY (ip)
) ENGINE=MyISAM COMMENT='论坛推广';


DROP TABLE IF EXISTS pre_forum_ratelog;
CREATE TABLE pre_forum_ratelog (
pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username char(15) NOT NULL default COMMENT '会员名',
extcredits tinyint(1) unsigned NOT NULL default '0' COMMENT '评分字段',
dateline int(10) unsigned NOT NULL default '0' COMMENT '评分时间',
score smallint(6) NOT NULL default '0' COMMENT '分数',
reason char(40) NOT NULL default COMMENT '操作理由',
KEY pid (pid,dateline),
KEY dateline (dateline),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='帖子评分记录表';


DROP TABLE IF EXISTS pre_forum_relatedthread;
CREATE TABLE pre_forum_relatedthread (
tid mediumint(8) NOT NULL default '0' COMMENT '主题id',
`type` enum('general','trade') NOT NULL default 'general' COMMENT '关键词类型',
expiration int(10) NOT NULL default '0' COMMENT '过期时间',
keywords varchar(255) NOT NULL default COMMENT '关键字',
relatedthreads text NOT NULL COMMENT '相关主题序列',
PRIMARY KEY (tid,`type`)
) ENGINE=MyISAM COMMENT='相关主题表';


DROP TABLE IF EXISTS pre_forum_rsscache;
CREATE TABLE pre_forum_rsscache (
lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后更新时间',
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',
forum char(50) NOT NULL default COMMENT '论坛名称',
author char(15) NOT NULL default COMMENT '作者',
`subject` char(80) NOT NULL default COMMENT '标题',
description char(255) NOT NULL default COMMENT '解释说明',
guidetype char(10) NOT NULL default COMMENT '导读中的类型',
UNIQUE KEY tid (tid),
KEY fid (fid,dateline)
) ENGINE=MyISAM COMMENT='rss缓存表';


DROP TABLE IF EXISTS pre_forum_replycredit;
CREATE TABLE pre_forum_replycredit (
tid mediumint(6) unsigned NOT NULL COMMENT '主题tid',
extcredits mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '单次回复奖励额度',
extcreditstype tinyint(1) NOT NULL DEFAULT '0' COMMENT '本规则下奖励积分的类型',
times smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '回复奖励次数',
membertimes smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '单个用户参与次数',
random tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户设置的回帖奖励几率',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='主题回帖获得积分规则表';


DROP TABLE IF EXISTS pre_common_searchindex;
CREATE TABLE pre_common_searchindex (
searchid int(10) unsigned NOT NULL auto_increment COMMENT '缓存id',
srchmod tinyint(3) unsigned NOT NULL COMMENT 'mod模块',
keywords varchar(255) NOT NULL default COMMENT '关键字',
searchstring text NOT NULL COMMENT '查找字符串',
useip varchar(15) NOT NULL default COMMENT '搜索人IP',
uid mediumint(10) unsigned NOT NULL default '0' COMMENT '会员id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '搜索时间',
expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
threadsortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',
num smallint(6) unsigned NOT NULL default '0' COMMENT '主题数量',
ids text NOT NULL COMMENT '主题id序列',
PRIMARY KEY (searchid),
KEY srchmod (srchmod)
) ENGINE=MyISAM COMMENT='搜索缓存表';
DROP TABLE IF EXISTS pre_common_sphinxcounter;
CREATE TABLE pre_common_sphinxcounter (
`indexid` tinyint(1) NOT NULL,
`maxid` int(10) NOT NULL,
PRIMARY KEY (`indexid`)
) ENGINE=MyISAM COMMENT='Sphinx 增量索引记录表';


DROP TABLE IF EXISTS pre_forum_spacecache;
CREATE TABLE pre_forum_spacecache (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户 uid',
variable varchar(20) NOT NULL COMMENT '缓存变量的名称',
`value` text NOT NULL COMMENT '缓存变量的值',
expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
PRIMARY KEY (uid,variable)
) ENGINE=MyISAM COMMENT='minispace缓存表';

DROP TABLE IF EXISTS pre_forum_statlog;
CREATE TABLE pre_forum_statlog (
`logdate` date NOT NULL COMMENT '日志日期',
`fid` mediumint(8) unsigned NOT NULL COMMENT '版块ID',
`type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '记录类型
`value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录值',
PRIMARY KEY (`logdate`,`fid`)
) ENGINE=MyISAM COMMENT='版块统计日志表';


DROP TABLE IF EXISTS pre_common_task;
CREATE TABLE pre_common_task (
taskid smallint(6) unsigned NOT NULL auto_increment COMMENT '任务id',
relatedtaskid smallint(6) unsigned NOT NULL default '0' COMMENT '依存任务id\n必须完成依存任务才能申请该任务',
available tinyint(1) NOT NULL default '0' COMMENT '是否启用',
`name` varchar(50) NOT NULL default COMMENT '任务名称',
description text NOT NULL COMMENT '任务描述',
icon varchar(150) NOT NULL default COMMENT '任务图标',
applicants mediumint(8) unsigned NOT NULL default '0' COMMENT '已申请任务人次',
achievers mediumint(8) unsigned NOT NULL default '0' COMMENT '已完成任务人次',
tasklimits mediumint(8) unsigned NOT NULL default '0' COMMENT '允许申请并完成该任务的人次上限',
applyperm text NOT NULL COMMENT '允许申请任务的用户组id, 格式: 1 2 3',
scriptname varchar(50) NOT NULL default COMMENT '任务脚本文件名',
starttime int(10) unsigned NOT NULL default '0' COMMENT '任务上线时间',
endtime int(10) unsigned NOT NULL default '0' COMMENT '任务下线时间',
period int(10) unsigned NOT NULL default '0' COMMENT '任务周期 单位：小时 默认为0表示一次性任务 设置为24即1天表示日常任务',
periodtype tinyint(1) NOT NULL default '0' COMMENT '任务间隔周期单位 0:小时 1:天 2:周 3:月',
reward enum('credit','magic','medal','invite','group') NOT NULL default 'credit' COMMENT '奖励类型\n(credit:积分 magic:道具 medal:勋章 invite:邀请码 group:特殊用户组)',
prize varchar(15) NOT NULL default COMMENT '奖品: 哪一个扩展积分, 道具id, 勋章id,邀请码有效期， 特殊用户组id',
bonus int(10) NOT NULL default '0' COMMENT '奖品数量/有效期: \n积分数量, 道具数量, 勋章有效期, 邀请码数量，特殊用户组有效期',
displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序',
version varchar(15) NOT NULL default COMMENT '任务脚本版本号',
PRIMARY KEY (taskid)
) ENGINE=MyISAM COMMENT='论坛任务表';


DROP TABLE IF EXISTS pre_common_taskvar;
CREATE TABLE pre_common_taskvar (
taskvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '任务变量id',
taskid smallint(6) unsigned NOT NULL default '0' COMMENT '任务id',
sort enum('apply','complete') NOT NULL default 'complete' COMMENT '变量类别\n(apply:申请任务条件 complete:完成任务条件)',
`name` varchar(100) NOT NULL default COMMENT '变量名称',
description varchar(255) NOT NULL default COMMENT '变量描述',
variable varchar(40) NOT NULL default COMMENT '变量名',
`type` varchar(20) NOT NULL default 'text' COMMENT '变量类型',
`value` text NOT NULL COMMENT '变量值',
PRIMARY KEY (taskvarid),
KEY taskid (taskid)
) ENGINE=MyISAM COMMENT='论坛任务设置表';


DROP TABLE IF EXISTS pre_forum_thread;
CREATE TABLE pre_forum_thread (
tid mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题id',
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级论坛',
posttableid smallint(6) unsigned NOT NULL default '0' COMMENT '帖子表ID',
typeid smallint(6) unsigned NOT NULL default '0' COMMENT '主题分类id',
sortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',
readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',
price smallint(6) NOT NULL default '0' COMMENT '价格',
author char(15) NOT NULL default COMMENT '会员名',
authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
`subject` char(80) NOT NULL default COMMENT '标题',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',
lastpost int(10) unsigned NOT NULL default '0' COMMENT '最后发表',
lastposter char(15) NOT NULL default COMMENT '最后发表人id',
views int(10) unsigned NOT NULL default '0' COMMENT '浏览次数',
replies mediumint(8) unsigned NOT NULL default '0' COMMENT '回复次数',
displayorder tinyint(1) NOT NULL default '0' COMMENT '显示顺序',
highlight tinyint(1) NOT NULL default '0' COMMENT '是否高亮',
digest tinyint(1) NOT NULL default '0' COMMENT '是否精华',
rate tinyint(1) NOT NULL default '0' COMMENT '是否评分',
special tinyint(1) NOT NULL default '0' COMMENT '特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关',
attachment tinyint(1) NOT NULL default '0' COMMENT '附件,0无附件 1普通附件 2有图片附件',
moderated tinyint(1) NOT NULL default '0' COMMENT '是否被管理员改动',
closed mediumint(8) unsigned NOT NULL default '0' COMMENT '是否关闭',
stickreply tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有回帖置顶',
recommends smallint(6) NOT NULL default '0' COMMENT '推荐指数',
recommend_add smallint(6) NOT NULL default '0' COMMENT '支持人数',
recommend_sub smallint(6) NOT NULL default '0' COMMENT '反对人数',
heats int(10) unsigned NOT NULL default '0' COMMENT '主题热度值',
status smallint(6) unsigned NOT NULL default '0' ,
isgroup tinyint(1) NOT NULL default '0' COMMENT '是否为群组帖子',
favtimes mediumint(8) NOT NULL default '0' COMMENT '主题收藏次数',
sharetimes mediumint(8) NOT NULL default '0' COMMENT '主题分享次数',
`stamp` tinyint(3) NOT NULL default '-1' COMMENT '主题图章',
`icon` tinyint(3) NOT NULL default '-1' COMMENT '主题图标',
pushedaid mediumint(8) NOT NULL default '0' COMMENT '被推送到的文章aid',
cover smallint(6) NOT NULL default '0' COMMENT '主题封面 负数:远程　正数:本地 0:无封面',
replycredit smallint(6) NOT NULL default '0' COMMENT '回帖奖励积分主题记录积分值',
relatebytag char(255) NOT NULL default '0' COMMENT '根据帖子标签取的相关主题id (time /t tid,...)',
maxposition int(8) unsigned NOT NULL default '0' COMMENT '最大回帖位置信息',
PRIMARY KEY (tid),
KEY digest (digest),
KEY sortid (sortid),
KEY displayorder (fid,displayorder,lastpost),
KEY typeid (fid,typeid,displayorder,lastpost),
KEY recommends (recommends),
KEY heats (heats),
KEY authorid (authorid),
KEY isgroup (isgroup, lastpost),
KEY special (special)
) ENGINE=MyISAM COMMENT='主题表';


DROP TABLE IF EXISTS pre_forum_threadaddviews;
CREATE TABLE pre_forum_threadaddviews (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
addviews int(10) unsigned NOT NULL default '0' COMMENT '浏览次数',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='主题查看数延时更新表';


DROP TABLE IF EXISTS pre_forum_threaddisablepos;
CREATE TABLE pre_forum_threaddisablepos (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
PRIMARY KEY (tid)
) ENGINE=MEMORY COMMENT='主题有楼层不准确时不使用position查询';


DROP TABLE IF EXISTS pre_forum_threadclosed;
CREATE TABLE pre_forum_threadclosed (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '对应源主题',
redirect mediumint(8) unsigned NOT NULL default '0' COMMENT '保留的指向 tid',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='主题转移后保留的指向记录';


DROP TABLE IF EXISTS pre_forum_threadmod;
CREATE TABLE pre_forum_threadmod (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username char(15) NOT NULL default COMMENT '会员名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '操作时间',
expiration int(10) unsigned NOT NULL default '0' COMMENT '有效时间',
`action` char(5) NOT NULL default COMMENT '操作',
`status` tinyint(1) NOT NULL default '0' COMMENT '状态',
magicid smallint(6) unsigned NOT NULL COMMENT '使用道具id',
`stamp` TINYINT(3) NOT NULL COMMENT '主题图章/图标 ID',
reason char(40) NOT NULL DEFAULT COMMENT '操作原因',
KEY tid (tid,dateline),
KEY expiration (expiration,`status`)
) ENGINE=MyISAM COMMENT='主题管理记录表';


DROP TABLE IF EXISTS pre_forum_threadpartake;
CREATE TABLE pre_forum_threadpartake (
tid mediumint(8) 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 '参与时间',
KEY tid (tid,uid)
) ENGINE=MyISAM COMMENT='主题参与者记录表';


DROP TABLE IF EXISTS pre_forum_threadrush;
CREATE TABLE pre_forum_threadrush (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
stopfloor mediumint(8) unsigned NOT NULL default '0' COMMENT '截止楼层',
starttimefrom int(10) unsigned NOT NULL default '0' COMMENT '开始时间',
starttimeto int(10) unsigned NOT NULL default '0' COMMENT '结束时间',
rewardfloor text NOT NULL default COMMENT '奖励楼层',
creditlimit int(10) NOT NULL default '-996' COMMENT '积分下限',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='抢楼设置表';


DROP TABLE IF EXISTS pre_forum_threadtype;
CREATE TABLE pre_forum_threadtype (
typeid smallint(6) unsigned NOT NULL auto_increment COMMENT '分类信息id',
`fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
`name` varchar(255) NOT NULL default COMMENT '名称',
description varchar(255) NOT NULL default COMMENT '解释说明',
`icon` varchar(255) NOT NULL default COMMENT '分类图标URL',
special smallint(6) NOT NULL default '0' COMMENT '分类状态',
modelid smallint(6) unsigned NOT NULL default '0' COMMENT '分类模型id',
expiration tinyint(1) NOT NULL default '0' COMMENT '分类有效期',
template text NOT NULL COMMENT '分类信息内容模板',
stemplate text NOT NULL COMMENT '分类信息主题模板',
ptemplate text NOT NULL COMMENT '分类信息发帖模板',
btemplate text NOT NULL COMMENT '分类信息模块调用模板',
PRIMARY KEY (typeid)
) ENGINE=MyISAM COMMENT='分类信息表';


DROP TABLE IF EXISTS pre_forum_trade;
CREATE TABLE pre_forum_trade (
tid mediumint(8) unsigned NOT NULL COMMENT '主题id',
pid int(10) unsigned NOT NULL COMMENT '帖子id',
typeid smallint(6) unsigned NOT NULL COMMENT '主题分类id',
sellerid mediumint(8) unsigned NOT NULL COMMENT '卖家id',
seller char(15) NOT NULL COMMENT '卖家名',
account char(50) NOT NULL COMMENT '卖家帐号',
tenpayaccount char(20) NOT NULL default COMMENT '卖家财付通账号',
`subject` char(100) NOT NULL COMMENT '标题',
price decimal(8,2) NOT NULL COMMENT '价格',
amount smallint(6) unsigned NOT NULL default '1' COMMENT '数量',
quality tinyint(1) unsigned NOT NULL default '0' COMMENT '成色',
locus char(20) NOT NULL COMMENT '所在地',
transport tinyint(1) NOT NULL default '0' COMMENT '物流方式',
ordinaryfee smallint(4) unsigned NOT NULL default '0' COMMENT '平邮附加费',
expressfee smallint(4) unsigned NOT NULL default '0' COMMENT '快递附加费',
emsfee smallint(4) unsigned NOT NULL default '0' COMMENT 'EMS附加费',
itemtype tinyint(1) NOT NULL default '0' COMMENT '商品类型',
dateline int(10) unsigned NOT NULL default '0' COMMENT '交易时间',
expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
lastbuyer char(15) NOT NULL COMMENT '最后买家用户名',
lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后交易时间',
totalitems smallint(5) unsigned NOT NULL default '0' COMMENT '总交易量',
tradesum decimal(8,2) NOT NULL default '0.00' COMMENT '总交易额',
closed tinyint(1) NOT NULL default '0' COMMENT '是否关闭',
aid mediumint(8) unsigned NOT NULL COMMENT '商品图片的 Aid',
displayorder tinyint(1) NOT NULL COMMENT '显示顺序',
costprice decimal(8,2) NOT NULL COMMENT '商品原价',
credit int(10) unsigned NOT NULL default '0' COMMENT '积分价格',
costcredit int(10) unsigned NOT NULL default '0' COMMENT '积分原价',
credittradesum int(10) unsigned NOT NULL default '0' COMMENT '总积分交易额',
PRIMARY KEY (tid,pid),
KEY pid (pid),
KEY sellerid (sellerid),
KEY totalitems (totalitems),
KEY tradesum (tradesum),
KEY displayorder (tid,displayorder),
KEY sellertrades (sellerid,tradesum,totalitems),
KEY typeid (typeid),
KEY credittradesum (credittradesum),
KEY expiration (expiration)
) ENGINE=MyISAM COMMENT='商品数据表';

DROP TABLE IF EXISTS pre_forum_threadclass;
CREATE TABLE pre_forum_threadclass (
`typeid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
`fid` mediumint(8) unsigned NOT NULL COMMENT '所属版块ID',
`name` varchar(255) NOT NULL COMMENT '分类名称',
`displayorder` mediumint(9) NOT NULL COMMENT '显示顺序',
`icon` varchar(255) NOT NULL COMMENT '分类图标URL',
`moderators` tinyint(1) NOT NULL default '0' COMMENT '仅管理者可用',
PRIMARY KEY (`typeid`),
KEY fid (fid, displayorder)
) ENGINE=MyISAM COMMENT='主题分类表';


DROP TABLE IF EXISTS pre_forum_tradecomment;
CREATE TABLE pre_forum_tradecomment (
id mediumint(8) NOT NULL auto_increment COMMENT 'id',
orderid char(32) NOT NULL COMMENT '订单 id',
pid int(10) unsigned NOT NULL COMMENT '帖子 id',
`type` tinyint(1) NOT NULL COMMENT '类型',
raterid mediumint(8) unsigned NOT NULL COMMENT '评价方会员id',
rater char(15) NOT NULL COMMENT '评价方用户名',
rateeid mediumint(8) unsigned NOT NULL COMMENT '被评价方会员id',
ratee char(15) NOT NULL COMMENT '被评价方用户名',
message char(200) NOT NULL COMMENT '评价内容',
explanation char(200) NOT NULL COMMENT '解释',
score tinyint(1) NOT NULL COMMENT '评分',
dateline int(10) unsigned NOT NULL COMMENT '评价时间',
PRIMARY KEY (id),
KEY raterid (raterid,`type`,dateline),
KEY rateeid (rateeid,`type`,dateline),
KEY orderid (orderid)
) ENGINE=MyISAM COMMENT='信用评价';


DROP TABLE IF EXISTS pre_forum_tradelog;
CREATE TABLE pre_forum_tradelog (
tid mediumint(8) unsigned NOT NULL COMMENT '主题id',
pid int(10) unsigned NOT NULL COMMENT '帖子id',
orderid varchar(32) NOT NULL COMMENT '订单号id',
tradeno varchar(32) NOT NULL COMMENT '支付宝订单号',
paytype tinyint(1) unsigned NOT NULL default '0' COMMENT '在线支付方式',
`subject` varchar(100) NOT NULL COMMENT '标题',
price decimal(8,2) NOT NULL default '0.00' COMMENT '价格',
quality tinyint(1) unsigned NOT NULL default '0' COMMENT '成色',
itemtype tinyint(1) NOT NULL default '0' COMMENT '商品类型',
number smallint(5) unsigned NOT NULL default '0' COMMENT '数量',
tax decimal(6,2) unsigned NOT NULL default '0.00' COMMENT '交易手续费',
locus varchar(100) NOT NULL COMMENT '物品所在地',
sellerid mediumint(8) unsigned NOT NULL COMMENT '卖家id',
seller varchar(15) NOT NULL COMMENT '卖家名',
selleraccount varchar(50) NOT NULL COMMENT '卖家交易帐号',
tenpayaccount varchar(20) NOT NULL default '0' COMMENT '卖家财付通账号',
buyerid mediumint(8) unsigned NOT NULL COMMENT '买家id',
buyer varchar(15) NOT NULL COMMENT '买家名',
buyercontact varchar(50) NOT NULL COMMENT '买家联系方式',
buyercredits smallint(5) unsigned NOT NULL default '0' COMMENT '买家暂扣积分',
buyermsg varchar(200) default NULL COMMENT '买家留言',
`status` tinyint(1) NOT NULL default '0' COMMENT '状态',
lastupdate int(10) unsigned NOT NULL default '0' COMMENT '状态最后更新',
offline tinyint(1) NOT NULL default '0' COMMENT '是否离线交易',
buyername varchar(50) NOT NULL COMMENT '买家姓名',
buyerzip varchar(10) NOT NULL COMMENT '买家邮编',
buyerphone varchar(20) NOT NULL COMMENT '买家电话',
buyermobile varchar(20) NOT NULL COMMENT '买家手机',
transport tinyint(1) NOT NULL default '0' COMMENT '运输方式',
transportfee smallint(6) unsigned NOT NULL default '0' COMMENT '运输费用',
baseprice decimal(8,2) NOT NULL COMMENT '商品原价',
discount tinyint(1) NOT NULL default '0' COMMENT '折扣',
ratestatus tinyint(1) NOT NULL default '0' COMMENT '评价状态',
message text NOT NULL COMMENT '订单留言',
credit int(10) unsigned NOT NULL default '0' COMMENT '积分价格',
basecredit int(10) unsigned NOT NULL default '0' COMMENT '积分原价',
UNIQUE KEY orderid (orderid),
KEY sellerid (sellerid),
KEY buyerid (buyerid),
KEY `status` (`status`),
KEY buyerlog (buyerid,`status`,lastupdate),
KEY sellerlog (sellerid,`status`,lastupdate),
KEY tid (tid,pid),
KEY pid (pid)
) ENGINE=MyISAM COMMENT='交易记录表';


DROP TABLE IF EXISTS pre_forum_typeoption;
CREATE TABLE pre_forum_typeoption (
optionid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类信息项目ID',
classid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '分类信息上级项目ID',
displayorder tinyint(3) NOT NULL DEFAULT '0' COMMENT '分类信息排序',
expiration tinyint(1) NOT NULL COMMENT '分类信息项目是否受有效期限制',
protect varchar(255) NOT NULL COMMENT '分类信息项目是否是保护项目',
title varchar(255) NOT NULL DEFAULT COMMENT '分类信息项目标题',
description varchar(255) NOT NULL DEFAULT COMMENT '分类信息项目描述',
identifier varchar(255) NOT NULL DEFAULT COMMENT '分类信息项目标识',
`type` varchar(255) NOT NULL DEFAULT COMMENT '分类信息项目类型',
unit varchar(255) NOT NULL COMMENT '分类信息项目单位',
rules mediumtext NOT NULL COMMENT '分类信息项目规则',
permprompt mediumtext NOT NULL COMMENT '分类信息项目权限提示',
PRIMARY KEY (optionid),
KEY classid (classid)
) ENGINE=MyISAM COMMENT='分类信息设置项目表';


DROP TABLE IF EXISTS pre_forum_typeoptionvar;
CREATE TABLE pre_forum_typeoptionvar (
sortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类信息数据对应帖子id',
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类信息数据对应帖子板块id',
optionid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息数据对应选项id',
expiration int(10) unsigned NOT NULL default '0' COMMENT '分类信息数据有效期',
`value` mediumtext NOT NULL COMMENT '分类信息数据数值',
KEY sortid (sortid),
KEY tid (tid),
KEY fid (fid)
) ENGINE=MyISAM COMMENT='分类信息项目数据表';


DROP TABLE IF EXISTS pre_forum_typevar;
CREATE TABLE pre_forum_typevar (
sortid smallint(6) NOT NULL default '0' COMMENT '分类信息id',
optionid smallint(6) NOT NULL default '0' COMMENT '分类信息对应项目id',
available tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可用',
required tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否必填',
unchangeable tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可修改',
search tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可搜索',
displayorder tinyint(3) NOT NULL default '0' COMMENT '分类信息对应项目顺序',
subjectshow TINYINT(1) NOT NULL DEFAULT '0',
UNIQUE KEY optionid (sortid,optionid),
KEY sortid (sortid)
) ENGINE=MyISAM COMMENT='分类信息对应项目表';


DROP TABLE IF EXISTS pre_forum_warning;
CREATE TABLE pre_forum_warning (
wid smallint(6) unsigned NOT NULL auto_increment COMMENT '记录id',
pid int(10) unsigned NOT NULL COMMENT '帖子 pid',
operatorid mediumint(8) unsigned NOT NULL COMMENT '警告者 Uid',
operator char(15) NOT NULL COMMENT '警告者用户名',
authorid mediumint(8) unsigned NOT NULL COMMENT '被警告者 uid',
author char(15) NOT NULL COMMENT '被警告者用户名',
dateline int(10) unsigned NOT NULL COMMENT '警告时间',
reason char(40) NOT NULL COMMENT '警告原因',
PRIMARY KEY (wid),
UNIQUE KEY pid (pid),
KEY authorid (authorid)
) ENGINE=MyISAM COMMENT='警告记录表';


DROP TABLE IF EXISTS pre_home_album;
CREATE TABLE pre_home_album (
albumid mediumint(8) unsigned NOT NULL auto_increment COMMENT '相册ID ',
albumname varchar(50) NOT NULL default COMMENT '相册名字',
catid smallint(6) unsigned NOT NULL default '0' COMMENT '相册系统分类',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '相册用户ID ',
username varchar(15) NOT NULL default COMMENT '相册用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '相册建立时间戳',
updatetime int(10) unsigned NOT NULL default '0' COMMENT '相册最后修改时间戳',
picnum smallint(6) unsigned NOT NULL default '0' COMMENT '相册照片数量',
pic varchar(60) NOT NULL default COMMENT '相册封面照片',
picflag tinyint(1) NOT NULL default '0' COMMENT '相册是否有图片',
friend tinyint(1) NOT NULL default '0' COMMENT '相册隐私设置:"0"全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 ',
`password` varchar(10) NOT NULL default COMMENT '相册密码',
target_ids text NOT NULL COMMENT '允许查看相册的用户ID,多个用户ID用"m"间隔 ',
favtimes mediumint(8) unsigned NOT NULL COMMENT '相册收藏次数',
sharetimes mediumint(8) unsigned NOT NULL COMMENT '相册分享次数',
depict text NOT NULL COMMENT '相册描述 ',
PRIMARY KEY (albumid),
KEY uid (uid,updatetime),
KEY updatetime (updatetime)
) ENGINE=MyISAM COMMENT='相册表';


DROP TABLE IF EXISTS pre_home_appcreditlog;
CREATE TABLE pre_home_appcreditlog (
logid mediumint(8) unsigned NOT NULL auto_increment COMMENT '序列id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户id',
appid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户名',
appname varchar(60) NOT NULL default COMMENT '应用名称',
`type` tinyint(1) NOT NULL default '0' COMMENT '积分转入转出类型',
credit mediumint(8) unsigned NOT NULL default '0' COMMENT '积分数',
note text NOT NULL COMMENT '备注',
dateline int(10) unsigned NOT NULL default '0' COMMENT '操作时间',
PRIMARY KEY (logid),
KEY uid (uid,dateline),
KEY appid (appid)
) ENGINE=MyISAM COMMENT='漫游应用积分操作记录表';


DROP TABLE IF EXISTS pre_home_blacklist;
CREATE TABLE pre_home_blacklist (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',
buid mediumint(8) unsigned NOT NULL default '0' COMMENT '被屏蔽的用户ID ',
dateline int(10) unsigned NOT NULL default '0' COMMENT '被屏蔽的时间戳',
PRIMARY KEY (uid,buid),
KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT='屏蔽黑名单表';


DROP TABLE IF EXISTS pre_common_block;
CREATE TABLE pre_common_block (
bid mediumint(8) unsigned NOT NULL auto_increment COMMENT '模块ID',
blockclass varchar(255) NOT NULL default '0' COMMENT '模块分类 article/pic/member/board/poll',
blocktype tinyint(1) NOT NULL default '0' COMMENT '调用类型 0为模板调用 1为js调用',
`name` varchar(255) NOT NULL default COMMENT '模块标名称',
title text NOT NULL COMMENT '模块标题名',
classname varchar(255) NOT NULL default COMMENT '指定样式class',
summary text NOT NULL COMMENT '模块自定义内容',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '创建者用户ID ',
username varchar(255) NOT NULL default COMMENT '创建者用户名',
styleid smallint(6) unsigned NOT NULL default '0' COMMENT '模块风格ID',
blockstyle text NOT NULL COMMENT '自定义风格',
picwidth smallint(6) unsigned NOT NULL default '0' COMMENT '显示图片长度',
picheight smallint(6) unsigned NOT NULL default '0' COMMENT '显示图片宽度',
target varchar(255) NOT NULL default COMMENT '模块链接打开方式: _blank, _self, _top',
dateformat varchar(255) NOT NULL default COMMENT '时间格式： H:i； u； Y-m-d等',
dateuformat tinyint(1) NOT NULL default '0' COMMENT '是否使用个性化时间格式',
script varchar(255) NOT NULL default COMMENT '模块获取数据脚本名',
param text NOT NULL COMMENT '模块参数配置序列化存储',
shownum smallint(6) unsigned NOT NULL default '0' COMMENT '获取数据数目',
cachetime int(10) NOT NULL default '0' COMMENT '模块缓存更新时间间隔',
cachetimerange char(5) NOT NULL default COMMENT '模块缓存更新时间区间',
punctualupdate tinyint(1) NOT NULL default '0' COMMENT '是否严格按照缓存时间更新（忽略优化）',
hidedisplay tinyint(1) NOT NULL default '0' COMMENT '是否屏蔽输出',
dateline int(10) unsigned NOT NULL default '0' COMMENT '模块缓存创建时间戳',
notinherited tinyint(1) NOT NULL default '0' COMMENT '是否继承所在页面权限',
isblank tinyint(1) NOT NULL default '0' COMMENT '是否为空白模块，只显示准送数据',
PRIMARY KEY (bid)
) ENGINE=MyISAM COMMENT='模块表';


DROP TABLE IF EXISTS pre_common_block_style;
CREATE TABLE pre_common_block_style (
styleid smallint(6) unsigned NOT NULL auto_increment COMMENT '模块样式ID',
blockclass varchar(255) NOT NULL default COMMENT '模块分类',
`name` varchar(255) NOT NULL default COMMENT '样式名称',
template text NOT NULL COMMENT '样式模板',
`hash` varchar(255) NOT NULL default COMMENT '样式hash（blockclass + template）',
getpic tinyint(1) NOT NULL default '0' COMMENT '是否需要获取pic数据',
getsummary tinyint(1) NOT NULL default '0' COMMENT '是否需要获取summary数据',
makethumb tinyint(1) NOT NULL default '0' COMMENT '是否需要block设置缩略图',
settarget tinyint(1) NOT NULL default '0' COMMENT '是否需要设置链接打开方式',
`fields` text NOT NULL COMMENT '模板中用到的模块分类字段',
moreurl tinyint(1) NOT NULL default '0' COMMENT '是否有更多链接',
PRIMARY KEY (styleid),
KEY `hash` (`hash`),
KEY `blockclass` (`blockclass`)
) ENGINE=MyISAM COMMENT='模块模板表';


DROP TABLE IF EXISTS pre_common_block_item;
CREATE TABLE pre_common_block_item (
itemid int(10) unsigned NOT NULL auto_increment COMMENT '信息ID',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',
id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',
idtype varchar(255) NOT NULL default COMMENT '来源ID TYPE，手工添加数据为rand',
itemtype tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为自动 1为手工输入 2已编辑',
title varchar(255) NOT NULL default COMMENT '信息标题名',
url varchar(255) NOT NULL default COMMENT '信息链接地址',
pic varchar(255) NOT NULL default COMMENT '信息图片',
picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',
makethumb tinyint(1) NOT NULL default '0' COMMENT '是否已生成缩略图 1:生成成功; 2:生成失败',
thumbpath varchar(255) NOT NULL default COMMENT '缩略图地址',
summary text NOT NULL COMMENT '信息摘要',
showstyle text NOT NULL COMMENT '显示样式',
related text NOT NULL COMMENT '相关链接',
`fields` text NOT NULL COMMENT '信息附属num/author/authorid/dateline',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
startdate int(10) unsigned NOT NULL default '0' COMMENT '开始时间戳',
enddate int(10) unsigned NOT NULL default '0' COMMENT '结束时间戳',
PRIMARY KEY (itemid),
KEY bid (bid)
) ENGINE=MyISAM COMMENT='模块数据表';


DROP TABLE IF EXISTS pre_common_block_pic;
CREATE TABLE pre_common_block_pic (
picid int(10) unsigned NOT NULL auto_increment COMMENT '图片ID',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',
itemid int(10) unsigned NOT NULL default '0' COMMENT '信息ID',
pic varchar(255) NOT NULL default COMMENT '信息图片',
picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为本地 1为ftp远程',
`type` tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为模块缩略图 1为上传的图',
PRIMARY KEY (picid),
KEY bid (bid,itemid)
) ENGINE=MyISAM COMMENT='模块使用图片表';

DROP TABLE IF EXISTS pre_common_block_item_data;
CREATE TABLE pre_common_block_item_data (
dataid int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '推荐信息ID',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',
id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',
idtype varchar(255) NOT NULL default COMMENT '来源ID TYPE',
itemtype tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为自动 1为手工输入 3推荐数据',
title varchar(255) NOT NULL default COMMENT '信息标题名',
url varchar(255) NOT NULL default COMMENT '信息链接地址',
pic varchar(255) NOT NULL default COMMENT '信息图片',
picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',
makethumb tinyint(1) NOT NULL default '0' COMMENT '是否已生成缩略图',
summary text NOT NULL COMMENT '信息摘要',
showstyle text NOT NULL COMMENT '显示样式',
related text NOT NULL COMMENT '相关链接',
`fields` text NOT NULL COMMENT '信息附属num/author/authorid/dateline',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
startdate int(10) unsigned NOT NULL default '0' COMMENT '开始时间戳',
enddate int(10) unsigned NOT NULL default '0' COMMENT '结束时间戳',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '推荐者 UID',
username varchar(255) NOT NULL DEFAULT COMMENT '推荐者用户名',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推荐日期',
isverified tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已通过审核',
verifiedtime int(10) unsigned NOT NULL DEFAULT '0' COMMENT '通过审核日期',
stickgrade tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '置顶等级： 0～10',
PRIMARY KEY (dataid),
KEY bid (bid, stickgrade, verifiedtime)
) ENGINE=MyISAM COMMENT='模块推荐信息表';