首页 > 活着 > discuz X2.0 数据库字典,discuz X2.0 数据解析,discuz X2.0 数据表结构《一》

discuz X2.0 数据库字典,discuz X2.0 数据解析,discuz X2.0 数据表结构《一》

discuz X2.0 数据库字典,discuz X2.0 数据解析,
discuz X2.0数据库详解,discuz X2.0数据库分析,
discuz X2.0 数据库表结构,discuz X2.0数据库结构,discuz X2.0数据结构,
discuz X2.0数据表详解,discuz X2.0数据字典,
discuz X2.0 数据表结构,

CREATE TABLE pre_common_admincp_cmenu (
  `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL COMMENT ‘菜单名称’,
  `url` VARCHAR(255) NOT NULL COMMENT ‘菜单地址’,
  `sort` TINYINT(1) NOT NULL DEFAULT ‘0’ COMMENT ‘菜单类型,备用’,
  `displayorder` TINYINT(3) NOT NULL COMMENT ‘显示顺序’,
  `clicks` SMALLINT(6) UNSIGNED NOT NULL DEFAULT ‘1’ COMMENT ‘点击数,备用’,
  `uid` MEDIUMINT(8) UNSIGNED NOT NULL COMMENT ‘添加用户’,
  `dateline` INT(10) UNSIGNED NOT NULL COMMENT ‘添加时间’,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `displayorder` (`displayorder`)
) ENGINE=MYISAM COMMENT=’后台菜单收藏表';

CREATE TABLE pre_common_admingroup (
  admingid smallint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘所属管理员分组ID’,
  alloweditpost tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑帖子’,
  alloweditpoll tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑投票’,
  allowstickthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许置顶主题’,
  allowmodpost tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许审核帖子’,
  allowdelpost tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许删除帖子’,
  allowmassprune tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许批量删帖’,
  allowrefund tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许强制退款’,
  allowcensorword tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘兼容性字段’,
  allowviewip tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许查看IP’,
  allowbanip tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许禁止IP’,
  allowedituser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑用户’,
  allowmoduser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许审核用户’,
  allowbanuser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许禁止用户发言’,
  allowbanvisituser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许禁止用户访问’,
  allowpostannounce tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许发布站点公告’,
  allowviewlog tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许查看管理日志’,
  allowbanpost tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许屏蔽帖子’,
  supe_allowpushthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘兼容性字段’,
  allowhighlightthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许高亮主题’,
  allowdigestthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许精华主题’,
  allowrecommendthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许推荐主题’,
  allowbumpthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许提升主题’,
  allowclosethread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许关闭主题’,
  allowmovethread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许移动主题’,
  allowedittypethread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑主题分类’,
  allowstampthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许添加主题图章’,
  allowstamplist tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许添加主题图标’,
  allowcopythread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许复制主题’,
  allowmergethread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许合并主题’,
  allowsplitthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许分割主题’,
  allowrepairthread tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许修复主题’,
  allowwarnpost tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许警告帖子’,
  allowviewreport tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许查看用户报告’,
  alloweditforum tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑版块’,
  allowremovereward tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许移除悬赏’,
  allowedittrade tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许编辑商品’,
  alloweditactivity tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理活动报名者’,
  allowstickreply tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许置顶回帖’,
  allowmanagearticle tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理所有文章’,
  allowaddtopic tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许创建专题’,
  allowmanagetopic tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理专题’,
  allowdiy tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许DIY’,
  allowclearrecycle tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许删除回收站的帖子’,
  allowmanagetag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理标签’,
  managefeed tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理动态(feed)’,
  managedoing tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理记录’,
  manageshare tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理分享’,
  manageblog tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理日志’,
  managealbum tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理相册’,
  managecomment tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理评论’,
  managemagiclog tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理道具记录’,
  managereport tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理举报’,
  managehotuser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理推荐成员’,
  managedefaultuser tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理推荐好友’,
  managevideophoto tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理视频认证’,
  managemagic tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理道具’,
  manageclick tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否允许管理表态动作’,
  PRIMARY KEY (admingid)
) ENGINE=MyISAM COMMENT=’管理组表';

CREATE TABLE pre_common_adminnote (
  id mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘后台留言id’,
  admin varchar(15) NOT NULL default ” COMMENT ‘管理员姓名’,
  access tinyint(3) NOT NULL default ‘0’ COMMENT ‘哪组可以看到信息’,
  adminid tinyint(3) NOT NULL default ‘0’ COMMENT ‘管理员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘发表时间’,
  expiration int(10) unsigned NOT NULL default ‘0’ COMMENT ‘过期时间’,
  message text NOT NULL COMMENT ‘消息’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’后台留言表';

CREATE TABLE pre_common_advertisement (
  advid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘广告id’,
  available tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否启用’,
  `type` varchar(50) NOT NULL default ‘0’ COMMENT ‘类型’,
  displayorder tinyint(3) NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  title varchar(255) NOT NULL default ” COMMENT ‘广告标题’,
  targets text NOT NULL COMMENT ‘投放范围’,
  parameters text NOT NULL COMMENT ‘参数\n序列化存放的数组数据’,
  `code` text NOT NULL COMMENT ‘代码’,
  starttime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘开始时间’,
  endtime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘结束时间’,
  PRIMARY KEY  (advid)
) ENGINE=MyISAM COMMENT=’广告数据表';

CREATE TABLE pre_common_advertisement_custom (
  `id` smallint(5) unsigned NOT NULL auto_increment COMMENT ‘自定义广告类型id’,
  `name` varchar(255) NOT NULL COMMENT ‘名称’,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM COMMENT=’自定义广告数据表';

CREATE TABLE pre_common_banned (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘禁止id’,
  ip1 smallint(3) NOT NULL default ‘0’ COMMENT ‘IP分段1′,
  ip2 smallint(3) NOT NULL default ‘0’ COMMENT ‘IP分段2′,
  ip3 smallint(3) NOT NULL default ‘0’ COMMENT ‘IP分段3′,
  ip4 smallint(3) NOT NULL default ‘0’ COMMENT ‘IP分段4′,
  admin varchar(15) NOT NULL default ” COMMENT ‘管理员姓名’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘禁止时间’,
  expiration int(10) unsigned NOT NULL default ‘0’ COMMENT ‘过期时间’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’禁止访问表';

CREATE TABLE pre_common_cache (
  cachekey varchar(255) NOT NULL default ”,
  cachevalue mediumblob NOT NULL,
  dateline int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (cachekey)
) ENGINE=MyISAM COMMENT=’通用缓存表';

CREATE TABLE pre_common_card (
  id char(255) NOT NULL default ” COMMENT ‘生成的卡片号码’,
  typeid smallint(6) unsigned NOT NULL default ‘1’ COMMENT ‘卡片分类’,
  maketype tinyint(1) NOT NULL default ‘0’ COMMENT ‘卡片生成的方法’,
  makeruid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘卡片生成者uid’,
  `price` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘卡片面值’,
  `extcreditskey` tinyint(1) NOT NULL default ‘0’ COMMENT ‘充值积分种类’,
  `extcreditsval` int(10) NOT NULL default ‘0’ COMMENT ‘积分数额’,
  `status` tinyint(1) unsigned NOT NULL default ‘1’ COMMENT ‘卡片状态(位与):1:可用,2:已用’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘卡片生成时间’,
  cleardateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘卡片清理时间’,
  useddateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘使用时间’,
  uid mediumint(8)  unsigned NOT NULL default ‘0’ COMMENT ‘使用者’,
  PRIMARY KEY  (id),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM COMMENT=’充值卡密表';

CREATE TABLE pre_common_card_log (
  id smallint(6) NOT NULL auto_increment COMMENT ‘生成的卡片号码’,
  `uid` mediumint(8) NOT NULL default ‘0’ COMMENT ‘卡片生成者’,
  `username` varchar(20) NOT NULL default ” COMMENT ‘卡片生成者’,
  cardrule varchar(255) NOT NULL default ” COMMENT ‘卡片生成规则’,
  `info` text NOT NULL default ” COMMENT ‘卡片生成log’,
  dateline INT(10) unsigned NOT NULL default ‘0’ COMMENT ‘本次log生成时间’,
  description mediumtext NOT NULL default ” COMMENT ‘卡片描述’,
  operation tinyint(1) NOT NULL default ‘0’ COMMENT ‘操作动作(位与):1:生成,2:任务生成,4:删除,9:卡片过期’,
  PRIMARY KEY  (id),
  KEY `dateline` (`dateline`),
  KEY `operation_dateline` (`operation`, `dateline`)
) ENGINE=MyISAM COMMENT=’充值卡密表';

CREATE TABLE pre_common_card_type (
  id smallint(6) NOT NULL auto_increment COMMENT ‘卡片分类ID’,
  typename char(20) NOT NULL default ” COMMENT ‘分类名称’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’卡片分类表';

CREATE TABLE pre_common_credit_log (
  `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘所属用户uid’,
  `operation` char(3) NOT NULL default ” COMMENT ‘操作类型’,
  `relatedid` int(10) unsigned NOT NULL COMMENT ‘操作相关ID’,
  `dateline` int(10) unsigned NOT NULL COMMENT ‘记录时间’,
  `extcredits1` int(10) NOT NULL COMMENT ‘积分1变化值’,
  `extcredits2` int(10) NOT NULL COMMENT ‘积分2变化值’,
  `extcredits3` int(10) NOT NULL COMMENT ‘积分3变化值’,
  `extcredits4` int(10) NOT NULL COMMENT ‘积分4变化值’,
  `extcredits5` int(10) NOT NULL COMMENT ‘积分5变化值’,
  `extcredits6` int(10) NOT NULL COMMENT ‘积分6变化值’,
  `extcredits7` int(10) NOT NULL COMMENT ‘积分7变化值’,
  `extcredits8` int(10) NOT NULL COMMENT ‘积分8变化值’,
  KEY `uid` (`uid`),
  KEY `operation` (`operation`),
  KEY `relatedid` (`relatedid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM COMMENT=’积分日志表';

CREATE TABLE pre_common_credit_rule_log (
  clid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘策略日志ID’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘策略日志所有者uid’,
  rid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘策略ID’,
  fid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘版块ID’,
  total mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘策略被执行总次数’,
  cyclenum mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘周期被执行次数’,
  extcredits1 int(10) NOT NULL default ‘0’ COMMENT ‘扩展1′,
  extcredits2 int(10) NOT NULL default ‘0’ COMMENT ‘扩展2′,
  extcredits3 int(10) NOT NULL default ‘0’ COMMENT ‘扩展3′,
  extcredits4 int(10) NOT NULL default ‘0’ COMMENT ‘扩展4′,
  extcredits5 int(10) NOT NULL default ‘0’ COMMENT ‘扩展5′,
  extcredits6 int(10) NOT NULL default ‘0’ COMMENT ‘扩展6′,
  extcredits7 int(10) NOT NULL default ‘0’ COMMENT ‘扩展7′,
  extcredits8 int(10) NOT NULL default ‘0’ COMMENT ‘扩展8′,
  starttime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘周期开始时间’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘策略最后执行时间’,
  PRIMARY KEY  (clid),
  KEY uid (uid,rid, fid),
  KEY dateline (dateline)
) ENGINE=MyISAM COMMENT=’积分规则日志表';

CREATE TABLE pre_common_credit_rule_log_field (
  clid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘策略日志ID’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘策略日志所有者uid’,
  info text NOT NULL COMMENT ‘记录信息防重’,
  `user` text NOT NULL COMMENT ‘记录用户防重’,
  app text NOT NULL COMMENT ‘记录应用防重’,
  PRIMARY KEY  (uid, clid)
) ENGINE=MyISAM;

CREATE TABLE pre_common_credit_rule (
  rid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘规则ID’,
  rulename varchar(20) NOT NULL default ” COMMENT ‘规则名称’,
  `action` varchar(20) NOT NULL default ” COMMENT ‘规则action唯一KEY’,
  cycletype tinyint(1) NOT NULL default ‘0’ COMMENT ‘奖励周期0:一次;1:每天;2:整点;3:间隔分钟;4:不限;’,
  cycletime int(10) NOT NULL default ‘0’ COMMENT ‘间隔时间’,
  rewardnum tinyint(2) NOT NULL default ‘1’ COMMENT ‘奖励次数’,
  norepeat tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否去重1:去重;0:不去重’,
  extcredits1 int(10) NOT NULL default ‘0’ COMMENT ‘扩展1′,
  extcredits2 int(10) NOT NULL default ‘0’ COMMENT ‘扩展2′,
  extcredits3 int(10) NOT NULL default ‘0’ COMMENT ‘扩展3′,
  extcredits4 int(10) NOT NULL default ‘0’ COMMENT ‘扩展4′,
  extcredits5 int(10) NOT NULL default ‘0’ COMMENT ‘扩展5′,
  extcredits6 int(10) NOT NULL default ‘0’ COMMENT ‘扩展6′,
  extcredits7 int(10) NOT NULL default ‘0’ COMMENT ‘扩展7′,
  extcredits8 int(10) NOT NULL default ‘0’ COMMENT ‘扩展8′,
  fids text NOT NULL COMMENT ‘记录自定义策略版块ID’,
  PRIMARY KEY  (rid),
  UNIQUE KEY `action` (`action`)
) ENGINE=MyISAM COMMENT=’积分规则表';

CREATE TABLE pre_common_cron (
  cronid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘计划任务id’,
  available tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否启用’,
  `type` enum(‘user’,’system’) NOT NULL default ‘user’ COMMENT ‘类型’,
  `name` char(50) NOT NULL default ” COMMENT ‘名称’,
  filename char(50) NOT NULL default ” COMMENT ‘对应文件’,
  lastrun int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上次执行时间’,
  nextrun int(10) unsigned NOT NULL default ‘0’ COMMENT ‘下次执行时间’,
  weekday tinyint(1) NOT NULL default ‘0’ COMMENT ‘周计划’,
  `day` tinyint(2) NOT NULL default ‘0’ COMMENT ‘日计划’,
  `hour` tinyint(2) NOT NULL default ‘0’ COMMENT ‘小时计划’,
  `minute` char(36) NOT NULL default ” COMMENT ‘分计划’,
  PRIMARY KEY  (cronid),
  KEY nextrun (available,nextrun)
) ENGINE=MyISAM COMMENT=’计划任务表';

CREATE TABLE pre_common_domain (
  domain char(30) NOT NULL default ” COMMENT ‘域名前缀’,
  domainroot char(60) NOT NULL default ” COMMENT ‘二级域名后缀’,
  id mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘对应对象id’,
  idtype char(15) NOT NULL default ” COMMENT ‘对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道’,
  PRIMARY KEY (id, idtype),
  KEY domain (domain, domainroot),
  KEY idtype (idtype)
) ENGINE=MyISAM COMMENT=’二级域名表';

CREATE TABLE pre_common_failedlogin (
  ip char(15) NOT NULL default ” COMMENT ‘失败IP’,
  username char(15) NOT NULL default ” COMMENT ‘失败时的用户名’,
  count tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘尝试次数’,
  lastupdate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘最后一次尝试时间’,
  PRIMARY KEY  (ip,username)
) ENGINE=MyISAM COMMENT=’失败登录表';

CREATE TABLE pre_common_friendlink (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘id’,
  displayorder tinyint(3) NOT NULL default ‘0’ COMMENT ‘显示顺序,正序’,
  `name` varchar(100) NOT NULL default ” COMMENT ‘名称’,
  url varchar(255) NOT NULL default ” COMMENT ‘url’,
  description mediumtext NOT NULL COMMENT ‘解释说明’,
  logo varchar(255) NOT NULL default ” COMMENT ‘logo’,
  `type` tinyint(3) NOT NULL default ‘0’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’友情链接表’ ;

CREATE TABLE pre_common_relatedlink (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘id’,
  `name` varchar(100) NOT NULL default ” COMMENT ‘名称’,
  url varchar(255) NOT NULL default ” COMMENT ‘url’,
  `extent` tinyint(3) NOT NULL default ‘0’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’关联链接表’ ;

CREATE TABLE pre_common_invite (
  id mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘ID’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘邀请人’,
  `code` char(20) NOT NULL default ” COMMENT ‘邀请码’,
  fuid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘受邀人UID’,
  fusername char(20) NOT NULL default ” COMMENT ‘受邀人姓名’,
  `type` tinyint(1) NOT NULL default ‘0’ COMMENT ”,
  email char(40) NOT NULL default ” COMMENT ‘邀请Email’,
  inviteip char(15) NOT NULL default ” COMMENT ‘邀请IP’,
  appid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘应用ID’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘邀请码生成时间’,
  endtime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘邀请码结束时间’,
  regdateline int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘注册时间’,
  `status` tinyint(1) NOT NULL DEFAULT ‘1’ COMMENT ‘邀请码状态’,
  orderid char(32) NOT NULL default ” COMMENT ‘购买邀请码的订单号id’,
  PRIMARY KEY (id),
  KEY uid (uid, dateline)
) ENGINE=MyISAM COMMENT=’邀请表';

CREATE TABLE pre_common_mailcron (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  touid mediumint(8) unsigned NOT NULL default ‘0’,
  email varchar(100) NOT NULL default ”,
  sendtime int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (cid),
  KEY sendtime (sendtime)
) ENGINE=MyISAM COMMENT=’邮件计划任务表';

CREATE TABLE pre_common_mailqueue (
  qid mediumint(8) unsigned NOT NULL auto_increment,
  cid mediumint(8) unsigned NOT NULL default ‘0’,
  `subject` text NOT NULL,
  message text NOT NULL,
  dateline int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (qid),
  KEY mcid (cid,dateline)
) ENGINE=MyISAM COMMENT=’邮件队列表';

CREATE TABLE pre_common_member (
  uid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘会员id’,
  email char(40) NOT NULL default ” COMMENT ‘邮箱’,
  username char(15) NOT NULL default ” COMMENT ‘用户名’,
  `password` char(32) NOT NULL default ” COMMENT ‘密码’,
  `status` tinyint(1) NOT NULL default ‘0’ COMMENT ‘判断用户是否已经删除 需要discuz程序加判断,并增加整体清理的功能。原home字段为flag’,
  emailstatus tinyint(1) NOT NULL default ‘0’ COMMENT ‘email是否经过验证 home字段为emailcheck’,
  avatarstatus tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否有头像 home字段为avatar’,
  videophotostatus tinyint(1) NOT NULL default ‘0’ COMMENT ‘视频认证状态 home’,
  adminid tinyint(1) NOT NULL default ‘0’ COMMENT ‘管理员id’,
  groupid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘会员组id’,
  groupexpiry int(10) unsigned NOT NULL default ‘0’ COMMENT ‘用户组有效期’,
  extgroupids char(20) NOT NULL default ” COMMENT ‘扩展用户组’,
  regdate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘注册时间’,
  credits int(10) NOT NULL default ‘0’ COMMENT ‘总积分’,
  notifysound tinyint(1) NOT NULL default ‘0’ COMMENT ‘短信声音’,
  timeoffset char(4) NOT NULL default ” COMMENT ‘时区校正’,
  newpm smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘新短消息数量’,
  newprompt smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘新提醒数目’,
  accessmasks tinyint(1) NOT NULL default ‘0’ COMMENT ‘标志’,
  allowadmincp tinyint(1) NOT NULL default ‘0’ COMMENT ‘标志’,
  onlyacceptfriendpm tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否只接收好友短消息’,
  conisbind tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘用户是否绑定QQConnect’,
  PRIMARY KEY  (uid),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `groupid` (`groupid`),
  KEY `conisbind` (`conisbind`)
) ENGINE=MyISAM COMMENT=’用户主表';

CREATE TABLE pre_common_member_count (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  extcredits1 int(10) NOT NULL default ‘0’ COMMENT ‘声望’,
  extcredits2 int(10) NOT NULL default ‘0’ COMMENT ‘金钱’,
  extcredits3 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  extcredits4 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  extcredits5 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  extcredits6 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  extcredits7 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  extcredits8 int(10) NOT NULL default ‘0’ COMMENT ‘扩展’,
  friends smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘好友个数 home’,
  posts mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘帖子数’,
  threads mediumint(8) unsigned NOT NULL default ‘0’,
  digestposts smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘精华数’,
  doings smallint(6) unsigned NOT NULL default ‘0’,
  blogs smallint(6) unsigned NOT NULL default ‘0’,
  albums smallint(6) unsigned NOT NULL default ‘0’,
  sharings smallint(6) unsigned NOT NULL default ‘0’,
  attachsize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传附件占用的空间 home’,
  views mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘空间查看数’,
  oltime smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘在线时间’,
  todayattachs smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘当天上传附件数’,
  todayattachsize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘当天上传附件容量’,
  PRIMARY KEY  (uid),
  KEY posts (posts)
) ENGINE=MyISAM COMMENT=’用户统计表';

CREATE TABLE pre_common_member_field_forum (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  publishfeed tinyint(3) NOT NULL default ‘0’ COMMENT ‘用户自定义发送哪些类型的feed(原字段为customaddfeed)’,
  customshow tinyint(1) unsigned NOT NULL default ’26’ COMMENT ‘自定义帖子显示模式’,
  customstatus varchar(30) NOT NULL default ” COMMENT ‘自定义头衔’,
  medals text NOT NULL COMMENT ‘勋章信息’,
  sightml text NOT NULL COMMENT ‘签名’,
  groupterms text NOT NULL COMMENT ‘公共用户组’,
  authstr varchar(20) NOT NULL default ” COMMENT ‘找回密码验证串’,
  groups mediumtext NOT NULL COMMENT ‘用户所有群组’,
  attentiongroup varchar(255) NOT NULL default ” COMMENT ‘用户偏好’,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM COMMENT=’用户论坛字段表';

CREATE TABLE pre_common_member_field_home (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  videophoto varchar(255) NOT NULL default ” COMMENT ‘视频认证照片地址 home’,
  spacename varchar(255) NOT NULL default ” COMMENT ‘空间名称’,
  spacedescription varchar(255) NOT NULL default ” COMMENT ‘空间简介’,
  `domain` char(15) NOT NULL default ” COMMENT ‘空间绑定二级域名 home’,
  addsize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘额外授予的上传空间 home’,
  addfriend smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘额外允许增加的好友数 home’,
  menunum smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘应用显示个数’,
  theme varchar(20) NOT NULL default ” COMMENT ‘空间风格主题 home’,
  spacecss text NOT NULL COMMENT ‘个人空间自定义css home’,
  blockposition text NOT NULL COMMENT ‘个人空间自定义模块位置及相关参数 home’,
  recentnote text NOT NULL COMMENT ‘最近一次行为记录’,
  spacenote text NOT NULL COMMENT ‘最近一次twitter’,
  privacy text NOT NULL COMMENT ‘home隐私设置(注意要和论坛发feed等开关的设置结合)’,
  feedfriend mediumtext NOT NULL COMMENT ‘接受feed的好友缓存’,
  acceptemail text NOT NULL COMMENT ‘接受新通知邮件及设置邮件接收参数’,
  magicgift text NOT NULL COMMENT ‘道具红包卡相关信息’,
  stickblogs text NOT NULL COMMENT ‘置顶的日志ID’,
  PRIMARY KEY  (uid),
  KEY domain (domain)
) ENGINE=MyISAM COMMENT=’用户家园字段表';

CREATE TABLE pre_common_member_action_log (
  id mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘记录id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘用户ID’,
  `action` tinyint(5) NOT NULL default ‘0’ COMMENT ‘操作代码’,
  dateline int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (id),
  KEY dateline (dateline, `action`, uid)
) ENGINE=MyISAM COMMENT=’用户操作日志表';

CREATE TABLE pre_common_member_connect (
  `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  `conuin` char(40) NOT NULL default ” COMMENT ‘QQConnect的access token’,
  `conuinsecret` char(16) NOT NULL default ” COMMENT ‘QQConnect的access token secret’,
  `conopenid` char(32) NOT NULL default ” COMMENT ‘QQConnect的openid’,
  `conisfeed` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘用户是否授权发Feed’,
  `conispublishfeed` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否默认往QQConnect发Feed’,
  `conispublisht` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否默认往QQConnect发微博’,
  `conisregister` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是QQConnect直接注册用户’,
  `conisqzoneavatar` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否使用Qzone头像’,
  PRIMARY KEY  (`uid`),
  KEY `conuin` (`conuin`)
) ENGINE=MyISAM COMMENT=’QQConnect用户表';

CREATE TABLE pre_common_member_log (
  uid mediumint(8) unsigned NOT NULL default ‘0’,
  `action` char(10) NOT NULL default ” COMMENT ‘add,update,delete’,
  dateline int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM COMMENT=’漫游用户日志表';

CREATE TABLE pre_common_member_profile (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  realname varchar(255) NOT NULL default ” COMMENT ‘实名’,
  gender tinyint(1) NOT NULL default ‘0’ COMMENT ‘性别\n(0:保密 1:男 2:女)’,
  birthyear smallint(6) unsigned NOT NULL default ‘0’,
  birthmonth tinyint(3) unsigned NOT NULL default ‘0’,
  birthday tinyint(3) unsigned NOT NULL default ‘0’,
  constellation varchar(255) NOT NULL default ” COMMENT ‘星座(根据生日自动计算)’,
  zodiac varchar(255) NOT NULL default ” COMMENT ‘生肖(根据生日自动计算)’,
  telephone varchar(255) NOT NULL default ” COMMENT ‘固定电话’,
  mobile varchar(255) NOT NULL default ” COMMENT ‘手机’,
  idcardtype varchar(255) NOT NULL default ” COMMENT ‘证件类型:身份证 护照 军官证等’,
  idcard varchar(255) NOT NULL default ” COMMENT ‘证件号码’,
  address varchar(255) NOT NULL default ” COMMENT ‘邮寄地址’,
  zipcode varchar(255) NOT NULL default ” COMMENT ‘邮编’,
  nationality varchar(255) NOT NULL default ” COMMENT ‘国籍’,
  birthprovince varchar(255) NOT NULL default ” COMMENT ‘出生省份’,
  birthcity varchar(255) NOT NULL default ” COMMENT ‘出生城市’,
  birthdist varchar(20) NOT NULL default ” COMMENT ‘出生行政区/县’,
  birthcommunity varchar(255) NOT NULL default ” COMMENT ‘出生小区’,
  resideprovince varchar(255) NOT NULL default ” COMMENT ‘居住省份’,
  residecity varchar(255) NOT NULL default ” COMMENT ‘居住城市’,
  residedist varchar(20) NOT NULL default ” COMMENT ‘居住行政区/县’,
  residecommunity varchar(255) NOT NULL default ” COMMENT ‘居住小区’,
  residesuite varchar(255) NOT NULL default ” COMMENT ‘小区、写字楼门牌号’,
  graduateschool varchar(255) NOT NULL default ” COMMENT ‘毕业学校’,
  company varchar(255) NOT NULL default ” COMMENT ‘ 公司’,
  education varchar(255) NOT NULL default ” COMMENT ‘ 学历’,
  occupation varchar(255) NOT NULL default ” COMMENT ‘ 职业’,
  `position` varchar(255) NOT NULL default ” COMMENT ‘职位’,
  revenue varchar(255) NOT NULL default ” COMMENT ‘ 年收入’,
  affectivestatus varchar(255) NOT NULL default ” COMMENT ‘ 情感状态’,
  lookingfor varchar(255) NOT NULL default ” COMMENT ‘ 交友目的(交友类型)’,
  bloodtype varchar(255) NOT NULL default ” COMMENT ‘血型’,
  height varchar(255) NOT NULL default ” COMMENT ‘ 身高’,
  weight varchar(255) NOT NULL default ” COMMENT ‘ 体重’,
  alipay varchar(255) NOT NULL default ” COMMENT ‘支付宝帐号’,
  icq varchar(255) NOT NULL default ” COMMENT ‘ICQ’,
  qq varchar(255) NOT NULL default ” COMMENT ‘QQ’,
  yahoo varchar(255) NOT NULL default ” COMMENT ‘YAHOO’,
  msn varchar(255) NOT NULL default ” COMMENT ‘MSN’,
  taobao varchar(255) NOT NULL default ” COMMENT ‘阿里旺旺’,
  site varchar(255) NOT NULL default ” COMMENT ‘主页’,
  bio text NOT NULL COMMENT ‘自我介绍 来自论坛bio字段’,
  interest text NOT NULL COMMENT ‘兴趣爱好’,
  field1 text NOT NULL COMMENT ‘自定义字段1′,
  field2 text NOT NULL COMMENT ‘自定义字段2′,
  field3 text NOT NULL COMMENT ‘自定义字段3′,
  field4 text NOT NULL COMMENT ‘自定义字段4′,
  field5 text NOT NULL COMMENT ‘自定义字段5′,
  field6 text NOT NULL COMMENT ‘自定义字段6′,
  field7 text NOT NULL COMMENT ‘自定义字段7′,
  field8 text NOT NULL COMMENT ‘自定义字段8′,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM COMMENT=’用户栏目表';

CREATE TABLE pre_common_member_verify (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  verify1 tinyint(1) NOT NULL default ‘0’ COMMENT ‘认证1: -1:被拒绝 0:待审核 1:审核通过’,
  verify2 tinyint(1) NOT NULL default ‘0’ COMMENT ‘认证2: -1:被拒绝 0:待审核 1:审核通过’,
  verify3 tinyint(1) NOT NULL default ‘0’ COMMENT ‘认证3: -1:被拒绝 0:待审核 1:审核通过’,
  verify4 tinyint(1) NOT NULL default ‘0’ COMMENT ‘认证4: -1:被拒绝 0:待审核 1:审核通过’,
  verify5 tinyint(1) NOT NULL default ‘0’ COMMENT ‘认证5: -1:被拒绝 0:待审核 1:审核通过’,
  verify6 tinyint(1) NOT NULL default ‘0’ COMMENT ‘实名认证: -1:被拒绝 0:待审核 1:审核通过’,
  verify7 tinyint(1) NOT NULL default ‘0’ COMMENT ‘视频认证: -1:被拒绝 0:待审核 1:审核通过’,
  PRIMARY KEY (uid),
  KEY verify1 (verify1),
  KEY verify2 (verify2),
  KEY verify3 (verify3),
  KEY verify4 (verify4),
  KEY verify5 (verify5),
  KEY verify6 (verify6),
  KEY verify7 (verify7)
) ENGINE=MyISAM COMMENT=’用户认证表';

CREATE TABLE pre_common_member_verify_info (
  vid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘审核id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  username varchar(30) NOT NULL default ” COMMENT ‘用户名’,
  verifytype tinyint(1) NOT NULL default ‘0’ COMMENT ‘审核类型0:资料审核, 1:认证1, 2:认证2, 3:认证3, 4:认证4, 5:认证5′,
  flag tinyint(1) NOT NULL default ‘0’ COMMENT ‘-1:被拒绝 0:待审核 1:审核通过’,
  field text NOT NULL COMMENT ‘序列化存储变化值’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘提交日期’,
  PRIMARY KEY (vid),
  KEY verifytype (verifytype, flag),
  KEY uid (uid, verifytype, dateline)
) ENGINE=MyISAM COMMENT=’个人信息修改审核';

CREATE TABLE pre_common_member_profile_setting (
  fieldid varchar(255) NOT NULL default ” COMMENT ‘profile字段标志符’,
  available tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否可用’,
  invisible tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否隐藏’,
  needverify tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否需要审核’,
  title varchar(255) NOT NULL default ” COMMENT ‘栏目标题’,
  description varchar(255) NOT NULL default ” COMMENT ‘解释说明’,
  displayorder smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  required tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否必填内容’,
  unchangeable tinyint(1) NOT NULL default ‘0’ COMMENT ‘不可修改’,
  showincard tinyint(1) NOT NULL default ‘0’ COMMENT ‘在名片中显示’,
  showinthread tinyint(1) NOT NULL default ‘0’ COMMENT ‘在帖子中显示’,
  showinregister tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否在注册页面显示’,
  allowsearch tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否可搜索’,
  formtype varchar(255) NOT NULL COMMENT ‘表单元素类型’,
  size smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘内容最大长度’,
  choices text NOT NULL COMMENT ‘选填内容’,
  validate text NOT NULL COMMENT ‘验证数据的正则表达式’,
  PRIMARY KEY  (fieldid)
) ENGINE=MyISAM  COMMENT=’个人信息扩展表’ ;

CREATE TABLE pre_common_member_security (
  securityid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘审核项id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  username varchar(255) NOT NULL default ” COMMENT ‘用户名’,
  fieldid varchar(255) NOT NULL default ” COMMENT ‘profile字段标志符’,
  oldvalue text NOT NULL COMMENT ‘旧的profile字段值’,
  newvalue text NOT NULL COMMENT ‘新的profile字段值’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘提交日期’,
  PRIMARY KEY  (securityid),
  KEY uid (uid, fieldid),
  KEY dateline (dateline)
) ENGINE=MyISAM COMMENT=’个人信息修改审核';

CREATE TABLE pre_common_member_status (
  uid mediumint(8) unsigned NOT NULL COMMENT ‘会员id’,
  regip char(15) NOT NULL default ” COMMENT ‘注册IP’,
  lastip char(15) NOT NULL default ” COMMENT ‘最后登录IP’,
  lastvisit int(10) unsigned NOT NULL default ‘0’ COMMENT ‘最后访问’,
  lastactivity int(10) unsigned NOT NULL default ‘0’ COMMENT ‘最后活动’,
  lastpost int(10) unsigned NOT NULL default ‘0’ COMMENT ‘最后发表’,
  lastsendmail int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上次发送email时间 home原字段为lastsend’,
  invisible tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否隐身登录’,
  buyercredit smallint(6) NOT NULL default ‘0’ COMMENT ‘买家信用等级及积分’,
  sellercredit smallint(6) NOT NULL default ‘0’ COMMENT ‘卖家信用等级及积分’,
  favtimes mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘个人空间收藏次数’,
  sharetimes mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘个人空间分享次数’,
  profileprogress tinyint(2) unsigned NOT NULL default ‘0’ COMMENT ‘个人资料完成度’,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM COMMENT=’用户状态表';

CREATE TABLE pre_common_member_stat_field (
  optionid  mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘资料统计项 id’,
  fieldid varchar(255) NOT NULL default ” COMMENT ‘资料项字段标志符’,
  fieldvalue varchar(255) NOT NULL default ” COMMENT ‘字段值’ ,
  hash varchar(255) NOT NULL default ” COMMENT ‘由fieldid和fieldvalue生成的hash’,
  users mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘对应用户数’,
  updatetime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘更新时间’,
  PRIMARY KEY (optionid),
  KEY fieldid (fieldid)
) ENGINE=MyISAM COMMENT=’用户资料统计项';

CREATE TABLE pre_common_member_stat_fieldcache (
  optionid  mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘资料统计项 id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘用户id’,
  PRIMARY KEY  (optionid, uid)
) ENGINE=MyISAM COMMENT=’搜索统计项用户ID缓存表';

CREATE TABLE pre_common_member_stat_search (
  optionid  mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘搜索统计项 id’,
  title varchar(255) NOT NULL default ” COMMENT ‘搜索统计项名称’ ,
  `condition` text NOT NULL COMMENT ‘检索条件’ ,
  hash varchar(255) NOT NULL default ” COMMENT ‘检索条件 hash’,
  users mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘对应用户数’,
  updatetime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘更新时间’,
  PRIMARY KEY  (optionid),
  KEY hash (hash)
) ENGINE=MyISAM COMMENT=’用户资料由搜索保存的统计项’ AUTO_INCREMENT=1;

CREATE TABLE pre_common_member_stat_searchcache (
  optionid  mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘搜索统计项 id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘用户id’,
  PRIMARY KEY  (optionid, uid)
) ENGINE=MyISAM COMMENT=’搜索统计项用户ID缓存表';

CREATE TABLE pre_common_member_validate (
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  submitdate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘提交日期’,
  moddate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘审核日期’,
  admin varchar(15) NOT NULL default ” COMMENT ‘管理员名’,
  submittimes tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘提交的次数’,
  `status` tinyint(1) NOT NULL default ‘0’ COMMENT ‘状态’,
  message text NOT NULL COMMENT ‘注册原因’,
  remark text NOT NULL COMMENT ‘管理员留言’,
  PRIMARY KEY  (uid),
  KEY `status` (`status`)
) ENGINE=MyISAM COMMENT=’用户审核表';

CREATE TABLE pre_common_member_grouppm (
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  gpmid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘消息id’,
  status tinyint(1) NOT NULL default ‘0’ COMMENT ‘0=未读 1=已读 -1=删除’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘阅读时间’,
  PRIMARY KEY  (uid, gpmid)
) ENGINE=MyISAM COMMENT=’群发短消息用户记录表';

CREATE TABLE pre_connect_memberbindlog (
     `mblid` mediumint(8) unsigned NOT NULL auto_increment,
     `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘pk’,
     `uin` char(40) NOT NULL COMMENT ‘connect uin’,
     `type` tinyint(1) NOT NULL default ‘0’ COMMENT ‘1=绑定/2=解绑’,
     `dateline` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘创建时间’,
     PRIMARY KEY  (`mblid`),
     KEY `uid` (`uid`),
     KEY `uin` (`uin`),
     KEY `dateline` (`dateline`)
) ENGINE=MyISAM COMMENT=’Connect 用户绑定/解绑记录表';

CREATE TABLE pre_connect_feedlog (
    `flid` mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘pk’,
    `tid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
    `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘用户id’,
    `publishtimes` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘调用次数’,
    `lastpublished` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘时间推送feed时间’,
    `dateline` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘创建时间’,
    `status` tinyint(1) NOT NULL default ‘1’ COMMENT ‘1=未推送;2=已推送;3=推送成功;4=已删除’,
    PRIMARY KEY  (`flid`),
    UNIQUE KEY `tid` (`tid`)
) ENGINE=MyISAM COMMENT=’Connect feed日志表';

CREATE TABLE pre_connect_tlog (
    `tlid` mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘pk’,
    `tid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
    `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘用户id’,
    `publishtimes` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘调用次数’,
    `lastpublished` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘时间推送feed时间’,
    `dateline` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘创建时间’,
    `status` tinyint(1) NOT NULL default ‘1’ COMMENT ‘1=未推送;2=已推送;3=推送成功;4=已删除’,
    PRIMARY KEY  (`tlid`),
    UNIQUE KEY `tid` (`tid`)
) ENGINE=MyISAM COMMENT=’微博日志表';

CREATE TABLE pre_common_uin_black (
     `uin` char(40) NOT NULL COMMENT ‘connect uin’,
     `uid` mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘pk’,
     `dateline` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘创建时间’,
     PRIMARY KEY  (`uin`),
     UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM COMMENT=’UIN 黑名单';

CREATE TABLE pre_common_grouppm (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘消息id’,
  authorid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘作者id’,
  author varchar(15) NOT NULL default ” COMMENT ‘作者姓名’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘时间’,
  message text NOT NULL COMMENT ‘消息’,
  numbers mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘数量’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’群发短消息表';

CREATE TABLE pre_common_myapp (
  appid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘应用id’,
  appname varchar(60) NOT NULL default ” COMMENT ‘应用名称’,
  narrow tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否显示为窄的profile box’,
  flag tinyint(1) NOT NULL default ‘0’ COMMENT ‘应用状态(黑白名单、默认应用等)’,
  version mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘应用版本号’,
  userpanelarea tinyint(1) NOT NULL default ‘0’ COMMENT ‘userabout显示区域、1主区、2、副区、3应用区’,
  canvastitle varchar(60) NOT NULL default ” COMMENT ‘canvas页面标题’,
  fullscreen tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否是全屏应用’,
  displayuserpanel tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否显示应用右侧的用户菜单’,
  displaymethod tinyint(1) NOT NULL default ‘0’ COMMENT ‘显示方式(iframe/myml)’,
  displayorder smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  appstatus tinyint(2) NOT NULL default ‘0’ COMMENT ‘标识应用1:新、2:热’,
  iconstatus tinyint(2) NOT NULL default ‘0’ COMMENT ‘应用图标是否已下载到本地。-1:失败;0:未下载;1:已下载’,
  icondowntime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘应用图标下载到本地时间’,
  PRIMARY KEY (appid),
  KEY flag (flag,displayorder)
) ENGINE=MyISAM COMMENT=’漫游应用表';

CREATE TABLE pre_common_myinvite (
  id mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘邀请id’,
  typename varchar(100) NOT NULL default ” COMMENT ‘邀请名称’,
  appid mediumint(8) NOT NULL default ‘0’ COMMENT ‘应用id’,
  `type` tinyint(1) NOT NULL default ‘0’ COMMENT ‘类型(request 邀请/invite 请求)’,
  fromuid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘邀请者id’,
  touid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘接收者id’,
  myml text NOT NULL COMMENT ‘邀请内容’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘发送邀请的时间戳’,
  `hash` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘hash标记’,
  PRIMARY KEY  (id),
  KEY `hash` (`hash`),
  KEY uid (touid,dateline)
) ENGINE=MyISAM COMMENT=’用户邀请表';

CREATE TABLE pre_common_nav (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘项目id’,
  parentid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘父 id(navtype=0)’,
  `name` varchar(255) NOT NULL COMMENT ‘导航名称’,
  title varchar(255) NOT NULL COMMENT ‘导航说明’,
  url varchar(255) NOT NULL COMMENT ‘导航链接’,
  identifier varchar(255) NOT NULL COMMENT ‘链接标识/相关ID’,
  target tinyint(1) NOT NULL default ‘0’ COMMENT ‘目标框架\n(0:本窗口 1:新窗口)’,
  `type` tinyint(1) NOT NULL default ‘0’ COMMENT ‘类型 0 系统  1 自定义 3 插件 4 频道’,
  available tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否可用’,
  displayorder tinyint(3) NOT NULL COMMENT ‘显示顺序’,
  highlight tinyint(1) NOT NULL default ‘0’ COMMENT ‘样式(navtype=0)’,
  `level` tinyint(1) NOT NULL default ‘0’ COMMENT ‘使用等级\n(0:游客 1:会员 2:版主 3:管理员)’,
  `subtype` tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘二级导航样式(navtype=0) 顶部导航位置(navtype=4)’,
  `subcols` tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘横排一行显示的条目数(navtype=0)’,
  `icon` varchar(255) NOT NULL COMMENT ‘图标地址(navtype=1、3)’,
  `subname` varchar(255) NOT NULL COMMENT ‘副导航名称(navtype=1)’,
  `suburl` varchar(255) NOT NULL COMMENT ‘副导航地址(navtype=1)’,
  `navtype` tinyint(1) NOT NULL default ‘0’ COMMENT ‘导航类型\n(0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航)’,
  logo varchar(255) NOT NULL COMMENT ‘自定义 Logo’,
  PRIMARY KEY  (id),
  KEY `navtype` (`navtype`)
) ENGINE=MyISAM COMMENT=’自定义导航栏表';

CREATE TABLE pre_common_onlinetime (
  uid mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
  thismonth smallint(6) unsigned NOT NULL DEFAULT ‘0’,
  total mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
  lastupdate int(10) unsigned NOT NULL DEFAULT ‘0’,
  PRIMARY KEY (uid)
) ENGINE=MyISAM COMMENT ‘在线时间表';

CREATE TABLE pre_common_regip (
  ip char(15) NOT NULL default ” COMMENT ‘IP地址’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘限制时间’,
  count smallint(6) NOT NULL default ‘0’ COMMENT ‘限制数量’,
  KEY ip (ip)
) ENGINE=MyISAM COMMENT=’注册IP限制表';

CREATE TABLE pre_common_secquestion (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘验证问题id’,
  `type` tinyint(1) unsigned NOT NULL COMMENT ‘验证问题类型’,
  question text NOT NULL COMMENT ‘验证问题’,
  answer varchar(255) NOT NULL COMMENT ‘问题答案’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’验证问题数据表’ ;

CREATE TABLE pre_common_session (
  sid char(6) NOT NULL default ” COMMENT ‘sid’,
  ip1 tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘IP段’,
  ip2 tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘IP段’,
  ip3 tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘IP段’,
  ip4 tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘IP段’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  username char(15) NOT NULL default ” COMMENT ‘会员名’,
  groupid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘会员组’,
  invisible tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否隐身登录’,
  `action` tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘当前动作’,
  lastactivity int(10) unsigned NOT NULL default ‘0’ COMMENT ‘最后活动时间’,
  lastolupdate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘在线时间最后更新’,
  fid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘论坛id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  UNIQUE KEY sid (sid),
  KEY uid (uid)
) ENGINE=MEMORY COMMENT=’会员认证表';

CREATE TABLE pre_common_setting (
  skey varchar(255) NOT NULL default ” COMMENT ‘变量名’,
  svalue text NOT NULL COMMENT ‘值’,
  PRIMARY KEY  (skey)
) ENGINE=MyISAM COMMENT=’设置表';

CREATE TABLE pre_common_smiley (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘表情id’,
  typeid smallint(6) unsigned NOT NULL COMMENT ‘表情分类 id’,
  displayorder tinyint(1) NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  `type` enum(‘smiley’,’stamp’,’stamplist’) NOT NULL default ‘smiley’ COMMENT ‘类型’,
  `code` varchar(30) NOT NULL default ” COMMENT ‘标记’,
  url varchar(30) NOT NULL default ” COMMENT ‘路径’,
  PRIMARY KEY  (id),
  KEY `type` (`type`, displayorder)
) ENGINE=MyISAM COMMENT=’表情表’ ;

CREATE TABLE pre_common_stat (
  daytime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘时间’,
  login int(10) unsigned NOT NULL default ‘0’ COMMENT ‘登陆’,
  mobilelogin int(10) unsigned NOT NULL default ‘0’ COMMENT ‘手机登陆’,
  connectlogin int(10) unsigned NOT NULL default ‘0’ COMMENT ‘QQConnect登陆’,
  register int(10) unsigned NOT NULL default ‘0’ COMMENT ‘注册’,
  invite int(10) unsigned NOT NULL default ‘0’ COMMENT ‘邀请’,
  appinvite int(10) unsigned NOT NULL default ‘0’ COMMENT ‘应用邀请’,
  doing int(10) unsigned NOT NULL default ‘0’ COMMENT ‘记录’,
  blog int(10) unsigned NOT NULL default ‘0’ COMMENT ‘日志’,
  pic int(10) unsigned NOT NULL default ‘0’ COMMENT ‘图片’,
  poll int(10) unsigned NOT NULL default ‘0’ COMMENT ‘投票’,
  activity int(10) unsigned NOT NULL default ‘0’ COMMENT ‘活动’,
  `share` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘分享’,
  thread int(10) unsigned NOT NULL default ‘0’ COMMENT ‘主题’,
  docomment int(10) unsigned NOT NULL default ‘0’ COMMENT ‘记录评论’,
  blogcomment int(10) unsigned NOT NULL default ‘0’ COMMENT ‘日志评论’,
  piccomment int(10) unsigned NOT NULL default ‘0’ COMMENT ‘图片评论’,
  sharecomment int(10) unsigned NOT NULL default ‘0’ COMMENT ‘分享评论’,
  reward int(10) unsigned NOT NULL default ‘0’ COMMENT ‘悬赏’,
  debate int(10) unsigned NOT NULL default ‘0’ COMMENT ‘辩论’,
  trade int(10) unsigned NOT NULL default ‘0’ COMMENT ‘商品’,
  `group` int(10) unsigned NOT NULL default ‘0’ COMMENT ‘群组’,
  groupjoin int(10) unsigned NOT NULL default ‘0’ COMMENT ‘参与群组’,
  groupthread int(10) unsigned NOT NULL default ‘0’ COMMENT ‘群组主题’,
  grouppost int(10) unsigned NOT NULL default ‘0’ COMMENT ‘群组回复’,
  post int(10) unsigned NOT NULL default ‘0’ COMMENT ‘主题回复’,
  wall int(10) unsigned NOT NULL default ‘0’ COMMENT ‘留言’,
  poke int(10) unsigned NOT NULL default ‘0’ COMMENT ‘打招呼’,
  click int(10) unsigned NOT NULL default ‘0’ COMMENT ‘表态’,
  sendpm int(10) unsigned NOT NULL default ‘0’ COMMENT ‘发送PM’,
  friend int(10) unsigned NOT NULL default ‘0’ COMMENT ‘成为好友’,
  addfriend int(10) unsigned NOT NULL default ‘0’ COMMENT ‘好友请求’,
  PRIMARY KEY  (daytime)
) ENGINE=MyISAM COMMENT=’趋势统计';

CREATE TABLE pre_common_statuser (
  uid mediumint(8) unsigned NOT NULL default ‘0’,
  daytime int(10) unsigned NOT NULL default ‘0’,
  `type` char(20) NOT NULL default ”,
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’统计用户表';

CREATE TABLE pre_common_style (
  styleid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘风格id’,
  `name` varchar(20) NOT NULL default ” COMMENT ‘风格名称’,
  available tinyint(1) NOT NULL default ‘1’ COMMENT ‘风格是否可用’,
  templateid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘对应模板id’,
  extstyle varchar(255) NOT NULL default ” COMMENT ‘配色’,
  PRIMARY KEY  (styleid)
) ENGINE=MyISAM COMMENT=’风格表’ ;

CREATE TABLE pre_common_stylevar (
  stylevarid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘风格变量id’,
  styleid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘风格id’,
  variable text NOT NULL COMMENT ‘变量名’,
  substitute text NOT NULL COMMENT ‘变量赋值’,
  PRIMARY KEY  (stylevarid),
  KEY styleid (styleid)
) ENGINE=MyISAM COMMENT=’风格变量表’ ;

CREATE TABLE pre_common_syscache (
  cname varchar(32) NOT NULL COMMENT ‘缓存名称’,
  `ctype` tinyint(3) unsigned NOT NULL COMMENT ‘缓存类型 0=value, serialize=1′,
  dateline int(10) unsigned NOT NULL COMMENT ‘缓存生成时间’,
  `data` mediumblob NOT NULL COMMENT ‘缓存数据’,
  PRIMARY KEY  (cname)
) ENGINE=MyISAM COMMENT=’缓存数据表';

CREATE TABLE pre_common_template (
  templateid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘模板id’,
  `name` varchar(30) NOT NULL default ” COMMENT ‘名称’,
  `directory` varchar(100) NOT NULL default ” COMMENT ‘目录’,
  copyright varchar(100) NOT NULL default ” COMMENT ‘版权’,
  PRIMARY KEY  (templateid)
) ENGINE=MyISAM COMMENT=’模板表';

CREATE TABLE pre_common_usergroup (
  groupid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘会员组id’,
  radminid tinyint(3) NOT NULL default ‘0’ COMMENT ‘关联关管理组’,
  `type` enum(‘system’,’special’,’member’) NOT NULL default ‘member’ COMMENT ‘类型’,
  system varchar(255) NOT NULL default ‘private’ COMMENT ‘会员是否可以自由进出’,
  grouptitle varchar(255) NOT NULL default ” COMMENT ‘组头衔’,
  creditshigher int(10) NOT NULL default ‘0’ COMMENT ‘该组的积分上限’,
  creditslower int(10) NOT NULL default ‘0’ COMMENT ‘该组的积分下限’,
  stars tinyint(3) NOT NULL default ‘0’ COMMENT ‘星星数量’,
  color varchar(255) NOT NULL default ” COMMENT ‘组头衔颜色’,
  icon varchar(255) NOT NULL default ”,
  allowvisit tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许访问’,
  allowsendpm tinyint(1) NOT NULL default ‘1’ COMMENT ‘是否允许发送短信息’,
  allowinvite tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许使用邀请注册’,
  allowmailinvite tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许通过论坛邮件系统发送邀请码’,
  maxinvitenum tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘最大邀请码拥有数量’,
  inviteprice smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘邀请码购买价格’,
  maxinviteday smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘邀请码有效期’,
  PRIMARY KEY  (groupid),
  KEY creditsrange (creditshigher,creditslower)
) ENGINE=MyISAM COMMENT=’用户组表';

CREATE TABLE pre_common_usergroup_field (
  groupid smallint(6) unsigned NOT NULL COMMENT ‘会员组id’,
  readaccess tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  allowpost tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许发帖’,
  allowreply tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许回复’,
  allowpostpoll tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许发表投票’,
  allowpostreward tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许发表悬赏’,
  allowposttrade tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许发表交易’,
  allowpostactivity tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许发表活动’,
  allowdirectpost 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 ‘允许上传图片’,
  allowvote tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许参与投票’,
  allowsearch tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许搜索’,
  allowcstatus tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许自定义头衔’,
  allowinvisible tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许隐身登录’,
  allowtransfer tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许积分转帐’,
  allowsetreadperm tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许设置阅读权限’,
  allowsetattachperm tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许设置附件权限’,
  allowposttag tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许使用标签’,
  allowhidecode tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许使用hide代码’,
  allowhtml tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许使用html’,
  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 mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘最大附件尺寸’,
  maxsizeperday int(10) 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 ‘是否不受“只接收好友短消息”设置的限制’,
  maximagesize mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘相册中允许最大图片大小’,
  allowmediacode tinyint(1) NOT NULL default ‘0’ COMMENT ‘允许使用多媒体代码’,
  PRIMARY KEY  (groupid)
) ENGINE=MyISAM COMMENT=’会员用户组权限表';

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=’词语过滤表’ ;

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=’词语过滤分类’ ;

CREATE TABLE pre_common_tag (
  tagid smallint(6) unsigned NOT NULL auto_increment COMMENT ‘标签id’,
  tagname varchar(20) NOT NULL default ” COMMENT ‘标签名’,
  status tinyint(1) NOT NULL default ‘0’ COMMENT ‘显示状态\n(0:正常 1:关闭 2:推荐)’,
  PRIMARY KEY  (tagid),
  KEY tagname (tagname),
  KEY status (status, tagid)
) ENGINE=MyISAM COMMENT=’标签表’ ;

CREATE TABLE pre_common_tagitem (
  tagid smallint(6) NOT NULL default ‘0’ COMMENT ‘标签id’,
  tagname varchar(20) NOT NULL default ” COMMENT ‘标签名’,
  itemid mediumint(8) NOT NULL default ‘0’ COMMENT ‘itemid’,
  idtype varchar(255) NOT NULL default ” COMMENT ‘内容类型’,
  KEY tagid (tagid, idtype),
  KEY idtype (idtype, itemid)
) ENGINE=MyISAM COMMENT=’标签内容表’ ;

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=’访问权限表';

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 ‘报名截止日期’,
  ufield TEXT NOT NULL COMMENT ‘用户定制项目’,
  credit smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘需消耗的积分’,
  PRIMARY KEY  (tid),
  KEY uid (uid,starttimefrom),
  KEY starttimefrom (starttimefrom),
  KEY expiration (expiration),
  KEY applynumber (applynumber)
) ENGINE=MyISAM COMMENT=’活动表';

CREATE TABLE pre_forum_activityapply (
  applyid int(10) unsigned NOT NULL auto_increment COMMENT ‘申请id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  username varchar(255) NOT NULL default ” COMMENT ‘用户名’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  message varchar(255) NOT NULL default ” COMMENT ‘消息’,
  verified tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否审核通过\n(0:N 1:Y 2:需完善资料)’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘申请时间’,
  payment mediumint(8) NOT NULL default ‘0’ COMMENT ‘每人花销’,
  ufielddata TEXT NOT NULL COMMENT ‘用户定制项目数据’,
  PRIMARY KEY  (applyid),
  KEY uid (uid),
  KEY tid (tid),
  KEY dateline (tid,dateline)
) ENGINE=MyISAM COMMENT=’活动申请表';

CREATE TABLE pre_common_addon (
  `key` varchar(255) NOT NULL default ” COMMENT ‘资源提供商ID’,
  title varchar(255) NOT NULL default ” COMMENT ‘名称’,
  sitename varchar(255) NOT NULL default ” COMMENT ‘站点名称’,
  siteurl varchar(255) NOT NULL default ” COMMENT ‘站点 URL’,
  description varchar(255) NOT NULL default ” COMMENT ‘说明’,
  contact varchar(255) NOT NULL default ” COMMENT ‘联系方式’,
  logo varchar(255) NOT NULL default ” COMMENT ‘LOGO 图片 URL’,
  system tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否系统提商(无法删除的)’,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM COMMENT=’扩展中心资源提供商';

CREATE TABLE pre_forum_announcement (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘公告id’,
  author varchar(15) NOT NULL default ” COMMENT ‘作者姓名’,
  `subject` varchar(255) NOT NULL default ” COMMENT ‘公告标题’,
  `type` tinyint(1) NOT NULL default ‘0’ COMMENT ‘公告类型\n(0:文字公告 1:网址链接)’,
  displayorder tinyint(3) NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  starttime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘开始时间’,
  endtime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘结束时间’,
  message text NOT NULL COMMENT ‘消息’,
  groups text NOT NULL COMMENT ‘接受用户组’,
  PRIMARY KEY  (id),
  KEY timespan (starttime,endtime)
) ENGINE=MyISAM COMMENT=’公告表';

CREATE TABLE pre_forum_threadimage (
  `tid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  KEY tid (tid)
) ENGINE=MyISAM COMMENT=’主题图片表';

CREATE TABLE pre_forum_attachment (
  aid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  tableid tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘附件表id’,
  downloads mediumint(8) NOT NULL default ‘0’ COMMENT ‘下载次数’,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件索引表';

CREATE TABLE pre_forum_attachment_unused (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  PRIMARY KEY (aid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’未使用附件表';

CREATE TABLE pre_forum_attachment_0 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_1 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_2 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_3 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_4 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_5 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_6 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_7 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_8 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachment_9 (
  aid mediumint(8) unsigned NOT NULL COMMENT ‘附件id’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘上传时间’,
  filename varchar(255) NOT NULL default ” COMMENT ‘原文件名’,
  filesize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘文件大小’,
  attachment varchar(255) NOT NULL default ” COMMENT ‘服务器路径’,
  remote tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否远程附件’,
  description varchar(255) NOT NULL COMMENT ‘说明’,
  readperm tinyint(3) unsigned NOT NULL default ‘0’ COMMENT ‘阅读权限’,
  price smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件价格’,
  isimage tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否图片’,
  width smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘附件宽度’,
  thumb tinyint(1) unsigned NOT NULL default ‘0’ COMMENT ‘是否是缩率图’,
  picid mediumint(8) NOT NULL default ‘0’ COMMENT ‘相册图片ID ‘,
  PRIMARY KEY (aid),
  KEY tid (tid),
  KEY pid (pid),
  KEY uid (uid)
) ENGINE=MyISAM COMMENT=’附件表';

CREATE TABLE pre_forum_attachtype (
  id smallint(6) unsigned NOT NULL auto_increment COMMENT ‘类型id’,
  extension char(12) NOT NULL default ” COMMENT ‘扩展名’,
  maxsize int(10) unsigned NOT NULL default ‘0’ COMMENT ‘允许上传最大值’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’附件类型表';

CREATE TABLE pre_forum_bbcode (
  id mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘代码id’,
  available tinyint(1) NOT NULL default ‘0’ COMMENT ‘是否启用\n(0:不启用 1:启用但不显示 2:启用并显示)’,
  tag varchar(100) NOT NULL default ” COMMENT ‘标签’,
  icon varchar(255) NOT NULL COMMENT ‘图标’,
  replacement text NOT NULL COMMENT ‘替换内容’,
  example varchar(255) NOT NULL default ” COMMENT ‘例子’,
  explanation text NOT NULL COMMENT ‘解释说明’,
  params tinyint(1) unsigned NOT NULL default ‘1’ COMMENT ‘参数个数’,
  prompt text NOT NULL COMMENT ‘标签描述’,
  nest tinyint(3) unsigned NOT NULL default ‘1’ COMMENT ‘嵌套层次’,
  displayorder tinyint(3) NOT NULL default ‘0’ COMMENT ‘显示顺序’,
  perm text NOT NULL COMMENT ‘有权使用的用户组’,
  PRIMARY KEY  (id)
) ENGINE=MyISAM COMMENT=’Discuz! 代码表';

CREATE TABLE pre_forum_creditslog (
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  fromto char(15) NOT NULL default ” COMMENT ‘来自/到’,
  sendcredits tinyint(1) NOT NULL default ‘0’ COMMENT ‘转出积分字段’,
  receivecredits tinyint(1) NOT NULL default ‘0’ COMMENT ‘接受积分字段’,
  send int(10) unsigned NOT NULL default ‘0’ COMMENT ‘转出积分’,
  receive int(10) unsigned NOT NULL default ‘0’ COMMENT ‘接受积分’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘转帐日期’,
  operation char(3) NOT NULL default ” COMMENT ‘操作’,
  KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT=’转帐记录表';

CREATE TABLE pre_forum_debate (
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘发起人id’,
  starttime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘开始时间’,
  endtime int(10) unsigned NOT NULL default ‘0’ COMMENT ‘结束时间’,
  affirmdebaters mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘正方辩论人数’,
  negadebaters mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘反方辩论人数’,
  affirmvotes mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘正方得票数’,
  negavotes mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘反方得票数’,
  umpire varchar(15) NOT NULL default ” COMMENT ‘裁判用户名’,
  winner tinyint(1) NOT NULL default ‘0’ COMMENT ‘获胜方\n(0:平局 1:为正方 2:为反方)\n裁判评判结果’,
  bestdebater varchar(50) NOT NULL default ” COMMENT ‘最佳辩手用户名’,
  affirmpoint text NOT NULL COMMENT ‘正方观点’,
  negapoint text NOT NULL COMMENT ‘反方观点’,
  umpirepoint text NOT NULL COMMENT ‘裁判观点,裁判结束辩论时填写’,
  affirmvoterids text NOT NULL COMMENT ‘正方投票人的 id 集合’,
  negavoterids text NOT NULL COMMENT ‘反方投票人的 id 集合’,
  affirmreplies mediumint(8) unsigned NOT NULL COMMENT ‘正方回复次数,用来翻页’,
  negareplies mediumint(8) unsigned NOT NULL COMMENT ‘反方回复次数,用来翻页’,
  PRIMARY KEY  (tid),
  KEY uid (uid,starttime)
) ENGINE=MyISAM COMMENT=’辩论主题表';

CREATE TABLE pre_forum_debatepost (
  pid int(10) unsigned NOT NULL default ‘0’ COMMENT ‘帖子id’,
  stand tinyint(1) NOT NULL default ‘0’ COMMENT ‘立场\n(0:中立 1:正方 2:为反方)’,
  tid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘主题id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘发起人id’,
  dateline int(10) unsigned NOT NULL default ‘0’ COMMENT ‘发表的时间’,
  voters mediumint(10) unsigned NOT NULL default ‘0’ COMMENT ‘投票人数’,
  voterids text NOT NULL COMMENT ‘投票人的 id 集合’,
  PRIMARY KEY  (pid),
  KEY pid (pid,stand),
  KEY tid (tid,uid)
) ENGINE=MyISAM COMMENT=’辩论帖子表';

CREATE TABLE pre_forum_faq (
  id smallint(6) NOT NULL auto_increment COMMENT ‘帮助id’,
  fpid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘帮助父id’,
  displayorder tinyint(3) NOT NULL default ‘0’ COMMENT ‘排序’,
  identifier varchar(20) NOT NULL COMMENT ‘帮助标识’,
  keyword varchar(50) NOT NULL COMMENT ‘帮助关键词’,
  title varchar(50) NOT NULL COMMENT ‘帮助标题’,
  message text NOT NULL COMMENT ‘帮助内容’,
  PRIMARY KEY  (id),
  KEY displayplay (displayorder)
) ENGINE=MyISAM COMMENT=’论坛帮助表';

CREATE TABLE pre_home_favorite (
  favid mediumint(8) unsigned NOT NULL auto_increment COMMENT ‘收藏id’,
  uid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘会员id’,
  id mediumint(8) unsigned NOT NULL default ‘0’,
  idtype varchar(255) NOT NULL default ”,
  spaceuid mediumint(8) unsigned NOT NULL default ‘0’ COMMENT ‘空间会员id’,
  title varchar(255) NOT NULL default ”,
  description text NOT NULL,
  dateline int(10) unsigned NOT NULL default ‘0’,
  PRIMARY KEY (favid),
  KEY idtype (id,idtype),
  KEY uid (uid,idtype,dateline)
) ENGINE=MyISAM COMMENT=’收藏表';

未完

详情请看:discuz X2.0 数据库字典,discuz X2.0 数据解析,discuz X2.0 数据表结构《二》

discuz X2.0 数据库字典,discuz X2.0 数据解析, discuz X2.0数据库详解,di […]

  1. 还没有评论
评论提交中, 请稍候...

留言

(Spamcheck Enabled)

Trackbacks & Pingbacks ( 1 )
  1. 八 8th, 2011 @ 10:02 | #1
    Pingback: 挺好