iceui/rootproject.sql at master · yirius/iceui · GitHub

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
/*
 Navicat MySQL Data Transfer

 Source Server         : MyMac
 Source Server Type    : MySQL
 Source Server Version : 50505
 Source Host           : localhost
 Source Database       : rootproject

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

 Date: 02/18/2018 21:39:03 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ices_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `ices_auth_group`;
CREATE TABLE `ices_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `rules` longtext NOT NULL,
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `ices_auth_group`
-- ----------------------------
BEGIN;
INSERT INTO `ices_auth_group` VALUES ('1', '超级管理员', '1', 'all', '2017-05-09 20:39:20', '2018-02-18 01:17:08'), ('2', '管理员测试', '1', '1,3,4,2,10,11', '2018-02-18 12:18:28', '2018-02-18 12:40:50');
COMMIT;

-- ----------------------------
--  Table structure for `ices_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `ices_auth_rule`;
CREATE TABLE `ices_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(80) NOT NULL DEFAULT '',
  `text` char(20) NOT NULL DEFAULT '',
  `icon` varchar(100) DEFAULT NULL,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '//1是路由认证，2是界面认证，3是其他补充认证',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `condition` char(100) NOT NULL DEFAULT '',
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  `list_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `ices_auth_rule`
-- ----------------------------
BEGIN;
INSERT INTO `ices_auth_rule` VALUES ('1', '/manage', '系统设置', 'wb-settings', '0', '1', '1', '', '2017-05-09 11:07:27', '2018-02-17 22:29:39', '1'), ('2', '/welcome', '后台欢迎界面', null, '1', '3', '1', '', '2017-05-09 11:16:09', null, '0'), ('3', '/icesui/setting', '框架设置', 'fa-bars', '1', '2', '1', '', '2018-01-01 20:17:01', '2018-02-17 11:07:45', '2'), ('4', '/icesui/setting/group', '角色设置', null, '3', '2', '1', '', '2018-01-27 15:45:42', '2018-02-17 11:07:45', '3'), ('5', '/icesui/setting/groupadd', '角色编辑', 'wb-settings', '4', '3', '1', '', '2018-02-18 13:19:02', '2018-02-18 13:19:04', '0'), ('6', '/icesui/setting/menu', '菜单设置', 'wb-settings', '3', '2', '1', '', '2018-01-19 14:54:18', '2018-02-17 11:07:45', '4'), ('7', '/icesui/setting/domenu', '菜单编辑', 'wb-settings', '6', '3', '1', '', '2018-02-18 13:20:15', '2018-02-18 13:20:16', '0'), ('8', '/icesui/setting/addtopmenu', '添加顶部菜单', 'wb-settings', '6', '3', '1', '', '2018-02-18 13:20:55', '2018-02-18 13:20:57', '0'), ('9', '/theme', '主题管理', 'wb-settings', '1', '3', '1', '', '2018-02-18 15:50:54', '2018-02-18 15:50:56', '0'), ('10', '/icesui/setting/users', '管理员设置', 'wb-settings', '3', '2', '1', '', '2018-02-18 12:20:28', '2018-02-18 12:20:30', '0'), ('11', '/icesui/setting/usersadd', '管理员编辑', 'wb-settings', '10', '3', '1', '', '2018-02-18 12:50:52', '2018-02-18 12:50:53', '0');
COMMIT;

-- ----------------------------
--  Table structure for `ices_auth_user`
-- ----------------------------
DROP TABLE IF EXISTS `ices_auth_user`;
CREATE TABLE `ices_auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `phone` bigint(11) DEFAULT NULL,
  `realname` varchar(100) DEFAULT NULL,
  `password` varchar(41) NOT NULL,
  `group_id` int(1) NOT NULL DEFAULT '0',
  `salt` varchar(10) DEFAULT '',
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  `isdelete` int(1) NOT NULL DEFAULT '0',
  `theme` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `ices_auth_user`
-- ----------------------------
BEGIN;
INSERT INTO `ices_auth_user` VALUES ('1', '12345678912', '11111111111', 'Yang', '71dd07494c5ee54992a27746d547e25dee01bd97', '1', '123456', '2017-01-23 15:38:45', '2017-06-30 18:38:23', '0', '{\"navigationColor\":\"bg-cyan-600\",\"acrossFlag\":\"navbar-inverse\",\"menuTheme\":\"site-menubar-light\",\"menuDisplay\":\"site-menubar-unfold\",\"menuTxtIcon\":\"site-menubar-keep\",\"themeColor\":\"cyan\",\"tabFlag\":\"site-contabs-open\"}'), ('2', '12345678912', '11111111112', 'Wang', 'bcc24a4dc43058e660d8a5f5bd46702879948f5d', '2', 'Tplk6e', '2018-02-18 12:41:11', '2018-02-18 12:41:11', '0', '{\"navigationColor\":\"bg-green-600\",\"acrossFlag\":\"navbar-inverse\",\"menuTheme\":\"site-menubar-dark\",\"menuDisplay\":\"site-menubar-unfold\",\"menuTxtIcon\":\"site-menubar-keep\",\"themeColor\":\"primary\",\"tabFlag\":\"site-contabs-open\"}');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;