-
Notifications
You must be signed in to change notification settings - Fork 5
/
forum.sql
146 lines (132 loc) · 5.42 KB
/
forum.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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`
(
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL UNIQUE,
`password` varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `users` (id,username,password,avatar,created_at,updated_at,deleted_at) VALUES (0, 'admin', '$2a$10$K3DRY94amW.0Shce.5FsmuDqjKPzQczll.s6fHA361yPJ0le1Igr.','https://user-gold-cdn.xitu.io/2019/5/29/16b028263cf8b532?imageView2/1/w/100/h/100/q/85/format/webp/interlace/1','2019-11-11 16:25:33', NULL , NULL);
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`
(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '角色名字',
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` (id,name,created_at,updated_at,deleted_at) VALUES (1,'admin','2019-11-11 16:25:33', NULL , NULL);
-- ----------------------------
-- Table structure for users_role
-- ----------------------------
DROP TABLE IF EXISTS `users_role`;
CREATE TABLE `users_role`
(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL COMMENT '用户ID',
`role_id` int(11) unsigned NOT NULL COMMENT '角色ID',
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
-- ----------------------------
-- Records of users_role
-- ----------------------------
INSERT INTO `users_role` (id,user_id,role_id,created_at,updated_at,deleted_at) VALUES (1, 1, 1,'2019-11-11 16:25:33', NULL , NULL);
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`
(
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '资源名字',
`path` varchar(50) NOT NULL COMMENT '访问路径',
`method` varchar(50) NOT NULL COMMENT '资源请求方式',
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `menu` (id,name,path,method,created_at,updated_at,deleted_at) VALUES
(1,'获取用户信息','/v1/auth/info','GET','2019-11-11 16:25:33', NULL , NULL),
(2, '获取用户列表', '/v1/user', 'GET', '2019-11-11 16:25:33', NULL , NULL),
(3, '获取单个用户', '/v1/user/:id', 'GET', '2019-11-11 16:25:33', NULL , NULL),
(4, '创建用户', '/v1/user/', 'POST', '2019-11-11 16:25:33', NULL , NULL),
(5, '删除用户', '/v1/user/:id', 'DELETE', '2019-11-11 16:25:33', NULL , NULL),
(6, '修改用户', '/v1/user/:id', 'PUT', '2019-11-11 16:25:33', NULL , NULL),
(7, '查询所有菜单', '/v1/menus', 'GET', '2019-11-11 16:25:33', NULL , NULL),
(8, '查询单个菜单', '/v1/menus/:id', 'GET', '2019-11-11 16:25:33', NULL , NULL),
(9, '创建单个菜单', '/v1/menus', 'POST', '2019-11-11 16:25:33', NULL , NULL),
(10, '更新单个菜单', '/v1/menus/:id', 'PUT','2019-11-11 16:25:33', NULL , NULL),
(11, '删除单个菜单', '/v1/menus/:id', 'DELETE','2019-11-11 16:25:33', NULL , NULL),
(12, '查询所有角色', '/v1/roles', 'GET','2019-11-11 16:25:33', NULL , NULL),
(13, '查询单个角色', '/v1/roles/:id', 'GET','2019-11-11 16:25:33', NULL , NULL),
(14, '创建单个角色', '/v1/roles', 'POST','2019-11-11 16:25:33', NULL , NULL),
(15, '更新单个角色', '/v1/roles/:id', 'PUT','2019-11-11 16:25:33', NULL , NULL),
(16, '删除单个角色', '/v1/roles/:id', 'DELETE','2019-11-11 16:25:33', NULL , NULL);
-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu`
(
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`role_id` int(11) unsigned NOT NULL COMMENT '角色ID',
`menu_id` int(11) unsigned NOT NULL COMMENT '菜单ID',
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
-- ----------------------------
-- Records of role_menu
-- ----------------------------
INSERT INTO `role_menu` (id,role_id,menu_id,created_at,updated_at,deleted_at) VALUES
(1,1,1,'2019-11-11 16:25:33', NULL , NULL),
(2,1,2,'2019-11-11 16:25:33', NULL , NULL),
(3,1,3,'2019-11-11 16:25:33', NULL , NULL);
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles`
(
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL,
`category_id` int(11) UNSIGNED NOT NULL,
`tag_id` int(11) UNSIGNED NOT NULL,
`user_id` int(11) UNSIGNED NOT NULL,
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories`
(
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`category_name` varchar(255) NOT NULL UNIQUE,
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags`
(
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tag_name` varchar(255) NOT NULL UNIQUE,
`created_at` timestamp NULL,
`updated_at` timestamp NULL,
`deleted_at` timestamp NULL,
PRIMARY KEY (`id`)
);