github.com/kotovmak/go-admin@v1.1.1/data/admin.mssql (about)

     1  
     2  
     3  CREATE TABLE [goadmin_menu] (
     4   [id] int   identity(1,1) ,
     5   [parent_id] int   NOT NULL DEFAULT 0,
     6   [type] tinyint   NOT NULL DEFAULT 0,
     7   [order] int   NOT NULL DEFAULT '0',
     8   [title] varchar(50)   NOT NULL,
     9   [icon] varchar(50)   NOT NULL,
    10   [uri] varchar(3000)   NOT NULL DEFAULT '',
    11   [header] varchar(150)   DEFAULT NULL,
    12   [uuid] varchar(150)   DEFAULT NULL,
    13   [plugin_name] varchar(150)   NOT NULL DEFAULT '',
    14   [created_at] datetime NULL DEFAULT GETDATE(),
    15   [updated_at] datetime NULL DEFAULT GETDATE(),
    16   PRIMARY KEY ([id]),
    17  ) 
    18  set  IDENTITY_INSERT [goadmin_menu] ON 
    19  INSERT INTO[goadmin_menu] ([id],[parent_id],[type],[order],[title],[icon],[uri],[header],[created_at],[updated_at])
    20  VALUES
    21  	(1,0,1,2,'Admin','fa-tasks','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    22  	(2,1,1,2,'Users','fa-users','/info/manager',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    23  	(3,1,1,3,'Roles','fa-user','/info/roles',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    24  	(4,1,1,4,'Permission','fa-ban','/info/permission',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    25  	(5,1,1,5,'Menu','fa-bars','/menu',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    26  	(6,1,1,6,'Operation log','fa-history','/info/op',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    27  	(7,0,1,1,'Dashboard','fa-bar-chart','/',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00');
    28  set  IDENTITY_INSERT [goadmin_menu] OFF 
    29  
    30  
    31  
    32  
    33  CREATE TABLE[goadmin_operation_log] (
    34   [id] int   identity(1,1) ,
    35   [user_id] int   NOT NULL,
    36   [path] varchar(255)   NOT NULL,
    37   [method] varchar(10)   NOT NULL,
    38   [ip] varchar(15)   NOT NULL,
    39   [input] text   NOT NULL,
    40   [created_at] datetime NULL DEFAULT GETDATE(),
    41   [updated_at] datetime NULL DEFAULT GETDATE(),
    42    PRIMARY KEY ([id]),
    43  ) 
    44  
    45  
    46  CREATE TABLE[goadmin_site] (
    47   [id] int   identity(1,1) ,
    48   [key] varchar(100)   NOT NULL,
    49   [value] text   NOT NULL,
    50   [state] tinyint   NOT NULL DEFAULT 0,
    51   [description] varchar(3000)   DEFAULT NULL,
    52   [created_at] datetime NULL DEFAULT GETDATE(),
    53   [updated_at] datetime NULL DEFAULT GETDATE(),
    54    PRIMARY KEY ([id]),
    55  )
    56  
    57  
    58  CREATE TABLE[goadmin_permissions] (
    59   [id] int   identity(1,1) ,
    60   [name] varchar(50)   NOT NULL,
    61   [slug] varchar(50)   NOT NULL,
    62   [http_method] varchar(255)   DEFAULT NULL,
    63   [http_path] text   NOT NULL,
    64   [created_at] datetime NULL DEFAULT GETDATE(),
    65   [updated_at] datetime NULL DEFAULT GETDATE(),
    66    PRIMARY KEY ([id]),
    67  ) 
    68  
    69  set  IDENTITY_INSERT [goadmin_permissions] ON 
    70  
    71  INSERT INTO[goadmin_permissions] ([id],[name],[slug],[http_method],[http_path],[created_at],[updated_at])
    72  VALUES
    73  	(1,'All permission','*','','*','2019-09-10 00:00:00','2019-09-10 00:00:00'),
    74  	(2,'Dashboard','dashboard','GET,PUT,POST,DELETE','/','2019-09-10 00:00:00','2019-09-10 00:00:00');
    75  
    76  set  IDENTITY_INSERT [goadmin_permissions] OFF 
    77  
    78  
    79  
    80  
    81  CREATE TABLE[goadmin_role_menu] (
    82   [role_id] int   NOT NULL,
    83   [menu_id] int   NOT NULL,
    84   [created_at] datetime NULL DEFAULT GETDATE(),
    85   [updated_at] datetime NULL DEFAULT GETDATE(),
    86   PRIMARY KEY([role_id],[menu_id])
    87  ) 
    88  
    89  
    90  
    91  INSERT INTO[goadmin_role_menu] ([role_id],[menu_id],[created_at],[updated_at])
    92  VALUES
    93  	(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    94  	(1,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    95  	(2,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
    96  	(1,8,'2019-09-11 10:20:55','2019-09-11 10:20:55'),
    97  	(2,8,'2019-09-11 10:20:55','2019-09-11 10:20:55');
    98  
    99  
   100  
   101  
   102  
   103  CREATE TABLE[goadmin_role_permissions] (
   104   [role_id] int   NOT NULL,
   105   [permission_id] int   NOT NULL,
   106   [created_at] datetime NULL DEFAULT GETDATE(),
   107   [updated_at] datetime NULL DEFAULT GETDATE(),
   108    PRIMARY KEY ([role_id],[permission_id])
   109  ) 
   110  
   111  
   112  INSERT INTO[goadmin_role_permissions] ([role_id],[permission_id],[created_at],[updated_at])
   113  VALUES
   114  	(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
   115  	(1,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
   116  	(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00');
   117  
   118  
   119  
   120  
   121  CREATE TABLE[goadmin_role_users] (
   122   [role_id] int   NOT NULL,
   123   [user_id] int   NOT NULL,
   124   [created_at] datetime NULL DEFAULT GETDATE(),
   125   [updated_at] datetime NULL DEFAULT GETDATE(),
   126    PRIMARY KEY ([role_id],[user_id])
   127  ) 
   128  
   129  
   130  INSERT INTO[goadmin_role_users] ([role_id],[user_id],[created_at],[updated_at])
   131  VALUES
   132  	(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
   133  	(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00');
   134  
   135  
   136  
   137  
   138  CREATE TABLE[goadmin_roles] (
   139   [id] int   identity(1,1) ,
   140   [name] varchar(50)   NOT NULL UNIQUE,
   141   [slug] varchar(50)   NOT NULL,
   142   [created_at] datetime NULL DEFAULT GETDATE(),
   143   [updated_at] datetime NULL DEFAULT GETDATE(),
   144    PRIMARY KEY ([id]),
   145  ) 
   146  
   147  set  IDENTITY_INSERT [goadmin_roles] ON 
   148  
   149  INSERT INTO[goadmin_roles] ([id],[name],[slug],[created_at],[updated_at])
   150  VALUES
   151  	(1,'Administrator','administrator','2019-09-10 00:00:00','2019-09-10 00:00:00'),
   152  	(2,'Operator','operator','2019-09-10 00:00:00','2019-09-10 00:00:00');
   153  
   154  set  IDENTITY_INSERT [goadmin_roles] OFF
   155  
   156  
   157  CREATE TABLE[goadmin_session] (
   158   [id] int   identity(1,1) ,
   159   [sid] varchar(50)   DEFAULT '',
   160   [values] varchar(3000)   DEFAULT '',
   161   [created_at] datetime NULL DEFAULT GETDATE(),
   162   [updated_at] datetime NULL DEFAULT GETDATE(),
   163    PRIMARY KEY ([id])
   164  )  
   165  
   166  
   167  
   168  
   169  CREATE TABLE[goadmin_user_permissions] (
   170   [user_id] int   NOT NULL,
   171   [permission_id] int   NOT NULL,
   172   [created_at] datetime NULL DEFAULT GETDATE(),
   173   [updated_at] datetime NULL DEFAULT GETDATE(),
   174    PRIMARY KEY  ([user_id],[permission_id])
   175  ) 
   176  
   177  
   178  INSERT INTO[goadmin_user_permissions] ([user_id],[permission_id],[created_at],[updated_at])
   179  VALUES
   180  	(1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'),
   181  	(2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00');
   182  
   183  
   184  
   185  
   186  
   187  CREATE TABLE[goadmin_users] (
   188   [id] int   identity(1,1) ,
   189   [username] varchar(100)   NOT NULL UNIQUE,
   190   [password] varchar(100)   NOT NULL DEFAULT '',
   191   [name] varchar(100)   NOT NULL,
   192   [avatar] varchar(255)   DEFAULT NULL,
   193   [remember_token] varchar(100)   DEFAULT NULL,
   194   [created_at] datetime NULL DEFAULT GETDATE(),
   195   [updated_at] datetime NULL DEFAULT GETDATE(),
   196    PRIMARY KEY ([id]),
   197  ) 
   198  
   199  set  IDENTITY_INSERT [goadmin_users] ON 
   200  
   201  INSERT INTO[goadmin_users] ([id],[username],[password],[name],[avatar],[remember_token],[created_at],[updated_at])
   202  VALUES
   203  	(1,'admin','$2a$10$U3F/NSaf2kaVbyXTBp7ppOn0jZFyRqXRnYXB.AMioCjXl3Ciaj4oy','admin','','tlNcBVK9AvfYH7WEnwB1RKvocJu8FfRy4um3DJtwdHuJy0dwFsLOgAc0xUfh','2019-09-10 00:00:00','2019-09-10 00:00:00'),
   204  	(2,'operator','$2a$10$rVqkOzHjN2MdlEprRflb1eGP0oZXuSrbJLOmJagFsCd81YZm0bsh.','Operator','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00');
   205  set  IDENTITY_INSERT [goadmin_users] OFF 
   206  
   207