· 5 years ago · Mar 05, 2020, 10:20 PM
1-- Adminer 4.6.3 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 `companies`;
11CREATE TABLE `companies` (
12 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
13 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
14 `machine` int(11) NOT NULL,
15 `tin` varchar(30) NOT NULL,
16 `employees` bigint(20) unsigned NOT NULL,
17 `created_at` timestamp NOT NULL,
18 `updated_at` timestamp NOT NULL,
19 `active` int(1) NOT NULL,
20 PRIMARY KEY (`id`),
21 KEY `empregados` (`employees`),
22 CONSTRAINT `companies_ibfk_1` FOREIGN KEY (`employees`) REFERENCES `users` (`id`)
23) ENGINE=InnoDB DEFAULT CHARSET=latin1;
24
25
26DROP TABLE IF EXISTS `failed_jobs`;
27CREATE TABLE `failed_jobs` (
28 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
29 `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
30 `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
31 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
32 `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
33 `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
36
37
38DROP TABLE IF EXISTS `machine`;
39CREATE TABLE `machine` (
40 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
41 `name` varchar(120) NOT NULL,
42 `kms` int(11) DEFAULT NULL,
43 `hours` int(11) DEFAULT NULL,
44 `next_maintenance` bigint(20) unsigned DEFAULT NULL,
45 `maintenaces` bigint(20) unsigned DEFAULT NULL,
46 `observations` varchar(250) DEFAULT NULL,
47 PRIMARY KEY (`id`),
48 KEY `next_maintenance` (`next_maintenance`),
49 KEY `maintenaces` (`maintenaces`),
50 CONSTRAINT `machine_ibfk_1` FOREIGN KEY (`next_maintenance`) REFERENCES `maintenance` (`id`),
51 CONSTRAINT `machine_ibfk_2` FOREIGN KEY (`maintenaces`) REFERENCES `maintenance` (`id`)
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54
55DROP TABLE IF EXISTS `maintenance`;
56CREATE TABLE `maintenance` (
57 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
58 `date` date DEFAULT NULL,
59 `employee` bigint(20) unsigned DEFAULT NULL,
60 `type` int(11) NOT NULL,
61 PRIMARY KEY (`id`),
62 KEY `employee` (`employee`),
63 CONSTRAINT `maintenance_ibfk_1` FOREIGN KEY (`employee`) REFERENCES `users` (`id`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66
67DROP TABLE IF EXISTS `migrations`;
68CREATE TABLE `migrations` (
69 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
70 `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
71 `batch` int(11) NOT NULL,
72 PRIMARY KEY (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
74
75INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
76(1, '2014_10_12_000000_create_users_table', 1),
77(2, '2014_10_12_100000_create_password_resets_table', 1),
78(3, '2019_08_19_000000_create_failed_jobs_table', 1),
79(4, '2019_10_09_134924_initial_structure', 1),
80(5, '2016_06_01_000001_create_oauth_auth_codes_table', 2),
81(6, '2016_06_01_000002_create_oauth_access_tokens_table', 2),
82(7, '2016_06_01_000003_create_oauth_refresh_tokens_table', 2),
83(8, '2016_06_01_000004_create_oauth_clients_table', 2),
84(9, '2016_06_01_000005_create_oauth_personal_access_clients_table', 2);
85
86DROP TABLE IF EXISTS `oauth_access_tokens`;
87CREATE TABLE `oauth_access_tokens` (
88 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
89 `user_id` bigint(20) unsigned DEFAULT NULL,
90 `client_id` bigint(20) unsigned NOT NULL,
91 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
92 `scopes` text COLLATE utf8mb4_unicode_ci,
93 `revoked` tinyint(1) NOT NULL,
94 `created_at` timestamp NULL DEFAULT NULL,
95 `updated_at` timestamp NULL DEFAULT NULL,
96 `expires_at` datetime DEFAULT NULL,
97 PRIMARY KEY (`id`),
98 KEY `oauth_access_tokens_user_id_index` (`user_id`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
100
101INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
102('036ddb291af0d9be746d18d94ad8af95b96b0e4e891e25152accbf11b06db6afba2e111fa2222b79', 1, 2, NULL, '[]', 0, '2020-03-05 09:13:22', '2020-03-05 09:13:22', '2021-03-05 09:13:22'),
103('176784743d2bc86582dddc1ede1323c09ec09cb8c705ff71cfa7b31fbd914f069b9fb554f73fec23', 1, 2, NULL, '[]', 0, '2020-03-05 14:08:09', '2020-03-05 14:08:09', '2021-03-05 14:08:09'),
104('3334c17326fc15d8fefdb871845e48fa4934e26446f83a1abc752409b7eb976b0d70ff599952d397', 1, 2, NULL, '[]', 0, '2020-03-05 14:08:08', '2020-03-05 14:08:08', '2021-03-05 14:08:08'),
105('3eaf9ca3213f17c7ad809af733febd3f7685e2798e5e0ecc48e9bbe73addd1ebc99a2e9f1d84742e', 1, 2, NULL, '[]', 0, '2020-03-05 17:54:29', '2020-03-05 17:54:29', '2021-03-05 17:54:29'),
106('821efbb6c718f8effb4343f9de516f4b80344237090c921262c1f2d1c8fb945060814edb380119e5', 1, 2, NULL, '[]', 0, '2020-03-05 08:57:01', '2020-03-05 08:57:01', '2021-03-05 08:57:01'),
107('85d224d40207951486be47f6617eeee1eb36305e62a2a336f68073c36b85d6fb66ef9a4dacea01e6', 1, 2, NULL, '[]', 0, '2020-03-05 08:59:12', '2020-03-05 08:59:12', '2021-03-05 08:59:12'),
108('ae36ddb1879f830dfee2bc32ca8bcc5b006189860fe9a00ca2fd8bfe7fe64e1c514523c1a2f8cb29', 1, 2, NULL, '[]', 0, '2020-03-05 20:04:55', '2020-03-05 20:04:55', '2021-03-05 20:04:55'),
109('c3f6b79a3f2a12f78bf7d9d96fafee94b957a67cd8672b6d44fabb483544b57577f93f0c311d8fa2', 1, 2, NULL, '[]', 0, '2020-03-05 09:05:21', '2020-03-05 09:05:21', '2021-03-05 09:05:21'),
110('dad88bdac9cb46bef3bd3eadcfd116d9869426da8bc6b41d079723b529289933ef7886f04a43e502', 1, 2, NULL, '[]', 0, '2020-02-29 15:15:54', '2020-02-29 15:15:54', '2021-03-01 15:15:54'),
111('dd004f9072c350aded671224908dea1fc668c5918f2247ffd3aa8614bf6e1034e1bb140064ef241e', 1, 2, NULL, '[]', 0, '2020-03-04 19:23:47', '2020-03-04 19:23:47', '2021-03-04 19:23:47'),
112('dd692cf28c8824f65de79abe977b550a755ece3f75c2d301726e53808f4400798683613820dc04be', 1, 2, NULL, '[]', 0, '2020-02-29 15:08:43', '2020-02-29 15:08:43', '2021-03-01 15:08:43'),
113('fd7d1c16bfe3dece5125bf34718a4cba2a885b34cd6eec15bc82bd5599f2c27e4a8b967f00464d06', 1, 2, NULL, '[]', 0, '2020-02-29 15:02:19', '2020-02-29 15:02:19', '2021-03-01 15:02:19');
114
115DROP TABLE IF EXISTS `oauth_auth_codes`;
116CREATE TABLE `oauth_auth_codes` (
117 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
118 `user_id` bigint(20) unsigned NOT NULL,
119 `client_id` bigint(20) unsigned NOT NULL,
120 `scopes` text COLLATE utf8mb4_unicode_ci,
121 `revoked` tinyint(1) NOT NULL,
122 `expires_at` datetime DEFAULT NULL,
123 PRIMARY KEY (`id`),
124 KEY `oauth_auth_codes_user_id_index` (`user_id`)
125) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
126
127
128DROP TABLE IF EXISTS `oauth_clients`;
129CREATE TABLE `oauth_clients` (
130 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
131 `user_id` bigint(20) unsigned DEFAULT NULL,
132 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
133 `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
134 `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
135 `personal_access_client` tinyint(1) NOT NULL,
136 `password_client` tinyint(1) NOT NULL,
137 `revoked` tinyint(1) NOT NULL,
138 `created_at` timestamp NULL DEFAULT NULL,
139 `updated_at` timestamp NULL DEFAULT NULL,
140 PRIMARY KEY (`id`),
141 KEY `oauth_clients_user_id_index` (`user_id`)
142) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
143
144INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
145(1, NULL, 'Laravel Personal Access Client', 'gCRv8lXtdezQfNi3VJ250muHtndgzXU2GW8Idj7k', 'http://localhost', 1, 0, 0, '2020-02-29 14:39:00', '2020-02-29 14:39:00'),
146(2, NULL, 'Laravel Password Grant Client', 'ApKYkWaoiSkp5k83W48HorSPHwADKwm2lqeWMhhO', 'http://localhost', 0, 1, 0, '2020-02-29 14:39:00', '2020-02-29 14:39:00');
147
148DROP TABLE IF EXISTS `oauth_personal_access_clients`;
149CREATE TABLE `oauth_personal_access_clients` (
150 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
151 `client_id` bigint(20) unsigned NOT NULL,
152 `created_at` timestamp NULL DEFAULT NULL,
153 `updated_at` timestamp NULL DEFAULT NULL,
154 PRIMARY KEY (`id`)
155) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
156
157INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
158(1, 1, '2020-02-29 14:39:00', '2020-02-29 14:39:00'),
159(2, 3, '2020-03-04 19:04:46', '2020-03-04 19:04:46');
160
161DROP TABLE IF EXISTS `oauth_refresh_tokens`;
162CREATE TABLE `oauth_refresh_tokens` (
163 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
164 `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
165 `revoked` tinyint(1) NOT NULL,
166 `expires_at` datetime DEFAULT NULL,
167 PRIMARY KEY (`id`)
168) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
169
170INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
171('11266895a691c7ffdf39167df37cc8170ef2ceea4043ab24d9977e50c19addcd747d831bc19ea2fd', '821efbb6c718f8effb4343f9de516f4b80344237090c921262c1f2d1c8fb945060814edb380119e5', 0, '2021-03-05 08:57:01'),
172('1c1b8aea9be0c1fe2787daee7a63134fb0253acb118ec0b8bbb093f51dae8a9ee4727bc8e34080ae', 'fd7d1c16bfe3dece5125bf34718a4cba2a885b34cd6eec15bc82bd5599f2c27e4a8b967f00464d06', 0, '2021-03-01 15:02:19'),
173('3a79af00ce9848b581378f601a9156435f6951859f058d1d148d5ffc8bd3b0900fe4c75af48a6dcc', '3eaf9ca3213f17c7ad809af733febd3f7685e2798e5e0ecc48e9bbe73addd1ebc99a2e9f1d84742e', 0, '2021-03-05 17:54:29'),
174('41d0076fee461d1c1533986760d65f45af5970c748e49aa2a940f715af977e840bbb052a2816a48a', '85d224d40207951486be47f6617eeee1eb36305e62a2a336f68073c36b85d6fb66ef9a4dacea01e6', 0, '2021-03-05 08:59:12'),
175('4d361ee419c5e44405b9ea0ab2cd9ab8fb8b957470c34f9a7f3e510b1d85d3cf91bdcc3e95c4c3a6', '176784743d2bc86582dddc1ede1323c09ec09cb8c705ff71cfa7b31fbd914f069b9fb554f73fec23', 0, '2021-03-05 14:08:09'),
176('56d01cb607076e2423ec9d26b9d1a2a2cc053f74ff13b60a4f0bb90c356efebd8184ec51280edede', 'ae36ddb1879f830dfee2bc32ca8bcc5b006189860fe9a00ca2fd8bfe7fe64e1c514523c1a2f8cb29', 0, '2021-03-05 20:04:55'),
177('5ff62406da066c336d3bd93f29f3e63d3414a54e22f357f0011b702d4aeb46d7a6e25ca77cb15984', '3334c17326fc15d8fefdb871845e48fa4934e26446f83a1abc752409b7eb976b0d70ff599952d397', 0, '2021-03-05 14:08:08'),
178('73b205296da03e73c44f7d7856d19a873b1fede3bafeb7eaef5474c9773f714b9b3d22349dc0528a', 'dad88bdac9cb46bef3bd3eadcfd116d9869426da8bc6b41d079723b529289933ef7886f04a43e502', 0, '2021-03-01 15:15:55'),
179('7d2dd6e1de9141cf50f200d142de53d8fcffd77cf6c4de62d06ee868ead66de60351f1df7f77c74d', 'ccc1ea87f94907a90c0dc3fc6a6901cb6dde88f1f94e3ac1a9e31c4bf3d4cc063f7bb2211cc1a78c', 0, '2021-03-01 15:10:37'),
180('9a53941fdcfe498340076b7c2f5f6aaf0a5abf587c4e0eeeb58a5de801a5576b54d2e199fcc73e43', 'dd692cf28c8824f65de79abe977b550a755ece3f75c2d301726e53808f4400798683613820dc04be', 0, '2021-03-01 15:08:43'),
181('b710c05e23b2bbf67dbd9078f65827c300e299a932df83fac76d5315fa38b02694fd59d23f9ac5f0', '036ddb291af0d9be746d18d94ad8af95b96b0e4e891e25152accbf11b06db6afba2e111fa2222b79', 0, '2021-03-05 09:13:22'),
182('c22db9835fc4c9fbb0555a7cda267a3683511c4b02a6c9ea9bc0df99de7f612f8d7d1532dc746dc8', 'c3f6b79a3f2a12f78bf7d9d96fafee94b957a67cd8672b6d44fabb483544b57577f93f0c311d8fa2', 0, '2021-03-05 09:05:21'),
183('e64e47f341554f2056855b89070586385fc06a6cf65346fc2908053f938fc87943ef4e3fd0cce670', 'dd004f9072c350aded671224908dea1fc668c5918f2247ffd3aa8614bf6e1034e1bb140064ef241e', 0, '2021-03-04 19:23:47');
184
185DROP TABLE IF EXISTS `password_resets`;
186CREATE TABLE `password_resets` (
187 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
188 `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
189 `created_at` timestamp NULL DEFAULT NULL,
190 KEY `password_resets_email_index` (`email`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
192
193
194DROP TABLE IF EXISTS `users`;
195CREATE TABLE `users` (
196 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
197 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
198 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
199 `email_verified_at` timestamp NULL DEFAULT NULL,
200 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
201 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
202 `created_at` timestamp NULL DEFAULT NULL,
203 `updated_at` timestamp NULL DEFAULT NULL,
204 `type` enum('e','g','a') COLLATE utf8mb4_unicode_ci NOT NULL,
205 `active` tinyint(1) NOT NULL DEFAULT '1',
206 PRIMARY KEY (`id`),
207 UNIQUE KEY `users_email_unique` (`email`)
208) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
209
210INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `type`, `active`) VALUES
211(1, 'Miguel Mascarenhas', 'miguel@mail.pt', NULL, '$2y$10$fEjoHP5NMzhmkBp..tHJDuSkGNqsS7l8sgWwBS.EclxIQsaGoikbq', NULL, '2020-03-04 19:18:53', '2020-03-04 19:18:53', 'a', 1);
212
213-- 2020-03-05 22:15:15