Skip to content

Commit d39d256

Browse files
lmxdawnlmxdawn
committed
增加数据库文件
1 parent 8ecd85c commit d39d256

File tree

1 file changed

+223
-0
lines changed

1 file changed

+223
-0
lines changed

‎vue-admin.sql

Lines changed: 223 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,223 @@
1+
/*
2+
Navicat MySQL Data Transfer
3+
4+
Source Server : php
5+
Source Server Version : 50553
6+
Source Host : localhost:3306
7+
Source Database : vue-admin
8+
9+
Target Server Type : MYSQL
10+
Target Server Version : 50553
11+
File Encoding : 65001
12+
13+
Date: 2018-11-20 18:59:57
14+
*/
15+
16+
SET FOREIGN_KEY_CHECKS=0;
17+
18+
-- ----------------------------
19+
-- Table structure for ad
20+
-- ----------------------------
21+
DROP TABLE IF EXISTS `ad`;
22+
CREATE TABLE `ad` (
23+
`ad_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '广告ID',
24+
`title` varchar(255) DEFAULT NULL COMMENT '广告标题',
25+
`describe` varchar(255) DEFAULT NULL COMMENT '描述',
26+
`jump_type` tinyint(4) DEFAULT '0' COMMENT '跳转方式（1：小程序，2：url链接）',
27+
`link_url` varchar(255) DEFAULT NULL COMMENT '跳转类型为 2 时有效',
28+
`pic` varchar(255) DEFAULT NULL COMMENT '图片的地址',
29+
`wxa_appid` varchar(50) DEFAULT NULL COMMENT '微信小程序的APPID（跳转类型为 1 时有效）',
30+
`wxa_path` varchar(255) DEFAULT NULL COMMENT '跳转小程序的路径（跳转类型为 1 时有效）',
31+
`extra_data` varchar(255) DEFAULT NULL COMMENT '跳转到小程序时的参数（跳转类型为 1 时有效）',
32+
`env_version` varchar(10) DEFAULT NULL COMMENT '跳转的小程序版本（跳转类型为 1 时有效）',
33+
`status` tinyint(4) DEFAULT '0' COMMENT '广告状态（0：禁用，1：正常）',
34+
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
35+
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
36+
PRIMARY KEY (`ad_id`)
37+
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='广告表';
38+
39+
-- ----------------------------
40+
-- Records of ad
41+
-- ----------------------------
42+
INSERT INTO `ad` VALUES ('1', 'css', '拉德芳斯就考虑到发动机爱上了房间里睡大觉飞拉萨的机房', '1', 'sss', 'resources/image/20180529/6f14f7a1f0b2bfdd49e3f47122a40160.png', '0', 'sss', '0', '0', '1', null, '2018-07-06 17:19:00');
43+
44+
-- ----------------------------
45+
-- Table structure for ad_site
46+
-- ----------------------------
47+
DROP TABLE IF EXISTS `ad_site`;
48+
CREATE TABLE `ad_site` (
49+
`site_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '广告位id',
50+
`site_name` varchar(255) DEFAULT NULL COMMENT '广告位名称',
51+
`describe` varchar(255) DEFAULT NULL COMMENT '广告位描述',
52+
`ad_ids` varchar(255) DEFAULT NULL COMMENT '广告位的广告id（多个用 , 号隔开）',
53+
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
54+
`update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
55+
PRIMARY KEY (`site_id`)
56+
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='广告位';
57+
58+
-- ----------------------------
59+
-- Records of ad_site
60+
-- ----------------------------
61+
INSERT INTO `ad_site` VALUES ('1', 'fff', 'fffgggggggghhh1111', '0', '2018-08-23 11:06:54', '2018-08-23 11:07:45');
62+
63+
-- ----------------------------
64+
-- Table structure for auth_admin
65+
-- ----------------------------
66+
DROP TABLE IF EXISTS `auth_admin`;
67+
CREATE TABLE `auth_admin` (
68+
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
69+
`username` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',
70+
`password` varchar(64) NOT NULL DEFAULT '' COMMENT '登录密码；sp_password加密',
71+
`tel` varchar(50) NOT NULL DEFAULT '' COMMENT '用户手机号',
72+
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '登录邮箱',
73+
`avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
74+
`sex` smallint(1) NOT NULL DEFAULT '0' COMMENT '性别；0：保密，1：男；2：女',
75+
`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 '注册时间',
78+
`status` int(11) NOT NULL DEFAULT '1' COMMENT '用户状态 0：禁用； 1：正常 ；2：未验证',
79+
PRIMARY KEY (`id`),
80+
KEY `user_login_key` (`username`)
81+
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表';
82+
83+
-- ----------------------------
84+
-- Records of auth_admin
85+
-- ----------------------------
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');
87+
88+
-- ----------------------------
89+
-- Table structure for auth_permission
90+
-- ----------------------------
91+
DROP TABLE IF EXISTS `auth_permission`;
92+
CREATE TABLE `auth_permission` (
93+
`role_id` int(11) unsigned NOT NULL COMMENT '角色',
94+
`permission_rule_id` int(11) NOT NULL DEFAULT '0' COMMENT '权限id',
95+
`type` varchar(30) DEFAULT NULL COMMENT '权限规则分类，请加应用前缀,如admin_'
96+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权表';
97+
98+
-- ----------------------------
99+
-- Records of auth_permission
100+
-- ----------------------------
101+
INSERT INTO `auth_permission` VALUES ('1', '4', 'admin');
102+
INSERT INTO `auth_permission` VALUES ('1', '3', 'admin');
103+
INSERT INTO `auth_permission` VALUES ('1', '2', 'admin');
104+
INSERT INTO `auth_permission` VALUES ('1', '1', 'admin');
105+
106+
-- ----------------------------
107+
-- Table structure for auth_permission_rule
108+
-- ----------------------------
109+
DROP TABLE IF EXISTS `auth_permission_rule`;
110+
CREATE TABLE `auth_permission_rule` (
111+
`id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则编号',
112+
`pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
113+
`is_leaf` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有叶子节点',
114+
`name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一标识',
115+
`title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文名称',
116+
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：为1正常，为0禁用',
117+
`condition` char(100) NOT NULL DEFAULT '' COMMENT '规则表达式，为空表示存在就验证，不为空表示按照条件验证',
118+
`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 '更新时间',
121+
PRIMARY KEY (`id`),
122+
UNIQUE KEY `name` (`name`)
123+
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='规则表';
124+
125+
-- ----------------------------
126+
-- Records of auth_permission_rule
127+
-- ----------------------------
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');
143+
144+
-- ----------------------------
145+
-- Table structure for auth_role
146+
-- ----------------------------
147+
DROP TABLE IF EXISTS `auth_role`;
148+
CREATE TABLE `auth_role` (
149+
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
150+
`name` varchar(20) NOT NULL COMMENT '角色名称',
151+
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
152+
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
153+
`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 '排序，优先级，越小优先级越高',
157+
PRIMARY KEY (`id`)
158+
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色表';
159+
160+
-- ----------------------------
161+
-- Records of auth_role
162+
-- ----------------------------
163+
INSERT INTO `auth_role` VALUES ('1', '超级管理员', '0', '1', '拥有网站最高管理员权限！', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0');
164+
165+
-- ----------------------------
166+
-- Table structure for auth_role_admin
167+
-- ----------------------------
168+
DROP TABLE IF EXISTS `auth_role_admin`;
169+
CREATE TABLE `auth_role_admin` (
170+
`role_id` int(11) unsigned DEFAULT '0' COMMENT '角色 id',
171+
`admin_id` int(11) DEFAULT '0' COMMENT '管理员id'
172+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色对应表';
173+
174+
-- ----------------------------
175+
-- Records of auth_role_admin
176+
-- ----------------------------
177+
178+
-- ----------------------------
179+
-- Table structure for file_resource
180+
-- ----------------------------
181+
DROP TABLE IF EXISTS `file_resource`;
182+
CREATE TABLE `file_resource` (
183+
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源id',
184+
`tag_id` int(11) NOT NULL DEFAULT '0' COMMENT '资源分组id',
185+
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '资源的类型（0：图片）',
186+
`filename` varchar(255) NOT NULL DEFAULT '' COMMENT '资源的原名',
187+
`path` varchar(255) NOT NULL DEFAULT '' COMMENT '资源的路径（不加 域名的地址）',
188+
`size` int(11) NOT NULL DEFAULT '0' COMMENT '大小',
189+
`ext` varchar(10) NOT NULL DEFAULT '' COMMENT '资源的文件后缀',
190+
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
191+
PRIMARY KEY (`id`)
192+
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='资源表';
193+
194+
-- ----------------------------
195+
-- Records of file_resource
196+
-- ----------------------------
197+
INSERT INTO `file_resource` VALUES ('1', '1', '0', 'Group 5.png', 'resources/image/20180530/854ae62758c585be5128cf344a511242.png', '7539', 'png', '2018-05-30 20:41:54');
198+
INSERT INTO `file_resource` VALUES ('2', '0', '0', '643353_sdfaf123.png', 'resources/image/20180823/c356ca140f631a512f1c3a5e37a15dc1.png', '11507', 'png', '2018-08-23 13:38:42');
199+
INSERT INTO `file_resource` VALUES ('3', '0', '0', '643353_sdfaf123.png', 'resources/image/20180823/4549c39e9c07c35681ee9fa94e0fc07e.png', '11507', 'png', '2018-08-23 14:05:18');
200+
INSERT INTO `file_resource` VALUES ('4', '0', '0', '', '', '0', '', '2018-08-23 15:45:21');
201+
INSERT INTO `file_resource` VALUES ('5', '0', '0', '', '', '2000000', '', '2018-08-23 15:45:21');
202+
INSERT INTO `file_resource` VALUES ('6', '0', '0', '', '', '0', '', '2018-08-23 15:45:21');
203+
INSERT INTO `file_resource` VALUES ('7', '0', '0', '', '', '0', '', '2018-08-23 15:45:21');
204+
INSERT INTO `file_resource` VALUES ('8', '0', '0', '643353_sdfaf123.png', 'resources/image/20180823/0c424412b231eb8cb969377e15dbb812.png', '11507', 'png', '2018-08-23 15:53:32');
205+
INSERT INTO `file_resource` VALUES ('9', '0', '0', '232826334630444283.png', 'FjBRVPOPF9gLeNBCAvK7jbif4yg8', '9668', 'png', '2018-08-23 16:08:13');
206+
INSERT INTO `file_resource` VALUES ('10', '0', '0', '232826334630444283.png', 'FjBRVPOPF9gLeNBCAvK7jbif4yg8', '9668', 'png', '2018-08-23 16:09:07');
207+
INSERT INTO `file_resource` VALUES ('11', '0', '0', '643353_sdfaf123.png', 'resources/image/20180823/52af5f8556a3af84cee696972b61baf4.png', '11507', 'png', '2018-08-23 17:06:05');
208+
209+
-- ----------------------------
210+
-- Table structure for file_resource_tag
211+
-- ----------------------------
212+
DROP TABLE IF EXISTS `file_resource_tag`;
213+
CREATE TABLE `file_resource_tag` (
214+
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源分组的id',
215+
`tag` varchar(255) NOT NULL DEFAULT '' COMMENT '资源分组的tag',
216+
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
217+
PRIMARY KEY (`id`)
218+
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='资源的分组表';
219+
220+
-- ----------------------------
221+
-- Records of file_resource_tag
222+
-- ----------------------------
223+
INSERT INTO `file_resource_tag` VALUES ('1', '测试', '2018-05-30 20:41:48');

0 commit comments

Comments
 (0)