-- 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 ;