-
Notifications
You must be signed in to change notification settings - Fork 14
/
tp10.sql
122 lines (110 loc) · 6.07 KB
/
tp10.sql
1
2
3
4
5
6
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50547
Source Host : localhost:3306
Source Database : tp10
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2016-06-26 11:38:45
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- 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` char(80) NOT NULL DEFAULT '',
`description` text COMMENT '描述',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auth_group
-- ----------------------------
INSERT INTO `auth_group` VALUES ('1', '管理员', '1', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17', '', '0', '1466780039');
INSERT INTO `auth_group` VALUES ('6', '初级管理员', '1', '11,6', '初级管理员', '1466910557', '1466910596');
-- ----------------------------
-- 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;
-- ----------------------------
-- 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` char(80) NOT NULL DEFAULT '',
`title` char(20) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '1',
`status` tinyint(1) NOT NULL DEFAULT '1',
`condition` char(100) NOT NULL DEFAULT '',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`pid` mediumint(8) unsigned NOT NULL,
`path` varchar(100) NOT NULL,
`sort` int(11) NOT NULL DEFAULT '0',
`is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auth_rule
-- ----------------------------
INSERT INTO `auth_rule` VALUES ('1', 'admin/main/index', '控制面板', '1', '1', '', '0', '0', '0', '0', '1', '1');
INSERT INTO `auth_rule` VALUES ('2', '', '系统', '1', '1', '', '0', '1466909995', '0', '0', '200', '1');
INSERT INTO `auth_rule` VALUES ('3', 'admin/auth_group/index', '角色管理', '1', '1', '', '0', '0', '2', '0-2', '1', '1');
INSERT INTO `auth_rule` VALUES ('4', 'admin/auth_rule/index', '权限列表', '1', '1', '', '0', '1466746258', '2', '0-2', '2', '1');
INSERT INTO `auth_rule` VALUES ('5', 'admin/auth_rule/add', '添加权限', '1', '1', '', '0', '1466686168', '4', '0-2-4', '1', '0');
INSERT INTO `auth_rule` VALUES ('6', 'admin/user/logout', '退出登录', '1', '1', '', '0', '0', '0', '0', '0', '0');
INSERT INTO `auth_rule` VALUES ('7', 'admin/auth_group/add', '添加角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0');
INSERT INTO `auth_rule` VALUES ('8', 'admin/auth_group/edit', '编辑角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0');
INSERT INTO `auth_rule` VALUES ('9', 'admin/auth_group/del', '删除角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0');
INSERT INTO `auth_rule` VALUES ('10', 'admin/auth_rule/edit', '编辑权限', '1', '1', '', '0', '1466686416', '4', '0-2-4', '2', '0');
INSERT INTO `auth_rule` VALUES ('11', 'admin/user/changePwd', '修改密码', '1', '1', '', '1466688085', '1466688085', '0', '0', '0', '0');
INSERT INTO `auth_rule` VALUES ('12', 'admin/auth_group/resource', '资源管理', '1', '1', '', '1466688887', '1466688887', '3', '0-2-3', '0', '0');
INSERT INTO `auth_rule` VALUES ('13', 'admin/user/index', '用户管理', '1', '1', '', '1466778713', '1466778747', '2', '0-2', '0', '1');
INSERT INTO `auth_rule` VALUES ('14', 'admin/user/edit', '编辑用户', '1', '1', '', '1466779374', '1466779374', '13', '0-2-13', '0', '0');
INSERT INTO `auth_rule` VALUES ('15', 'admin/user/del', '删除用户', '1', '1', '', '1466779400', '1466779400', '13', '0-2-13', '0', '0');
INSERT INTO `auth_rule` VALUES ('16', 'admin/user/add', '添加用户', '1', '1', '', '1466780028', '1466780028', '13', '0-2-13', '0', '0');
INSERT INTO `auth_rule` VALUES ('17', 'admin/auth_rule/del', '删除权限', '1', '1', '', '1466911172', '1466911172', '4', '0-2-4', '0', '0');
-- ----------------------------
-- Table structure for ucenter_member
-- ----------------------------
DROP TABLE IF EXISTS `ucenter_member`;
CREATE TABLE `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 DEFAULT '' COMMENT '用户手机',
`reg_ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
`last_login_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
`last_login_ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
`status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of ucenter_member
-- ----------------------------
INSERT INTO `ucenter_member` VALUES ('1', 'admin', '779d005fa526b871d424fcab8140582f', '[email protected]', '18053449656', '0', '1466909925', '2130706433', '1', '0', '1466909925');
INSERT INTO `ucenter_member` VALUES ('3', 'test123', '779d005fa526b871d424fcab8140582f', '', '', '127.0.0.1', '0', '0', '1', '1466910101', '1466910142');