|
|
|
|
|
CREATE TABLE [goadmin_menu] ( |
|
[id] int identity(1,1) , |
|
[parent_id] int NOT NULL DEFAULT 0, |
|
[type] tinyint NOT NULL DEFAULT 0, |
|
[order] int NOT NULL DEFAULT '0', |
|
[title] varchar(50) NOT NULL, |
|
[icon] varchar(50) NOT NULL, |
|
[uri] varchar(3000) NOT NULL DEFAULT '', |
|
[header] varchar(150) DEFAULT NULL, |
|
[uuid] varchar(150) DEFAULT NULL, |
|
[plugin_name] varchar(150) NOT NULL DEFAULT '', |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
set IDENTITY_INSERT [goadmin_menu] ON |
|
INSERT INTO[goadmin_menu] ([id],[parent_id],[type],[order],[title],[icon],[uri],[header],[created_at],[updated_at]) |
|
VALUES |
|
(1,0,1,2,'Admin','fa-tasks','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,1,1,2,'Users','fa-users','/info/manager',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(3,1,1,3,'Roles','fa-user','/info/roles',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(4,1,1,4,'Permission','fa-ban','/info/permission',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(5,1,1,5,'Menu','fa-bars','/menu',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(6,1,1,6,'Operation log','fa-history','/info/op',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(7,0,1,1,'Dashboard','fa-bar-chart','/',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
set IDENTITY_INSERT [goadmin_menu] OFF |
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_operation_log] ( |
|
[id] int identity(1,1) , |
|
[user_id] int NOT NULL, |
|
[path] varchar(255) NOT NULL, |
|
[method] varchar(10) NOT NULL, |
|
[ip] varchar(15) NOT NULL, |
|
[input] text NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
|
|
|
|
CREATE TABLE[goadmin_site] ( |
|
[id] int identity(1,1) , |
|
[key] varchar(100) NOT NULL, |
|
[value] text NOT NULL, |
|
[state] tinyint NOT NULL DEFAULT 0, |
|
[description] varchar(3000) DEFAULT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
|
|
|
|
CREATE TABLE[goadmin_permissions] ( |
|
[id] int identity(1,1) , |
|
[name] varchar(50) NOT NULL, |
|
[slug] varchar(50) NOT NULL, |
|
[http_method] varchar(255) DEFAULT NULL, |
|
[http_path] text NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
|
|
set IDENTITY_INSERT [goadmin_permissions] ON |
|
|
|
INSERT INTO[goadmin_permissions] ([id],[name],[slug],[http_method],[http_path],[created_at],[updated_at]) |
|
VALUES |
|
(1,'All permission','*','','*','2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,'Dashboard','dashboard','GET,PUT,POST,DELETE','/','2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
|
|
set IDENTITY_INSERT [goadmin_permissions] OFF |
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_role_menu] ( |
|
[role_id] int NOT NULL, |
|
[menu_id] int NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY([role_id],[menu_id]) |
|
) |
|
|
|
|
|
|
|
INSERT INTO[goadmin_role_menu] ([role_id],[menu_id],[created_at],[updated_at]) |
|
VALUES |
|
(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(1,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(1,8,'2019-09-11 10:20:55','2019-09-11 10:20:55'), |
|
(2,8,'2019-09-11 10:20:55','2019-09-11 10:20:55'); |
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_role_permissions] ( |
|
[role_id] int NOT NULL, |
|
[permission_id] int NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([role_id],[permission_id]) |
|
) |
|
|
|
|
|
INSERT INTO[goadmin_role_permissions] ([role_id],[permission_id],[created_at],[updated_at]) |
|
VALUES |
|
(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(1,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_role_users] ( |
|
[role_id] int NOT NULL, |
|
[user_id] int NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([role_id],[user_id]) |
|
) |
|
|
|
|
|
INSERT INTO[goadmin_role_users] ([role_id],[user_id],[created_at],[updated_at]) |
|
VALUES |
|
(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_roles] ( |
|
[id] int identity(1,1) , |
|
[name] varchar(50) NOT NULL UNIQUE, |
|
[slug] varchar(50) NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
|
|
set IDENTITY_INSERT [goadmin_roles] ON |
|
|
|
INSERT INTO[goadmin_roles] ([id],[name],[slug],[created_at],[updated_at]) |
|
VALUES |
|
(1,'Administrator','administrator','2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,'Operator','operator','2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
|
|
set IDENTITY_INSERT [goadmin_roles] OFF |
|
|
|
|
|
CREATE TABLE[goadmin_session] ( |
|
[id] int identity(1,1) , |
|
[sid] varchar(50) DEFAULT '', |
|
[values] varchar(3000) DEFAULT '', |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]) |
|
) |
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_user_permissions] ( |
|
[user_id] int NOT NULL, |
|
[permission_id] int NOT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([user_id],[permission_id]) |
|
) |
|
|
|
|
|
INSERT INTO[goadmin_user_permissions] ([user_id],[permission_id],[created_at],[updated_at]) |
|
VALUES |
|
(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE[goadmin_users] ( |
|
[id] int identity(1,1) , |
|
[username] varchar(100) NOT NULL UNIQUE, |
|
[password] varchar(100) NOT NULL DEFAULT '', |
|
[name] varchar(100) NOT NULL, |
|
[avatar] varchar(255) DEFAULT NULL, |
|
[remember_token] varchar(100) DEFAULT NULL, |
|
[created_at] datetime NULL DEFAULT GETDATE(), |
|
[updated_at] datetime NULL DEFAULT GETDATE(), |
|
PRIMARY KEY ([id]), |
|
) |
|
|
|
set IDENTITY_INSERT [goadmin_users] ON |
|
|
|
INSERT INTO[goadmin_users] ([id],[username],[password],[name],[avatar],[remember_token],[created_at],[updated_at]) |
|
VALUES |
|
(1,'admin','$2a$10$U3F/NSaf2kaVbyXTBp7ppOn0jZFyRqXRnYXB.AMioCjXl3Ciaj4oy','admin','','tlNcBVK9AvfYH7WEnwB1RKvocJu8FfRy4um3DJtwdHuJy0dwFsLOgAc0xUfh','2019-09-10 00:00:00','2019-09-10 00:00:00'), |
|
(2,'operator','$2a$10$rVqkOzHjN2MdlEprRflb1eGP0oZXuSrbJLOmJagFsCd81YZm0bsh.','Operator','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'); |
|
set IDENTITY_INSERT [goadmin_users] OFF |
|
|
|
|
|
|