/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50623
 Source Host           : localhost
 Source Database       : bmobcms

 Target Server Type    : MySQL
 Target Server Version : 50623
 File Encoding         : utf-8

 Date: 07/15/2015 16:16:00 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_action`
-- ----------------------------
DROP TABLE IF EXISTS `t_action`;
CREATE TABLE `t_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '行为唯一标识',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '行为说明',
  `remark` char(140) NOT NULL DEFAULT '' COMMENT '行为描述',
  `rule` text NOT NULL COMMENT '行为规则',
  `log` text NOT NULL COMMENT '日志规则',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统行为表';

-- ----------------------------
--  Records of `t_action`
-- ----------------------------
BEGIN;
INSERT INTO `t_action` VALUES ('1', 'user_login', '用户登录', '积分+10，每天一次', 'table:member|field:score|condition:uid={$self} AND status>-1|rule:score+10|cycle:24|max:1;', '[user|get_nickname]在[time|time_format]登录了后台', '1', '1', '1387181220'), ('2', 'add_article', '发布文章', '积分+5，每天上限5次', 'table:member|field:score|condition:uid={$self}|rule:score+5|cycle:24|max:5', '', '2', '0', '1380173180'), ('3', 'review', '评论', '评论积分+1，无限制', 'table:member|field:score|condition:uid={$self}|rule:score+1', '', '2', '1', '1383285646'), ('4', 'add_document', '发表文档', '积分+10，每天上限5次', 'table:member|field:score|condition:uid={$self}|rule:score+10|cycle:24|max:5', '[user|get_nickname]在[time|time_format]发表了一篇文章。\r\n表[model]，记录编号[record]。', '2', '0', '1386139726'), ('5', 'add_document_topic', '发表讨论', '积分+5，每天上限10次', 'table:member|field:score|condition:uid={$self}|rule:score+5|cycle:24|max:10', '', '2', '0', '1383285551'), ('6', 'update_config', '更新配置', '新增或修改或删除配置', '', '', '1', '1', '1383294988'), ('7', 'update_model', '更新模型', '新增或修改模型', '', '', '1', '1', '1383295057'), ('8', 'update_attribute', '更新属性', '新增或更新或删除属性', '', '', '1', '1', '1383295963'), ('9', 'update_channel', '更新导航', '新增或修改或删除导航', '', '', '1', '1', '1383296301'), ('10', 'update_menu', '更新菜单', '新增或修改或删除菜单', '', '', '1', '1', '1383296392'), ('11', 'update_category', '更新分类', '新增或修改或删除分类', '', '', '1', '1', '1383296765');
COMMIT;

-- ----------------------------
--  Table structure for `t_action_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_action_log`;
CREATE TABLE `t_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `action_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',
  `record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  PRIMARY KEY (`id`),
  KEY `action_ip_ix` (`action_ip`),
  KEY `action_id_ix` (`action_id`),
  KEY `user_id_ix` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=158 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

-- ----------------------------
--  Table structure for `t_addons`
-- ----------------------------
DROP TABLE IF EXISTS `t_addons`;
CREATE TABLE `t_addons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL COMMENT '插件名或标识',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '中文名',
  `description` text COMMENT '插件描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `config` text COMMENT '配置',
  `author` varchar(40) DEFAULT '' COMMENT '作者',
  `version` varchar(20) DEFAULT '' COMMENT '版本号',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `has_adminlist` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台列表',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
