github.com/kotovmak/go-admin@v1.1.1/plugins/admin/data/mysql/admin.sql (about) 1 # ************************************************************ 2 # Sequel Pro SQL dump 3 # Version 4468 4 # 5 # http://www.sequelpro.com/ 6 # https://github.com/sequelpro/sequelpro 7 # 8 # Host: 127.0.0.1 (MySQL 5.7.19) 9 # Database: godmin 10 # Generation Time: 2019-09-12 04:16:47 +0000 11 # ************************************************************ 12 13 14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17 /*!40101 SET NAMES utf8 */; 18 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 19 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 20 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 21 22 23 # Dump of table goadmin_menu 24 # ------------------------------------------------------------ 25 26 DROP TABLE IF EXISTS `goadmin_menu`; 27 28 CREATE TABLE `goadmin_menu` ( 29 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 30 `parent_id` int(11) unsigned NOT NULL DEFAULT '0', 31 `type` tinyint(4) unsigned NOT NULL DEFAULT '0', 32 `order` int(11) unsigned NOT NULL DEFAULT '0', 33 `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 34 `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 35 `uri` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 36 `header` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, 37 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 38 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 39 PRIMARY KEY (`id`) 40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 41 42 LOCK TABLES `goadmin_menu` WRITE; 43 /*!40000 ALTER TABLE `goadmin_menu` DISABLE KEYS */; 44 45 INSERT INTO `goadmin_menu` (`id`, `parent_id`, `type`, `order`, `title`, `icon`, `uri`, `header`, `created_at`, `updated_at`) 46 VALUES 47 (1,0,1,2,'Admin','fa-tasks','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 48 (2,1,1,2,'Users','fa-users','/info/manager',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 49 (3,1,1,3,'Roles','fa-user','/info/roles',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 50 (4,1,1,4,'Permission','fa-ban','/info/permission',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 51 (5,1,1,5,'Menu','fa-bars','/menu',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 52 (6,1,1,6,'Operation log','fa-history','/info/op',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 53 (7,0,1,1,'Dashboard','fa-bar-chart','/',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'); 54 55 /*!40000 ALTER TABLE `goadmin_menu` ENABLE KEYS */; 56 UNLOCK TABLES; 57 58 59 # Dump of table goadmin_operation_log 60 # ------------------------------------------------------------ 61 62 DROP TABLE IF EXISTS `goadmin_operation_log`; 63 64 CREATE TABLE `goadmin_operation_log` ( 65 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 66 `user_id` int(11) unsigned NOT NULL, 67 `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, 68 `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, 69 `ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, 70 `input` text COLLATE utf8mb4_unicode_ci NOT NULL, 71 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 72 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 73 PRIMARY KEY (`id`), 74 KEY `admin_operation_log_user_id_index` (`user_id`) 75 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 76 77 78 79 # Dump of table goadmin_permissions 80 # ------------------------------------------------------------ 81 82 DROP TABLE IF EXISTS `goadmin_permissions`; 83 84 CREATE TABLE `goadmin_permissions` ( 85 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 86 `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 87 `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 88 `http_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, 89 `http_path` text COLLATE utf8mb4_unicode_ci NOT NULL, 90 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 91 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 92 PRIMARY KEY (`id`), 93 UNIQUE KEY `admin_permissions_name_unique` (`name`) 94 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 95 96 LOCK TABLES `goadmin_permissions` WRITE; 97 /*!40000 ALTER TABLE `goadmin_permissions` DISABLE KEYS */; 98 99 INSERT INTO `goadmin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `created_at`, `updated_at`) 100 VALUES 101 (1,'All permission','*','','*','2019-09-10 00:00:00','2019-09-10 00:00:00'), 102 (2,'Dashboard','dashboard','GET,PUT,POST,DELETE','/','2019-09-10 00:00:00','2019-09-10 00:00:00'); 103 104 /*!40000 ALTER TABLE `goadmin_permissions` ENABLE KEYS */; 105 UNLOCK TABLES; 106 107 108 # Dump of table goadmin_role_menu 109 # ------------------------------------------------------------ 110 111 DROP TABLE IF EXISTS `goadmin_role_menu`; 112 113 CREATE TABLE `goadmin_role_menu` ( 114 `role_id` int(11) unsigned NOT NULL, 115 `menu_id` int(11) unsigned NOT NULL, 116 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 117 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 118 KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`) 119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 120 121 LOCK TABLES `goadmin_role_menu` WRITE; 122 /*!40000 ALTER TABLE `goadmin_role_menu` DISABLE KEYS */; 123 124 INSERT INTO `goadmin_role_menu` (`role_id`, `menu_id`, `created_at`, `updated_at`) 125 VALUES 126 (1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 127 (1,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 128 (2,7,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 129 (1,8,'2019-09-11 10:20:55','2019-09-11 10:20:55'), 130 (2,8,'2019-09-11 10:20:55','2019-09-11 10:20:55'); 131 132 /*!40000 ALTER TABLE `goadmin_role_menu` ENABLE KEYS */; 133 UNLOCK TABLES; 134 135 136 # Dump of table goadmin_role_permissions 137 # ------------------------------------------------------------ 138 139 DROP TABLE IF EXISTS `goadmin_role_permissions`; 140 141 CREATE TABLE `goadmin_role_permissions` ( 142 `role_id` int(11) unsigned NOT NULL, 143 `permission_id` int(11) unsigned NOT NULL, 144 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 145 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 146 UNIQUE KEY `admin_role_permissions` (`role_id`,`permission_id`) 147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 148 149 LOCK TABLES `goadmin_role_permissions` WRITE; 150 /*!40000 ALTER TABLE `goadmin_role_permissions` DISABLE KEYS */; 151 152 INSERT INTO `goadmin_role_permissions` (`role_id`, `permission_id`, `created_at`, `updated_at`) 153 VALUES 154 (1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 155 (1,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 156 (2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'); 157 158 /*!40000 ALTER TABLE `goadmin_role_permissions` ENABLE KEYS */; 159 UNLOCK TABLES; 160 161 162 # Dump of table goadmin_role_users 163 # ------------------------------------------------------------ 164 165 DROP TABLE IF EXISTS `goadmin_role_users`; 166 167 CREATE TABLE `goadmin_role_users` ( 168 `role_id` int(11) unsigned NOT NULL, 169 `user_id` int(11) unsigned NOT NULL, 170 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 171 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 172 UNIQUE KEY `admin_user_roles` (`role_id`,`user_id`) 173 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 174 175 LOCK TABLES `goadmin_role_users` WRITE; 176 /*!40000 ALTER TABLE `goadmin_role_users` DISABLE KEYS */; 177 178 INSERT INTO `goadmin_role_users` (`role_id`, `user_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 /*!40000 ALTER TABLE `goadmin_role_users` ENABLE KEYS */; 184 UNLOCK TABLES; 185 186 187 # Dump of table goadmin_roles 188 # ------------------------------------------------------------ 189 190 DROP TABLE IF EXISTS `goadmin_roles`; 191 192 CREATE TABLE `goadmin_roles` ( 193 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 194 `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 195 `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, 196 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 197 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 198 PRIMARY KEY (`id`), 199 UNIQUE KEY `admin_roles_name_unique` (`name`) 200 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 201 202 LOCK TABLES `goadmin_roles` WRITE; 203 /*!40000 ALTER TABLE `goadmin_roles` DISABLE KEYS */; 204 205 INSERT INTO `goadmin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`) 206 VALUES 207 (1,'Administrator','administrator','2019-09-10 00:00:00','2019-09-10 00:00:00'), 208 (2,'Operator','operator','2019-09-10 00:00:00','2019-09-10 00:00:00'); 209 210 /*!40000 ALTER TABLE `goadmin_roles` ENABLE KEYS */; 211 UNLOCK TABLES; 212 213 214 # Dump of table goadmin_session 215 # ------------------------------------------------------------ 216 217 DROP TABLE IF EXISTS `goadmin_session`; 218 219 CREATE TABLE `goadmin_session` ( 220 `id` int(11) unsigned NOT NULL AUTO_INCREMENT, 221 `sid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 222 `values` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 223 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 224 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 225 PRIMARY KEY (`id`) 226 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 227 228 229 230 # Dump of table goadmin_user_permissions 231 # ------------------------------------------------------------ 232 233 DROP TABLE IF EXISTS `goadmin_user_permissions`; 234 235 CREATE TABLE `goadmin_user_permissions` ( 236 `user_id` int(11) unsigned NOT NULL, 237 `permission_id` int(11) unsigned NOT NULL, 238 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 239 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 240 UNIQUE KEY `admin_user_permissions` (`user_id`,`permission_id`) 241 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 242 243 LOCK TABLES `goadmin_user_permissions` WRITE; 244 /*!40000 ALTER TABLE `goadmin_user_permissions` DISABLE KEYS */; 245 246 INSERT INTO `goadmin_user_permissions` (`user_id`, `permission_id`, `created_at`, `updated_at`) 247 VALUES 248 (1,1,'2019-09-10 00:00:00','2019-09-10 00:00:00'), 249 (2,2,'2019-09-10 00:00:00','2019-09-10 00:00:00'); 250 251 /*!40000 ALTER TABLE `goadmin_user_permissions` ENABLE KEYS */; 252 UNLOCK TABLES; 253 254 255 # Dump of table goadmin_users 256 # ------------------------------------------------------------ 257 258 DROP TABLE IF EXISTS `goadmin_users`; 259 260 CREATE TABLE `goadmin_users` ( 261 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 262 `username` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL, 263 `password` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 264 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, 265 `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, 266 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, 267 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 268 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 269 PRIMARY KEY (`id`), 270 UNIQUE KEY `admin_users_username_unique` (`username`) 271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 272 273 LOCK TABLES `goadmin_users` WRITE; 274 /*!40000 ALTER TABLE `goadmin_users` DISABLE KEYS */; 275 276 INSERT INTO `goadmin_users` (`id`, `username`, `password`, `name`, `avatar`, `remember_token`, `created_at`, `updated_at`) 277 VALUES 278 (1,'admin','$2a$10$U3F/NSaf2kaVbyXTBp7ppOn0jZFyRqXRnYXB.AMioCjXl3Ciaj4oy','admin','','tlNcBVK9AvfYH7WEnwB1RKvocJu8FfRy4um3DJtwdHuJy0dwFsLOgAc0xUfh','2019-09-10 00:00:00','2019-09-10 00:00:00'), 279 (2,'operator','$2a$10$rVqkOzHjN2MdlEprRflb1eGP0oZXuSrbJLOmJagFsCd81YZm0bsh.','Operator','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'); 280 281 /*!40000 ALTER TABLE `goadmin_users` ENABLE KEYS */; 282 UNLOCK TABLES; 283 284 285 286 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 287 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 288 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 289 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 290 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 291 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;