allowanonymous tinyint(1) NOT NULL default '0' COMMENT '允许匿名发帖',
allowsigbbcode tinyint(1) NOT NULL default '0' COMMENT '允许签名使用bbcode', allowsigimgcode tinyint(1) NOT NULL default '0' COMMENT '允许使用img', allowmagics tinyint(1) unsigned NOT NULL COMMENT '允许使用道具',
disableperiodctrl tinyint(1) NOT NULL default '0' COMMENT '不受时间段限制', reasonpm tinyint(1) NOT NULL default '0' COMMENT '操作理由短信通知作者', maxprice smallint(6) unsigned NOT NULL default '0' COMMENT '主题最大售价', maxsigsize smallint(6) unsigned NOT NULL default '0' COMMENT '最大签名尺寸', maxattachsize int(10) unsigned NOT NULL default '0' COMMENT '最大附件尺寸',
maxsizeperday int(10) unsigned NOT NULL default '0' COMMENT '每天最大附件总尺寸', maxthreadsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT '每小时发主题数限制',
maxpostsperhour tinyint(3) unsigned NOT NULL default '0' COMMENT '每小时发回帖数限制',
attachextensions char(100) NOT NULL default COMMENT '允许发表的附件类型', raterange char(150) NOT NULL default COMMENT '评分范围',
mintradeprice smallint(6) unsigned NOT NULL default '1' COMMENT '交易最小积分', maxtradeprice smallint(6) unsigned NOT NULL default '0' COMMENT '交易最大积分', minrewardprice smallint(6) unsigned NOT NULL default '1' COMMENT '悬赏最小积分', maxrewardprice smallint(6) unsigned NOT NULL default '0' COMMENT '悬赏最大积分', magicsdiscount tinyint(1) NOT NULL COMMENT '道具折扣',
maxmagicsweight smallint(6) unsigned NOT NULL COMMENT '道具负载最大值', allowpostdebate tinyint(1) NOT NULL default '0' COMMENT '允许发表辩论', tradestick tinyint(1) unsigned NOT NULL COMMENT '可商品推荐数', exempt tinyint(1) unsigned NOT NULL COMMENT '用户组表达式',
maxattachnum smallint(6) NOT NULL default '0' COMMENT '最大每天附件数量', allowposturl tinyint(1) NOT NULL default '3' COMMENT '是否允许发送含 url 内容',
allowrecommend tinyint(1) unsigned NOT NULL default '1' COMMENT '是否允许评价主题', allowpostrushreply TINYINT(1) NOT NULL DEFAULT '0' COMMENT '允许发表抢楼帖', maxfriendnum smallint(6) unsigned NOT NULL default '0' COMMENT '最多好友数', maxspacesize int(10) unsigned NOT NULL default '0' COMMENT '空间大小', allowcomment tinyint(1) NOT NULL default '0' COMMENT '发表留言/评论',
allowcommentarticle smallint(6) NOT NULL default '0' COMMENT '发表文章的评论',
searchinterval smallint(6) unsigned NOT NULL default '0' COMMENT '两次搜索操作间隔', searchignore tinyint(1) NOT NULL default '0' COMMENT '是否免费搜索', allowblog tinyint(1) NOT NULL default '0' COMMENT '发表日志', allowdoing tinyint(1) NOT NULL default '0' COMMENT '发表记录', allowupload tinyint(1) NOT NULL default '0' COMMENT '上传图片', allowshare tinyint(1) NOT NULL default '0' COMMENT '发布分享',
allowblogmod tinyint(1) unsigned NOT NULL default '0' COMMENT '发表日志需要审核', allowdoingmod tinyint(1) unsigned NOT NULL default '0' COMMENT '发表记录需要审核', allowuploadmod tinyint(1) unsigned NOT NULL default '0' COMMENT '上传图片需要审核', allowsharemod tinyint(1) unsigned NOT NULL default '0' COMMENT '发布分享需要审核', allowcss tinyint(1) NOT NULL default '0' COMMENT '允许自定义CSS',
allowpoke tinyint(1) NOT NULL default '0' COMMENT '允许打招呼', allowfriend tinyint(1) NOT NULL default '0' COMMENT '允许加好友', allowclick tinyint(1) NOT NULL default '0' COMMENT '允许表态',
allowmagic tinyint(1) NOT NULL default '0' COMMENT '允许使用道具', allowstat tinyint(1) NOT NULL default '0' COMMENT '允许查看趋势统计',
allowstatdata tinyint(1) NOT NULL default '0' COMMENT '允许查看统计数据报表', videophotoignore tinyint(1) NOT NULL default '0' COMMENT '视频认证限制',
allowviewvideophoto tinyint(1) NOT NULL default '0' COMMENT '允许查看视频认证', allowmyop tinyint(1) NOT NULL default '0' COMMENT '允许使用应用', magicdiscount tinyint(1) NOT NULL default '0' COMMENT '购买道具折扣',
domainlength smallint(6) unsigned NOT NULL default '0' COMMENT '二级域名最短长度', seccode tinyint(1) NOT NULL default '1' COMMENT '发布操作需填验证码',
disablepostctrl tinyint(1) NOT NULL DEFAULT '0' COMMENT '发表是否受防灌水限制',
allowbuildgroup tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许建立群组，0为不允许',
allowgroupdirectpost tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许直接在群组中发帖',
allowgroupposturl tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许在群组中发站外URL',
edittimelimit smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '编辑帖子时间限制', allowpostarticle tinyint(1) NOT NULL default '0' COMMENT '允许发布文章',
allowdownlocalimg tinyint(1) NOT NULL default '0' COMMENT '允许下载本地图片', allowdownremoteimg tinyint(1) NOT NULL default '0' COMMENT '允许下载远程图片',
allowpostarticlemod tinyint(1) unsigned NOT NULL default '0' COMMENT '发布文章是否需要审核',
allowspacediyhtml tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用HTML', allowspacediybbcode tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用BBCODE',
allowspacediyimgcode tinyint(1) NOT NULL default '0' COMMENT '允许自定义模块使用[img]',
allowcommentpost tinyint(1) NOT NULL default '2' COMMENT '允许帖子点评 0:禁止 1:楼主 2:回复 3:All',
allowcommentitem tinyint(1) NOT NULL default '0' COMMENT '允许发表点评观点', allowcommentreply tinyint(1) NOT NULL default '0' COMMENT '允许发表回复点评', allowreplycredit tinyint(1) NOT NULL default '0' COMMENT '允许设置回帖奖励',
ignorecensor tinyint(1) unsigned NOT NULL default '0' COMMENT '是否忽略要审核的关键字',
allowsendallpm tinyint(1) unsigned NOT NULL default '0' COMMENT '是否不受“只接收好友短消息”设置的限制',
allowsendpmmaxnum smallint(6) unsigned NOT NULL default '0' COMMENT '24小时内允许发短消息的数量',
maximagesize mediumint(8) unsigned NOT NULL default '0' COMMENT '相册中允许最大图片大小',
allowmediacode tinyint(1) NOT NULL default '0' COMMENT '允许使用多媒体代码',
allowat smallint(6) unsigned NOT NULL default '0' COMMENT '允许@用户 0：禁止 n:发帖时@的数量',
allowsetpublishdate tinyint(1) unsigned NOT NULL default '0' COMMENT '允许定时发布主题',
allowfollowcollection tinyint(1) unsigned NOT NULL default '0' COMMENT '允许关注淘专辑数',
allowcommentcollection tinyint(1) unsigned NOT NULL default '0' COMMENT '允许评论淘专辑',
allowcreatecollection smallint(6) unsigned NOT NULL default '0' COMMENT '允许创建淘专辑数',
PRIMARY KEY (groupid)
) ENGINE=MyISAM COMMENT='会员用户组权限表';
DROP TABLE IF EXISTS pre_common_word; CREATE TABLE pre_common_word (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '词汇id', admin varchar(15) NOT NULL default COMMENT '管理员名', type smallint(6) NOT NULL default '1' COMMENT '关键词分类', find varchar(255) NOT NULL default COMMENT '不良词语',
replacement varchar(255) NOT NULL default COMMENT '替换内容', extra varchar(255) NOT NULL default , PRIMARY KEY (id)
) ENGINE=MyISAM COMMENT='词语过滤表';
DROP TABLE IF EXISTS pre_common_word_type; CREATE TABLE pre_common_word_type (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '词语过滤分类id', typename varchar(15) NOT NULL default COMMENT '分类名称', PRIMARY KEY (id)
) ENGINE=MyISAM COMMENT='词语过滤分类';
DROP TABLE IF EXISTS pre_common_tag; CREATE TABLE pre_common_tag (
tagid smallint(6) unsigned NOT NULL auto_increment COMMENT '标签id', tagname char(20) NOT NULL default COMMENT '标签名',
status tinyint(1) NOT NULL default '0' COMMENT '显示状态\\n(0:正常 1:关闭 2:推荐 3:用户标签)',
PRIMARY KEY (tagid), KEY tagname (tagname), KEY status (status, tagid)
) ENGINE=MyISAM COMMENT='标签表';
DROP TABLE IF EXISTS pre_common_tagitem; CREATE TABLE pre_common_tagitem (
tagid smallint(6) unsigned NOT NULL default '0' COMMENT '标签id', itemid mediumint(8) unsigned NOT NULL default '0' COMMENT 'itemid', idtype char(10) NOT NULL default COMMENT '内容类型', UNIQUE KEY item (tagid, itemid, idtype), KEY idtype (idtype, itemid)
) ENGINE=MyISAM COMMENT='标签内容表';
DROP TABLE IF EXISTS pre_forum_access; CREATE TABLE pre_forum_access (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id', allowview tinyint(1) NOT NULL default '0' COMMENT '允许浏览', allowpost tinyint(1) NOT NULL default '0' COMMENT '允许发表', allowreply tinyint(1) NOT NULL default '0' COMMENT '允许回复',
allowgetattach tinyint(1) NOT NULL default '0' COMMENT '允许下载附件', allowgetimage tinyint(1) NOT NULL default '0' COMMENT '允许查看图片', allowpostattach tinyint(1) NOT NULL default '0' COMMENT '允许上传附件', allowpostimage tinyint(1) NOT NULL default '0' COMMENT '允许上传图片',
adminuser mediumint(8) unsigned NOT NULL default '0' COMMENT '管理员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '时间', PRIMARY KEY (uid,fid), KEY listorder (fid,dateline)
) ENGINE=MyISAM COMMENT='访问权限表';
DROP TABLE IF EXISTS pre_forum_activity; CREATE TABLE pre_forum_activity (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', aid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题图片id', cost mediumint(8) unsigned NOT NULL default '0' COMMENT '每人花销', starttimefrom int(10) unsigned NOT NULL default '0' COMMENT '开始时间', starttimeto int(10) unsigned NOT NULL default '0' COMMENT '结束时间', place varchar(255) NOT NULL default COMMENT '地点', class varchar(255) NOT NULL default COMMENT '类别', gender tinyint(1) NOT NULL default '0' COMMENT '性别',
number smallint(5) unsigned NOT NULL default '0' COMMENT '人数',
applynumber smallint(5) unsigned NOT NULL default '0' COMMENT '已参加人数', expiration int(10) unsigned NOT NULL default '0' COMMENT '报名截止日期',