/*
SQLyog Ultimate v11.28 (64 bit)
MySQL - 5.5.40 : Database - thinkadmin
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`thinkadmin` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `thinkadmin`;

/*Table structure for table `think_auth_group` */

DROP TABLE IF EXISTS `think_auth_group`;

CREATE TABLE `think_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `rules` char(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户组表';

/*Data for the table `think_auth_group` */

insert  into `think_auth_group`(`id`,`title`,`status`,`rules`) values (1,'管理组',1,'1,2,11,13,12,14,17,18,43,44,45,46,32,36,37,38,39,16,40,41,42'),(2,'新闻一组',1,'6,8'),(3,'新闻二组',1,''),(4,'运维一组',1,'1,4'),(5,'运维二组',1,'1,5');

/*Table structure for table `think_auth_group_access` */

DROP TABLE IF EXISTS `think_auth_group_access`;

CREATE TABLE `think_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='用户组明细表';

/*Data for the table `think_auth_group_access` */

insert  into `think_auth_group_access`(`uid`,`group_id`) values (1,1),(1,2),(2,1),(2,2);

/*Table structure for table `think_auth_rule` */

DROP TABLE IF EXISTS `think_auth_rule`;

CREATE TABLE `think_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(9) DEFAULT '0',
  `pth` varchar(30) DEFAULT '' COMMENT '记录菜单的层级关系',
  `name` char(80) NOT NULL DEFAULT '',
  `title` char(20) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `sort` tinyint(4) DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:显示 0:隐藏',
  `condition` char(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='规则表';

/*Data for the table `think_auth_rule` */

insert  into `think_auth_rule`(`id`,`parent_id`,`pth`,`name`,`title`,`type`,`sort`,`status`,`condition`) values (1,0,'0,1','','控制台',1,0,1,''),(2,1,'0,1,2','adminer/index/welcome','欢迎',1,0,1,''),(3,1,'0,1,3','','缓存',1,0,1,''),(4,1,'0,1,4','','报表',1,0,1,''),(5,1,'0,1,5','','备份',1,0,1,''),(6,0,'0,6','','站务管理',1,1,1,''),(7,6,'0,6,7','','网站菜单',1,0,1,''),(8,6,'0,6,8','adminer/news/index','新闻',1,0,1,''),(9,6,'0,6,9','','广告',1,0,1,''),(10,6,'0,6,10','','友链',1,0,1,''),(11,0,'0,11','','会员服务',1,2,1,''),(12,11,'0,11,12','','用户管理',1,0,1,''),(13,11,'0,11,13','','短信管理',1,0,1,''),(14,0,'0,14','','系统',1,3,1,''),(15,14,'0,14,15','','设置',1,0,1,''),(16,14,'0,14,16','adminer/system/menuList','菜单',1,0,1,''),(17,14,'0,14,17','','权限',1,0,1,''),(18,17,'0,14,17,18','adminer/member/index','管理员',1,0,1,''),(19,14,'0,14,19','','日志',1,0,1,''),(20,1,'0,1,20','','运维',1,0,1,''),(21,0,'0,21','','其他',1,4,1,''),(22,21,'0,21,22','','游戏',1,0,1,''),(23,22,'0,21,22,23','','小转盘',1,0,1,''),(24,22,'0,21,22,24','','大转盘',1,0,1,''),(36,32,'0,14,17,32,36','adminer/group/add','增加角色',1,0,0,''),(35,21,'0,21,35','','备忘录',1,1,1,''),(32,17,'0,14,17,32','adminer/group/index','角色',1,0,1,''),(33,21,'0,21,33','','工具',1,0,1,''),(34,33,'0,21,33,34','','缓存清理',1,0,1,''),(37,32,'0,14,17,32,37','adminer/group/edit','编辑角色',1,1,0,''),(38,32,'0,14,17,32,38','','禁用角色',1,2,0,''),(39,32,'0,14,17,32,39','adminer/group/grantAuth','授权角色',1,3,0,''),(40,16,'0,14,16,40','adminer/system/addMenu','添加菜单',1,0,0,''),(41,16,'0,14,16,41','adminer/system/editMenu','编辑菜单',1,1,0,''),(42,16,'0,14,16,42','adminer/system/delMenu','删除菜单',1,2,0,''),(43,18,'0,14,17,18,43','adminer/member/','管理员添加',1,0,0,''),(44,18,'0,14,17,18,44','adminer/member/edit','管理员编辑',1,1,0,''),(45,18,'0,14,17,18,45','adminer/index/editPassword','管理员改密',1,2,0,''),(46,18,'0,14,17,18,46','adminer/member/grant','管理员授权',1,3,0,'');

/*Table structure for table `think_auth_user` */

DROP TABLE IF EXISTS `think_auth_user`;

CREATE TABLE `think_auth_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` char(32) NOT NULL,
  `phone` char(11) NOT NULL COMMENT '操作管理员的手机号码',
  `salt` varchar(8) NOT NULL DEFAULT '' COMMENT '随机因子',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1:启用 0:禁止',
  `super` tinyint(1) DEFAULT '0' COMMENT '1:超级管理员 0:普通管理员',
  `remark` varchar(255) NOT NULL COMMENT '备注说明',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `last_login_time` datetime NOT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `last_location` varchar(100) NOT NULL DEFAULT '0' COMMENT '最后登录位置',
  PRIMARY KEY (`id`),
  KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='AUTH-权限管理-后台管理员用户表';

/*Data for the table `think_auth_user` */

insert  into `think_auth_user`(`id`,`username`,`password`,`phone`,`salt`,`status`,`super`,`remark`,`create_at`,`last_login_time`,`last_login_ip`,`last_location`) values (1,'admin','1fd94b7170dc92c3a7bb642446fc5d30','','AQ2re5',1,1,'超级管理员','2018-04-12 20:27:20','0000-00-00 00:00:00','0','0'),(2,'guest','b62581104c99079c5b14ec51979b1b59','','voBMjD',1,0,'','2018-05-15 12:39:29','0000-00-00 00:00:00','0','0');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;