/*
Navicat MySQL Data Transfer

Source Server         : local2
Source Server Version : 50635
Source Host           : localhost:3306
Source Database       : base

Target Server Type    : MYSQL
Target Server Version : 50635
File Encoding         : 65001

Date: 2018-08-09 14:22:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `password` varchar(50) NOT NULL DEFAULT '' COMMENT '管理员密码',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1 启用 0 禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(20) DEFAULT NULL COMMENT '最后登录IP',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES ('1', 'admin', '0dfc7612f607db6c17fd99388e9e5f9c', '1', '2016-10-18 15:28:37', '2018-08-09 13:20:03', '127.0.0.1');

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `rules` mediumtext NOT NULL COMMENT '权限规则ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='权限组表';

-- ----------------------------
-- Records of auth_group
-- ----------------------------
INSERT INTO `auth_group` VALUES ('1', '超级管理组', '1', '1,2,3,73,74,5,6,7,8,9,10,11,14,16,17,44,45,46,47,48,18,49,50,51,52,53,19,31,32,33,34,35,36,37,54');

-- ----------------------------
-- Table structure for auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_access`;
CREATE TABLE `auth_group_access` (
  `uid` mediumint(8) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='权限组规则表';

-- ----------------------------
-- Records of auth_group_access
-- ----------------------------
INSERT INTO `auth_group_access` VALUES ('1', '1');

-- ----------------------------
-- Table structure for auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `auth_rule`;
CREATE TABLE `auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '' COMMENT '规则名称',
  `title` varchar(20) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `pid` smallint(5) unsigned NOT NULL COMMENT '父级ID',
  `icon` varchar(50) DEFAULT '' COMMENT '图标',
  `sort` tinyint(4) unsigned NOT NULL COMMENT '排序',
  `condition` char(100) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='规则表';

-- ----------------------------
-- Records of auth_rule
-- ----------------------------
INSERT INTO `auth_rule` VALUES ('1', 'admin/System/default', '系统配置', '1', '1', '0', 'icon-system1', '0', '');
INSERT INTO `auth_rule` VALUES ('2', 'admin/System/siteConfig', '站点配置', '1', '1', '1', '', '0', '');
INSERT INTO `auth_rule` VALUES ('3', 'admin/System/updateSiteConfig', '更新配置', '1', '0', '1', '', '0', '');
INSERT INTO `auth_rule` VALUES ('5', 'admin/Menu/default', '菜单管理', '1', '1', '0', 'icon-caidan', '0', '');
INSERT INTO `auth_rule` VALUES ('6', 'admin/Menu/index', '后台菜单', '1', '1', '5', '', '0', '');
INSERT INTO `auth_rule` VALUES ('7', 'admin/Menu/add', '添加菜单', '1', '0', '6', '', '0', '');
INSERT INTO `auth_rule` VALUES ('8', 'admin/Menu/save', '保存菜单', '1', '0', '6', '', '0', '');
INSERT INTO `auth_rule` VALUES ('9', 'admin/Menu/edit', '编辑菜单', '1', '0', '6', '', '0', '');
INSERT INTO `auth_rule` VALUES ('10', 'admin/Menu/update', '更新菜单', '1', '0', '6', '', '0', '');
INSERT INTO `auth_rule` VALUES ('11', 'admin/Menu/delete', '删除菜单', '1', '0', '6', '', '0', '');
INSERT INTO `auth_rule` VALUES ('14', 'admin/Content/default', '内容管理', '1', '0', '0', 'icon-zixun', '0', '');
INSERT INTO `auth_rule` VALUES ('75', 'admin/AdminUser/default', '管理员', '1', '1', '0', 'icon-guanliyuan', '0', '');
INSERT INTO `auth_rule` VALUES ('16', 'admin/User/default', '用户管理', '1', '1', '0', 'icon-icon-user', '0', '');
INSERT INTO `auth_rule` VALUES ('17', 'admin/User/index', '普通用户', '1', '1', '16', '', '0', '');
INSERT INTO `auth_rule` VALUES ('18', 'admin/AdminUser/index', '管理员', '1', '1', '75', '', '0', '');
INSERT INTO `auth_rule` VALUES ('19', 'admin/AuthGroup/index', '权限组', '1', '1', '75', '', '0', '');
INSERT INTO `auth_rule` VALUES ('76', 'admin/Files/index', '文件管理', '1', '1', '0', 'icon-caidan', '0', '');
INSERT INTO `auth_rule` VALUES ('77', 'admin/Files/add', '添加文件', '1', '0', '76', '', '0', '');
INSERT INTO `auth_rule` VALUES ('78', 'admin/Layer/files', '附件选择器', '1', '0', '54', '', '0', '');
INSERT INTO `auth_rule` VALUES ('31', 'admin/AuthGroup/add', '添加权限组', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('32', 'admin/AuthGroup/save', '保存权限组', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('33', 'admin/AuthGroup/edit', '编辑权限组', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('34', 'admin/AuthGroup/update', '更新权限组', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('35', 'admin/AuthGroup/delete', '删除权限组', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('36', 'admin/AuthGroup/auth', '授权', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('37', 'admin/AuthGroup/updateAuthGroupRule', '更新权限组规则', '1', '0', '19', '', '0', '');
INSERT INTO `auth_rule` VALUES ('44', 'admin/User/add', '添加用户', '1', '0', '17', '', '0', '');
INSERT INTO `auth_rule` VALUES ('45', 'admin/User/save', '保存用户', '1', '0', '17', '', '0', '');
INSERT INTO `auth_rule` VALUES ('46', 'admin/User/edit', '编辑用户', '1', '0', '17', '', '0', '');
INSERT INTO `auth_rule` VALUES ('47', 'admin/User/update', '更新用户', '1', '0', '17', '', '0', '');
INSERT INTO `auth_rule` VALUES ('48', 'admin/User/delete', '删除用户', '1', '0', '17', '', '0', '');
INSERT INTO `auth_rule` VALUES ('49', 'admin/AdminUser/add', '添加管理员', '1', '0', '18', '', '0', '');
INSERT INTO `auth_rule` VALUES ('50', 'admin/AdminUser/save', '保存管理员', '1', '0', '18', '', '0', '');
INSERT INTO `auth_rule` VALUES ('51', 'admin/AdminUser/edit', '编辑管理员', '1', '0', '18', '', '0', '');
INSERT INTO `auth_rule` VALUES ('52', 'admin/AdminUser/update', '更新管理员', '1', '0', '18', '', '0', '');
INSERT INTO `auth_rule` VALUES ('53', 'admin/AdminUser/delete', '删除管理员', '1', '0', '18', '', '0', '');
INSERT INTO `auth_rule` VALUES ('54', 'admin/Slide/default', '扩展管理', '1', '0', '0', 'icon-expert', '0', '');
INSERT INTO `auth_rule` VALUES ('73', 'admin/ChangePassword/index', '修改密码', '1', '1', '1', '', '0', '');
INSERT INTO `auth_rule` VALUES ('74', 'admin/ChangePassword/updatePassword', '更新密码', '1', '0', '1', '', '0', '');

-- ----------------------------
-- Table structure for files
-- ----------------------------
DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '1-正常 0-不可訪問',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of files
-- ----------------------------
INSERT INTO `files` VALUES ('1', '640 (2).gif', '/uploads/20180808/b0302c441540cecc7a31acf9947cea5a.gif', null, '1');
INSERT INTO `files` VALUES ('2', '640 (2).gif', '/uploads/20180808/9e79c0530608147a1ee98a704bc0a121.gif', null, '1');
INSERT INTO `files` VALUES ('3', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/ffeb805df671a49e5131ec5e15ecff41.gif', '2018-08-08 23:17:10', '1');
INSERT INTO `files` VALUES ('4', '640.gif', '/uploads/20180808/53d52fcf8595a01856a6e3c261cb092a.gif', '2018-08-08 23:24:13', '1');
INSERT INTO `files` VALUES ('5', '2760732_0443b37429fb2970fe6a2654977ccd87_1533476884.gif', '/uploads/20180808/70acd1ec35831ab6d31a06132b05a675.gif', '2018-08-08 23:24:44', '1');
INSERT INTO `files` VALUES ('6', '640 (1).gif', '/uploads/20180808/5764c55a56efe5faa056c97a7d5dbc70.gif', '2018-08-08 23:25:19', '1');
INSERT INTO `files` VALUES ('7', '640 (1).gif', '/uploads/20180808/6ab9f1f0dac97412b60679dd90ce2c3d.gif', '2018-08-08 23:26:27', '1');
INSERT INTO `files` VALUES ('8', '640 (2).gif', '/uploads/20180808/cdc1d2f6626d8ac5690f6c3d57fc378d.gif', '2018-08-08 23:26:28', '1');
INSERT INTO `files` VALUES ('9', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/7894d9ecf08ece743ab3143f7778ba7a.gif', '2018-08-08 23:26:29', '1');
INSERT INTO `files` VALUES ('10', '640 (1).gif', '/uploads/20180808/cc91692641f7c463bec5ad15eaf9b031.gif', '2018-08-08 23:26:59', '1');
INSERT INTO `files` VALUES ('11', '640 (2).gif', '/uploads/20180808/58561e3f1cb5b5178f7b7a3d3115c5c2.gif', '2018-08-08 23:27:00', '1');
INSERT INTO `files` VALUES ('12', '微信图片_20180615162758.gif', '/uploads/20180808/c077ec09a4765fff4bd381edef316c77.gif', '2018-08-08 23:28:57', '1');
INSERT INTO `files` VALUES ('13', '640 (1).gif', '/uploads/20180808/82d2ef2fad853bf787e6df223cc44869.gif', '2018-08-08 23:29:13', '1');
INSERT INTO `files` VALUES ('14', '640 (4).gif', '/uploads/20180808/356fc92a6d787e345c3201a40168f74a.gif', '2018-08-08 23:29:13', '1');
INSERT INTO `files` VALUES ('15', '640-(11).gif', '/uploads/20180808/5c5ad516616699c4791b9139209a575d.gif', '2018-08-08 23:29:13', '1');
INSERT INTO `files` VALUES ('16', '640 (2).gif', '/uploads/20180808/01441d55d910b24899afd0428b238cd8.gif', '2018-08-08 23:29:13', '1');
INSERT INTO `files` VALUES ('17', '640 (3).gif', '/uploads/20180808/f1163850d1ed7bdfe3ab472457c4f78c.gif', '2018-08-08 23:29:14', '1');
INSERT INTO `files` VALUES ('18', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/6e386ff2dd9e7e85652c156b4ad110ff.gif', '2018-08-08 23:29:14', '1');
INSERT INTO `files` VALUES ('19', '640.gif', '/uploads/20180808/a96074e1ecf76774fdffa41fe49fac42.gif', '2018-08-08 23:29:14', '1');
INSERT INTO `files` VALUES ('20', '640 (1).gif', '/uploads/20180808/af2973a2f0ce0212ebec46ff25fe56d2.gif', '2018-08-08 23:30:32', '1');
INSERT INTO `files` VALUES ('21', '640 (4).gif', '/uploads/20180808/acfb883cf062ed80c0eed51e85e852bc.gif', '2018-08-08 23:30:32', '1');
INSERT INTO `files` VALUES ('22', '640 (2).gif', '/uploads/20180808/615f2f208a2b712571a42072d863a7e7.gif', '2018-08-08 23:30:32', '1');
INSERT INTO `files` VALUES ('23', '640-(11).gif', '/uploads/20180808/21d641f087e2fd0f0b945dca4b836c08.gif', '2018-08-08 23:30:32', '1');
INSERT INTO `files` VALUES ('24', '640 (3).gif', '/uploads/20180808/f0b9422836bd5291ec3019d05c1e6fbc.gif', '2018-08-08 23:30:33', '1');
INSERT INTO `files` VALUES ('25', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/971dff6834f434f33edc1ca4b2a52a9d.gif', '2018-08-08 23:30:33', '1');
INSERT INTO `files` VALUES ('26', '640 (4).gif', '/uploads/20180808/3071ac9904b736cf3ee515006eb188c5.gif', '2018-08-08 23:31:14', '1');
INSERT INTO `files` VALUES ('27', '640-(11).gif', '/uploads/20180808/a2f5c6153ab1624d55b10c5dd0b400ee.gif', '2018-08-08 23:31:14', '1');
INSERT INTO `files` VALUES ('28', '640 (3).gif', '/uploads/20180808/2f6bdec01e5602395a0d893794ea1b3c.gif', '2018-08-08 23:31:14', '1');
INSERT INTO `files` VALUES ('29', '640 (1).gif', '/uploads/20180808/3b0950ff49de6682681873f98daacfaf.gif', '2018-08-08 23:31:27', '1');
INSERT INTO `files` VALUES ('30', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/22528a0b247745fb2a21550f6614ef93.gif', '2018-08-08 23:31:27', '1');
INSERT INTO `files` VALUES ('38', '640 (1).gif', '/uploads/20180809/f80a00d3be2dbd6e2c6913547c584003.gif', '2018-08-09 13:20:44', '1');
INSERT INTO `files` VALUES ('32', '640 (2).gif', '/uploads/20180808/5683aa0553f6bcf4757ece2f91508296.gif', '2018-08-08 23:32:11', '1');
INSERT INTO `files` VALUES ('33', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180808/ed6adddae39b7bb5d64734160f6b4dfa.gif', '2018-08-08 23:32:11', '1');
INSERT INTO `files` VALUES ('34', '640 (4).gif', '/uploads/20180808/eb4319cd6454f85cb5a197f88c0cbf45.gif', '2018-08-08 23:46:13', '1');
INSERT INTO `files` VALUES ('35', '640.gif', '/uploads/20180808/f53439fae44a360702378176eedcedae.gif', '2018-08-08 23:46:13', '1');
INSERT INTO `files` VALUES ('36', '640-(11).gif', '/uploads/20180808/755ec80f6e393a1d7df74d0696c4b7f1.gif', '2018-08-08 23:46:13', '1');
INSERT INTO `files` VALUES ('37', '640 (3).gif', '/uploads/20180808/983e205682562972d9ee426825607fa0.gif', '2018-08-08 23:46:14', '1');
INSERT INTO `files` VALUES ('39', '640 (2).gif', '/uploads/20180809/f9bd31fef161177d0b2591ed18da2094.gif', '2018-08-09 13:20:44', '1');
INSERT INTO `files` VALUES ('40', '7e2b9114gy1ftzow0esk7g207607sx6p.gif', '/uploads/20180809/7397a6312ab23158170e9edf191b159a.gif', '2018-08-09 13:20:45', '1');

-- ----------------------------
-- Table structure for system
-- ----------------------------
DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '配置项名称',
  `value` text NOT NULL COMMENT '配置项值',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of system
-- ----------------------------
INSERT INTO `system` VALUES ('1', 'site_config', 'a:7:{s:10:\"site_title\";s:29:\"Think Admin后台管理系统\";s:9:\"seo_title\";s:0:\"\";s:11:\"seo_keyword\";s:0:\"\";s:15:\"seo_description\";s:0:\"\";s:14:\"site_copyright\";s:0:\"\";s:8:\"site_icp\";s:0:\"\";s:11:\"site_tongji\";s:0:\"\";}');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `avatar` int(11) DEFAULT NULL,
  `password` varchar(50) NOT NULL COMMENT '密码',
  `mobile` varchar(11) DEFAULT '' COMMENT '手机',
  `email` varchar(50) DEFAULT '' COMMENT '邮箱',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '用户状态  1 正常  2 禁止',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登陆时间',
  `last_login_ip` varchar(50) DEFAULT '' COMMENT '最后登录IP',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'test', '30', 'b9b433cfeb75458aea0cd77cef76f5bf', '', '33@qq.com', '1', '2018-08-08 20:38:19', null, '');