Skip to content

Commit 58c7693

Browse files
lmxdawnlmxdawn
committed
优化数据库
1 parent d39d256 commit 58c7693

File tree

1 file changed

+26
-26
lines changed

1 file changed

+26
-26
lines changed

‎vue-admin.sql

Lines changed: 26 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -73,8 +73,8 @@ CREATE TABLE `auth_admin` (
7373
`avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
7474
`sex` smallint(1) NOT NULL DEFAULT '0' COMMENT '性别；0：保密，1：男；2：女',
7575
`last_login_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '最后登录ip',
76-
`last_login_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '最后登录时间',
77-
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '注册时间',
76+
`last_login_time` datetime NOT NULL COMMENT '最后登录时间',
77+
`create_time` datetime NOT NULL COMMENT '注册时间',
7878
`status` int(11) NOT NULL DEFAULT '1' COMMENT '用户状态 0：禁用； 1：正常 ；2：未验证',
7979
PRIMARY KEY (`id`),
8080
KEY `user_login_key` (`username`)
@@ -83,7 +83,7 @@ CREATE TABLE `auth_admin` (
8383
-- ----------------------------
8484
-- Records of auth_admin
8585
-- ----------------------------
86-
INSERT INTO `auth_admin` VALUES ('1', 'admin', 'c3284d0f94606de1fd2af172aba15bf3', 'admin', 'lmxdawn@gmail.com', 'sssss', '0', '127.0.0.1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1');
86+
INSERT INTO `auth_admin` VALUES ('1', 'admin', 'c3284d0f94606de1fd2af172aba15bf3', 'admin', 'lmxdawn@gmail.com', 'sssss', '0', '127.0.0.1', '2018-11-23 10:23:52', '2018-11-23 10:23:52', '1');
8787

8888
-- ----------------------------
8989
-- Table structure for auth_permission
@@ -116,30 +116,30 @@ CREATE TABLE `auth_permission_rule` (
116116
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：为1正常，为0禁用',
117117
`condition` char(100) NOT NULL DEFAULT '' COMMENT '规则表达式，为空表示存在就验证，不为空表示按照条件验证',
118118
`listorder` int(10) NOT NULL DEFAULT '0' COMMENT '排序，优先级，越小优先级越高',
119-
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
120-
`update_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
119+
`create_time` datetime NOT NULL COMMENT '创建时间',
120+
`update_time` datetime NOT NULL COMMENT '更新时间',
121121
PRIMARY KEY (`id`),
122122
UNIQUE KEY `name` (`name`)
123123
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='规则表';
124124

125125
-- ----------------------------
126126
-- Records of auth_permission_rule
127127
-- ----------------------------
128-
INSERT INTO `auth_permission_rule` VALUES ('1', '0', '0', 'user_manage', '用户管理', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
129-
INSERT INTO `auth_permission_rule` VALUES ('2', '1', '0', 'user_manage/admin_manage', '管理组1', '1', '', '999', '0000-00-00 00:00:00', '2018-11-23 10:23:52');
130-
INSERT INTO `auth_permission_rule` VALUES ('3', '2', '0', 'admin/auth/admin/index', '管理员管理', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
131-
INSERT INTO `auth_permission_rule` VALUES ('4', '3', '0', 'admin/auth/admin/save', '添加管理员', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
132-
INSERT INTO `auth_permission_rule` VALUES ('5', '3', '0', 'admin/auth/admin/edit', '编辑管理员', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
133-
INSERT INTO `auth_permission_rule` VALUES ('6', '3', '0', 'admin/auth/admin/delete', '删除管理员', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
134-
INSERT INTO `auth_permission_rule` VALUES ('7', '2', '0', 'admin/auth/role/index', '角色管理', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
135-
INSERT INTO `auth_permission_rule` VALUES ('8', '7', '0', 'admin/auth/role/save', '添加角色', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
136-
INSERT INTO `auth_permission_rule` VALUES ('9', '7', '0', 'admin/auth/role/edit', '编辑角色', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
137-
INSERT INTO `auth_permission_rule` VALUES ('10', '7', '0', 'admin/auth/role/delete', '删除角色', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
138-
INSERT INTO `auth_permission_rule` VALUES ('11', '7', '0', 'admin/auth/role/auth', '角色授权', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
139-
INSERT INTO `auth_permission_rule` VALUES ('12', '2', '0', 'admin/auth/permission_rule/index', '权限管理', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
140-
INSERT INTO `auth_permission_rule` VALUES ('13', '12', '0', 'admin/auth/permission_rule/save', '添加权限', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
141-
INSERT INTO `auth_permission_rule` VALUES ('14', '12', '0', 'admin/auth/permission_rule/edit', '编辑权限', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
142-
INSERT INTO `auth_permission_rule` VALUES ('15', '12', '0', 'admin/auth/permission_rule/delete', '删除权限', '1', '', '999', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
128+
INSERT INTO `auth_permission_rule` VALUES ('1', '0', '0', 'user_manage', '用户管理', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
129+
INSERT INTO `auth_permission_rule` VALUES ('2', '1', '0', 'user_manage/admin_manage', '管理组1', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
130+
INSERT INTO `auth_permission_rule` VALUES ('3', '2', '0', 'admin/auth/admin/index', '管理员管理', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
131+
INSERT INTO `auth_permission_rule` VALUES ('4', '3', '0', 'admin/auth/admin/save', '添加管理员', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
132+
INSERT INTO `auth_permission_rule` VALUES ('5', '3', '0', 'admin/auth/admin/edit', '编辑管理员', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
133+
INSERT INTO `auth_permission_rule` VALUES ('6', '3', '0', 'admin/auth/admin/delete', '删除管理员', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
134+
INSERT INTO `auth_permission_rule` VALUES ('7', '2', '0', 'admin/auth/role/index', '角色管理', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
135+
INSERT INTO `auth_permission_rule` VALUES ('8', '7', '0', 'admin/auth/role/save', '添加角色', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
136+
INSERT INTO `auth_permission_rule` VALUES ('9', '7', '0', 'admin/auth/role/edit', '编辑角色', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
137+
INSERT INTO `auth_permission_rule` VALUES ('10', '7', '0', 'admin/auth/role/delete', '删除角色', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
138+
INSERT INTO `auth_permission_rule` VALUES ('11', '7', '0', 'admin/auth/role/auth', '角色授权', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
139+
INSERT INTO `auth_permission_rule` VALUES ('12', '2', '0', 'admin/auth/permission_rule/index', '权限管理', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
140+
INSERT INTO `auth_permission_rule` VALUES ('13', '12', '0', 'admin/auth/permission_rule/save', '添加权限', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
141+
INSERT INTO `auth_permission_rule` VALUES ('14', '12', '0', 'admin/auth/permission_rule/edit', '编辑权限', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
142+
INSERT INTO `auth_permission_rule` VALUES ('15', '12', '0', 'admin/auth/permission_rule/delete', '删除权限', '1', '', '999', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
143143

144144
-- ----------------------------
145145
-- Table structure for auth_role
@@ -151,16 +151,16 @@ CREATE TABLE `auth_role` (
151151
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
152152
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
153153
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
154-
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
155-
`update_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
156-
`listorder` int(3) NOT NULL DEFAULT '0' COMMENT '排序，优先级，越小优先级越高',
154+
`listorder` int(10) NOT NULL DEFAULT '0' COMMENT '排序，优先级，越小优先级越高',
155+
`create_time` datetime NOT NULL COMMENT '创建时间',
156+
`update_time` datetime NOT NULL COMMENT '更新时间',
157157
PRIMARY KEY (`id`)
158158
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色表';
159159

160160
-- ----------------------------
161161
-- Records of auth_role
162162
-- ----------------------------
163-
INSERT INTO `auth_role` VALUES ('1', '超级管理员', '0', '1', '拥有网站最高管理员权限！', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0');
163+
INSERT INTO `auth_role` VALUES ('1', '超级管理员', '0', '1', '拥有网站最高管理员权限！', '0', '2018-11-23 10:23:52', '2018-11-23 10:23:52');
164164

165165
-- ----------------------------
166166
-- Table structure for auth_role_admin
@@ -187,7 +187,7 @@ CREATE TABLE `file_resource` (
187187
`path` varchar(255) NOT NULL DEFAULT '' COMMENT '资源的路径（不加 域名的地址）',
188188
`size` int(11) NOT NULL DEFAULT '0' COMMENT '大小',
189189
`ext` varchar(10) NOT NULL DEFAULT '' COMMENT '资源的文件后缀',
190-
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
190+
`create_time` datetime NOT NULL COMMENT '创建时间',
191191
PRIMARY KEY (`id`)
192192
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='资源表';
193193

@@ -213,7 +213,7 @@ DROP TABLE IF EXISTS `file_resource_tag`;
213213
CREATE TABLE `file_resource_tag` (
214214
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源分组的id',
215215
`tag` varchar(255) NOT NULL DEFAULT '' COMMENT '资源分组的tag',
216-
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
216+
`create_time` datetime NOT NULL COMMENT '更新时间',
217217
PRIMARY KEY (`id`)
218218
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='资源的分组表';
219219

0 commit comments

Comments
 (0)