· 5 years ago · Feb 17, 2020, 02:44 PM
1-- Adminer 4.7.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `failed_jobs`;
11CREATE TABLE `failed_jobs` (
12 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
13 `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
14 `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
15 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
16 `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
17 `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
18 PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
20
21
22DROP TABLE IF EXISTS `migrations`;
23CREATE TABLE `migrations` (
24 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
25 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
26 `batch` int(11) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
29
30INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
31(1, '2014_10_12_000000_create_users_table', 1),
32(2, '2014_10_12_100000_create_password_resets_table', 1),
33(3, '2019_08_19_000000_create_failed_jobs_table', 1),
34(4, '2019_11_28_191636_add_api_token_column_to_users_table', 2),
35(7, '2019_11_28_230522_create_servers_table', 3),
36(13, '2019_12_12_135648_add_columns_to_users_table', 5),
37(14, '2019_12_12_150839_add_key_to_users_table', 6),
38(16, '2019_12_16_114321_add_keys_to_users_table', 7);
39
40DROP TABLE IF EXISTS `password_resets`;
41CREATE TABLE `password_resets` (
42 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
43 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
44 `created_at` timestamp NULL DEFAULT NULL,
45 KEY `password_resets_email_index` (`email`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
47
48
49DROP TABLE IF EXISTS `servers`;
50CREATE TABLE `servers` (
51 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
52 `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
53 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
54 `created_at` timestamp NULL DEFAULT NULL,
55 `updated_at` timestamp NULL DEFAULT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
58
59INSERT INTO `servers` (`id`, `ip`, `name`, `created_at`, `updated_at`) VALUES
60(1, '95.78.250.41:8080', 'Server #1', '2019-12-12 12:13:40', '2019-12-12 12:13:40'),
61(2, '84.39.252.80:9090', 'Server #2', '2020-02-06 14:36:19', '2020-02-06 14:36:19');
62
63DROP TABLE IF EXISTS `users`;
64CREATE TABLE `users` (
65 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
66 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
67 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
68 `email_verified_at` timestamp NULL DEFAULT NULL,
69 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
70 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
71 `created_at` timestamp NULL DEFAULT NULL,
72 `updated_at` timestamp NULL DEFAULT NULL,
73 `api_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
74 `server_id` bigint(20) unsigned DEFAULT '0',
75 `shinobi_password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
76 `shinobi_time` timestamp NULL DEFAULT NULL,
77 `shinobi_ke` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
78 `shinobi_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
79 PRIMARY KEY (`id`),
80 UNIQUE KEY `users_email_unique` (`email`),
81 KEY `users_server_id_foreign` (`server_id`),
82 CONSTRAINT `users_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
84
85INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `api_token`, `server_id`, `shinobi_password`, `shinobi_time`, `shinobi_ke`, `shinobi_token`) VALUES
86(1, 'User', 'true25@signum.video', NULL, '$2y$10$FjinPl0LYUmfyEcYcTzEDePW9urXQWNU71SnzPcqj2VSno2UPcdXG', NULL, '2019-12-12 11:55:57', '2020-02-17 10:06:47', NULL, 1, 'signal56', '2020-02-17 11:06:47', 'signum', 'f71306463ec2eda611f441329716ea67'),
87(6, 'User 2', 'ninja@signum.com', NULL, '$2y$10$KzTWK0X8FWOI16mK.gKnUOkqjPqApYjbP3fYI4IrvtqFlf3CQi6rK', NULL, '2019-12-12 11:55:57', '2020-02-13 19:44:17', NULL, 2, 'signum56', '2020-02-13 20:44:17', 'signum', 'aab4dce3588f7793944dee8129afe518');
88
89-- 2020-02-17 14:41:17