--  Records of `t_addons`
-- ----------------------------
BEGIN;
INSERT INTO `t_addons` VALUES ('15', 'EditorForAdmin', '后台编辑器', '用于增强整站长文本的输入和显示', '1', '{\"editor_type\":\"2\",\"editor_wysiwyg\":\"1\",\"editor_height\":\"500px\",\"editor_resize_type\":\"1\"}', 'thinkphp', '0.1', '1383126253', '0'), ('2', 'SiteStat', '站点统计信息', '统计站点的基础信息', '1', '{\"title\":\"\\u7cfb\\u7edf\\u4fe1\\u606f\",\"width\":\"1\",\"display\":\"1\",\"status\":\"0\"}', 'thinkphp', '0.1', '1379512015', '0'), ('3', 'DevTeam', '开发团队信息', '开发团队成员信息', '1', '{\"title\":\"jingrui\\u5f00\\u53d1\\u56e2\\u961f\",\"width\":\"2\",\"display\":\"1\"}', 'thinkphp', '0.1', '1379512022', '0'), ('4', 'SystemInfo', '系统环境信息', '用于显示一些服务器的信息', '1', '{\"title\":\"\\u7cfb\\u7edf\\u4fe1\\u606f\",\"width\":\"2\",\"display\":\"1\"}', 'thinkphp', '0.1', '1379512036', '0'), ('5', 'Editor', '前台编辑器', '用于增强整站长文本的输入和显示', '1', '{\"editor_type\":\"2\",\"editor_wysiwyg\":\"1\",\"editor_height\":\"300px\",\"editor_resize_type\":\"1\"}', 'thinkphp', '0.1', '1379830910', '0'), ('6', 'Attachment', '附件', '用于文档模型上传附件', '1', 'null', 'thinkphp', '0.1', '1379842319', '1'), ('9', 'SocialComment', '通用社交化评论', '集成了各种社交化评论插件，轻松集成到系统中。', '1', '{\"comment_type\":\"1\",\"comment_uid_youyan\":\"\",\"comment_short_name_duoshuo\":\"\",\"comment_data_list_duoshuo\":\"\"}', 'thinkphp', '0.1', '1380273962', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_appmodels`
-- ----------------------------
DROP TABLE IF EXISTS `t_appmodels`;
CREATE TABLE `t_appmodels` (
  `app_id` int(10) unsigned NOT NULL COMMENT 'App ID',
  `model_id` int(10) unsigned NOT NULL COMMENT '模型ID',
  PRIMARY KEY (`app_id`,`model_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_appmodels`
-- ----------------------------
BEGIN;
INSERT INTO `t_appmodels` VALUES ('1', '4'), ('1', '9'), ('2', '4'), ('2', '9');
COMMIT;

-- ----------------------------
--  Table structure for `t_apps`
-- ----------------------------
DROP TABLE IF EXISTS `t_apps`;
CREATE TABLE `t_apps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `desc` varchar(255) NOT NULL COMMENT '描述',
  `app_id` varchar(255) NOT NULL COMMENT '应用ID',
  `rest_api_key` varchar(255) NOT NULL COMMENT 'rest请求key',
  `master_key` varchar(255) NOT NULL COMMENT 'Master Key',
  `access_key` varchar(255) NOT NULL COMMENT 'Access Key',
  `secret_key` varchar(255) NOT NULL COMMENT 'Secret Key',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_apps`
-- ----------------------------
BEGIN;
INSERT INTO `t_apps` VALUES ('1', 'JRTools', '晶睿互动测试工具', '85898d6e01ff1bc35a496cb05917ed04', 'a76469712789001f540b642f1c9cf8a4', '154aaa5573f8418f1e92585876ad6162', '1ecf34ff60b3e8d52e3359504603ca1e', 'e00cc42ec29735a7', '1'), ('2', 'JRDemo1', 'demo1', 'fc0a8741656864dadd7b37db2218c804', '83ab994a99ad6b59e9e25e637cd08451', 'e25805f6bef88e733663e8a984deb182', 'f4ea3b0f7b7f54924ccb82798f61c6a8', '27c2936a578d0270', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `t_attachment`;
CREATE TABLE `t_attachment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `title` char(30) NOT NULL DEFAULT '' COMMENT '附件显示名',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '附件类型',
  `source` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资源ID',
  `record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联记录ID',
  `download` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '附件大小',
  `dir` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '上级目录ID',
  `sort` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `idx_record_status` (`record_id`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='附件表';

-- ----------------------------
--  Table structure for `t_attribute`
-- ----------------------------
DROP TABLE IF EXISTS `t_attribute`;
CREATE TABLE `t_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '字段名',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '字段注释',
  `field` varchar(100) NOT NULL DEFAULT '' COMMENT '字段定义',
  `type` varchar(20) NOT NULL DEFAULT '' COMMENT '数据类型',
  `value` varchar(100) NOT NULL DEFAULT '' COMMENT '字段默认值',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '备注',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '参数',
  `model_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模型id',
  `is_must` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否必填',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `validate_rule` varchar(255) NOT NULL,
  `validate_time` tinyint(1) unsigned NOT NULL,
  `error_info` varchar(100) NOT NULL,
  `validate_type` varchar(25) NOT NULL,
  `auto_rule` varchar(100) NOT NULL,
  `auto_time` tinyint(1) unsigned NOT NULL,
  `auto_type` varchar(25) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `model_id` (`model_id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COMMENT='模型属性表';

-- ----------------------------
--  Records of `t_attribute`
-- ----------------------------
BEGIN;
INSERT INTO `t_attribute` VALUES ('1', 'uid', '用户ID', 'int(10) unsigned NOT NULL ', 'num', '0', '', '0', '', '1', '0', '1', '1384508362', '1383891233', '', '0', '', '', '', '0', ''), ('2', 'name', '标识', 'char(40) NOT NULL ', 'string', '', '同一根节点下标识不重复', '1', '', '1', '0', '1', '1383894743', '1383891233', '', '0', '', '', '', '0', ''), ('3', 'title', '标题', 'char(80) NOT NULL ', 'string', '', '文档标题', '1', '', '1', '0', '1', '1383894778', '1383891233', '', '0', '', '', '', '0', ''), ('4', 'category_id', '所属分类', 'int(10) unsigned NOT NULL ', 'string', '', '', '0', '', '1', '0', '1', '1384508336', '1383891233', '', '0', '', '', '', '0', ''), ('5', 'description', '描述', 'char(140) NOT NULL ', 'textarea', '', '', '1', '', '1', '0', '1', '1383894927', '1383891233', '', '0', '', '', '', '0', ''), ('6', 'root', '根节点', 'int(10) unsigned NOT NULL ', 'num', '0', '该文档的顶级文档编号', '0', '', '1', '0', '1', '1384508323', '1383891233', '', '0', '', '', '', '0', ''), ('7', 'pid', '所属ID', 'int(10) unsigned NOT NULL ', 'num', '0', '父文档编号', '0', '', '1', '0', '1', '1384508543', '1383891233', '', '0', '', '', '', '0', ''), ('8', 'model_id', '内容模型ID', 'tinyint(3) unsigned NOT NULL ', 'num', '0', '该文档所对应的模型', '0', '', '1', '0', '1', '1384508350', '1383891233', '', '0', '', '', '', '0', ''), ('9', 'type', '内容类型', 'tinyint(3) unsigned NOT NULL ', 'select', '2', '', '1', '1:目录\r\n2:主题\r\n3:段落', '1', '0', '1', '1384511157', '1383891233', '', '0', '', '', '', '0', ''), ('10', 'position', '推荐位', 'smallint(5) unsigned NOT NULL ', 'checkbox', '0', '多个推荐则将其推荐值相加', '1', '1:列表推荐\r\n2:频道页推荐\r\n4:首页推荐', '1', '0', '1', '1383895640', '1383891233', '', '0', '', '', '', '0', ''), ('11', 'link_id', '外链', 'int(10) unsigned NOT NULL ', 'num', '0', '0-非外链，大于0-外链ID,需要函数进行链接与编号的转换', '1', '', '1', '0', '1', '1383895757', '1383891233', '', '0', '', '', '', '0', ''), ('12', 'cover_id', '封面', 'int(10) unsigned NOT NULL ', 'picture', '0', '0-无封面，大于0-封面图片ID，需要函数处理', '1', '', '1', '0', '1', '1384147827', '1383891233', '', '0', '', '', '', '0', ''), ('13', 'display', '可见性', 'tinyint(3) unsigned NOT NULL ', 'radio', '1', '', '1', '0:不可见\r\n1:所有人可见', '1', '0', '1', '1386662271', '1383891233', '', '0', '', 'regex', '', '0', 'function'), ('14', 'deadline', '截至时间', 'int(10) unsigned NOT NULL ', 'datetime', '0', '0-永久有效', '1', '', '1', '0', '1', '1387163248', '1383891233', '', '0', '', 'regex', '', '0', 'function'), ('15', 'attach', '附件数量', 'tinyint(3) unsigned NOT NULL ', 'num', '0', '', '0', '', '1', '0', '1', '1387260355', '1383891233', '', '0', '', 'regex', '', '0', 'function'), ('16', 'view', '浏览量', 'int(10) unsigned NOT NULL ', 'num', '0', '', '1', '', '1', '0', '1', '1383895835', '1383891233', '', '0', '', '', '', '0', ''), ('17', 'comment', '评论数', 'int(10) unsigned NOT NULL ', 'num', '0', '', '1', '', '1', '0', '1', '1383895846', '1383891233', '', '0', '', '', '', '0', ''), ('18', 'extend', '扩展统计字段', 'int(10) unsigned NOT NULL ', 'num', '0', '根据需求自行使用', '0', '', '1', '0', '1', '1384508264', '1383891233', '', '0', '', '', '', '0', ''), ('19', 'level', '优先级', 'int(10) unsigned NOT NULL ', 'num', '0', '越高排序越靠前', '1', '', '1', '0', '1', '1383895894', '1383891233', '', '0', '', '', '', '0', ''), ('20', 'create_time', '创建时间', 'int(10) unsigned NOT NULL ', 'datetime', '0', '', '1', '', '1', '0', '1', '1383895903', '1383891233', '', '0', '', '', '', '0', ''), ('21', 'update_time', '更新时间', 'int(10) unsigned NOT NULL ', 'datetime', '0', '', '0', '', '1', '0', '1', '1384508277', '1383891233', '', '0', '', '', '', '0', ''), ('22', 'status', '数据状态', 'tinyint(4) NOT NULL ', 'radio', '0', '', '0', '-1:删除\r\n0:禁用\r\n1:正常\r\n2:待审核\r\n3:草稿', '1', '0', '1', '1384508496', '1383891233', '', '0', '', '', '', '0', ''), ('23', 'parse', '内容解析类型', 'tinyint(3) unsigned NOT NULL ', 'select', '0', '', '0', '0:html\r\n1:ubb\r\n2:markdown', '2', '0', '1', '1384511049', '1383891243', '', '0', '', '', '', '0', ''), ('24', 'content', '文章内容', 'text NOT NULL ', 'editor', '', '', '1', '', '2', '0', '1', '1383896225', '1383891243', '', '0', '', '', '', '0', ''), ('25', 'template', '详情页显示模板', 'varchar(100) NOT NULL ', 'string', '', '参照display方法参数的定义', '1', '', '2', '0', '1', '1383896190', '1383891243', '', '0', '', '', '', '0', ''), ('26', 'bookmark', '收藏数', 'int(10) unsigned NOT NULL ', 'num', '0', '', '1', '', '2', '0', '1', '1383896103', '1383891243', '', '0', '', '', '', '0', ''), ('27', 'parse', '内容解析类型', 'tinyint(3) unsigned NOT NULL ', 'select', '0', '', '0', '0:html\r\n1:ubb\r\n2:markdown', '3', '0', '1', '1387260461', '1383891252', '', '0', '', 'regex', '', '0', 'function'), ('28', 'content', '下载详细描述', 'text NOT NULL ', 'editor', '', '', '1', '', '3', '0', '1', '1383896438', '1383891252', '', '0', '', '', '', '0', ''), ('29', 'template', '详情页显示模板', 'varchar(100) NOT NULL ', 'string', '', '', '1', '', '3', '0', '1', '1383896429', '1383891252', '', '0', '', '', '', '0', ''), ('30', 'file_id', '文件ID', 'int(10) unsigned NOT NULL ', 'file', '0', '需要函数处理', '1', '', '3', '0', '1', '1383896415', '1383891252', '', '0', '', '', '', '0', ''), ('31', 'download', '下载次数', 'int(10) unsigned NOT NULL ', 'num', '0', '', '1', '', '3', '0', '1', '1383896380', '1383891252', '', '0', '', '', '', '0', ''), ('32', 'size', '文件大小', 'bigint(20) unsigned NOT NULL ', 'num', '0', '单位bit', '1', '', '3', '0', '1', '1383896371', '1383891252', '', '0', '', '', '', '0', ''), ('57', 'myString', '字符串', 'swing.shi', 'String', '', '', '1', '', '9', '0', '1', '1436944411', '1436943280', '', '3', '', 'regex', '', '3', 'function'), ('34', 'username', '用户名', 'String', 'String', '', '', '1', '', '4', '0', '1', '1436941838', '1436775538', '', '3', '', 'regex', '', '3', 'function'), ('35', 'password', '密码', 'String', 'String', '', '', '1', '', '4', '0', '1', '1436941831', '1436775552', '', '3', '', 'regex', '', '3', 'function'), ('56', 'myBoolean', '布尔', 'true', 'Boolean', '', '', '1', '', '9', '0', '1', '1436944398', '1436943233', '', '3', '', 'regex', '', '3', 'function'), ('55', 'myNumber', '数字', '10086', 'Number', '', '', '1', '', '9', '0', '1', '1436944374', '1436943212', '', '3', '', 'regex', '', '3', 'function'), ('38', 'name', '名称', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788194', '1436788194', '', '3', '', 'regex', '', '3', 'function'), ('39', 'desc', '描述', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788207', '1436788207', '', '3', '', 'regex', '', '3', 'function'), ('40', 'app_id', '应用ID', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788229', '1436788229', '', '3', '', 'regex', '', '3', 'function'), ('41', 'rest_api_key', 'rest请求key', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788252', '1436788252', '', '3', '', 'regex', '', '3', 'function'), ('42', 'master_key', 'Master Key', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788268', '1436788268', '', '3', '', 'regex', '', '3', 'function'), ('43', 'access_key', 'Access Key', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788285', '1436788285', '', '3', '', 'regex', '', '3', 'function'), ('44', 'secret_key', 'Secret Key', 'varchar(255) NOT NULL', 'string', '', '', '1', '', '7', '0', '1', '1436788302', '1436788302', '', '3', '', 'regex', '', '3', 'function'), ('45', 'status', '状态', 'tinyint(4) NOT NULL', 'radio', '1', '', '1', '-1:删除\r\n0:禁用\r\n1:正常\r\n2:待审核\r\n3:草稿', '7', '0', '1', '1436788890', '1436788890', '', '3', '', 'regex', '', '3', 'function'), ('46', 'uid', '用户ID', 'int(10) UNSIGNED NOT NULL', 'num', '', '', '1', '', '5', '0', '1', '1436789496', '1436789496', '', '3', '', 'regex', '', '3', 'function'), ('47', 'app_id', 'App Id', 'int(10) UNSIGNED NOT NULL', 'num', '', '', '1', '', '5', '0', '1', '1436789514', '1436789514', '', '3', '', 'regex', '', '3', 'function'), ('48', 'app_id', 'App ID', 'int(10) UNSIGNED NOT NULL', 'num', '', '', '1', '', '6', '0', '1', '1436789716', '1436789716', '', '3', '', 'regex', '', '3', 'function'), ('49', 'model_id', '模型ID', 'int(10) UNSIGNED NOT NULL', 'num', '', '', '1', '', '6', '0', '1', '1436789745', '1436789745', '', '3', '', 'regex', '', '3', 'function'), ('58', 'myDate', '时间', '{\"__type\": \"Date\",\"iso\": \"2011-08-21 18:02:52\"}', 'Date', '', '', '1', '', '9', '0', '1', '1436946566', '1436943294', '', '3', '', 'regex', '', '3', 'function'), ('59', 'myFile', '文件', '{\"__type\": \"File\",\"group\": \"group1\",\"filename\": \"1.xml\",\"url\": \"M00/01/14/sd2lkds0.xml\"}', 'File', '', '', '1', '', '9', '0', '1', '1436946575', '1436943307', '', '3', '', 'regex', '', '3', 'function'), ('60', 'myGeopoint', '位置', '{\"__type\": \"GeoPoint\",\"latitude\": 50.934755,\"longitude\": 24.52065}', 'Geopoint', '', '', '1', '', '9', '0', '1', '1436946585', '1436943324', '', '3', '', 'regex', '', '3', 'function'), ('61', 'myArray', '数组', '{\"__op\":\"Add\",\"objects\":[\"person1\",\"person2\"]}', 'Array', '', '', '1', '', '9', '0', '1', '1436946604', '1436943343', '', '3', '', 'regex', '', '3', 'function'), ('62', 'myObject', '对象', '{\"__type\": \"Object\",\"className\": \"Post\",\"objectId\": \"51e3a359e4b015ead4d95ddc\"}', 'Object', '', '', '1', '', '9', '0', '1', '1436946685', '1436943361', '', '3', '', 'regex', '', '3', 'function'), ('63', 'myPointer', '指针', '{\"__type\": \"Pointer\",\"className\": \"_User\",\"objectId\": \"DdUOIIIW\"}', 'Pointer', '', '', '1', '', '9', '0', '1', '1436947321', '1436943377', '', '3', '', 'regex', '', '3', 'function'), ('64', 'myRelation', '引用', '{\"__type\": \"Relation\",\"className\": \"GameScore\"}', 'Relation', '', '', '1', '', '9', '0', '1', '1436946702', '1436943397', '', '3', '', 'regex', '', '3', 'function');
COMMIT;

-- ----------------------------
--  Table structure for `t_auth_extend`
-- ----------------------------
DROP TABLE IF EXISTS `t_auth_extend`;
CREATE TABLE `t_auth_extend` (
  `group_id` mediumint(10) unsigned NOT NULL COMMENT '用户id',
  `extend_id` mediumint(8) unsigned NOT NULL COMMENT '扩展表中数据的id',
  `type` tinyint(1) unsigned NOT NULL COMMENT '扩展类型标识 1:栏目分类权限;2:模型权限',
  UNIQUE KEY `group_extend_type` (`group_id`,`extend_id`,`type`),
  KEY `uid` (`group_id`),
  KEY `group_id` (`extend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户组与分类的对应关系表';

-- ----------------------------
--  Records of `t_auth_extend`
-- ----------------------------
BEGIN;
INSERT INTO `t_auth_extend` VALUES ('1', '1', '1'), ('1', '1', '2'), ('1', '2', '1'), ('1', '2', '2'), ('1', '3', '1'), ('1', '3', '2'), ('1', '4', '1'), ('1', '37', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `t_auth_group`;
CREATE TABLE `t_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL COMMENT '组类型',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_auth_group`
-- ----------------------------
BEGIN;
INSERT INTO `t_auth_group` VALUES ('1', 'admin', '1', '默认用户组', '', '1', '1,2,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,79,80,81,82,83,84,86,87,88,89,90,91,92,93,94,95,96,97,100,102,103,105,106'), ('2', 'admin', '1', '测试用户', '测试用户', '1', '1,2,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,79,80,82,83,84,88,89,90,91,92,93,96,97,100,102,103,195');
COMMIT;

-- ----------------------------
--  Table structure for `t_auth_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `t_auth_group_access`;
CREATE TABLE `t_auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `t_auth_rule`;
CREATE TABLE `t_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_auth_rule`
-- ----------------------------
BEGIN;
INSERT INTO `t_auth_rule` VALUES ('1', 'admin', '2', 'Admin/Index/index', '首页', '1', ''), ('2', 'admin', '2', 'Admin/Article/mydocument', '内容', '1', ''), ('3', 'admin', '2', 'Admin/User/index', '用户', '1', ''), ('4', 'admin', '2', 'Admin/Addons/index', '扩展', '1', ''), ('5', 'admin', '2', 'Admin/Config/group', '系统', '1', ''), ('7', 'admin', '1', 'Admin/article/add', '新增', '1', ''), ('8', 'admin', '1', 'Admin/article/edit', '编辑', '1', ''), ('9', 'admin', '1', 'Admin/article/setStatus', '改变状态', '1', ''), ('10', 'admin', '1', 'Admin/article/update', '保存', '1', ''), ('11', 'admin', '1', 'Admin/article/autoSave', '保存草稿', '1', ''), ('12', 'admin', '1', 'Admin/article/move', '移动', '1', ''), ('13', 'admin', '1', 'Admin/article/copy', '复制', '1', ''), ('14', 'admin', '1', 'Admin/article/paste', '粘贴', '1', ''), ('15', 'admin', '1', 'Admin/article/permit', '还原', '1', ''), ('16', 'admin', '1', 'Admin/article/clear', '清空', '1', ''), ('17', 'admin', '1', 'Admin/article/index', '文档列表', '1', ''), ('18', 'admin', '1', 'Admin/article/recycle', '回收站', '1', ''), ('19', 'admin', '1', 'Admin/User/addaction', '新增用户行为', '1', ''), ('20', 'admin', '1', 'Admin/User/editaction', '编辑用户行为', '1', ''), ('21', 'admin', '1', 'Admin/User/saveAction', '保存用户行为', '1', ''), ('22', 'admin', '1', 'Admin/User/setStatus', '变更行为状态', '1', ''), ('23', 'admin', '1', 'Admin/User/changeStatus?method=forbidUser', '禁用会员', '1', ''), ('24', 'admin', '1', 'Admin/User/changeStatus?method=resumeUser', '启用会员', '1', ''), ('25', 'admin', '1', 'Admin/User/changeStatus?method=deleteUser', '删除会员', '1', ''), ('26', 'admin', '1', 'Admin/User/index', '用户信息', '1', ''), ('27', 'admin', '1', 'Admin/User/action', '用户行为', '1', ''), ('28', 'admin', '1', 'Admin/AuthManager/changeStatus?method=deleteGroup', '删除', '1', ''), ('29', 'admin', '1', 'Admin/AuthManager/changeStatus?method=forbidGroup', '禁用', '1', ''), ('30', 'admin', '1', 'Admin/AuthManager/changeStatus?method=resumeGroup', '恢复', '1', ''), ('31', 'admin', '1', 'Admin/AuthManager/createGroup', '新增', '1', ''), ('32', 'admin', '1', 'Admin/AuthManager/editGroup', '编辑', '1', ''), ('33', 'admin', '1', 'Admin/AuthManager/writeGroup', '保存用户组', '1', ''), ('34', 'admin', '1', 'Admin/AuthManager/group', '授权', '1', ''), ('35', 'admin', '1', 'Admin/AuthManager/access', '访问授权', '1', ''), ('36', 'admin', '1', 'Admin/AuthManager/user', '成员授权', '1', ''), ('37', 'admin', '1', 'Admin/AuthManager/removeFromGroup', '解除授权', '1', ''), ('38', 'admin', '1', 'Admin/AuthManager/addToGroup', '保存成员授权', '1', ''), ('39', 'admin', '1', 'Admin/AuthManager/category', '分类授权', '1', ''), ('40', 'admin', '1', 'Admin/AuthManager/addToCategory', '保存分类授权', '1', ''), ('41', 'admin', '1', 'Admin/AuthManager/index', '权限管理', '1', ''), ('42', 'admin', '1', 'Admin/Addons/create', '创建', '1', ''), ('43', 'admin', '1', 'Admin/Addons/checkForm', '检测创建', '1', ''), ('44', 'admin', '1', 'Admin/Addons/preview', '预览', '1', ''), ('45', 'admin', '1', 'Admin/Addons/build', '快速生成插件', '1', ''), ('46', 'admin', '1', 'Admin/Addons/config', '设置', '1', ''), ('47', 'admin', '1', 'Admin/Addons/disable', '禁用', '1', ''), ('48', 'admin', '1', 'Admin/Addons/enable', '启用', '1', ''), ('49', 'admin', '1', 'Admin/Addons/install', '安装', '1', ''), ('50', 'admin', '1', 'Admin/Addons/uninstall', '卸载', '1', ''), ('51', 'admin', '1', 'Admin/Addons/saveconfig', '更新配置', '1', ''), ('52', 'admin', '1', 'Admin/Addons/adminList', '插件后台列表', '1', ''), ('53', 'admin', '1', 'Admin/Addons/execute', '上传图片', '1', ''), ('54', 'admin', '1', 'Admin/Addons/index', '插件管理', '1', ''), ('55', 'admin', '1', 'Admin/Addons/hooks', '钩子管理', '1', ''), ('56', 'admin', '1', 'Admin/model/add', '新增', '1', ''), ('57', 'admin', '1', 'Admin/model/edit', '编辑', '1', ''), ('58', 'admin', '1', 'Admin/model/setStatus', '改变状态', '1', ''), ('59', 'admin', '1', 'Admin/model/update', '保存数据', '1', ''), ('60', 'admin', '1', 'Admin/Model/index', '模型管理', '1', ''), ('61', 'admin', '1', 'Admin/Config/edit', '编辑', '1', ''), ('62', 'admin', '1', 'Admin/Config/del', '删除', '1', ''), ('63', 'admin', '1', 'Admin/Config/add', '新增', '1', ''), ('64', 'admin', '1', 'Admin/Config/save', '保存', '1', ''), ('65', 'admin', '1', 'Admin/Config/group', '网站设置', '1', ''), ('66', 'admin', '1', 'Admin/Config/index', '配置管理', '1', ''), ('67', 'admin', '1', 'Admin/Channel/add', '新增', '1', ''), ('68', 'admin', '1', 'Admin/Channel/edit', '编辑', '1', ''), ('69', 'admin', '1', 'Admin/Channel/del', '删除', '1', ''), ('70', 'admin', '1', 'Admin/Channel/index', '导航管理', '1', ''), ('71', 'admin', '1', 'Admin/Category/edit', '编辑', '1', ''), ('72', 'admin', '1', 'Admin/Category/add', '新增', '1', ''), ('73', 'admin', '1', 'Admin/Category/remove', '删除', '1', ''), ('74', 'admin', '1', 'Admin/Category/index', '分类管理', '1', ''), ('75', 'admin', '1', 'Admin/file/upload', '上传控件', '-1', ''), ('76', 'admin', '1', 'Admin/file/uploadPicture', '上传图片', '-1', ''), ('77', 'admin', '1', 'Admin/file/download', '下载', '-1', ''), ('94', 'admin', '1', 'Admin/AuthManager/modelauth', '模型授权', '1', ''), ('79', 'admin', '1', 'Admin/article/batchOperate', '导入', '1', ''), ('80', 'admin', '1', 'Admin/Database/index?type=export', '备份数据库', '1', ''), ('81', 'admin', '1', 'Admin/Database/index?type=import', '还原数据库', '1', ''), ('82', 'admin', '1', 'Admin/Database/export', '备份', '1', ''), ('83', 'admin', '1', 'Admin/Database/optimize', '优化表', '1', ''), ('84', 'admin', '1', 'Admin/Database/repair', '修复表', '1', ''), ('86', 'admin', '1', 'Admin/Database/import', '恢复', '1', ''), ('87', 'admin', '1', 'Admin/Database/del', '删除', '1', ''), ('88', 'admin', '1', 'Admin/User/add', '新增用户', '1', ''), ('89', 'admin', '1', 'Admin/Attribute/index', '属性管理', '1', ''), ('90', 'admin', '1', 'Admin/Attribute/add', '新增', '1', ''), ('91', 'admin', '1', 'Admin/Attribute/edit', '编辑', '1', ''), ('92', 'admin', '1', 'Admin/Attribute/setStatus', '改变状态', '1', ''), ('93', 'admin', '1', 'Admin/Attribute/update', '保存数据', '1', ''), ('95', 'admin', '1', 'Admin/AuthManager/addToModel', '保存模型授权', '1', ''), ('96', 'admin', '1', 'Admin/Category/move', '移动', '-1', ''), ('97', 'admin', '1', 'Admin/Category/merge', '合并', '-1', ''), ('98', 'admin', '1', 'Admin/Config/menu', '后台菜单管理', '-1', ''), ('99', 'admin', '1', 'Admin/Article/mydocument', '内容', '-1', ''), ('100', 'admin', '1', 'Admin/Menu/index', '菜单管理', '1', ''), ('101', 'admin', '1', 'Admin/other', '其他', '-1', ''), ('102', 'admin', '1', 'Admin/Menu/add', '新增', '1', ''), ('103', 'admin', '1', 'Admin/Menu/edit', '编辑', '1', ''), ('104', 'admin', '1', 'Admin/Think/lists?model=article', '文章管理', '-1', ''), ('105', 'admin', '1', 'Admin/Think/lists?model=download', '下载管理', '1', ''), ('106', 'admin', '1', 'Admin/Think/lists?model=config', '配置管理', '1', ''), ('107', 'admin', '1', 'Admin/Action/actionlog', '行为日志', '1', ''), ('108', 'admin', '1', 'Admin/User/updatePassword', '修改密码', '1', ''), ('109', 'admin', '1', 'Admin/User/updateNickname', '修改昵称', '1', ''), ('110', 'admin', '1', 'Admin/action/edit', '查看行为日志', '1', ''), ('205', 'admin', '1', 'Admin/think/add', '新增数据', '1', ''), ('111', 'admin', '2', 'Admin/article/index', '文档列表', '-1', ''), ('112', 'admin', '2', 'Admin/article/add', '新增', '-1', ''), ('113', 'admin', '2', 'Admin/article/edit', '编辑', '-1', ''), ('114', 'admin', '2', 'Admin/article/setStatus', '改变状态', '-1', ''), ('115', 'admin', '2', 'Admin/article/update', '保存', '-1', ''), ('116', 'admin', '2', 'Admin/article/autoSave', '保存草稿', '-1', ''), ('117', 'admin', '2', 'Admin/article/move', '移动', '-1', ''), ('118', 'admin', '2', 'Admin/article/copy', '复制', '-1', ''), ('119', 'admin', '2', 'Admin/article/paste', '粘贴', '-1', ''), ('120', 'admin', '2', 'Admin/article/batchOperate', '导入', '-1', ''), ('121', 'admin', '2', 'Admin/article/recycle', '回收站', '-1', ''), ('122', 'admin', '2', 'Admin/article/permit', '还原', '-1', ''), ('123', 'admin', '2', 'Admin/article/clear', '清空', '-1', ''), ('124', 'admin', '2', 'Admin/User/add', '新增用户', '-1', ''), ('125', 'admin', '2', 'Admin/User/action', '用户行为', '-1', ''), ('126', 'admin', '2', 'Admin/User/addAction', '新增用户行为', '-1', ''), ('127', 'admin', '2', 'Admin/User/editAction', '编辑用户行为', '-1', ''), ('128', 'admin', '2', 'Admin/User/saveAction', '保存用户行为', '-1', ''), ('129', 'admin', '2', 'Admin/User/setStatus', '变更行为状态', '-1', ''), ('130', 'admin', '2', 'Admin/User/changeStatus?method=forbidUser', '禁用会员', '-1', ''), ('131', 'admin', '2', 'Admin/User/changeStatus?method=resumeUser', '启用会员', '-1', ''), ('132', 'admin', '2', 'Admin/User/changeStatus?method=deleteUser', '删除会员', '-1', ''), ('133', 'admin', '2', 'Admin/AuthManager/index', '权限管理', '-1', ''), ('134', 'admin', '2', 'Admin/AuthManager/changeStatus?method=deleteGroup', '删除', '-1', ''), ('135', 'admin', '2', 'Admin/AuthManager/changeStatus?method=forbidGroup', '禁用', '-1', ''), ('136', 'admin', '2', 'Admin/AuthManager/changeStatus?method=resumeGroup', '恢复', '-1', ''), ('137', 'admin', '2', 'Admin/AuthManager/createGroup', '新增', '-1', ''), ('138', 'admin', '2', 'Admin/AuthManager/editGroup', '编辑', '-1', ''), ('139', 'admin', '2', 'Admin/AuthManager/writeGroup', '保存用户组', '-1', ''), ('140', 'admin', '2', 'Admin/AuthManager/group', '授权', '-1', ''), ('141', 'admin', '2', 'Admin/AuthManager/access', '访问授权', '-1', ''), ('142', 'admin', '2', 'Admin/AuthManager/user', '成员授权', '-1', ''), ('143', 'admin', '2', 'Admin/AuthManager/removeFromGroup', '解除授权', '-1', ''), ('144', 'admin', '2', 'Admin/AuthManager/addToGroup', '保存成员授权', '-1', ''), ('145', 'admin', '2', 'Admin/AuthManager/category', '分类授权', '-1', ''), ('146', 'admin', '2', 'Admin/AuthManager/addToCategory', '保存分类授权', '-1', ''), ('147', 'admin', '2', 'Admin/AuthManager/modelauth', '模型授权', '-1', ''), ('148', 'admin', '2', 'Admin/AuthManager/addToModel', '保存模型授权', '-1', ''), ('149', 'admin', '2', 'Admin/Addons/create', '创建', '-1', ''), ('150', 'admin', '2', 'Admin/Addons/checkForm', '检测创建', '-1', ''), ('151', 'admin', '2', 'Admin/Addons/preview', '预览', '-1', ''), ('152', 'admin', '2', 'Admin/Addons/build', '快速生成插件', '-1', ''), ('153', 'admin', '2', 'Admin/Addons/config', '设置', '-1', ''), ('154', 'admin', '2', 'Admin/Addons/disable', '禁用', '-1', ''), ('155', 'admin', '2', 'Admin/Addons/enable', '启用', '-1', ''), ('156', 'admin', '2', 'Admin/Addons/install', '安装', '-1', ''), ('157', 'admin', '2', 'Admin/Addons/uninstall', '卸载', '-1', ''), ('158', 'admin', '2', 'Admin/Addons/saveconfig', '更新配置', '-1', ''), ('159', 'admin', '2', 'Admin/Addons/adminList', '插件后台列表', '-1', ''), ('160', 'admin', '2', 'Admin/Addons/execute', 'URL方式访问插件', '-1', ''), ('161', 'admin', '2', 'Admin/Addons/hooks', '钩子管理', '-1', ''), ('162', 'admin', '2', 'Admin/Model/index', '模型管理', '-1', ''), ('163', 'admin', '2', 'Admin/model/add', '新增', '-1', ''), ('164', 'admin', '2', 'Admin/model/edit', '编辑', '-1', ''), ('165', 'admin', '2', 'Admin/model/setStatus', '改变状态', '-1', ''), ('166', 'admin', '2', 'Admin/model/update', '保存数据', '-1', ''), ('167', 'admin', '2', 'Admin/Attribute/index', '属性管理', '-1', ''), ('168', 'admin', '2', 'Admin/Attribute/add', '新增', '-1', ''), ('169', 'admin', '2', 'Admin/Attribute/edit', '编辑', '-1', ''), ('170', 'admin', '2', 'Admin/Attribute/setStatus', '改变状态', '-1', ''), ('171', 'admin', '2', 'Admin/Attribute/update', '保存数据', '-1', ''), ('172', 'admin', '2', 'Admin/Config/index', '配置管理', '-1', ''), ('173', 'admin', '2', 'Admin/Config/edit', '编辑', '-1', ''), ('174', 'admin', '2', 'Admin/Config/del', '删除', '-1', ''), ('175', 'admin', '2', 'Admin/Config/add', '新增', '-1', ''), ('176', 'admin', '2', 'Admin/Config/save', '保存', '-1', ''), ('177', 'admin', '2', 'Admin/Menu/index', '菜单管理', '-1', ''), ('178', 'admin', '2', 'Admin/Channel/index', '导航管理', '-1', ''), ('179', 'admin', '2', 'Admin/Channel/add', '新增', '-1', ''), ('180', 'admin', '2', 'Admin/Channel/edit', '编辑', '-1', ''), ('181', 'admin', '2', 'Admin/Channel/del', '删除', '-1', ''), ('182', 'admin', '2', 'Admin/Category/index', '分类管理', '-1', ''), ('183', 'admin', '2', 'Admin/Category/edit', '编辑', '-1', ''), ('184', 'admin', '2', 'Admin/Category/add', '新增', '-1', ''), ('185', 'admin', '2', 'Admin/Category/remove', '删除', '-1', ''), ('186', 'admin', '2', 'Admin/Category/move', '移动', '-1', ''), ('187', 'admin', '2', 'Admin/Category/merge', '合并', '-1', ''), ('188', 'admin', '2', 'Admin/Database/index?type=export', '备份数据库', '-1', ''), ('189', 'admin', '2', 'Admin/Database/export', '备份', '-1', ''), ('190', 'admin', '2', 'Admin/Database/optimize', '优化表', '-1', ''), ('191', 'admin', '2', 'Admin/Database/repair', '修复表', '-1', ''), ('192', 'admin', '2', 'Admin/Database/index?type=import', '还原数据库', '-1', ''), ('193', 'admin', '2', 'Admin/Database/import', '恢复', '-1', ''), ('194', 'admin', '2', 'Admin/Database/del', '删除', '-1', ''), ('195', 'admin', '2', 'Admin/other', '其他', '1', ''), ('196', 'admin', '2', 'Admin/Menu/add', '新增', '-1', ''), ('197', 'admin', '2', 'Admin/Menu/edit', '编辑', '-1', ''), ('198', 'admin', '2', 'Admin/Think/lists?model=article', '应用', '-1', ''), ('199', 'admin', '2', 'Admin/Think/lists?model=download', '下载管理', '-1', ''), ('200', 'admin', '2', 'Admin/Think/lists?model=config', '应用', '-1', ''), ('201', 'admin', '2', 'Admin/Action/actionlog', '行为日志', '-1', ''), ('202', 'admin', '2', 'Admin/User/updatePassword', '修改密码', '-1', ''), ('203', 'admin', '2', 'Admin/User/updateNickname', '修改昵称', '-1', ''), ('204', 'admin', '2', 'Admin/action/edit', '查看行为日志', '-1', ''), ('206', 'admin', '1', 'Admin/think/edit', '编辑数据', '1', ''), ('207', 'admin', '1', 'Admin/Menu/import', '导入', '1', ''), ('208', 'admin', '1', 'Admin/Model/generate', '生成', '1', ''), ('209', 'admin', '1', 'Admin/Addons/addHook', '新增钩子', '1', ''), ('210', 'admin', '1', 'Admin/Addons/edithook', '编辑钩子', '1', ''), ('211', 'admin', '1', 'Admin/Article/sort', '文档排序', '1', ''), ('212', 'admin', '1', 'Admin/Config/sort', '排序', '1', ''), ('213', 'admin', '1', 'Admin/Menu/sort', '排序', '1', ''), ('214', 'admin', '1', 'Admin/Channel/sort', '排序', '1', ''), ('215', 'admin', '1', 'Admin/Category/operate/type/move', '移动', '1', ''), ('216', 'admin', '1', 'Admin/Category/operate/type/merge', '合并', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `t_category`
-- ----------------------------
DROP TABLE IF EXISTS `t_category`;
CREATE TABLE `t_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `name` varchar(30) NOT NULL COMMENT '标志',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `list_row` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '列表每页行数',
  `meta_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'SEO的网页标题',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `template_index` varchar(100) NOT NULL COMMENT '频道页模板',
  `template_lists` varchar(100) NOT NULL COMMENT '列表页模板',
  `template_detail` varchar(100) NOT NULL COMMENT '详情页模板',
  `template_edit` varchar(100) NOT NULL COMMENT '编辑页模板',
  `model` varchar(100) NOT NULL DEFAULT '' COMMENT '关联模型',
  `type` varchar(100) NOT NULL DEFAULT '' COMMENT '允许发布的内容类型',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '外链',
  `allow_publish` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许发布内容',
  `display` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '可见性',
  `reply` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许回复',
  `check` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发布的文章是否需要审核',
  `reply_model` varchar(100) NOT NULL DEFAULT '',
  `extend` text NOT NULL COMMENT '扩展设置',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据状态',
  `icon` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类图标',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='分类表';

-- ----------------------------
--  Records of `t_category`
-- ----------------------------
BEGIN;
INSERT INTO `t_category` VALUES ('1', 'blog', '博客', '0', '0', '10', '', '', '', '', '', '', '', '2', '2,1', '0', '0', '1', '0', '0', '1', '', '1379474947', '1382701539', '1', '0'), ('2', 'default_blog', '默认分类', '1', '1', '10', '', '', '', '', '', '', '', '2', '2,1,3', '0', '1', '1', '0', '1', '1', '', '1379475028', '1386839751', '1', '31');
COMMIT;

-- ----------------------------
--  Table structure for `t_channel`
-- ----------------------------
DROP TABLE IF EXISTS `t_channel`;
CREATE TABLE `t_channel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '频道ID',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级频道ID',
  `title` char(30) NOT NULL COMMENT '频道标题',
  `url` char(100) NOT NULL COMMENT '频道连接',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '导航排序',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `target` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '新窗口打开',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_channel`
-- ----------------------------
BEGIN;
INSERT INTO `t_channel` VALUES ('1', '0', '首页', 'Index/index', '1', '1379475111', '1379923177', '1', '0'), ('2', '0', '博客', 'Article/index?category=blog', '2', '1379475131', '1379483713', '1', '0'), ('3', '0', '官网', 'http://www.jingruichina.cn', '3', '1379475154', '1403338098', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_config`
-- ----------------------------
DROP TABLE IF EXISTS `t_config`;
CREATE TABLE `t_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `group` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置分组',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text NOT NULL COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`),
  KEY `group` (`group`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_config`
-- ----------------------------
BEGIN;
INSERT INTO `t_config` VALUES ('1', 'WEB_SITE_TITLE', '1', '网站标题', '1', '', '网站标题前台显示标题', '1378898976', '1379235274', '1', 'JR管理后台', '0'), ('2', 'WEB_SITE_DESCRIPTION', '2', '网站描述', '1', '', '网站搜索引擎描述', '1378898976', '1379235841', '1', 'JR管理后台', '1'), ('3', 'WEB_SITE_KEYWORD', '2', '网站关键字', '1', '', '网站搜索引擎关键字', '1378898976', '1381390100', '1', ' JR', '8'), ('4', 'WEB_SITE_CLOSE', '4', '关闭站点', '1', '0:关闭,1:开启', '站点关闭后其他用户不能访问，管理员可以正常访问', '1378898976', '1379235296', '1', '1', '1'), ('9', 'CONFIG_TYPE_LIST', '3', '配置类型列表', '4', '', '主要用于数据解析和页面表单的生成', '1378898976', '1379235348', '1', '0:数字\r\n1:字符\r\n2:文本\r\n3:数组\r\n4:枚举', '2'), ('10', 'WEB_SITE_ICP', '1', '网站备案号', '1', '', '设置在网站底部显示的备案号，如“沪ICP备12007941号-2', '1378900335', '1379235859', '1', '', '9'), ('11', 'DOCUMENT_POSITION', '3', '文档推荐位', '2', '', '文档推荐位，推荐到多个位置KEY值相加即可', '1379053380', '1379235329', '1', '1:列表页推荐\r\n2:频道页推荐\r\n4:网站首页推荐', '3'), ('12', 'DOCUMENT_DISPLAY', '3', '文档可见性', '2', '', '文章可见性仅影响前台显示，后台不收影响', '1379056370', '1379235322', '1', '0:所有人可见\r\n1:仅注册会员可见\r\n2:仅管理员可见', '4'), ('13', 'COLOR_STYLE', '4', '后台色系', '1', 'default_color:默认\r\nblue_color:紫罗兰', '后台颜色风格', '1379122533', '1379235904', '1', 'default_color', '10'), ('20', 'CONFIG_GROUP_LIST', '3', '配置分组', '4', '', '配置分组', '1379228036', '1384418383', '1', '1:基本\r\n2:内容\r\n3:用户\r\n4:系统', '4'), ('21', 'HOOKS_TYPE', '3', '钩子的类型', '4', '', '类型 1-用于扩展显示内容，2-用于扩展业务处理', '1379313397', '1379313407', '1', '1:视图\r\n2:控制器', '6'), ('22', 'AUTH_CONFIG', '3', 'Auth配置', '4', '', '自定义Auth.class.php类配置', '1379409310', '1379409564', '1', 'AUTH_ON:1\r\nAUTH_TYPE:2', '8'), ('23', 'OPEN_DRAFTBOX', '4', '是否开启草稿功能', '2', '0:关闭草稿功能\r\n1:开启草稿功能\r\n', '新增文章时的草稿功能配置', '1379484332', '1379484591', '1', '1', '1'), ('24', 'DRAFT_AOTOSAVE_INTERVAL', '0', '自动保存草稿时间', '2', '', '自动保存草稿的时间间隔，单位：秒', '1379484574', '1386143323', '1', '60', '2'), ('25', 'LIST_ROWS', '0', '后台每页记录数', '2', '', '后台数据每页显示记录数', '1379503896', '1380427745', '1', '10', '10'), ('26', 'USER_ALLOW_REGISTER', '4', '是否允许用户注册', '3', '0:关闭注册\r\n1:允许注册', '是否开放用户注册', '1379504487', '1379504580', '1', '1', '3'), ('27', 'CODEMIRROR_THEME', '4', '预览插件的CodeMirror主题', '4', '3024-day:3024 day\r\n3024-night:3024 night\r\nambiance:ambiance\r\nbase16-dark:base16 dark\r\nbase16-light:base16 light\r\nblackboard:blackboard\r\ncobalt:cobalt\r\neclipse:eclipse\r\nelegant:elegant\r\nerlang-dark:erlang-dark\r\nlesser-dark:lesser-dark\r\nmidnight:midnight', '详情见CodeMirror官网', '1379814385', '1384740813', '1', 'ambiance', '3'), ('28', 'DATA_BACKUP_PATH', '1', '数据库备份根路径', '4', '', '路径必须以 / 结尾', '1381482411', '1381482411', '1', './Data/', '5'), ('29', 'DATA_BACKUP_PART_SIZE', '0', '数据库备份卷大小', '4', '', '该值用于限制压缩后的分卷最大长度。单位：B；建议设置20M', '1381482488', '1381729564', '1', '20971520', '7'), ('30', 'DATA_BACKUP_COMPRESS', '4', '数据库备份文件是否启用压缩', '4', '0:不压缩\r\n1:启用压缩', '压缩备份文件需要PHP环境支持gzopen,gzwrite函数', '1381713345', '1381729544', '1', '1', '9'), ('31', 'DATA_BACKUP_COMPRESS_LEVEL', '4', '数据库备份文件压缩级别', '4', '1:普通\r\n4:一般\r\n9:最高', '数据库备份文件的压缩级别，该配置在开启压缩时生效', '1381713408', '1381713408', '1', '9', '10'), ('32', 'DEVELOP_MODE', '4', '开启开发者模式', '4', '0:关闭\r\n1:开启', '是否开启开发者模式', '1383105995', '1383291877', '1', '1', '11'), ('33', 'ALLOW_VISIT', '3', '不受限控制器方法', '0', '', '', '1386644047', '1386644741', '1', '0:article/draftbox\r\n1:article/mydocument\r\n2:Category/tree\r\n3:Index/verify\r\n4:file/upload\r\n5:file/download\r\n6:user/updatePassword\r\n7:user/updateNickname\r\n8:user/submitPassword\r\n9:user/submitNickname\r\n10:file/uploadpicture', '0'), ('34', 'DENY_VISIT', '3', '超管专限控制器方法', '0', '', '仅超级管理员可访问的控制器方法', '1386644141', '1386644659', '1', '0:Addons/addhook\r\n1:Addons/edithook\r\n2:Addons/delhook\r\n3:Addons/updateHook\r\n4:Admin/getMenus\r\n5:Admin/recordList\r\n6:AuthManager/updateRules\r\n7:AuthManager/tree', '0'), ('35', 'REPLY_LIST_ROWS', '0', '回复列表每页条数', '2', '', '', '1386645376', '1387178083', '1', '10', '0'), ('36', 'ADMIN_ALLOW_IP', '2', '后台允许访问IP', '4', '', '多个用逗号分隔，如果不配置表示不限制IP访问', '1387165454', '1387165553', '1', '', '12'), ('37', 'SHOW_PAGE_TRACE', '4', '是否显示页面Trace', '4', '0:关闭\r\n1:开启', '是否显示页面Trace信息', '1387165685', '1387165685', '1', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_document`
-- ----------------------------
DROP TABLE IF EXISTS `t_document`;
CREATE TABLE `t_document` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `name` char(40) NOT NULL DEFAULT '' COMMENT '标识',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '标题',
  `category_id` int(10) unsigned NOT NULL COMMENT '所属分类',
  `description` char(140) NOT NULL DEFAULT '' COMMENT '描述',
  `root` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '根节点',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属ID',
  `model_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '内容模型ID',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '内容类型',
  `position` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '推荐位',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '外链',
  `cover_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '封面',
  `display` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '可见性',
  `deadline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '截至时间',
  `attach` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '附件数量',
  `view` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
  `comment` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  `extend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '扩展统计字段',
  `level` int(10) NOT NULL DEFAULT '0' COMMENT '优先级',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据状态',
  PRIMARY KEY (`id`),
  KEY `idx_category_status` (`category_id`,`status`),
  KEY `idx_status_type_pid` (`status`,`uid`,`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文档模型基础表';

-- ----------------------------
--  Records of `t_document`
-- ----------------------------
BEGIN;
INSERT INTO `t_document` VALUES ('1', '1', '', 'JR网站正式版发布', '2', 'JR网站正式版发布', '0', '0', '2', '2', '0', '0', '0', '1', '0', '0', '8', '0', '0', '0', '1387260660', '1403338152', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_document_article`
-- ----------------------------
DROP TABLE IF EXISTS `t_document_article`;
CREATE TABLE `t_document_article` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `parse` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '内容解析类型',
  `content` text NOT NULL COMMENT '文章内容',
  `template` varchar(100) NOT NULL DEFAULT '' COMMENT '详情页显示模板',
  `bookmark` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏数',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档模型文章表';

-- ----------------------------
--  Records of `t_document_article`
-- ----------------------------
BEGIN;
INSERT INTO `t_document_article` VALUES ('1', '0', 'JR网站正式版发布', '', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_document_download`
-- ----------------------------
DROP TABLE IF EXISTS `t_document_download`;
CREATE TABLE `t_document_download` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `parse` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '内容解析类型',
  `content` text NOT NULL COMMENT '下载详细描述',
  `template` varchar(100) NOT NULL DEFAULT '' COMMENT '详情页显示模板',
  `file_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件ID',
  `download` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档模型下载表';

-- ----------------------------
--  Table structure for `t_file`
-- ----------------------------
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE `t_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件ID',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '原始文件名',
  `savename` char(20) NOT NULL DEFAULT '' COMMENT '保存名称',
  `savepath` char(30) NOT NULL DEFAULT '' COMMENT '文件保存路径',
  `ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀',
  `mime` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置',
  `create_time` int(10) unsigned NOT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_md5` (`md5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文件表';

-- ----------------------------
--  Table structure for `t_hooks`
-- ----------------------------
DROP TABLE IF EXISTS `t_hooks`;
CREATE TABLE `t_hooks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `description` text NOT NULL COMMENT '描述',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `addons` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子挂载的插件 ''，''分割',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_hooks`
-- ----------------------------
BEGIN;
INSERT INTO `t_hooks` VALUES ('1', 'pageHeader', '页面header钩子，一般用于加载插件CSS文件和代码', '1', '0', ''), ('2', 'pageFooter', '页面footer钩子，一般用于加载插件JS文件和JS代码', '1', '0', 'ReturnTop'), ('3', 'documentEditForm', '添加编辑表单的 扩展内容钩子', '1', '0', 'Attachment'), ('4', 'documentDetailAfter', '文档末尾显示', '1', '0', 'Attachment,SocialComment'), ('5', 'documentDetailBefore', '页面内容前显示用钩子', '1', '0', ''), ('6', 'documentSaveComplete', '保存文档数据后的扩展钩子', '2', '0', 'Attachment'), ('7', 'documentEditFormContent', '添加编辑表单的内容显示钩子', '1', '0', 'Editor'), ('8', 'adminArticleEdit', '后台内容编辑页编辑器', '1', '1378982734', 'EditorForAdmin'), ('13', 'AdminIndex', '首页小格子个性化显示', '1', '1382596073', 'SiteStat,SystemInfo,DevTeam'), ('14', 'topicComment', '评论提交方式扩展钩子。', '1', '1380163518', 'Editor'), ('16', 'app_begin', '应用开始', '2', '1384481614', '');
COMMIT;

-- ----------------------------
--  Table structure for `t_item`
-- ----------------------------
DROP TABLE IF EXISTS `t_item`;
CREATE TABLE `t_item` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `desc` text,
  `order` int(11) NOT NULL DEFAULT '100',
  `type` varchar(255) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '待发布',
  `guid` varchar(255) DEFAULT NULL,
  `parent` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_item`
-- ----------------------------
BEGIN;
INSERT INTO `t_item` VALUES ('1', 'root', 'root', '100', 'system', '待发布', 'root', '0'), ('2', '图片', '', '100', 'pic', '已发布', '', '1'), ('3', '下载', '', '100', 'downlaod', '已发布', '', '1'), ('4', '新闻', '', '100', 'news', '已发布', '', '1'), ('5', '文章', '', '100', 'pages', '已发布', '', '1'), ('8', '自动提示信息', '', '100', 'autoComplete', '已发布', '', '1'), ('100', '', '', '0', '', '待发布', null, '1'), ('101', '111', '', '100', 'item', '待发布', null, '1'), ('102', '121212', '', '100', 'item', '待发布', null, '101');
COMMIT;

-- ----------------------------
--  Table structure for `t_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(20) NOT NULL,
  `operate` varchar(20) NOT NULL,
  `message` varchar(100) NOT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_t_log_user_id` (`user_id`) USING BTREE,
  KEY `fk_t_log_type` (`type`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_log`
-- ----------------------------
BEGIN;
INSERT INTO `t_log` VALUES ('10', '2014-04-07 16:47:45', 'user', 'user_add', '添加用户', 'jack', '1', 'admin'), ('11', '2014-04-07 16:47:45', 'system', 'login', '登录', '管理员登录', '1', 'admin'), ('12', '2014-04-07 16:47:45', 'post', 'post_add', '发表文章', '今天天气好啊', '1', 'admin'), ('13', '2014-04-07 16:47:45', 'system', 'logout', '登出', '管理员登出', '1', 'admin'), ('14', '2014-04-07 16:58:51', 'system', 'login', 'admin登录失败', '0.0.0.0', null, null), ('15', '2014-04-07 16:58:57', 'system', 'login', 'admin登录成功', '0.0.0.0', '1', 'admin'), ('16', '2014-04-07 17:03:17', 'user', 'lock_user', '锁定用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('17', '2014-04-07 17:03:19', 'user', 'active_user', '激活用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('18', '2014-04-07 17:40:12', 'system', 'add_meta', '添加meta成功,key：1', '0.0.0.0', '1', 'admin'), ('19', '2014-04-07 17:40:27', 'system', 'add_meta', '添加meta成功,key：2', '0.0.0.0', '1', 'admin'), ('20', '2014-04-07 17:41:44', 'system', 'delete_meta', '删除meta成功,key：0', '0.0.0.0', '1', 'admin'), ('21', '2014-04-07 17:43:19', 'system', 'delete_meta', '删除meta成功,key：0', '0.0.0.0', '1', 'admin'), ('22', '2014-04-07 17:43:24', 'system', 'add_meta', '添加meta成功,key：1', '0.0.0.0', '1', 'admin'), ('23', '2014-04-07 17:43:32', 'system', 'update_meta', '更新meta成功,key：1', '0.0.0.0', '1', 'admin'), ('24', '2014-04-07 17:43:38', 'system', 'update_meta', '更新meta成功,key：2', '0.0.0.0', '1', 'admin'), ('25', '2014-04-07 17:49:31', 'user', 'lock_user', '锁定用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('26', '2014-04-07 17:49:31', 'user', 'lock_user', '锁定用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('27', '2014-04-07 17:49:41', 'user', 'active_user', '激活用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('28', '2014-04-07 17:49:42', 'user', 'lock_user', '锁定用户成功,用户id：11', '0.0.0.0', '1', 'admin'), ('29', '2014-04-07 21:51:20', 'system', 'un_public_item', '撤销分类，分类id：5', '0.0.0.0', '1', 'admin'), ('30', '2014-04-07 21:52:38', 'system', 'un_public_item', '撤销分类，分类id：5', '0.0.0.0', '1', 'admin'), ('31', '2014-04-07 21:52:40', 'system', 'public_item', '发布分类，分类id：5', '0.0.0.0', '1', 'admin'), ('32', '2014-04-07 21:58:01', 'system', 'add_item', '添加item成功,key：', '0.0.0.0', '1', 'admin'), ('33', '2014-04-07 21:59:04', 'system', 'add_item', '添加item成功,key：', '0.0.0.0', '1', 'admin'), ('34', '2014-04-07 21:59:22', 'system', 'add_item', '添加item成功,key：', '0.0.0.0', '1', 'admin'), ('35', '2014-04-07 22:04:36', 'system', 'update_item', '更新item成功,key：', '0.0.0.0', '1', 'admin'), ('36', '2014-04-07 23:00:52', 'post', 'add_post', '添加文章成功,id：', '0.0.0.0', '1', 'admin'), ('37', '2014-04-07 23:10:06', 'post', 'add_post', '添加文章成功,id：', '0.0.0.0', '1', 'admin'), ('38', '2014-04-07 23:16:32', 'post', 'update_post', '更新文章成功,id：101', '0.0.0.0', '1', 'admin'), ('39', '2014-04-07 23:16:44', 'post', 'update_post', '更新文章成功,id：101', '0.0.0.0', '1', 'admin'), ('40', '2014-04-07 23:18:46', 'post', 'public_post', '发布文档，分类id：101', '0.0.0.0', '1', 'admin'), ('41', '2014-04-07 23:18:47', 'post', 'public_post', '发布文档，分类id：101', '0.0.0.0', '1', 'admin'), ('42', '2014-04-07 23:20:17', 'post', 'un_public_post', '撤销文档，分类id：101', '0.0.0.0', '1', 'admin'), ('43', '2014-04-07 23:20:17', 'post', 'un_public_post', '撤销文档，分类id：101', '0.0.0.0', '1', 'admin'), ('44', '2014-04-07 23:21:26', 'post', 'public_post', '发布文档，分类id：101', '0.0.0.0', '1', 'admin'), ('45', '2014-04-07 23:21:28', 'post', 'public_post', '发布文档，分类id：101', '0.0.0.0', '1', 'admin'), ('46', '2014-04-07 23:21:45', 'post', 'un_public_post', '撤销文档，分类id：101', '0.0.0.0', '1', 'admin'), ('47', '2014-04-07 23:21:50', 'post', 'un_public_post', '撤销文档，分类id：101', '0.0.0.0', '1', 'admin'), ('48', '2014-04-07 23:23:08', 'post', 'add_post', '添加文章成功,id：', '0.0.0.0', '1', 'admin'), ('49', '2014-04-07 23:23:20', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('50', '2014-04-07 23:23:20', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('51', '2014-04-07 23:24:21', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('52', '2014-04-07 23:24:25', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('53', '2014-04-07 23:24:44', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('54', '2014-04-07 23:24:46', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('55', '2014-04-07 23:24:54', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('56', '2014-04-07 23:24:59', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('57', '2014-04-07 23:27:11', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('58', '2014-04-07 23:27:13', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('59', '2014-04-07 23:27:18', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('60', '2014-04-07 23:27:18', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('61', '2014-04-07 23:27:52', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('62', '2014-04-07 23:27:52', 'post', 'public_post', '发布文档，分类id：102', '0.0.0.0', '1', 'admin'), ('63', '2014-04-07 23:28:00', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('64', '2014-04-07 23:28:00', 'post', 'un_public_post', '撤销文档，分类id：102', '0.0.0.0', '1', 'admin'), ('65', '2014-04-07 23:28:12', 'post', 'public_post', '发布文档，分类id：0', '0.0.0.0', '1', 'admin'), ('66', '2014-04-07 23:28:12', 'post', 'public_post', '发布文档，分类id：0', '0.0.0.0', '1', 'admin'), ('67', '2014-04-10 09:57:06', 'system', 'login', 'admin登录成功', '0.0.0.0', '1', 'admin');
COMMIT;

-- ----------------------------
--  Table structure for `t_member`
-- ----------------------------
DROP TABLE IF EXISTS `t_member`;
CREATE TABLE `t_member` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵称',
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date NOT NULL DEFAULT '0000-00-00' COMMENT '生日',
  `qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq号',
  `score` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `login` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员状态',
  PRIMARY KEY (`uid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
--  Records of `t_member`
-- ----------------------------
BEGIN;
INSERT INTO `t_member` VALUES ('1', 'admin', '0', '0000-00-00', '', '20', '5', '0', '1403334606', '2130706433', '1436756907', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_menu`
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES ('1', '首页', '0', '1', 'Index/index', '0', '', '', '0'), ('2', '内容', '0', '2', 'Article/mydocument', '1', '', '', '0'), ('3', '文档列表', '2', '0', 'article/index', '1', '', '内容', '0'), ('4', '新增', '3', '0', 'article/add', '0', '', '', '0'), ('5', '编辑', '3', '0', 'article/edit', '0', '', '', '0'), ('6', '改变状态', '3', '0', 'article/setStatus', '0', '', '', '0'), ('7', '保存', '3', '0', 'article/update', '0', '', '', '0'), ('8', '保存草稿', '3', '0', 'article/autoSave', '0', '', '', '0'), ('9', '移动', '3', '0', 'article/move', '0', '', '', '0'), ('10', '复制', '3', '0', 'article/copy', '0', '', '', '0'), ('11', '粘贴', '3', '0', 'article/paste', '0', '', '', '0'), ('12', '导入', '3', '0', 'article/batchOperate', '0', '', '', '0'), ('13', '回收站', '2', '0', 'article/recycle', '1', '', '内容', '0'), ('14', '还原', '13', '0', 'article/permit', '0', '', '', '0'), ('15', '清空', '13', '0', 'article/clear', '0', '', '', '0'), ('16', '用户', '0', '3', 'User/index', '0', '', '', '0'), ('17', '用户信息', '16', '0', 'User/index', '0', '', '用户管理', '0'), ('18', '新增用户', '17', '0', 'User/add', '0', '添加新用户', '', '0'), ('19', '用户行为', '16', '0', 'User/action', '0', '', '行为管理', '0'), ('20', '新增用户行为', '19', '0', 'User/addaction', '0', '', '', '0'), ('21', '编辑用户行为', '19', '0', 'User/editaction', '0', '', '', '0'), ('22', '保存用户行为', '19', '0', 'User/saveAction', '0', '\"用户->用户行为\"保存编辑和新增的用户行为', '', '0'), ('23', '变更行为状态', '19', '0', 'User/setStatus', '0', '\"用户->用户行为\"中的启用,禁用和删除权限', '', '0'), ('24', '禁用会员', '19', '0', 'User/changeStatus?method=forbidUser', '0', '\"用户->用户信息\"中的禁用', '', '0'), ('25', '启用会员', '19', '0', 'User/changeStatus?method=resumeUser', '0', '\"用户->用户信息\"中的启用', '', '0'), ('26', '删除会员', '19', '0', 'User/changeStatus?method=deleteUser', '0', '\"用户->用户信息\"中的删除', '', '0'), ('27', '权限管理', '16', '0', 'AuthManager/index', '0', '', '用户管理', '0'), ('28', '删除', '27', '0', 'AuthManager/changeStatus?method=deleteGroup', '0', '删除用户组', '', '0'), ('29', '禁用', '27', '0', 'AuthManager/changeStatus?method=forbidGroup', '0', '禁用用户组', '', '0'), ('30', '恢复', '27', '0', 'AuthManager/changeStatus?method=resumeGroup', '0', '恢复已禁用的用户组', '', '0'), ('31', '新增', '27', '0', 'AuthManager/createGroup', '0', '创建新的用户组', '', '0'), ('32', '编辑', '27', '0', 'AuthManager/editGroup', '0', '编辑用户组名称和描述', '', '0'), ('33', '保存用户组', '27', '0', 'AuthManager/writeGroup', '0', '新增和编辑用户组的\"保存\"按钮', '', '0'), ('34', '授权', '27', '0', 'AuthManager/group', '0', '\"后台 \\ 用户 \\ 用户信息\"列表页的\"授权\"操作按钮,用于设置用户所属用户组', '', '0'), ('35', '访问授权', '27', '0', 'AuthManager/access', '0', '\"后台 \\ 用户 \\ 权限管理\"列表页的\"访问授权\"操作按钮', '', '0'), ('36', '成员授权', '27', '0', 'AuthManager/user', '0', '\"后台 \\ 用户 \\ 权限管理\"列表页的\"成员授权\"操作按钮', '', '0'), ('37', '解除授权', '27', '0', 'AuthManager/removeFromGroup', '0', '\"成员授权\"列表页内的解除授权操作按钮', '', '0'), ('38', '保存成员授权', '27', '0', 'AuthManager/addToGroup', '0', '\"用户信息\"列表页\"授权\"时的\"保存\"按钮和\"成员授权\"里右上角的\"添加\"按钮)', '', '0'), ('39', '分类授权', '27', '0', 'AuthManager/category', '0', '\"后台 \\ 用户 \\ 权限管理\"列表页的\"分类授权\"操作按钮', '', '0'), ('40', '保存分类授权', '27', '0', 'AuthManager/addToCategory', '0', '\"分类授权\"页面的\"保存\"按钮', '', '0'), ('41', '模型授权', '27', '0', 'AuthManager/modelauth', '0', '\"后台 \\ 用户 \\ 权限管理\"列表页的\"模型授权\"操作按钮', '', '0'), ('42', '保存模型授权', '27', '0', 'AuthManager/addToModel', '0', '\"分类授权\"页面的\"保存\"按钮', '', '0'), ('43', '扩展', '0', '7', 'Addons/index', '1', '', '', '1'), ('44', '插件管理', '43', '1', 'Addons/index', '0', '', '扩展', '0'), ('45', '创建', '44', '0', 'Addons/create', '0', '服务器上创建插件结构向导', '', '0'), ('46', '检测创建', '44', '0', 'Addons/checkForm', '0', '检测插件是否可以创建', '', '0'), ('47', '预览', '44', '0', 'Addons/preview', '0', '预览插件定义类文件', '', '0'), ('48', '快速生成插件', '44', '0', 'Addons/build', '0', '开始生成插件结构', '', '0'), ('49', '设置', '44', '0', 'Addons/config', '0', '设置插件配置', '', '0'), ('50', '禁用', '44', '0', 'Addons/disable', '0', '禁用插件', '', '0'), ('51', '启用', '44', '0', 'Addons/enable', '0', '启用插件', '', '0'), ('52', '安装', '44', '0', 'Addons/install', '0', '安装插件', '', '0'), ('53', '卸载', '44', '0', 'Addons/uninstall', '0', '卸载插件', '', '0'), ('54', '更新配置', '44', '0', 'Addons/saveconfig', '0', '更新插件配置处理', '', '0'), ('55', '插件后台列表', '44', '0', 'Addons/adminList', '0', '', '', '0'), ('56', 'URL方式访问插件', '44', '0', 'Addons/execute', '0', '控制是否有权限通过url访问插件控制器方法', '', '0'), ('57', '钩子管理', '43', '2', 'Addons/hooks', '0', '', '扩展', '0'), ('58', '模型管理', '68', '3', 'Model/index', '0', '', '系统设置', '0'), ('59', '新增', '58', '0', 'model/add', '0', '', '', '0'), ('60', '编辑', '58', '0', 'model/edit', '0', '', '', '0'), ('61', '改变状态', '58', '0', 'model/setStatus', '0', '', '', '0'), ('62', '保存数据', '58', '0', 'model/update', '0', '', '', '0'), ('63', '属性管理', '68', '0', 'Attribute/index', '1', '网站属性配置。', '', '0'), ('64', '新增', '63', '0', 'Attribute/add', '0', '', '', '0'), ('65', '编辑', '63', '0', 'Attribute/edit', '0', '', '', '0'), ('66', '改变状态', '63', '0', 'Attribute/setStatus', '0', '', '', '0'), ('67', '保存数据', '63', '0', 'Attribute/update', '0', '', '', '0'), ('68', '系统', '0', '4', 'Config/group', '0', '', '', '0'), ('69', '网站设置', '68', '1', 'Config/group', '0', '', '系统设置', '0'), ('70', '配置管理', '68', '4', 'Config/index', '0', '', '系统设置', '0'), ('71', '编辑', '70', '0', 'Config/edit', '0', '新增编辑和保存配置', '', '0'), ('72', '删除', '70', '0', 'Config/del', '0', '删除配置', '', '0'), ('73', '新增', '70', '0', 'Config/add', '0', '新增配置', '', '0'), ('74', '保存', '70', '0', 'Config/save', '0', '保存配置', '', '0'), ('75', '菜单管理', '68', '5', 'Menu/index', '0', '', '系统设置', '0'), ('76', '导航管理', '68', '6', 'Channel/index', '0', '', '系统设置', '0'), ('77', '新增', '76', '0', 'Channel/add', '0', '', '', '0'), ('78', '编辑', '76', '0', 'Channel/edit', '0', '', '', '0'), ('79', '删除', '76', '0', 'Channel/del', '0', '', '', '0'), ('80', '分类管理', '68', '2', 'Category/index', '0', '', '系统设置', '0'), ('81', '编辑', '80', '0', 'Category/edit', '0', '编辑和保存栏目分类', '', '0'), ('82', '新增', '80', '0', 'Category/add', '0', '新增栏目分类', '', '0'), ('83', '删除', '80', '0', 'Category/remove', '0', '删除栏目分类', '', '0'), ('84', '移动', '80', '0', 'Category/operate/type/move', '0', '移动栏目分类', '', '0'), ('85', '合并', '80', '0', 'Category/operate/type/merge', '0', '合并栏目分类', '', '0'), ('86', '备份数据库', '68', '0', 'Database/index?type=export', '0', '', '数据备份', '0'), ('87', '备份', '86', '0', 'Database/export', '0', '备份数据库', '', '0'), ('88', '优化表', '86', '0', 'Database/optimize', '0', '优化数据表', '', '0'), ('89', '修复表', '86', '0', 'Database/repair', '0', '修复数据表', '', '0'), ('90', '还原数据库', '68', '0', 'Database/index?type=import', '0', '', '数据备份', '0'), ('91', '恢复', '90', '0', 'Database/import', '0', '数据库恢复', '', '0'), ('92', '删除', '90', '0', 'Database/del', '0', '删除备份文件', '', '0'), ('93', '其他', '0', '5', 'other', '1', '', '', '0'), ('96', '新增', '75', '0', 'Menu/add', '0', '', '系统设置', '0'), ('98', '编辑', '75', '0', 'Menu/edit', '0', '', '', '0'), ('104', '下载管理', '102', '0', 'Think/lists?model=download', '0', '', '', '0'), ('105', '配置管理', '102', '0', 'Think/lists?model=config', '0', '', '', '0'), ('106', '行为日志', '16', '0', 'Action/actionlog', '0', '', '行为管理', '0'), ('108', '修改密码', '16', '0', 'User/updatePassword', '1', '', '', '0'), ('109', '修改昵称', '16', '0', 'User/updateNickname', '1', '', '', '0'), ('110', '查看行为日志', '106', '0', 'action/edit', '1', '', '', '0'), ('112', '新增数据', '58', '0', 'think/add', '1', '', '', '0'), ('113', '编辑数据', '58', '0', 'think/edit', '1', '', '', '0'), ('114', '导入', '75', '0', 'Menu/import', '0', '', '', '0'), ('115', '生成', '58', '0', 'Model/generate', '0', '', '', '0'), ('116', '新增钩子', '57', '0', 'Addons/addHook', '0', '', '', '0'), ('117', '编辑钩子', '57', '0', 'Addons/edithook', '0', '', '', '0'), ('118', '文档排序', '3', '0', 'Article/sort', '1', '', '', '0'), ('119', '排序', '70', '0', 'Config/sort', '1', '', '', '0'), ('120', '排序', '75', '0', 'Menu/sort', '1', '', '', '0'), ('121', '排序', '76', '0', 'Channel/sort', '1', '', '', '0'), ('122', '上传图片', '1', '0', 'Addons/execute', '0', '', '', '0'), ('123', '用户Apps', '17', '2', 'User/apps', '0', '', '', '0'), ('124', 'Apps', '0', '3', 'Apps/lists', '0', '', '', '0'), ('125', '应用', '124', '1', 'Apps/lists', '0', '', 'Apps', '0'), ('126', '添加应用', '125', '1', 'Apps/add', '0', '', '', '0'), ('127', '编辑应用', '125', '2', 'Apps/edit', '0', '', '', '0'), ('128', '删除应用', '125', '3', 'Apps/del', '0', '', '', '0'), ('129', '应用数据模型', '125', '4', 'Apps/models', '0', '', '', '0'), ('130', '数据', '125', '5', 'Apps/datas', '0', '', '', '0'), ('131', '推送', '124', '2', 'Index/datas', '1', '', 'Apps', '0'), ('132', 'Bmob_lists', '125', '11', 'Bmob/lists', '0', '', '', '0'), ('133', 'Bmob_add', '125', '13', 'Bmob/add', '0', '', '', '0'), ('134', 'Bmob_edit', '125', '12', 'Bmob/edit', '0', '', '', '0'), ('135', 'Bmob_del', '125', '14', 'Bmob/del', '0', '', '', '0'), ('136', 'Bmob_tools', '125', '15', 'Bmob/tools', '0', '', '', '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_meta`
-- ----------------------------
DROP TABLE IF EXISTS `t_meta`;
CREATE TABLE `t_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `record_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `key` varchar(255) DEFAULT NULL,
  `value` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_meta`
-- ----------------------------
BEGIN;
INSERT INTO `t_meta` VALUES ('1', '0', '网站logo', 'web_logo', 'img/jptm_logo.png'), ('102', '0', '2', '2', '2');
COMMIT;

-- ----------------------------
--  Table structure for `t_model`
-- ----------------------------
DROP TABLE IF EXISTS `t_model`;
CREATE TABLE `t_model` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模型ID',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '模型标识',
  `title` char(30) NOT NULL DEFAULT '' COMMENT '模型名称',
  `extend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '继承的模型',
  `relation` varchar(30) NOT NULL DEFAULT '' COMMENT '继承与被继承模型的关联字段',
  `need_pk` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '新建表时是否需要主键字段',
  `field_sort` text NOT NULL COMMENT '表单字段排序',
  `field_group` varchar(255) NOT NULL DEFAULT '1:基础' COMMENT '字段分组',
  `attribute_list` text NOT NULL COMMENT '属性列表（表的字段）',
  `template_list` varchar(100) NOT NULL DEFAULT '' COMMENT '列表模板',
  `template_add` varchar(100) NOT NULL DEFAULT '' COMMENT '新增模板',
  `template_edit` varchar(100) NOT NULL DEFAULT '' COMMENT '编辑模板',
  `list_grid` text NOT NULL COMMENT '列表定义',
  `list_row` smallint(2) unsigned NOT NULL DEFAULT '10' COMMENT '列表数据长度',
  `search_key` varchar(50) NOT NULL DEFAULT '' COMMENT '默认搜索字段',
  `search_list` varchar(255) NOT NULL DEFAULT '' COMMENT '高级搜索的字段',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `engine_type` varchar(25) NOT NULL DEFAULT 'MyISAM' COMMENT '数据库引擎',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='文档模型表';

-- ----------------------------
--  Records of `t_model`
-- ----------------------------
BEGIN;
INSERT INTO `t_model` VALUES ('1', 'document', '基础文档', '0', '', '1', '{\"1\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"11\",\"12\",\"13\",\"14\",\"15\",\"16\",\"17\",\"18\",\"19\",\"20\",\"21\",\"22\"]}', '1:基础', '', '', '', '', 'id:编号\r\ntitle:标题:article/index?cate_id=[category_id]&pid=[id]\r\ntype|get_document_type:类型\r\nlevel:优先级\r\nupdate_time|time_format:最后更新\r\nstatus_text:状态\r\nview:浏览\r\nid:操作:[EDIT]&cate_id=[category_id]|编辑,article/setstatus?status=-1&ids=[id]|删除', '0', '', '', '1383891233', '1384507827', '1', 'MyISAM'), ('2', 'article', '文章', '1', '', '1', '{\"1\":[\"3\",\"24\",\"2\",\"5\"],\"2\":[\"9\",\"13\",\"19\",\"10\",\"12\",\"16\",\"17\",\"26\",\"20\",\"14\",\"11\",\"25\"]}', '1:基础,2:扩展', '', '', '', '', 'id:编号\r\ntitle:标题:article/edit?cate_id=[category_id]&id=[id]\r\ncontent:内容', '0', '', '', '1383891243', '1387260622', '1', 'MyISAM'), ('3', 'download', '下载', '1', '', '1', '{\"1\":[\"3\",\"28\",\"30\",\"32\",\"2\",\"5\",\"31\"],\"2\":[\"13\",\"10\",\"27\",\"9\",\"12\",\"16\",\"17\",\"19\",\"11\",\"20\",\"14\",\"29\"]}', '1:基础,2:扩展', '', '', '', '', 'id:编号\r\ntitle:标题', '0', '', '', '1383891252', '1387260449', '1', 'MyISAM'), ('4', 'JrTools', 'JRTools', '2', '', '0', '{\"1\":[\"34\",\"35\"]}', '1:基础', '', '', '', '', 'objectId:对象ID\r\nusername:用户名\r\npassword:密码\r\ncreatedAt:创建时间\r\nupdatedAt:更新时间\r\nobjectId:操作:edit?objectId=[objectId]&model_id=[model_id]|编辑', '10', 'username', 'username', '1436775476', '1436940534', '1', 'MyISAM'), ('5', 'userapps', '用户App关系', '0', '', '0', '', '1:基础', '', '', '', '', '', '10', '', '', '1436787726', '1436787726', '1', 'MyISAM'), ('6', 'appmodels', 'App数据模型关系', '0', '', '1', '', '1:基础', '', '', '', '', '', '10', '', '', '1436787749', '1436787749', '1', 'MyISAM'), ('7', 'apps', 'App应用', '0', '', '1', '{\"1\":[\"38\",\"39\",\"40\",\"41\",\"42\",\"43\",\"44\",\"45\"]}', '1:基础', '', '', '', '', 'id:ID\r\nname:名称\r\napp_id:应用ID\r\nid:模型:models?app_id=[id]|模型\r\nid:数据:datas?app_id=[id]|数据\r\nstatus|get_status_title:状态\r\nid:操作:[EDIT]|编辑,setstatus?status=-1&ids=[id]|删除', '10', 'name', '', '1436788167', '1436840822', '1', 'MyISAM'), ('9', 'test', '测试模型', '2', '', '1', '', '1:基础', '', '', '', '', '', '10', '', '', '1436927738', '1436927738', '1', 'MyISAM');
COMMIT;

-- ----------------------------
--  Table structure for `t_picture`
-- ----------------------------
DROP TABLE IF EXISTS `t_picture`;
CREATE TABLE `t_picture` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id自增',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '图片链接',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_post`
-- ----------------------------
DROP TABLE IF EXISTS `t_post`;
CREATE TABLE `t_post` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `author` bigint(20) unsigned NOT NULL DEFAULT '0',
  `content` longtext NOT NULL,
  `title` text NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT '待发布',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NULL DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT '100',
  `pic1` varchar(255) DEFAULT '',
  `pic2` varchar(255) DEFAULT '',
  `pic3` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT 'page',
  `parent` bigint(20) unsigned DEFAULT '0',
  `item` bigint(20) unsigned DEFAULT '0',
  `guid` varchar(255) DEFAULT NULL,
  `attr1` varchar(255) DEFAULT '',
  `attr2` varchar(255) DEFAULT '',
  `attr3` varchar(255) DEFAULT '',
  `attr4` varchar(255) DEFAULT '',
  `attr5` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `author` (`author`),
  KEY `item` (`item`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_post`
-- ----------------------------
BEGIN;
INSERT INTO `t_post` VALUES ('100', '0', 'dd', 'dd', '待发布', '2014-04-07 23:00:52', null, '100', 'ddd', '', '', 'page', '0', '2', null, '', '', '', '', ''), ('101', '1', 'ddddda', 'dddccc', '待发布', '2014-04-07 23:10:06', null, '1', 'ddd', '', '', 'page', '0', '2', null, '', '', '', '', ''), ('102', '1', '22222', '111111', '待发布', '2014-04-07 23:23:08', null, '100', '2222', '', '', 'page', '0', '1', null, '', '', '', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `t_ucenter_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_ucenter_admin`;
CREATE TABLE `t_ucenter_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员用户ID',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '管理员状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
--  Table structure for `t_ucenter_app`
-- ----------------------------
DROP TABLE IF EXISTS `t_ucenter_app`;
CREATE TABLE `t_ucenter_app` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '应用ID',
  `title` varchar(30) NOT NULL COMMENT '应用名称',
  `url` varchar(100) NOT NULL COMMENT '应用URL',
  `ip` char(15) NOT NULL COMMENT '应用IP',
  `auth_key` varchar(100) NOT NULL COMMENT '加密KEY',
  `sys_login` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '同步登陆',
  `allow_ip` varchar(255) NOT NULL COMMENT '允许访问的IP',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '应用状态',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='应用表';

-- ----------------------------
--  Table structure for `t_ucenter_member`
-- ----------------------------
DROP TABLE IF EXISTS `t_ucenter_member`;
CREATE TABLE `t_ucenter_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` char(16) NOT NULL COMMENT '用户名',
  `password` char(32) NOT NULL COMMENT '密码',
  `email` char(32) NOT NULL COMMENT '用户邮箱',
  `mobile` char(15) NOT NULL COMMENT '用户手机',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `t_ucenter_member`
-- ----------------------------
BEGIN;
INSERT INTO `t_ucenter_member` VALUES ('1', 'admin', 'b538a6c77646942865405a85697371a1', '278250658@qq.com', '', '1403334606', '0', '1436756907', '2130706433', '1403334606', '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_ucenter_setting`
-- ----------------------------
DROP TABLE IF EXISTS `t_ucenter_setting`;
CREATE TABLE `t_ucenter_setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '设置ID',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型（1-用户配置）',
  `value` text NOT NULL COMMENT '配置数据',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='设置表';

-- ----------------------------
--  Table structure for `t_url`
-- ----------------------------
DROP TABLE IF EXISTS `t_url`;
CREATE TABLE `t_url` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '链接唯一标识',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `short` char(100) NOT NULL DEFAULT '' COMMENT '短网址',
  `status` tinyint(2) NOT NULL DEFAULT '2' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='链接表';

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(64) NOT NULL DEFAULT '',
  `nicename` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '0',
  `level` varchar(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `username_key` (`username`),
  KEY `nicename_key` (`nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin', '278250658@qq.com', 'http://localhost/APP/Modules/Admin/Tpl/Public/images/logo2.png', '2014-03-30 23:39:09', '1', '5'), ('10', '1', '1', '1', '1@qq.com', '', '2014-04-07 15:33:58', '3', '5'), ('11', '2', '2', '2', '2', '2', '2014-04-07 15:34:58', '2', '5'), ('12', '3', '3', '3', '3', '3', '2014-04-07 15:35:32', '2', '5'), ('13', '4', '4', '4', '4', '4', '2014-04-07 15:41:18', '0', '5'), ('14', '6', '1679091c5a880faf6fb5e6087eb1b2dc', '6', '002@qq.com', '6', '0000-00-00 00:00:00', '0', '5');
COMMIT;

-- ----------------------------
--  Table structure for `t_userapps`
-- ----------------------------
DROP TABLE IF EXISTS `t_userapps`;
CREATE TABLE `t_userapps` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户ID',
  `app_id` int(10) unsigned NOT NULL COMMENT 'App Id',
  PRIMARY KEY (`uid`,`app_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `t_userapps`
-- ----------------------------
BEGIN;
INSERT INTO `t_userapps` VALUES ('1', '1'), ('1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `t_userdata`
-- ----------------------------
DROP TABLE IF EXISTS `t_userdata`;
CREATE TABLE `t_userdata` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `type` tinyint(3) unsigned NOT NULL COMMENT '类型标识',
  `target_id` int(10) unsigned NOT NULL COMMENT '目标id',
  UNIQUE KEY `uid` (`uid`,`type`,`target_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;