Mikel
Database: `we7_pro`
书写 SQL 语句时一定要注意规范, 不要加不必要的空格, Tab 等, “;” 结尾直接换行.
数据表图例
核心 SQL
-- phpMyAdmin SQL Dump -- version 4.1.6 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: 2015-01-27 11:00:31 -- 服务器版本： 5.5.39 -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Database: `we7_pro` -- -- -- 表的结构 `ims_account` -- CREATE TABLE IF NOT EXISTS `ims_account` ( `acid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `hash` VARCHAR(8) NOT NULL, `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '1为微信，2为易信', `isconnect` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`acid`), KEY `idx_uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=437 ; -- -- 表的结构 `ims_account_wechats` -- CREATE TABLE IF NOT EXISTS `ims_account_wechats` ( `acid` INT(10) UNSIGNED NOT NULL, `uniacid` INT(10) UNSIGNED NOT NULL, `token` VARCHAR(32) NOT NULL COMMENT '随机生成密钥', `encodingaeskey` VARCHAR(43) NOT NULL, `access_token` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '存取凭证结构', `jsapi_ticket` VARCHAR(1000) NOT NULL, `level` tinyint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT '接口权限级别, 0 普通订阅号, 1 认证订阅号|普通服务号, 2认证服务号', `name` VARCHAR(30) NOT NULL COMMENT '公众号名称', `account` VARCHAR(30) NOT NULL COMMENT '微信帐号', `original` VARCHAR(50) NOT NULL, `signature` VARCHAR(100) NOT NULL COMMENT '功能介绍', `country` VARCHAR(10) NOT NULL, `province` VARCHAR(3) NOT NULL, `city` VARCHAR(15) NOT NULL, `username` VARCHAR(30) NOT NULL, `password` VARCHAR(32) NOT NULL, `lastupdate` INT(10) UNSIGNED NOT NULL DEFAULT '0', `key` VARCHAR(50) NOT NULL, `secret` VARCHAR(50) NOT NULL, `styleid` INT(10) UNSIGNED NOT NULL DEFAULT '1' COMMENT '风格ID', `subscribeurl` VARCHAR(120) NOT NULL DEFAULT '' COMMENT '引导素材', PRIMARY KEY (`acid`), KEY `idx_key` (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 表的结构 `ims_activity_coupon` -- CREATE TABLE IF NOT EXISTS `ims_activity_coupon` ( `couponid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '公号序号', `type` tinyint(4) NOT NULL COMMENT '优惠券类型. 1为折扣券, 2为代金券', `title` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '标题', `couponsn` VARCHAR(50) NOT NULL, `description` text COMMENT '描述', `discount` DECIMAL(10,2) NOT NULL COMMENT '折扣券(折扣率), 代金券(面额)', `condition` DECIMAL(10,2) NOT NULL COMMENT '订单满多少可用', `starttime` INT(10) UNSIGNED NOT NULL COMMENT '开始时间', `endtime` INT(10) UNSIGNED NOT NULL COMMENT '结束时间', `limit` INT(11) NOT NULL DEFAULT '0' COMMENT '每人限领', `dosage` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '已领取数量', `amount` INT(11) UNSIGNED NOT NULL COMMENT '总发行数量', `thumb` VARCHAR(500) NOT NULL COMMENT '缩略图', `credittype` VARCHAR(20) NOT NULL, `credit` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`couponid`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ; -- -- 表的结构 `ims_activity_coupon_allocation` -- CREATE TABLE IF NOT EXISTS `ims_activity_coupon_allocation` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `couponid` INT(10) UNSIGNED NOT NULL, `groupid` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`,`couponid`,`groupid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=407 ; -- -- 表的结构 `ims_activity_coupon_password` -- CREATE TABLE IF NOT EXISTS `ims_activity_coupon_password` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `name` VARCHAR(50) NOT NULL DEFAULT '', `password` VARCHAR(200) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; -- -- 表的结构 `ims_activity_coupon_record` -- CREATE TABLE IF NOT EXISTS `ims_activity_coupon_record` ( `recid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '序号', `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL COMMENT '用户编号', `grantmodule` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '发放模块', `granttime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发放时间', `usemodule` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '使用模块', `usetime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '使用时间', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态: 0 未发放, 1 已发放, 2 已使用', `operator` VARCHAR(30) NOT NULL COMMENT '操作员', `remark` VARCHAR(300) NOT NULL DEFAULT '', `couponid` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`recid`), KEY `couponid` (`uid`,`grantmodule`,`usemodule`,`status`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ; -- -- 表的结构 `ims_activity_exchange` -- CREATE TABLE IF NOT EXISTS `ims_activity_exchange` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(11) NOT NULL, `title` VARCHAR(100) NOT NULL COMMENT '物品名称', `description` VARCHAR(1000) NOT NULL COMMENT '描述信息', `thumb` VARCHAR(500) NOT NULL COMMENT '缩略图', `type` tinyint(1) UNSIGNED NOT NULL COMMENT '物品类型，1折扣券，2代金券，3实物，4虚拟物品(未启用)，5营销模块操作次数', `extra` VARCHAR(3000) NOT NULL DEFAULT '' COMMENT '兑换产品属性', `credit` INT(10) UNSIGNED NOT NULL COMMENT '兑换积分数量', `credittype` VARCHAR(10) NOT NULL COMMENT '兑换积分类型', `pretotal` INT(11) NOT NULL COMMENT '每个人最大兑换次数', `num` INT(11) NOT NULL COMMENT '已兑换礼品数量', `total` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总量', `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态', `starttime` INT(10) UNSIGNED NOT NULL, `endtime` INT(10) NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL, `couponid` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ; -- -- 表的结构 `ims_activity_exchange_trades` -- CREATE TABLE IF NOT EXISTS `ims_activity_exchange_trades` ( `tid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '统一公号', `uid` INT(10) UNSIGNED NOT NULL COMMENT '用户(粉丝)id', `exid` INT(10) UNSIGNED NOT NULL COMMENT '兑换产品 exchangeid', `type` INT(10) UNSIGNED NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '交换记录创建时间', PRIMARY KEY (`tid`), KEY `uniacid` (`uniacid`,`uid`,`exid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- 表的结构 `ims_activity_exchange_trades_shipping` -- CREATE TABLE IF NOT EXISTS `ims_activity_exchange_trades_shipping` ( `tid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `exid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '订单状态，0为正常，-1为关闭，1为已发货，2为已完成', `createtime` INT(10) UNSIGNED NOT NULL, `province` VARCHAR(30) NOT NULL, `city` VARCHAR(30) NOT NULL, `district` VARCHAR(30) NOT NULL, `address` VARCHAR(255) NOT NULL, `zipcode` VARCHAR(6) NOT NULL, `mobile` VARCHAR(30) NOT NULL, `name` VARCHAR(30) NOT NULL COMMENT '收件人', PRIMARY KEY (`tid`), KEY `uniacid` (`uniacid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- 表的结构 `ims_activity_modules` -- CREATE TABLE IF NOT EXISTS `ims_activity_modules` ( `mid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '公号ID', `exid` INT(10) UNSIGNED NOT NULL COMMENT '活动参与次数id', `module` VARCHAR(50) NOT NULL COMMENT '模块名称', `uid` INT(10) UNSIGNED NOT NULL COMMENT '用户ID', `available` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '可用次数', PRIMARY KEY (`mid`), KEY `uniacid` (`uniacid`), KEY `module` (`module`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; -- -- 表的结构 `ims_activity_modules_record` -- CREATE TABLE IF NOT EXISTS `ims_activity_modules_record` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `mid` INT(10) UNSIGNED NOT NULL, `num` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'num=1表示兑换,num=-1表示消费', `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `mid` (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- 表的结构 `ims_basic_reply` -- CREATE TABLE IF NOT EXISTS `ims_basic_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `content` VARCHAR(1000) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=246 ; -- -- 表的结构 `ims_core_attachment` -- CREATE TABLE IF NOT EXISTS `ims_core_attachment` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `filename` VARCHAR(255) NOT NULL, `attachment` VARCHAR(255) NOT NULL, `type` tinyint(3) UNSIGNED NOT NULL COMMENT '1.图片; 2.音乐;', `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=694 ; -- -- 表的结构 `ims_core_cache` -- CREATE TABLE IF NOT EXISTS `ims_core_cache` ( `key` VARCHAR(50) NOT NULL COMMENT '缓存键名', `value` mediumtext NOT NULL COMMENT '缓存内容', PRIMARY KEY (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='缓存表'; -- -- 表的结构 `ims_core_paylog` -- CREATE TABLE IF NOT EXISTS `ims_core_paylog` ( `plid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `type` VARCHAR(20) NOT NULL DEFAULT '', `uniacid` INT(11) NOT NULL, `acid` INT(11) NOT NULL, `openid` VARCHAR(40) NOT NULL DEFAULT '', `tid` VARCHAR(64) NOT NULL, `fee` DECIMAL(10,2) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '0', `module` VARCHAR(50) NOT NULL DEFAULT '', `tag` VARCHAR(2000) NOT NULL DEFAULT '', PRIMARY KEY (`plid`), KEY `idx_openid` (`openid`), KEY `idx_tid` (`tid`), KEY `idx_uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ; -- -- 表的结构 `ims_core_performance` -- CREATE TABLE IF NOT EXISTS `ims_core_performance` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `type` tinyint(1) NOT NULL COMMENT '1:系统,2:数据库', `runtime` VARCHAR(10) NOT NULL COMMENT '运行时间', `runurl` VARCHAR(512) NOT NULL COMMENT '运行页面url', `runsql` VARCHAR(512) NOT NULL COMMENT '运行sql语句', `createtime` INT(10) NOT NULL COMMENT '记录时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=297223 ; -- -- 表的结构 `ims_core_queue` -- CREATE TABLE IF NOT EXISTS `ims_core_queue` ( `qid` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '逻辑主键', `uniacid` INT(10) UNSIGNED NOT NULL, `acid` INT(10) UNSIGNED NOT NULL, `message` VARCHAR(2000) NOT NULL DEFAULT '', `params` VARCHAR(1000) NOT NULL DEFAULT '', `keyword` VARCHAR(1000) NOT NULL DEFAULT '', `response` VARCHAR(2000) NOT NULL DEFAULT '', `module` VARCHAR(50) NOT NULL DEFAULT '', `dateline` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`qid`), KEY `uniacid` (`uniacid`,`acid`), KEY `module` (`module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5475 ; -- -- 表的结构 `ims_core_resource` -- CREATE TABLE IF NOT EXISTS `ims_core_resource` ( `mid` INT(11) NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `media_id` VARCHAR(100) NOT NULL, `trunk` INT(10) UNSIGNED NOT NULL DEFAULT '0', `type` VARCHAR(10) NOT NULL, `dateline` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`mid`), KEY `acid` (`uniacid`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- 表的结构 `ims_core_sessions` -- CREATE TABLE IF NOT EXISTS `ims_core_sessions` ( `sid` CHAR(32) NOT NULL DEFAULT '' COMMENT 'sessionid唯一标识', `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '所属公众号', `openid` VARCHAR(50) NOT NULL COMMENT '用户唯一标识', `data` VARCHAR(500) NOT NULL, `expiretime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '超时时间', PRIMARY KEY (`sid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 表的结构 `ims_core_settings` -- CREATE TABLE IF NOT EXISTS `ims_core_settings` ( `key` VARCHAR(200) NOT NULL COMMENT '设置键名', `value` text NOT NULL COMMENT '设置内容，大量数据将序列化', PRIMARY KEY (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 表的结构 `ims_core_wechats_attachment` -- CREATE TABLE IF NOT EXISTS `ims_core_wechats_attachment` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `filename` VARCHAR(255) NOT NULL, `attachment` VARCHAR(255) NOT NULL, `media_id` VARCHAR(255) NOT NULL, `type` VARCHAR(15) NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `media_id` (`media_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=650 ; -- -- 表的结构 `ims_cover_reply` -- CREATE TABLE IF NOT EXISTS `ims_cover_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `multiid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `rid` INT(10) UNSIGNED NOT NULL, `module` VARCHAR(30) NOT NULL DEFAULT '', `do` VARCHAR(30) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` VARCHAR(255) NOT NULL DEFAULT '', `thumb` VARCHAR(255) NOT NULL DEFAULT '', `url` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=96 ; -- -- 表的结构 `ims_cron` -- CREATE TABLE IF NOT EXISTS `ims_cron` ( `cronid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT, `available` tinyint(1) NOT NULL DEFAULT '0', `type` enum('user','system','plugin') NOT NULL DEFAULT 'user', `name` CHAR(50) NOT NULL DEFAULT '', `filename` CHAR(50) NOT NULL DEFAULT '', `lastrun` INT(10) UNSIGNED NOT NULL DEFAULT '0', `nextrun` INT(10) UNSIGNED NOT NULL DEFAULT '0', `weekday` tinyint(1) NOT NULL DEFAULT '0', `day` tinyint(2) NOT NULL DEFAULT '0', `hour` tinyint(2) NOT NULL DEFAULT '0', `minute` CHAR(36) NOT NULL DEFAULT '', PRIMARY KEY (`cronid`), KEY `nextrun` (`available`,`nextrun`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- 表的结构 `ims_custom_reply` -- CREATE TABLE IF NOT EXISTS `ims_custom_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `start1` INT(10) UNSIGNED NOT NULL DEFAULT '0', `end1` INT(10) UNSIGNED NOT NULL DEFAULT '0', `start2` INT(10) UNSIGNED NOT NULL, `end2` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `rid` (`rid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- 表的结构 `ims_images_reply` -- CREATE TABLE IF NOT EXISTS `ims_images_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL COMMENT '规则ID', `title` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '标题', `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '介绍', `mediaid` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '图片id', `createtime` INT(10) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=131 ; -- -- 表的结构 `ims_mc_card` -- CREATE TABLE IF NOT EXISTS `ims_mc_card` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `title` VARCHAR(100) NOT NULL DEFAULT '', `color` VARCHAR(255) NOT NULL DEFAULT '', `background` VARCHAR(255) NOT NULL DEFAULT '', `logo` VARCHAR(255) NOT NULL DEFAULT '', `format` VARCHAR(50) NOT NULL DEFAULT '', `fields` VARCHAR(1000) NOT NULL DEFAULT '', `snpos` INT(11) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用1:启用0:关闭', `business` text NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ; -- -- 表的结构 `ims_mc_card_members` -- CREATE TABLE IF NOT EXISTS `ims_mc_card_members` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) DEFAULT NULL, `cid` INT(10) NOT NULL DEFAULT '0', `cardsn` VARCHAR(20) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=85 ; -- -- 表的结构 `ims_mc_chats_record` -- CREATE TABLE IF NOT EXISTS `ims_mc_chats_record` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `acid` INT(10) UNSIGNED NOT NULL, `flag` tinyint(3) UNSIGNED NOT NULL DEFAULT '1', `openid` VARCHAR(32) NOT NULL, `msgtype` VARCHAR(15) NOT NULL, `content` VARCHAR(10000) NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`,`acid`), KEY `openid` (`openid`), KEY `createtime` (`createtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=86 ; -- -- 表的结构 `ims_mc_credits_recharge` -- CREATE TABLE IF NOT EXISTS `ims_mc_credits_recharge` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `tid` VARCHAR(20) NOT NULL, `transid` VARCHAR(30) NOT NULL, `fee` VARCHAR(10) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `idx_uniacid_uid` (`uniacid`,`uid`), KEY `idx_tid` (`tid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; -- -- 表的结构 `ims_mc_credits_record` -- CREATE TABLE IF NOT EXISTS `ims_mc_credits_record` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `uid` INT(10) UNSIGNED NOT NULL, `uniacid` INT(11) NOT NULL, `credittype` VARCHAR(10) NOT NULL DEFAULT '', `num` DECIMAL(10,2) NOT NULL DEFAULT '0.00', `operator` INT(10) UNSIGNED NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL, `remark` VARCHAR(200) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=367 ; -- -- 表的结构 `ims_mc_fans_groups` -- CREATE TABLE IF NOT EXISTS `ims_mc_fans_groups` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `acid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `groups` VARCHAR(10000) NOT NULL, PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 表的结构 `ims_mc_groups` -- CREATE TABLE IF NOT EXISTS `ims_mc_groups` ( `groupid` INT(11) NOT NULL AUTO_INCREMENT, `uniacid` INT(11) NOT NULL DEFAULT '0', `title` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '会员组名称', `orderlist` tinyint(4) UNSIGNED NOT NULL DEFAULT '0', `isdefault` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`groupid`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=277 ; -- -- 表的结构 `ims_mc_handsel` -- CREATE TABLE IF NOT EXISTS `ims_mc_handsel` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) NOT NULL, `touid` INT(10) UNSIGNED NOT NULL COMMENT '用户uid', `fromuid` VARCHAR(32) NOT NULL COMMENT '来源', `module` VARCHAR(30) NOT NULL COMMENT '模块名称', `sign` VARCHAR(100) NOT NULL COMMENT '赠送积分的对象', `action` VARCHAR(20) NOT NULL COMMENT '动作（分享，阅读）', `credit_value` INT(10) UNSIGNED NOT NULL COMMENT '赠送积分多少', `createtime` INT(10) UNSIGNED NOT NULL COMMENT '记录添加时间', PRIMARY KEY (`id`), KEY `uid` (`touid`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ; -- -- 表的结构 `ims_mc_mapping_fans` -- CREATE TABLE IF NOT EXISTS `ims_mc_mapping_fans` ( `fanid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `acid` INT(10) UNSIGNED NOT NULL COMMENT '公众号ID', `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '统一公号(冗余列)', `uid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '统一用户', `openid` VARCHAR(255) NOT NULL COMMENT '用户的唯一身份ID', `groupid` INT(10) UNSIGNED DEFAULT '0' COMMENT '粉丝所在组id', `salt` CHAR(8) NOT NULL DEFAULT '' COMMENT '加密盐', `follow` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否订阅', `followtime` INT(10) UNSIGNED NOT NULL, `unfollowtime` INT(10) UNSIGNED NOT NULL, `tag` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `updatetime` INT(10) UNSIGNED DEFAULT '0' COMMENT '粉丝信息最后更新时间', PRIMARY KEY (`fanid`), UNIQUE KEY `sasdf` (`salt`), KEY `acid` (`acid`), KEY `uniacid` (`uniacid`), KEY `openid` (`openid`), KEY `updatetime` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=75171 ; -- -- 表的结构 `ims_mc_members` -- CREATE TABLE IF NOT EXISTS `ims_mc_members` ( `uid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '统一公号ID', `mobile` VARCHAR(11) NOT NULL DEFAULT '' COMMENT '手机号码', `email` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '电子邮箱', `password` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '密码', `salt` VARCHAR(8) NOT NULL DEFAULT '' COMMENT '盐', `groupid` INT(11) NOT NULL DEFAULT '0', `credit1` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '积分', `credit2` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '余额', `credit3` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00', `credit4` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00', `credit5` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00', `createtime` INT(10) UNSIGNED NOT NULL COMMENT '加入时间', `realname` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '真实姓名', `nickname` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '昵称', `avatar` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '头像', `qq` VARCHAR(15) NOT NULL DEFAULT '' COMMENT 'QQ号', `vip` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'VIP级别,0为普通会员', `gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0:保密 1:男 2:女)', `birthyear` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生日年', `birthmonth` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生日月', `birthday` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生日', `constellation` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '星座', `zodiac` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '生肖', `telephone` VARCHAR(15) NOT NULL DEFAULT '' COMMENT '固定电话', `idcard` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '证件号码', `studentid` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '学号', `grade` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '班级', `address` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '邮寄地址', `zipcode` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '邮编', `nationality` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '国籍', `resideprovince` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '居住省份', `residecity` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '居住城市', `residedist` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '居住行政区/县', `graduateschool` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '毕业学校', `company` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '公司', `education` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '学历', `occupation` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '职业', `position` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '职位', `revenue` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '年收入', `affectivestatus` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '情感状态', `lookingfor` VARCHAR(255) NOT NULL DEFAULT '' COMMENT ' 交友目的', `bloodtype` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '血型', `height` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '身高', `weight` VARCHAR(5) NOT NULL DEFAULT '' COMMENT '体重', `alipay` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '支付宝帐号', `msn` VARCHAR(30) NOT NULL DEFAULT '' COMMENT 'MSN', `taobao` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '阿里旺旺', `site` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '主页', `bio` text NOT NULL COMMENT '自我介绍', `interest` text NOT NULL COMMENT '兴趣爱好', PRIMARY KEY (`uid`), KEY `groupid` (`groupid`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9983 ; -- -- 表的结构 `ims_modules` -- CREATE TABLE IF NOT EXISTS `ims_modules` ( `mid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL COMMENT '标识', `type` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '类型', `title` VARCHAR(100) NOT NULL COMMENT '名称', `version` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '版本', `ability` VARCHAR(500) NOT NULL COMMENT '功能描述', `description` VARCHAR(1000) NOT NULL COMMENT '介绍', `author` VARCHAR(50) NOT NULL COMMENT '作者', `url` VARCHAR(255) NOT NULL COMMENT '发布页面', `settings` tinyint(1) NOT NULL DEFAULT '0' COMMENT '扩展设置项', `subscribes` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '订阅的消息类型', `handles` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '能够直接处理的消息类型', `isrulefields` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有规则嵌入项', `issystem` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否是系统模块', `issolution` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `target` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`mid`), KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=399 ; -- -- 表的结构 `ims_modules_bindings` -- CREATE TABLE IF NOT EXISTS `ims_modules_bindings` ( `eid` INT(11) NOT NULL AUTO_INCREMENT, `module` VARCHAR(30) NOT NULL DEFAULT '', `entry` VARCHAR(10) NOT NULL DEFAULT '', `call` VARCHAR(50) NOT NULL DEFAULT '', `title` VARCHAR(50) NOT NULL, `do` VARCHAR(30) NOT NULL, `state` VARCHAR(200) NOT NULL, `direct` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`eid`), KEY `idx_module` (`module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2670 ; -- -- 表的结构 `ims_music_reply` -- CREATE TABLE IF NOT EXISTS `ims_music_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL COMMENT '规则ID', `title` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '标题', `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '介绍', `url` VARCHAR(300) NOT NULL DEFAULT '' COMMENT '音乐地址', `hqurl` VARCHAR(300) NOT NULL DEFAULT '' COMMENT '高清地址', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=167 ; -- -- 表的结构 `ims_news_reply` -- CREATE TABLE IF NOT EXISTS `ims_news_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL, `title` VARCHAR(50) NOT NULL, `author` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '作者', `description` VARCHAR(255) NOT NULL, `thumb` VARCHAR(255) NOT NULL COMMENT '封面图片', `content` text NOT NULL, `url` VARCHAR(255) NOT NULL, `displayorder` INT(10) NOT NULL, `incontent` tinyint(1) NOT NULL DEFAULT '0' COMMENT '封面是否显示在正文中', `createtime` INT(10) NOT NULL COMMENT '发布时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=763 ; -- -- 表的结构 `ims_profile_fields` -- CREATE TABLE IF NOT EXISTS `ims_profile_fields` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `field` VARCHAR(255) NOT NULL, `available` tinyint(1) NOT NULL DEFAULT '1', `title` VARCHAR(255) NOT NULL, `description` VARCHAR(255) NOT NULL, `displayorder` SMALLINT(6) NOT NULL DEFAULT '0', `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否必填', `unchangeable` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否不可修改', `showinregister` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否显示在注册表单', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ; -- -- 表的结构 `ims_qrcode` -- CREATE TABLE IF NOT EXISTS `ims_qrcode` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `acid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `qrcid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '二维码场景ID', `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '场景名称', `keyword` VARCHAR(100) NOT NULL COMMENT '关联关键字', `model` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '模式，1临时，2为永久', `ticket` VARCHAR(250) NOT NULL DEFAULT '' COMMENT '标识', `expire` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '过期时间', `subnum` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关注扫描次数', `createtime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生成时间', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0为未启用，1为启用', PRIMARY KEY (`id`), KEY `idx_qrcid` (`qrcid`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ; -- -- 表的结构 `ims_qrcode_stat` -- CREATE TABLE IF NOT EXISTS `ims_qrcode_stat` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `acid` INT(10) UNSIGNED NOT NULL, `qid` INT(10) UNSIGNED NOT NULL, `openid` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '用户的唯一身份ID', `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否发生在订阅时', `qrcid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '二维码场景ID', `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '场景名称', `createtime` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生成时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- 表的结构 `ims_rule` -- CREATE TABLE IF NOT EXISTS `ims_rule` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(50) NOT NULL DEFAULT '', `module` VARCHAR(50) NOT NULL, `displayorder` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '规则排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '规则状态，0禁用，1启用，2置顶', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=432 ; -- -- 表的结构 `ims_rule_keyword` -- CREATE TABLE IF NOT EXISTS `ims_rule_keyword` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '规则ID', `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属帐号', `module` VARCHAR(50) NOT NULL COMMENT '对应模块', `content` VARCHAR(255) NOT NULL COMMENT '内容', `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '类型1匹配，2包含，3正则', `displayorder` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '规则排序，255为置顶，其它为普通排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '规则状态，0禁用，1启用', PRIMARY KEY (`id`), KEY `idx_content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1832 ; -- -- 表的结构 `ims_site_article` -- CREATE TABLE IF NOT EXISTS `ims_site_article` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `rid` INT(10) UNSIGNED NOT NULL COMMENT '关联规则id', `kid` INT(10) UNSIGNED NOT NULL COMMENT '关联关键字id', `iscommend` tinyint(1) NOT NULL DEFAULT '0', `ishot` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `pcate` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '一级分类', `ccate` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '二级分类', `template` VARCHAR(30) NOT NULL COMMENT '内容模板', `title` VARCHAR(100) NOT NULL DEFAULT '', `description` VARCHAR(100) NOT NULL DEFAULT '', `content` mediumtext NOT NULL, `thumb` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '缩略图', `source` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '来源', `author` VARCHAR(50) NOT NULL COMMENT '作者', `displayorder` INT(10) UNSIGNED NOT NULL DEFAULT '0', `linkurl` VARCHAR(500) NOT NULL DEFAULT '', `createtime` INT(10) UNSIGNED NOT NULL DEFAULT '0', `type` VARCHAR(10) NOT NULL DEFAULT '', `credit` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `idx_iscommend` (`iscommend`), KEY `idx_ishot` (`ishot`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; -- -- 表的结构 `ims_site_category` -- CREATE TABLE IF NOT EXISTS `ims_site_category` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属帐号', `nid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关联导航id', `name` VARCHAR(50) NOT NULL COMMENT '分类名称', `parentid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上级分类ID,0为第一级', `displayorder` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序', `enabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否开启', `icon` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '分类图标', `description` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '分类描述', `styleid` INT(10) UNSIGNED NOT NULL COMMENT '风格id', `templatefile` VARCHAR(100) NOT NULL DEFAULT '', `linkurl` VARCHAR(500) NOT NULL DEFAULT '', `ishomepage` tinyint(1) NOT NULL DEFAULT '0', `icontype` tinyint(1) UNSIGNED NOT NULL, `css` VARCHAR(500) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; -- -- 表的结构 `ims_site_multi` -- CREATE TABLE IF NOT EXISTS `ims_site_multi` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `title` VARCHAR(30) NOT NULL, `styleid` INT(10) UNSIGNED NOT NULL COMMENT '风格id', `site_info` text NOT NULL, `quickmenu` VARCHAR(2000) NOT NULL, `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='多微站' AUTO_INCREMENT=183 ; -- -- 表的结构 `ims_site_nav` -- CREATE TABLE IF NOT EXISTS `ims_site_nav` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `multiid` INT(10) UNSIGNED NOT NULL, `section` tinyint(4) NOT NULL DEFAULT '0', `module` VARCHAR(50) NOT NULL DEFAULT '', `displayorder` SMALLINT(5) UNSIGNED NOT NULL COMMENT '排序', `name` VARCHAR(50) NOT NULL COMMENT '导航名称', `description` VARCHAR(1000) NOT NULL DEFAULT '', `position` tinyint(4) NOT NULL DEFAULT '1' COMMENT '显示位置，1首页，2个人中心', `url` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '链接地址', `icon` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '图标', `css` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '扩展CSS', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '0为隐藏，1为显示', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `muiltiid` (`multiid`), KEY `multiid` (`multiid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=381 ; -- -- 表的结构 `ims_site_slide` -- CREATE TABLE IF NOT EXISTS `ims_site_slide` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `multiid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `title` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL DEFAULT '', `thumb` VARCHAR(255) NOT NULL DEFAULT '', `displayorder` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `multiid` (`multiid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; -- -- 表的结构 `ims_site_styles` -- CREATE TABLE IF NOT EXISTS `ims_site_styles` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `templateid` INT(10) UNSIGNED NOT NULL, `name` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=170 ; -- -- 表的结构 `ims_site_styles_vars` -- CREATE TABLE IF NOT EXISTS `ims_site_styles_vars` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `templateid` INT(10) UNSIGNED NOT NULL COMMENT '风格ID', `styleid` INT(10) UNSIGNED NOT NULL, `variable` VARCHAR(50) NOT NULL COMMENT '模板预设变量', `content` text NOT NULL COMMENT '变量值', `description` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 表的结构 `ims_site_templates` -- CREATE TABLE IF NOT EXISTS `ims_site_templates` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '标识', `version` VARCHAR(10) NOT NULL, `title` VARCHAR(30) NOT NULL COMMENT '名称', `description` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '描述', `author` VARCHAR(50) NOT NULL COMMENT '作者', `url` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '发布页面', `type` VARCHAR(20) NOT NULL DEFAULT '', `sections` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ; -- -- 表的结构 `ims_stat_keyword` -- CREATE TABLE IF NOT EXISTS `ims_stat_keyword` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '所属帐号ID', `rid` VARCHAR(10) NOT NULL COMMENT '规则ID', `kid` INT(10) UNSIGNED NOT NULL COMMENT '关键字ID', `hit` INT(10) UNSIGNED NOT NULL COMMENT '命中次数', `lastupdate` INT(10) UNSIGNED NOT NULL COMMENT '最后触发时间', `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `idx_createtime` (`createtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1028 ; -- -- 表的结构 `ims_stat_msg_history` -- CREATE TABLE IF NOT EXISTS `ims_stat_msg_history` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '所属帐号ID', `rid` INT(10) UNSIGNED NOT NULL COMMENT '命中规则ID', `kid` INT(10) UNSIGNED NOT NULL COMMENT '命中关键字ID', `from_user` VARCHAR(50) NOT NULL COMMENT '用户的唯一身份ID', `module` VARCHAR(50) NOT NULL COMMENT '命中模块', `message` VARCHAR(1000) NOT NULL COMMENT '用户发送的消息', `type` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '消息类型', `createtime` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `idx_createtime` (`createtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4221 ; -- -- 表的结构 `ims_stat_rule` -- CREATE TABLE IF NOT EXISTS `ims_stat_rule` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL COMMENT '所属帐号ID', `rid` INT(10) UNSIGNED NOT NULL COMMENT '规则ID', `hit` INT(10) UNSIGNED NOT NULL COMMENT '命中次数', `lastupdate` INT(10) UNSIGNED NOT NULL COMMENT '最后触发时间', `createtime` INT(10) UNSIGNED NOT NULL COMMENT '记录新建的日期', PRIMARY KEY (`id`), KEY `idx_createtime` (`createtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2572 ; -- -- 表的结构 `ims_uni_account` -- CREATE TABLE IF NOT EXISTS `ims_uni_account` ( `uniacid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `groupid` INT(10) NOT NULL DEFAULT '0', `name` VARCHAR(100) NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=444 ; -- -- 表的结构 `ims_uni_account_modules` -- CREATE TABLE IF NOT EXISTS `ims_uni_account_modules` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `module` VARCHAR(50) NOT NULL DEFAULT '', `enabled` tinyint(1) UNSIGNED NOT NULL, `settings` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_module` (`module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1674 ; -- -- 表的结构 `ims_uni_account_users` -- CREATE TABLE IF NOT EXISTS `ims_uni_account_users` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `role` VARCHAR(255) NOT NULL COMMENT 'manager管理员，operator操作者', PRIMARY KEY (`id`), KEY `idx_memberid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=442 ; -- -- 表的结构 `ims_uni_group` -- CREATE TABLE IF NOT EXISTS `ims_uni_group` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `modules` VARCHAR(5000) NOT NULL DEFAULT '', `templates` VARCHAR(5000) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- 表的结构 `ims_uni_settings` -- CREATE TABLE IF NOT EXISTS `ims_uni_settings` ( `uniacid` INT(10) UNSIGNED NOT NULL, `passport` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '会员中心注册参数', `oauth` VARCHAR(100) NOT NULL DEFAULT '', `jsauth_acid` INT(10) UNSIGNED NOT NULL, `uc` VARCHAR(500) NOT NULL COMMENT 'ucenter 通信参数', `notify` VARCHAR(2000) NOT NULL DEFAULT '', `creditnames` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '积分别名', `creditbehaviors` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '积分行为说明', `welcome` VARCHAR(60) NOT NULL DEFAULT '', `default` VARCHAR(60) NOT NULL DEFAULT '', `default_message` VARCHAR(1000) NOT NULL DEFAULT '', `shortcuts` VARCHAR(5000) NOT NULL DEFAULT '', `payment` VARCHAR(2000) NOT NULL DEFAULT '', `groupdata` VARCHAR(100) NOT NULL, `stat` VARCHAR(300) NOT NULL, `menuset` text NOT NULL, `default_site` INT(10) UNSIGNED DEFAULT '0', `sync` tinyint(3) UNSIGNED NOT NULL, PRIMARY KEY (`uniacid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 表的结构 `ims_users` -- CREATE TABLE IF NOT EXISTS `ims_users` ( `uid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户编号', `groupid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `username` VARCHAR(30) NOT NULL COMMENT '用户名', `password` VARCHAR(200) NOT NULL COMMENT '用户密码', `salt` VARCHAR(10) NOT NULL COMMENT '加密盐', `status` tinyint(4) NOT NULL DEFAULT '0', `joindate` INT(10) UNSIGNED NOT NULL DEFAULT '0', `joinip` VARCHAR(15) NOT NULL DEFAULT '', `lastvisit` INT(10) UNSIGNED NOT NULL DEFAULT '0', `lastip` VARCHAR(15) NOT NULL DEFAULT '', `remark` VARCHAR(500) NOT NULL DEFAULT '', PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表' AUTO_INCREMENT=74 ; -- -- 表的结构 `ims_users_group` -- CREATE TABLE IF NOT EXISTS `ims_users_group` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `package` VARCHAR(5000) NOT NULL DEFAULT '', `maxaccount` INT(10) UNSIGNED NOT NULL DEFAULT '0', `maxsubaccount` INT(10) UNSIGNED NOT NULL COMMENT '子公号最多添加数量，为0为不可以添加', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- 表的结构 `ims_users_permission` -- CREATE TABLE IF NOT EXISTS `ims_users_permission` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uniacid` INT(10) UNSIGNED NOT NULL, `uid` INT(10) UNSIGNED NOT NULL, `url` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ; -- -- 表的结构 `ims_users_profile` -- CREATE TABLE IF NOT EXISTS `ims_users_profile` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` INT(10) UNSIGNED NOT NULL, `createtime` INT(10) UNSIGNED NOT NULL COMMENT '加入时间', `realname` VARCHAR(10) NOT NULL DEFAULT '', `nickname` VARCHAR(20) NOT NULL DEFAULT '', `avatar` VARCHAR(100) NOT NULL DEFAULT '', `qq` VARCHAR(15) NOT NULL DEFAULT '', `mobile` VARCHAR(11) NOT NULL DEFAULT '', `fakeid` VARCHAR(30) NOT NULL, `vip` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `gender` tinyint(1) NOT NULL DEFAULT '0', `birthyear` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `birthmonth` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `birthday` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `constellation` VARCHAR(10) NOT NULL DEFAULT '', `zodiac` VARCHAR(5) NOT NULL DEFAULT '', `telephone` VARCHAR(15) NOT NULL DEFAULT '', `idcard` VARCHAR(30) NOT NULL DEFAULT '', `studentid` VARCHAR(50) NOT NULL DEFAULT '', `grade` VARCHAR(10) NOT NULL DEFAULT '', `address` VARCHAR(255) NOT NULL DEFAULT '', `zipcode` VARCHAR(10) NOT NULL DEFAULT '', `nationality` VARCHAR(30) NOT NULL DEFAULT '', `resideprovince` VARCHAR(30) NOT NULL DEFAULT '', `residecity` VARCHAR(30) NOT NULL DEFAULT '', `residedist` VARCHAR(30) NOT NULL DEFAULT '', `graduateschool` VARCHAR(50) NOT NULL DEFAULT '', `company` VARCHAR(50) NOT NULL DEFAULT '', `education` VARCHAR(10) NOT NULL DEFAULT '', `occupation` VARCHAR(30) NOT NULL DEFAULT '', `position` VARCHAR(30) NOT NULL DEFAULT '', `revenue` VARCHAR(10) NOT NULL DEFAULT '', `affectivestatus` VARCHAR(30) NOT NULL DEFAULT '', `lookingfor` VARCHAR(255) NOT NULL DEFAULT '', `bloodtype` VARCHAR(5) NOT NULL DEFAULT '', `height` VARCHAR(5) NOT NULL DEFAULT '', `weight` VARCHAR(5) NOT NULL DEFAULT '', `alipay` VARCHAR(30) NOT NULL DEFAULT '', `msn` VARCHAR(30) NOT NULL DEFAULT '', `email` VARCHAR(50) NOT NULL DEFAULT '', `taobao` VARCHAR(30) NOT NULL DEFAULT '', `site` VARCHAR(30) NOT NULL DEFAULT '', `bio` text NOT NULL COMMENT '自我介绍', `interest` text NOT NULL COMMENT '兴趣爱好', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; -- -- 表的结构 `ims_video_reply` -- CREATE TABLE IF NOT EXISTS `ims_video_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL COMMENT '规则ID', `title` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '标题', `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '介绍', `mediaid` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '视频id', `createtime` INT(10) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=157 ; -- -- 表的结构 `ims_voice_reply` -- CREATE TABLE IF NOT EXISTS `ims_voice_reply` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `rid` INT(10) UNSIGNED NOT NULL COMMENT '规则ID', `title` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '标题', `mediaid` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '语音id', `createtime` INT(10) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
