-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathicesadmin.sql
More file actions
executable file
·141 lines (126 loc) · 6.42 KB
/
icesadmin.sql
File metadata and controls
executable file
·141 lines (126 loc) · 6.42 KB
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
/*
Navicat MySQL Data Transfer
Source Server : MyMac
Source Server Type : MySQL
Source Server Version : 50505
Source Host : localhost
Source Database : chejiaosuo
Target Server Type : MySQL
Target Server Version : 50505
File Encoding : utf-8
Date: 07/14/2018 15:18:59 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `ices_admin_group`
-- ----------------------------
DROP TABLE IF EXISTS `ices_admin_group`;
CREATE TABLE `ices_admin_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 '',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`deletetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `ices_admin_group`
-- ----------------------------
BEGIN;
INSERT INTO `ices_admin_group` VALUES ('1', '超级管理员', '1', '1,2,3,4,5,6,7,8', null, null, null), ('2', '系统管理员', '1', '1,2', null, null, null), ('3', '其他管理员', '1', '1', null, '2018-07-01 16:26:13', '2018-07-01 16:26:13'), ('5', '系统管理员', '0', '1,2', null, '2018-07-01 16:27:52', '2018-07-01 16:27:52');
COMMIT;
-- ----------------------------
-- Table structure for `ices_admin_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `ices_admin_group_access`;
CREATE TABLE `ices_admin_group_access` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`group_id` mediumint(8) unsigned NOT NULL,
`type` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uid_group_id` (`uid`,`group_id`,`type`) USING BTREE,
KEY `uid` (`uid`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `ices_admin_group_access`
-- ----------------------------
BEGIN;
INSERT INTO `ices_admin_group_access` VALUES ('1', '1', '1', '0');
COMMIT;
-- ----------------------------
-- Table structure for `ices_admin_member`
-- ----------------------------
DROP TABLE IF EXISTS `ices_admin_member`;
CREATE TABLE `ices_admin_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`realname` varchar(100) DEFAULT NULL,
`password` varchar(41) NOT NULL,
`salt` varchar(10) DEFAULT '',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`deletetime` datetime DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '0',
`theme` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of `ices_admin_member`
-- ----------------------------
BEGIN;
INSERT INTO `ices_admin_member` VALUES ('1', 'admin', '11111111111', '超级管理员', '7c1d9ac16bced96952624e0aaaa038d882b36245', '478543', '2018-06-28 15:27:50', '2018-06-29 17:07:09', null, '1', null);
COMMIT;
-- ----------------------------
-- Table structure for `ices_admin_menu`
-- ----------------------------
DROP TABLE IF EXISTS `ices_admin_menu`;
CREATE TABLE `ices_admin_menu` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`pid` smallint(6) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
`title` varchar(20) NOT NULL COMMENT '菜单名称',
`jump` varchar(50) DEFAULT NULL COMMENT '链接',
`icon` varchar(50) DEFAULT NULL COMMENT '字体图标',
`sort` smallint(6) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`deletetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='菜单表';
-- ----------------------------
-- Records of `ices_admin_menu`
-- ----------------------------
BEGIN;
INSERT INTO `ices_admin_menu` VALUES ('1', '0', 'user', '用户设置', 'user', 'layui-icon-user', '1', null, '2018-07-14 15:07:13', null), ('2', '1', 'administrators-list', '后台管理员', './admin/list', null, '2', null, null, null), ('3', '1', 'administrators-rule', '角色管理', './admin/role', null, '3', null, null, null), ('4', '1', 'user-rule', '规则设置', '../../icesadminview/rule', null, '4', null, null, null), ('5', '1', 'menu', '菜单设置', '../../icesadminview/menu', null, '5', null, '2018-07-02 18:45:11', null), ('32', '0', 'showtest', '后台演示', 'showtest', 'layui-icon-util', '2', '2018-07-11 13:08:06', '2018-07-11 13:08:06', null), ('33', '32', 'showtest-form', 'Form演示', '../../manage/view/form', 'layui-icon-form', '3', '2018-07-11 13:12:02', '2018-07-11 13:12:02', null), ('34', '32', 'showtest-table', 'Table演示', '../../manage/view/table', 'layui-icon-table', '4', '2018-07-11 13:12:35', '2018-07-11 13:12:35', null);
COMMIT;
-- ----------------------------
-- Table structure for `ices_admin_rule`
-- ----------------------------
DROP TABLE IF EXISTS `ices_admin_rule`;
CREATE TABLE `ices_admin_rule` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` char(80) NOT NULL DEFAULT '',
`title` char(20) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '1',
`condition` char(100) NOT NULL DEFAULT '',
`mid` int(8) NOT NULL,
`type` tinyint(2) NOT NULL DEFAULT '1',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`deletetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `ices_admin_rule`
-- ----------------------------
BEGIN;
INSERT INTO `ices_admin_rule` VALUES ('1', 'user', '后台用户设置', '1', '', '0', '1', null, '2018-07-11 13:04:10', null), ('2', './admin/list', '后台管理员设置', '1', '', '1', '1', null, null, null), ('3', './admin/role', '角色设置', '1', '', '1', '1', null, null, null), ('4', '../../icesadminview/rule', '规则设置', '1', '', '1', '1', null, null, null), ('5', '../../icesadminview/menu', '菜单设置', '1', '', '1', '1', null, '2018-07-02 18:33:53', null), ('6', 'showtest', '后台演示', '1', '', '0', '1', '2018-07-11 13:08:26', '2018-07-11 13:08:26', null), ('7', '../../manage/view/form', 'Form演示', '1', '', '6', '1', '2018-07-11 13:12:59', '2018-07-11 13:12:59', null), ('8', '../../manage/view/table', 'Table演示', '1', '', '6', '1', '2018-07-12 12:21:20', '2018-07-12 12:21:20', null);
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;