Modoer数据表字典
Modoer 2.5 SC 数据表字典
-- --------------------------------------------------------
-- -- 表的结构 `modoer_activity` --
CREATE TABLE `modoer_activity` (
`aid` mediumint(8) unsigned NOT NULL auto_increment COMMENT 'ID',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '活跃时间',
`uid` mediumint(8) NOT NULL default '0' COMMENT '用户uid',
`username` varchar(16) NOT NULL COMMENT '用户昵称',
`reviews` smallint(5) unsigned NOT NULL default '0' COMMENT '点评发布数量',
`subjects` smallint(5) unsigned NOT NULL default '0' COMMENT '主题添加数量',
PRIMARY KEY (`aid`),
KEY `reviews` (`reviews`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户活跃表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_admin` --
CREATE TABLE `modoer_admin` (
`id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '管理员ID',
`adminname` varchar(24) NOT NULL COMMENT '名称',
`password` varchar(32) NOT NULL COMMENT '密码',
`email` varchar(60) NOT NULL COMMENT 'email',
`admintype` tinyint(3) NOT NULL default '0' COMMENT '管理员类型',
`is_founder` char(1) NOT NULL default 'N' COMMENT '是否创始人',
`logintime` int(10) NOT NULL default '0' COMMENT '登录时间',
`loginip` varchar(20) NOT NULL COMMENT '登录ip',
`logincount` int(10) unsigned NOT NULL default '0' COMMENT '登录次数',
`mymodules` text NOT NULL COMMENT '管理模型',
`closed` tinyint(1) NOT NULL default '0' COMMENT '禁用',
`validtime` int(10) NOT NULL default '0' COMMENT '禁用时间',
PRIMARY KEY (`id`),
UNIQUE KEY `adminname` (`adminname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='后台用户表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_adminsessions` --
CREATE TABLE `modoer_adminsessions` (
`adminid` mediumint(8) unsigned NOT NULL default '0' COMMENT '管理员id',
`ip` char(16) NOT NULL COMMENT 'ip地址',
`dateline` int(10) NOT NULL default '0' COMMENT '最后操作时间',
`errorcount` tinyint(1) NOT NULL default '0' COMMENT '错误标记'
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='后台登录session';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_adv_list` --
CREATE TABLE `modoer_adv_list` (
`adid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '广告ID',
`apid` smallint(5) unsigned NOT NULL default '0' COMMENT '广告位ID',
`city_id` mediumint(8) unsigned NOT NULL default '0' COMMENT '城市ID',
`adname` varchar(60) NOT NULL COMMENT '广告名称',
`sort` enum('word', 'flash', 'code', 'img') NOT NULL COMMENT '广告类型',
`begintime` int(10) unsigned NOT NULL default '0' COMMENT '开始展示时间',
`endtime` int(10) unsigned NOT NULL default '0' COMMENT '结束时间',
`config` text NOT NULL COMMENT '广告配置信息',
`code` text NOT NULL COMMENT '前台显示的HTML代码',
`attr` char(10) NOT NULL COMMENT '自定义属性',
`ader` varchar(255) NOT NULL COMMENT '广告主名称',
`adtel` varchar(255) NOT NULL COMMENT '广告主电话',
`ademail` varchar(255) NOT NULL COMMENT '广告主email',
`enabled` char(1) NOT NULL default 'Y' COMMENT '是否显示',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`adid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='广告数据表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_adv_place` --
CREATE TABLE `modoer_adv_place` (
`apid` smallint(5) unsigned NOT NULL auto_increment COMMENT '广告位ID',
`templateid` smallint(5) unsigned NOT NULL default '0' COMMENT '广告位模板id',
`name` varchar(60) NOT NULL COMMENT '广告位名称',
`des` varchar(255) NOT NULL COMMENT '广告位内部说明',
`template` text NOT NULL COMMENT '广告位显示模板',
`enabled` char(1) NOT NULL default 'Y' COMMENT '是否使用',
PRIMARY KEY (`apid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='广告位表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_announcements` --
CREATE TABLE `modoer_announcements` (
`id` mediumint(8) unsigned NOT NULL auto_increment COMMENT 'ID',
`title` varchar(200) NOT NULL COMMENT '名称',
`orders` smallint(5) NOT NULL default '0' COMMENT '排序',
`content` mediumtext NOT NULL COMMENT '内容',
`author` varchar(50) NOT NULL COMMENT '作者',
`pageview` int(10) NOT NULL default '0' COMMENT '浏览量',
`dateline` int(10) NOT NULL default '0' COMMENT '发布时间',
`available` tinyint(1) NOT NULL default '1' COMMENT '是否显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='公告表';
-- --------------------------------------------------------
-- --------------------------------------------------------
-- -- 表的结构 `modoer_area` --
CREATE TABLE `modoer_area` (
`aid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '地区ID',
`pid` mediumint(8) unsigned NOT NULL default '0' COMMENT '地区上级ID，0为一级地区（城市）',
`name` varchar(16) NOT NULL COMMENT '名称',
`mappoint` varchar(50) NOT NULL COMMENT '坐标点',
`level` tinyint(1) unsigned NOT NULL default '0' COMMENT '等级（1：城市，2：区县，3：街道',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`aid`),
KEY `pid` (`pid`),
KEY `level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='地区表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_articles` --
CREATE TABLE `modoer_articles` (
`articleid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '文章ID',
`catid` smallint(5) unsigned NOT NULL default '0' COMMENT '分类ID',
`sid` mediumint(8) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0' COMMENT '发布时间',
`att` tinyint(1) NOT NULL default '0' COMMENT '自定义属性值',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
`havepic` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有封面',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '作者ID',
`author` varchar(20) NOT NULL COMMENT '作者昵称',
`subject` varchar(60) NOT NULL COMMENT '标题',
`keywords` varchar(100) NOT NULL COMMENT '关键字（多个组成，逗号分隔）',
`pageview` mediumint(8) unsigned NOT NULL default '0' COMMENT '浏览量',
`grade` tinyint(1) unsigned NOT NULL default '0' COMMENT '评论打分',
`digg` mediumint(8) NOT NULL default '0' COMMENT 'digg次数',
`closed_comment` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否关闭评论',
`comments` mediumint(8) unsigned NOT NULL default '0' COMMENT '评论数量',
`copyfrom` varchar(200) NOT NULL COMMENT '来源',
`introduce` varchar(255) NOT NULL COMMENT '简介',
`thumb` varchar(255) NOT NULL COMMENT '封面',
`picture` varchar(255) NOT NULL COMMENT '大图',
`status` tinyint(1) NOT NULL default '1' COMMENT '状态（0：未审核，1：已审核）',
`checker` varchar(30) NOT NULL COMMENT '后台审核用户昵称',
PRIMARY KEY (`articleid`),
KEY `sid` (`sid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='文章表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_article_category` --
CREATE TABLE `modoer_article_category` (
`catid` smallint(5) unsigned NOT NULL auto_increment COMMENT '分类ID',
`pid` smallint(5) NOT NULL default '0' COMMENT '上级分类ID，主分类=0',
`name` varchar(20) NOT NULL COMMENT '名称',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
`total` mediumint(8) unsigned NOT NULL default '0' COMMENT '数量',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='文章分类表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_article_data` --
CREATE TABLE `modoer_article_data` (
`articleid` mediumint(8) unsigned NOT NULL default '0' COMMENT '文章ID',
`content` mediumtext NOT NULL COMMENT '文章详细内容',
PRIMARY KEY (`articleid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='文章内容表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_att_cat` --
CREATE TABLE `modoer_att_cat` (
`catid` mediumint(8) NOT NULL auto_increment COMMENT '属性组ID',
`name` varchar(60) NOT NULL COMMENT '名称',
`des` varchar(255) NOT NULL COMMENT '说明',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='属性组表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_att_list` --
CREATE TABLE `modoer_att_list` (
`attid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '属性值ID',
`catid` mediumint(8) unsigned NOT NULL default '0' COMMENT '所属属性组ID',
`name` varchar(20) NOT NULL COMMENT '名称',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`attid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='属性值表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_bcastr` --
CREATE TABLE `modoer_bcastr` (
`bcastr_id` smallint(3) unsigned NOT NULL auto_increment COMMENT 'ID',
`groupname` varchar(15) NOT NULL default 'index' COMMENT '组名',
`available` tinyint(1) NOT NULL default '1' COMMENT '是否显示',
`itemtitle` varchar(100) NOT NULL COMMENT '标题',
`link` varchar(255) NOT NULL COMMENT '图片地址',
`item_url` varchar(255) NOT NULL COMMENT '图片链接',
`orders` smallint(3) NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`bcastr_id`),
KEY `groupname` (`groupname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='图片轮换表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_card_apply` --
CREATE TABLE `modoer_card_apply` (
`applyid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '会员卡申请ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '申请用户uid',
`username` varchar(20) NOT NULL COMMENT '申请用户昵称',
`linkman` varchar(20) NOT NULL COMMENT '联系人',
`tel` varchar(20) NOT NULL COMMENT '电话',
`mobile` varchar(20) NOT NULL COMMENT '手机',
`address` varchar(255) NOT NULL COMMENT '地址',
`postcode` varchar(10) NOT NULL COMMENT '邮编',
`num` smallint(5) unsigned NOT NULL default '1' COMMENT '数量',
`coin` int(10) NOT NULL default '0' COMMENT '花费积分数量',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '申请时间',
`status` tinyint(1) unsigned NOT NULL default '1' COMMENT '申请状态',
`comment` text NOT NULL COMMENT '申请备注',
`checker` varchar(30) NOT NULL COMMENT '审核用户',
`checktime` int(10) NOT NULL default '0' COMMENT '审核时间',
`checkmsg` text NOT NULL COMMENT '审核备注',
PRIMARY KEY (`applyid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='会员卡申请表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_card_discounts` --
CREATE TABLE `modoer_card_discounts` (
`sid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题id',
`cardsort` enum('both', 'largess', 'discount') NOT NULL default 'discount' COMMENT '优惠类型',
`discount` decimal(4, 1) NOT NULL default '0.0' COMMENT '折扣度',
`largess` varchar(100) NOT NULL COMMENT '优惠信息',
`exception` varchar(255) NOT NULL COMMENT '例外说明',
`addtime` int(10) unsigned NOT NULL default '0' COMMENT '添加时间',
`available` tinyint(1) NOT NULL default '1' COMMENT '是否可用',
`finer` tinyint(1) NOT NULL default '0' COMMENT '是否推荐',
PRIMARY KEY (`sid`),
KEY `available` (`available`),
KEY `finer` (`finer`, `available`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='会员卡优惠信息表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_category` --
CREATE TABLE `modoer_category` (
`catid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题分类id',
`pid` mediumint(8) NOT NULL default '0' COMMENT '上级分类id',
`level` tinyint(1) unsigned NOT NULL default '0' COMMENT '等级（1-3）',
`modelid` smallint(5) NOT NULL default '0' COMMENT '关联主题模型ID',
`review_opt_gid` smallint(5) unsigned NOT NULL COMMENT '关联点评项组ID',
`name` varchar(20) NOT NULL COMMENT '名称',
`total` int(10) unsigned NOT NULL default '0' COMMENT '主题数量',
`config` text NOT NULL COMMENT '配置信息',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
`enabled` tinyint(1) unsigned NOT NULL default '1' COMMENT '是否可用',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题分类表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_comment` --
CREATE TABLE `modoer_comment` (
`cid` mediumint(8) unsigned NOT NULL auto_increment COMMENT 'ID',
`idtype` varchar(15) NOT NULL COMMENT '评论类型',
`id` mediumint(8) unsigned NOT NULL default '0' COMMENT '评论主体ID',
`grade` tinyint(2) NOT NULL default '0' COMMENT '打分',
`effect1` int(10) unsigned NOT NULL default '0' COMMENT '用户行为1',
`effect2` int(10) unsigned NOT NULL default '0' COMMENT '用户行为2',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '作者uid',
`username` varchar(20) NOT NULL COMMENT '作者昵称',
`status` tinyint(1) unsigned NOT NULL default '1' COMMENT '状态（0：未审核，1：已审核）',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '发布时间',
`title` varchar(255) NOT NULL COMMENT '标题',
`content` text NOT NULL COMMENT '内容',
`ip` varchar(15) NOT NULL COMMENT 'ip地址',
PRIMARY KEY (`cid`),
KEY `idtype` (`idtype`, `id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论内容表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_config` --
CREATE TABLE `modoer_config` (
`variable` varchar(32) NOT NULL COMMENT '配置名称标识',
`value` text NOT NULL COMMENT '配置值',
`module` varchar(20) NOT NULL COMMENT '所属模型标识',
PRIMARY KEY (`variable`, `module`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='配置信息表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_coupons` --
CREATE TABLE `modoer_coupons` (
`couponid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '优惠券ID',
`catid` smallint(5) unsigned NOT NULL default '0' COMMENT '分类ID',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID',
`uid` mediumint(8) NOT NULL default '0' COMMENT '上传用户UID',
`username` varchar(30) NOT NULL COMMENT '上传用户昵称',
`thumb` varchar(255) NOT NULL COMMENT '缩略图',
`picture` varchar(255) NOT NULL COMMENT '原图',
`starttime` int(10) NOT NULL default '0' COMMENT '优惠时间',
`endtime` int(10) NOT NULL default '0' COMMENT '结束',
`subject` varchar(100) NOT NULL COMMENT '名称',
`des` varchar(50) NOT NULL COMMENT '简介',
`content` text NOT NULL COMMENT '内容',
`effect1` mediumint(8) unsigned NOT NULL default '0' COMMENT '有用',
`prints` mediumint(8) unsigned NOT NULL default '0' COMMENT '打印次数',
`comments` mediumint(8) unsigned NOT NULL default '0' COMMENT '评论次数',
`grade` smallint(5) unsigned NOT NULL default '0' COMMENT '评分',
`flag` tinyint(1) unsigned NOT NULL default '1' COMMENT '我也忘了。。',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '发布时间',
`pageview` int(10) NOT NULL default '0' COMMENT '浏览量',
`status` tinyint(1) unsigned NOT NULL default '1' COMMENT '状态',
`closed_comment` tinyint(3) unsigned NOT NULL default '0' COMMENT '是否关闭评论',
PRIMARY KEY (`couponid`),
KEY `sid` (`sid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='优惠券表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_coupon_category` --
CREATE TABLE `modoer_coupon_category` (
`catid` smallint(8) unsigned NOT NULL auto_increment COMMENT '优惠券分类ID',
`name` varchar(40) NOT NULL COMMENT '分类名称',
`num` mediumint(9) NOT NULL default '0' COMMENT '数量',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='优惠券分类表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_coupon_print` --
CREATE TABLE `modoer_coupon_print` (
`id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '打印记录ID',
`couponid` mediumint(8) unsigned NOT NULL default '0' COMMENT '优惠券ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户UID',
`username` varchar(20) NOT NULL COMMENT '用户昵称',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '打印时间',
`point` mediumint(8) unsigned NOT NULL default '0' COMMENT '消费积分',
PRIMARY KEY (`id`),
KEY `couponid` (`couponid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='优惠券打印记录表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_datacall` --
CREATE TABLE `modoer_datacall` (
`callid` smallint(5) unsigned NOT NULL auto_increment COMMENT '调用id',
`module` varchar(60) NOT NULL COMMENT '所属模型',
`calltype` varchar(60) NOT NULL COMMENT '调用类型',
`name` varchar(50) NOT NULL COMMENT '名称',
`fun` varchar(60) NOT NULL COMMENT '调用函数',
`var` varchar(60) NOT NULL COMMENT '返回值变量名',
`cachetime` mediumint(8) unsigned NOT NULL default '0' COMMENT '缓存时间',
`expression` text NOT NULL COMMENT 'SQL等表达式',
`tplname` varchar(200) NOT NULL COMMENT '数据模板',
`empty_tplname` varchar(200) NOT NULL COMMENT '空数据模板',
`closed` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否关闭',
`hash` varchar(32) NOT NULL COMMENT '废弃...',
PRIMARY KEY (`callid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='数据调用表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_exchange_gifts` --
CREATE TABLE `modoer_exchange_gifts` (
`giftid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '礼品ID',
`name` varchar(200) NOT NULL COMMENT '名称',
`sort` tinyint(1) unsigned NOT NULL default '1' COMMENT '类型',
`available` tinyint(1) NOT NULL default '0' COMMENT '是否可用',
`displayorder` tinyint(3) NOT NULL default '0' COMMENT '排序时间',
`description` text NOT NULL COMMENT '详细说明',
`price` int(10) unsigned NOT NULL default '0' COMMENT '价格',
`num` int(10) unsigned NOT NULL default '0' COMMENT '数量',
`pageview` mediumint(8) unsigned NOT NULL default '0' COMMENT '浏览量',
`thumb` varchar(255) NOT NULL COMMENT '缩略图',
`picture` varchar(255) NOT NULL COMMENT '图片',
`salevolume` int(11) unsigned NOT NULL default '0' COMMENT '销售量',
PRIMARY KEY (`giftid`),
KEY `available` (`available`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='兑换礼品表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_exchange_log` --
CREATE TABLE `modoer_exchange_log` (
`exchangeid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '兑换记录ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '兑换用户UID',
`username` varchar(25) NOT NULL COMMENT '昵称',
`giftid` mediumint(8) unsigned NOT NULL default '0' COMMENT '礼品ID',
`giftname` varchar(200) NOT NULL COMMENT '礼品名称',
`price` int(10) unsigned NOT NULL default '0' COMMENT '价格',
`number` int(10) unsigned NOT NULL default '1' COMMENT '数量',
`status` tinyint(1) NOT NULL default '1' COMMENT '状态',
`status_extra` varchar(255) NOT NULL COMMENT '发送状态',
`exchangetime` int(10) NOT NULL default '0' COMMENT '兑换时间',
`contact` mediumtext NOT NULL COMMENT '联系方式',
`checker` varchar(20) NOT NULL COMMENT '审核人',
PRIMARY KEY (`exchangeid`),
KEY `uid` (`uid`),
KEY `giftid` (`giftid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='兑换记录表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_exchange_serial` --
CREATE TABLE `modoer_exchange_serial` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`giftid` mediumint(8) unsigned NOT NULL default '0',
`serial` varchar(255) NOT NULL default ,
`status` tinyint(1) unsigned NOT NULL default '1',
`dateline` int(10) unsigned NOT NULL default '0',
`sendtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `giftid` (`giftid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='兑换虚拟物品卡密表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_favorites` --
CREATE TABLE `modoer_favorites` (
`fid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '收藏夹自增ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户uid',
`username` varchar(20) NOT NULL COMMENT '用户名',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
`addtime` int(10) NOT NULL default '0' COMMENT '收藏时间',
PRIMARY KEY (`fid`),
KEY `shopid` (`sid`),
KEY `addtime` (`addtime`),
KEY `uid` (`uid`, `addtime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题收藏表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_field` --
CREATE TABLE `modoer_field` (
`fieldid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自定义字段ID',
`idtype` varchar(20) NOT NULL COMMENT '使用自定义字段的标识',
`id` smallint(5) NOT NULL default '0' COMMENT '使用自定义字段的ID',
`tablename` varchar(25) NOT NULL COMMENT '表名',
`fieldname` varchar(50) NOT NULL COMMENT '字段名',
`title` varchar(100) NOT NULL COMMENT '标题',
`unit` varchar(100) NOT NULL COMMENT '单位',
`style` varchar(255) NOT NULL COMMENT '样式',
`template` text NOT NULL COMMENT '显示模板',
`note` mediumtext NOT NULL COMMENT '说明',
`type` varchar(20) NOT NULL COMMENT '字段类型',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
`allownull` tinyint(1) unsigned NOT NULL default '1' COMMENT '允许空',
`enablesearch` tinyint(1) unsigned NOT NULL default '0' COMMENT '允许搜索',
`iscore` tinyint(1) NOT NULL default '0' COMMENT '核心',
`isadminfield` varchar(1) NOT NULL default '0' COMMENT '是否后台字段',
`show_list` tinyint(1) unsigned NOT NULL default '0' COMMENT '列表页显示',
`show_detail` tinyint(1) unsigned NOT NULL default '1' COMMENT '内容页显示',
`regular` varchar(255) NOT NULL COMMENT '正则验证',
`errmsg` varchar(255) NOT NULL COMMENT '验证提示',
`datatype` varchar(60) NOT NULL COMMENT 'SQL数据类型',
`config` text NOT NULL COMMENT '字段配置',
`disable` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否禁用',
PRIMARY KEY (`fieldid`),
KEY `tablename` (`tablename`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='自定义字段表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_flowers` --
CREATE TABLE `modoer_flowers` (
`fid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '鲜花自增id',
`rid` mediumint(8) unsigned NOT NULL default '0' COMMENT '点评id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户uid',
`username` varchar(16) NOT NULL COMMENT '用户昵称',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '赠送时间',
PRIMARY KEY (`fid`),
KEY `reviewid` (`rid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='鲜花记录表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_friends` --
CREATE TABLE `modoer_friends` (
`fid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',
`friend_uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '好友ID',
`addtime` int(10) NOT NULL default '0' COMMENT '添加时间',
PRIMARY KEY (`fid`),
KEY `addtime` (`addtime`, `uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='好友表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_gbooks` --
CREATE TABLE `modoer_gbooks` (
`gid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '空间留言本ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '空间用户UID',
`gbuid` mediumint(8) unsigned NOT NULL default '0' COMMENT '留言用户UID',
`gbusername` varchar(16) NOT NULL COMMENT '留言用户昵称',
`content` text NOT NULL COMMENT '留言内容',
`posttime` int(10) NOT NULL default '0' COMMENT '留言时间',
PRIMARY KEY (`gid`),
KEY `uid` (`uid`, `posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='空间留言表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_getpassword` --
CREATE TABLE `modoer_getpassword` (
`getpwid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT 'uid',
`secode` varchar(8) NOT NULL COMMENT '验证码',
`posttime` int(10) NOT NULL default '0' COMMENT '提交时间',
`status` tinyint(1) NOT NULL default '1' COMMENT '状态',
PRIMARY KEY (`getpwid`),
KEY `secode` (`secode`, `status`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='找回密码';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_guestbook` --
CREATE TABLE `modoer_guestbook` (
`guestbookid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题留言ID',
`sid` mediumint(8) NOT NULL default '0' COMMENT '主题ID',
`username` varchar(20) NOT NULL COMMENT '留言用户',
`uid` mediumint(9) unsigned NOT NULL default '0' COMMENT '留言用户UID',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '留言时间',
`content` text NOT NULL COMMENT '内容',
`ip` varchar(15) NOT NULL COMMENT 'ip地址',
`status` tinyint(1) unsigned NOT NULL default '0' COMMENT '状态',
`reply` text NOT NULL COMMENT '回复',
`replytime` int(10) NOT NULL default '0' COMMENT '回复时间',
PRIMARY KEY (`guestbookid`),
KEY `id` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题留言表';
-- --------------------------------------------------------
-- 表的结构 `modoer_membereffect` --
CREATE TABLE `modoer_membereffect` (
`id` mediumint(8) unsigned NOT NULL default '0' COMMENT '行为对象ID',
`idtype` varchar(30) NOT NULL COMMENT '行为对象标识',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户UID',
`username` varchar(20) NOT NULL COMMENT '用户昵称',
`dateline` int(10) NOT NULL default '0' COMMENT '行为时间',
`effect1` tinyint(1) unsigned NOT NULL default '0' COMMENT '行为1',
`effect2` tinyint(1) unsigned NOT NULL default '0' COMMENT '行为2',
`effect3` tinyint(1) unsigned NOT NULL default '0' COMMENT '行为3',
KEY `id` (`id`, `idtype`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户行为表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_membereffect_total` --
CREATE TABLE `modoer_membereffect_total` (
`id` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户行为统计',
`idtype` varchar(15) NOT NULL COMMENT '用户行为对象类型',
`effect1` int(10) unsigned NOT NULL default '0' COMMENT '行为1数量',
`effect2` int(10) unsigned NOT NULL default '0' COMMENT '行为2数量',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户行为统计表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_members` --
CREATE TABLE `modoer_members` (
`uid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '用户UID',
`email` varchar(60) NOT NULL COMMENT 'email',
`password` varchar(32) NOT NULL COMMENT '用户密码',
`username` varchar(16) NOT NULL COMMENT '用户昵称',
`point` int(10) NOT NULL default '0' COMMENT '等级积分',
`coin` int(10) NOT NULL default '0',
`rmb` decimal(9, 1) unsigned NOT NULL default '0.0',
`newmsg` smallint(5) unsigned NOT NULL default '0' COMMENT '新信息',
`regdate` int(10) unsigned NOT NULL default '0' COMMENT '注册时间',
`logintime` int(10) unsigned NOT NULL default '0' COMMENT '登录时间',
`loginip` varchar(16) NOT NULL COMMENT '登录IP',
`logincount` mediumint(8) unsigned NOT NULL default '0' COMMENT '登录次数',
`groupid` smallint(2) NOT NULL default '1' COMMENT '会员组ID',
`nextgroupid` smallint(5) unsigned NOT NULL default '0' COMMENT '过期后用户组',
`nexttime` int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
`subjects` int(10) unsigned NOT NULL default '0' COMMENT '等级主题数量',
`reviews` int(10) unsigned NOT NULL default '0' COMMENT '点评数量',
`responds` int(10) unsigned NOT NULL default '0' COMMENT '回复数量',
`flowers` int(10) unsigned NOT NULL default '0' COMMENT '收到鲜花数量',
`pictures` int(10) unsigned NOT NULL default '0' COMMENT '上传图片数量',
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`),
KEY `email` (`email`),
KEY `groupid` (`groupid`),
KEY `point` (`point`),
KEY `coin` (`coin`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_member_pointlog` --
CREATE TABLE `modoer_member_pointlog` (
`id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '积分记录ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',
`username` varchar(20) NOT NULL COMMENT '用户昵称',
`p_sort` enum('point', 'coin', 'rmb') NOT NULL COMMENT '支出类型',
`p_out` decimal(9, 2) unsigned NOT NULL default '0.00' COMMENT '指出金币',
`p_in` decimal(9, 2) unsigned NOT NULL default '0.00' COMMENT '收入金币',
`des` varchar(255) NOT NULL COMMENT '备注',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '记录时间',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC COMMENT='用户积分行为表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_menus` --
CREATE TABLE `modoer_menus` (
`menuid` smallint(5) unsigned NOT NULL auto_increment COMMENT '菜单id',
`parentid` smallint(5) unsigned NOT NULL default '0' COMMENT '上级菜单id',
`isclosed` tinyint(1) NOT NULL default '0' COMMENT '是否关闭',
`isfolder` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否菜单组',
`title` varchar(100) NOT NULL COMMENT '标题',
`scriptnav` varchar(60) NOT NULL COMMENT '当页标识',
`url` varchar(255) NOT NULL COMMENT '链接',
`icon` varchar(60) NOT NULL COMMENT '图标',
`target` varchar(15) NOT NULL COMMENT '目标框架',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='菜单表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_model` --
CREATE TABLE `modoer_model` (
`modelid` smallint(5) unsigned NOT NULL auto_increment COMMENT '模型id',
`name` varchar(30) NOT NULL COMMENT '模型名称',
`tablename` varchar(20) NOT NULL COMMENT '表名',
`description` varchar(255) NOT NULL COMMENT '内容',
`usearea` tinyint(1) NOT NULL default '0' COMMENT '是否使用地区',
`item_name` varchar(200) NOT NULL COMMENT '主题名称',
`item_unit` varchar(200) NOT NULL COMMENT '主题单位',
`tplname_list` varchar(200) NOT NULL COMMENT '列表页模板',
`tplname_detail` varchar(200) NOT NULL COMMENT '内容页模板',
`disable` tinyint(1) unsigned NOT NULL default '0' COMMENT '禁用',
PRIMARY KEY (`modelid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='模型表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_modules` --
CREATE TABLE `modoer_modules` (
`moduleid` smallint(5) unsigned NOT NULL auto_increment COMMENT '模块ID',
`flag` varchar(30) NOT NULL COMMENT '标识',
`iscore` tinyint(1) NOT NULL default '0' COMMENT '核心',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
`name` varchar(60) NOT NULL COMMENT '名称',
`directory` varchar(100) NOT NULL COMMENT '目录',
`disable` tinyint(1) unsigned NOT NULL default '0' COMMENT '禁用',
`config` text NOT NULL COMMENT '配置',
`version` varchar(60) NOT NULL COMMENT '版本',
`releasetime` date NOT NULL default '0000-00-00' COMMENT '发布时间',
`reliant` varchar(255) NOT NULL COMMENT '依赖',
`author` varchar(255) NOT NULL COMMENT '作者',
`introduce` text NOT NULL COMMENT '介绍',
`siteurl` varchar(255) NOT NULL COMMENT '网址',
`email` varchar(255) NOT NULL COMMENT 'email',
`copyright` varchar(255) NOT NULL COMMENT '版权',
`checkurl` varchar(255) NOT NULL COMMENT '新版本检测',
PRIMARY KEY (`moduleid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='模块表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_mylinks` --
CREATE TABLE `modoer_mylinks` (
`linkid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '链接ID',
`title` varchar(40) NOT NULL COMMENT '标题',
`link` varchar(100) NOT NULL COMMENT '连接地址',
`logo` varchar(100) NOT NULL COMMENT 'logo地址',
`des` varchar(255) NOT NULL COMMENT '说明',
`displayorder` int(8) NOT NULL default '0' COMMENT '排序',
`ischeck` tinyint(1) NOT NULL default '0' COMMENT '是否适合',
PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='友情链接表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_mysubject` --
CREATE TABLE `modoer_mysubject` (
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户ID',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '管理主题ID',
`modelid` smallint(5) NOT NULL default '0' COMMENT '主题模型ID',
`expirydate` int(10) unsigned NOT NULL default '0' COMMENT '到期时间',
`lasttime` int(10) unsigned NOT NULL default '0' COMMENT '最后操作时间',
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='我的主题（主题管理员）表';
-- -- 表的结构 `modoer_pictures` --
CREATE TABLE `modoer_pictures` (
`picid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '图片id',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '上传用户id',
`username` varchar(16) NOT NULL COMMENT '用户名称',
`title` varchar(60) NOT NULL COMMENT '标题',
`thumb` varchar(255) NOT NULL COMMENT '缩略图',
`filename` varchar(255) NOT NULL COMMENT '文件名',
`width` smallint(5) unsigned NOT NULL default '0' COMMENT '图片宽度',
`height` smallint(5) unsigned NOT NULL default '0' COMMENT '图片高度',
`size` int(10) unsigned NOT NULL default '0' COMMENT '大小',
`comments` varchar(60) NOT NULL COMMENT '评论数量',
`sort` tinyint(1) NOT NULL default '0' COMMENT '类型',
`browse` int(10) NOT NULL default '0' COMMENT '浏览量',
`addtime` int(10) NOT NULL default '0' COMMENT '添加时间',
`status` tinyint(1) NOT NULL default '1' COMMENT '状态',
PRIMARY KEY (`picid`),
KEY `uid` (`uid`, `sid`),
KEY `sid` (`sid`, `status`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题图片表';
-- -- 表的结构 `modoer_pmsgs` --
CREATE TABLE `modoer_pmsgs` (
`pmid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '短信息自增id',
`senduid` mediumint(8) unsigned NOT NULL default '0' COMMENT '发送用户uid',
`recvuid` mediumint(8) unsigned NOT NULL default '0' COMMENT '接受用户uid',
`content` mediumtext NOT NULL COMMENT '内容',
`subject` varchar(60) NOT NULL COMMENT '标题',
`posttime` int(10) NOT NULL default '0' COMMENT '发送时间',
`new` tinyint(1) NOT NULL default '1' COMMENT '是否新短信',
`delflag` tinyint(1) NOT NULL default '0' COMMENT '双边删除标记',
PRIMARY KEY (`pmid`),
KEY `senduid` (`senduid`, `posttime`),
KEY `recvuid` (`recvuid`, `posttime`),
KEY `new` (`new`, `recvuid`, `posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='短信息表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_product` --
CREATE TABLE `modoer_product` (
`pid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '产品id',
`modelid` smallint(5) unsigned NOT NULL default '0' COMMENT '模型id',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
`catid` mediumint(8) unsigned NOT NULL default '0' COMMENT '分类id',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '产品发布时间',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '发布用户',
`username` varchar(20) NOT NULL COMMENT '用户昵称',
`subject` varchar(60) NOT NULL COMMENT '名称',
`price` decimal(9, 2) unsigned NOT NULL default '0.00' COMMENT '价钱',
`grade` smallint(5) NOT NULL default '0' COMMENT '评分',
`pageview` mediumint(8) unsigned NOT NULL default '0' COMMENT '浏览量',
`comments` mediumint(8) NOT NULL default '0' COMMENT '评论量',
`picture` varchar(255) NOT NULL COMMENT '图片原图',
`thumb` varchar(255) NOT NULL COMMENT '缩略图',
`description` varchar(255) NOT NULL COMMENT '简介',
`closed_comment` tinyint(1) NOT NULL default '0' COMMENT '关闭评论',
`status` tinyint(1) NOT NULL default '1' COMMENT '状态',
`listorder` smallint(5) unsigned NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`pid`),
KEY `catid` (`sid`, `catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='产品表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_product_category` --
CREATE TABLE `modoer_product_category` (
`catid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '产品分类id',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题sid',
`name` varchar(20) NOT NULL COMMENT '分类名称',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
`num` mediumint(8) unsigned NOT NULL default '0' COMMENT '数量',
PRIMARY KEY (`catid`),
KEY `sid` (`sid`, `catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='产品分类表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_product_model` --
CREATE TABLE `modoer_product_model` (
`modelid` smallint(5) unsigned NOT NULL auto_increment COMMENT '产品模型id',
`name` varchar(30) NOT NULL COMMENT '模型名称',
`tablename` varchar(20) NOT NULL COMMENT '附表名',
`description` varchar(255) NOT NULL COMMENT '介绍',
`usearea` tinyint(1) NOT NULL default '0' COMMENT '是否地理特性',
`item_name` varchar(200) NOT NULL COMMENT '名称',
`item_unit` varchar(200) NOT NULL COMMENT '单位',
`tplname_list` varchar(200) NOT NULL COMMENT '列表页显示',
`tplname_detail` varchar(200) NOT NULL COMMENT '内容页显示',
`disable` tinyint(1) unsigned NOT NULL default '0' COMMENT '禁用',
PRIMARY KEY (`modelid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='产品模型表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_reports` --
CREATE TABLE `modoer_reports` (
`reportid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '举报自增ID',
`rid` mediumint(8) unsigned NOT NULL default '0' COMMENT '点评id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '用户id',
`username` varchar(16) NOT NULL COMMENT '用户昵称',
`email` varchar(60) NOT NULL COMMENT 'email',
`sort` tinyint(1) NOT NULL default '0' COMMENT '举报类型',
`reportcontent` mediumtext NOT NULL COMMENT '内容',
`disposal` tinyint(1) NOT NULL default '0' COMMENT '审核否',
`posttime` int(10) NOT NULL default '0' COMMENT '提交时间',
`disposaltime` int(10) NOT NULL default '0' COMMENT '审核时间',
`reportremark` mediumtext NOT NULL COMMENT '审核备注',
`update_point` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否给举报人积分赠送',
PRIMARY KEY (`reportid`),
KEY `disposal` (`disposal`),
KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点评举报表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_responds` --
CREATE TABLE `modoer_responds` (
`respondid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '回复自增id',
`rid` mediumint(8) unsigned NOT NULL default '0' COMMENT '点评id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '回复用户uid',
`username` varchar(20) NOT NULL COMMENT '回复用户昵称',
`content` text NOT NULL COMMENT '内容',
`posttime` int(10) NOT NULL default '0' COMMENT '时间',
`status` tinyint(1) NOT NULL default '1' COMMENT '审核',
`ip` varchar(15) NOT NULL COMMENT 'ip',
PRIMARY KEY (`respondid`),
KEY `uid` (`uid`, `status`),
KEY `reviewid` (`rid`, `status`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点评回复表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_review` --
CREATE TABLE `modoer_review` (
`rid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '点评id',
`idtype` varchar(30) NOT NULL COMMENT '点评对象表示',
`id` mediumint(8) unsigned NOT NULL default '0' COMMENT '点评对象id',
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL COMMENT '用户昵称',
`status` tinyint(1) unsigned NOT NULL default '1' COMMENT '状态',
`pcatid` smallint(5) unsigned NOT NULL default '0' COMMENT '点评对象分类ID',
`sort1` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项1',
`sort2` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项2',
`sort3` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项3',
`sort4` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项4',
`sort5` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项5',
`sort6` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项6',
`sort7` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项7',
`sort8` tinyint(1) unsigned NOT NULL default '0' COMMENT '点评项8',
`price` int(10) unsigned NOT NULL default '0' COMMENT '消费字段',
`best` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否好评',
`digest` tinyint(1) NOT NULL default '0' COMMENT '是否精华点评',
`havepic` tinyint(1) NOT NULL default '0' COMMENT '是否有图片',
`posttime` int(10) NOT NULL default '0' COMMENT '发布时间',
`isupdate` tinyint(1) NOT NULL default '0' COMMENT '是否更新过',
`flowers` int(8) unsigned NOT NULL default '0' COMMENT '鲜花数量',
`responds` int(8) unsigned NOT NULL default '0' COMMENT '回复数量',
`ip` varchar(15) NOT NULL COMMENT 'ip地址',
`subject` varchar(255) NOT NULL COMMENT '主题名称',
`title` varchar(60) NOT NULL COMMENT '点评标题',
`content` text NOT NULL COMMENT '点评内容',
`taggroup` text NOT NULL COMMENT '标签组',
`pictures` text NOT NULL COMMENT '图片量',
PRIMARY KEY (`rid`),
KEY `sid` (`id`, `status`),
KEY `uid` (`uid`, `status`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点评表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_review_opt` --
CREATE TABLE `modoer_review_opt` (
`id` smallint(5) unsigned NOT NULL auto_increment COMMENT '点评项ID',
`gid` smallint(5) unsigned NOT NULL default '0' COMMENT '点评项组ID',
`flag` varchar(10) NOT NULL COMMENT '点评项字段名',
`name` varchar(50) NOT NULL COMMENT '名称',
`listorder` smallint(5) NOT NULL default '0' COMMENT '排序',
`enable` tinyint(1) NOT NULL default '1' COMMENT '是否启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点评项配置表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_review_opt_group` --
CREATE TABLE `modoer_review_opt_group` (
`gid` smallint(5) unsigned NOT NULL auto_increment COMMENT '点评项组ID',
`name` varchar(60) NOT NULL COMMENT '组名',
`des` varchar(255) NOT NULL COMMENT '说明描述',
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点评项组表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_search_cache` --
CREATE TABLE `modoer_search_cache` (
`ssid` mediumint(8) NOT NULL auto_increment COMMENT '搜索自增ID',
`keyword` varchar(60) NOT NULL default '0' COMMENT '关键词',
`count` mediumint(8) NOT NULL default '0' COMMENT '搜索次数',
`total` mediumint(8) NOT NULL default '0' COMMENT '结果数量',
`catid` smallint(5) NOT NULL default '0' COMMENT '分类ID',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '搜索缓存时间',
PRIMARY KEY (`ssid`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题搜索缓存表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_spaces` --
CREATE TABLE `modoer_spaces` (
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT 'UID',
`space_styleid` smallint(3) NOT NULL default '0' COMMENT '风格ID',
`spacename` varchar(30) NOT NULL COMMENT '空间名',
`spacedescribe` varchar(50) NOT NULL COMMENT '空间描述',
`pageview` int(10) NOT NULL default '0' COMMENT '空间浏览量',
PRIMARY KEY (`uid`),
KEY `pageviews` (`pageview`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='个人空间表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_subject` --
CREATE TABLE `modoer_subject` (
`sid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题ID',
`domain` char(50) NOT NULL COMMENT '个性目录或二级域名',
`aid` smallint(5) unsigned NOT NULL default '0' COMMENT '地区ID',
`pid` smallint(5) unsigned NOT NULL default '0' COMMENT '主分类ID',
`catid` smallint(5) unsigned NOT NULL default '0' COMMENT '子分类ID',
`name` varchar(60) NOT NULL COMMENT '名称',
`subname` varchar(60) NOT NULL COMMENT '子名称',
`avgsort` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '平均分',
`sort1` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分1',
`sort2` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分2',
`sort3` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分3',
`sort4` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分4',
`sort5` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分5',
`sort6` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分6',
`sort7` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分7',
`sort8` decimal(4, 2) unsigned NOT NULL default '0.00' COMMENT '评分8',
`avgprice` int(10) unsigned NOT NULL default '0' COMMENT '平均消费',
`best` int(10) unsigned NOT NULL default '0' COMMENT '是否喜欢',
`reviews` int(10) unsigned NOT NULL default '0' COMMENT '点评数',
`guestbooks` int(10) unsigned NOT NULL default '0' COMMENT '留言数量',
`pictures` int(10) unsigned NOT NULL default '0' COMMENT '图片数',
`pageviews` int(10) unsigned NOT NULL default '1' COMMENT '浏览量',
`products` mediumint(8) unsigned NOT NULL default '0' COMMENT '产品数量',
`coupons` mediumint(8) unsigned NOT NULL default '0' COMMENT '优惠券数量',
`favorites` mediumint(8) unsigned NOT NULL default '0' COMMENT '会员卡',
`finer` tinyint(3) unsigned NOT NULL default '0' COMMENT '推荐度',
`level` tinyint(3) unsigned NOT NULL default '0' COMMENT '等级',
`owner` varchar(20) NOT NULL COMMENT '管理员昵称',
`cuid` mediumint(8) unsigned NOT NULL default '0' COMMENT '创建者UID',
`creator` varchar(20) NOT NULL COMMENT '创建者昵称',
`addtime` int(10) unsigned NOT NULL default '0' COMMENT '添加时间',
`video` varchar(255) NOT NULL COMMENT '视频',
`thumb` varchar(255) NOT NULL COMMENT '缩略图',
`status` tinyint(1) unsigned NOT NULL default '1' COMMENT '状态',
`map_lng` decimal(8, 5) NOT NULL default '0.00000' COMMENT '地图坐标',
`map_lat` decimal(8, 5) NOT NULL default '0.00000' COMMENT '地图坐标',
`description` varchar(255) NOT NULL COMMENT '简介',
PRIMARY KEY (`sid`),
KEY `aid` (`aid`, `catid`),
KEY `pid` (`pid`),
KEY `name` (`name`),
KEY `doamin` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_subjectapply` --
CREATE TABLE `modoer_subjectapply` (
`applyid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '申请ID',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '申请用户ID',
`username` varchar(20) NOT NULL COMMENT '申请用户昵称',
`status` tinyint(1) unsigned NOT NULL default '0' COMMENT '状态',
`applyname` varchar(100) NOT NULL COMMENT '申请人',
`contact` varchar(255) NOT NULL COMMENT '申请人联系方式',
`pic` varchar(255) NOT NULL COMMENT '上传的图片',
`content` mediumtext NOT NULL COMMENT '备注',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '申请时间',
`checker` varchar(30) NOT NULL COMMENT '审核人',
`returned` text NOT NULL COMMENT '审核备注',
PRIMARY KEY (`applyid`),
KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题申请表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_subjectatt` --
CREATE TABLE `modoer_subjectatt` (
`id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题属性ID',
`sid` mediumint(8) unsigned NOT NULL COMMENT '主题ID',
`attid` mediumint(8) unsigned NOT NULL COMMENT '属性值ID',
`att_catid` mediumint(8) unsigned NOT NULL COMMENT '属性组ID',
PRIMARY KEY (`id`),
KEY `sid` (`sid`, `attid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题属性表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_subjectfield` --
CREATE TABLE `modoer_subjectfield` (
`fieldid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '主题自定义字段ID',
`modelid` smallint(5) NOT NULL default '0' COMMENT '模型ID',
`tablename` varchar(25) NOT NULL COMMENT '附表名',
`fieldname` varchar(50) NOT NULL COMMENT '附表字段名',
`title` varchar(100) NOT NULL COMMENT '标题',
`unit` varchar(100) NOT NULL COMMENT '单位',
`style` varchar(255) NOT NULL,
`template` text NOT NULL COMMENT '显示模板',
`note` mediumtext NOT NULL COMMENT '描述',
`type` varchar(20) NOT NULL COMMENT '字段类型',
`listorder` smallint(5) NOT NULL default '0' COMMENT '字段顺序',
`allownull` tinyint(1) unsigned NOT NULL default '1' COMMENT '允许空值',
`enablesearch` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否搜索',
`iscore` tinyint(1) NOT NULL default '0' COMMENT '是否核心',
`isadminfield` varchar(1) NOT NULL default '0' COMMENT '是否后台字段',
`show_list` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否在列表页显示',
`show_detail` tinyint(1) unsigned NOT NULL default '1' COMMENT '是否在内容页显示',
`regular` varchar(255) NOT NULL COMMENT '正则表达验证',
`errmsg` varchar(255) NOT NULL COMMENT '验证失败提示信息',
`datatype` varchar(60) NOT NULL COMMENT 'SQL数据类型',
`config` text NOT NULL COMMENT '字段配置信息',
`disable` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否禁用',
PRIMARY KEY (`fieldid`),
KEY `tablename` (`tablename`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='主题自定义字段表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_subjectlog` --
CREATE TABLE `modoer_subjectlog` (
`upid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '补充主题id',
`sid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '补充人uid',
`username` varchar(16) NOT NULL COMMENT '补充人昵称',
`email` varchar(60) NOT NULL COMMENT 'email',
`ismappoint` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否地图报错',
`upcontent` mediumtext NOT NULL COMMENT '补充内容',
`disposal` tinyint(1) NOT NULL default '0' COMMENT '是否审核通过',
`posttime` int(10) NOT NULL default '0' COMMENT '提交时间',
`upremark` mediumtext NOT NULL COMMENT '补充标注',
`disposaltime` int(10) NOT NULL default '0' COMMENT '审核时间',
`update_point` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否给补充人积分',
PRIMARY KEY (`upid`),
KEY `sid` (`sid`),
KEY `disposal` (`disposal`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- -- 表的结构 `modoer_taggroup` --
CREATE TABLE `modoer_taggroup` (
`tgid` smallint(5) unsigned NOT NULL auto_increment COMMENT '标签组ID',
`name` varchar(30) NOT NULL COMMENT '标签组名称',
`des` varchar(200) NOT NULL COMMENT '描述',
`sort` tinyint(1) unsigned NOT NULL default '0' COMMENT '类型',
`options` text NOT NULL COMMENT '字段值',
PRIMARY KEY (`tgid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='标签组表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_tags` --
CREATE TABLE `modoer_tags` (
`tagid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '标签ID',
`tagname` varchar(20) NOT NULL COMMENT '标签名',
`closed` tinyint(1) NOT NULL default '0' COMMENT '是否关闭',
`total` int(10) unsigned NOT NULL default '0' COMMENT '统计数量',
`dateline` int(10) unsigned NOT NULL default '0' COMMENT '标签更新呢时间',
PRIMARY KEY (`tagid`),
KEY `total` (`total`),
KEY `closed` (`closed`),
KEY `tagname` (`tagname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='标签表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_tag_data` --
CREATE TABLE `modoer_tag_data` (
`stid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '标签数据索引ID',
`tagid` int(10) unsigned NOT NULL default '0' COMMENT '标签ID',
`tgid` smallint(5) unsigned NOT NULL default '0' COMMENT '标签组ID',
`id` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID',
`tagname` varchar(25) NOT NULL COMMENT '标签名称',
`total` int(10) unsigned NOT NULL default '0' COMMENT '数量',
PRIMARY KEY (`stid`),
KEY `tagid` (`tagid`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='标签数据表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_templates` --
CREATE TABLE `modoer_templates` (
`templateid` smallint(6) unsigned NOT NULL auto_increment COMMENT '模板id',
`name` varchar(20) NOT NULL COMMENT '模板名称',
`directory` varchar(100) NOT NULL COMMENT '所在目录',
`copyright` varchar(45) NOT NULL COMMENT '版权',
`tpltype` varchar(15) NOT NULL COMMENT '模板类型',
`bind` tinyint(1) NOT NULL default '0' COMMENT '（废弃）',
PRIMARY KEY (`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='模板数据表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_travelers` --
CREATE TABLE `modoer_travelers` (
`tid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',
`uid` mediumint(8) unsigned NOT NULL default '0' COMMENT '被访问uid',
`tuid` mediumint(8) unsigned NOT NULL default '0' COMMENT '访问uid',
`tusername` varchar(16) NOT NULL COMMENT '访问者',
`addtime` int(10) NOT NULL default '0' COMMENT '最近访问时间',
PRIMARY KEY (`tid`),
KEY `uid` (`uid`, `addtime`),
KEY `tuid` (`tuid`, `addtime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='空间游客表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_usergroups` --
CREATE TABLE `modoer_usergroups` (
`groupid` smallint(6) NOT NULL auto_increment COMMENT '用户组ID',
`grouptype` enum('member', 'special', 'system') default 'member' COMMENT '用户组类型',
`groupname` char(16) default NULL COMMENT '用户组名称',
`point` int(10) NOT NULL default '0' COMMENT '积分范围',
`color` varchar(7) NOT NULL COMMENT '颜色',
`access` text NOT NULL COMMENT '权限信息',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户组表';
-- --------------------------------------------------------
-- -- 表的结构 `modoer_words` --
CREATE TABLE `modoer_words` (
`id` smallint(5) unsigned NOT NULL auto_increment COMMENT '敏感词ID',
`keyword` varchar(255) NOT NULL COMMENT '词',
`expression` varchar(255) NOT NULL COMMENT '过滤（替换，审核等）',
`admin` varchar(20) NOT NULL COMMENT '录入管理员',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='敏感词过滤表';
