forked from QQ2287991080/Zero.Core
-
Notifications
You must be signed in to change notification settings - Fork 7
Expand file tree
/
Copy pathdbData.sql
More file actions
139 lines (131 loc) · 55.3 KB
/
Copy pathdbData.sql
File metadata and controls
139 lines (131 loc) · 55.3 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
USE [Zero_Core_DB]
GO
SET IDENTITY_INSERT [dbo].[T_Menu] ON
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (1, CAST(N'2020-10-22T16:48:05.6234425' AS DateTime2), NULL, CAST(N'2020-10-22T16:52:19.9993285' AS DateTime2), 1, N'test菜单', NULL, NULL, 1, NULL, 0, 0, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (2, CAST(N'2020-10-22T16:50:59.4025212' AS DateTime2), NULL, CAST(N'2020-10-28T16:06:04.6860289' AS DateTime2), 1, N'test菜单2', NULL, NULL, 1, NULL, 0, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (3, CAST(N'2020-10-22T16:51:11.1166808' AS DateTime2), NULL, CAST(N'2020-10-25T14:06:20.3182684' AS DateTime2), 1, N'test菜单3', NULL, NULL, 1, NULL, 0, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (5, CAST(N'2020-10-25T11:22:55.1158780' AS DateTime2), NULL, CAST(N'2020-10-25T14:02:28.5743288' AS DateTime2), 1, N'', N'', N'', NULL, N'', 0, 1, 2)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (6, CAST(N'2020-10-25T13:38:48.5509385' AS DateTime2), NULL, CAST(N'2020-10-25T14:06:53.2599270' AS DateTime2), 1, N'21', N'321', N'', NULL, N'', 1, 1, 4)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (7, CAST(N'2020-10-25T13:43:58.9234566' AS DateTime2), NULL, CAST(N'2020-10-25T14:05:43.4606679' AS DateTime2), 1, N'大苏打', N'学习下', N'', NULL, N'', 0, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (8, CAST(N'2020-10-25T13:44:42.0034251' AS DateTime2), CAST(N'2020-10-28T16:13:40.1010850' AS DateTime2), CAST(N'2020-11-10T14:37:15.9001245' AS DateTime2), 1, N'测试', N'/', N'', NULL, N'', 4, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (9, CAST(N'2020-10-25T13:46:08.5694313' AS DateTime2), NULL, CAST(N'2020-10-25T14:07:52.5404369' AS DateTime2), 1, N'我是你爹', N'的撒大', N'', NULL, N'', 0, 1, 8)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (10, CAST(N'2020-10-25T13:47:40.6524401' AS DateTime2), NULL, CAST(N'2020-10-25T14:06:27.5325902' AS DateTime2), 1, N'212', N'12', N'', NULL, N'', 1221, 1, 4)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (11, CAST(N'2020-10-25T13:51:12.8110991' AS DateTime2), NULL, CAST(N'2020-10-25T14:07:22.6178264' AS DateTime2), 1, N'3', N'2313', N'', NULL, N'', 0, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (12, CAST(N'2020-10-28T16:06:36.8490682' AS DateTime2), CAST(N'2020-11-05T14:50:21.6930234' AS DateTime2), NULL, 0, N'首页', N'/dashboard', N'dashboard', 2, N'', 0, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (13, CAST(N'2020-10-28T16:07:19.7494639' AS DateTime2), CAST(N'2020-11-05T15:00:48.5556090' AS DateTime2), NULL, 0, N'系统功能', N'/', N'definition', 2, N'', 1, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (14, CAST(N'2020-10-28T16:08:20.8743702' AS DateTime2), NULL, NULL, 0, N'技术总览', N'/command/technology', N'document', 1, N'', 0, 1, 13)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (15, CAST(N'2020-10-28T16:08:44.4896509' AS DateTime2), NULL, NULL, 0, N'日志推送', N'/command/signalrLog', N'news', 1, N'', 1, 1, 13)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (16, CAST(N'2020-10-28T16:09:30.2643611' AS DateTime2), CAST(N'2020-11-06T11:49:01.4626668' AS DateTime2), NULL, 0, N'图标管理', N'/svg-icons', N'icon', 2, N'', 2, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (17, CAST(N'2020-10-28T16:11:58.2071282' AS DateTime2), CAST(N'2020-11-05T15:00:40.3754760' AS DateTime2), NULL, 0, N'系统设置', N'/', N'setting', 1, N'', 3, 1, NULL)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (18, CAST(N'2020-10-28T16:12:25.4584762' AS DateTime2), NULL, NULL, 0, N'角色管理', N'/system/role', N'role', 2, N'', 0, 1, 17)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (19, CAST(N'2020-10-28T16:12:52.6743167' AS DateTime2), NULL, NULL, 0, N'菜单管理', N'/system/menu', N'menu', 1, N'', 1, 1, 17)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (20, CAST(N'2020-10-28T16:13:17.8392940' AS DateTime2), NULL, NULL, 0, N'用户管理', N'/system/user', N'user', 1, N'', 2, 1, 17)
INSERT [dbo].[T_Menu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Url], [Icon], [IconType], [ClassName], [Sort], [IsAllow], [IdParent]) VALUES (21, CAST(N'2020-11-05T14:46:44.3770910' AS DateTime2), NULL, NULL, 0, N'字典管理', N'/system/dictionary', N'full-screen', 1, N'', 0, 1, 17)
SET IDENTITY_INSERT [dbo].[T_Menu] OFF
SET IDENTITY_INSERT [dbo].[T_Role] ON
INSERT [dbo].[T_Role] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo]) VALUES (1, CAST(N'2020-10-22T14:47:48.9904561' AS DateTime2), CAST(N'2020-10-22T14:47:48.9904561' AS DateTime2), CAST(N'2020-10-26T15:52:01.3046284' AS DateTime2), 1, N'管理员', N'这是一个管理员，别惹我')
INSERT [dbo].[T_Role] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo]) VALUES (2, CAST(N'2020-10-26T07:50:07.0410000' AS DateTime2), NULL, NULL, 0, N'SuperAdmin', N'这是一个超级管理哦')
INSERT [dbo].[T_Role] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo]) VALUES (3, CAST(N'2020-10-29T10:48:02.0679167' AS DateTime2), CAST(N'2020-10-29T11:00:21.1602623' AS DateTime2), CAST(N'2020-10-29T11:00:32.1878491' AS DateTime2), 1, N'admin', N'12312321321')
INSERT [dbo].[T_Role] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo]) VALUES (28, CAST(N'2020-11-02T15:18:38.4724488' AS DateTime2), NULL, NULL, 0, N'admin', N'这是个小管理，是超级管理员的老弟')
INSERT [dbo].[T_Role] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo]) VALUES (29, CAST(N'2020-11-06T10:48:31.4353381' AS DateTime2), CAST(N'2020-11-06T10:48:57.7258219' AS DateTime2), NULL, 0, N'test001', N'你是个游客')
SET IDENTITY_INSERT [dbo].[T_Role] OFF
SET IDENTITY_INSERT [dbo].[T_RoleMenu] ON
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (149, CAST(N'2020-11-06T10:46:23.0794997' AS DateTime2), NULL, NULL, 0, 2, 3)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (150, CAST(N'2020-11-06T10:46:23.1135075' AS DateTime2), NULL, NULL, 0, 2, 13)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (151, CAST(N'2020-11-06T10:46:23.1134936' AS DateTime2), NULL, NULL, 0, 2, 12)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (152, CAST(N'2020-11-06T10:46:23.1134657' AS DateTime2), NULL, NULL, 0, 2, 15)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (153, CAST(N'2020-11-06T10:46:23.1134527' AS DateTime2), NULL, NULL, 0, 2, 17)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (154, CAST(N'2020-11-06T10:46:23.1134805' AS DateTime2), NULL, NULL, 0, 2, 14)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (155, CAST(N'2020-11-06T10:46:23.1134250' AS DateTime2), NULL, NULL, 0, 2, 19)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (156, CAST(N'2020-11-06T10:46:23.1134089' AS DateTime2), NULL, NULL, 0, 2, 18)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (157, CAST(N'2020-11-06T10:46:23.1133798' AS DateTime2), NULL, NULL, 0, 2, 21)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (158, CAST(N'2020-11-06T10:46:23.1127620' AS DateTime2), NULL, NULL, 0, 2, 16)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (159, CAST(N'2020-11-06T10:46:23.1134397' AS DateTime2), NULL, NULL, 0, 2, 20)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (350, CAST(N'2020-11-10T15:03:50.9038728' AS DateTime2), NULL, NULL, 0, 28, 12)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (351, CAST(N'2020-11-10T15:03:50.9041271' AS DateTime2), NULL, NULL, 0, 28, 13)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (352, CAST(N'2020-11-10T15:03:50.9041489' AS DateTime2), NULL, NULL, 0, 28, 19)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (353, CAST(N'2020-11-10T15:03:50.9041639' AS DateTime2), NULL, NULL, 0, 28, 20)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (354, CAST(N'2020-11-10T15:03:50.9041772' AS DateTime2), NULL, NULL, 0, 28, 17)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (355, CAST(N'2020-11-10T15:03:50.9041896' AS DateTime2), NULL, NULL, 0, 28, 21)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (356, CAST(N'2020-11-10T15:03:50.9042037' AS DateTime2), NULL, NULL, 0, 28, 18)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (357, CAST(N'2020-11-10T15:03:50.9042162' AS DateTime2), NULL, NULL, 0, 28, 15)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (358, CAST(N'2020-11-10T15:03:50.9042293' AS DateTime2), NULL, NULL, 0, 28, 14)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (359, CAST(N'2020-11-10T15:03:50.9042429' AS DateTime2), NULL, NULL, 0, 28, 16)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (360, CAST(N'2020-11-10T15:10:30.2961389' AS DateTime2), NULL, NULL, 0, 29, 13)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (361, CAST(N'2020-11-10T15:10:30.2962057' AS DateTime2), NULL, NULL, 0, 29, 14)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (362, CAST(N'2020-11-10T15:10:30.2962199' AS DateTime2), NULL, NULL, 0, 29, 15)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (363, CAST(N'2020-11-10T15:10:30.2962330' AS DateTime2), NULL, NULL, 0, 29, 16)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (364, CAST(N'2020-11-10T15:10:30.2962448' AS DateTime2), NULL, NULL, 0, 29, 21)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (365, CAST(N'2020-11-10T15:10:30.2962656' AS DateTime2), NULL, NULL, 0, 29, 17)
INSERT [dbo].[T_RoleMenu] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [MenuId]) VALUES (366, CAST(N'2020-11-10T15:10:30.2962780' AS DateTime2), NULL, NULL, 0, 29, 12)
SET IDENTITY_INSERT [dbo].[T_RoleMenu] OFF
SET IDENTITY_INSERT [dbo].[T_Permission] ON
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (1, CAST(N'2020-10-26T04:00:33.7930000' AS DateTime2), NULL, NULL, 0, N'新增', N'x_add', 3, 1, N'')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (3, CAST(N'2020-10-28T18:16:55.4771740' AS DateTime2), CAST(N'2020-10-29T12:02:24.3168478' AS DateTime2), CAST(N'2020-11-10T14:37:11.5343610' AS DateTime2), 1, N'小黑', N'xiao_hei', 8, 1, N'小嘿嘿嘿')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (4, CAST(N'2020-10-29T12:04:25.8312937' AS DateTime2), CAST(N'2020-10-29T12:06:47.5045870' AS DateTime2), CAST(N'2020-11-10T14:37:08.9983273' AS DateTime2), 1, N'312312312', N'1323123', 8, 1, N'12312321')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (5, CAST(N'2020-10-29T12:07:24.7690170' AS DateTime2), NULL, CAST(N'2020-10-29T13:45:58.8956730' AS DateTime2), 1, N'hahahah', N'131232', 8, 1, N'321')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (6, CAST(N'2020-10-29T15:26:35.6277858' AS DateTime2), NULL, NULL, 0, N'新增子菜单', N'menu_addchildren', 19, 1, N'菜单管理新增子菜单')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (7, CAST(N'2020-10-29T15:27:38.0456652' AS DateTime2), NULL, NULL, 0, N'新增平级菜单', N'menu_addlevel', 19, 1, N'菜单管理新增平级菜单')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (8, CAST(N'2020-10-29T15:28:21.3780099' AS DateTime2), NULL, NULL, 0, N'修改', N'menu_update', 19, 1, N'菜单管理修改菜单')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (9, CAST(N'2020-10-29T15:28:43.7077173' AS DateTime2), NULL, NULL, 0, N'删除', N'menu_delete', 19, 1, N'菜单管理删除菜单')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (10, CAST(N'2020-10-29T15:29:24.4102192' AS DateTime2), NULL, NULL, 0, N'权限新增', N'menu_addpermission', 19, 1, N'菜单管理新增权限')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (11, CAST(N'2020-10-29T15:29:54.7893484' AS DateTime2), NULL, NULL, 0, N'权限修改', N'menu_updatepermission', 19, 1, N'菜单管理修改权限')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (12, CAST(N'2020-10-29T15:30:23.3274924' AS DateTime2), NULL, NULL, 0, N'权限删除', N'menu_deletepermission', 19, 1, N'菜单管理删除权限')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (13, CAST(N'2020-10-29T15:30:58.1678842' AS DateTime2), NULL, NULL, 0, N'新增', N'role_add', 18, 1, N'角色管理新增角色')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (14, CAST(N'2020-10-29T15:31:57.2777493' AS DateTime2), NULL, NULL, 0, N'修改', N'role_update', 18, 1, N'角色管理修改角色')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (15, CAST(N'2020-10-29T15:32:31.2070249' AS DateTime2), NULL, NULL, 0, N'删除', N'role_delete', 18, 1, N'角色管理删除角色')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (16, CAST(N'2020-10-29T15:35:31.3992868' AS DateTime2), NULL, NULL, 0, N'分配权限', N'role_permission', 18, 1, N'角色管理分配权限')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (17, CAST(N'2020-11-05T14:54:20.9683658' AS DateTime2), NULL, NULL, 0, N'新增子节点', N'dic_addchild', 21, 1, N'字典管理新增子节点')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (18, CAST(N'2020-11-05T14:56:56.3184104' AS DateTime2), NULL, NULL, 0, N'新增平级节点', N'dic_add', 21, 1, N'字典管理新增平级节点')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (19, CAST(N'2020-11-05T14:57:50.1293779' AS DateTime2), NULL, NULL, 0, N'修改', N'dic_update', 21, 1, N'字典管理修改')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (20, CAST(N'2020-11-05T14:58:13.5984848' AS DateTime2), NULL, NULL, 0, N'删除', N'dic_delete', 21, 1, N'字典管理删除')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (21, CAST(N'2020-11-10T14:27:49.2667941' AS DateTime2), NULL, NULL, 0, N'新增', N'user_add', 20, 1, N'用户管理新增')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (22, CAST(N'2020-11-10T14:28:14.1883924' AS DateTime2), NULL, NULL, 0, N'修改', N'user_update', 20, 1, N'用户管理修改')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (23, CAST(N'2020-11-10T14:33:14.8919192' AS DateTime2), NULL, NULL, 0, N'删除', N'user_delete', 20, 1, N'用户管理删除')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (24, CAST(N'2020-11-10T14:33:48.7112819' AS DateTime2), NULL, NULL, 0, N'锁定', N'user_lock', 20, 1, N'用户管理锁定')
INSERT [dbo].[T_Permission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Code], [MenuId], [IsAllow], [Memo]) VALUES (25, CAST(N'2020-11-10T14:34:36.7061459' AS DateTime2), NULL, NULL, 0, N'分配角色', N'user_setrole', 20, 1, N'用户管理分配角色')
SET IDENTITY_INSERT [dbo].[T_Permission] OFF
SET IDENTITY_INSERT [dbo].[T_User] ON
INSERT [dbo].[T_User] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserName], [RealName], [Email], [Phone], [Password], [Salt], [IsLock], [Remark], [Sex], [Avatar]) VALUES (1, CAST(N'2020-10-14T11:32:47.7647798' AS DateTime2), CAST(N'2020-11-10T16:10:23.3264788' AS DateTime2), NULL, 0, N'Zero', N'飞天猪皮怪', N'2287991080@qq.com', N'15268983151', N'6d89e6f048004a1830699eb809ce90cc', N'300459', 0, N'ppgod', 1, N'avatar/7fc55f9b-8c13-4555-afc0-060fb644d531.jpg')
INSERT [dbo].[T_User] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserName], [RealName], [Email], [Phone], [Password], [Salt], [IsLock], [Remark], [Sex], [Avatar]) VALUES (14, CAST(N'2020-11-05T15:22:09.2102590' AS DateTime2), NULL, NULL, 0, N'test001', N'test001', N'', N'', N'd348098b4753e539df25ecb4242a1a41', N'789456', 0, NULL, 1, NULL)
INSERT [dbo].[T_User] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserName], [RealName], [Email], [Phone], [Password], [Salt], [IsLock], [Remark], [Sex], [Avatar]) VALUES (15, CAST(N'2020-11-10T16:18:10.1035723' AS DateTime2), NULL, NULL, 0, N'admin', N'admin', N'', N'', N'348a6a9a8467a48d61ae23405b3bb6c4', N'451759', 0, N'这是个用来测试的管理员', 1, NULL)
SET IDENTITY_INSERT [dbo].[T_User] OFF
SET IDENTITY_INSERT [dbo].[T_UserRole] ON
INSERT [dbo].[T_UserRole] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserId], [RoleId]) VALUES (19, CAST(N'2020-11-05T14:24:45.6960776' AS DateTime2), NULL, NULL, 0, 1, 2)
INSERT [dbo].[T_UserRole] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserId], [RoleId]) VALUES (21, CAST(N'2020-11-10T15:06:53.9058539' AS DateTime2), NULL, NULL, 0, 14, 29)
INSERT [dbo].[T_UserRole] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [UserId], [RoleId]) VALUES (22, CAST(N'2020-11-10T16:18:13.6447076' AS DateTime2), NULL, NULL, 0, 15, 28)
SET IDENTITY_INSERT [dbo].[T_UserRole] OFF
SET IDENTITY_INSERT [dbo].[T_Dictionaries] ON
INSERT [dbo].[T_Dictionaries] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo], [IdParent], [Sort], [IsAllow]) VALUES (1, CAST(N'2020-11-03T10:20:30.4532928' AS DateTime2), NULL, NULL, 0, N'测试字典', N'测试', NULL, 1, 1)
INSERT [dbo].[T_Dictionaries] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo], [IdParent], [Sort], [IsAllow]) VALUES (2, CAST(N'2020-11-03T10:22:38.3359438' AS DateTime2), NULL, NULL, 0, N'测试字典子集', N'测试', 1, 0, 1)
INSERT [dbo].[T_Dictionaries] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo], [IdParent], [Sort], [IsAllow]) VALUES (3, CAST(N'2020-11-05T13:39:55.9613942' AS DateTime2), NULL, CAST(N'2020-11-05T13:54:13.8284421' AS DateTime2), 1, N'测试子集2', N'嘻嘻嘻嘻', 1, 2, 0)
INSERT [dbo].[T_Dictionaries] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo], [IdParent], [Sort], [IsAllow]) VALUES (4, CAST(N'2020-11-05T13:55:09.2312290' AS DateTime2), CAST(N'2020-11-05T14:00:34.8866436' AS DateTime2), NULL, 0, N'测试字典2哈哈哈哈哈哈', N'测下手', NULL, 2, 0)
INSERT [dbo].[T_Dictionaries] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [Name], [Memo], [IdParent], [Sort], [IsAllow]) VALUES (5, CAST(N'2020-11-05T14:13:16.1755429' AS DateTime2), NULL, NULL, 0, N'嘿哈', N'堍堍堍堍堍堍堍', 4, 0, 0)
SET IDENTITY_INSERT [dbo].[T_Dictionaries] OFF
SET IDENTITY_INSERT [dbo].[T_RolePermission] ON
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (3, CAST(N'2020-10-30T11:26:23.9238575' AS DateTime2), NULL, NULL, 0, 26, 3)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (4, CAST(N'2020-10-30T11:26:23.9283814' AS DateTime2), NULL, NULL, 0, 26, 4)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (5, CAST(N'2020-10-30T11:51:33.8977454' AS DateTime2), NULL, NULL, 0, 23, 3)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (6, CAST(N'2020-10-30T11:51:33.8985378' AS DateTime2), NULL, NULL, 0, 23, 4)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (7, CAST(N'2020-10-30T11:51:33.8990053' AS DateTime2), NULL, NULL, 0, 23, 6)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (8, CAST(N'2020-10-30T11:51:33.8992819' AS DateTime2), NULL, NULL, 0, 23, 10)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (9, CAST(N'2020-10-30T11:51:33.8994302' AS DateTime2), NULL, NULL, 0, 23, 7)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (10, CAST(N'2020-10-30T11:51:33.8996623' AS DateTime2), NULL, NULL, 0, 23, 11)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (219, CAST(N'2020-11-06T10:46:23.1311704' AS DateTime2), NULL, NULL, 0, 2, 11)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (220, CAST(N'2020-11-06T10:46:23.1312311' AS DateTime2), NULL, NULL, 0, 2, 13)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (221, CAST(N'2020-11-06T10:46:23.1312194' AS DateTime2), NULL, NULL, 0, 2, 20)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (222, CAST(N'2020-11-06T10:46:23.1312076' AS DateTime2), NULL, NULL, 0, 2, 18)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (223, CAST(N'2020-11-06T10:46:23.1311943' AS DateTime2), NULL, NULL, 0, 2, 17)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (224, CAST(N'2020-11-06T10:46:23.1311824' AS DateTime2), NULL, NULL, 0, 2, 9)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (225, CAST(N'2020-11-06T10:46:23.1311572' AS DateTime2), NULL, NULL, 0, 2, 10)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (226, CAST(N'2020-11-06T10:46:23.1310874' AS DateTime2), NULL, NULL, 0, 2, 2)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (227, CAST(N'2020-11-06T10:46:23.1311318' AS DateTime2), NULL, NULL, 0, 2, 6)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (228, CAST(N'2020-11-06T10:46:23.1311163' AS DateTime2), NULL, NULL, 0, 2, 19)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (229, CAST(N'2020-11-06T10:46:23.1311024' AS DateTime2), NULL, NULL, 0, 2, 7)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (230, CAST(N'2020-11-06T10:46:23.1312581' AS DateTime2), NULL, NULL, 0, 2, 15)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (231, CAST(N'2020-11-06T10:46:23.1309768' AS DateTime2), NULL, NULL, 0, 2, 8)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (232, CAST(N'2020-11-06T10:46:23.1170265' AS DateTime2), NULL, NULL, 0, 2, 12)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (233, CAST(N'2020-11-06T10:46:23.1311446' AS DateTime2), NULL, NULL, 0, 2, 14)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (234, CAST(N'2020-11-06T10:46:23.1312717' AS DateTime2), NULL, NULL, 0, 2, 16)
INSERT [dbo].[T_RolePermission] ([Id], [CreateTime], [ModifyTime], [DeleteTime], [IsDelete], [RoleId], [Pid]) VALUES (268, CAST(N'2020-11-10T15:03:50.9044979' AS DateTime2), NULL, NULL, 0, 28, 19)
SET IDENTITY_INSERT [dbo].[T_RolePermission] OFF