admin / data /admin.mssql
AZLABS's picture
Upload folder using huggingface_hub
530729e verified
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