Discuz! X2.5数据字典

出自Discuz! 技术文库

根据以下的原因，您无权限进行编辑这个页面操作：

您可以查看并复制此页面的源代码：

DROP TABLE IF EXISTS pre_common_admincp_cmenu;<br>CREATE TABLE pre_common_admincp_cmenu (<br> `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,<br> `title` VARCHAR(255) NOT NULL COMMENT '菜单名称',<br> `url` VARCHAR(255) NOT NULL COMMENT '菜单地址',<br> `sort` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '菜单类型,备用',<br> `displayorder` TINYINT(3) NOT NULL COMMENT '显示顺序',<br> `clicks` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1' COMMENT '点击数,备用',<br> `uid` MEDIUMINT(8) UNSIGNED NOT NULL COMMENT '添加用户',<br> `dateline` INT(10) UNSIGNED NOT NULL COMMENT '添加时间',<br> PRIMARY KEY (`id`),<br> KEY `uid` (`uid`),<br> KEY `displayorder` (`displayorder`)<br>) ENGINE=MYISAM COMMENT='后台菜单收藏表'; <br>DROP TABLE IF EXISTS pre_common_admingroup;<br>CREATE TABLE pre_common_admingroup (<br> admingid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '所属管理员分组ID',<br> alloweditpost tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑帖子',<br> alloweditpoll tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑投票',<br> allowstickthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许置顶主题',<br> allowmodpost tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许审核帖子',<br> allowdelpost tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许删除帖子',<br> allowmassprune tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许批量删帖',<br> allowrefund tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许强制退款',<br> allowcensorword tinyint(1) NOT NULL DEFAULT '0' COMMENT '兼容性字段',<br> allowviewip tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许查看IP',<br> allowbanip tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许禁止IP',<br> allowedituser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑用户',<br> allowmoduser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许审核用户',<br> allowbanuser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许禁止用户发言',<br> allowbanvisituser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许禁止用户访问',<br> allowpostannounce tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许发布站点公告',<br> allowviewlog tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许查看管理日志',<br> allowbanpost tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许屏蔽帖子',<br> supe_allowpushthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '兼容性字段',<br> allowhighlightthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许高亮主题',<br> allowdigestthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许精华主题',<br> allowrecommendthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许推荐主题',<br> allowbumpthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许提升主题',<br> allowclosethread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许关闭主题',<br> allowmovethread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许移动主题',<br> allowedittypethread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑主题分类',<br> allowstampthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许添加主题图章',<br> allowstamplist tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许添加主题图标',<br> allowcopythread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许复制主题',<br> allowmergethread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许合并主题',<br> allowsplitthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许分割主题',<br> allowrepairthread tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许修复主题',<br> allowwarnpost tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许警告帖子',<br> allowviewreport tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许查看用户报告',<br> alloweditforum tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑版块',<br> allowremovereward tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许移除悬赏',<br> allowedittrade tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑商品',<br> alloweditactivity tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理活动报名者',<br> allowstickreply tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许置顶回帖',<br> allowmanagearticle tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理所有文章',<br> allowaddtopic tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许创建专题',<br> allowmanagetopic tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理专题',<br> allowdiy tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许DIY',<br> allowclearrecycle tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许删除回收站的帖子',<br> allowmanagetag tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理标签',<br> alloweditusertag tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理用户标签',<br> managefeed tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理动态(feed)',<br> managedoing tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理记录',<br> manageshare tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理分享',<br> manageblog tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理日志',<br> managealbum tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理相册',<br> managecomment tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理评论',<br> managemagiclog tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理道具记录',<br> managereport tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理举报',<br> managehotuser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理推荐成员',<br> managedefaultuser tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理推荐好友',<br> managevideophoto tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理视频认证',<br> managemagic tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理道具',<br> manageclick tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理表态动作',<br> allowmanagecollection tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许管理淘专辑',<br> PRIMARY KEY (admingid)<br>) ENGINE=MyISAM COMMENT='管理组表';<br> <br>DROP TABLE IF EXISTS pre_common_adminnote;<br>CREATE TABLE pre_common_adminnote (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '后台留言id',<br> admin varchar(15) NOT NULL default ''COMMENT '管理员姓名',<br> access tinyint(3) NOT NULL default '0' COMMENT '哪组可以看到信息',<br> adminid tinyint(3) NOT NULL default '0' COMMENT '管理员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> message text NOT NULL COMMENT '消息',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='后台留言表';'' <br>DROP TABLE IF EXISTS pre_common_advertisement;<br>CREATE TABLE pre_common_advertisement (<br> advid mediumint(8) unsigned NOT NULL auto_increment COMMENT '广告id',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> `type` varchar(50) NOT NULL default '0' COMMENT '类型',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> title varchar(255) NOT NULL default ''COMMENT '广告标题',<br> targets text NOT NULL COMMENT '投放范围',<br> parameters text NOT NULL COMMENT '参数\n序列化存放的数组数据',<br> `code` text NOT NULL COMMENT '代码',<br> starttime int(10) unsigned NOT NULL default '0' COMMENT '开始时间',<br> endtime int(10) unsigned NOT NULL default '0' COMMENT '结束时间',<br> PRIMARY KEY (advid)<br>) ENGINE=MyISAM COMMENT='广告数据表';'' <br>DROP TABLE IF EXISTS pre_common_advertisement_custom;<br>CREATE TABLE pre_common_advertisement_custom (<br> `id` smallint(5) unsigned NOT NULL auto_increment COMMENT '自定义广告类型id',<br> `name` varchar(255) NOT NULL COMMENT '名称',<br> PRIMARY KEY (`id`),<br> KEY `name` (`name`)<br>) ENGINE=MyISAM COMMENT='自定义广告数据表'; <br>DROP TABLE IF EXISTS pre_common_banned;<br>CREATE TABLE pre_common_banned (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '禁止id',<br> ip1 smallint(3) NOT NULL default '0' COMMENT 'IP分段1',<br> ip2 smallint(3) NOT NULL default '0' COMMENT 'IP分段2',<br> ip3 smallint(3) NOT NULL default '0' COMMENT 'IP分段3',<br> ip4 smallint(3) NOT NULL default '0' COMMENT 'IP分段4',<br> admin varchar(15) NOT NULL default ''COMMENT '管理员姓名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '禁止时间',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='禁止访问表';'' <br>DROP TABLE IF EXISTS pre_common_cache;<br>CREATE TABLE pre_common_cache (<br> cachekey varchar(255) NOT NULL default '',<br> cachevalue mediumblob NOT NULL,<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (cachekey)<br>) ENGINE=MyISAM COMMENT='通用缓存表';'' <br>DROP TABLE IF EXISTS pre_common_card;<br>CREATE TABLE pre_common_card (<br> id char(255) NOT NULL default ''COMMENT '生成的卡片号码',<br> typeid smallint(6) unsigned NOT NULL default '1' COMMENT '卡片分类',<br> maketype tinyint(1) NOT NULL default '0' COMMENT '卡片生成的方法',<br> makeruid mediumint(8) unsigned NOT NULL default '0' COMMENT '卡片生成者uid',<br> `price` mediumint(8) unsigned NOT NULL default '0' COMMENT '卡片面值',<br> `extcreditskey` tinyint(1) NOT NULL default '0' COMMENT '充值积分种类',<br> `extcreditsval` int(10) NOT NULL default '0' COMMENT '积分数额',<br> `status` tinyint(1) unsigned NOT NULL default '1' COMMENT '卡片状态(位与):1:可用,2:已用',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '卡片生成时间',<br> cleardateline int(10) unsigned NOT NULL default '0' COMMENT '卡片清理时间',<br> useddateline int(10) unsigned NOT NULL default '0' COMMENT '使用时间',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '使用者',<br> PRIMARY KEY (id),<br> KEY `dateline` (`dateline`)<br>) ENGINE=MyISAM COMMENT='充值卡密表';'' <br>DROP TABLE IF EXISTS pre_common_card_log;<br>CREATE TABLE pre_common_card_log (<br> id smallint(6) NOT NULL auto_increment COMMENT '生成的卡片号码',<br> `uid` mediumint(8) NOT NULL default '0' COMMENT '卡片生成者',<br> `username` varchar(20) NOT NULL default ''COMMENT '卡片生成者',<br> cardrule varchar(255) NOT NULL default '' COMMENT '卡片生成规则',<br> `info` text NOT NULL COMMENT '卡片生成log',<br> dateline INT(10) unsigned NOT NULL default '0' COMMENT '本次log生成时间',<br> description mediumtext NOT NULL COMMENT '卡片描述',<br> operation tinyint(1) NOT NULL default '0' COMMENT '操作动作(位与):1:生成,2:任务生成,4:删除,9:卡片过期',<br> PRIMARY KEY (id),<br> KEY `dateline` (`dateline`),<br> KEY `operation_dateline` (`operation`, `dateline`)<br>) ENGINE=MyISAM COMMENT='充值卡密表'; <br>DROP TABLE IF EXISTS pre_common_card_type;<br>CREATE TABLE pre_common_card_type (<br> id smallint(6) NOT NULL auto_increment COMMENT '卡片分类ID',<br> typename char(20) NOT NULL default ''COMMENT '分类名称',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='卡片分类表';'' DROP TABLE IF EXISTS pre_common_credit_log;<br>CREATE TABLE pre_common_credit_log (<br> `uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '所属用户uid',<br> `operation` char(3) NOT NULL default ''COMMENT '操作类型',<br> `relatedid` int(10) unsigned NOT NULL COMMENT '操作相关ID',<br> `dateline` int(10) unsigned NOT NULL COMMENT '记录时间',<br> `extcredits1` int(10) NOT NULL COMMENT '积分1变化值',<br> `extcredits2` int(10) NOT NULL COMMENT '积分2变化值',<br> `extcredits3` int(10) NOT NULL COMMENT '积分3变化值',<br> `extcredits4` int(10) NOT NULL COMMENT '积分4变化值',<br> `extcredits5` int(10) NOT NULL COMMENT '积分5变化值',<br> `extcredits6` int(10) NOT NULL COMMENT '积分6变化值',<br> `extcredits7` int(10) NOT NULL COMMENT '积分7变化值',<br> `extcredits8` int(10) NOT NULL COMMENT '积分8变化值',<br> KEY `uid` (`uid`),<br> KEY `operation` (`operation`),<br> KEY `relatedid` (`relatedid`),<br> KEY `dateline` (`dateline`)<br>) ENGINE=MyISAM COMMENT='积分日志表';'' <br>DROP TABLE IF EXISTS pre_common_credit_rule_log;<br>CREATE TABLE pre_common_credit_rule_log (<br> clid mediumint(8) unsigned NOT NULL auto_increment COMMENT '策略日志ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '策略日志所有者uid',<br> rid mediumint(8) unsigned NOT NULL default '0' COMMENT '策略ID',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '版块ID',<br> total mediumint(8) unsigned NOT NULL default '0' COMMENT '策略被执行总次数',<br> cyclenum mediumint(8) unsigned NOT NULL default '0' COMMENT '周期被执行次数',<br> extcredits1 int(10) NOT NULL default '0' COMMENT '扩展1',<br> extcredits2 int(10) NOT NULL default '0' COMMENT '扩展2',<br> extcredits3 int(10) NOT NULL default '0' COMMENT '扩展3',<br> extcredits4 int(10) NOT NULL default '0' COMMENT '扩展4',<br> extcredits5 int(10) NOT NULL default '0' COMMENT '扩展5',<br> extcredits6 int(10) NOT NULL default '0' COMMENT '扩展6',<br> extcredits7 int(10) NOT NULL default '0' COMMENT '扩展7',<br> extcredits8 int(10) NOT NULL default '0' COMMENT '扩展8',<br> starttime int(10) unsigned NOT NULL default '0' COMMENT '周期开始时间',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '策略最后执行时间',<br> PRIMARY KEY (clid),<br> KEY uid (uid,rid, fid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='积分规则日志表'; <br>DROP TABLE IF EXISTS pre_common_credit_rule_log_field;<br>CREATE TABLE pre_common_credit_rule_log_field (<br> clid mediumint(8) unsigned NOT NULL default '0' COMMENT '策略日志ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '策略日志所有者uid',<br> info text NOT NULL COMMENT '记录信息防重',<br> `user` text NOT NULL COMMENT '记录用户防重',<br> app text NOT NULL COMMENT '记录应用防重',<br> PRIMARY KEY (uid, clid)<br>) ENGINE=MyISAM COMMENT='积分规则日志扩展表'; <br>DROP TABLE IF EXISTS pre_common_credit_rule;<br>CREATE TABLE pre_common_credit_rule (<br> rid mediumint(8) unsigned NOT NULL auto_increment COMMENT '规则ID',<br> rulename varchar(20) NOT NULL default ''COMMENT '规则名称',<br> `action` varchar(20) NOT NULL default '' COMMENT '规则action唯一KEY',<br> cycletype tinyint(1) NOT NULL default '0' COMMENT '奖励周期0:一次;1:每天;2:整点;3:间隔分钟;4:不限;',<br> cycletime int(10) NOT NULL default '0' COMMENT '间隔时间',<br> rewardnum tinyint(2) NOT NULL default '1' COMMENT '奖励次数',<br> norepeat tinyint(1) NOT NULL default '0' COMMENT '是否去重1：去重;0：不去重',<br> extcredits1 int(10) NOT NULL default '0' COMMENT '扩展1',<br> extcredits2 int(10) NOT NULL default '0' COMMENT '扩展2',<br> extcredits3 int(10) NOT NULL default '0' COMMENT '扩展3',<br> extcredits4 int(10) NOT NULL default '0' COMMENT '扩展4',<br> extcredits5 int(10) NOT NULL default '0' COMMENT '扩展5',<br> extcredits6 int(10) NOT NULL default '0' COMMENT '扩展6',<br> extcredits7 int(10) NOT NULL default '0' COMMENT '扩展7',<br> extcredits8 int(10) NOT NULL default '0' COMMENT '扩展8',<br> fids text NOT NULL COMMENT '记录自定义策略版块ID',<br> PRIMARY KEY (rid),<br> UNIQUE KEY `action` (`action`)<br>) ENGINE=MyISAM COMMENT='积分规则表'; <br>DROP TABLE IF EXISTS pre_common_cron;<br>CREATE TABLE pre_common_cron (<br> cronid smallint(6) unsigned NOT NULL auto_increment COMMENT '计划任务id',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> `type` enum('user','system') NOT NULL default 'user' COMMENT '类型',<br> `name` char(50) NOT NULL default ''COMMENT '名称',<br> filename char(50) NOT NULL default '' COMMENT '对应文件',<br> lastrun int(10) unsigned NOT NULL default '0' COMMENT '上次执行时间',<br> nextrun int(10) unsigned NOT NULL default '0' COMMENT '下次执行时间',<br> weekday tinyint(1) NOT NULL default '0' COMMENT '周计划',<br> `day` tinyint(2) NOT NULL default '0' COMMENT '日计划',<br> `hour` tinyint(2) NOT NULL default '0' COMMENT '小时计划',<br> `minute` char(36) NOT NULL default ''COMMENT '分计划',<br> PRIMARY KEY (cronid),<br> KEY nextrun (available,nextrun)<br>) ENGINE=MyISAM COMMENT='计划任务表';'' <br>DROP TABLE IF EXISTS pre_common_domain;<br>CREATE TABLE pre_common_domain (<br> domain char(30) NOT NULL default ''COMMENT '域名前缀',<br> domainroot char(60) NOT NULL default '' COMMENT '二级域名后缀',<br> id mediumint(8) unsigned NOT NULL default '0' COMMENT '对应对象id',<br> idtype char(15) NOT NULL default ''COMMENT '对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道',<br> PRIMARY KEY (id, idtype),<br> KEY domain (domain, domainroot),<br> KEY idtype (idtype)<br>) ENGINE=MyISAM COMMENT='二级域名表';'' <br>DROP TABLE IF EXISTS pre_common_failedlogin;<br>CREATE TABLE pre_common_failedlogin (<br> ip char(15) NOT NULL default ''COMMENT '失败IP',<br> username char(32) NOT NULL default '' COMMENT '失败时的用户名',<br> count tinyint(1) unsigned NOT NULL default '0' COMMENT '尝试次数',<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后一次尝试时间',<br> PRIMARY KEY (ip,username)<br>) ENGINE=MyISAM COMMENT='失败登录表'; <br>DROP TABLE IF EXISTS pre_common_friendlink;<br>CREATE TABLE pre_common_friendlink (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT 'id',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序，正序',<br> `name` varchar(100) NOT NULL default ''COMMENT '名称',<br> url varchar(255) NOT NULL default '' COMMENT 'url',<br> description mediumtext NOT NULL COMMENT '解释说明',<br> logo varchar(255) NOT NULL default ''COMMENT 'logo',<br> `type` tinyint(3) NOT NULL default '0',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='友情链接表';'' <br>DROP TABLE IF EXISTS pre_common_relatedlink;<br>CREATE TABLE pre_common_relatedlink (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT 'id',<br> `name` varchar(100) NOT NULL default ''COMMENT '名称',<br> url varchar(255) NOT NULL default '' COMMENT 'url',<br> `extent` tinyint(3) NOT NULL default '0',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='关联链接表'; <br>DROP TABLE IF EXISTS pre_common_invite;<br>CREATE TABLE pre_common_invite (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT 'ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '邀请人',<br> `code` char(20) NOT NULL default ''COMMENT '邀请码',<br> fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '受邀人UID',<br> fusername char(20) NOT NULL default '' COMMENT '受邀人姓名',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '邮件邀请 1是0否',<br> email char(40) NOT NULL default ''COMMENT '邀请Email',<br> inviteip char(15) NOT NULL default '' COMMENT '邀请IP',<br> appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用ID',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '邀请码生成时间',<br> endtime int(10) unsigned NOT NULL default '0' COMMENT '邀请码结束时间',<br> regdateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',<br> `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '邀请码状态',<br> orderid char(32) NOT NULL default ''COMMENT '购买邀请码的订单号id',<br> PRIMARY KEY (id),<br> KEY uid (uid, dateline)<br>) ENGINE=MyISAM COMMENT='邀请表';'' <br>DROP TABLE IF EXISTS pre_common_mailcron;<br>CREATE TABLE pre_common_mailcron (<br> cid mediumint(8) unsigned NOT NULL auto_increment,<br> touid mediumint(8) unsigned NOT NULL default '0',<br> email varchar(100) NOT NULL default '',<br> sendtime int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (cid),<br> KEY sendtime (sendtime)<br>) ENGINE=MyISAM COMMENT='邮件计划任务表';'' <br>DROP TABLE IF EXISTS pre_common_mailqueue;<br>CREATE TABLE pre_common_mailqueue (<br> qid mediumint(8) unsigned NOT NULL auto_increment,<br> cid mediumint(8) unsigned NOT NULL default '0',<br> `subject` text NOT NULL,<br> message text NOT NULL,<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (qid),<br> KEY mcid (cid,dateline)<br>) ENGINE=MyISAM COMMENT='邮件队列表'; <br>DROP TABLE IF EXISTS pre_common_member;<br>CREATE TABLE pre_common_member (<br> uid mediumint(8) unsigned NOT NULL auto_increment COMMENT '会员id',<br> email char(40) NOT NULL default ''COMMENT '邮箱',<br> username char(15) NOT NULL default '' COMMENT '用户名',<br> `password` char(32) NOT NULL default ''COMMENT '密码',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '判断用户是否已经删除 需要discuz程序加判断，并增加整体清理的功能。原home字段为flag',<br> emailstatus tinyint(1) NOT NULL default '0' COMMENT 'email是否经过验证 home字段为emailcheck',<br> avatarstatus tinyint(1) NOT NULL default '0' COMMENT '是否有头像 home字段为avatar',<br> videophotostatus tinyint(1) NOT NULL default '0' COMMENT '视频认证状态 home',<br> adminid tinyint(1) NOT NULL default '0' COMMENT '管理员id',<br> groupid smallint(6) unsigned NOT NULL default '0' COMMENT '会员组id',<br> groupexpiry int(10) unsigned NOT NULL default '0' COMMENT '用户组有效期',<br> extgroupids char(20) NOT NULL default '' COMMENT '扩展用户组',<br> regdate int(10) unsigned NOT NULL default '0' COMMENT '注册时间',<br> credits int(10) NOT NULL default '0' COMMENT '总积分',<br> notifysound tinyint(1) NOT NULL default '0' COMMENT '短信声音',<br> timeoffset char(4) NOT NULL default ''COMMENT '时区校正',<br> newpm smallint(6) unsigned NOT NULL default '0' COMMENT '新短消息数量',<br> newprompt smallint(6) unsigned NOT NULL default '0' COMMENT '新提醒数目',<br> accessmasks tinyint(1) NOT NULL default '0' COMMENT '标志',<br> allowadmincp tinyint(1) NOT NULL default '0' COMMENT '标志',<br> onlyacceptfriendpm tinyint(1) NOT NULL default '0' COMMENT '是否只接收好友短消息',<br> conisbind tinyint(1) unsigned NOT NULL default '0' COMMENT '用户是否绑定QC',<br> PRIMARY KEY (uid),<br> UNIQUE KEY `username` (`username`),<br> KEY `email` (`email`),<br> KEY `groupid` (`groupid`),<br> KEY `conisbind` (`conisbind`)<br>) ENGINE=MyISAM COMMENT='用户主表';'' <br>DROP TABLE IF EXISTS pre_common_member_count;<br>CREATE TABLE pre_common_member_count (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> extcredits1 int(10) NOT NULL default '0' COMMENT '声望',<br> extcredits2 int(10) NOT NULL default '0' COMMENT '金钱',<br> extcredits3 int(10) NOT NULL default '0' COMMENT '扩展',<br> extcredits4 int(10) NOT NULL default '0' COMMENT '扩展',<br> extcredits5 int(10) NOT NULL default '0' COMMENT '扩展',<br> extcredits6 int(10) NOT NULL default '0' COMMENT '扩展',<br> extcredits7 int(10) NOT NULL default '0' COMMENT '扩展',<br> extcredits8 int(10) NOT NULL default '0' COMMENT '扩展',<br> friends smallint(6) unsigned NOT NULL default '0' COMMENT '好友个数 home',<br> posts mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子数',<br> threads mediumint(8) unsigned NOT NULL default '0' COMMENT '主题数',<br> digestposts smallint(6) unsigned NOT NULL default '0' COMMENT '精华数',<br> doings smallint(6) unsigned NOT NULL default '0' COMMENT '记录数',<br> blogs smallint(6) unsigned NOT NULL default '0' COMMENT '日志数',<br> albums smallint(6) unsigned NOT NULL default '0' COMMENT '相册数',<br> sharings smallint(6) unsigned NOT NULL default '0' COMMENT '分享数',<br> attachsize int(10) unsigned NOT NULL default '0' COMMENT '上传附件占用的空间 home',<br> views mediumint(8) unsigned NOT NULL default '0' COMMENT '空间查看数',<br> oltime smallint(6) unsigned NOT NULL default '0' COMMENT '在线时间',<br> todayattachs smallint(6) unsigned NOT NULL default '0' COMMENT '当天上传附件数',<br> todayattachsize int(10) unsigned NOT NULL default '0' COMMENT '当天上传附件容量',<br> feeds mediumint(8) unsigned NOT NULL default '0' COMMENT '广播数',<br> follower mediumint(8) unsigned NOT NULL default '0' COMMENT '听众数量',<br> following mediumint(8) unsigned NOT NULL default '0' COMMENT '收听数量',<br> newfollower mediumint(8) unsigned NOT NULL default '0' COMMENT '新增听众数量',<br> PRIMARY KEY (uid),<br> KEY posts (posts)<br>) ENGINE=MyISAM COMMENT='用户统计表'; <br>DROP TABLE IF EXISTS pre_common_member_field_forum;<br>CREATE TABLE pre_common_member_field_forum (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> publishfeed tinyint(3) NOT NULL default '0' COMMENT '用户自定义发送哪些类型的feed(原字段为customaddfeed)',<br> customshow tinyint(1) unsigned NOT NULL default '26' COMMENT '自定义帖子显示模式',<br> customstatus varchar(30) NOT NULL default ''COMMENT '自定义头衔',<br> medals text NOT NULL COMMENT '勋章信息',<br> sightml text NOT NULL COMMENT '签名',<br> groupterms text NOT NULL COMMENT '公共用户组',<br> authstr varchar(20) NOT NULL default '' COMMENT '找回密码验证串',<br> groups mediumtext NOT NULL COMMENT '用户所有群组',<br> attentiongroup varchar(255) NOT NULL default ''COMMENT '用户偏好',<br> PRIMARY KEY (uid)<br>) ENGINE=MyISAM COMMENT='用户论坛字段表';'' <br>DROP TABLE IF EXISTS pre_common_member_field_home;<br>CREATE TABLE pre_common_member_field_home (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> videophoto varchar(255) NOT NULL default ''COMMENT '视频认证照片地址 home',<br> spacename varchar(255) NOT NULL default '' COMMENT '空间名称',<br> spacedescription varchar(255) NOT NULL default ''COMMENT '空间简介',<br> `domain` char(15) NOT NULL default '' COMMENT '空间绑定二级域名 home',<br> addsize int(10) unsigned NOT NULL default '0' COMMENT '额外授予的上传空间 home',<br> addfriend smallint(6) unsigned NOT NULL default '0' COMMENT '额外允许增加的好友数 home',<br> menunum smallint(6) unsigned NOT NULL default '0' COMMENT '应用显示个数',<br> theme varchar(20) NOT NULL default ''COMMENT '空间风格主题 home',<br> spacecss text NOT NULL COMMENT '个人空间自定义css home',<br> blockposition text NOT NULL COMMENT '个人空间自定义模块位置及相关参数 home',<br> recentnote text NOT NULL COMMENT '最近一次行为记录',<br> spacenote text NOT NULL COMMENT '最近一次twitter',<br> privacy text NOT NULL COMMENT 'home隐私设置(注意要和论坛发feed等开关的设置结合)',<br> feedfriend mediumtext NOT NULL COMMENT '接受feed的好友缓存',<br> acceptemail text NOT NULL COMMENT '接受新通知邮件及设置邮件接收参数',<br> magicgift text NOT NULL COMMENT '道具红包卡相关信息',<br> stickblogs text NOT NULL COMMENT '置顶的日志ID',<br> PRIMARY KEY (uid),<br> KEY domain (domain)<br>) ENGINE=MyISAM COMMENT='用户家园字段表';'' <br>DROP TABLE IF EXISTS pre_common_member_profile;<br>CREATE TABLE pre_common_member_profile (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> realname varchar(255) NOT NULL default ''COMMENT '实名',<br> gender tinyint(1) NOT NULL default '0' COMMENT '性别\n(0:保密 1:男 2:女)',<br> birthyear smallint(6) unsigned NOT NULL default '0',<br> birthmonth tinyint(3) unsigned NOT NULL default '0',<br> birthday tinyint(3) unsigned NOT NULL default '0',<br> constellation varchar(255) NOT NULL default '' COMMENT '星座(根据生日自动计算)',<br> zodiac varchar(255) NOT NULL default ''COMMENT '生肖(根据生日自动计算)',<br> telephone varchar(255) NOT NULL default '' COMMENT '固定电话',<br> mobile varchar(255) NOT NULL default ''COMMENT '手机',<br> idcardtype varchar(255) NOT NULL default '' COMMENT '证件类型：身份证 护照 军官证等',<br> idcard varchar(255) NOT NULL default ''COMMENT '证件号码',<br> address varchar(255) NOT NULL default '' COMMENT '邮寄地址',<br> zipcode varchar(255) NOT NULL default ''COMMENT '邮编',<br> nationality varchar(255) NOT NULL default '' COMMENT '国籍',<br> birthprovince varchar(255) NOT NULL default ''COMMENT '出生省份',<br> birthcity varchar(255) NOT NULL default '' COMMENT '出生城市',<br> birthdist varchar(20) NOT NULL default ''COMMENT '出生行政区/县',<br> birthcommunity varchar(255) NOT NULL default '' COMMENT '出生小区',<br> resideprovince varchar(255) NOT NULL default ''COMMENT '居住省份',<br> residecity varchar(255) NOT NULL default '' COMMENT '居住城市',<br> residedist varchar(20) NOT NULL default ''COMMENT '居住行政区/县',<br> residecommunity varchar(255) NOT NULL default '' COMMENT '居住小区',<br> residesuite varchar(255) NOT NULL default ''COMMENT '小区、写字楼门牌号',<br> graduateschool varchar(255) NOT NULL default '' COMMENT '毕业学校',<br> company varchar(255) NOT NULL default ''COMMENT ' 公司',<br> education varchar(255) NOT NULL default '' COMMENT ' 学历',<br> occupation varchar(255) NOT NULL default ''COMMENT ' 职业',<br> `position` varchar(255) NOT NULL default '' COMMENT '职位',<br> revenue varchar(255) NOT NULL default ''COMMENT ' 年收入',<br> affectivestatus varchar(255) NOT NULL default '' COMMENT ' 情感状态',<br> lookingfor varchar(255) NOT NULL default ''COMMENT ' 交友目的（交友类型）',<br> bloodtype varchar(255) NOT NULL default '' COMMENT '血型',<br> height varchar(255) NOT NULL default ''COMMENT ' 身高',<br> weight varchar(255) NOT NULL default '' COMMENT ' 体重',<br> alipay varchar(255) NOT NULL default ''COMMENT '支付宝帐号',<br> icq varchar(255) NOT NULL default '' COMMENT 'ICQ',<br> qq varchar(255) NOT NULL default ''COMMENT 'QQ',<br> yahoo varchar(255) NOT NULL default '' COMMENT 'YAHOO',<br> msn varchar(255) NOT NULL default ''COMMENT 'MSN',<br> taobao varchar(255) NOT NULL default '' COMMENT '阿里旺旺',<br> site varchar(255) NOT NULL default ''COMMENT '主页',<br> bio text NOT NULL COMMENT '自我介绍 来自论坛bio字段',<br> interest text NOT NULL COMMENT '兴趣爱好',<br> field1 text NOT NULL COMMENT '自定义字段1',<br> field2 text NOT NULL COMMENT '自定义字段2',<br> field3 text NOT NULL COMMENT '自定义字段3',<br> field4 text NOT NULL COMMENT '自定义字段4',<br> field5 text NOT NULL COMMENT '自定义字段5',<br> field6 text NOT NULL COMMENT '自定义字段6',<br> field7 text NOT NULL COMMENT '自定义字段7',<br> field8 text NOT NULL COMMENT '自定义字段8',<br> PRIMARY KEY (uid)<br>) ENGINE=MyISAM COMMENT='用户栏目表';'' <br>DROP TABLE IF EXISTS pre_common_member_status;<br>CREATE TABLE pre_common_member_status (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> regip char(15) NOT NULL default ''COMMENT '注册IP',<br> lastip char(15) NOT NULL default '' COMMENT '最后登录IP',<br> lastvisit int(10) unsigned NOT NULL default '0' COMMENT '最后访问',<br> lastactivity int(10) unsigned NOT NULL default '0' COMMENT '最后活动',<br> lastpost int(10) unsigned NOT NULL default '0' COMMENT '最后发表',<br> lastsendmail int(10) unsigned NOT NULL default '0' COMMENT '上次发送email时间 home原字段为lastsend',<br> invisible tinyint(1) NOT NULL default '0' COMMENT '是否隐身登录',<br> buyercredit smallint(6) NOT NULL default '0' COMMENT '买家信用等级及积分',<br> sellercredit smallint(6) NOT NULL default '0' COMMENT '卖家信用等级及积分',<br> favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '个人空间收藏次数',<br> sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '个人空间分享次数',<br> profileprogress tinyint(2) unsigned NOT NULL default '0' COMMENT '个人资料完成度',<br> PRIMARY KEY (uid),<br> KEY lastactivity (lastactivity, invisible)<br>) ENGINE=MyISAM COMMENT='用户状态表'; <br>DROP TABLE IF EXISTS pre_common_member_stat_field;<br>CREATE TABLE pre_common_member_stat_field (<br> optionid mediumint(8) unsigned NOT NULL auto_increment COMMENT '资料统计项 id',<br> fieldid varchar(255) NOT NULL default ''COMMENT '资料项字段标志符',<br> fieldvalue varchar(255) NOT NULL default '' COMMENT '字段值' ,<br> hash varchar(255) NOT NULL default ''COMMENT '由fieldid和fieldvalue生成的hash',<br> users mediumint(8) unsigned NOT NULL default '0' COMMENT '对应用户数',<br> updatetime int(10) unsigned NOT NULL default '0' COMMENT '更新时间',<br> PRIMARY KEY (optionid),<br> KEY fieldid (fieldid)<br>) ENGINE=MyISAM COMMENT='用户资料统计项';'' <br>DROP TABLE IF EXISTS pre_common_member_action_log;<br>CREATE TABLE pre_common_member_action_log (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',<br> `action` tinyint(5) NOT NULL default '0' COMMENT '操作代码',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (id),<br> KEY dateline (dateline, `action`, uid)<br>) ENGINE=MyISAM COMMENT='用户操作日志表'; <br>DROP TABLE IF EXISTS pre_home_follow;<br>CREATE TABLE pre_home_follow (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',<br> username char(15) NOT NULL default ''COMMENT '用户名',<br> followuid mediumint(8) unsigned NOT NULL default '0' COMMENT '被关注用户ID',<br> fusername char(15) NOT NULL default '' COMMENT '被关注用户名称',<br> bkname varchar(255) NOT NULL default ''COMMENT '用户备注',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '0:正常 1:特殊关注 -1:不能再关注此人',<br> mutual tinyint(1) NOT NULL default '0' COMMENT '0:单向 1:已互相关注',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (uid, followuid)<br>) ENGINE=MyISAM COMMENT='用户关注关系表';'' <br>DROP TABLE IF EXISTS pre_home_follow_feed;<br>CREATE TABLE pre_home_follow_feed (<br> feedid mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '被关注者ID',<br> username varchar(15) NOT NULL default ''COMMENT '被关注用户名',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子tid',<br> note text NOT NULL COMMENT '转发理由',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (feedid),<br> KEY uid (uid, dateline)<br>) ENGINE=MyISAM COMMENT='被关注者事件表';'' <br>DROP TABLE IF EXISTS pre_home_follow_feed_archiver;<br>CREATE TABLE pre_home_follow_feed_archiver (<br> feedid mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '被关注者ID',<br> username varchar(15) NOT NULL default ''COMMENT '被关注用户名',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子tid',<br> note text NOT NULL COMMENT '转发理由',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (feedid),<br> KEY uid (uid, dateline)<br>) ENGINE=MyISAM COMMENT='被关注者事件存档';'' <br>DROP TABLE IF EXISTS pre_common_member_log;<br>CREATE TABLE pre_common_member_log (<br> uid mediumint(8) unsigned NOT NULL default '0',<br> `action` char(10) NOT NULL default ''COMMENT 'add,update,delete',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (uid)<br>) ENGINE=MyISAM COMMENT='漫游用户日志表';'' <br>DROP TABLE IF EXISTS pre_common_member_verify;<br>CREATE TABLE pre_common_member_verify (<br> uid mediumint(8) unsigned NOT NULL COMMENT '会员id',<br> verify1 tinyint(1) NOT NULL default '0' COMMENT '认证1: -1:被拒绝 0:待审核 1:审核通过',<br> verify2 tinyint(1) NOT NULL default '0' COMMENT '认证2: -1:被拒绝 0:待审核 1:审核通过',<br> verify3 tinyint(1) NOT NULL default '0' COMMENT '认证3: -1:被拒绝 0:待审核 1:审核通过',<br> verify4 tinyint(1) NOT NULL default '0' COMMENT '认证4: -1:被拒绝 0:待审核 1:审核通过',<br> verify5 tinyint(1) NOT NULL default '0' COMMENT '认证5: -1:被拒绝 0:待审核 1:审核通过',<br> verify6 tinyint(1) NOT NULL default '0' COMMENT '实名认证: -1:被拒绝 0:待审核 1:审核通过',<br> verify7 tinyint(1) NOT NULL default '0' COMMENT '视频认证: -1:被拒绝 0:待审核 1:审核通过',<br> PRIMARY KEY (uid),<br> KEY verify1 (verify1),<br> KEY verify2 (verify2),<br> KEY verify3 (verify3),<br> KEY verify4 (verify4),<br> KEY verify5 (verify5),<br> KEY verify6 (verify6),<br> KEY verify7 (verify7)<br>) ENGINE=MyISAM COMMENT='用户认证表'; <br>DROP TABLE IF EXISTS pre_common_member_verify_info;<br>CREATE TABLE pre_common_member_verify_info (<br> vid mediumint(8) unsigned NOT NULL auto_increment COMMENT '审核id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username varchar(30) NOT NULL default ''COMMENT '用户名',<br> verifytype tinyint(1) NOT NULL default '0' COMMENT '审核类型0:资料审核, 1:认证1, 2:认证2, 3:认证3, 4:认证4, 5:认证5',<br> flag tinyint(1) NOT NULL default '0' COMMENT '-1:被拒绝 0:待审核 1:审核通过',<br> field text NOT NULL COMMENT '序列化存储变化值',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '提交日期',<br> PRIMARY KEY (vid),<br> KEY verifytype (verifytype, flag),<br> KEY uid (uid, verifytype, dateline)<br>) ENGINE=MyISAM COMMENT='个人信息修改审核';'' DROP TABLE IF EXISTS pre_common_member_profile_setting;<br>CREATE TABLE pre_common_member_profile_setting (<br> fieldid varchar(255) NOT NULL default ''COMMENT 'profile字段标志符',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否可用',<br> invisible tinyint(1) NOT NULL default '0' COMMENT '是否隐藏',<br> needverify tinyint(1) NOT NULL default '0' COMMENT '是否需要审核',<br> title varchar(255) NOT NULL default '' COMMENT '栏目标题',<br> description varchar(255) NOT NULL default ''COMMENT '解释说明',<br> displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序',<br> required tinyint(1) NOT NULL default '0' COMMENT '是否必填内容',<br> unchangeable tinyint(1) NOT NULL default '0' COMMENT '不可修改',<br> showincard tinyint(1) NOT NULL default '0' COMMENT '在名片中显示',<br> showinthread tinyint(1) NOT NULL default '0' COMMENT '在帖子中显示',<br> showinregister tinyint(1) NOT NULL default '0' COMMENT '是否在注册页面显示',<br> allowsearch tinyint(1) NOT NULL default '0' COMMENT '是否可搜索',<br> formtype varchar(255) NOT NULL COMMENT '表单元素类型',<br> size smallint(6) unsigned NOT NULL default '0' COMMENT '内容最大长度',<br> choices text NOT NULL COMMENT '选填内容',<br> validate text NOT NULL COMMENT '验证数据的正则表达式',<br> PRIMARY KEY (fieldid)<br>) ENGINE=MyISAM COMMENT='个人信息扩展表';'' <br>DROP TABLE IF EXISTS pre_common_member_security;<br>CREATE TABLE pre_common_member_security (<br> securityid mediumint(8) unsigned NOT NULL auto_increment COMMENT '审核项id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username varchar(255) NOT NULL default ''COMMENT '用户名',<br> fieldid varchar(255) NOT NULL default '' COMMENT 'profile字段标志符',<br> oldvalue text NOT NULL COMMENT '旧的profile字段值',<br> newvalue text NOT NULL COMMENT '新的profile字段值',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '提交日期',<br> PRIMARY KEY (securityid),<br> KEY uid (uid, fieldid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='个人信息修改审核'; <br>DROP TABLE IF EXISTS pre_common_member_validate;<br>CREATE TABLE pre_common_member_validate (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> submitdate int(10) unsigned NOT NULL default '0' COMMENT '提交日期',<br> moddate int(10) unsigned NOT NULL default '0' COMMENT '审核日期',<br> admin varchar(15) NOT NULL default ''COMMENT '管理员名',<br> submittimes tinyint(3) unsigned NOT NULL default '0' COMMENT '提交的次数',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '状态',<br> message text NOT NULL COMMENT '注册原因',<br> remark text NOT NULL COMMENT '管理员留言',<br> PRIMARY KEY (uid),<br> KEY `status` (`status`)<br>) ENGINE=MyISAM COMMENT='用户审核表';'' <br>DROP TABLE IF EXISTS pre_common_member_crime;<br>CREATE TABLE pre_common_member_crime (<br> cid mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '被惩罚操作的用户id',<br> operatorid mediumint(8) unsigned NOT NULL default '0' COMMENT '进行惩罚操作的用户id',<br> operator varchar(15) NOT NULL COMMENT '进行惩罚操作的用户名',<br> `action` tinyint(5) NOT NULL COMMENT '惩罚行为',<br> reason text NOT NULL COMMENT '惩罚理由',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '惩罚操作时间',<br> PRIMARY KEY (cid),<br> KEY uid (uid,`action`,dateline)<br>) ENGINE=MyISAM COMMENT='用户惩罚操作表'; DROP TABLE IF EXISTS pre_common_member_grouppm;<br>CREATE TABLE pre_common_member_grouppm (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> gpmid smallint(6) unsigned NOT NULL auto_increment COMMENT '消息id',<br> status tinyint(1) NOT NULL default '0' COMMENT '0=未读 1=已读 -1=删除',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '阅读时间',<br> PRIMARY KEY (uid, gpmid)<br>) ENGINE=MyISAM COMMENT='群发短消息用户记录表'; <br>DROP TABLE IF EXISTS pre_common_grouppm;<br>CREATE TABLE pre_common_grouppm (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '消息id',<br> authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者id',<br> author varchar(15) NOT NULL default ''COMMENT '作者姓名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '时间',<br> message text NOT NULL COMMENT '消息',<br> numbers mediumint(8) unsigned NOT NULL default '0' COMMENT '数量',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='群发短消息表';'' <br>DROP TABLE IF EXISTS pre_common_myapp;<br>CREATE TABLE pre_common_myapp (<br> appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用id',<br> appname varchar(60) NOT NULL default ''COMMENT '应用名称',<br> narrow tinyint(1) NOT NULL default '0' COMMENT '是否显示为窄的profile box',<br> flag tinyint(1) NOT NULL default '0' COMMENT '应用状态（黑白名单、默认应用等）',<br> version mediumint(8) unsigned NOT NULL default '0' COMMENT '应用版本号',<br> userpanelarea tinyint(1) NOT NULL default '0' COMMENT 'userabout显示区域、1主区、2、副区、3应用区',<br> canvastitle varchar(60) NOT NULL default '' COMMENT 'canvas页面标题',<br> fullscreen tinyint(1) NOT NULL default '0' COMMENT '是否是全屏应用',<br> displayuserpanel tinyint(1) NOT NULL default '0' COMMENT '是否显示应用右侧的用户菜单',<br> displaymethod tinyint(1) NOT NULL default '0' COMMENT '显示方式（iframe/myml）',<br> displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序',<br> appstatus tinyint(2) NOT NULL default '0' COMMENT '标识应用1:新、2:热',<br> iconstatus tinyint(2) NOT NULL default '0' COMMENT '应用图标是否已下载到本地。-1：失败；0：未下载；1：已下载',<br> icondowntime int(10) unsigned NOT NULL default '0' COMMENT '应用图标下载到本地时间',<br> PRIMARY KEY (appid),<br> KEY flag (flag,displayorder)<br>) ENGINE=MyISAM COMMENT='漫游应用表'; <br>DROP TABLE IF EXISTS pre_common_myinvite;<br>CREATE TABLE pre_common_myinvite (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '邀请id',<br> typename varchar(100) NOT NULL default ''COMMENT '邀请名称',<br> appid mediumint(8) NOT NULL default '0' COMMENT '应用id',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '类型(request 邀请/invite 请求)',<br> fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '邀请者id',<br> touid mediumint(8) unsigned NOT NULL default '0' COMMENT '接收者id',<br> myml text NOT NULL COMMENT '邀请内容',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发送邀请的时间戳',<br> `hash` int(10) unsigned NOT NULL default '0' COMMENT 'hash标记',<br> PRIMARY KEY (id),<br> KEY `hash` (`hash`),<br> KEY uid (touid,dateline)<br>) ENGINE=MyISAM COMMENT='用户邀请表';'' <br>DROP TABLE IF EXISTS pre_common_nav;<br>CREATE TABLE pre_common_nav (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '项目id',<br> parentid smallint(6) unsigned NOT NULL default '0' COMMENT '父 id(navtype=0)',<br> `name` varchar(255) NOT NULL COMMENT '导航名称',<br> title varchar(255) NOT NULL COMMENT '导航说明',<br> url varchar(255) NOT NULL COMMENT '导航链接',<br> identifier varchar(255) NOT NULL COMMENT '链接标识/相关ID',<br> target tinyint(1) NOT NULL default '0' COMMENT '目标框架\n(0:本窗口 1:新窗口)',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '类型 0 系统 1 自定义 3 插件 4 频道',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否可用',<br> displayorder tinyint(3) NOT NULL COMMENT '显示顺序',<br> highlight tinyint(1) NOT NULL default '0' COMMENT '样式(navtype=0)',<br> `level` tinyint(1) NOT NULL default '0' COMMENT '使用等级\n(0:游客 1:会员 2:版主 3:管理员)',<br> `subtype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '二级导航样式(navtype=0) 顶部导航位置(navtype=4)',<br> `subcols` tinyint(1) NOT NULL DEFAULT '0' COMMENT '横排一行显示的条目数(navtype=0)',<br> `icon` varchar(255) NOT NULL COMMENT '图标地址(navtype=1、3)',<br> `subname` varchar(255) NOT NULL COMMENT '副导航名称(navtype=1)',<br> `suburl` varchar(255) NOT NULL COMMENT '副导航地址(navtype=1)',<br> `navtype` tinyint(1) NOT NULL default '0' COMMENT '导航类型\n(0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航)',<br> logo varchar(255) NOT NULL COMMENT '自定义 Logo',<br> PRIMARY KEY (id),<br> KEY `navtype` (`navtype`)<br>) ENGINE=MyISAM COMMENT='自定义导航栏表'; DROP TABLE IF EXISTS pre_common_onlinetime;<br>CREATE TABLE pre_common_onlinetime (<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0',<br> thismonth smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '本月在线时间',<br> total mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '总在线时间',<br> lastupdate int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (uid)<br>) ENGINE=MyISAM COMMENT='在线时间表'; <br>DROP TABLE IF EXISTS pre_common_regip;<br>CREATE TABLE pre_common_regip (<br> ip char(15) NOT NULL default ''COMMENT 'IP地址',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '限制时间',<br> count smallint(6) NOT NULL default '0' COMMENT '限制数量',<br> KEY ip (ip)<br>) ENGINE=MyISAM COMMENT='注册IP限制表';'' <br>DROP TABLE IF EXISTS pre_common_secquestion;<br>CREATE TABLE pre_common_secquestion (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '验证问题id',<br> `type` tinyint(1) unsigned NOT NULL COMMENT '验证问题类型',<br> question text NOT NULL COMMENT '验证问题',<br> answer varchar(255) NOT NULL COMMENT '问题答案',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='验证问题数据表'; DROP TABLE IF EXISTS pre_common_session;<br>CREATE TABLE pre_common_session (<br> sid char(6) NOT NULL default ''COMMENT 'sid',<br> ip1 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',<br> ip2 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',<br> ip3 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',<br> ip4 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username char(15) NOT NULL default '' COMMENT '会员名',<br> groupid smallint(6) unsigned NOT NULL default '0' COMMENT '会员组',<br> invisible tinyint(1) NOT NULL default '0' COMMENT '是否隐身登录',<br> `action` tinyint(1) unsigned NOT NULL default '0' COMMENT '当前动作',<br> lastactivity int(10) unsigned NOT NULL default '0' COMMENT '最后活动时间',<br> lastolupdate int(10) unsigned NOT NULL default '0' COMMENT '在线时间最后更新',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> UNIQUE KEY sid (sid),<br> KEY uid (uid)<br>) ENGINE=MEMORY COMMENT='会员认证表'; <br>DROP TABLE IF EXISTS pre_common_setting;<br>CREATE TABLE pre_common_setting (<br> skey varchar(255) NOT NULL default ''COMMENT '变量名',<br> svalue text NOT NULL COMMENT '值',<br> PRIMARY KEY (skey)<br>) ENGINE=MyISAM COMMENT='设置表';'' <br>DROP TABLE IF EXISTS pre_common_smiley;<br>CREATE TABLE pre_common_smiley (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '表情id',<br> typeid smallint(6) unsigned NOT NULL COMMENT '表情分类 id',<br> displayorder tinyint(1) NOT NULL default '0' COMMENT '显示顺序',<br> `type` enum('smiley','stamp','stamplist') NOT NULL default 'smiley' COMMENT '类型',<br> `code` varchar(30) NOT NULL default ''COMMENT '标记',<br> url varchar(30) NOT NULL default '' COMMENT '路径',<br> PRIMARY KEY (id),<br> KEY `type` (`type`, displayorder)<br>) ENGINE=MyISAM COMMENT='表情表'; <br>DROP TABLE IF EXISTS pre_common_stat;<br>CREATE TABLE pre_common_stat (<br> daytime int(10) unsigned NOT NULL default '0' COMMENT '时间',<br> login int(10) unsigned NOT NULL default '0' COMMENT '登陆',<br> mobilelogin int(10) unsigned NOT NULL default '0' COMMENT '手机登陆',<br> connectlogin int(10) unsigned NOT NULL default '0' COMMENT 'QQConnect登陆',<br> register int(10) unsigned NOT NULL default '0' COMMENT '注册',<br> invite int(10) unsigned NOT NULL default '0' COMMENT '邀请',<br> appinvite int(10) unsigned NOT NULL default '0' COMMENT '应用邀请',<br> doing int(10) unsigned NOT NULL default '0' COMMENT '记录',<br> blog int(10) unsigned NOT NULL default '0' COMMENT '日志',<br> pic int(10) unsigned NOT NULL default '0' COMMENT '图片',<br> poll int(10) unsigned NOT NULL default '0' COMMENT '投票',<br> activity int(10) unsigned NOT NULL default '0' COMMENT '活动',<br> `share` int(10) unsigned NOT NULL default '0' COMMENT '分享',<br> thread int(10) unsigned NOT NULL default '0' COMMENT '主题',<br> docomment int(10) unsigned NOT NULL default '0' COMMENT '记录评论',<br> blogcomment int(10) unsigned NOT NULL default '0' COMMENT '日志评论',<br> piccomment int(10) unsigned NOT NULL default '0' COMMENT '图片评论',<br> sharecomment int(10) unsigned NOT NULL default '0' COMMENT '分享评论',<br> reward int(10) unsigned NOT NULL default '0' COMMENT '悬赏',<br> debate int(10) unsigned NOT NULL default '0' COMMENT '辩论',<br> trade int(10) unsigned NOT NULL default '0' COMMENT '商品',<br> `group` int(10) unsigned NOT NULL default '0' COMMENT '群组',<br> groupjoin int(10) unsigned NOT NULL default '0' COMMENT '参与群组',<br> groupthread int(10) unsigned NOT NULL default '0' COMMENT '群组主题',<br> grouppost int(10) unsigned NOT NULL default '0' COMMENT '群组回复',<br> post int(10) unsigned NOT NULL default '0' COMMENT '主题回复',<br> wall int(10) unsigned NOT NULL default '0' COMMENT '留言',<br> poke int(10) unsigned NOT NULL default '0' COMMENT '打招呼',<br> click int(10) unsigned NOT NULL default '0' COMMENT '表态',<br> sendpm int(10) unsigned NOT NULL default '0' COMMENT '发送PM',<br> friend int(10) unsigned NOT NULL default '0' COMMENT '成为好友',<br> addfriend int(10) unsigned NOT NULL default '0' COMMENT '好友请求',<br> PRIMARY KEY (daytime)<br>) ENGINE=MyISAM COMMENT='趋势统计'; <br>DROP TABLE IF EXISTS pre_common_statuser;<br>CREATE TABLE pre_common_statuser (<br> uid mediumint(8) unsigned NOT NULL default '0',<br> daytime int(10) unsigned NOT NULL default '0',<br> `type` char(20) NOT NULL default ''COMMENT '各种用户行为如：invite、register、login...',<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='统计用户表';'' <br>DROP TABLE IF EXISTS pre_common_style;<br>CREATE TABLE pre_common_style (<br> styleid smallint(6) unsigned NOT NULL auto_increment COMMENT '风格id',<br> `name` varchar(20) NOT NULL default ''COMMENT '风格名称',<br> available tinyint(1) NOT NULL default '1' COMMENT '风格是否可用',<br> templateid smallint(6) unsigned NOT NULL default '0' COMMENT '对应模板id',<br> extstyle varchar(255) NOT NULL default '' COMMENT '配色',<br> PRIMARY KEY (styleid)<br>) ENGINE=MyISAM COMMENT='风格表'; <br>DROP TABLE IF EXISTS pre_common_stylevar;<br>CREATE TABLE pre_common_stylevar (<br> stylevarid smallint(6) unsigned NOT NULL auto_increment COMMENT '风格变量id',<br> styleid smallint(6) unsigned NOT NULL default '0' COMMENT '风格id',<br> variable text NOT NULL COMMENT '变量名',<br> substitute text NOT NULL COMMENT '变量赋值',<br> PRIMARY KEY (stylevarid),<br> KEY styleid (styleid)<br>) ENGINE=MyISAM COMMENT='风格变量表'; <br>DROP TABLE IF EXISTS pre_common_syscache;<br>CREATE TABLE pre_common_syscache (<br> cname varchar(32) NOT NULL COMMENT '缓存名称',<br> `ctype` tinyint(3) unsigned NOT NULL COMMENT '缓存类型 0=value, serialize=1',<br> dateline int(10) unsigned NOT NULL COMMENT '缓存生成时间',<br> `data` mediumblob NOT NULL COMMENT '缓存数据',<br> PRIMARY KEY (cname)<br>) ENGINE=MyISAM COMMENT='缓存数据表'; <br>DROP TABLE IF EXISTS pre_common_template;<br>CREATE TABLE pre_common_template (<br> templateid smallint(6) unsigned NOT NULL auto_increment COMMENT '模板id',<br> `name` varchar(30) NOT NULL default ''COMMENT '名称',<br> `directory` varchar(100) NOT NULL default '' COMMENT '目录',<br> copyright varchar(100) NOT NULL default ''COMMENT '版权',<br> PRIMARY KEY (templateid)<br>) ENGINE=MyISAM COMMENT='模板表';'' <br>DROP TABLE IF EXISTS pre_common_usergroup;<br>CREATE TABLE pre_common_usergroup (<br> groupid smallint(6) unsigned NOT NULL auto_increment COMMENT '会员组id',<br> radminid tinyint(3) NOT NULL default '0' COMMENT '关联关管理组',<br> `type` enum('system','special','member') NOT NULL default 'member' COMMENT '类型',<br> system varchar(255) NOT NULL default 'private' COMMENT '会员是否可以自由进出',<br> grouptitle varchar(255) NOT NULL default ''COMMENT '组头衔',<br> creditshigher int(10) NOT NULL default '0' COMMENT '该组的积分上限',<br> creditslower int(10) NOT NULL default '0' COMMENT '该组的积分下限',<br> stars tinyint(3) NOT NULL default '0' COMMENT '星星数量',<br> color varchar(255) NOT NULL default '' COMMENT '组头衔颜色',<br> icon varchar(255) NOT NULL default '',<br> allowvisit tinyint(1) NOT NULL default '0' COMMENT '允许访问',<br> allowsendpm tinyint(1) NOT NULL default '1' COMMENT '是否允许发送短信息',<br> allowinvite tinyint(1) NOT NULL default '0' COMMENT '允许使用邀请注册',<br> allowmailinvite tinyint(1) NOT NULL default '0' COMMENT '允许通过论坛邮件系统发送邀请码',<br> maxinvitenum tinyint(3) unsigned NOT NULL default '0' COMMENT '最大邀请码拥有数量',<br> inviteprice smallint(6) unsigned NOT NULL default '0' COMMENT '邀请码购买价格',<br> maxinviteday smallint(6) unsigned NOT NULL default '0' COMMENT '邀请码有效期',<br> PRIMARY KEY (groupid),<br> KEY creditsrange (creditshigher,creditslower)<br>) ENGINE=MyISAM COMMENT='用户组表';'' <br>DROP TABLE IF EXISTS pre_common_usergroup_field;<br>CREATE TABLE pre_common_usergroup_field (<br> groupid smallint(6) unsigned NOT NULL COMMENT '会员组id',<br> readaccess tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> allowpost tinyint(1) NOT NULL default '0' COMMENT '允许发帖',<br> allowreply tinyint(1) NOT NULL default '0' COMMENT '允许回复',<br> allowpostpoll tinyint(1) NOT NULL default '0' COMMENT '允许发表投票',<br> allowpostreward tinyint(1) NOT NULL default '0' COMMENT '允许发表悬赏',<br> allowposttrade tinyint(1) NOT NULL default '0' COMMENT '允许发表交易',<br> allowpostactivity tinyint(1) NOT NULL default '0' COMMENT '允许发表活动',<br> allowdirectpost tinyint(1) NOT NULL default '0' COMMENT '是否需要审核',<br> allowgetattach tinyint(1) NOT NULL default '0' COMMENT '允许下载附件',<br> allowgetimage tinyint(1) NOT NULL default '0' COMMENT '允许查看图片',<br> allowpostattach tinyint(1) NOT NULL default '0' COMMENT '允许上传附件',<br> allowpostimage tinyint(1) NOT NULL default '0' COMMENT '允许上传图片',<br> allowvote tinyint(1) NOT NULL default '0' COMMENT '允许参与投票',<br> allowsearch tinyint(1) NOT NULL default '0' COMMENT '允许搜索',<br> allowcstatus tinyint(1) NOT NULL default '0' COMMENT '允许自定义头衔',<br> allowinvisible tinyint(1) NOT NULL default '0' COMMENT '允许隐身登录',<br> allowtransfer tinyint(1) NOT NULL default '0' COMMENT '允许积分转帐',<br> allowsetreadperm tinyint(1) NOT NULL default '0' COMMENT '允许设置阅读权限',<br> allowsetattachperm tinyint(1) NOT NULL default '0' COMMENT '允许设置附件权限',<br> allowposttag tinyint(1) NOT NULL default '0' COMMENT '允许使用标签',<br> allowhidecode tinyint(1) NOT NULL default '0' COMMENT '允许使用hide代码',<br> allowhtml tinyint(1) NOT NULL default '0' COMMENT '允许使用html',<br> allowanonymous tinyint(1) NOT NULL default '0' COMMENT '允许匿名发帖',<br> allowsigbbcode tinyint(1) NOT NULL default '0' COMMENT '允许签名使用bbcode',<br> allowsigimgcode tinyint(1) NOT NULL default '0' COMMENT '允许使用img',<br> allowmagics tinyint(1) unsigned NOT NULL COMMENT '允许使用道具',<br> disableperiodctrl tinyint(1) NOT NULL default '0' COMMENT '不受时间段限制',<br> reasonpm tinyint(1) NOT NULL default '0' COMMENT '操作理由短信通知作者',<br> maxprice smallint(6) unsigned NOT NULL default '0' COMMENT '主题最大售价',<br> maxsigsize smallint(6) unsigned NOT NULL default '0' COMMENT '最大签名尺寸',<br> maxattachsize int(10) unsigned NOT NULL default '0' COMMENT '最大附件尺寸',<br> maxsizeperday int(10) unsigned NOT NULL default '0' COMMENT '每天最大附件总尺寸',<br> maxthreadsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT '每小时发主题数限制',<br> maxpostsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT '每小时发回帖数限制',<br> attachextensions char(100) NOT NULL default ''COMMENT '允许发表的附件类型',<br> raterange char(150) NOT NULL default '' COMMENT '评分范围',<br> mintradeprice smallint(6) unsigned NOT NULL default '1' COMMENT '交易最小积分',<br> maxtradeprice smallint(6) unsigned NOT NULL default '0' COMMENT '交易最大积分',<br> minrewardprice smallint(6) unsigned NOT NULL default '1' COMMENT '悬赏最小积分',<br> maxrewardprice smallint(6) unsigned NOT NULL default '0' COMMENT '悬赏最大积分',<br> magicsdiscount tinyint(1) NOT NULL COMMENT '道具折扣',<br> maxmagicsweight smallint(6) unsigned NOT NULL COMMENT '道具负载最大值',<br> allowpostdebate tinyint(1) NOT NULL default '0' COMMENT '允许发表辩论',<br> tradestick tinyint(1) unsigned NOT NULL COMMENT '可商品推荐数',<br> exempt tinyint(1) unsigned NOT NULL COMMENT '用户组表达式',<br> maxattachnum smallint(6) NOT NULL default '0' COMMENT '最大每天附件数量',<br> allowposturl tinyint(1) NOT NULL default '3' COMMENT '是否允许发送含 url 内容',<br> allowrecommend tinyint(1) unsigned NOT NULL default '1' COMMENT '是否允许评价主题',<br> allowpostrushreply TINYINT(1) NOT NULL DEFAULT '0' COMMENT '允许发表抢楼帖',<br> maxfriendnum smallint(6) unsigned NOT NULL default '0' COMMENT '最多好友数',<br> maxspacesize int(10) unsigned NOT NULL default '0' COMMENT '空间大小',<br> allowcomment tinyint(1) NOT NULL default '0' COMMENT '发表留言/评论',<br> allowcommentarticle smallint(6) NOT NULL default '0' COMMENT '发表文章的评论',<br> searchinterval smallint(6) unsigned NOT NULL default '0' COMMENT '两次搜索操作间隔',<br> searchignore tinyint(1) NOT NULL default '0' COMMENT '是否免费搜索',<br> allowblog tinyint(1) NOT NULL default '0' COMMENT '发表日志',<br> allowdoing tinyint(1) NOT NULL default '0' COMMENT '发表记录',<br> allowupload tinyint(1) NOT NULL default '0' COMMENT '上传图片',<br> allowshare tinyint(1) NOT NULL default '0' COMMENT '发布分享',<br> allowblogmod tinyint(1) unsigned NOT NULL default '0' COMMENT '发表日志需要审核',<br> allowdoingmod tinyint(1) unsigned NOT NULL default '0' COMMENT '发表记录需要审核',<br> allowuploadmod tinyint(1) unsigned NOT NULL default '0' COMMENT '上传图片需要审核',<br> allowsharemod tinyint(1) unsigned NOT NULL default '0' COMMENT '发布分享需要审核',<br> allowcss tinyint(1) NOT NULL default '0' COMMENT '允许自定义CSS',<br> allowpoke tinyint(1) NOT NULL default '0' COMMENT '允许打招呼',<br> allowfriend tinyint(1) NOT NULL default '0' COMMENT '允许加好友',<br> allowclick tinyint(1) NOT NULL default '0' COMMENT '允许表态',<br> allowmagic tinyint(1) NOT NULL default '0' COMMENT '允许使用道具',<br> allowstat tinyint(1) NOT NULL default '0' COMMENT '允许查看趋势统计',<br> allowstatdata tinyint(1) NOT NULL default '0' COMMENT '允许查看统计数据报表',<br> videophotoignore tinyint(1) NOT NULL default '0' COMMENT '视频认证限制',<br> allowviewvideophoto tinyint(1) NOT NULL default '0' COMMENT '允许查看视频认证',<br> allowmyop tinyint(1) NOT NULL default '0' COMMENT '允许使用应用',<br> magicdiscount tinyint(1) NOT NULL default '0' COMMENT '购买道具折扣',<br> domainlength smallint(6) unsigned NOT NULL default '0' COMMENT '二级域名最短长度',<br> seccode tinyint(1) NOT NULL default '1' COMMENT '发布操作需填验证码',<br> disablepostctrl tinyint(1) NOT NULL DEFAULT '0' COMMENT '发表是否受防灌水限制',<br> allowbuildgroup tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许建立群组，0为不允许',<br> allowgroupdirectpost tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许直接在群组中发帖',<br> allowgroupposturl tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许在群组中发站外URL',<br> edittimelimit smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '编辑帖子时间限制',<br> allowpostarticle tinyint(1) NOT NULL default '0' COMMENT '允许发布文章',<br> allowdownlocalimg tinyint(1) NOT NULL default '0' COMMENT '允许下载本地图片',<br> allowdownremoteimg tinyint(1) NOT NULL default '0' COMMENT '允许下载远程图片',<br> allowpostarticlemod tinyint(1) unsigned NOT NULL default '0' COMMENT '发布文章是否需要审核',<br> allowspacediyhtml tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用HTML',<br> allowspacediybbcode tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用BBCODE',<br> allowspacediyimgcode tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用[img]',<br> allowcommentpost tinyint(1) NOT NULL default '2' COMMENT '允许帖子点评 0:禁止 1:楼主 2:回复 3:All',<br> allowcommentitem tinyint(1) NOT NULL default '0' COMMENT '允许发表点评观点',<br> allowcommentreply tinyint(1) NOT NULL default '0' COMMENT '允许发表回复点评',<br> allowreplycredit tinyint(1) NOT NULL default '0' COMMENT '允许设置回帖奖励',<br> ignorecensor tinyint(1) unsigned NOT NULL default '0' COMMENT '是否忽略要审核的关键字',<br> allowsendallpm tinyint(1) unsigned NOT NULL default '0' COMMENT '是否不受“只接收好友短消息”设置的限制',<br> allowsendpmmaxnum smallint(6) unsigned NOT NULL default '0' COMMENT '24小时内允许发短消息的数量',<br> maximagesize mediumint(8) unsigned NOT NULL default '0' COMMENT '相册中允许最大图片大小',<br> allowmediacode tinyint(1) NOT NULL default '0' COMMENT '允许使用多媒体代码',<br> allowat smallint(6) unsigned NOT NULL default '0' COMMENT '允许@用户 0：禁止 n:发帖时@的数量',<br> allowsetpublishdate tinyint(1) unsigned NOT NULL default '0' COMMENT '允许定时发布主题',<br> allowfollowcollection tinyint(1) unsigned NOT NULL default '0' COMMENT '允许关注淘专辑数',<br> allowcommentcollection tinyint(1) unsigned NOT NULL default '0' COMMENT '允许评论淘专辑',<br> allowcreatecollection smallint(6) unsigned NOT NULL default '0' COMMENT '允许创建淘专辑数',<br> PRIMARY KEY (groupid)<br>) ENGINE=MyISAM COMMENT='会员用户组权限表'; <br>DROP TABLE IF EXISTS pre_common_word;<br>CREATE TABLE pre_common_word (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '词汇id',<br> admin varchar(15) NOT NULL default ''COMMENT '管理员名',<br> type smallint(6) NOT NULL default '1' COMMENT '关键词分类',<br> find varchar(255) NOT NULL default '' COMMENT '不良词语',<br> replacement varchar(255) NOT NULL default ''COMMENT '替换内容',<br> extra varchar(255) NOT NULL default '',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='词语过滤表'; <br>DROP TABLE IF EXISTS pre_common_word_type;<br>CREATE TABLE pre_common_word_type (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '词语过滤分类id',<br> typename varchar(15) NOT NULL default ''COMMENT '分类名称',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='词语过滤分类';'' <br>DROP TABLE IF EXISTS pre_common_tag;<br>CREATE TABLE pre_common_tag (<br> tagid smallint(6) unsigned NOT NULL auto_increment COMMENT '标签id',<br> tagname char(20) NOT NULL default ''COMMENT '标签名',<br> status tinyint(1) NOT NULL default '0' COMMENT '显示状态\n(0:正常 1:关闭 2:推荐 3:用户标签)',<br> PRIMARY KEY (tagid),<br> KEY tagname (tagname),<br> KEY status (status, tagid)<br>) ENGINE=MyISAM COMMENT='标签表';'' <br>DROP TABLE IF EXISTS pre_common_tagitem;<br>CREATE TABLE pre_common_tagitem (<br> tagid smallint(6) unsigned NOT NULL default '0' COMMENT '标签id',<br> itemid mediumint(8) unsigned NOT NULL default '0' COMMENT 'itemid',<br> idtype char(10) NOT NULL default ''COMMENT '内容类型',<br> UNIQUE KEY item (tagid, itemid, idtype),<br> KEY idtype (idtype, itemid)<br>) ENGINE=MyISAM COMMENT='标签内容表';'' <br>DROP TABLE IF EXISTS pre_forum_access;<br>CREATE TABLE pre_forum_access (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> allowview tinyint(1) NOT NULL default '0' COMMENT '允许浏览',<br> allowpost tinyint(1) NOT NULL default '0' COMMENT '允许发表',<br> allowreply tinyint(1) NOT NULL default '0' COMMENT '允许回复',<br> allowgetattach tinyint(1) NOT NULL default '0' COMMENT '允许下载附件',<br> allowgetimage tinyint(1) NOT NULL default '0' COMMENT '允许查看图片',<br> allowpostattach tinyint(1) NOT NULL default '0' COMMENT '允许上传附件',<br> allowpostimage tinyint(1) NOT NULL default '0' COMMENT '允许上传图片',<br> adminuser mediumint(8) unsigned NOT NULL default '0' COMMENT '管理员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '时间',<br> PRIMARY KEY (uid,fid),<br> KEY listorder (fid,dateline)<br>) ENGINE=MyISAM COMMENT='访问权限表'; <br>DROP TABLE IF EXISTS pre_forum_activity;<br>CREATE TABLE pre_forum_activity (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题图片id',<br> cost mediumint(8) unsigned NOT NULL default '0' COMMENT '每人花销',<br> starttimefrom int(10) unsigned NOT NULL default '0' COMMENT '开始时间',<br> starttimeto int(10) unsigned NOT NULL default '0' COMMENT '结束时间',<br> place varchar(255) NOT NULL default ''COMMENT '地点',<br> class varchar(255) NOT NULL default '' COMMENT '类别',<br> gender tinyint(1) NOT NULL default '0' COMMENT '性别',<br> number smallint(5) unsigned NOT NULL default '0' COMMENT '人数',<br> applynumber smallint(5) unsigned NOT NULL default '0' COMMENT '已参加人数',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '报名截止日期',<br> ufield TEXT NOT NULL COMMENT '用户定制项目',<br> credit smallint(6) unsigned NOT NULL default '0' COMMENT '需消耗的积分',<br> PRIMARY KEY (tid),<br> KEY uid (uid,starttimefrom),<br> KEY starttimefrom (starttimefrom),<br> KEY expiration (expiration),<br> KEY applynumber (applynumber)<br>) ENGINE=MyISAM COMMENT='活动表'; <br>DROP TABLE IF EXISTS pre_forum_activityapply;<br>CREATE TABLE pre_forum_activityapply (<br> applyid int(10) unsigned NOT NULL auto_increment COMMENT '申请id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> username varchar(255) NOT NULL default ''COMMENT '用户名',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> message varchar(255) NOT NULL default '' COMMENT '消息',<br> verified tinyint(1) NOT NULL default '0' COMMENT '是否审核通过\n(0:N 1:Y 2:需完善资料)',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '申请时间',<br> payment mediumint(8) NOT NULL default '0' COMMENT '每人花销',<br> ufielddata TEXT NOT NULL COMMENT '用户定制项目数据',<br> PRIMARY KEY (applyid),<br> KEY uid (uid),<br> KEY tid (tid),<br> KEY dateline (tid,dateline)<br>) ENGINE=MyISAM COMMENT='活动申请表'; <br>DROP TABLE IF EXISTS pre_forum_announcement;<br>CREATE TABLE pre_forum_announcement (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '公告id',<br> author varchar(15) NOT NULL default ''COMMENT '作者姓名',<br> `subject` varchar(255) NOT NULL default '' COMMENT '公告标题',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '公告类型\n(0:文字公告 1:网址链接)',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> starttime int(10) unsigned NOT NULL default '0' COMMENT '开始时间',<br> endtime int(10) unsigned NOT NULL default '0' COMMENT '结束时间',<br> message text NOT NULL COMMENT '消息',<br> groups text NOT NULL COMMENT '接受用户组',<br> PRIMARY KEY (id),<br> KEY timespan (starttime,endtime)<br>) ENGINE=MyISAM COMMENT='公告表';<br>DROP TABLE IF EXISTS pre_forum_threadimage;<br>CREATE TABLE pre_forum_threadimage (<br> `tid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> attachment varchar(255) NOT NULL default ''COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> KEY tid (tid)<br>) ENGINE=MyISAM COMMENT='主题图片表';'' <br>DROP TABLE IF EXISTS pre_forum_attachment;<br>CREATE TABLE pre_forum_attachment (<br> aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> tableid tinyint(1) unsigned NOT NULL default '0' COMMENT '附件表id',<br> downloads mediumint(8) NOT NULL default '0' COMMENT '下载次数',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件索引表';<br>DROP TABLE IF EXISTS pre_forum_attachment_exif;<br>CREATE TABLE pre_forum_attachment_exif (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> exif text NOT NULL COMMENT 'exif信息',<br> PRIMARY KEY (aid)<br>) ENGINE=MyISAM COMMENT='Exif缓存表';<br>DROP TABLE IF EXISTS pre_forum_attachment_unused;<br>CREATE TABLE pre_forum_attachment_unused (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> PRIMARY KEY (aid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='未使用附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_0;<br>CREATE TABLE pre_forum_attachment_0 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_1;<br>CREATE TABLE pre_forum_attachment_1 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_2;<br>CREATE TABLE pre_forum_attachment_2 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_3;<br>CREATE TABLE pre_forum_attachment_3 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_4;<br>CREATE TABLE pre_forum_attachment_4 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_5;<br>CREATE TABLE pre_forum_attachment_5 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_6;<br>CREATE TABLE pre_forum_attachment_6 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_7;<br>CREATE TABLE pre_forum_attachment_7 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_8;<br>CREATE TABLE pre_forum_attachment_8 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表';<br>DROP TABLE IF EXISTS pre_forum_attachment_9;<br>CREATE TABLE pre_forum_attachment_9 (<br> aid mediumint(8) unsigned NOT NULL COMMENT '附件id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default '' COMMENT '服务器路径',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> description varchar(255) NOT NULL COMMENT '说明',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ',<br> PRIMARY KEY (aid),<br> KEY tid (tid),<br> KEY pid (pid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='附件表'; <br>DROP TABLE IF EXISTS pre_forum_attachtype;<br>CREATE TABLE pre_forum_attachtype (<br> id smallint(6) unsigned NOT NULL auto_increment COMMENT '类型id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> extension char(12) NOT NULL default ''COMMENT '扩展名',<br> maxsize int(10) unsigned NOT NULL default '0' COMMENT '允许上传最大值',<br> PRIMARY KEY (id),<br> KEY fid (fid)<br>) ENGINE=MyISAM COMMENT='附件类型表';'' <br>DROP TABLE IF EXISTS pre_forum_bbcode;<br>CREATE TABLE pre_forum_bbcode (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '代码id',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用\n(0:不启用 1:启用但不显示 2:启用并显示)',<br> tag varchar(100) NOT NULL default ''COMMENT '标签',<br> icon varchar(255) NOT NULL COMMENT '图标',<br> replacement text NOT NULL COMMENT '替换内容',<br> example varchar(255) NOT NULL default '' COMMENT '例子',<br> explanation text NOT NULL COMMENT '解释说明',<br> params tinyint(1) unsigned NOT NULL default '1' COMMENT '参数个数',<br> prompt text NOT NULL COMMENT '标签描述',<br> nest tinyint(3) unsigned NOT NULL default '1' COMMENT '嵌套层次',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> perm text NOT NULL COMMENT '有权使用的用户组',<br> PRIMARY KEY (id)<br>) ENGINE=MyISAM COMMENT='Discuz! 代码表'; <br>DROP TABLE IF EXISTS pre_forum_creditslog;<br>CREATE TABLE pre_forum_creditslog (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> fromto char(15) NOT NULL default ''COMMENT '来自/到',<br> sendcredits tinyint(1) NOT NULL default '0' COMMENT '转出积分字段',<br> receivecredits tinyint(1) NOT NULL default '0' COMMENT '接受积分字段',<br> send int(10) unsigned NOT NULL default '0' COMMENT '转出积分',<br> receive int(10) unsigned NOT NULL default '0' COMMENT '接受积分',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '转帐日期',<br> operation char(3) NOT NULL default '' COMMENT '操作',<br> KEY uid (uid,dateline)<br>) ENGINE=MyISAM COMMENT='转帐记录表'; <br>DROP TABLE IF EXISTS pre_forum_debate;<br>CREATE TABLE pre_forum_debate (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起人id',<br> starttime int(10) unsigned NOT NULL default '0' COMMENT '开始时间',<br> endtime int(10) unsigned NOT NULL default '0' COMMENT '结束时间',<br> affirmdebaters mediumint(8) unsigned NOT NULL default '0' COMMENT '正方辩论人数',<br> negadebaters mediumint(8) unsigned NOT NULL default '0' COMMENT '反方辩论人数',<br> affirmvotes mediumint(8) unsigned NOT NULL default '0' COMMENT '正方得票数',<br> negavotes mediumint(8) unsigned NOT NULL default '0' COMMENT '反方得票数',<br> umpire varchar(15) NOT NULL default ''COMMENT '裁判用户名',<br> winner tinyint(1) NOT NULL default '0' COMMENT '获胜方\n(0:平局 1:为正方 2:为反方)\n裁判评判结果',<br> bestdebater varchar(50) NOT NULL default '' COMMENT '最佳辩手用户名',<br> affirmpoint text NOT NULL COMMENT '正方观点',<br> negapoint text NOT NULL COMMENT '反方观点',<br> umpirepoint text NOT NULL COMMENT '裁判观点，裁判结束辩论时填写',<br> affirmvoterids text NOT NULL COMMENT '正方投票人的 id 集合',<br> negavoterids text NOT NULL COMMENT '反方投票人的 id 集合',<br> affirmreplies mediumint(8) unsigned NOT NULL COMMENT '正方回复次数，用来翻页',<br> negareplies mediumint(8) unsigned NOT NULL COMMENT '反方回复次数，用来翻页',<br> PRIMARY KEY (tid),<br> KEY uid (uid,starttime)<br>) ENGINE=MyISAM COMMENT='辩论主题表'; <br>DROP TABLE IF EXISTS pre_forum_debatepost;<br>CREATE TABLE pre_forum_debatepost (<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> stand tinyint(1) NOT NULL default '0' COMMENT '立场\n(0:中立 1:正方 2:为反方)',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起人id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表的时间',<br> voters mediumint(10) unsigned NOT NULL default '0' COMMENT '投票人数',<br> voterids text NOT NULL COMMENT '投票人的 id 集合',<br> PRIMARY KEY (pid),<br> KEY pid (pid,stand),<br> KEY tid (tid,uid)<br>) ENGINE=MyISAM COMMENT='辩论帖子表'; <br>DROP TABLE IF EXISTS pre_forum_faq;<br>CREATE TABLE pre_forum_faq (<br> id smallint(6) NOT NULL auto_increment COMMENT '帮助id',<br> fpid smallint(6) unsigned NOT NULL default '0' COMMENT '帮助父id',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '排序',<br> identifier varchar(20) NOT NULL COMMENT '帮助标识',<br> keyword varchar(50) NOT NULL COMMENT '帮助关键词',<br> title varchar(50) NOT NULL COMMENT '帮助标题',<br> message text NOT NULL COMMENT '帮助内容',<br> PRIMARY KEY (id),<br> KEY displayplay (displayorder)<br>) ENGINE=MyISAM COMMENT='论坛帮助表'; <br>DROP TABLE IF EXISTS pre_forum_postcache;<br>CREATE TABLE pre_forum_postcache (<br> pid int(10) unsigned NOT NULL,<br> comment text NOT NULL COMMENT '点评内容缓存',<br> rate text NOT NULL COMMENT '评分情况缓存',<br> dateline int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (pid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='论坛帖子缓存表'; <br>DROP TABLE IF EXISTS pre_home_favorite;<br>CREATE TABLE pre_home_favorite (<br> favid mediumint(8) unsigned NOT NULL auto_increment COMMENT '收藏id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> id mediumint(8) unsigned NOT NULL default '0',<br> idtype varchar(255) NOT NULL default '',<br> spaceuid mediumint(8) unsigned NOT NULL default '0' COMMENT '空间会员id',<br> title varchar(255) NOT NULL default '' COMMENT '标题',<br> description text NOT NULL COMMENT '简介',<br> dateline int(10) unsigned NOT NULL default '0',<br> PRIMARY KEY (favid),<br> KEY idtype (id,idtype),<br> KEY uid (uid,idtype,dateline)<br>) ENGINE=MyISAM COMMENT='收藏表'; <br>DROP TABLE IF EXISTS pre_forum_forum;<br>CREATE TABLE pre_forum_forum (<br> fid mediumint(8) unsigned NOT NULL auto_increment COMMENT '论坛id',<br> fup mediumint(8) unsigned NOT NULL default '0' COMMENT '上级论坛id',<br> `type` enum('group','forum','sub') NOT NULL default 'forum' COMMENT '类型\n(group:分类 forum:普通论坛 sub:子论坛)',<br> `name` char(50) NOT NULL default ''COMMENT '名称',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '显示状态\n(0:隐藏 1:正常 3:群组)',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> styleid smallint(6) unsigned NOT NULL default '0' COMMENT '风格id',<br> threads mediumint(8) unsigned NOT NULL default '0' COMMENT '主题数量',<br> posts mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子数量',<br> todayposts mediumint(8) unsigned NOT NULL default '0' COMMENT '今日发帖数量',<br> lastpost char(110) NOT NULL default '' COMMENT '最后发表',<br> domain char(15) NOT NULL default ''COMMENT '绑定的二级域名',<br> allowsmilies tinyint(1) NOT NULL default '0' COMMENT '允许使用表情',<br> allowhtml tinyint(1) NOT NULL default '0' COMMENT '允许使用html',<br> allowbbcode tinyint(1) NOT NULL default '0' COMMENT '允许bbcode',<br> allowimgcode tinyint(1) NOT NULL default '0' COMMENT '允许img',<br> allowmediacode tinyint(1) NOT NULL default '0' COMMENT '允许使用多媒体代码',<br> allowanonymous tinyint(1) NOT NULL default '0' COMMENT '允许匿名',<br> allowpostspecial smallint(6) unsigned NOT NULL default '0' COMMENT '允许发表特殊主题',<br> allowspecialonly tinyint(1) unsigned NOT NULL default '0' COMMENT '只允许发表特殊主题',<br> allowappend tinyint(1) unsigned NOT NULL default '0' COMMENT '是否开启帖子补充',<br> alloweditrules tinyint(1) NOT NULL default '0' COMMENT '允许版主修改论坛规则',<br> allowfeed tinyint(1) NOT NULL default '1' COMMENT '允许推送动态,默认推送广播',<br> allowside tinyint(1) NOT NULL default '0' COMMENT '显示边栏',<br> recyclebin tinyint(1) NOT NULL default '0' COMMENT '是否启用回收站',<br> modnewposts tinyint(1) NOT NULL default '0' COMMENT '是否审核发帖',<br> jammer tinyint(1) NOT NULL default '0' COMMENT '是否启用干扰码',<br> disablewatermark tinyint(1) NOT NULL default '0' COMMENT '是否图片附件增加水印',<br> inheritedmod tinyint(1) NOT NULL default '0' COMMENT '本论坛或分类版主的权力继承到下级论坛',<br> autoclose smallint(6) NOT NULL default '0' COMMENT '自动关闭主题',<br> forumcolumns tinyint(3) unsigned NOT NULL default '0' COMMENT '增加论坛水平横排设置',<br> catforumcolumns tinyint(3) unsigned NOT NULL default '0' COMMENT '增加分区版块水平横排设置',<br> threadcaches tinyint(1) NOT NULL default '0' COMMENT '主题缓存功能设置',<br> alloweditpost tinyint(1) unsigned NOT NULL default '1' COMMENT '允许编辑帖子',<br> `simple` tinyint(1) unsigned NOT NULL default '0' COMMENT '只显示子版块',<br> modworks tinyint(1) unsigned NOT NULL default '0' COMMENT '本版有待处理的管理事项',<br> allowglobalstick tinyint(1) NOT NULL default '1' COMMENT '是否显示全局置顶',<br> level smallint(6) NOT NULL default '0' COMMENT '群组等级',<br> commoncredits int(10) unsigned NOT NULL default '0' COMMENT '群组公共积分',<br> `archive` tinyint(1) NOT NULL default '0' COMMENT '是否有存档表',<br> recommend smallint(6) unsigned NOT NULL default '0' COMMENT '推荐到的版块',<br> favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '版块或群组的收藏次数',<br> sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '版块或群组的分享次数',<br> disablethumb tinyint(1) NOT NULL default '0' COMMENT '是否添加缩略图',<br> disablecollect tinyint(1) NOT NULL default '0' COMMENT '禁止淘帖',<br> PRIMARY KEY (fid),<br> KEY forum (`status`,`type`,displayorder),<br> KEY fup_type (`fup`,`type`,displayorder),<br> KEY fup (fup)<br>) ENGINE=MyISAM COMMENT='版块表';'' <br>DROP TABLE IF EXISTS pre_forum_forumfield;<br>CREATE TABLE pre_forum_forumfield (<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '版块id',<br> description text NOT NULL COMMENT '解释说明',<br> `password` varchar(12) NOT NULL default ''COMMENT '私密论坛密码',<br> icon varchar(255) NOT NULL default '' COMMENT '图标',<br> redirect varchar(255) NOT NULL default ''COMMENT 'URL转发',<br> attachextensions varchar(255) NOT NULL default '' COMMENT '允许上传附件类型',<br> creditspolicy mediumtext NOT NULL COMMENT '版块积分策略',<br> formulaperm text NOT NULL COMMENT '版块权限表达式',<br> moderators text NOT NULL COMMENT '版主列表，格式:admin',<br> rules text NOT NULL COMMENT '版块规则',<br> threadtypes text NOT NULL COMMENT '主题分类，序列化存放的设置，格式为一个数组',<br> threadsorts text NOT NULL COMMENT '分类信息，序列化存放的设置，格式为一个数组',<br> viewperm text NOT NULL COMMENT '阅读权限, 格式: 1 4 5',<br> postperm text NOT NULL COMMENT '发表权限, 格式: 1 4 5',<br> replyperm text NOT NULL COMMENT '回复权限, 格式: 1 4 5',<br> getattachperm text NOT NULL COMMENT '下载附件权限, 格式: 1 4 5',<br> postattachperm text NOT NULL COMMENT '上传附件权限, 格式: 1 4 5',<br> postimageperm text NOT NULL COMMENT '上传图片权限, 格式: 1 4 5',<br> spviewperm text NOT NULL COMMENT '不受限于版权权限表达式, 格式: 1 4 5',<br> seotitle text NOT NULL COMMENT '版块seo标题',<br> keywords text NOT NULL COMMENT '版块seo关键词',<br> seodescription text NOT NULL COMMENT '版块seo描述',<br> supe_pushsetting text NOT NULL COMMENT 'supe推送设置，序列化存放设置数据，格式为一个数组。',<br> modrecommend text NOT NULL COMMENT '版主推荐规则',<br> threadplugin text NOT NULL COMMENT '特殊主题插件数据',<br> extra TEXT NOT NULL,<br> jointype tinyint(1) NOT NULL default '0' COMMENT '加入群组方式 -1为关闭，0为公开， 2邀请',<br> gviewperm tinyint(1) unsigned NOT NULL default '0' COMMENT '群组浏览权限 0:仅成员 1:所有用户',<br> membernum smallint(6) unsigned NOT NULL default '0' COMMENT '群组成员数',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '群组创建时间',<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '群组最后更新时间',<br> activity int(10) unsigned NOT NULL default '0' COMMENT '群组活跃度',<br> founderuid mediumint(8) unsigned NOT NULL default '0' COMMENT '群组创始人UID',<br> foundername varchar(255) NOT NULL default ''COMMENT '群组创始人名称',<br> banner varchar(255) NOT NULL default '' COMMENT '群组头图片',<br> groupnum smallint(6) unsigned NOT NULL default '0' COMMENT '分类下的群组数量',<br> commentitem TEXT NOT NULL,<br> relatedgroup TEXT NOT NULL,<br> picstyle tinyint(1) NOT NULL default '0' COMMENT '帖子列表是否以图片形式显示 0:否 1:是',<br> widthauto tinyint(1) NOT NULL default '0' COMMENT '默认是否宽屏 0:全局 -1:宽屏 1:窄屏',<br> PRIMARY KEY (fid),<br> KEY membernum (membernum),<br> KEY dateline (dateline),<br> KEY lastupdate (lastupdate),<br> KEY activity (activity)<br>) ENGINE=MyISAM COMMENT='版块扩展表'; DROP TABLE IF EXISTS pre_forum_forum_threadtable;<br>CREATE TABLE pre_forum_forum_threadtable (<br> `fid` smallint(6) unsigned NOT NULL COMMENT '版块id',<br> `threadtableid` smallint(6) unsigned NOT NULL COMMENT 'thread分区id',<br> `threads` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '主题数',<br> `posts` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '帖子数',<br> PRIMARY KEY (`fid`,`threadtableid`)<br>) ENGINE=MyISAM COMMENT='版块存档信息'; <br>DROP TABLE IF EXISTS pre_forum_forumrecommend;<br>CREATE TABLE pre_forum_forumrecommend (<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '版块id',<br> tid mediumint(8) unsigned NOT NULL COMMENT '帖子id',<br> typeid smallint(6) NOT NULL COMMENT '是否含有附件图片',<br> displayorder tinyint(1) NOT NULL COMMENT '推荐顺序',<br> `subject` char(80) NOT NULL COMMENT '推荐主题标题',<br> author char(15) NOT NULL COMMENT '推荐主题作者',<br> authorid mediumint(8) NOT NULL COMMENT '推荐主题作者id',<br> moderatorid mediumint(8) NOT NULL COMMENT '推荐管理人员id',<br> expiration int(10) unsigned NOT NULL COMMENT '推荐主题有效期',<br> position tinyint(1) NOT NULL default '0' COMMENT '显示位置',<br> highlight tinyint(1) NOT NULL default '0' COMMENT '高亮颜色',<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '附件ID',<br> filename char(100) NOT NULL default ''COMMENT '附件文件',<br> PRIMARY KEY (tid),<br> KEY displayorder (fid,displayorder),<br> KEY position (position)<br>) ENGINE=MyISAM COMMENT='版主推荐表';'' <br>DROP TABLE IF EXISTS pre_forum_imagetype;<br>CREATE TABLE pre_forum_imagetype (<br> typeid smallint(6) unsigned NOT NULL auto_increment COMMENT '分类id',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> `name` char(20) NOT NULL COMMENT '分类名称',<br> `type` enum('smiley','icon','avatar') NOT NULL default 'smiley' COMMENT '分类类型\n(smiley:表情 icon:图标 avatar:头像)',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '分类顺序',<br> `directory` char(100) NOT NULL COMMENT '图片目录',<br> PRIMARY KEY (typeid)<br>) ENGINE=MyISAM COMMENT='图片 表情 头像等 分类'; <br>DROP TABLE IF EXISTS pre_forum_medal;<br>CREATE TABLE pre_forum_medal (<br> medalid smallint(6) unsigned NOT NULL auto_increment COMMENT '勋章id',<br> `name` varchar(50) NOT NULL default ''COMMENT '勋章名称',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> image varchar(255) NOT NULL default '' COMMENT '勋章图片',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '勋章类型',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '勋章显示顺序',<br> description varchar(255) NOT NULL COMMENT '勋章描述',<br> expiration smallint(6) unsigned NOT NULL default '0' COMMENT '勋章有效期',<br> permission mediumtext NOT NULL COMMENT '勋章获得条件表达式',<br> `credit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '勋章购买使用积分',<br> `price` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '勋章价格',<br> PRIMARY KEY (medalid),<br> KEY displayorder (displayorder),<br> KEY `available` (`available`,`displayorder`)<br>) ENGINE=MyISAM COMMENT='勋章表'; <br>DROP TABLE IF EXISTS pre_forum_medallog;<br>CREATE TABLE pre_forum_medallog (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '勋章拥有着用户id',<br> medalid smallint(6) unsigned NOT NULL default '0' COMMENT '勋章id',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '勋章类型id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '颁发时间id',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '有效期id',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '勋章状态id',<br> PRIMARY KEY (id),<br> KEY `type` (`type`),<br> KEY `status` (`status`,expiration),<br> KEY uid (uid,medalid,`type`),<br> KEY `dateline` (`dateline`)<br>) ENGINE=MyISAM COMMENT='勋章日志表'; <br>DROP TABLE IF EXISTS pre_common_member_magic;<br>CREATE TABLE pre_common_member_magic (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户uid',<br> magicid smallint(6) unsigned NOT NULL default '0' COMMENT '道具id',<br> num smallint(6) unsigned NOT NULL default '0' COMMENT '拥有数量',<br> PRIMARY KEY (uid,magicid)<br>) ENGINE=MyISAM COMMENT='用户道具数据表'; <br>DROP TABLE IF EXISTS pre_common_member_medal;<br>CREATE TABLE pre_common_member_medal (<br> uid mediumint(8) unsigned NOT NULL,<br> medalid smallint(6) unsigned NOT NULL,<br> PRIMARY KEY (uid,medalid)<br>) ENGINE=MyISAM COMMENT='用户勋章数据表'; <br>DROP TABLE IF EXISTS pre_forum_memberrecommend;<br>CREATE TABLE pre_forum_memberrecommend (<br> tid mediumint(8) unsigned NOT NULL COMMENT '主题ID',<br> recommenduid mediumint(8) unsigned NOT NULL COMMENT '推荐会员ID',<br> dateline int(10) unsigned NOT NULL COMMENT '推荐时间',<br> KEY tid (tid),<br> KEY uid (recommenduid)<br>) ENGINE=MyISAM COMMENT='用户推荐表'; <br>DROP TABLE IF EXISTS pre_forum_moderator;<br>CREATE TABLE pre_forum_moderator (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> inherited tinyint(1) NOT NULL default '0' COMMENT '是否继承',<br> PRIMARY KEY (uid,fid)<br>) ENGINE=MyISAM COMMENT='版主表'; <br>DROP TABLE IF EXISTS pre_forum_modwork;<br>CREATE TABLE pre_forum_modwork (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> modaction char(3) NOT NULL default ''COMMENT '动作',<br> dateline date NOT NULL default '2006-01-01' COMMENT '时间段',<br> count smallint(6) unsigned NOT NULL default '0' COMMENT '登录次数',<br> posts smallint(6) unsigned NOT NULL default '0' COMMENT '发表数',<br> KEY uid (uid,dateline)<br>) ENGINE=MyISAM COMMENT='论坛管理统计表';'' <br>DROP TABLE IF EXISTS pre_common_mytask;<br>CREATE TABLE pre_common_mytask (<br> uid mediumint(8) unsigned NOT NULL COMMENT '用户Uid',<br> username char(15) NOT NULL default ''COMMENT '用户名',<br> taskid smallint(6) unsigned NOT NULL COMMENT '任务id',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '任务状态\n(-1:失败 0:进行中 1:已完成)',<br> csc char(255) NOT NULL default '' COMMENT '任务进度',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '申请任务时间',<br> PRIMARY KEY (uid,taskid),<br> KEY parter (taskid,dateline)<br>) ENGINE=MyISAM COMMENT='我的任务表'; <br>DROP TABLE IF EXISTS pre_forum_onlinelist;<br>CREATE TABLE pre_forum_onlinelist (<br> groupid smallint(6) unsigned NOT NULL default '0' COMMENT '会员组id',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> title varchar(30) NOT NULL default ''COMMENT '组名称',<br> url varchar(30) NOT NULL default '' COMMENT '图例URL'<br>) ENGINE=MyISAM COMMENT='在线列表定制'; <br>DROP TABLE IF EXISTS pre_forum_order;<br>CREATE TABLE pre_forum_order (<br> orderid char(32) NOT NULL default ''COMMENT '订单号id',<br> `status` char(3) NOT NULL default '' COMMENT '状态',<br> buyer char(50) NOT NULL default ''COMMENT '购买者姓名',<br> admin char(15) NOT NULL default '' COMMENT '补单管理员姓名',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '购买者id',<br> amount int(10) unsigned NOT NULL default '0' COMMENT '数量',<br> price float(7,2) unsigned NOT NULL default '0.00' COMMENT '价格',<br> submitdate int(10) unsigned NOT NULL default '0' COMMENT '提交日期',<br> confirmdate int(10) unsigned NOT NULL default '0' COMMENT '确认日期',<br> email char(40) NOT NULL default ''COMMENT '购买时的Email',<br> ip char(15) NOT NULL default '' COMMENT '购买时的IP',<br> UNIQUE KEY orderid (orderid),<br> KEY submitdate (submitdate),<br> KEY uid (uid,submitdate)<br>) ENGINE=MyISAM COMMENT='订单信息表'; <br>DROP TABLE IF EXISTS pre_forum_groupfield;<br>CREATE TABLE pre_forum_groupfield (<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '群组关联fid',<br> privacy tinyint(1) unsigned NOT NULL default '0' COMMENT '群组隐私设置',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '缓存生成时间',<br> type varchar(255) NOT NULL COMMENT '缓存类型',<br> data text NOT NULL COMMENT '缓存数据',<br> UNIQUE KEY types (fid,type),<br> KEY fid (fid),<br> KEY type (type)<br>) ENGINE = MyISAM COMMENT='群组扩展信息缓存'; <br>DROP TABLE IF EXISTS pre_forum_groupinvite;<br>CREATE TABLE pre_forum_groupinvite (<br> fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组id',<br> uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '邀请人id',<br> inviteuid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '被邀请人id',<br> dateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '邀请时间',<br> UNIQUE KEY ids (fid,inviteuid),<br> KEY dateline (dateline)<br>) ENGINE = MYISAM COMMENT='群组邀请'; <br>DROP TABLE IF EXISTS pre_forum_groupuser;<br>CREATE TABLE pre_forum_groupuser (<br> fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组关联fid',<br> uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员id',<br> username CHAR( 15 ) NOT NULL COMMENT '成员名',<br> level TINYINT( 3 ) UNSIGNED NOT NULL default '0' COMMENT '成员等级\n(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)',<br> threads MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员主题数',<br> replies MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员回复数',<br> joindateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员加入群组时间',<br> lastupdate INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员最后活动时间',<br> privacy TINYINT( 1 ) UNSIGNED NOT NULL default '0' COMMENT '成员隐私设置',<br> PRIMARY KEY (fid,uid),<br> KEY uid_lastupdate (uid,lastupdate),<br> KEY userlist (fid,level,lastupdate)<br>) ENGINE = MYISAM COMMENT='群组成员'; <br>DROP TABLE IF EXISTS pre_common_plugin;<br>CREATE TABLE pre_common_plugin (<br> pluginid smallint(6) unsigned NOT NULL auto_increment COMMENT '插件id',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> adminid tinyint(1) unsigned NOT NULL default '0' COMMENT '管理员id',<br> `name` varchar(40) NOT NULL default ''COMMENT '名称',<br> identifier varchar(40) NOT NULL default '' COMMENT '唯一标识符',<br> description varchar(255) NOT NULL default ''COMMENT '解释说明',<br> datatables varchar(255) NOT NULL default '' COMMENT '插件数据表',<br> `directory` varchar(100) NOT NULL default ''COMMENT '插件目录',<br> copyright varchar(100) NOT NULL default '' COMMENT '版权信息',<br> modules text NOT NULL COMMENT '插件信息',<br> version varchar(20) NOT NULL default ''COMMENT '插件版本',<br> PRIMARY KEY (pluginid),<br> UNIQUE KEY identifier (identifier)<br>) ENGINE=MyISAM COMMENT='插件表';'' <br>DROP TABLE IF EXISTS pre_common_pluginvar;<br>CREATE TABLE pre_common_pluginvar (<br> pluginvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '插件变量id',<br> pluginid smallint(6) unsigned NOT NULL default '0' COMMENT '插件id',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> title varchar(100) NOT NULL default ''COMMENT '名称',<br> description varchar(255) NOT NULL default '' COMMENT '解释说明',<br> variable varchar(40) NOT NULL default ''COMMENT '变量名',<br> `type` varchar(20) NOT NULL default 'text' COMMENT '类型',<br> `value` text NOT NULL COMMENT '值',<br> extra text NOT NULL COMMENT '附加',<br> PRIMARY KEY (pluginvarid),<br> KEY pluginid (pluginid)<br>) ENGINE=MyISAM COMMENT='插件变量表';'' <br>DROP TABLE IF EXISTS pre_forum_thread_moderate;<br>CREATE TABLE pre_forum_thread_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='主题审核数据表'; <br>DROP TABLE IF EXISTS pre_forum_post_moderate;<br>CREATE TABLE pre_forum_post_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='帖子审核数据表'; <br>DROP TABLE IF EXISTS pre_home_blog_moderate;<br>CREATE TABLE pre_home_blog_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='日志审核数据表'; <br>DROP TABLE IF EXISTS pre_home_pic_moderate;<br>CREATE TABLE pre_home_pic_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='图片审核数据表'; <br>DROP TABLE IF EXISTS pre_home_doing_moderate;<br>CREATE TABLE pre_home_doing_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='记录审核数据表'; <br>DROP TABLE IF EXISTS pre_home_share_moderate;<br>CREATE TABLE pre_home_share_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='分享审核数据表'; <br>DROP TABLE IF EXISTS pre_portal_article_moderate;<br>CREATE TABLE pre_portal_article_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY status (status, dateline)<br>) ENGINE=MyISAM COMMENT='文章审核数据表'; <br>DROP TABLE IF EXISTS pre_home_comment_moderate;<br>CREATE TABLE pre_home_comment_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> idtype varchar(15) NOT NULL default ''COMMENT 'ID类型',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY idtype (idtype, status, dateline)<br>) ENGINE=MyISAM COMMENT='家园评论审核数据表';'' <br>DROP TABLE IF EXISTS pre_portal_comment_moderate;<br>CREATE TABLE pre_portal_comment_moderate (<br> id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',<br> idtype varchar(15) NOT NULL default ''COMMENT 'ID类型',<br> status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (id),<br> KEY idtype (idtype, status, dateline)<br>) ENGINE=MyISAM COMMENT='文章/专题评论审核数据表';'' <br>DROP TABLE IF EXISTS pre_forum_postlog;<br>CREATE TABLE pre_forum_postlog (<br> `pid` int(10) unsigned NOT NULL DEFAULT '0',<br> `tid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> `fid` smallint(6) unsigned NOT NULL DEFAULT '0',<br> `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> `action` char(10) NOT NULL DEFAULT '',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (pid, tid),<br> KEY fid (fid),<br> KEY uid (uid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='漫游帖子日志';'' <br>DROP TABLE IF EXISTS pre_forum_threadlog;<br>CREATE TABLE pre_forum_threadlog (<br> `tid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> `fid` smallint(6) unsigned NOT NULL DEFAULT '0',<br> `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> `otherid` smallint(6) unsigned NOT NULL DEFAULT '0',<br> `action` char(10) NOT NULL,<br> `expiry` int(10) unsigned NOT NULL DEFAULT '0',<br> `dateline` int(10) unsigned NOT NULL DEFAULT '0',<br> PRIMARY KEY (tid,fid,uid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='漫游主题日志'; <br>DROP TABLE IF EXISTS pre_forum_threadpreview;<br>CREATE TABLE pre_forum_threadpreview (<br> tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题ID',<br> relay int(10) unsigned NOT NULL default '0' COMMENT '转播次数',<br> content text NOT NULL COMMENT '主题内容预览',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='服务于广播'; <br>DROP TABLE IF EXISTS pre_forum_poll;<br>CREATE TABLE pre_forum_poll (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> overt tinyint(1) NOT NULL default '0' COMMENT '是否公开投票参与人',<br> multiple tinyint(1) NOT NULL default '0' COMMENT '是否多选',<br> visible tinyint(1) NOT NULL default '0' COMMENT '是否投票后可见',<br> maxchoices tinyint(3) unsigned NOT NULL default '0' COMMENT '最大可选项数',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> pollpreview varchar(255) NOT NULL default ''COMMENT '选项内容前两项预览',<br> voters mediumint(8) unsigned NOT NULL default '0' COMMENT '投票人数',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='投票表';'' <br>DROP TABLE IF EXISTS pre_forum_pollvoter;<br>CREATE TABLE pre_forum_pollvoter (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username varchar(15) NOT NULL default ''COMMENT '会员名',<br> `options` text NOT NULL COMMENT '选项 \t 分隔',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> KEY tid (tid),<br> KEY uid (uid, dateline)<br>) ENGINE=MyISAM COMMENT='投票用户表';'' <br>DROP TABLE IF EXISTS pre_forum_polloption;<br>CREATE TABLE pre_forum_polloption (<br> polloptionid int(10) unsigned NOT NULL auto_increment COMMENT '选项id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> votes mediumint(8) unsigned NOT NULL default '0' COMMENT '票数',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序',<br> polloption varchar(80) NOT NULL default ''COMMENT '选项内容',<br> voterids mediumtext NOT NULL COMMENT '投票人id',<br> PRIMARY KEY (polloptionid),<br> KEY tid (tid,displayorder)<br>) ENGINE=MyISAM COMMENT='投票选项表';'' <br>DROP TABLE IF EXISTS pre_forum_post;<br>CREATE TABLE pre_forum_post (<br> pid int(10) unsigned NOT NULL COMMENT '帖子id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> `first` tinyint(1) NOT NULL default '0' COMMENT '是否是首贴',<br> author varchar(15) NOT NULL default ''COMMENT '作者姓名',<br> authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者id',<br> `subject` varchar(80) NOT NULL default '' COMMENT '标题',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> message mediumtext NOT NULL COMMENT '消息',<br> useip varchar(15) NOT NULL default ''COMMENT '发帖者IP',<br> invisible tinyint(1) NOT NULL default '0' COMMENT '是否通过审核',<br> anonymous tinyint(1) NOT NULL default '0' COMMENT '是否匿名',<br> usesig tinyint(1) NOT NULL default '0' COMMENT '是否启用签名',<br> htmlon tinyint(1) NOT NULL default '0' COMMENT '是否允许HTML',<br> bbcodeoff tinyint(1) NOT NULL default '0' COMMENT '是否关闭BBCODE',<br> smileyoff tinyint(1) NOT NULL default '0' COMMENT '是否关闭表情',<br> parseurloff tinyint(1) NOT NULL default '0' COMMENT '是否允许粘贴URL',<br> attachment tinyint(1) NOT NULL default '0' COMMENT '附件',<br> rate smallint(6) NOT NULL default '0' COMMENT '评分分数',<br> ratetimes tinyint(3) unsigned NOT NULL default '0' COMMENT '评分次数',<br> `status` int(10) NOT NULL default '0' COMMENT '帖子状态',<br> tags varchar(255) NOT NULL default '0' COMMENT '新增字段，用于存放tag',<br> `comment` tinyint(1) NOT NULL default '0' COMMENT '是否存在点评',<br> replycredit int(10) NOT NULL default '0' COMMENT '回帖获得积分记录',<br> `position` int(8) unsigned NOT NULL auto_increment COMMENT '帖子位置信息',<br> PRIMARY KEY (tid, `position`),<br> KEY fid (fid),<br> KEY authorid (authorid,invisible),<br> KEY dateline (dateline),<br> KEY invisible (invisible),<br> KEY displayorder (tid,invisible,dateline),<br> KEY `first` (tid,`first`),<br> UNIQUE KEY pid (pid)<br>) ENGINE=MyISAM COMMENT='帖子表';'' DROP TABLE IF EXISTS pre_forum_postcomment;<br>CREATE TABLE pre_forum_postcomment (<br> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br> `tid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID',<br> `pid` int(10) unsigned NOT NULL default '0' COMMENT '帖子ID',<br> `author` varchar(15) NOT NULL default ''COMMENT '作者',<br> `authorid` mediumint(8) NOT NULL default '0' COMMENT '作者ID x1.5以后：0为游客　-1为观点',<br> `dateline` int(10) unsigned NOT NULL default '0' COMMENT '时间',<br> `comment` varchar(255) NOT NULL default '' COMMENT '点评内容',<br> `score` tinyint(1) NOT NULL default '0' COMMENT '是否包含点评观点',<br> `useip` varchar(15) NOT NULL default ''COMMENT '发帖者IP',<br> `rpid` int(10) unsigned NOT NULL default '0' COMMENT '关联的帖子ID',<br> PRIMARY KEY (`id`),<br> KEY `tid` (`tid`),<br> KEY authorid (authorid),<br> KEY score (score),<br> KEY rpid (rpid),<br> KEY `pid` (`pid`,`dateline`)<br>) ENGINE=MyISAM COMMENT='点评帖子表';'' <br>DROP TABLE IF EXISTS pre_forum_post_location;<br>CREATE TABLE pre_forum_post_location (<br> `pid` int(10) unsigned NOT NULL DEFAULT '0',<br> `tid` mediumint(8) unsigned DEFAULT '0',<br> `uid` mediumint(8) unsigned DEFAULT '0',<br> `mapx` varchar(255) NOT NULL,<br> `mapy` varchar(255) NOT NULL,<br> `location` varchar(255) NOT NULL,<br> PRIMARY KEY (`pid`),<br> KEY `tid` (`tid`),<br> KEY `uid` (`uid`)<br>) ENGINE=MyISAM COMMENT='帖子地理位置表'; DROP TABLE IF EXISTS pre_forum_post_tableid;<br>CREATE TABLE pre_forum_post_tableid (<br> `pid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Post ID',<br> PRIMARY KEY (`pid`)<br>) ENGINE=MyISAM COMMENT='post分表协调表'; <br>DROP TABLE IF EXISTS pre_forum_poststick;<br>CREATE TABLE pre_forum_poststick (<br> `tid` mediumint(8) unsigned NOT NULL,<br> `pid` int(10) unsigned NOT NULL,<br> `position` int(10) unsigned NOT NULL,<br> `dateline` int(10) unsigned NOT NULL,<br> PRIMARY KEY (`tid`,`pid`),<br> KEY `dateline` (`tid`,`dateline`)<br>) ENGINE=MyISAM COMMENT='回帖置顶表'; <br>DROP TABLE IF EXISTS pre_forum_promotion;<br>CREATE TABLE pre_forum_promotion (<br> ip char(15) NOT NULL default ''COMMENT 'IP地址',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username char(15) NOT NULL default '' COMMENT '会员名',<br> PRIMARY KEY (ip)<br>) ENGINE=MyISAM COMMENT='论坛推广'; <br>DROP TABLE IF EXISTS pre_forum_ratelog;<br>CREATE TABLE pre_forum_ratelog (<br> pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username char(15) NOT NULL default ''COMMENT '会员名',<br> extcredits tinyint(1) unsigned NOT NULL default '0' COMMENT '评分字段',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '评分时间',<br> score smallint(6) NOT NULL default '0' COMMENT '分数',<br> reason char(40) NOT NULL default '' COMMENT '操作理由',<br> KEY pid (pid,dateline),<br> KEY dateline (dateline),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='帖子评分记录表'; <br>DROP TABLE IF EXISTS pre_forum_relatedthread;<br>CREATE TABLE pre_forum_relatedthread (<br> tid mediumint(8) NOT NULL default '0' COMMENT '主题id',<br> `type` enum('general','trade') NOT NULL default 'general' COMMENT '关键词类型',<br> expiration int(10) NOT NULL default '0' COMMENT '过期时间',<br> keywords varchar(255) NOT NULL default ''COMMENT '关键字',<br> relatedthreads text NOT NULL COMMENT '相关主题序列',<br> PRIMARY KEY (tid,`type`)<br>) ENGINE=MyISAM COMMENT='相关主题表';'' <br>DROP TABLE IF EXISTS pre_forum_rsscache;<br>CREATE TABLE pre_forum_rsscache (<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后更新时间',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> forum char(50) NOT NULL default ''COMMENT '论坛名称',<br> author char(15) NOT NULL default '' COMMENT '作者',<br> `subject` char(80) NOT NULL default ''COMMENT '标题',<br> description char(255) NOT NULL default '' COMMENT '解释说明',<br> guidetype char(10) NOT NULL default ''COMMENT '导读中的类型',<br> UNIQUE KEY tid (tid),<br> KEY fid (fid,dateline)<br>) ENGINE=MyISAM COMMENT='rss缓存表';'' <br>DROP TABLE IF EXISTS pre_forum_replycredit;<br>CREATE TABLE pre_forum_replycredit (<br> tid mediumint(6) unsigned NOT NULL COMMENT '主题tid',<br> extcredits mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '单次回复奖励额度',<br> extcreditstype tinyint(1) NOT NULL DEFAULT '0' COMMENT '本规则下奖励积分的类型',<br> times smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '回复奖励次数',<br> membertimes smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '单个用户参与次数',<br> random tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户设置的回帖奖励几率',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='主题回帖获得积分规则表'; <br>DROP TABLE IF EXISTS pre_common_searchindex;<br>CREATE TABLE pre_common_searchindex (<br> searchid int(10) unsigned NOT NULL auto_increment COMMENT '缓存id',<br> srchmod tinyint(3) unsigned NOT NULL COMMENT 'mod模块',<br> keywords varchar(255) NOT NULL default ''COMMENT '关键字',<br> searchstring text NOT NULL COMMENT '查找字符串',<br> useip varchar(15) NOT NULL default '' COMMENT '搜索人IP',<br> uid mediumint(10) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '搜索时间',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> threadsortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',<br> num smallint(6) unsigned NOT NULL default '0' COMMENT '主题数量',<br> ids text NOT NULL COMMENT '主题id序列',<br> PRIMARY KEY (searchid),<br> KEY srchmod (srchmod)<br>) ENGINE=MyISAM COMMENT='搜索缓存表';<br>DROP TABLE IF EXISTS pre_common_sphinxcounter;<br>CREATE TABLE pre_common_sphinxcounter (<br> `indexid` tinyint(1) NOT NULL,<br> `maxid` int(10) NOT NULL,<br> PRIMARY KEY (`indexid`)<br>) ENGINE=MyISAM COMMENT='Sphinx 增量索引记录表'; <br>DROP TABLE IF EXISTS pre_forum_spacecache;<br>CREATE TABLE pre_forum_spacecache (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户 uid',<br> variable varchar(20) NOT NULL COMMENT '缓存变量的名称',<br> `value` text NOT NULL COMMENT '缓存变量的值',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> PRIMARY KEY (uid,variable)<br>) ENGINE=MyISAM COMMENT='minispace缓存表'; DROP TABLE IF EXISTS pre_forum_statlog;<br>CREATE TABLE pre_forum_statlog (<br> `logdate` date NOT NULL COMMENT '日志日期',<br> `fid` mediumint(8) unsigned NOT NULL COMMENT '版块ID',<br> `type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '记录类型 <br> `value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录值',<br> PRIMARY KEY (`logdate`,`fid`)<br>) ENGINE=MyISAM COMMENT='版块统计日志表'; <br>DROP TABLE IF EXISTS pre_common_task;<br>CREATE TABLE pre_common_task (<br> taskid smallint(6) unsigned NOT NULL auto_increment COMMENT '任务id',<br> relatedtaskid smallint(6) unsigned NOT NULL default '0' COMMENT '依存任务id\n必须完成依存任务才能申请该任务',<br> available tinyint(1) NOT NULL default '0' COMMENT '是否启用',<br> `name` varchar(50) NOT NULL default ''COMMENT '任务名称',<br> description text NOT NULL COMMENT '任务描述',<br> icon varchar(150) NOT NULL default '' COMMENT '任务图标',<br> applicants mediumint(8) unsigned NOT NULL default '0' COMMENT '已申请任务人次',<br> achievers mediumint(8) unsigned NOT NULL default '0' COMMENT '已完成任务人次',<br> tasklimits mediumint(8) unsigned NOT NULL default '0' COMMENT '允许申请并完成该任务的人次上限',<br> applyperm text NOT NULL COMMENT '允许申请任务的用户组id, 格式: 1 2 3',<br> scriptname varchar(50) NOT NULL default ''COMMENT '任务脚本文件名',<br> starttime int(10) unsigned NOT NULL default '0' COMMENT '任务上线时间',<br> endtime int(10) unsigned NOT NULL default '0' COMMENT '任务下线时间',<br> period int(10) unsigned NOT NULL default '0' COMMENT '任务周期 单位：小时 默认为0表示一次性任务 设置为24即1天表示日常任务',<br> periodtype tinyint(1) NOT NULL default '0' COMMENT '任务间隔周期单位 0:小时 1:天 2:周 3:月',<br> reward enum('credit','magic','medal','invite','group') NOT NULL default 'credit' COMMENT '奖励类型\n(credit:积分 magic:道具 medal:勋章 invite:邀请码 group:特殊用户组)',<br> prize varchar(15) NOT NULL default '' COMMENT '奖品: 哪一个扩展积分, 道具id, 勋章id,邀请码有效期， 特殊用户组id',<br> bonus int(10) NOT NULL default '0' COMMENT '奖品数量/有效期: \n积分数量, 道具数量, 勋章有效期, 邀请码数量，特殊用户组有效期',<br> displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序',<br> version varchar(15) NOT NULL default ''COMMENT '任务脚本版本号',<br> PRIMARY KEY (taskid)<br>) ENGINE=MyISAM COMMENT='论坛任务表';'' <br>DROP TABLE IF EXISTS pre_common_taskvar;<br>CREATE TABLE pre_common_taskvar (<br> taskvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '任务变量id',<br> taskid smallint(6) unsigned NOT NULL default '0' COMMENT '任务id',<br> sort enum('apply','complete') NOT NULL default 'complete' COMMENT '变量类别\n(apply:申请任务条件 complete:完成任务条件)',<br> `name` varchar(100) NOT NULL default ''COMMENT '变量名称',<br> description varchar(255) NOT NULL default '' COMMENT '变量描述',<br> variable varchar(40) NOT NULL default ''COMMENT '变量名',<br> `type` varchar(20) NOT NULL default 'text' COMMENT '变量类型',<br> `value` text NOT NULL COMMENT '变量值',<br> PRIMARY KEY (taskvarid),<br> KEY taskid (taskid)<br>) ENGINE=MyISAM COMMENT='论坛任务设置表';'' <br>DROP TABLE IF EXISTS pre_forum_thread;<br>CREATE TABLE pre_forum_thread (<br> tid mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级论坛',<br> posttableid smallint(6) unsigned NOT NULL default '0' COMMENT '帖子表ID',<br> typeid smallint(6) unsigned NOT NULL default '0' COMMENT '主题分类id',<br> sortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',<br> readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限',<br> price smallint(6) NOT NULL default '0' COMMENT '价格',<br> author char(15) NOT NULL default ''COMMENT '会员名',<br> authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> `subject` char(80) NOT NULL default '' COMMENT '标题',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> lastpost int(10) unsigned NOT NULL default '0' COMMENT '最后发表',<br> lastposter char(15) NOT NULL default ''COMMENT '最后发表人id',<br> views int(10) unsigned NOT NULL default '0' COMMENT '浏览次数',<br> replies mediumint(8) unsigned NOT NULL default '0' COMMENT '回复次数',<br> displayorder tinyint(1) NOT NULL default '0' COMMENT '显示顺序',<br> highlight tinyint(1) NOT NULL default '0' COMMENT '是否高亮',<br> digest tinyint(1) NOT NULL default '0' COMMENT '是否精华',<br> rate tinyint(1) NOT NULL default '0' COMMENT '是否评分',<br> special tinyint(1) NOT NULL default '0' COMMENT '特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关',<br> attachment tinyint(1) NOT NULL default '0' COMMENT '附件,0无附件 1普通附件 2有图片附件',<br> moderated tinyint(1) NOT NULL default '0' COMMENT '是否被管理员改动',<br> closed mediumint(8) unsigned NOT NULL default '0' COMMENT '是否关闭',<br> stickreply tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有回帖置顶',<br> recommends smallint(6) NOT NULL default '0' COMMENT '推荐指数',<br> recommend_add smallint(6) NOT NULL default '0' COMMENT '支持人数',<br> recommend_sub smallint(6) NOT NULL default '0' COMMENT '反对人数',<br> heats int(10) unsigned NOT NULL default '0' COMMENT '主题热度值',<br> status smallint(6) unsigned NOT NULL default '0' ,<br> isgroup tinyint(1) NOT NULL default '0' COMMENT '是否为群组帖子',<br> favtimes mediumint(8) NOT NULL default '0' COMMENT '主题收藏次数',<br> sharetimes mediumint(8) NOT NULL default '0' COMMENT '主题分享次数',<br> `stamp` tinyint(3) NOT NULL default '-1' COMMENT '主题图章',<br> `icon` tinyint(3) NOT NULL default '-1' COMMENT '主题图标',<br> pushedaid mediumint(8) NOT NULL default '0' COMMENT '被推送到的文章aid',<br> cover smallint(6) NOT NULL default '0' COMMENT '主题封面 负数:远程　正数:本地 0:无封面',<br> replycredit smallint(6) NOT NULL default '0' COMMENT '回帖奖励积分主题记录积分值',<br> relatebytag char(255) NOT NULL default '0' COMMENT '根据帖子标签取的相关主题id (time /t tid,...)',<br> maxposition int(8) unsigned NOT NULL default '0' COMMENT '最大回帖位置信息',<br> PRIMARY KEY (tid),<br> KEY digest (digest),<br> KEY sortid (sortid),<br> KEY displayorder (fid,displayorder,lastpost),<br> KEY typeid (fid,typeid,displayorder,lastpost),<br> KEY recommends (recommends),<br> KEY heats (heats),<br> KEY authorid (authorid),<br> KEY isgroup (isgroup, lastpost),<br> KEY special (special)<br>) ENGINE=MyISAM COMMENT='主题表';'' <br>DROP TABLE IF EXISTS pre_forum_threadaddviews;<br>CREATE TABLE pre_forum_threadaddviews (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> addviews int(10) unsigned NOT NULL default '0' COMMENT '浏览次数',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='主题查看数延时更新表'; <br>DROP TABLE IF EXISTS pre_forum_threaddisablepos;<br>CREATE TABLE pre_forum_threaddisablepos (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> PRIMARY KEY (tid)<br>) ENGINE=MEMORY COMMENT='主题有楼层不准确时不使用position查询'; <br>DROP TABLE IF EXISTS pre_forum_threadclosed;<br>CREATE TABLE pre_forum_threadclosed (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '对应源主题',<br> redirect mediumint(8) unsigned NOT NULL default '0' COMMENT '保留的指向 tid',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='主题转移后保留的指向记录'; <br>DROP TABLE IF EXISTS pre_forum_threadmod;<br>CREATE TABLE pre_forum_threadmod (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username char(15) NOT NULL default ''COMMENT '会员名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '操作时间',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '有效时间',<br> `action` char(5) NOT NULL default '' COMMENT '操作',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '状态',<br> magicid smallint(6) unsigned NOT NULL COMMENT '使用道具id',<br> `stamp` TINYINT(3) NOT NULL COMMENT '主题图章/图标 ID',<br> reason char(40) NOT NULL DEFAULT ''COMMENT '操作原因',<br> KEY tid (tid,dateline),<br> KEY expiration (expiration,`status`)<br>) ENGINE=MyISAM COMMENT='主题管理记录表';'' <br>DROP TABLE IF EXISTS pre_forum_threadpartake;<br>CREATE TABLE pre_forum_threadpartake (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '参与时间',<br> KEY tid (tid,uid)<br>) ENGINE=MyISAM COMMENT='主题参与者记录表'; <br>DROP TABLE IF EXISTS pre_forum_threadrush;<br>CREATE TABLE pre_forum_threadrush (<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',<br> stopfloor mediumint(8) unsigned NOT NULL default '0' COMMENT '截止楼层',<br> starttimefrom int(10) unsigned NOT NULL default '0' COMMENT '开始时间',<br> starttimeto int(10) unsigned NOT NULL default '0' COMMENT '结束时间',<br> rewardfloor text NOT NULL default ''COMMENT '奖励楼层',<br> creditlimit int(10) NOT NULL default '-996' COMMENT '积分下限',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='抢楼设置表';'' <br>DROP TABLE IF EXISTS pre_forum_threadtype;<br>CREATE TABLE pre_forum_threadtype (<br> typeid smallint(6) unsigned NOT NULL auto_increment COMMENT '分类信息id',<br> `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> `name` varchar(255) NOT NULL default ''COMMENT '名称',<br> description varchar(255) NOT NULL default '' COMMENT '解释说明',<br> `icon` varchar(255) NOT NULL default ''COMMENT '分类图标URL',<br> special smallint(6) NOT NULL default '0' COMMENT '分类状态',<br> modelid smallint(6) unsigned NOT NULL default '0' COMMENT '分类模型id',<br> expiration tinyint(1) NOT NULL default '0' COMMENT '分类有效期',<br> template text NOT NULL COMMENT '分类信息内容模板',<br> stemplate text NOT NULL COMMENT '分类信息主题模板',<br> ptemplate text NOT NULL COMMENT '分类信息发帖模板',<br> btemplate text NOT NULL COMMENT '分类信息模块调用模板',<br> PRIMARY KEY (typeid)<br>) ENGINE=MyISAM COMMENT='分类信息表';'' <br>DROP TABLE IF EXISTS pre_forum_trade;<br>CREATE TABLE pre_forum_trade (<br> tid mediumint(8) unsigned NOT NULL COMMENT '主题id',<br> pid int(10) unsigned NOT NULL COMMENT '帖子id',<br> typeid smallint(6) unsigned NOT NULL COMMENT '主题分类id',<br> sellerid mediumint(8) unsigned NOT NULL COMMENT '卖家id',<br> seller char(15) NOT NULL COMMENT '卖家名',<br> account char(50) NOT NULL COMMENT '卖家帐号',<br> tenpayaccount char(20) NOT NULL default ''COMMENT '卖家财付通账号',<br> `subject` char(100) NOT NULL COMMENT '标题',<br> price decimal(8,2) NOT NULL COMMENT '价格',<br> amount smallint(6) unsigned NOT NULL default '1' COMMENT '数量',<br> quality tinyint(1) unsigned NOT NULL default '0' COMMENT '成色',<br> locus char(20) NOT NULL COMMENT '所在地',<br> transport tinyint(1) NOT NULL default '0' COMMENT '物流方式',<br> ordinaryfee smallint(4) unsigned NOT NULL default '0' COMMENT '平邮附加费',<br> expressfee smallint(4) unsigned NOT NULL default '0' COMMENT '快递附加费',<br> emsfee smallint(4) unsigned NOT NULL default '0' COMMENT 'EMS附加费',<br> itemtype tinyint(1) NOT NULL default '0' COMMENT '商品类型',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '交易时间',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',<br> lastbuyer char(15) NOT NULL COMMENT '最后买家用户名',<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后交易时间',<br> totalitems smallint(5) unsigned NOT NULL default '0' COMMENT '总交易量',<br> tradesum decimal(8,2) NOT NULL default '0.00' COMMENT '总交易额',<br> closed tinyint(1) NOT NULL default '0' COMMENT '是否关闭',<br> aid mediumint(8) unsigned NOT NULL COMMENT '商品图片的 Aid',<br> displayorder tinyint(1) NOT NULL COMMENT '显示顺序',<br> costprice decimal(8,2) NOT NULL COMMENT '商品原价',<br> credit int(10) unsigned NOT NULL default '0' COMMENT '积分价格',<br> costcredit int(10) unsigned NOT NULL default '0' COMMENT '积分原价',<br> credittradesum int(10) unsigned NOT NULL default '0' COMMENT '总积分交易额',<br> PRIMARY KEY (tid,pid),<br> KEY pid (pid),<br> KEY sellerid (sellerid),<br> KEY totalitems (totalitems),<br> KEY tradesum (tradesum),<br> KEY displayorder (tid,displayorder),<br> KEY sellertrades (sellerid,tradesum,totalitems),<br> KEY typeid (typeid),<br> KEY credittradesum (credittradesum),<br> KEY expiration (expiration)<br>) ENGINE=MyISAM COMMENT='商品数据表';'' DROP TABLE IF EXISTS pre_forum_threadclass;<br>CREATE TABLE pre_forum_threadclass (<br> `typeid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',<br> `fid` mediumint(8) unsigned NOT NULL COMMENT '所属版块ID',<br> `name` varchar(255) NOT NULL COMMENT '分类名称',<br> `displayorder` mediumint(9) NOT NULL COMMENT '显示顺序',<br> `icon` varchar(255) NOT NULL COMMENT '分类图标URL',<br> `moderators` tinyint(1) NOT NULL default '0' COMMENT '仅管理者可用',<br> PRIMARY KEY (`typeid`),<br> KEY fid (fid, displayorder)<br>) ENGINE=MyISAM COMMENT='主题分类表'; <br>DROP TABLE IF EXISTS pre_forum_tradecomment;<br>CREATE TABLE pre_forum_tradecomment (<br> id mediumint(8) NOT NULL auto_increment COMMENT 'id',<br> orderid char(32) NOT NULL COMMENT '订单 id',<br> pid int(10) unsigned NOT NULL COMMENT '帖子 id',<br> `type` tinyint(1) NOT NULL COMMENT '类型',<br> raterid mediumint(8) unsigned NOT NULL COMMENT '评价方会员id',<br> rater char(15) NOT NULL COMMENT '评价方用户名',<br> rateeid mediumint(8) unsigned NOT NULL COMMENT '被评价方会员id',<br> ratee char(15) NOT NULL COMMENT '被评价方用户名',<br> message char(200) NOT NULL COMMENT '评价内容',<br> explanation char(200) NOT NULL COMMENT '解释',<br> score tinyint(1) NOT NULL COMMENT '评分',<br> dateline int(10) unsigned NOT NULL COMMENT '评价时间',<br> PRIMARY KEY (id),<br> KEY raterid (raterid,`type`,dateline),<br> KEY rateeid (rateeid,`type`,dateline),<br> KEY orderid (orderid)<br>) ENGINE=MyISAM COMMENT='信用评价'; <br>DROP TABLE IF EXISTS pre_forum_tradelog;<br>CREATE TABLE pre_forum_tradelog (<br> tid mediumint(8) unsigned NOT NULL COMMENT '主题id',<br> pid int(10) unsigned NOT NULL COMMENT '帖子id',<br> orderid varchar(32) NOT NULL COMMENT '订单号id',<br> tradeno varchar(32) NOT NULL COMMENT '支付宝订单号',<br> paytype tinyint(1) unsigned NOT NULL default '0' COMMENT '在线支付方式',<br> `subject` varchar(100) NOT NULL COMMENT '标题',<br> price decimal(8,2) NOT NULL default '0.00' COMMENT '价格',<br> quality tinyint(1) unsigned NOT NULL default '0' COMMENT '成色',<br> itemtype tinyint(1) NOT NULL default '0' COMMENT '商品类型',<br> number smallint(5) unsigned NOT NULL default '0' COMMENT '数量',<br> tax decimal(6,2) unsigned NOT NULL default '0.00' COMMENT '交易手续费',<br> locus varchar(100) NOT NULL COMMENT '物品所在地',<br> sellerid mediumint(8) unsigned NOT NULL COMMENT '卖家id',<br> seller varchar(15) NOT NULL COMMENT '卖家名',<br> selleraccount varchar(50) NOT NULL COMMENT '卖家交易帐号',<br> tenpayaccount varchar(20) NOT NULL default '0' COMMENT '卖家财付通账号',<br> buyerid mediumint(8) unsigned NOT NULL COMMENT '买家id',<br> buyer varchar(15) NOT NULL COMMENT '买家名',<br> buyercontact varchar(50) NOT NULL COMMENT '买家联系方式',<br> buyercredits smallint(5) unsigned NOT NULL default '0' COMMENT '买家暂扣积分',<br> buyermsg varchar(200) default NULL COMMENT '买家留言',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '状态',<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '状态最后更新',<br> offline tinyint(1) NOT NULL default '0' COMMENT '是否离线交易',<br> buyername varchar(50) NOT NULL COMMENT '买家姓名',<br> buyerzip varchar(10) NOT NULL COMMENT '买家邮编',<br> buyerphone varchar(20) NOT NULL COMMENT '买家电话',<br> buyermobile varchar(20) NOT NULL COMMENT '买家手机',<br> transport tinyint(1) NOT NULL default '0' COMMENT '运输方式',<br> transportfee smallint(6) unsigned NOT NULL default '0' COMMENT '运输费用',<br> baseprice decimal(8,2) NOT NULL COMMENT '商品原价',<br> discount tinyint(1) NOT NULL default '0' COMMENT '折扣',<br> ratestatus tinyint(1) NOT NULL default '0' COMMENT '评价状态',<br> message text NOT NULL COMMENT '订单留言',<br> credit int(10) unsigned NOT NULL default '0' COMMENT '积分价格',<br> basecredit int(10) unsigned NOT NULL default '0' COMMENT '积分原价',<br> UNIQUE KEY orderid (orderid),<br> KEY sellerid (sellerid),<br> KEY buyerid (buyerid),<br> KEY `status` (`status`),<br> KEY buyerlog (buyerid,`status`,lastupdate),<br> KEY sellerlog (sellerid,`status`,lastupdate),<br> KEY tid (tid,pid),<br> KEY pid (pid)<br>) ENGINE=MyISAM COMMENT='交易记录表'; <br>DROP TABLE IF EXISTS pre_forum_typeoption;<br>CREATE TABLE pre_forum_typeoption (<br> optionid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类信息项目ID',<br> classid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '分类信息上级项目ID',<br> displayorder tinyint(3) NOT NULL DEFAULT '0' COMMENT '分类信息排序',<br> expiration tinyint(1) NOT NULL COMMENT '分类信息项目是否受有效期限制',<br> protect varchar(255) NOT NULL COMMENT '分类信息项目是否是保护项目',<br> title varchar(255) NOT NULL DEFAULT ''COMMENT '分类信息项目标题',<br> description varchar(255) NOT NULL DEFAULT '' COMMENT '分类信息项目描述',<br> identifier varchar(255) NOT NULL DEFAULT ''COMMENT '分类信息项目标识',<br> `type` varchar(255) NOT NULL DEFAULT '' COMMENT '分类信息项目类型',<br> unit varchar(255) NOT NULL COMMENT '分类信息项目单位',<br> rules mediumtext NOT NULL COMMENT '分类信息项目规则',<br> permprompt mediumtext NOT NULL COMMENT '分类信息项目权限提示',<br> PRIMARY KEY (optionid),<br> KEY classid (classid)<br>) ENGINE=MyISAM COMMENT='分类信息设置项目表'; <br>DROP TABLE IF EXISTS pre_forum_typeoptionvar;<br>CREATE TABLE pre_forum_typeoptionvar (<br> sortid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息id',<br> tid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类信息数据对应帖子id',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类信息数据对应帖子板块id',<br> optionid smallint(6) unsigned NOT NULL default '0' COMMENT '分类信息数据对应选项id',<br> expiration int(10) unsigned NOT NULL default '0' COMMENT '分类信息数据有效期',<br> `value` mediumtext NOT NULL COMMENT '分类信息数据数值',<br> KEY sortid (sortid),<br> KEY tid (tid),<br> KEY fid (fid)<br>) ENGINE=MyISAM COMMENT='分类信息项目数据表'; <br>DROP TABLE IF EXISTS pre_forum_typevar;<br>CREATE TABLE pre_forum_typevar (<br> sortid smallint(6) NOT NULL default '0' COMMENT '分类信息id',<br> optionid smallint(6) NOT NULL default '0' COMMENT '分类信息对应项目id',<br> available tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可用',<br> required tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否必填',<br> unchangeable tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可修改',<br> search tinyint(1) NOT NULL default '0' COMMENT '分类信息对应项目是否可搜索',<br> displayorder tinyint(3) NOT NULL default '0' COMMENT '分类信息对应项目顺序',<br> subjectshow TINYINT(1) NOT NULL DEFAULT '0',<br> UNIQUE KEY optionid (sortid,optionid),<br> KEY sortid (sortid)<br>) ENGINE=MyISAM COMMENT='分类信息对应项目表'; <br>DROP TABLE IF EXISTS pre_forum_warning;<br>CREATE TABLE pre_forum_warning (<br> wid smallint(6) unsigned NOT NULL auto_increment COMMENT '记录id',<br> pid int(10) unsigned NOT NULL COMMENT '帖子 pid',<br> operatorid mediumint(8) unsigned NOT NULL COMMENT '警告者 Uid',<br> operator char(15) NOT NULL COMMENT '警告者用户名',<br> authorid mediumint(8) unsigned NOT NULL COMMENT '被警告者 uid',<br> author char(15) NOT NULL COMMENT '被警告者用户名',<br> dateline int(10) unsigned NOT NULL COMMENT '警告时间',<br> reason char(40) NOT NULL COMMENT '警告原因',<br> PRIMARY KEY (wid),<br> UNIQUE KEY pid (pid),<br> KEY authorid (authorid)<br>) ENGINE=MyISAM COMMENT='警告记录表'; <br> DROP TABLE IF EXISTS pre_home_album;<br>CREATE TABLE pre_home_album (<br> albumid mediumint(8) unsigned NOT NULL auto_increment COMMENT '相册ID ',<br> albumname varchar(50) NOT NULL default ''COMMENT '相册名字',<br> catid smallint(6) unsigned NOT NULL default '0' COMMENT '相册系统分类',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '相册用户ID ',<br> username varchar(15) NOT NULL default '' COMMENT '相册用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '相册建立时间戳',<br> updatetime int(10) unsigned NOT NULL default '0' COMMENT '相册最后修改时间戳',<br> picnum smallint(6) unsigned NOT NULL default '0' COMMENT '相册照片数量',<br> pic varchar(60) NOT NULL default ''COMMENT '相册封面照片',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '相册是否有图片',<br> friend tinyint(1) NOT NULL default '0' COMMENT '相册隐私设置:"0"全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 ',<br> `password` varchar(10) NOT NULL default '' COMMENT '相册密码',<br> target_ids text NOT NULL COMMENT '允许查看相册的用户ID,多个用户ID用"m"间隔 ',<br> favtimes mediumint(8) unsigned NOT NULL COMMENT '相册收藏次数',<br> sharetimes mediumint(8) unsigned NOT NULL COMMENT '相册分享次数',<br> depict text NOT NULL COMMENT '相册描述 ',<br> PRIMARY KEY (albumid),<br> KEY uid (uid,updatetime),<br> KEY updatetime (updatetime)<br>) ENGINE=MyISAM COMMENT='相册表'; <br>DROP TABLE IF EXISTS pre_home_appcreditlog;<br>CREATE TABLE pre_home_appcreditlog (<br> logid mediumint(8) unsigned NOT NULL auto_increment COMMENT '序列id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户id',<br> appid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户名',<br> appname varchar(60) NOT NULL default ''COMMENT '应用名称',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '积分转入转出类型',<br> credit mediumint(8) unsigned NOT NULL default '0' COMMENT '积分数',<br> note text NOT NULL COMMENT '备注',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '操作时间',<br> PRIMARY KEY (logid),<br> KEY uid (uid,dateline),<br> KEY appid (appid)<br>) ENGINE=MyISAM COMMENT='漫游应用积分操作记录表';'' <br>DROP TABLE IF EXISTS pre_home_blacklist;<br>CREATE TABLE pre_home_blacklist (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',<br> buid mediumint(8) unsigned NOT NULL default '0' COMMENT '被屏蔽的用户ID ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '被屏蔽的时间戳',<br> PRIMARY KEY (uid,buid),<br> KEY uid (uid,dateline)<br>) ENGINE=MyISAM COMMENT='屏蔽黑名单表'; <br>DROP TABLE IF EXISTS pre_common_block;<br>CREATE TABLE pre_common_block (<br> bid mediumint(8) unsigned NOT NULL auto_increment COMMENT '模块ID',<br> blockclass varchar(255) NOT NULL default '0' COMMENT '模块分类 article/pic/member/board/poll',<br> blocktype tinyint(1) NOT NULL default '0' COMMENT '调用类型 0为模板调用 1为js调用',<br> `name` varchar(255) NOT NULL default ''COMMENT '模块标名称',<br> title text NOT NULL COMMENT '模块标题名',<br> classname varchar(255) NOT NULL default '' COMMENT '指定样式class',<br> summary text NOT NULL COMMENT '模块自定义内容',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '创建者用户ID ',<br> username varchar(255) NOT NULL default ''COMMENT '创建者用户名',<br> styleid smallint(6) unsigned NOT NULL default '0' COMMENT '模块风格ID',<br> blockstyle text NOT NULL COMMENT '自定义风格',<br> picwidth smallint(6) unsigned NOT NULL default '0' COMMENT '显示图片长度',<br> picheight smallint(6) unsigned NOT NULL default '0' COMMENT '显示图片宽度',<br> target varchar(255) NOT NULL default '' COMMENT '模块链接打开方式: _blank, _self, _top',<br> dateformat varchar(255) NOT NULL default ''COMMENT '时间格式： H:i； u； Y-m-d等',<br> dateuformat tinyint(1) NOT NULL default '0' COMMENT '是否使用个性化时间格式',<br> script varchar(255) NOT NULL default '' COMMENT '模块获取数据脚本名',<br> param text NOT NULL COMMENT '模块参数配置序列化存储',<br> shownum smallint(6) unsigned NOT NULL default '0' COMMENT '获取数据数目',<br> cachetime int(10) NOT NULL default '0' COMMENT '模块缓存更新时间间隔',<br> cachetimerange char(5) NOT NULL default ''COMMENT '模块缓存更新时间区间',<br> punctualupdate tinyint(1) NOT NULL default '0' COMMENT '是否严格按照缓存时间更新（忽略优化）',<br> hidedisplay tinyint(1) NOT NULL default '0' COMMENT '是否屏蔽输出',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '模块缓存创建时间戳',<br> notinherited tinyint(1) NOT NULL default '0' COMMENT '是否继承所在页面权限',<br> isblank tinyint(1) NOT NULL default '0' COMMENT '是否为空白模块，只显示准送数据',<br> PRIMARY KEY (bid)<br>) ENGINE=MyISAM COMMENT='模块表';'' <br>DROP TABLE IF EXISTS pre_common_block_style;<br>CREATE TABLE pre_common_block_style (<br> styleid smallint(6) unsigned NOT NULL auto_increment COMMENT '模块样式ID',<br> blockclass varchar(255) NOT NULL default ''COMMENT '模块分类',<br> `name` varchar(255) NOT NULL default '' COMMENT '样式名称',<br> template text NOT NULL COMMENT '样式模板',<br> `hash` varchar(255) NOT NULL default ''COMMENT '样式hash（blockclass + template）',<br> getpic tinyint(1) NOT NULL default '0' COMMENT '是否需要获取pic数据',<br> getsummary tinyint(1) NOT NULL default '0' COMMENT '是否需要获取summary数据',<br> makethumb tinyint(1) NOT NULL default '0' COMMENT '是否需要block设置缩略图',<br> settarget tinyint(1) NOT NULL default '0' COMMENT '是否需要设置链接打开方式',<br> `fields` text NOT NULL COMMENT '模板中用到的模块分类字段',<br> moreurl tinyint(1) NOT NULL default '0' COMMENT '是否有更多链接',<br> PRIMARY KEY (styleid),<br> KEY `hash` (`hash`),<br> KEY `blockclass` (`blockclass`)<br>) ENGINE=MyISAM COMMENT='模块模板表';'' <br>DROP TABLE IF EXISTS pre_common_block_item;<br>CREATE TABLE pre_common_block_item (<br> itemid int(10) unsigned NOT NULL auto_increment COMMENT '信息ID',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',<br> id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',<br> idtype varchar(255) NOT NULL default ''COMMENT '来源ID TYPE，手工添加数据为rand',<br> itemtype tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为自动 1为手工输入 2已编辑',<br> title varchar(255) NOT NULL default '' COMMENT '信息标题名',<br> url varchar(255) NOT NULL default ''COMMENT '信息链接地址',<br> pic varchar(255) NOT NULL default '' COMMENT '信息图片',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',<br> makethumb tinyint(1) NOT NULL default '0' COMMENT '是否已生成缩略图 1:生成成功; 2:生成失败',<br> thumbpath varchar(255) NOT NULL default ''COMMENT '缩略图地址',<br> summary text NOT NULL COMMENT '信息摘要',<br> showstyle text NOT NULL COMMENT '显示样式',<br> related text NOT NULL COMMENT '相关链接',<br> `fields` text NOT NULL COMMENT '信息附属num/author/authorid/dateline',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> startdate int(10) unsigned NOT NULL default '0' COMMENT '开始时间戳',<br> enddate int(10) unsigned NOT NULL default '0' COMMENT '结束时间戳',<br> PRIMARY KEY (itemid),<br> KEY bid (bid)<br>) ENGINE=MyISAM COMMENT='模块数据表';'' <br>DROP TABLE IF EXISTS pre_common_block_pic;<br>CREATE TABLE pre_common_block_pic (<br> picid int(10) unsigned NOT NULL auto_increment COMMENT '图片ID',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',<br> itemid int(10) unsigned NOT NULL default '0' COMMENT '信息ID',<br> pic varchar(255) NOT NULL default ''COMMENT '信息图片',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为本地 1为ftp远程',<br> `type` tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为模块缩略图 1为上传的图',<br> PRIMARY KEY (picid),<br> KEY bid (bid,itemid)<br>) ENGINE=MyISAM COMMENT='模块使用图片表';'' <br>DROP TABLE IF EXISTS pre_common_block_item_data;<br>CREATE TABLE pre_common_block_item_data (<br> dataid int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '推荐信息ID',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',<br> id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',<br> idtype varchar(255) NOT NULL default ''COMMENT '来源ID TYPE',<br> itemtype tinyint(1) NOT NULL default '0' COMMENT '信息类型 0为自动 1为手工输入 3推荐数据',<br> title varchar(255) NOT NULL default '' COMMENT '信息标题名',<br> url varchar(255) NOT NULL default ''COMMENT '信息链接地址',<br> pic varchar(255) NOT NULL default '' COMMENT '信息图片',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',<br> makethumb tinyint(1) NOT NULL default '0' COMMENT '是否已生成缩略图',<br> summary text NOT NULL COMMENT '信息摘要',<br> showstyle text NOT NULL COMMENT '显示样式',<br> related text NOT NULL COMMENT '相关链接',<br> `fields` text NOT NULL COMMENT '信息附属num/author/authorid/dateline',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> startdate int(10) unsigned NOT NULL default '0' COMMENT '开始时间戳',<br> enddate int(10) unsigned NOT NULL default '0' COMMENT '结束时间戳',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '推荐者 UID',<br> username varchar(255) NOT NULL DEFAULT ''COMMENT '推荐者用户名',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推荐日期',<br> isverified tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已通过审核',<br> verifiedtime int(10) unsigned NOT NULL DEFAULT '0' COMMENT '通过审核日期',<br> stickgrade tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '置顶等级： 0～10',<br> PRIMARY KEY (dataid),<br> KEY bid (bid, stickgrade, verifiedtime)<br>) ENGINE=MyISAM COMMENT='模块推荐信息表';'' <br>DROP TABLE IF EXISTS pre_common_block_xml;<br>CREATE TABLE pre_common_block_xml (<br> `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',<br> `name` varchar(255) NOT NULL COMMENT 'XML扩展 名称',<br> `version` varchar(255) NOT NULL COMMENT 'XML扩展 版本',<br> `url` varchar(255) NOT NULL COMMENT 'XML扩展 URL',<br> `clientid` varchar(255) NOT NULL COMMENT '客户端ID',<br> `key` varchar(255) NOT NULL COMMENT '通信密钥',<br> `signtype` varchar(255) NOT NULL COMMENT '签名的加密方式：目前只支持MD5方式，空为不使用签名，直接使用通信密钥',<br> `data` text NOT NULL COMMENT 'XML扩展 数据',<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM COMMENT='模块 XML 扩展类数据表'; <br>DROP TABLE IF EXISTS pre_common_block_favorite;<br>CREATE TABLE pre_common_block_favorite (<br> favid mediumint(8) unsigned NOT NULL auto_increment COMMENT '收藏id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '收藏时间',<br> PRIMARY KEY (favid),<br> KEY uid (uid,dateline)<br>) ENGINE=MyISAM COMMENT='模块收藏表'; <br>DROP TABLE IF EXISTS pre_home_blog;<br>CREATE TABLE pre_home_blog (<br> blogid mediumint(8) unsigned NOT NULL auto_increment COMMENT '日志ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志所属用户ID ',<br> username char(15) NOT NULL default ''COMMENT '日志所属用户名',<br> `subject` char(80) NOT NULL default '' COMMENT '日志标题',<br> classid smallint(6) unsigned NOT NULL default '0' COMMENT '个人分类id',<br> catid smallint(6) unsigned NOT NULL default '0' COMMENT '系统分类id',<br> viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '日志查看数',<br> replynum mediumint(8) unsigned NOT NULL default '0' COMMENT '日志回复数',<br> hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '日志发布时间',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '日志是否有图片',<br> noreply tinyint(1) NOT NULL default '0' COMMENT '是否允许评论:"0"为允许,"1"为不允许 ',<br> friend tinyint(1) NOT NULL default '0' COMMENT '日志隐私设置:"0"为全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 ',<br> `password` char(10) NOT NULL default ''COMMENT '日志密码',<br> favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '日志收藏次数',<br> sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '日志分享次数',<br> `status` tinyint(1) unsigned NOT NULL default '0' COMMENT 'blog状态 1-审核',<br> click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',<br> click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',<br> click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',<br> click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',<br> click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',<br> click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',<br> click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',<br> click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',<br> PRIMARY KEY (blogid),<br> KEY uid (uid,dateline),<br> KEY hot (hot),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='日志表';'' <br>DROP TABLE IF EXISTS pre_home_blogfield;<br>CREATE TABLE pre_home_blogfield (<br> blogid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志所属用户ID ',<br> pic varchar(255) NOT NULL default ''COMMENT '标题图片',<br> tag varchar(255) NOT NULL default '' COMMENT '日志TAG ',<br> message mediumtext NOT NULL COMMENT '日志内容',<br> postip varchar(255) NOT NULL default ''COMMENT '发表日志的IP ',<br> related text NOT NULL COMMENT '相关日志的数据信息',<br> relatedtime int(10) unsigned NOT NULL default '0' COMMENT '相关日志产生时间戳',<br> target_ids text NOT NULL COMMENT '允许查看日志的用户ID多个ID以","间隔 ',<br> hotuser text NOT NULL COMMENT '热点用户',<br> magiccolor tinyint(6) NOT NULL default '0' COMMENT '道具彩色灯id',<br> magicpaper tinyint(6) NOT NULL default '0' COMMENT '道具信纸id',<br> pushedaid mediumint(8) NOT NULL default '0' COMMENT '被推送到的文章aid',<br> PRIMARY KEY (blogid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='日志字段表';'' <br>DROP TABLE IF EXISTS pre_home_class;<br>CREATE TABLE pre_home_class (<br> classid mediumint(8) unsigned NOT NULL auto_increment COMMENT '个人分类id',<br> classname char(40) NOT NULL default ''COMMENT '分类名称',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类所属用户ID ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '分类创建时间戳',<br> PRIMARY KEY (classid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='日志个人分类表';'' <br>DROP TABLE IF EXISTS pre_home_click;<br>CREATE TABLE pre_home_click (<br> clickid smallint(6) unsigned NOT NULL auto_increment COMMENT '表态ID',<br> `name` char(50) NOT NULL default ''COMMENT '表态名称',<br> icon char(100) NOT NULL default '' COMMENT '表态图标',<br> idtype char(15) NOT NULL default ''COMMENT '表态类型',<br> available tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有效',<br> displayorder tinyint(6) unsigned NOT NULL default '0' COMMENT '排序',<br> PRIMARY KEY (clickid),<br> KEY idtype (idtype, displayorder)<br>) ENGINE=MyISAM COMMENT='表态动作';'' <br>DROP TABLE IF EXISTS pre_home_clickuser;<br>CREATE TABLE pre_home_clickuser (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '表态用户id',<br> username varchar(15) NOT NULL default ''COMMENT '表态用户名',<br> id mediumint(8) unsigned NOT NULL default '0' COMMENT '作用对象id',<br> idtype varchar(15) NOT NULL default '' COMMENT '作用对象id类型',<br> clickid smallint(6) unsigned NOT NULL default '0' COMMENT '表态id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表表态时间戳',<br> KEY id (id,idtype,dateline),<br> KEY uid (uid,idtype,dateline)<br>) ENGINE=MyISAM COMMENT='用户表态表'; <br>DROP TABLE IF EXISTS pre_home_comment;<br>CREATE TABLE pre_home_comment (<br> cid mediumint(8) unsigned NOT NULL auto_increment COMMENT '评论id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发表评论的用户id',<br> id mediumint(8) unsigned NOT NULL default '0' COMMENT '评论对象id',<br> idtype varchar(20) NOT NULL default ''COMMENT '评论对象的id类型：blogid，picid，uid',<br> authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '若为回复,回复作者用户ID ',<br> author varchar(15) NOT NULL default '' COMMENT '若为回复,回复作者用户名 ',<br> ip varchar(20) NOT NULL default ''COMMENT '评论IP ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '评论时间戳',<br> message text NOT NULL COMMENT '评论内容',<br> magicflicker tinyint(1) NOT NULL default '0' COMMENT '是否使用了道具彩虹炫',<br> status tinyint(1) NOT NULL default '0' COMMENT '评论状态 1-审核',<br> PRIMARY KEY (cid),<br> KEY authorid (authorid,idtype),<br> KEY id (id,idtype,dateline)<br>) ENGINE=MyISAM COMMENT='用户评论表';'' <br>DROP TABLE IF EXISTS pre_home_docomment;<br>CREATE TABLE pre_home_docomment (<br> id int(10) unsigned NOT NULL auto_increment COMMENT '记录回复id',<br> upid int(10) unsigned NOT NULL default '0' COMMENT '上级记录回复id',<br> doid mediumint(8) unsigned NOT NULL default '0' COMMENT '所评论的记录id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发布记录者用户id',<br> username varchar(15) NOT NULL default ''COMMENT '发布记录者用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '记录回复时间戳',<br> message text NOT NULL COMMENT '记录回复内容',<br> ip varchar(20) NOT NULL default '' COMMENT '发布记录ip',<br> grade smallint(6) unsigned NOT NULL default '0' COMMENT '记录回复的层级',<br> PRIMARY KEY (id),<br> KEY doid (doid,dateline),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='用户记录回复表'; <br>DROP TABLE IF EXISTS pre_home_doing;<br>CREATE TABLE pre_home_doing (<br> doid mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '记录发布者用户id',<br> username varchar(15) NOT NULL default ''COMMENT '记录发布者用户名',<br> `from` varchar(20) NOT NULL default '' COMMENT '记录的发表来源',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '记录发布时间戳',<br> message text NOT NULL COMMENT '记录内容',<br> ip varchar(20) NOT NULL default ''COMMENT '记录发布ip',<br> replynum int(10) unsigned NOT NULL default '0' COMMENT '记录回复数',<br> status tinyint(1) unsigned NOT NULL default '0' COMMENT '记录状态 1-审核',<br> PRIMARY KEY (doid),<br> KEY uid (uid,dateline),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='用户记录表';'' <br>DROP TABLE IF EXISTS pre_home_feed;<br>CREATE TABLE pre_home_feed (<br> feedid int(10) unsigned NOT NULL auto_increment COMMENT 'feed的ID ',<br> appid smallint(6) unsigned NOT NULL default '0' COMMENT '应用程序ID ',<br> icon varchar(30) NOT NULL default ''COMMENT 'feed图标 ',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '产生feed的用户ID ',<br> username varchar(15) NOT NULL default '' COMMENT '产生feed的用户名 ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT 'feed产生时间戳 ',<br> friend tinyint(1) NOT NULL default '0' COMMENT '产生feed信息的隐私设置 ',<br> hash_template varchar(32) NOT NULL default ''COMMENT '模板hash:md5(title_template"\t"body_template) ',<br> hash_data varchar(32) NOT NULL default '' COMMENT '数据内容hash:md5(title_templat"\t"title_data"\t"body_template"\t"body_data) ',<br> title_template text NOT NULL COMMENT 'feed标题模板 ',<br> title_data text NOT NULL COMMENT 'feed标题 ',<br> body_template text NOT NULL COMMENT 'feed内容模板 ',<br> body_data text NOT NULL COMMENT 'feed内容 ',<br> body_general text NOT NULL COMMENT '用户填写的信息 ',<br> image_1 varchar(255) NOT NULL default ''COMMENT 'feed图1',<br> image_1_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接1',<br> image_2 varchar(255) NOT NULL default ''COMMENT 'feed图片2',<br> image_2_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接2',<br> image_3 varchar(255) NOT NULL default ''COMMENT 'feed图片3',<br> image_3_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接3',<br> image_4 varchar(255) NOT NULL default ''COMMENT 'feed图片4',<br> image_4_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接4',<br> target_ids text NOT NULL COMMENT '产生feed信息允许查看的好友ID ',<br> id mediumint(8) unsigned NOT NULL default '0' COMMENT 'feed对应对象id',<br> idtype varchar(15) NOT NULL default ''COMMENT 'feed对应对象类型',<br> hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',<br> PRIMARY KEY (feedid),<br> KEY uid (uid,dateline),<br> KEY dateline (dateline),<br> KEY hot (hot),<br> KEY id (id,idtype)<br>) ENGINE=MyISAM COMMENT='站点feed表';'' <br>DROP TABLE IF EXISTS pre_home_feed_app;<br>CREATE TABLE pre_home_feed_app (<br> feedid int(10) unsigned NOT NULL auto_increment COMMENT '应用feed id',<br> appid smallint(6) unsigned NOT NULL default '0' COMMENT '应用程序ID',<br> icon varchar(30) NOT NULL default ''COMMENT 'feed图标 ',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '产生feed的用户ID ',<br> username varchar(15) NOT NULL default '' COMMENT '产生feed的用户名 ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT 'feed产生时间戳 ',<br> friend tinyint(1) NOT NULL default '0' COMMENT '产生feed信息的隐私设置 ',<br> hash_template varchar(32) NOT NULL default ''COMMENT '模板hash:md5(title_template"\t"body_template) ',<br> hash_data varchar(32) NOT NULL default '' COMMENT '数据内容hash:md5(title_templat"\t"title_data"\t"body_template"\t"body_data) ',<br> title_template text NOT NULL COMMENT 'feed标题模板 ',<br> title_data text NOT NULL COMMENT 'feed标题 ',<br> body_template text NOT NULL COMMENT 'feed内容模板 ',<br> body_data text NOT NULL COMMENT 'feed内容 ',<br> body_general text NOT NULL COMMENT '用户填写的信息 ',<br> image_1 varchar(255) NOT NULL default ''COMMENT 'feed图1',<br> image_1_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接1',<br> image_2 varchar(255) NOT NULL default ''COMMENT 'feed图片2',<br> image_2_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接2',<br> image_3 varchar(255) NOT NULL default ''COMMENT 'feed图片3',<br> image_3_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接3',<br> image_4 varchar(255) NOT NULL default ''COMMENT 'feed图片4',<br> image_4_link varchar(255) NOT NULL default '' COMMENT 'feed图片链接4',<br> target_ids text NOT NULL COMMENT '产生feed信息允许查看的好友ID ',<br> PRIMARY KEY (feedid),<br> KEY uid (uid,dateline),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='应该feed表'; <br>DROP TABLE IF EXISTS pre_home_friend;<br>CREATE TABLE pre_home_friend (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',<br> fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户好友ID ',<br> fusername varchar(15) NOT NULL default ''COMMENT '用户好友名',<br> gid smallint(6) unsigned NOT NULL default '0' COMMENT '好友所在的好友组ID ',<br> num mediumint(8) unsigned NOT NULL default '0' COMMENT '好友之间的任务关系数',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '加好友的时间戳',<br> note varchar(255) NOT NULL default '' COMMENT '好友备注',<br> PRIMARY KEY (uid,fuid),<br> KEY fuid (fuid),<br> KEY `uid` (uid,num,dateline)<br>) ENGINE=MyISAM COMMENT='用户好友表'; <br>DROP TABLE IF EXISTS pre_home_friend_request;<br>CREATE TABLE pre_home_friend_request (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',<br> fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '被请求用户ID ',<br> fusername char(15) NOT NULL default ''COMMENT '被请求用户名称',<br> gid smallint(6) unsigned NOT NULL default '0' COMMENT '好友所在的好友组ID ',<br> note char(60) NOT NULL default '' COMMENT '申请附言',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '请求好友时间戳',<br> PRIMARY KEY (uid,fuid),<br> KEY fuid (fuid),<br> KEY `dateline` (uid, dateline)<br>) ENGINE=MyISAM COMMENT='申请好友表'; <br>DROP TABLE IF EXISTS pre_home_friendlog;<br>CREATE TABLE pre_home_friendlog (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',<br> fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '好友用户ID ',<br> `action` varchar(10) NOT NULL default ''COMMENT '好友动作:"add"添加,"update"更新 ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '好友动作时间',<br> PRIMARY KEY (uid,fuid)<br>) ENGINE=MyISAM COMMENT='用户好友动作日志表';'' <br>DROP TABLE IF EXISTS pre_common_magiclog;<br>CREATE TABLE pre_common_magiclog (<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',<br> magicid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '道具id',<br> action tinyint(1) NOT NULL DEFAULT '0' COMMENT '操作动作 1 购买 2 使用 3 赠送',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',<br> amount smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '操作数量',<br> credit tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作积分',<br> price mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '操作价格',<br> `targetid` int(10) unsigned NOT NULL DEFAULT '0',<br> `idtype` char(6) DEFAULT NULL,<br> targetuid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '道具目标uid',<br> KEY uid (uid,dateline),<br> KEY `action` (`action`),<br> KEY targetuid (targetuid,dateline),<br> KEY magicid (magicid,dateline)<br>) ENGINE=MyISAM COMMENT='道具日志表'; <br>DROP TABLE IF EXISTS pre_common_magic;<br>CREATE TABLE pre_common_magic (<br> magicid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '道具id',<br> available tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可用',<br> name varchar(50) NOT NULL COMMENT '名称',<br> identifier varchar(40) NOT NULL COMMENT '唯一标识',<br> description varchar(255) NOT NULL COMMENT '描述',<br> displayorder tinyint(3) NOT NULL DEFAULT '0' COMMENT '顺序',<br> credit tinyint(1) NOT NULL DEFAULT '0' COMMENT '使用的积分',<br> price mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '价格',<br> num smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '数量',<br> salevolume smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '销售量',<br> supplytype tinyint(1) NOT NULL DEFAULT '0' COMMENT '自动补货类型',<br> supplynum smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '自动补货数量',<br> useperoid tinyint(1) NOT NULL DEFAULT '0' COMMENT '使用周期',<br> usenum smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '周期使用数量',<br> weight tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '重量',<br> magicperm text NOT NULL COMMENT '权限',<br> useevent tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:只在特定环境使用 1:可以在道具中心使用',<br> PRIMARY KEY (magicid),<br> UNIQUE KEY identifier (identifier),<br> KEY displayorder (available,displayorder)<br>) ENGINE=MyISAM COMMENT='道具数据表'; <br>DROP TABLE IF EXISTS pre_home_notification;<br>CREATE TABLE pre_home_notification (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '通知ID ',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '通知用户ID ',<br> `type` varchar(20) NOT NULL default ''COMMENT '通知类型:"doing"记录,"friend"好友请求,"sharenotice"好友分享,"post"话题回复, ',<br> `new` tinyint(1) NOT NULL default '0' COMMENT '通知是否为新:"1"为新通知,"0"为通知已读 ',<br> authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者用户ID ',<br> author varchar(15) NOT NULL default '' COMMENT '用户名',<br> note text NOT NULL COMMENT '通知内容',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '通知产生的时间戳',<br> from_id mediumint(8) unsigned NOT NULL default '0' COMMENT '来源对象id',<br> from_idtype varchar(20) NOT NULL default ''COMMENT '来源对象类型',<br> from_num mediumint(8) unsigned NOT NULL default '0' COMMENT '来源量',<br> PRIMARY KEY (id),<br> KEY uid (uid,new,dateline),<br> KEY from_id (from_id,from_idtype)<br>) ENGINE=MyISAM COMMENT='通知表';'' <br>DROP TABLE IF EXISTS pre_home_pic;<br>CREATE TABLE pre_home_pic (<br> picid mediumint(8) NOT NULL auto_increment COMMENT '图片ID ',<br> albumid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属相册ID ',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属用户ID ',<br> username varchar(15) NOT NULL default ''COMMENT '图片所属用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '图片上传时间戳',<br> postip varchar(255) NOT NULL default '' COMMENT '图片上传ip',<br> filename varchar(255) NOT NULL default ''COMMENT '图片文件名',<br> title varchar(255) NOT NULL default '' COMMENT '图片标题',<br> `type` varchar(255) NOT NULL default ''COMMENT '图片类型',<br> size int(10) unsigned NOT NULL default '0' COMMENT '图片大小',<br> filepath varchar(255) NOT NULL default '' COMMENT '图片路径',<br> thumb tinyint(1) NOT NULL default '0' COMMENT '是否有缩略图',<br> remote tinyint(1) NOT NULL default '0' COMMENT '是否有远程图片0:home本地图片,1:home远程图片,2:论坛本地图片,3论坛远程图片',<br> hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',<br> sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '图片分享次数',<br> click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',<br> click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',<br> click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',<br> click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',<br> click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',<br> click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',<br> click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',<br> click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',<br> magicframe tinyint(6) NOT NULL default '0' COMMENT '道具使用相框id',<br> status tinyint(1) unsigned NOT NULL default '0' COMMENT '图片状态 1-审核',<br> PRIMARY KEY (picid),<br> KEY uid (uid),<br> KEY albumid (albumid,dateline)<br>) ENGINE=MyISAM COMMENT='家园图片表'; <br>DROP TABLE IF EXISTS pre_home_picfield;<br>CREATE TABLE pre_home_picfield (<br> picid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片id',<br> hotuser text NOT NULL COMMENT '图片对应热点用户',<br> PRIMARY KEY (picid)<br>) ENGINE=MyISAM COMMENT='家园图片拓展表'; <br>DROP TABLE IF EXISTS pre_home_poke;<br>CREATE TABLE pre_home_poke (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '接招呼的用户ID ',<br> fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '打招呼的用户ID ',<br> fromusername varchar(15) NOT NULL default ''COMMENT '打招呼的用户名 ',<br> note varchar(255) NOT NULL default '' COMMENT '招呼内容',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '打招呼时间戳',<br> iconid smallint(6) unsigned NOT NULL default '0' COMMENT '招呼图标',<br> PRIMARY KEY (uid,fromuid),<br> KEY uid (uid,dateline)<br>) ENGINE=MyISAM COMMENT='用户招呼表'; <br>DROP TABLE IF EXISTS pre_home_pokearchive;<br>CREATE TABLE pre_home_pokearchive (<br> pid mediumint(8) NOT NULL auto_increment COMMENT '招呼历史id',<br> pokeuid int(10) unsigned NOT NULL default '0' COMMENT 'uid + fromuid',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '目标用户ID',<br> fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起用户ID',<br> note varchar(255) NOT NULL default ''COMMENT '招呼内容',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '招呼时间戳',<br> iconid smallint(6) unsigned NOT NULL default '0' COMMENT '招呼图标',<br> PRIMARY KEY (pid),<br> KEY pokeuid (pokeuid)<br>) ENGINE=MyISAM COMMENT='用户招呼存档表';'' <br>DROP TABLE IF EXISTS pre_home_share;<br>CREATE TABLE pre_home_share (<br> sid mediumint(8) unsigned NOT NULL auto_increment COMMENT '分享id',<br> itemid mediumint(8) unsigned NOT NULL COMMENT '相关条目的ID',<br> `type` varchar(30) NOT NULL default ''COMMENT '分享类型',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '分享者用户id',<br> username varchar(15) NOT NULL default '' COMMENT '分享者用户名',<br> fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '被分享者用户ID',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '分享时间戳',<br> title_template text NOT NULL COMMENT '分享标题模板',<br> body_template text NOT NULL COMMENT '分享内容模板',<br> body_data text NOT NULL COMMENT '分享内容数据',<br> body_general text NOT NULL COMMENT '分享说明',<br> image varchar(255) NOT NULL default ''COMMENT '分享的图片',<br> image_link varchar(255) NOT NULL default '' COMMENT '分享的图片链接',<br> hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',<br> hotuser text NOT NULL COMMENT '相关热点用户',<br> status tinyint(1) NOT NULL COMMENT '分享条目状态 1-审核',<br> PRIMARY KEY (sid),<br> KEY uid (uid,dateline),<br> KEY hot (hot),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='用户分享表'; <br>DROP TABLE IF EXISTS pre_home_show;<br>CREATE TABLE pre_home_show (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '我要上榜用户id',<br> username varchar(15) NOT NULL default ''COMMENT '我要上榜用户名',<br> unitprice int(10) unsigned NOT NULL default '1' COMMENT '单次访问单价',<br> credit int(10) unsigned NOT NULL default '0' COMMENT '上榜总积分',<br> note varchar(100) NOT NULL default '' COMMENT '上榜宣言',<br> PRIMARY KEY (uid),<br> KEY unitprice (unitprice),<br> KEY credit (credit)<br>) ENGINE=MyISAM COMMENT='用户上榜表'; <br>DROP TABLE IF EXISTS pre_home_userapp;<br>CREATE TABLE pre_home_userapp (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '使用应用的用户ID ',<br> appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用ID ',<br> appname varchar(60) NOT NULL default ''COMMENT '应用名',<br> privacy tinyint(1) NOT NULL default '0' COMMENT '应用是否公开',<br> allowsidenav tinyint(1) NOT NULL default '0' COMMENT '是否在开始菜单中显示',<br> allowfeed tinyint(1) NOT NULL default '0' COMMENT '是否允许应用产生feed ',<br> allowprofilelink tinyint(1) NOT NULL default '0' COMMENT '时都允许在首页显示连接',<br> narrow tinyint(1) NOT NULL default '0' COMMENT '是否在个人空间左边显示',<br> menuorder smallint(6) NOT NULL default '0' COMMENT '菜单顺序',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> KEY uid (uid,appid),<br> KEY menuorder (uid,menuorder),<br> KEY displayorder (uid,displayorder)<br>) ENGINE=MyISAM COMMENT='用户使用应用表';'' <br>DROP TABLE IF EXISTS pre_home_userappfield;<br>CREATE TABLE pre_home_userappfield (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '使用应用的用户id',<br> appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用id',<br> profilelink text NOT NULL COMMENT '应用链接',<br> myml text NOT NULL COMMENT 'myml格式的首页显示信息',<br> KEY uid (uid,appid)<br>) ENGINE=MyISAM COMMENT='用户使用应用扩展表'; <br>DROP TABLE IF EXISTS pre_home_visitor;<br>CREATE TABLE pre_home_visitor (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '受访者用户id',<br> vuid mediumint(8) unsigned NOT NULL default '0' COMMENT '访问者用户id',<br> vusername char(15) NOT NULL default ''COMMENT '访问者用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '访问时间戳',<br> PRIMARY KEY (uid,vuid),<br> KEY vuid (vuid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='空间访问日志表';'' <br> DROP TABLE IF EXISTS pre_portal_article_title;<br>CREATE TABLE pre_portal_article_title (<br> aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '文章ID',<br> catid mediumint(8) unsigned NOT NULL default '0' COMMENT '栏目id',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户id',<br> username varchar(255) NOT NULL default ''COMMENT '用户名',<br> title varchar(255) NOT NULL default '' COMMENT '标题',<br> highlight varchar(255) NOT NULL default ''COMMENT '标题样式',<br> author varchar(255) NOT NULL default '' COMMENT '原作者',<br> `from` varchar(255) NOT NULL default ''COMMENT '来源',<br> fromurl varchar(255) NOT NULL default '' COMMENT '来源URL',<br> url varchar(255) NOT NULL default ''COMMENT '访问URL',<br> summary varchar(255) NOT NULL default '' COMMENT '摘要',<br> pic varchar(255) NOT NULL default ''COMMENT '封面图片',<br> thumb tinyint(1) NOT NULL default '0' COMMENT '封面图片是否缩略',<br> remote tinyint(1) NOT NULL default '0' COMMENT '封面图片是否远程',<br> id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',<br> idtype varchar(255) NOT NULL default '' COMMENT '来源ID类型',<br> contents smallint(6) NOT NULL default '0' COMMENT '内容分页数',<br> allowcomment tinyint(1) NOT NULL default '0' COMMENT '是否允许评论',<br> owncomment tinyint(1) NOT NULL default '0' COMMENT '对于推送过来的文章：1，使用文章评论；0，同步原主题/日志的帖子/评论',<br> click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',<br> click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',<br> click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',<br> click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',<br> click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',<br> click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',<br> click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',<br> click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',<br> tag tinyint(8) unsigned NOT NULL DEFAULT '0' COMMENT '文章属性，共八位',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '添加时间',<br> status tinyint(1) unsigned NOT NULL default '0' COMMENT '文章状态 0-已审核 1-需要审核 2-已忽略',<br> showinnernav tinyint(1) unsigned NOT NULL default '0' COMMENT '是否显示分页导航',<br> PRIMARY KEY (aid),<br> KEY catid (catid,dateline)<br>) ENGINE=MyISAM COMMENT='门户文章标题表'; <br>DROP TABLE IF EXISTS pre_portal_article_content;<br>CREATE TABLE pre_portal_article_content (<br> cid int(10) unsigned NOT NULL auto_increment COMMENT '内容ID',<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章ID',<br> id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',<br> idtype varchar(255) NOT NULL default ''COMMENT '来源ID类型',<br> title varchar(255) NOT NULL default '' COMMENT '标题',<br> content text NOT NULL COMMENT '文章内容',<br> pageorder smallint(6) unsigned NOT NULL default '0' COMMENT '分页排序',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '添加时间',<br> PRIMARY KEY (cid),<br> KEY aid (aid,pageorder),<br> KEY pageorder (pageorder)<br>) ENGINE=MyISAM COMMENT='门户文章内容表'; <br>DROP TABLE IF EXISTS pre_portal_article_count;<br>CREATE TABLE pre_portal_article_count (<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章ID',<br> catid mediumint(8) unsigned NOT NULL default '0' COMMENT '栏目id',<br> viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '查看数',<br> commentnum mediumint(8) unsigned NOT NULL default '0' COMMENT '评论数',<br> favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '文章收藏次数',<br> sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '文章分享次数',<br> PRIMARY KEY (aid)<br>) ENGINE=MyISAM COMMENT='门户文章统计数据表'; <br>DROP TABLE IF EXISTS pre_portal_article_trash;<br>CREATE TABLE pre_portal_article_trash (<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '垃圾文章ID',<br> content text NOT NULL COMMENT '文章数据的seriallize存储',<br> PRIMARY KEY (aid)<br>) ENGINE=MyISAM COMMENT='门户文章回收站表'; <br>DROP TABLE IF EXISTS pre_portal_comment;<br>CREATE TABLE pre_portal_comment (<br> cid mediumint(8) unsigned NOT NULL auto_increment COMMENT '评论id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发表评论的用户id',<br> username varchar(255) NOT NULL default ''COMMENT '发表评论的用户名',<br> id mediumint(8) unsigned NOT NULL default '0' COMMENT '评论对象id',<br> idtype varchar(20) NOT NULL default '' COMMENT '评论对象的id类型：aid，topicid',<br> postip varchar(255) NOT NULL default ''COMMENT '评论IP ',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '评论时间戳',<br> status tinyint(1) unsigned NOT NULL default '0' COMMENT '评论状态 1-审核',<br> message text NOT NULL COMMENT '评论内容',<br> PRIMARY KEY (cid),<br> KEY idtype (id,idtype,dateline)<br>) ENGINE=MyISAM COMMENT='门户评论表';'' <br>DROP TABLE IF EXISTS pre_portal_rsscache;<br>CREATE TABLE pre_portal_rsscache (<br> lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后更新时间',<br> catid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章分类id',<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',<br> catname char(50) NOT NULL default ''COMMENT '分类名称',<br> author char(15) NOT NULL default '' COMMENT '作者',<br> subject char(80) NOT NULL default ''COMMENT '标题',<br> description char(255) NOT NULL default '' COMMENT '解释说明',<br> UNIQUE KEY aid (aid),<br> KEY catid (catid,dateline)<br>) ENGINE=MyISAM COMMENT='文章rss缓存表'; <br>DROP TABLE IF EXISTS pre_portal_topic;<br>CREATE TABLE pre_portal_topic (<br> topicid mediumint(8) unsigned NOT NULL auto_increment COMMENT '专题ID',<br> title varchar(255) NOT NULL default ''COMMENT '专题标题',<br> name varchar(255) NOT NULL default '' COMMENT '静态化名称',<br> `domain` varchar(255) NOT NULL DEFAULT ''COMMENT '二级域名',<br> summary text NOT NULL COMMENT '专题介绍',<br> keyword text NOT NULL COMMENT 'SEO 关键字',<br> cover varchar(255) NOT NULL default '' COMMENT '专题封面',<br> picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',<br> primaltplname varchar(255) NOT NULL default ''COMMENT '原模板地址',<br> useheader tinyint(1) NOT NULL default '0' COMMENT '是否使用网站导航内容',<br> usefooter tinyint(1) NOT NULL default '0' COMMENT '是否使用网站尾部信息',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '创建者UID',<br> username varchar(255) NOT NULL default '' COMMENT '创建者用户名',<br> viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '查看数',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '创建时间',<br> closed tinyint(1) NOT NULL default '0' COMMENT '是否关闭状态',<br> allowcomment tinyint(1) NOT NULL default '0' COMMENT '是否允许评论',<br> commentnum mediumint(8) unsigned NOT NULL default '0' COMMENT '评论数',<br> PRIMARY KEY (topicid),<br> KEY name (name)<br>) ENGINE=MyISAM COMMENT='门户专题表'; <br>DROP TABLE IF EXISTS pre_portal_topic_pic;<br>CREATE TABLE pre_portal_topic_pic (<br> picid mediumint(8) NOT NULL auto_increment COMMENT '图片ID ',<br> topicid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属专题ID ',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属用户ID ',<br> username varchar(15) NOT NULL default ''COMMENT '图片所属用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '图片上传时间戳',<br> filename varchar(255) NOT NULL default '' COMMENT '图片文件名',<br> title varchar(255) NOT NULL default ''COMMENT '图片标题',<br> size int(10) unsigned NOT NULL default '0' COMMENT '图片大小',<br> filepath varchar(255) NOT NULL default '' COMMENT '图片路径',<br> thumb tinyint(1) NOT NULL default '0' COMMENT '是否有缩略图',<br> remote tinyint(1) NOT NULL default '0' COMMENT '是否有远程图片',<br> PRIMARY KEY (picid),<br> KEY topicid (topicid)<br>) ENGINE=MyISAM COMMENT='门户专题图片表'; <br>DROP TABLE IF EXISTS pre_common_diy_data;<br>CREATE TABLE pre_common_diy_data (<br> targettplname varchar(100) NOT NULL default ''COMMENT '目标模板文件名',<br> tpldirectory varchar(80) NOT NULL default '' COMMENT '原模板所在目录',<br> primaltplname varchar(255) NOT NULL default ''COMMENT '原模板文件名',<br> diycontent mediumtext NOT NULL COMMENT 'DIY的内容',<br> `name` varchar(255) NOT NULL default '' COMMENT '目标模板页面名称',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username varchar(15) NOT NULL default ''COMMENT '用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '更新时间',<br> PRIMARY KEY (targettplname, tpldirectory)<br>) ENGINE=MyISAM COMMENT='DIY模板页面数据的存档表';'' <br>DROP TABLE IF EXISTS pre_common_template_block;<br>CREATE TABLE pre_common_template_block (<br> targettplname varchar(100) NOT NULL default ''COMMENT '目标模板文件名',<br> tpldirectory varchar(80) NOT NULL default '' COMMENT '原模板所在目录',<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',<br> PRIMARY KEY (targettplname, tpldirectory, bid),<br> KEY bid (bid)<br>) ENGINE=MyISAM COMMENT='模板页面和模块的关联表'; DROP TABLE IF EXISTS pre_common_template_permission;<br>CREATE TABLE pre_common_template_permission (<br> targettplname varchar(100) NOT NULL DEFAULT ''COMMENT '目标模板',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',<br> allowmanage tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许管理',<br> allowrecommend tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许推荐',<br> needverify tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐需要审核',<br> inheritedtplname varchar(255) NOT NULL DEFAULT '' COMMENT '继承自的模板名称',<br> PRIMARY KEY (targettplname,uid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='DIY模板页面权限表'; <br>DROP TABLE IF EXISTS pre_common_block_permission;<br>CREATE TABLE pre_common_block_permission (<br> bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> allowmanage tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许管理',<br> allowrecommend tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许推荐',<br> needverify tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐需要审核',<br> inheritedtplname varchar(255) NOT NULL DEFAULT ''COMMENT '继承自的模板名称',<br> PRIMARY KEY (bid, uid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='模块权限表';'' <br>DROP TABLE IF EXISTS pre_portal_category_permission;<br>CREATE TABLE pre_portal_category_permission (<br> catid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类ID',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> allowpublish tinyint(1) NOT NULL default '0' COMMENT '允许发布文章',<br> allowmanage tinyint(1) NOT NULL default '0' COMMENT '允许管理文章',<br> inheritedcatid mediumint(8) NOT NULL DEFAULT '0' COMMENT '继承自的频道ID',<br> PRIMARY KEY (catid, uid),<br> KEY uid (uid)<br>) ENGINE=MyISAM COMMENT='文章分类权限表'; <br>DROP TABLE IF EXISTS pre_portal_category;<br>CREATE TABLE pre_portal_category (<br> catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',<br> upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',<br> catname varchar(255) NOT NULL default ''COMMENT '标题',<br> articles mediumint(8) unsigned NOT NULL default '0' COMMENT '文章数',<br> allowcomment tinyint(1) NOT NULL default '1' COMMENT '是否允许评论',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> notinheritedarticle tinyint(1) NOT NULL default '0' COMMENT '是否不继承上级文章管理权限',<br> notinheritedblock tinyint(1) NOT NULL default '0' COMMENT '是否不继承上级DIY页面和模块权限',<br> `domain` varchar(255) NOT NULL DEFAULT '' COMMENT '二级域名',<br> url varchar(255) NOT NULL DEFAULT ''COMMENT '自定义链接',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '创建者ID',<br> username varchar(255) NOT NULL DEFAULT '' COMMENT '创建者用户名',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',<br> closed tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否关闭',<br> shownav tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在导航显示',<br> description text NOT NULL COMMENT '分类介绍 SEO描述',<br> seotitle text NOT NULL COMMENT 'SEO 标题',<br> keyword text NOT NULL COMMENT 'SEO 关键字',<br> primaltplname varchar(255) NOT NULL default ''COMMENT '列表页原模板地址',<br> articleprimaltplname varchar(255) NOT NULL default '' COMMENT '文章页原模板地址',<br> disallowpublish tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁止发布文章',<br> foldername varchar(255) NOT NULL DEFAULT ''COMMENT '文件夹名称',<br> notshowarticlesummay varchar(255) NOT NULL DEFAULT '' COMMENT '文章内容页是否不显示摘要',<br> perpage smallint(6) NOT NULL default '0' COMMENT '列表每页显示文章数',<br> maxpages smallint(6) NOT NULL default '0' COMMENT '列表最大分页数',<br> PRIMARY KEY (catid)<br>) ENGINE=MyISAM COMMENT='门户 文章栏目表'; DROP TABLE IF EXISTS pre_common_process;<br>CREATE TABLE pre_common_process (<br> processid char(32) NOT NULL COMMENT '锁名称的md5',<br> expiry int(10) DEFAULT NULL COMMENT '锁的过期时间',<br> extra int(10) DEFAULT NULL COMMENT '锁的附属信息',<br> PRIMARY KEY (processid),<br> KEY expiry (expiry)<br>) ENGINE=MEMORY COMMENT='进程锁管理'; DROP TABLE IF EXISTS pre_common_admincp_group;<br>CREATE TABLE pre_common_admincp_group (<br> cpgroupid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台组id',<br> cpgroupname varchar(255) NOT NULL COMMENT '后台组名称',<br> PRIMARY KEY (cpgroupid)<br>) ENGINE=MyISAM COMMENT='后台管理组'; DROP TABLE IF EXISTS pre_common_admincp_member;<br>CREATE TABLE pre_common_admincp_member (<br> uid int(10) unsigned NOT NULL COMMENT '成员uid',<br> cpgroupid int(10) unsigned NOT NULL COMMENT '成员组id',<br> customperm text NOT NULL COMMENT '自定义管理权限',<br> PRIMARY KEY (uid)<br>) ENGINE=MyISAM COMMENT='后台管理成员'; DROP TABLE IF EXISTS pre_common_admincp_perm;<br>CREATE TABLE pre_common_admincp_perm (<br> cpgroupid smallint(6) unsigned NOT NULL COMMENT '后台组id',<br> perm varchar(255) NOT NULL COMMENT '后台组权限',<br> UNIQUE KEY cpgroupperm (cpgroupid,perm)<br>) ENGINE=MyISAM COMMENT='后台权限表'; DROP TABLE IF EXISTS pre_common_admincp_session;<br>CREATE TABLE pre_common_admincp_session (<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',<br> adminid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '管理组id',<br> panel tinyint(1) NOT NULL DEFAULT '0' COMMENT '面板位置',<br> ip varchar(15) NOT NULL DEFAULT ''COMMENT 'IP',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后动作时间',<br> errorcount tinyint(1) NOT NULL DEFAULT '0' COMMENT '登录错误次数',<br> storage mediumtext NOT NULL COMMENT '临时内容存储',<br> PRIMARY KEY (uid,panel)<br>) ENGINE=MyISAM COMMENT='后台session表';'' <br>DROP TABLE IF EXISTS pre_portal_attachment;<br>CREATE TABLE pre_portal_attachment (<br> attachid mediumint(8) unsigned NOT NULL auto_increment COMMENT '附件id',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间',<br> filename varchar(255) NOT NULL default ''COMMENT '原文件名',<br> filetype varchar(255) NOT NULL default '' COMMENT '文件类型',<br> filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',<br> attachment varchar(255) NOT NULL default ''COMMENT '服务器路径',<br> isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',<br> thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',<br> remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',<br> aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章id',<br> PRIMARY KEY (attachid),<br> KEY aid (aid,attachid)<br>) ENGINE=MyISAM COMMENT='门户文章附件表';'' <br>DROP TABLE IF EXISTS pre_portal_article_related;<br>CREATE TABLE pre_portal_article_related (<br> aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '文章ID',<br> raid mediumint(8) unsigned NOT NULL default '0' COMMENT '相关文章ID',<br> displayorder mediumint(8) unsigned NOT NULL default '0' COMMENT '显示顺序',<br> PRIMARY KEY (aid,raid),<br> KEY aid (aid,displayorder)<br>) ENGINE=MyISAM COMMENT='门户相关文章'; <br>DROP TABLE IF EXISTS pre_home_specialuser;<br>CREATE TABLE pre_home_specialuser (<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',<br> username varchar(15) NOT NULL default ''COMMENT '用户名',<br> status tinyint(1) unsigned NOT NULL default '0' COMMENT '用户类型0为推荐用户1为默认好友',<br> dateline int(10) NOT NULL default '0' COMMENT '设置时间',<br> reason text NOT NULL COMMENT '操作原因',<br> opuid mediumint(8) unsigned NOT NULL default '0' COMMENT '操作者用户ID',<br> opusername varchar(15) NOT NULL default '' COMMENT '操作者用户名',<br> displayorder mediumint(8) unsigned NOT NULL default '0' COMMENT '显示顺序',<br> KEY uid (uid,status),<br> KEY displayorder (status,displayorder)<br>) ENGINE=MyISAM COMMENT='特殊用户表'; <br>DROP TABLE IF EXISTS pre_common_district;<br>CREATE TABLE pre_common_district (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '地区ID',<br> `name` varchar(255) NOT NULL default ''COMMENT '地区名称',<br> `level` tinyint(4) unsigned NOT NULL default '0' COMMENT '地区等级：1，省级；2，市级；3，县级；4，乡镇',<br> usetype tinyint(1) unsigned NOT NULL default '0' COMMENT '使用对象：0:都不启用; 1:出生地; 2:居住地; 3:都启用',<br> upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级地区ID',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> PRIMARY KEY (id),<br> KEY upid (upid,displayorder)<br>) ENGINE=MyISAM COMMENT='地区表';'' <br>DROP TABLE IF EXISTS pre_forum_grouplevel;<br>CREATE TABLE pre_forum_grouplevel (<br> levelid smallint(6) unsigned NOT NULL auto_increment COMMENT '等级ID',<br> `type` enum('special','default') NOT NULL default 'default' COMMENT '类型',<br> leveltitle varchar(255) NOT NULL default ''COMMENT '群组等级名称',<br> creditshigher int(10) NOT NULL default '0' COMMENT '该等级的积分上限',<br> creditslower int(10) NOT NULL default '0' COMMENT '该等级的积分下限',<br> icon varchar(255) NOT NULL default '' COMMENT '等级图标',<br> creditspolicy text NOT NULL COMMENT '积分策略',<br> postpolicy text NOT NULL COMMENT '帖子策略',<br> specialswitch text NOT NULL COMMENT '特殊开能开关',<br> PRIMARY KEY (levelid),<br> KEY creditsrange (creditshigher,creditslower)<br>) ENGINE=MyISAM COMMENT='群组等级表'; DROP TABLE IF EXISTS pre_forum_groupcreditslog;<br>CREATE TABLE pre_forum_groupcreditslog (<br> fid mediumint(8) unsigned NOT NULL COMMENT '群组ID',<br> uid mediumint(8) unsigned NOT NULL COMMENT '成员UID',<br> logdate int(8) NOT NULL default '0' COMMENT '日期/20100308',<br> PRIMARY KEY (fid,uid,logdate)<br>) ENGINE=MyISAM COMMENT='群组积分日志表'; <br>DROP TABLE IF EXISTS pre_home_blog_category;<br>CREATE TABLE pre_home_blog_category (<br> catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',<br> upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',<br> catname varchar(255) NOT NULL default ''COMMENT '标题',<br> num mediumint(8) unsigned NOT NULL default '0' COMMENT '日志数',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> PRIMARY KEY (catid)<br>) ENGINE=MyISAM COMMENT='日志系统栏目';'' <br>DROP TABLE IF EXISTS pre_home_album_category;<br>CREATE TABLE pre_home_album_category (<br> catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',<br> upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',<br> catname varchar(255) NOT NULL default ''COMMENT '标题',<br> num mediumint(8) unsigned NOT NULL default '0' COMMENT '相册数',<br> displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',<br> PRIMARY KEY (catid)<br>) ENGINE=MyISAM COMMENT='相册系统栏目';'' <br>DROP TABLE IF EXISTS pre_common_report;<br>CREATE TABLE pre_common_report (<br> id mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',<br> urlkey char(32) NOT NULL default ''COMMENT '地址md5',<br> url varchar(255) NOT NULL default '' COMMENT '地址',<br> message text NOT NULL COMMENT '举报理由',<br> uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',<br> username varchar(15) NOT NULL default ''COMMENT '用户名',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '举报时间',<br> num smallint(6) unsigned NOT NULL default '1' COMMENT '举报次数',<br> opuid mediumint(8) unsigned NOT NULL default '0' COMMENT '管理员id',<br> opname varchar(15) NOT NULL default '' COMMENT '管理员姓名',<br> optime int(10) unsigned NOT NULL default '0' COMMENT '处理时间',<br> opresult varchar(255) NOT NULL default ''COMMENT '对举报人的奖惩',<br> fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',<br> PRIMARY KEY (id),<br> KEY urlkey (urlkey),<br> KEY fid (fid)<br>) ENGINE=MyISAM COMMENT='用户举报表';'' <br>DROP TABLE IF EXISTS pre_common_patch;<br>CREATE TABLE pre_common_patch (<br> serial varchar(10) NOT NULL default ''COMMENT '漏洞编号',<br> rule text NOT NULL COMMENT '修补规则',<br> note text NOT NULL COMMENT '漏洞说明',<br> `status` tinyint(1) NOT NULL default '0' COMMENT '修补状态',<br> dateline int(10) unsigned NOT NULL default '0' COMMENT '漏洞发布时间',<br> PRIMARY KEY (serial)<br>) ENGINE=MyISAM COMMENT='漏洞补丁表';'' <br>DROP TABLE IF EXISTS pre_forum_collection;<br>CREATE TABLE pre_forum_collection (<br> ctid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '专辑ID',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',<br> username varchar(15) NOT NULL DEFAULT ''COMMENT '用户名',<br> `name` varchar(50) NOT NULL DEFAULT '' COMMENT '专辑名',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',<br> follownum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订阅数',<br> threadnum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题数',<br> commentnum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',<br> `desc` varchar(255) NOT NULL DEFAULT ''COMMENT '简介',<br> lastupdate int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后变动时间',<br> rate float NOT NULL DEFAULT '0' COMMENT '评分',<br> ratenum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '评分次数',<br> lastpost mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '最后主题ID',<br> lastsubject varchar(80) NOT NULL DEFAULT '' COMMENT '最后主题标题',<br> lastposttime int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后主题时间',<br> lastposter varchar(15) NOT NULL DEFAULT ''COMMENT '最后主题发帖者',<br> lastvisit int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者最后访问',<br> `keyword` varchar(255) NOT NULL DEFAULT '' COMMENT '专辑关键词',<br> PRIMARY KEY (ctid),<br> KEY dateline (dateline),<br> KEY hotcollection (threadnum,lastupdate),<br> KEY follownum (follownum)<br>) ENGINE=MyISAM COMMENT='淘帖专辑表'; <br>DROP TABLE IF EXISTS pre_forum_collectioncomment;<br>CREATE TABLE pre_forum_collectioncomment (<br> cid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID',<br> ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',<br> username varchar(15) NOT NULL DEFAULT ''COMMENT '用户名',<br> message text NOT NULL COMMENT '评论内容',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间',<br> useip varchar(16) NOT NULL DEFAULT '' COMMENT 'IP地址',<br> rate float NOT NULL DEFAULT '0' COMMENT '评分',<br> PRIMARY KEY (cid),<br> KEY ctid (ctid,dateline),<br> KEY userrate (ctid,uid,rate)<br>) ENGINE=MyISAM COMMENT='淘帖评论表'; <br>DROP TABLE IF EXISTS pre_forum_collectionfollow;<br>CREATE TABLE pre_forum_collectionfollow (<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',<br> username char(15) NOT NULL DEFAULT ''COMMENT '用户名',<br> ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关注时间',<br> lastvisit int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问专辑时间',<br> PRIMARY KEY (uid,ctid),<br> KEY ctid (ctid,dateline)<br>) ENGINE=MyISAM COMMENT='淘帖关注表';'' <br>DROP TABLE IF EXISTS pre_forum_collectioninvite;<br>CREATE TABLE pre_forum_collectioninvite (<br> ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '邀请合作者ID',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '邀请时间',<br> PRIMARY KEY (ctid,uid),<br> KEY dateline (dateline)<br>) ENGINE=MyISAM COMMENT='邀请管理淘专辑'; <br>DROP TABLE IF EXISTS pre_forum_collectionrelated;<br>CREATE TABLE pre_forum_collectionrelated (<br> tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题ID',<br> collection text NOT NULL COMMENT '专辑列表',<br> PRIMARY KEY (tid)<br>) ENGINE=MyISAM COMMENT='淘帖主题被收入专辑表'; <br>DROP TABLE IF EXISTS pre_forum_collectionteamworker;<br>CREATE TABLE pre_forum_collectionteamworker (<br> ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',<br> uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '合作者ID',<br> `name` varchar(50) NOT NULL DEFAULT ''COMMENT '专辑名',<br> username varchar(15) NOT NULL DEFAULT '' COMMENT '用户名',<br> lastvisit int(8) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问专辑时间',<br> PRIMARY KEY (ctid,uid)<br>) ENGINE=MyISAM COMMENT='淘帖合作编辑表'; <br>DROP TABLE IF EXISTS pre_forum_collectionthread;<br>CREATE TABLE pre_forum_collectionthread (<br> ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',<br> tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑内主题ID',<br> dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '主题日期',<br> reason varchar(255) NOT NULL DEFAULT ''COMMENT '推荐理由',<br> PRIMARY KEY (ctid,tid),<br> KEY ctid (ctid,dateline)<br>) ENGINE=MyISAM COMMENT='淘帖包含主题表';<br>''

返回到Discuz! X2.5数据字典。