DROP TABLE IF EXISTS pre_common_block_xml;
CREATE TABLE pre_common_block_xml (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) NOT NULL COMMENT 'XML扩展 名称',
`version` varchar(255) NOT NULL COMMENT 'XML扩展 版本',
`url` varchar(255) NOT NULL COMMENT 'XML扩展 URL',
`clientid` varchar(255) NOT NULL COMMENT '客户端ID',
`key` varchar(255) NOT NULL COMMENT '通信密钥',
`signtype` varchar(255) NOT NULL COMMENT '签名的加密方式：目前只支持MD5方式，空为不使用签名，直接使用通信密钥',
`data` text NOT NULL COMMENT 'XML扩展 数据',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='模块 XML 扩展类数据表';


DROP TABLE IF EXISTS pre_common_block_favorite;
CREATE TABLE pre_common_block_favorite (
favid mediumint(8) unsigned NOT NULL auto_increment COMMENT '收藏id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '收藏时间',
PRIMARY KEY (favid),
KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT='模块收藏表';


DROP TABLE IF EXISTS pre_home_blog;
CREATE TABLE pre_home_blog (
blogid mediumint(8) unsigned NOT NULL auto_increment COMMENT '日志ID',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志所属用户ID ',
username char(15) NOT NULL default COMMENT '日志所属用户名',
`subject` char(80) NOT NULL default COMMENT '日志标题',
classid smallint(6) unsigned NOT NULL default '0' COMMENT '个人分类id',
catid smallint(6) unsigned NOT NULL default '0' COMMENT '系统分类id',
viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '日志查看数',
replynum mediumint(8) unsigned NOT NULL default '0' COMMENT '日志回复数',
hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',
dateline int(10) unsigned NOT NULL default '0' COMMENT '日志发布时间',
picflag tinyint(1) NOT NULL default '0' COMMENT '日志是否有图片',
noreply tinyint(1) NOT NULL default '0' COMMENT '是否允许评论:"0"为允许,"1"为不允许 ',
friend tinyint(1) NOT NULL default '0' COMMENT '日志隐私设置:"0"为全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 ',
`password` char(10) NOT NULL default COMMENT '日志密码',
favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '日志收藏次数',
sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '日志分享次数',
`status` tinyint(1) unsigned NOT NULL default '0' COMMENT 'blog状态 1-审核',
click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',
click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',
click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',
click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',
click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',
click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',
click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',
click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',
PRIMARY KEY (blogid),
KEY uid (uid,dateline),
KEY hot (hot),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='日志表';


DROP TABLE IF EXISTS pre_home_blogfield;
CREATE TABLE pre_home_blogfield (
blogid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '日志所属用户ID ',
pic varchar(255) NOT NULL default COMMENT '标题图片',
tag varchar(255) NOT NULL default COMMENT '日志TAG ',
message mediumtext NOT NULL COMMENT '日志内容',
postip varchar(255) NOT NULL default COMMENT '发表日志的IP ',
related text NOT NULL COMMENT '相关日志的数据信息',
relatedtime int(10) unsigned NOT NULL default '0' COMMENT '相关日志产生时间戳',
target_ids text NOT NULL COMMENT '允许查看日志的用户ID多个ID以","间隔 ',
hotuser text NOT NULL COMMENT '热点用户',
magiccolor tinyint(6) NOT NULL default '0' COMMENT '道具彩色灯id',
magicpaper tinyint(6) NOT NULL default '0' COMMENT '道具信纸id',
pushedaid mediumint(8) NOT NULL default '0' COMMENT '被推送到的文章aid',
PRIMARY KEY (blogid),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='日志字段表';


DROP TABLE IF EXISTS pre_home_class;
CREATE TABLE pre_home_class (
classid mediumint(8) unsigned NOT NULL auto_increment COMMENT '个人分类id',
classname char(40) NOT NULL default COMMENT '分类名称',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类所属用户ID ',
dateline int(10) unsigned NOT NULL default '0' COMMENT '分类创建时间戳',
PRIMARY KEY (classid),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='日志个人分类表';


DROP TABLE IF EXISTS pre_home_click;
CREATE TABLE pre_home_click (
clickid smallint(6) unsigned NOT NULL auto_increment COMMENT '表态ID',
`name` char(50) NOT NULL default COMMENT '表态名称',
icon char(100) NOT NULL default COMMENT '表态图标',
idtype char(15) NOT NULL default COMMENT '表态类型',
available tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有效',
displayorder tinyint(6) unsigned NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (clickid),
KEY idtype (idtype, displayorder)
) ENGINE=MyISAM COMMENT='表态动作';


DROP TABLE IF EXISTS pre_home_clickuser;
CREATE TABLE pre_home_clickuser (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '表态用户id',
username varchar(15) NOT NULL default COMMENT '表态用户名',
id mediumint(8) unsigned NOT NULL default '0' COMMENT '作用对象id',
idtype varchar(15) NOT NULL default COMMENT '作用对象id类型',
clickid smallint(6) unsigned NOT NULL default '0' COMMENT '表态id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表表态时间戳',
KEY id (id,idtype,dateline),
KEY uid (uid,idtype,dateline)
) ENGINE=MyISAM COMMENT='用户表态表';


DROP TABLE IF EXISTS pre_home_comment;
CREATE TABLE pre_home_comment (
cid 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' COMMENT '评论对象id',
idtype varchar(20) NOT NULL default COMMENT '评论对象的id类型：blogid，picid，uid',
authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '若为回复,回复作者用户ID ',
author varchar(15) NOT NULL default COMMENT '若为回复,回复作者用户名 ',
ip varchar(20) NOT NULL default COMMENT '评论IP ',
dateline int(10) unsigned NOT NULL default '0' COMMENT '评论时间戳',
message text NOT NULL COMMENT '评论内容',
magicflicker tinyint(1) NOT NULL default '0' COMMENT '是否使用了道具彩虹炫',
status tinyint(1) NOT NULL default '0' COMMENT '评论状态 1-审核',
PRIMARY KEY (cid),
KEY authorid (authorid,idtype),
KEY id (id,idtype,dateline)
) ENGINE=MyISAM COMMENT='用户评论表';


DROP TABLE IF EXISTS pre_home_docomment;
CREATE TABLE pre_home_docomment (
id int(10) unsigned NOT NULL auto_increment COMMENT '记录回复id',
upid int(10) unsigned NOT NULL default '0' COMMENT '上级记录回复id',
doid mediumint(8) unsigned NOT NULL default '0' COMMENT '所评论的记录id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发布记录者用户id',
username varchar(15) NOT NULL default COMMENT '发布记录者用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '记录回复时间戳',
message text NOT NULL COMMENT '记录回复内容',
ip varchar(20) NOT NULL default COMMENT '发布记录ip',
grade smallint(6) unsigned NOT NULL default '0' COMMENT '记录回复的层级',
PRIMARY KEY (id),
KEY doid (doid,dateline),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='用户记录回复表';


DROP TABLE IF EXISTS pre_home_doing;
CREATE TABLE pre_home_doing (
doid mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '记录发布者用户id',
username varchar(15) NOT NULL default COMMENT '记录发布者用户名',
`from` varchar(20) NOT NULL default COMMENT '记录的发表来源',
dateline int(10) unsigned NOT NULL default '0' COMMENT '记录发布时间戳',
message text NOT NULL COMMENT '记录内容',
ip varchar(20) NOT NULL default COMMENT '记录发布ip',
replynum int(10) unsigned NOT NULL default '0' COMMENT '记录回复数',
status tinyint(1) unsigned NOT NULL default '0' COMMENT '记录状态 1-审核',
PRIMARY KEY (doid),
KEY uid (uid,dateline),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='用户记录表';


DROP TABLE IF EXISTS pre_home_feed;
CREATE TABLE pre_home_feed (
feedid int(10) unsigned NOT NULL auto_increment COMMENT 'feed的ID ',
appid smallint(6) unsigned NOT NULL default '0' COMMENT '应用程序ID ',
icon varchar(30) NOT NULL default COMMENT 'feed图标 ',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '产生feed的用户ID ',
username varchar(15) NOT NULL default COMMENT '产生feed的用户名 ',
dateline int(10) unsigned NOT NULL default '0' COMMENT 'feed产生时间戳 ',
friend tinyint(1) NOT NULL default '0' COMMENT '产生feed信息的隐私设置 ',
hash_template varchar(32) NOT NULL default COMMENT '模板hash:md5(title_template"\t"body_template) ',
hash_data varchar(32) NOT NULL default COMMENT '数据内容hash:md5(title_templat"\t"title_data"\t"body_template"\t"body_data) ',
title_template text NOT NULL COMMENT 'feed标题模板 ',
title_data text NOT NULL COMMENT 'feed标题 ',
body_template text NOT NULL COMMENT 'feed内容模板 ',
body_data text NOT NULL COMMENT 'feed内容 ',
body_general text NOT NULL COMMENT '用户填写的信息 ',
image_1 varchar(255) NOT NULL default COMMENT 'feed图1',
image_1_link varchar(255) NOT NULL default COMMENT 'feed图片链接1',
image_2 varchar(255) NOT NULL default COMMENT 'feed图片2',
image_2_link varchar(255) NOT NULL default COMMENT 'feed图片链接2',
image_3 varchar(255) NOT NULL default COMMENT 'feed图片3',
image_3_link varchar(255) NOT NULL default COMMENT 'feed图片链接3',
image_4 varchar(255) NOT NULL default COMMENT 'feed图片4',
image_4_link varchar(255) NOT NULL default COMMENT 'feed图片链接4',
target_ids text NOT NULL COMMENT '产生feed信息允许查看的好友ID ',
id mediumint(8) unsigned NOT NULL default '0' COMMENT 'feed对应对象id',
idtype varchar(15) NOT NULL default COMMENT 'feed对应对象类型',
hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',
PRIMARY KEY (feedid),
KEY uid (uid,dateline),
KEY dateline (dateline),
KEY hot (hot),
KEY id (id,idtype)
) ENGINE=MyISAM COMMENT='站点feed表';


DROP TABLE IF EXISTS pre_home_feed_app;
CREATE TABLE pre_home_feed_app (
feedid int(10) unsigned NOT NULL auto_increment COMMENT '应用feed id',
appid smallint(6) unsigned NOT NULL default '0' COMMENT '应用程序ID',
icon varchar(30) NOT NULL default COMMENT 'feed图标 ',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '产生feed的用户ID ',
username varchar(15) NOT NULL default COMMENT '产生feed的用户名 ',
dateline int(10) unsigned NOT NULL default '0' COMMENT 'feed产生时间戳 ',
friend tinyint(1) NOT NULL default '0' COMMENT '产生feed信息的隐私设置 ',
hash_template varchar(32) NOT NULL default COMMENT '模板hash:md5(title_template"\t"body_template) ',
hash_data varchar(32) NOT NULL default COMMENT '数据内容hash:md5(title_templat"\t"title_data"\t"body_template"\t"body_data) ',
title_template text NOT NULL COMMENT 'feed标题模板 ',
title_data text NOT NULL COMMENT 'feed标题 ',
body_template text NOT NULL COMMENT 'feed内容模板 ',
body_data text NOT NULL COMMENT 'feed内容 ',
body_general text NOT NULL COMMENT '用户填写的信息 ',
image_1 varchar(255) NOT NULL default COMMENT 'feed图1',
image_1_link varchar(255) NOT NULL default COMMENT 'feed图片链接1',
image_2 varchar(255) NOT NULL default COMMENT 'feed图片2',
image_2_link varchar(255) NOT NULL default COMMENT 'feed图片链接2',
image_3 varchar(255) NOT NULL default COMMENT 'feed图片3',
image_3_link varchar(255) NOT NULL default COMMENT 'feed图片链接3',
image_4 varchar(255) NOT NULL default COMMENT 'feed图片4',
image_4_link varchar(255) NOT NULL default COMMENT 'feed图片链接4',
target_ids text NOT NULL COMMENT '产生feed信息允许查看的好友ID ',
PRIMARY KEY (feedid),
KEY uid (uid,dateline),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='应该feed表';


DROP TABLE IF EXISTS pre_home_friend;
CREATE TABLE pre_home_friend (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',
fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户好友ID ',
fusername varchar(15) NOT NULL default COMMENT '用户好友名',
gid smallint(6) unsigned NOT NULL default '0' COMMENT '好友所在的好友组ID ',
num mediumint(8) unsigned NOT NULL default '0' COMMENT '好友之间的任务关系数',
dateline int(10) unsigned NOT NULL default '0' COMMENT '加好友的时间戳',
note varchar(255) NOT NULL default COMMENT '好友备注',
PRIMARY KEY (uid,fuid),
KEY fuid (fuid),
KEY `uid` (uid,num,dateline)
) ENGINE=MyISAM COMMENT='用户好友表';


DROP TABLE IF EXISTS pre_home_friend_request;
CREATE TABLE pre_home_friend_request (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',
fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '被请求用户ID ',
fusername char(15) NOT NULL default COMMENT '被请求用户名称',
gid smallint(6) unsigned NOT NULL default '0' COMMENT '好友所在的好友组ID ',
note char(60) NOT NULL default COMMENT '申请附言',
dateline int(10) unsigned NOT NULL default '0' COMMENT '请求好友时间戳',
PRIMARY KEY (uid,fuid),
KEY fuid (fuid),
KEY `dateline` (uid, dateline)
) ENGINE=MyISAM COMMENT='申请好友表';


DROP TABLE IF EXISTS pre_home_friendlog;
CREATE TABLE pre_home_friendlog (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID ',
fuid mediumint(8) unsigned NOT NULL default '0' COMMENT '好友用户ID ',
`action` varchar(10) NOT NULL default COMMENT '好友动作:"add"添加,"update"更新 ',
dateline int(10) unsigned NOT NULL default '0' COMMENT '好友动作时间',
PRIMARY KEY (uid,fuid)
) ENGINE=MyISAM COMMENT='用户好友动作日志表';


DROP TABLE IF EXISTS pre_common_magiclog;
CREATE TABLE pre_common_magiclog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
magicid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '道具id',
action tinyint(1) NOT NULL DEFAULT '0' COMMENT '操作动作 1 购买 2 使用 3 赠送',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
amount smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '操作数量',
credit tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作积分',
price mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '操作价格',
`targetid` int(10) unsigned NOT NULL DEFAULT '0',
`idtype` char(6) DEFAULT NULL,
targetuid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '道具目标uid',
KEY uid (uid,dateline),
KEY `action` (`action`),
KEY targetuid (targetuid,dateline),
KEY magicid (magicid,dateline)
) ENGINE=MyISAM COMMENT='道具日志表';


DROP TABLE IF EXISTS pre_common_magic;
CREATE TABLE pre_common_magic (
magicid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '道具id',
available tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可用',
name varchar(50) NOT NULL COMMENT '名称',
identifier varchar(40) NOT NULL COMMENT '唯一标识',
description varchar(255) NOT NULL COMMENT '描述',
displayorder tinyint(3) NOT NULL DEFAULT '0' COMMENT '顺序',
credit tinyint(1) NOT NULL DEFAULT '0' COMMENT '使用的积分',
price mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '价格',
num smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '数量',
salevolume smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '销售量',
supplytype tinyint(1) NOT NULL DEFAULT '0' COMMENT '自动补货类型',
supplynum smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '自动补货数量',
useperoid tinyint(1) NOT NULL DEFAULT '0' COMMENT '使用周期',
usenum smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '周期使用数量',
weight tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '重量',
magicperm text NOT NULL COMMENT '权限',
useevent tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:只在特定环境使用 1:可以在道具中心使用',
PRIMARY KEY (magicid),
UNIQUE KEY identifier (identifier),
KEY displayorder (available,displayorder)
) ENGINE=MyISAM COMMENT='道具数据表';


DROP TABLE IF EXISTS pre_home_notification;
CREATE TABLE pre_home_notification (
id mediumint(8) unsigned NOT NULL auto_increment COMMENT '通知ID ',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '通知用户ID ',
`type` varchar(20) NOT NULL default COMMENT '通知类型:"doing"记录,"friend"好友请求,"sharenotice"好友分享,"post"话题回复, ',
`new` tinyint(1) NOT NULL default '0' COMMENT '通知是否为新:"1"为新通知,"0"为通知已读 ',
authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者用户ID ',
author varchar(15) NOT NULL default COMMENT '用户名',
note text NOT NULL COMMENT '通知内容',
dateline int(10) unsigned NOT NULL default '0' COMMENT '通知产生的时间戳',
from_id mediumint(8) unsigned NOT NULL default '0' COMMENT '来源对象id',
from_idtype varchar(20) NOT NULL default COMMENT '来源对象类型',
from_num mediumint(8) unsigned NOT NULL default '0' COMMENT '来源量',
PRIMARY KEY (id),
KEY uid (uid,new,dateline),
KEY from_id (from_id,from_idtype)
) ENGINE=MyISAM COMMENT='通知表';


DROP TABLE IF EXISTS pre_home_pic;
CREATE TABLE pre_home_pic (
picid mediumint(8) NOT NULL auto_increment COMMENT '图片ID ',
albumid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属相册ID ',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属用户ID ',
username varchar(15) NOT NULL default COMMENT '图片所属用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '图片上传时间戳',
postip varchar(255) NOT NULL default COMMENT '图片上传ip',
filename varchar(255) NOT NULL default COMMENT '图片文件名',
title varchar(255) NOT NULL default COMMENT '图片标题',
`type` varchar(255) NOT NULL default COMMENT '图片类型',
size int(10) unsigned NOT NULL default '0' COMMENT '图片大小',
filepath varchar(255) NOT NULL default COMMENT '图片路径',
thumb tinyint(1) NOT NULL default '0' COMMENT '是否有缩略图',
remote tinyint(1) NOT NULL default '0' COMMENT '是否有远程图片0:home本地图片,1:home远程图片,2:论坛本地图片,3论坛远程图片',
hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',
sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '图片分享次数',
click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',
click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',
click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',
click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',
click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',
click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',
click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',
click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',
magicframe tinyint(6) NOT NULL default '0' COMMENT '道具使用相框id',
status tinyint(1) unsigned NOT NULL default '0' COMMENT '图片状态 1-审核',
PRIMARY KEY (picid),
KEY uid (uid),
KEY albumid (albumid,dateline)
) ENGINE=MyISAM COMMENT='家园图片表';


DROP TABLE IF EXISTS pre_home_picfield;
CREATE TABLE pre_home_picfield (
picid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片id',
hotuser text NOT NULL COMMENT '图片对应热点用户',
PRIMARY KEY (picid)
) ENGINE=MyISAM COMMENT='家园图片拓展表';


DROP TABLE IF EXISTS pre_home_poke;
CREATE TABLE pre_home_poke (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '接招呼的用户ID ',
fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '打招呼的用户ID ',
fromusername varchar(15) NOT NULL default COMMENT '打招呼的用户名 ',
note varchar(255) NOT NULL default COMMENT '招呼内容',
dateline int(10) unsigned NOT NULL default '0' COMMENT '打招呼时间戳',
iconid smallint(6) unsigned NOT NULL default '0' COMMENT '招呼图标',
PRIMARY KEY (uid,fromuid),
KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT='用户招呼表';


DROP TABLE IF EXISTS pre_home_pokearchive;
CREATE TABLE pre_home_pokearchive (
pid mediumint(8) NOT NULL auto_increment COMMENT '招呼历史id',
pokeuid int(10) unsigned NOT NULL default '0' COMMENT 'uid + fromuid',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '目标用户ID',
fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起用户ID',
note varchar(255) NOT NULL default COMMENT '招呼内容',
dateline int(10) unsigned NOT NULL default '0' COMMENT '招呼时间戳',
iconid smallint(6) unsigned NOT NULL default '0' COMMENT '招呼图标',
PRIMARY KEY (pid),
KEY pokeuid (pokeuid)
) ENGINE=MyISAM COMMENT='用户招呼存档表';


DROP TABLE IF EXISTS pre_home_share;
CREATE TABLE pre_home_share (
sid mediumint(8) unsigned NOT NULL auto_increment COMMENT '分享id',
itemid mediumint(8) unsigned NOT NULL COMMENT '相关条目的ID',
`type` varchar(30) NOT NULL default COMMENT '分享类型',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '分享者用户id',
username varchar(15) NOT NULL default COMMENT '分享者用户名',
fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '被分享者用户ID',
dateline int(10) unsigned NOT NULL default '0' COMMENT '分享时间戳',
title_template text NOT NULL COMMENT '分享标题模板',
body_template text NOT NULL COMMENT '分享内容模板',
body_data text NOT NULL COMMENT '分享内容数据',
body_general text NOT NULL COMMENT '分享说明',
image varchar(255) NOT NULL default COMMENT '分享的图片',
image_link varchar(255) NOT NULL default COMMENT '分享的图片链接',
hot mediumint(8) unsigned NOT NULL default '0' COMMENT '热度',
hotuser text NOT NULL COMMENT '相关热点用户',
status tinyint(1) NOT NULL COMMENT '分享条目状态 1-审核',
PRIMARY KEY (sid),
KEY uid (uid,dateline),
KEY hot (hot),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='用户分享表';


DROP TABLE IF EXISTS pre_home_show;
CREATE TABLE pre_home_show (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '我要上榜用户id',
username varchar(15) NOT NULL default COMMENT '我要上榜用户名',
unitprice int(10) unsigned NOT NULL default '1' COMMENT '单次访问单价',
credit int(10) unsigned NOT NULL default '0' COMMENT '上榜总积分',
note varchar(100) NOT NULL default COMMENT '上榜宣言',
PRIMARY KEY (uid),
KEY unitprice (unitprice),
KEY credit (credit)
) ENGINE=MyISAM COMMENT='用户上榜表';


DROP TABLE IF EXISTS pre_home_userapp;
CREATE TABLE pre_home_userapp (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '使用应用的用户ID ',
appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用ID ',
appname varchar(60) NOT NULL default COMMENT '应用名',
privacy tinyint(1) NOT NULL default '0' COMMENT '应用是否公开',
allowsidenav tinyint(1) NOT NULL default '0' COMMENT '是否在开始菜单中显示',
allowfeed tinyint(1) NOT NULL default '0' COMMENT '是否允许应用产生feed ',
allowprofilelink tinyint(1) NOT NULL default '0' COMMENT '时都允许在首页显示连接',
narrow tinyint(1) NOT NULL default '0' COMMENT '是否在个人空间左边显示',
menuorder smallint(6) NOT NULL default '0' COMMENT '菜单顺序',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
KEY uid (uid,appid),
KEY menuorder (uid,menuorder),
KEY displayorder (uid,displayorder)
) ENGINE=MyISAM COMMENT='用户使用应用表';


DROP TABLE IF EXISTS pre_home_userappfield;
CREATE TABLE pre_home_userappfield (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '使用应用的用户id',
appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用id',
profilelink text NOT NULL COMMENT '应用链接',
myml text NOT NULL COMMENT 'myml格式的首页显示信息',
KEY uid (uid,appid)
) ENGINE=MyISAM COMMENT='用户使用应用扩展表';


DROP TABLE IF EXISTS pre_home_visitor;
CREATE TABLE pre_home_visitor (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '受访者用户id',
vuid mediumint(8) unsigned NOT NULL default '0' COMMENT '访问者用户id',
vusername char(15) NOT NULL default COMMENT '访问者用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '访问时间戳',
PRIMARY KEY (uid,vuid),
KEY vuid (vuid),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='空间访问日志表';


DROP TABLE IF EXISTS pre_portal_article_title;
CREATE TABLE pre_portal_article_title (
aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '文章ID',
catid mediumint(8) unsigned NOT NULL default '0' COMMENT '栏目id',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户id',
username varchar(255) NOT NULL default COMMENT '用户名',
title varchar(255) NOT NULL default COMMENT '标题',
highlight varchar(255) NOT NULL default COMMENT '标题样式',
author varchar(255) NOT NULL default COMMENT '原作者',
`from` varchar(255) NOT NULL default COMMENT '来源',
fromurl varchar(255) NOT NULL default COMMENT '来源URL',
url varchar(255) NOT NULL default COMMENT '访问URL',
summary varchar(255) NOT NULL default COMMENT '摘要',
pic varchar(255) NOT NULL default COMMENT '封面图片',
thumb tinyint(1) NOT NULL default '0' COMMENT '封面图片是否缩略',
remote tinyint(1) NOT NULL default '0' COMMENT '封面图片是否远程',
id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',
idtype varchar(255) NOT NULL default COMMENT '来源ID类型',
contents smallint(6) NOT NULL default '0' COMMENT '内容分页数',
allowcomment tinyint(1) NOT NULL default '0' COMMENT '是否允许评论',
owncomment tinyint(1) NOT NULL default '0' COMMENT '对于推送过来的文章：1，使用文章评论；0，同步原主题/日志的帖子/评论',
click1 smallint(6) unsigned NOT NULL default '0' COMMENT '表态1 id',
click2 smallint(6) unsigned NOT NULL default '0' COMMENT '表态2 id',
click3 smallint(6) unsigned NOT NULL default '0' COMMENT '表态3 id',
click4 smallint(6) unsigned NOT NULL default '0' COMMENT '表态4 id',
click5 smallint(6) unsigned NOT NULL default '0' COMMENT '表态5 id',
click6 smallint(6) unsigned NOT NULL default '0' COMMENT '表态6 id',
click7 smallint(6) unsigned NOT NULL default '0' COMMENT '表态7 id',
click8 smallint(6) unsigned NOT NULL default '0' COMMENT '表态8 id',
tag tinyint(8) unsigned NOT NULL DEFAULT '0' COMMENT '文章属性，共八位',
dateline int(10) unsigned NOT NULL default '0' COMMENT '添加时间',
status tinyint(1) unsigned NOT NULL default '0' COMMENT '文章状态 0-已审核 1-需要审核 2-已忽略',
showinnernav tinyint(1) unsigned NOT NULL default '0' COMMENT '是否显示分页导航',
PRIMARY KEY (aid),
KEY catid (catid,dateline)
) ENGINE=MyISAM COMMENT='门户文章标题表';


DROP TABLE IF EXISTS pre_portal_article_content;
CREATE TABLE pre_portal_article_content (
cid int(10) unsigned NOT NULL auto_increment COMMENT '内容ID',
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章ID',
id int(10) unsigned NOT NULL default '0' COMMENT '来源ID',
idtype varchar(255) NOT NULL default COMMENT '来源ID类型',
title varchar(255) NOT NULL default COMMENT '标题',
content text NOT NULL COMMENT '文章内容',
pageorder smallint(6) unsigned NOT NULL default '0' COMMENT '分页排序',
dateline int(10) unsigned NOT NULL default '0' COMMENT '添加时间',
PRIMARY KEY (cid),
KEY aid (aid,pageorder),
KEY pageorder (pageorder)
) ENGINE=MyISAM COMMENT='门户文章内容表';


DROP TABLE IF EXISTS pre_portal_article_count;
CREATE TABLE pre_portal_article_count (
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章ID',
catid mediumint(8) unsigned NOT NULL default '0' COMMENT '栏目id',
viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '查看数',
commentnum mediumint(8) unsigned NOT NULL default '0' COMMENT '评论数',
favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '文章收藏次数',
sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '文章分享次数',
PRIMARY KEY (aid)
) ENGINE=MyISAM COMMENT='门户文章统计数据表';


DROP TABLE IF EXISTS pre_portal_article_trash;
CREATE TABLE pre_portal_article_trash (
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '垃圾文章ID',
content text NOT NULL COMMENT '文章数据的seriallize存储',
PRIMARY KEY (aid)
) ENGINE=MyISAM COMMENT='门户文章回收站表';


DROP TABLE IF EXISTS pre_portal_comment;
CREATE TABLE pre_portal_comment (
cid 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 '发表评论的用户名',
id mediumint(8) unsigned NOT NULL default '0' COMMENT '评论对象id',
idtype varchar(20) NOT NULL default COMMENT '评论对象的id类型：aid，topicid',
postip varchar(255) NOT NULL default COMMENT '评论IP ',
dateline int(10) unsigned NOT NULL default '0' COMMENT '评论时间戳',
status tinyint(1) unsigned NOT NULL default '0' COMMENT '评论状态 1-审核',
message text NOT NULL COMMENT '评论内容',
PRIMARY KEY (cid),
KEY idtype (id,idtype,dateline)
) ENGINE=MyISAM COMMENT='门户评论表';


DROP TABLE IF EXISTS pre_portal_rsscache;
CREATE TABLE pre_portal_rsscache (
lastupdate int(10) unsigned NOT NULL default '0' COMMENT '最后更新时间',
catid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章分类id',
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间',
catname char(50) NOT NULL default COMMENT '分类名称',
author char(15) NOT NULL default COMMENT '作者',
subject char(80) NOT NULL default COMMENT '标题',
description char(255) NOT NULL default COMMENT '解释说明',
UNIQUE KEY aid (aid),
KEY catid (catid,dateline)
) ENGINE=MyISAM COMMENT='文章rss缓存表';


DROP TABLE IF EXISTS pre_portal_topic;
CREATE TABLE pre_portal_topic (
topicid mediumint(8) unsigned NOT NULL auto_increment COMMENT '专题ID',
title varchar(255) NOT NULL default COMMENT '专题标题',
name varchar(255) NOT NULL default COMMENT '静态化名称',
`domain` varchar(255) NOT NULL DEFAULT COMMENT '二级域名',
summary text NOT NULL COMMENT '专题介绍',
keyword text NOT NULL COMMENT 'SEO 关键字',
cover varchar(255) NOT NULL default COMMENT '专题封面',
picflag tinyint(1) NOT NULL default '0' COMMENT '图片类型 0为url 1为本地 2 为ftp远程',
primaltplname varchar(255) NOT NULL default COMMENT '原模板地址',
useheader tinyint(1) NOT NULL default '0' COMMENT '是否使用网站导航内容',
usefooter tinyint(1) NOT NULL default '0' COMMENT '是否使用网站尾部信息',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '创建者UID',
username varchar(255) NOT NULL default COMMENT '创建者用户名',
viewnum mediumint(8) unsigned NOT NULL default '0' COMMENT '查看数',
dateline int(10) unsigned NOT NULL default '0' COMMENT '创建时间',
closed tinyint(1) NOT NULL default '0' COMMENT '是否关闭状态',
allowcomment tinyint(1) NOT NULL default '0' COMMENT '是否允许评论',
commentnum mediumint(8) unsigned NOT NULL default '0' COMMENT '评论数',
PRIMARY KEY (topicid),
KEY name (name)
) ENGINE=MyISAM COMMENT='门户专题表';


DROP TABLE IF EXISTS pre_portal_topic_pic;
CREATE TABLE pre_portal_topic_pic (
picid mediumint(8) NOT NULL auto_increment COMMENT '图片ID ',
topicid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属专题ID ',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '图片所属用户ID ',
username varchar(15) NOT NULL default COMMENT '图片所属用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '图片上传时间戳',
filename varchar(255) NOT NULL default COMMENT '图片文件名',
title varchar(255) NOT NULL default COMMENT '图片标题',
size int(10) unsigned NOT NULL default '0' COMMENT '图片大小',
filepath varchar(255) NOT NULL default COMMENT '图片路径',
thumb tinyint(1) NOT NULL default '0' COMMENT '是否有缩略图',
remote tinyint(1) NOT NULL default '0' COMMENT '是否有远程图片',
PRIMARY KEY (picid),
KEY topicid (topicid)
) ENGINE=MyISAM COMMENT='门户专题图片表';


DROP TABLE IF EXISTS pre_common_diy_data;
CREATE TABLE pre_common_diy_data (
targettplname varchar(100) NOT NULL default COMMENT '目标模板文件名',
tpldirectory varchar(80) NOT NULL default COMMENT '原模板所在目录',
primaltplname varchar(255) NOT NULL default COMMENT '原模板文件名',
diycontent mediumtext NOT NULL COMMENT 'DIY的内容',
`name` varchar(255) NOT NULL default COMMENT '目标模板页面名称',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username varchar(15) NOT NULL default COMMENT '用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '更新时间',
PRIMARY KEY (targettplname, tpldirectory)
) ENGINE=MyISAM COMMENT='DIY模板页面数据的存档表';


DROP TABLE IF EXISTS pre_common_template_block;
CREATE TABLE pre_common_template_block (
targettplname varchar(100) NOT NULL default COMMENT '目标模板文件名',
tpldirectory varchar(80) NOT NULL default COMMENT '原模板所在目录',
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',
PRIMARY KEY (targettplname, tpldirectory, bid),
KEY bid (bid)
) ENGINE=MyISAM COMMENT='模板页面和模块的关联表';

DROP TABLE IF EXISTS pre_common_template_permission;
CREATE TABLE pre_common_template_permission (
targettplname varchar(100) NOT NULL DEFAULT COMMENT '目标模板',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
allowmanage tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许管理',
allowrecommend tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许推荐',
needverify tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐需要审核',
inheritedtplname varchar(255) NOT NULL DEFAULT COMMENT '继承自的模板名称',
PRIMARY KEY (targettplname,uid),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='DIY模板页面权限表';


DROP TABLE IF EXISTS pre_common_block_permission;
CREATE TABLE pre_common_block_permission (
bid mediumint(8) unsigned NOT NULL default '0' COMMENT '模块ID',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
allowmanage tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许管理',
allowrecommend tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许推荐',
needverify tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐需要审核',
inheritedtplname varchar(255) NOT NULL DEFAULT COMMENT '继承自的模板名称',
PRIMARY KEY (bid, uid),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='模块权限表';


DROP TABLE IF EXISTS pre_portal_category_permission;
CREATE TABLE pre_portal_category_permission (
catid mediumint(8) unsigned NOT NULL default '0' COMMENT '分类ID',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
allowpublish tinyint(1) NOT NULL default '0' COMMENT '允许发布文章',
allowmanage tinyint(1) NOT NULL default '0' COMMENT '允许管理文章',
inheritedcatid mediumint(8) NOT NULL DEFAULT '0' COMMENT '继承自的频道ID',
PRIMARY KEY (catid, uid),
KEY uid (uid)
) ENGINE=MyISAM COMMENT='文章分类权限表';


DROP TABLE IF EXISTS pre_portal_category;
CREATE TABLE pre_portal_category (
catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',
upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',
catname varchar(255) NOT NULL default COMMENT '标题',
articles mediumint(8) unsigned NOT NULL default '0' COMMENT '文章数',
allowcomment tinyint(1) NOT NULL default '1' COMMENT '是否允许评论',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
notinheritedarticle tinyint(1) NOT NULL default '0' COMMENT '是否不继承上级文章管理权限',
notinheritedblock tinyint(1) NOT NULL default '0' COMMENT '是否不继承上级DIY页面和模块权限',
`domain` varchar(255) NOT NULL DEFAULT COMMENT '二级域名',
url varchar(255) NOT NULL DEFAULT COMMENT '自定义链接',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '创建者ID',
username varchar(255) NOT NULL DEFAULT COMMENT '创建者用户名',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
closed tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否关闭',
shownav tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在导航显示',
description text NOT NULL COMMENT '分类介绍 SEO描述',
seotitle text NOT NULL COMMENT 'SEO 标题',
keyword text NOT NULL COMMENT 'SEO 关键字',
primaltplname varchar(255) NOT NULL default COMMENT '列表页原模板地址',
articleprimaltplname varchar(255) NOT NULL default COMMENT '文章页原模板地址',
disallowpublish tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁止发布文章',
foldername varchar(255) NOT NULL DEFAULT COMMENT '文件夹名称',
notshowarticlesummay varchar(255) NOT NULL DEFAULT COMMENT '文章内容页是否不显示摘要',
perpage smallint(6) NOT NULL default '0' COMMENT '列表每页显示文章数',
maxpages smallint(6) NOT NULL default '0' COMMENT '列表最大分页数',
PRIMARY KEY (catid)
) ENGINE=MyISAM COMMENT='门户 文章栏目表';

DROP TABLE IF EXISTS pre_common_process;
CREATE TABLE pre_common_process (
processid char(32) NOT NULL COMMENT '锁名称的md5',
expiry int(10) DEFAULT NULL COMMENT '锁的过期时间',
extra int(10) DEFAULT NULL COMMENT '锁的附属信息',
PRIMARY KEY (processid),
KEY expiry (expiry)
) ENGINE=MEMORY COMMENT='进程锁管理';

DROP TABLE IF EXISTS pre_common_admincp_group;
CREATE TABLE pre_common_admincp_group (
cpgroupid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台组id',
cpgroupname varchar(255) NOT NULL COMMENT '后台组名称',
PRIMARY KEY (cpgroupid)
) ENGINE=MyISAM COMMENT='后台管理组';

DROP TABLE IF EXISTS pre_common_admincp_member;
CREATE TABLE pre_common_admincp_member (
uid int(10) unsigned NOT NULL COMMENT '成员uid',
cpgroupid int(10) unsigned NOT NULL COMMENT '成员组id',
customperm text NOT NULL COMMENT '自定义管理权限',
PRIMARY KEY (uid)
) ENGINE=MyISAM COMMENT='后台管理成员';

DROP TABLE IF EXISTS pre_common_admincp_perm;
CREATE TABLE pre_common_admincp_perm (
cpgroupid smallint(6) unsigned NOT NULL COMMENT '后台组id',
perm varchar(255) NOT NULL COMMENT '后台组权限',
UNIQUE KEY cpgroupperm (cpgroupid,perm)
) ENGINE=MyISAM COMMENT='后台权限表';

DROP TABLE IF EXISTS pre_common_admincp_session;
CREATE TABLE pre_common_admincp_session (
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
adminid smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '管理组id',
panel tinyint(1) NOT NULL DEFAULT '0' COMMENT '面板位置',
ip varchar(15) NOT NULL DEFAULT COMMENT 'IP',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后动作时间',
errorcount tinyint(1) NOT NULL DEFAULT '0' COMMENT '登录错误次数',
storage mediumtext NOT NULL COMMENT '临时内容存储',
PRIMARY KEY (uid,panel)
) ENGINE=MyISAM COMMENT='后台session表';


DROP TABLE IF EXISTS pre_portal_attachment;
CREATE TABLE pre_portal_attachment (
attachid mediumint(8) unsigned NOT NULL auto_increment 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 '原文件名',
filetype varchar(255) NOT NULL default COMMENT '文件类型',
filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小',
attachment varchar(255) NOT NULL default COMMENT '服务器路径',
isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',
thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',
remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件',
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '文章id',
PRIMARY KEY (attachid),
KEY aid (aid,attachid)
) ENGINE=MyISAM COMMENT='门户文章附件表';


DROP TABLE IF EXISTS pre_portal_article_related;
CREATE TABLE pre_portal_article_related (
aid mediumint(8) unsigned NOT NULL auto_increment COMMENT '文章ID',
raid mediumint(8) unsigned NOT NULL default '0' COMMENT '相关文章ID',
displayorder mediumint(8) unsigned NOT NULL default '0' COMMENT '显示顺序',
PRIMARY KEY (aid,raid),
KEY aid (aid,displayorder)
) ENGINE=MyISAM COMMENT='门户相关文章';


DROP TABLE IF EXISTS pre_home_specialuser;
CREATE TABLE pre_home_specialuser (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',
username varchar(15) NOT NULL default COMMENT '用户名',
status tinyint(1) unsigned NOT NULL default '0' COMMENT '用户类型0为推荐用户1为默认好友',
dateline int(10) NOT NULL default '0' COMMENT '设置时间',
reason text NOT NULL COMMENT '操作原因',
opuid mediumint(8) unsigned NOT NULL default '0' COMMENT '操作者用户ID',
opusername varchar(15) NOT NULL default COMMENT '操作者用户名',
displayorder mediumint(8) unsigned NOT NULL default '0' COMMENT '显示顺序',
KEY uid (uid,status),
KEY displayorder (status,displayorder)
) ENGINE=MyISAM COMMENT='特殊用户表';


DROP TABLE IF EXISTS pre_common_district;
CREATE TABLE pre_common_district (
id mediumint(8) unsigned NOT NULL auto_increment COMMENT '地区ID',
`name` varchar(255) NOT NULL default COMMENT '地区名称',
`level` tinyint(4) unsigned NOT NULL default '0' COMMENT '地区等级：1，省级；2，市级；3，县级；4，乡镇',
usetype tinyint(1) unsigned NOT NULL default '0' COMMENT '使用对象：0:都不启用; 1:出生地; 2:居住地; 3:都启用',
upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级地区ID',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
PRIMARY KEY (id),
KEY upid (upid,displayorder)
) ENGINE=MyISAM COMMENT='地区表';


DROP TABLE IF EXISTS pre_forum_grouplevel;
CREATE TABLE pre_forum_grouplevel (
levelid smallint(6) unsigned NOT NULL auto_increment COMMENT '等级ID',
`type` enum('special','default') NOT NULL default 'default' COMMENT '类型',
leveltitle varchar(255) NOT NULL default COMMENT '群组等级名称',
creditshigher int(10) NOT NULL default '0' COMMENT '该等级的积分上限',
creditslower int(10) NOT NULL default '0' COMMENT '该等级的积分下限',
icon varchar(255) NOT NULL default COMMENT '等级图标',
creditspolicy text NOT NULL COMMENT '积分策略',
postpolicy text NOT NULL COMMENT '帖子策略',
specialswitch text NOT NULL COMMENT '特殊开能开关',
PRIMARY KEY (levelid),
KEY creditsrange (creditshigher,creditslower)
) ENGINE=MyISAM COMMENT='群组等级表';

DROP TABLE IF EXISTS pre_forum_groupcreditslog;
CREATE TABLE pre_forum_groupcreditslog (
fid mediumint(8) unsigned NOT NULL COMMENT '群组ID',
uid mediumint(8) unsigned NOT NULL COMMENT '成员UID',
logdate int(8) NOT NULL default '0' COMMENT '日期/20100308',
PRIMARY KEY (fid,uid,logdate)
) ENGINE=MyISAM COMMENT='群组积分日志表';


DROP TABLE IF EXISTS pre_home_blog_category;
CREATE TABLE pre_home_blog_category (
catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',
upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',
catname varchar(255) NOT NULL default COMMENT '标题',
num mediumint(8) unsigned NOT NULL default '0' COMMENT '日志数',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
PRIMARY KEY (catid)
) ENGINE=MyISAM COMMENT='日志系统栏目';


DROP TABLE IF EXISTS pre_home_album_category;
CREATE TABLE pre_home_album_category (
catid mediumint(8) unsigned NOT NULL auto_increment COMMENT '栏目id',
upid mediumint(8) unsigned NOT NULL default '0' COMMENT '上级栏目id',
catname varchar(255) NOT NULL default COMMENT '标题',
num mediumint(8) unsigned NOT NULL default '0' COMMENT '相册数',
displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序',
PRIMARY KEY (catid)
) ENGINE=MyISAM COMMENT='相册系统栏目';


DROP TABLE IF EXISTS pre_common_report;
CREATE TABLE pre_common_report (
id mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',
urlkey char(32) NOT NULL default COMMENT '地址md5',
url varchar(255) NOT NULL default COMMENT '地址',
message text NOT NULL COMMENT '举报理由',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
username varchar(15) NOT NULL default COMMENT '用户名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '举报时间',
num smallint(6) unsigned NOT NULL default '1' COMMENT '举报次数',
opuid mediumint(8) unsigned NOT NULL default '0' COMMENT '管理员id',
opname varchar(15) NOT NULL default COMMENT '管理员姓名',
optime int(10) unsigned NOT NULL default '0' COMMENT '处理时间',
opresult varchar(255) NOT NULL default COMMENT '对举报人的奖惩',
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id',
PRIMARY KEY (id),
KEY urlkey (urlkey),
KEY fid (fid)
) ENGINE=MyISAM COMMENT='用户举报表';


DROP TABLE IF EXISTS pre_common_patch;
CREATE TABLE pre_common_patch (
serial varchar(10) NOT NULL default COMMENT '漏洞编号',
rule text NOT NULL COMMENT '修补规则',
note text NOT NULL COMMENT '漏洞说明',
`status` tinyint(1) NOT NULL default '0' COMMENT '修补状态',
dateline int(10) unsigned NOT NULL default '0' COMMENT '漏洞发布时间',
PRIMARY KEY (serial)
) ENGINE=MyISAM COMMENT='漏洞补丁表';


DROP TABLE IF EXISTS pre_forum_collection;
CREATE TABLE pre_forum_collection (
ctid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '专辑ID',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
username varchar(15) NOT NULL DEFAULT COMMENT '用户名',
`name` varchar(50) NOT NULL DEFAULT COMMENT '专辑名',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
follownum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订阅数',
threadnum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题数',
commentnum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
`desc` varchar(255) NOT NULL DEFAULT COMMENT '简介',
lastupdate int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后变动时间',
rate float NOT NULL DEFAULT '0' COMMENT '评分',
ratenum mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '评分次数',
lastpost mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '最后主题ID',
lastsubject varchar(80) NOT NULL DEFAULT COMMENT '最后主题标题',
lastposttime int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后主题时间',
lastposter varchar(15) NOT NULL DEFAULT COMMENT '最后主题发帖者',
lastvisit int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者最后访问',
`keyword` varchar(255) NOT NULL DEFAULT COMMENT '专辑关键词',
PRIMARY KEY (ctid),
KEY dateline (dateline),
KEY hotcollection (threadnum,lastupdate),
KEY follownum (follownum)
) ENGINE=MyISAM COMMENT='淘帖专辑表';


DROP TABLE IF EXISTS pre_forum_collectioncomment;
CREATE TABLE pre_forum_collectioncomment (
cid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID',
ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
username varchar(15) NOT NULL DEFAULT COMMENT '用户名',
message text NOT NULL COMMENT '评论内容',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间',
useip varchar(16) NOT NULL DEFAULT COMMENT 'IP地址',
rate float NOT NULL DEFAULT '0' COMMENT '评分',
PRIMARY KEY (cid),
KEY ctid (ctid,dateline),
KEY userrate (ctid,uid,rate)
) ENGINE=MyISAM COMMENT='淘帖评论表';


DROP TABLE IF EXISTS pre_forum_collectionfollow;
CREATE TABLE pre_forum_collectionfollow (
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
username char(15) NOT NULL DEFAULT COMMENT '用户名',
ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关注时间',
lastvisit int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问专辑时间',
PRIMARY KEY (uid,ctid),
KEY ctid (ctid,dateline)
) ENGINE=MyISAM COMMENT='淘帖关注表';


DROP TABLE IF EXISTS pre_forum_collectioninvite;
CREATE TABLE pre_forum_collectioninvite (
ctid 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 '邀请时间',
PRIMARY KEY (ctid,uid),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='邀请管理淘专辑';


DROP TABLE IF EXISTS pre_forum_collectionrelated;
CREATE TABLE pre_forum_collectionrelated (
tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题ID',
collection text NOT NULL COMMENT '专辑列表',
PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='淘帖主题被收入专辑表';


DROP TABLE IF EXISTS pre_forum_collectionteamworker;
CREATE TABLE pre_forum_collectionteamworker (
ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',
uid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '合作者ID',
`name` varchar(50) NOT NULL DEFAULT COMMENT '专辑名',
username varchar(15) NOT NULL DEFAULT COMMENT '用户名',
lastvisit int(8) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问专辑时间',
PRIMARY KEY (ctid,uid)
) ENGINE=MyISAM COMMENT='淘帖合作编辑表';


DROP TABLE IF EXISTS pre_forum_collectionthread;
CREATE TABLE pre_forum_collectionthread (
ctid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑ID',
tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专辑内主题ID',
dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '主题日期',
reason varchar(255) NOT NULL DEFAULT COMMENT '推荐理由',
PRIMARY KEY (ctid,tid),
KEY ctid (ctid,dateline)
) ENGINE=MyISAM COMMENT='淘帖包含主题表';