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='敏感詞過濾表';
