CoCalc -- mysql-schema.sql

GitHub Repository: pterodactyl/panel
Path: blob/1.0-develop/database/schema/mysql-schema.sql
⁷⁴⁶⁰ views
1
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2
/*!40103 SET TIME_ZONE='+00:00' */;
3
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
4
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
7
DROP TABLE IF EXISTS `activity_log_subjects`;
8
/*!40101 SET @saved_cs_client     = @@character_set_client */;
9
/*!40101 SET character_set_client = utf8 */;
10
CREATE TABLE `activity_log_subjects` (
11
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
12
  `activity_log_id` bigint(20) unsigned NOT NULL,
13
  `subject_type` varchar(191) NOT NULL,
14
  `subject_id` bigint(20) unsigned NOT NULL,
15
  PRIMARY KEY (`id`),
16
  KEY `activity_log_subjects_activity_log_id_foreign` (`activity_log_id`),
17
  KEY `activity_log_subjects_subject_type_subject_id_index` (`subject_type`,`subject_id`),
18
  CONSTRAINT `activity_log_subjects_activity_log_id_foreign` FOREIGN KEY (`activity_log_id`) REFERENCES `activity_logs` (`id`) ON DELETE CASCADE
19
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
20
/*!40101 SET character_set_client = @saved_cs_client */;
21
DROP TABLE IF EXISTS `activity_logs`;
22
/*!40101 SET @saved_cs_client     = @@character_set_client */;
23
/*!40101 SET character_set_client = utf8 */;
24
CREATE TABLE `activity_logs` (
25
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
26
  `batch` char(36) DEFAULT NULL,
27
  `event` varchar(191) NOT NULL,
28
  `ip` varchar(191) NOT NULL,
29
  `description` text DEFAULT NULL,
30
  `actor_type` varchar(191) DEFAULT NULL,
31
  `actor_id` bigint(20) unsigned DEFAULT NULL,
32
  `api_key_id` int(10) unsigned DEFAULT NULL,
33
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`properties`)),
34
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
35
  PRIMARY KEY (`id`),
36
  KEY `activity_logs_actor_type_actor_id_index` (`actor_type`,`actor_id`),
37
  KEY `activity_logs_event_index` (`event`)
38
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39
/*!40101 SET character_set_client = @saved_cs_client */;
40
DROP TABLE IF EXISTS `allocations`;
41
/*!40101 SET @saved_cs_client     = @@character_set_client */;
42
/*!40101 SET character_set_client = utf8 */;
43
CREATE TABLE `allocations` (
44
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
45
  `node_id` int(10) unsigned NOT NULL,
46
  `ip` varchar(191) NOT NULL,
47
  `ip_alias` text DEFAULT NULL,
48
  `port` mediumint(8) unsigned NOT NULL,
49
  `server_id` int(10) unsigned DEFAULT NULL,
50
  `notes` varchar(191) DEFAULT NULL,
51
  `created_at` timestamp NULL DEFAULT NULL,
52
  `updated_at` timestamp NULL DEFAULT NULL,
53
  PRIMARY KEY (`id`),
54
  UNIQUE KEY `allocations_node_id_ip_port_unique` (`node_id`,`ip`,`port`),
55
  KEY `allocations_server_id_foreign` (`server_id`),
56
  CONSTRAINT `allocations_node_id_foreign` FOREIGN KEY (`node_id`) REFERENCES `nodes` (`id`) ON DELETE CASCADE,
57
  CONSTRAINT `allocations_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE SET NULL
58
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
59
/*!40101 SET character_set_client = @saved_cs_client */;
60
DROP TABLE IF EXISTS `api_keys`;
61
/*!40101 SET @saved_cs_client     = @@character_set_client */;
62
/*!40101 SET character_set_client = utf8 */;
63
CREATE TABLE `api_keys` (
64
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
65
  `user_id` int(10) unsigned NOT NULL,
66
  `key_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
67
  `identifier` char(16) DEFAULT NULL,
68
  `token` text NOT NULL,
69
  `allowed_ips` text DEFAULT NULL,
70
  `memo` text DEFAULT NULL,
71
  `last_used_at` timestamp NULL DEFAULT NULL,
72
  `expires_at` timestamp NULL DEFAULT NULL,
73
  `created_at` timestamp NULL DEFAULT NULL,
74
  `updated_at` timestamp NULL DEFAULT NULL,
75
  `r_servers` tinyint(3) unsigned NOT NULL DEFAULT 0,
76
  `r_nodes` tinyint(3) unsigned NOT NULL DEFAULT 0,
77
  `r_allocations` tinyint(3) unsigned NOT NULL DEFAULT 0,
78
  `r_users` tinyint(3) unsigned NOT NULL DEFAULT 0,
79
  `r_locations` tinyint(3) unsigned NOT NULL DEFAULT 0,
80
  `r_nests` tinyint(3) unsigned NOT NULL DEFAULT 0,
81
  `r_eggs` tinyint(3) unsigned NOT NULL DEFAULT 0,
82
  `r_database_hosts` tinyint(3) unsigned NOT NULL DEFAULT 0,
83
  `r_server_databases` tinyint(3) unsigned NOT NULL DEFAULT 0,
84
  PRIMARY KEY (`id`),
85
  UNIQUE KEY `api_keys_identifier_unique` (`identifier`),
86
  KEY `api_keys_user_id_foreign` (`user_id`),
87
  CONSTRAINT `api_keys_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
88
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
89
/*!40101 SET character_set_client = @saved_cs_client */;
90
DROP TABLE IF EXISTS `api_logs`;
91
/*!40101 SET @saved_cs_client     = @@character_set_client */;
92
/*!40101 SET character_set_client = utf8 */;
93
CREATE TABLE `api_logs` (
94
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
95
  `authorized` tinyint(1) NOT NULL,
96
  `error` text DEFAULT NULL,
97
  `key` char(16) DEFAULT NULL,
98
  `method` char(6) NOT NULL,
99
  `route` text NOT NULL,
100
  `content` text DEFAULT NULL,
101
  `user_agent` text NOT NULL,
102
  `request_ip` varchar(45) NOT NULL,
103
  `created_at` timestamp NULL DEFAULT NULL,
104
  `updated_at` timestamp NULL DEFAULT NULL,
105
  PRIMARY KEY (`id`)
106
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
107
/*!40101 SET character_set_client = @saved_cs_client */;
108
DROP TABLE IF EXISTS `audit_logs`;
109
/*!40101 SET @saved_cs_client     = @@character_set_client */;
110
/*!40101 SET character_set_client = utf8 */;
111
CREATE TABLE `audit_logs` (
112
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
113
  `uuid` char(36) NOT NULL,
114
  `is_system` tinyint(1) NOT NULL DEFAULT 0,
115
  `user_id` int(10) unsigned DEFAULT NULL,
116
  `server_id` int(10) unsigned DEFAULT NULL,
117
  `action` varchar(191) NOT NULL,
118
  `subaction` varchar(191) DEFAULT NULL,
119
  `device` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`device`)),
120
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`metadata`)),
121
  `created_at` timestamp NOT NULL,
122
  PRIMARY KEY (`id`),
123
  KEY `audit_logs_user_id_foreign` (`user_id`),
124
  KEY `audit_logs_server_id_foreign` (`server_id`),
125
  KEY `audit_logs_action_server_id_index` (`action`,`server_id`),
126
  CONSTRAINT `audit_logs_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE,
127
  CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
128
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
129
/*!40101 SET character_set_client = @saved_cs_client */;
130
DROP TABLE IF EXISTS `backups`;
131
/*!40101 SET @saved_cs_client     = @@character_set_client */;
132
/*!40101 SET character_set_client = utf8 */;
133
CREATE TABLE `backups` (
134
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
135
  `server_id` int(10) unsigned NOT NULL,
136
  `uuid` char(36) NOT NULL,
137
  `upload_id` text DEFAULT NULL,
138
  `is_successful` tinyint(1) NOT NULL DEFAULT 0,
139
  `is_locked` tinyint(3) unsigned NOT NULL DEFAULT 0,
140
  `name` varchar(191) NOT NULL,
141
  `ignored_files` text NOT NULL,
142
  `disk` varchar(191) NOT NULL,
143
  `checksum` varchar(191) DEFAULT NULL,
144
  `bytes` bigint(20) unsigned NOT NULL DEFAULT 0,
145
  `completed_at` timestamp NULL DEFAULT NULL,
146
  `created_at` timestamp NULL DEFAULT NULL,
147
  `updated_at` timestamp NULL DEFAULT NULL,
148
  `deleted_at` timestamp NULL DEFAULT NULL,
149
  PRIMARY KEY (`id`),
150
  UNIQUE KEY `backups_uuid_unique` (`uuid`),
151
  KEY `backups_server_id_foreign` (`server_id`),
152
  CONSTRAINT `backups_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE
153
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
154
/*!40101 SET character_set_client = @saved_cs_client */;
155
DROP TABLE IF EXISTS `database_hosts`;
156
/*!40101 SET @saved_cs_client     = @@character_set_client */;
157
/*!40101 SET character_set_client = utf8 */;
158
CREATE TABLE `database_hosts` (
159
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
160
  `name` varchar(191) NOT NULL,
161
  `host` varchar(191) NOT NULL,
162
  `port` int(10) unsigned NOT NULL,
163
  `username` varchar(191) NOT NULL,
164
  `password` text NOT NULL,
165
  `max_databases` int(10) unsigned DEFAULT NULL,
166
  `node_id` int(10) unsigned DEFAULT NULL,
167
  `created_at` timestamp NULL DEFAULT NULL,
168
  `updated_at` timestamp NULL DEFAULT NULL,
169
  PRIMARY KEY (`id`),
170
  KEY `database_hosts_node_id_foreign` (`node_id`),
171
  CONSTRAINT `database_hosts_node_id_foreign` FOREIGN KEY (`node_id`) REFERENCES `nodes` (`id`) ON DELETE SET NULL
172
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
173
/*!40101 SET character_set_client = @saved_cs_client */;
174
DROP TABLE IF EXISTS `databases`;
175
/*!40101 SET @saved_cs_client     = @@character_set_client */;
176
/*!40101 SET character_set_client = utf8 */;
177
CREATE TABLE `databases` (
178
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
179
  `server_id` int(10) unsigned NOT NULL,
180
  `database_host_id` int(10) unsigned NOT NULL,
181
  `database` varchar(191) NOT NULL,
182
  `username` varchar(191) NOT NULL,
183
  `remote` varchar(191) NOT NULL DEFAULT '%',
184
  `password` text NOT NULL,
185
  `max_connections` int(11) DEFAULT 0,
186
  `created_at` timestamp NULL DEFAULT NULL,
187
  `updated_at` timestamp NULL DEFAULT NULL,
188
  PRIMARY KEY (`id`),
189
  UNIQUE KEY `databases_database_host_id_username_unique` (`database_host_id`,`username`),
190
  UNIQUE KEY `databases_database_host_id_server_id_database_unique` (`database_host_id`,`server_id`,`database`),
191
  KEY `databases_server_id_foreign` (`server_id`),
192
  CONSTRAINT `databases_database_host_id_foreign` FOREIGN KEY (`database_host_id`) REFERENCES `database_hosts` (`id`),
193
  CONSTRAINT `databases_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`)
194
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
195
/*!40101 SET character_set_client = @saved_cs_client */;
196
DROP TABLE IF EXISTS `egg_mount`;
197
/*!40101 SET @saved_cs_client     = @@character_set_client */;
198
/*!40101 SET character_set_client = utf8 */;
199
CREATE TABLE `egg_mount` (
200
  `egg_id` int(10) unsigned NOT NULL,
201
  `mount_id` int(10) unsigned NOT NULL,
202
  UNIQUE KEY `egg_mount_egg_id_mount_id_unique` (`egg_id`,`mount_id`),
203
  KEY `egg_mount_mount_id_foreign` (`mount_id`),
204
  CONSTRAINT `egg_mount_egg_id_foreign` FOREIGN KEY (`egg_id`) REFERENCES `eggs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
205
  CONSTRAINT `egg_mount_mount_id_foreign` FOREIGN KEY (`mount_id`) REFERENCES `mounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
206
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
207
/*!40101 SET character_set_client = @saved_cs_client */;
208
DROP TABLE IF EXISTS `egg_variables`;
209
/*!40101 SET @saved_cs_client     = @@character_set_client */;
210
/*!40101 SET character_set_client = utf8 */;
211
CREATE TABLE `egg_variables` (
212
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
213
  `egg_id` int(10) unsigned NOT NULL,
214
  `name` varchar(191) NOT NULL,
215
  `description` text NOT NULL,
216
  `env_variable` varchar(191) NOT NULL,
217
  `default_value` text NOT NULL,
218
  `user_viewable` tinyint(3) unsigned NOT NULL,
219
  `user_editable` tinyint(3) unsigned NOT NULL,
220
  `rules` text DEFAULT NULL,
221
  `created_at` timestamp NULL DEFAULT NULL,
222
  `updated_at` timestamp NULL DEFAULT NULL,
223
  PRIMARY KEY (`id`),
224
  KEY `service_variables_egg_id_foreign` (`egg_id`),
225
  CONSTRAINT `service_variables_egg_id_foreign` FOREIGN KEY (`egg_id`) REFERENCES `eggs` (`id`) ON DELETE CASCADE
226
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
227
/*!40101 SET character_set_client = @saved_cs_client */;
228
DROP TABLE IF EXISTS `eggs`;
229
/*!40101 SET @saved_cs_client     = @@character_set_client */;
230
/*!40101 SET character_set_client = utf8 */;
231
CREATE TABLE `eggs` (
232
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
233
  `uuid` char(36) NOT NULL,
234
  `nest_id` int(10) unsigned NOT NULL,
235
  `author` varchar(191) NOT NULL,
236
  `name` varchar(191) NOT NULL,
237
  `description` text DEFAULT NULL,
238
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
239
  `docker_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`docker_images`)),
240
  `file_denylist` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`file_denylist`)),
241
  `update_url` text DEFAULT NULL,
242
  `config_files` text DEFAULT NULL,
243
  `config_startup` text DEFAULT NULL,
244
  `config_logs` text DEFAULT NULL,
245
  `config_stop` varchar(191) DEFAULT NULL,
246
  `config_from` int(10) unsigned DEFAULT NULL,
247
  `startup` text DEFAULT NULL,
248
  `script_container` varchar(191) NOT NULL DEFAULT 'alpine:3.4',
249
  `copy_script_from` int(10) unsigned DEFAULT NULL,
250
  `script_entry` varchar(191) NOT NULL DEFAULT 'ash',
251
  `script_is_privileged` tinyint(1) NOT NULL DEFAULT 1,
252
  `script_install` text DEFAULT NULL,
253
  `created_at` timestamp NULL DEFAULT NULL,
254
  `updated_at` timestamp NULL DEFAULT NULL,
255
  `force_outgoing_ip` tinyint(1) NOT NULL DEFAULT 0,
256
  PRIMARY KEY (`id`),
257
  UNIQUE KEY `service_options_uuid_unique` (`uuid`),
258
  KEY `service_options_nest_id_foreign` (`nest_id`),
259
  KEY `eggs_config_from_foreign` (`config_from`),
260
  KEY `eggs_copy_script_from_foreign` (`copy_script_from`),
261
  CONSTRAINT `eggs_config_from_foreign` FOREIGN KEY (`config_from`) REFERENCES `eggs` (`id`) ON DELETE SET NULL,
262
  CONSTRAINT `eggs_copy_script_from_foreign` FOREIGN KEY (`copy_script_from`) REFERENCES `eggs` (`id`) ON DELETE SET NULL,
263
  CONSTRAINT `service_options_nest_id_foreign` FOREIGN KEY (`nest_id`) REFERENCES `nests` (`id`) ON DELETE CASCADE
264
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
265
/*!40101 SET character_set_client = @saved_cs_client */;
266
DROP TABLE IF EXISTS `failed_jobs`;
267
/*!40101 SET @saved_cs_client     = @@character_set_client */;
268
/*!40101 SET character_set_client = utf8 */;
269
CREATE TABLE `failed_jobs` (
270
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
271
  `uuid` varchar(191) DEFAULT NULL,
272
  `connection` text NOT NULL,
273
  `queue` text NOT NULL,
274
  `payload` longtext NOT NULL,
275
  `failed_at` timestamp NOT NULL,
276
  `exception` text NOT NULL,
277
  PRIMARY KEY (`id`),
278
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
279
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
280
/*!40101 SET character_set_client = @saved_cs_client */;
281
DROP TABLE IF EXISTS `jobs`;
282
/*!40101 SET @saved_cs_client     = @@character_set_client */;
283
/*!40101 SET character_set_client = utf8 */;
284
CREATE TABLE `jobs` (
285
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
286
  `queue` varchar(191) NOT NULL,
287
  `payload` longtext NOT NULL,
288
  `attempts` tinyint(3) unsigned NOT NULL,
289
  `reserved_at` int(10) unsigned DEFAULT NULL,
290
  `available_at` int(10) unsigned NOT NULL,
291
  `created_at` int(10) unsigned NOT NULL,
292
  PRIMARY KEY (`id`),
293
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
294
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
295
/*!40101 SET character_set_client = @saved_cs_client */;
296
DROP TABLE IF EXISTS `locations`;
297
/*!40101 SET @saved_cs_client     = @@character_set_client */;
298
/*!40101 SET character_set_client = utf8 */;
299
CREATE TABLE `locations` (
300
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
301
  `short` varchar(191) NOT NULL,
302
  `long` text DEFAULT NULL,
303
  `created_at` timestamp NULL DEFAULT NULL,
304
  `updated_at` timestamp NULL DEFAULT NULL,
305
  PRIMARY KEY (`id`),
306
  UNIQUE KEY `locations_short_unique` (`short`)
307
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
308
/*!40101 SET character_set_client = @saved_cs_client */;
309
DROP TABLE IF EXISTS `migrations`;
310
/*!40101 SET @saved_cs_client     = @@character_set_client */;
311
/*!40101 SET character_set_client = utf8 */;
312
CREATE TABLE `migrations` (
313
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
314
  `migration` varchar(191) NOT NULL,
315
  `batch` int(11) NOT NULL,
316
  PRIMARY KEY (`id`)
317
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
318
/*!40101 SET character_set_client = @saved_cs_client */;
319
DROP TABLE IF EXISTS `mount_node`;
320
/*!40101 SET @saved_cs_client     = @@character_set_client */;
321
/*!40101 SET character_set_client = utf8 */;
322
CREATE TABLE `mount_node` (
323
  `node_id` int(10) unsigned NOT NULL,
324
  `mount_id` int(10) unsigned NOT NULL,
325
  UNIQUE KEY `mount_node_node_id_mount_id_unique` (`node_id`,`mount_id`),
326
  KEY `mount_node_mount_id_foreign` (`mount_id`),
327
  CONSTRAINT `mount_node_mount_id_foreign` FOREIGN KEY (`mount_id`) REFERENCES `mounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
328
  CONSTRAINT `mount_node_node_id_foreign` FOREIGN KEY (`node_id`) REFERENCES `nodes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
329
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
330
/*!40101 SET character_set_client = @saved_cs_client */;
331
DROP TABLE IF EXISTS `mount_server`;
332
/*!40101 SET @saved_cs_client     = @@character_set_client */;
333
/*!40101 SET character_set_client = utf8 */;
334
CREATE TABLE `mount_server` (
335
  `server_id` int(10) unsigned NOT NULL,
336
  `mount_id` int(10) unsigned NOT NULL,
337
  UNIQUE KEY `mount_server_server_id_mount_id_unique` (`server_id`,`mount_id`),
338
  KEY `mount_server_mount_id_foreign` (`mount_id`),
339
  CONSTRAINT `mount_server_mount_id_foreign` FOREIGN KEY (`mount_id`) REFERENCES `mounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
340
  CONSTRAINT `mount_server_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
341
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
342
/*!40101 SET character_set_client = @saved_cs_client */;
343
DROP TABLE IF EXISTS `mounts`;
344
/*!40101 SET @saved_cs_client     = @@character_set_client */;
345
/*!40101 SET character_set_client = utf8 */;
346
CREATE TABLE `mounts` (
347
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
348
  `uuid` char(36) NOT NULL,
349
  `name` varchar(191) NOT NULL,
350
  `description` text DEFAULT NULL,
351
  `source` varchar(191) NOT NULL,
352
  `target` varchar(191) NOT NULL,
353
  `read_only` tinyint(3) unsigned NOT NULL,
354
  `user_mountable` tinyint(3) unsigned NOT NULL,
355
  PRIMARY KEY (`id`),
356
  UNIQUE KEY `mounts_id_unique` (`id`),
357
  UNIQUE KEY `mounts_uuid_unique` (`uuid`),
358
  UNIQUE KEY `mounts_name_unique` (`name`)
359
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
360
/*!40101 SET character_set_client = @saved_cs_client */;
361
DROP TABLE IF EXISTS `nests`;
362
/*!40101 SET @saved_cs_client     = @@character_set_client */;
363
/*!40101 SET character_set_client = utf8 */;
364
CREATE TABLE `nests` (
365
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
366
  `uuid` char(36) NOT NULL,
367
  `author` char(191) NOT NULL,
368
  `name` varchar(191) NOT NULL,
369
  `description` text DEFAULT NULL,
370
  `created_at` timestamp NULL DEFAULT NULL,
371
  `updated_at` timestamp NULL DEFAULT NULL,
372
  PRIMARY KEY (`id`),
373
  UNIQUE KEY `services_uuid_unique` (`uuid`)
374
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
375
/*!40101 SET character_set_client = @saved_cs_client */;
376
DROP TABLE IF EXISTS `nodes`;
377
/*!40101 SET @saved_cs_client     = @@character_set_client */;
378
/*!40101 SET character_set_client = utf8 */;
379
CREATE TABLE `nodes` (
380
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
381
  `uuid` char(36) NOT NULL,
382
  `public` smallint(5) unsigned NOT NULL,
383
  `name` varchar(191) NOT NULL,
384
  `description` text DEFAULT NULL,
385
  `location_id` int(10) unsigned NOT NULL,
386
  `fqdn` varchar(191) NOT NULL,
387
  `scheme` varchar(191) NOT NULL DEFAULT 'https',
388
  `behind_proxy` tinyint(1) NOT NULL DEFAULT 0,
389
  `maintenance_mode` tinyint(1) NOT NULL DEFAULT 0,
390
  `memory` int(10) unsigned NOT NULL,
391
  `memory_overallocate` int(11) NOT NULL DEFAULT 0,
392
  `disk` int(10) unsigned NOT NULL,
393
  `disk_overallocate` int(11) NOT NULL DEFAULT 0,
394
  `upload_size` int(10) unsigned NOT NULL DEFAULT 100,
395
  `daemon_token_id` char(16) NOT NULL,
396
  `daemon_token` text NOT NULL,
397
  `daemonListen` smallint(5) unsigned NOT NULL DEFAULT 8080,
398
  `daemonSFTP` smallint(5) unsigned NOT NULL DEFAULT 2022,
399
  `daemonBase` varchar(191) NOT NULL DEFAULT '/home/daemon-files',
400
  `created_at` timestamp NULL DEFAULT NULL,
401
  `updated_at` timestamp NULL DEFAULT NULL,
402
  PRIMARY KEY (`id`),
403
  UNIQUE KEY `nodes_uuid_unique` (`uuid`),
404
  UNIQUE KEY `nodes_daemon_token_id_unique` (`daemon_token_id`),
405
  KEY `nodes_location_id_foreign` (`location_id`),
406
  CONSTRAINT `nodes_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`)
407
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
408
/*!40101 SET character_set_client = @saved_cs_client */;
409
DROP TABLE IF EXISTS `notifications`;
410
/*!40101 SET @saved_cs_client     = @@character_set_client */;
411
/*!40101 SET character_set_client = utf8 */;
412
CREATE TABLE `notifications` (
413
  `id` varchar(191) NOT NULL,
414
  `type` varchar(191) NOT NULL,
415
  `notifiable_type` varchar(191) NOT NULL,
416
  `notifiable_id` bigint(20) unsigned NOT NULL,
417
  `data` text NOT NULL,
418
  `read_at` timestamp NULL DEFAULT NULL,
419
  `created_at` timestamp NULL DEFAULT NULL,
420
  `updated_at` timestamp NULL DEFAULT NULL,
421
  PRIMARY KEY (`id`),
422
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
423
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
424
/*!40101 SET character_set_client = @saved_cs_client */;
425
DROP TABLE IF EXISTS `password_resets`;
426
/*!40101 SET @saved_cs_client     = @@character_set_client */;
427
/*!40101 SET character_set_client = utf8 */;
428
CREATE TABLE `password_resets` (
429
  `email` varchar(191) NOT NULL,
430
  `token` varchar(191) NOT NULL,
431
  `created_at` timestamp NOT NULL,
432
  KEY `password_resets_email_index` (`email`),
433
  KEY `password_resets_token_index` (`token`)
434
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
435
/*!40101 SET character_set_client = @saved_cs_client */;
436
DROP TABLE IF EXISTS `recovery_tokens`;
437
/*!40101 SET @saved_cs_client     = @@character_set_client */;
438
/*!40101 SET character_set_client = utf8 */;
439
CREATE TABLE `recovery_tokens` (
440
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
441
  `user_id` int(10) unsigned NOT NULL,
442
  `token` varchar(191) NOT NULL,
443
  `created_at` timestamp NULL DEFAULT NULL,
444
  PRIMARY KEY (`id`),
445
  KEY `recovery_tokens_user_id_foreign` (`user_id`),
446
  CONSTRAINT `recovery_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
447
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
448
/*!40101 SET character_set_client = @saved_cs_client */;
449
DROP TABLE IF EXISTS `schedules`;
450
/*!40101 SET @saved_cs_client     = @@character_set_client */;
451
/*!40101 SET character_set_client = utf8 */;
452
CREATE TABLE `schedules` (
453
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
454
  `server_id` int(10) unsigned NOT NULL,
455
  `name` varchar(191) NOT NULL,
456
  `cron_day_of_week` varchar(191) NOT NULL,
457
  `cron_month` varchar(191) NOT NULL,
458
  `cron_day_of_month` varchar(191) NOT NULL,
459
  `cron_hour` varchar(191) NOT NULL,
460
  `cron_minute` varchar(191) NOT NULL,
461
  `is_active` tinyint(1) NOT NULL,
462
  `is_processing` tinyint(1) NOT NULL,
463
  `only_when_online` tinyint(3) unsigned NOT NULL DEFAULT 0,
464
  `last_run_at` timestamp NULL DEFAULT NULL,
465
  `next_run_at` timestamp NULL DEFAULT NULL,
466
  `created_at` timestamp NULL DEFAULT NULL,
467
  `updated_at` timestamp NULL DEFAULT NULL,
468
  PRIMARY KEY (`id`),
469
  KEY `schedules_server_id_foreign` (`server_id`),
470
  CONSTRAINT `schedules_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE
471
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
472
/*!40101 SET character_set_client = @saved_cs_client */;
473
DROP TABLE IF EXISTS `server_transfers`;
474
/*!40101 SET @saved_cs_client     = @@character_set_client */;
475
/*!40101 SET character_set_client = utf8 */;
476
CREATE TABLE `server_transfers` (
477
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
478
  `server_id` int(10) unsigned NOT NULL,
479
  `successful` tinyint(1) DEFAULT NULL,
480
  `old_node` int(10) unsigned NOT NULL,
481
  `new_node` int(10) unsigned NOT NULL,
482
  `old_allocation` int(10) unsigned NOT NULL,
483
  `new_allocation` int(10) unsigned NOT NULL,
484
  `old_additional_allocations` longtext DEFAULT NULL COMMENT '(DC2Type:json)',
485
  `new_additional_allocations` longtext DEFAULT NULL COMMENT '(DC2Type:json)',
486
  `archived` tinyint(1) NOT NULL DEFAULT 0,
487
  `created_at` timestamp NULL DEFAULT NULL,
488
  `updated_at` timestamp NULL DEFAULT NULL,
489
  PRIMARY KEY (`id`),
490
  KEY `server_transfers_server_id_foreign` (`server_id`),
491
  CONSTRAINT `server_transfers_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE
492
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
493
/*!40101 SET character_set_client = @saved_cs_client */;
494
DROP TABLE IF EXISTS `server_variables`;
495
/*!40101 SET @saved_cs_client     = @@character_set_client */;
496
/*!40101 SET character_set_client = utf8 */;
497
CREATE TABLE `server_variables` (
498
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
499
  `server_id` int(10) unsigned DEFAULT NULL,
500
  `variable_id` int(10) unsigned NOT NULL,
501
  `variable_value` text NOT NULL,
502
  `created_at` timestamp NULL DEFAULT NULL,
503
  `updated_at` timestamp NULL DEFAULT NULL,
504
  PRIMARY KEY (`id`),
505
  KEY `server_variables_server_id_foreign` (`server_id`),
506
  KEY `server_variables_variable_id_foreign` (`variable_id`),
507
  CONSTRAINT `server_variables_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE,
508
  CONSTRAINT `server_variables_variable_id_foreign` FOREIGN KEY (`variable_id`) REFERENCES `egg_variables` (`id`) ON DELETE CASCADE
509
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
510
/*!40101 SET character_set_client = @saved_cs_client */;
511
DROP TABLE IF EXISTS `servers`;
512
/*!40101 SET @saved_cs_client     = @@character_set_client */;
513
/*!40101 SET character_set_client = utf8 */;
514
CREATE TABLE `servers` (
515
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
516
  `external_id` varchar(191) DEFAULT NULL,
517
  `uuid` char(36) NOT NULL,
518
  `uuidShort` char(8) NOT NULL,
519
  `node_id` int(10) unsigned NOT NULL,
520
  `name` varchar(191) NOT NULL,
521
  `description` text NOT NULL,
522
  `status` varchar(191) DEFAULT NULL,
523
  `skip_scripts` tinyint(1) NOT NULL DEFAULT 0,
524
  `owner_id` int(10) unsigned NOT NULL,
525
  `memory` int(10) unsigned NOT NULL,
526
  `swap` int(11) NOT NULL,
527
  `disk` int(10) unsigned NOT NULL,
528
  `io` int(10) unsigned NOT NULL,
529
  `cpu` int(10) unsigned NOT NULL,
530
  `threads` varchar(191) DEFAULT NULL,
531
  `oom_disabled` tinyint(3) unsigned NOT NULL DEFAULT 0,
532
  `allocation_id` int(10) unsigned NOT NULL,
533
  `nest_id` int(10) unsigned NOT NULL,
534
  `egg_id` int(10) unsigned NOT NULL,
535
  `startup` text NOT NULL,
536
  `image` varchar(191) NOT NULL,
537
  `allocation_limit` int(10) unsigned DEFAULT NULL,
538
  `database_limit` int(10) unsigned DEFAULT 0,
539
  `backup_limit` int(10) unsigned NOT NULL DEFAULT 0,
540
  `created_at` timestamp NULL DEFAULT NULL,
541
  `updated_at` timestamp NULL DEFAULT NULL,
542
  `installed_at` timestamp NULL DEFAULT NULL,
543
  PRIMARY KEY (`id`),
544
  UNIQUE KEY `servers_uuid_unique` (`uuid`),
545
  UNIQUE KEY `servers_uuidshort_unique` (`uuidShort`),
546
  UNIQUE KEY `servers_allocation_id_unique` (`allocation_id`),
547
  UNIQUE KEY `servers_external_id_unique` (`external_id`),
548
  KEY `servers_node_id_foreign` (`node_id`),
549
  KEY `servers_owner_id_foreign` (`owner_id`),
550
  KEY `servers_nest_id_foreign` (`nest_id`),
551
  KEY `servers_egg_id_foreign` (`egg_id`),
552
  CONSTRAINT `servers_allocation_id_foreign` FOREIGN KEY (`allocation_id`) REFERENCES `allocations` (`id`),
553
  CONSTRAINT `servers_egg_id_foreign` FOREIGN KEY (`egg_id`) REFERENCES `eggs` (`id`),
554
  CONSTRAINT `servers_nest_id_foreign` FOREIGN KEY (`nest_id`) REFERENCES `nests` (`id`),
555
  CONSTRAINT `servers_node_id_foreign` FOREIGN KEY (`node_id`) REFERENCES `nodes` (`id`),
556
  CONSTRAINT `servers_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`)
557
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
558
/*!40101 SET character_set_client = @saved_cs_client */;
559
DROP TABLE IF EXISTS `sessions`;
560
/*!40101 SET @saved_cs_client     = @@character_set_client */;
561
/*!40101 SET character_set_client = utf8 */;
562
CREATE TABLE `sessions` (
563
  `id` varchar(191) NOT NULL,
564
  `user_id` int(11) DEFAULT NULL,
565
  `ip_address` varchar(45) DEFAULT NULL,
566
  `user_agent` text DEFAULT NULL,
567
  `payload` text NOT NULL,
568
  `last_activity` int(11) NOT NULL,
569
  UNIQUE KEY `sessions_id_unique` (`id`)
570
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
571
/*!40101 SET character_set_client = @saved_cs_client */;
572
DROP TABLE IF EXISTS `settings`;
573
/*!40101 SET @saved_cs_client     = @@character_set_client */;
574
/*!40101 SET character_set_client = utf8 */;
575
CREATE TABLE `settings` (
576
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
577
  `key` varchar(191) NOT NULL,
578
  `value` text NOT NULL,
579
  PRIMARY KEY (`id`),
580
  UNIQUE KEY `settings_key_unique` (`key`)
581
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
582
/*!40101 SET character_set_client = @saved_cs_client */;
583
DROP TABLE IF EXISTS `subusers`;
584
/*!40101 SET @saved_cs_client     = @@character_set_client */;
585
/*!40101 SET character_set_client = utf8 */;
586
CREATE TABLE `subusers` (
587
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
588
  `user_id` int(10) unsigned NOT NULL,
589
  `server_id` int(10) unsigned NOT NULL,
590
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
591
  `created_at` timestamp NULL DEFAULT NULL,
592
  `updated_at` timestamp NULL DEFAULT NULL,
593
  PRIMARY KEY (`id`),
594
  KEY `subusers_user_id_foreign` (`user_id`),
595
  KEY `subusers_server_id_foreign` (`server_id`),
596
  CONSTRAINT `subusers_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE,
597
  CONSTRAINT `subusers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
598
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
599
/*!40101 SET character_set_client = @saved_cs_client */;
600
DROP TABLE IF EXISTS `tasks`;
601
/*!40101 SET @saved_cs_client     = @@character_set_client */;
602
/*!40101 SET character_set_client = utf8 */;
603
CREATE TABLE `tasks` (
604
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
605
  `schedule_id` int(10) unsigned NOT NULL,
606
  `sequence_id` int(10) unsigned NOT NULL,
607
  `action` varchar(191) NOT NULL,
608
  `payload` text NOT NULL,
609
  `time_offset` int(10) unsigned NOT NULL,
610
  `is_queued` tinyint(1) NOT NULL,
611
  `continue_on_failure` tinyint(3) unsigned NOT NULL DEFAULT 0,
612
  `created_at` timestamp NULL DEFAULT NULL,
613
  `updated_at` timestamp NULL DEFAULT NULL,
614
  PRIMARY KEY (`id`),
615
  KEY `tasks_schedule_id_sequence_id_index` (`schedule_id`,`sequence_id`),
616
  CONSTRAINT `tasks_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`id`) ON DELETE CASCADE
617
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
618
/*!40101 SET character_set_client = @saved_cs_client */;
619
DROP TABLE IF EXISTS `tasks_log`;
620
/*!40101 SET @saved_cs_client     = @@character_set_client */;
621
/*!40101 SET character_set_client = utf8 */;
622
CREATE TABLE `tasks_log` (
623
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
624
  `task_id` int(10) unsigned NOT NULL,
625
  `run_time` timestamp NOT NULL,
626
  `run_status` int(10) unsigned NOT NULL,
627
  `response` text NOT NULL,
628
  `created_at` timestamp NULL DEFAULT NULL,
629
  `updated_at` timestamp NULL DEFAULT NULL,
630
  PRIMARY KEY (`id`)
631
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
632
/*!40101 SET character_set_client = @saved_cs_client */;
633
DROP TABLE IF EXISTS `user_ssh_keys`;
634
/*!40101 SET @saved_cs_client     = @@character_set_client */;
635
/*!40101 SET character_set_client = utf8 */;
636
CREATE TABLE `user_ssh_keys` (
637
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
638
  `user_id` int(10) unsigned NOT NULL,
639
  `name` varchar(191) NOT NULL,
640
  `fingerprint` varchar(191) NOT NULL,
641
  `public_key` text NOT NULL,
642
  `created_at` timestamp NULL DEFAULT NULL,
643
  `updated_at` timestamp NULL DEFAULT NULL,
644
  `deleted_at` timestamp NULL DEFAULT NULL,
645
  PRIMARY KEY (`id`),
646
  KEY `user_ssh_keys_user_id_foreign` (`user_id`),
647
  CONSTRAINT `user_ssh_keys_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
648
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
649
/*!40101 SET character_set_client = @saved_cs_client */;
650
DROP TABLE IF EXISTS `users`;
651
/*!40101 SET @saved_cs_client     = @@character_set_client */;
652
/*!40101 SET character_set_client = utf8 */;
653
CREATE TABLE `users` (
654
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
655
  `external_id` varchar(191) DEFAULT NULL,
656
  `uuid` char(36) NOT NULL,
657
  `username` varchar(191) NOT NULL,
658
  `email` varchar(191) NOT NULL,
659
  `name_first` varchar(191) DEFAULT NULL,
660
  `name_last` varchar(191) DEFAULT NULL,
661
  `password` text NOT NULL,
662
  `remember_token` varchar(191) DEFAULT NULL,
663
  `language` char(5) NOT NULL DEFAULT 'en',
664
  `root_admin` tinyint(3) unsigned NOT NULL DEFAULT 0,
665
  `use_totp` tinyint(3) unsigned NOT NULL,
666
  `totp_secret` text DEFAULT NULL,
667
  `totp_authenticated_at` timestamp NULL DEFAULT NULL,
668
  `gravatar` tinyint(1) NOT NULL DEFAULT 1,
669
  `created_at` timestamp NULL DEFAULT NULL,
670
  `updated_at` timestamp NULL DEFAULT NULL,
671
  PRIMARY KEY (`id`),
672
  UNIQUE KEY `users_uuid_unique` (`uuid`),
673
  UNIQUE KEY `users_email_unique` (`email`),
674
  UNIQUE KEY `users_username_unique` (`username`),
675
  KEY `users_external_id_index` (`external_id`)
676
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
677
/*!40101 SET character_set_client = @saved_cs_client */;
678
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
679

680
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
681
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
682
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
683
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
684

685
INSERT INTO `migrations` VALUES (1,'2016_01_23_195641_add_allocations_table',1);
686
INSERT INTO `migrations` VALUES (2,'2016_01_23_195851_add_api_keys',1);
687
INSERT INTO `migrations` VALUES (3,'2016_01_23_200044_add_api_permissions',1);
688
INSERT INTO `migrations` VALUES (4,'2016_01_23_200159_add_downloads',1);
689
INSERT INTO `migrations` VALUES (5,'2016_01_23_200421_create_failed_jobs_table',1);
690
INSERT INTO `migrations` VALUES (6,'2016_01_23_200440_create_jobs_table',1);
691
INSERT INTO `migrations` VALUES (7,'2016_01_23_200528_add_locations',1);
692
INSERT INTO `migrations` VALUES (8,'2016_01_23_200648_add_nodes',1);
693
INSERT INTO `migrations` VALUES (9,'2016_01_23_201433_add_password_resets',1);
694
INSERT INTO `migrations` VALUES (10,'2016_01_23_201531_add_permissions',1);
695
INSERT INTO `migrations` VALUES (11,'2016_01_23_201649_add_server_variables',1);
696
INSERT INTO `migrations` VALUES (12,'2016_01_23_201748_add_servers',1);
697
INSERT INTO `migrations` VALUES (13,'2016_01_23_202544_add_service_options',1);
698
INSERT INTO `migrations` VALUES (14,'2016_01_23_202731_add_service_varibles',1);
699
INSERT INTO `migrations` VALUES (15,'2016_01_23_202943_add_services',1);
700
INSERT INTO `migrations` VALUES (16,'2016_01_23_203119_create_settings_table',1);
701
INSERT INTO `migrations` VALUES (17,'2016_01_23_203150_add_subusers',1);
702
INSERT INTO `migrations` VALUES (18,'2016_01_23_203159_add_users',1);
703
INSERT INTO `migrations` VALUES (19,'2016_01_23_203947_create_sessions_table',1);
704
INSERT INTO `migrations` VALUES (20,'2016_01_25_234418_rename_permissions_column',1);
705
INSERT INTO `migrations` VALUES (21,'2016_02_07_172148_add_databases_tables',1);
706
INSERT INTO `migrations` VALUES (22,'2016_02_07_181319_add_database_servers_table',1);
707
INSERT INTO `migrations` VALUES (23,'2016_02_13_154306_add_service_option_default_startup',1);
708
INSERT INTO `migrations` VALUES (24,'2016_02_20_155318_add_unique_service_field',1);
709
INSERT INTO `migrations` VALUES (25,'2016_02_27_163411_add_tasks_table',1);
710
INSERT INTO `migrations` VALUES (26,'2016_02_27_163447_add_tasks_log_table',1);
711
INSERT INTO `migrations` VALUES (27,'2016_03_18_155649_add_nullable_field_lastrun',1);
712
INSERT INTO `migrations` VALUES (28,'2016_08_30_212718_add_ip_alias',1);
713
INSERT INTO `migrations` VALUES (29,'2016_08_30_213301_modify_ip_storage_method',1);
714
INSERT INTO `migrations` VALUES (30,'2016_09_01_193520_add_suspension_for_servers',1);
715
INSERT INTO `migrations` VALUES (31,'2016_09_01_211924_remove_active_column',1);
716
INSERT INTO `migrations` VALUES (32,'2016_09_02_190647_add_sftp_password_storage',1);
717
INSERT INTO `migrations` VALUES (33,'2016_09_04_171338_update_jobs_tables',1);
718
INSERT INTO `migrations` VALUES (34,'2016_09_04_172028_update_failed_jobs_table',1);
719
INSERT INTO `migrations` VALUES (35,'2016_09_04_182835_create_notifications_table',1);
720
INSERT INTO `migrations` VALUES (36,'2016_09_07_163017_add_unique_identifier',1);
721
INSERT INTO `migrations` VALUES (37,'2016_09_14_145945_allow_longer_regex_field',1);
722
INSERT INTO `migrations` VALUES (38,'2016_09_17_194246_add_docker_image_column',1);
723
INSERT INTO `migrations` VALUES (39,'2016_09_21_165554_update_servers_column_name',1);
724
INSERT INTO `migrations` VALUES (40,'2016_09_29_213518_rename_double_insurgency',1);
725
INSERT INTO `migrations` VALUES (41,'2016_10_07_152117_build_api_log_table',1);
726
INSERT INTO `migrations` VALUES (42,'2016_10_14_164802_update_api_keys',1);
727
INSERT INTO `migrations` VALUES (43,'2016_10_23_181719_update_misnamed_bungee',1);
728
INSERT INTO `migrations` VALUES (44,'2016_10_23_193810_add_foreign_keys_servers',1);
729
INSERT INTO `migrations` VALUES (45,'2016_10_23_201624_add_foreign_allocations',1);
730
INSERT INTO `migrations` VALUES (46,'2016_10_23_202222_add_foreign_api_keys',1);
731
INSERT INTO `migrations` VALUES (47,'2016_10_23_202703_add_foreign_api_permissions',1);
732
INSERT INTO `migrations` VALUES (48,'2016_10_23_202953_add_foreign_database_servers',1);
733
INSERT INTO `migrations` VALUES (49,'2016_10_23_203105_add_foreign_databases',1);
734
INSERT INTO `migrations` VALUES (50,'2016_10_23_203335_add_foreign_nodes',1);
735
INSERT INTO `migrations` VALUES (51,'2016_10_23_203522_add_foreign_permissions',1);
736
INSERT INTO `migrations` VALUES (52,'2016_10_23_203857_add_foreign_server_variables',1);
737
INSERT INTO `migrations` VALUES (53,'2016_10_23_204157_add_foreign_service_options',1);
738
INSERT INTO `migrations` VALUES (54,'2016_10_23_204321_add_foreign_service_variables',1);
739
INSERT INTO `migrations` VALUES (55,'2016_10_23_204454_add_foreign_subusers',1);
740
INSERT INTO `migrations` VALUES (56,'2016_10_23_204610_add_foreign_tasks',1);
741
INSERT INTO `migrations` VALUES (57,'2016_11_04_000949_add_ark_service_option_fixed',1);
742
INSERT INTO `migrations` VALUES (58,'2016_11_11_220649_add_pack_support',1);
743
INSERT INTO `migrations` VALUES (59,'2016_11_11_231731_set_service_name_unique',1);
744
INSERT INTO `migrations` VALUES (60,'2016_11_27_142519_add_pack_column',1);
745
INSERT INTO `migrations` VALUES (61,'2016_12_01_173018_add_configurable_upload_limit',1);
746
INSERT INTO `migrations` VALUES (62,'2016_12_02_185206_correct_service_variables',1);
747
INSERT INTO `migrations` VALUES (63,'2017_01_03_150436_fix_misnamed_option_tag',1);
748
INSERT INTO `migrations` VALUES (64,'2017_01_07_154228_create_node_configuration_tokens_table',1);
749
INSERT INTO `migrations` VALUES (65,'2017_01_12_135449_add_more_user_data',1);
750
INSERT INTO `migrations` VALUES (66,'2017_02_02_175548_UpdateColumnNames',1);
751
INSERT INTO `migrations` VALUES (67,'2017_02_03_140948_UpdateNodesTable',1);
752
INSERT INTO `migrations` VALUES (68,'2017_02_03_155554_RenameColumns',1);
753
INSERT INTO `migrations` VALUES (69,'2017_02_05_164123_AdjustColumnNames',1);
754
INSERT INTO `migrations` VALUES (70,'2017_02_05_164516_AdjustColumnNamesForServicePacks',1);
755
INSERT INTO `migrations` VALUES (71,'2017_02_09_174834_SetupPermissionsPivotTable',1);
756
INSERT INTO `migrations` VALUES (72,'2017_02_10_171858_UpdateAPIKeyColumnNames',1);
757
INSERT INTO `migrations` VALUES (73,'2017_03_03_224254_UpdateNodeConfigTokensColumns',1);
758
INSERT INTO `migrations` VALUES (74,'2017_03_05_212803_DeleteServiceExecutableOption',1);
759
INSERT INTO `migrations` VALUES (75,'2017_03_10_162934_AddNewServiceOptionsColumns',1);
760
INSERT INTO `migrations` VALUES (76,'2017_03_10_173607_MigrateToNewServiceSystem',1);
761
INSERT INTO `migrations` VALUES (77,'2017_03_11_215455_ChangeServiceVariablesValidationRules',1);
762
INSERT INTO `migrations` VALUES (78,'2017_03_12_150648_MoveFunctionsFromFileToDatabase',1);
763
INSERT INTO `migrations` VALUES (79,'2017_03_14_175631_RenameServicePacksToSingluarPacks',1);
764
INSERT INTO `migrations` VALUES (80,'2017_03_14_200326_AddLockedStatusToTable',1);
765
INSERT INTO `migrations` VALUES (81,'2017_03_16_181109_ReOrganizeDatabaseServersToDatabaseHost',1);
766
INSERT INTO `migrations` VALUES (82,'2017_03_16_181515_CleanupDatabasesDatabase',1);
767
INSERT INTO `migrations` VALUES (83,'2017_03_18_204953_AddForeignKeyToPacks',1);
768
INSERT INTO `migrations` VALUES (84,'2017_03_31_221948_AddServerDescriptionColumn',1);
769
INSERT INTO `migrations` VALUES (85,'2017_04_02_163232_DropDeletedAtColumnFromServers',1);
770
INSERT INTO `migrations` VALUES (86,'2017_04_15_125021_UpgradeTaskSystem',1);
771
INSERT INTO `migrations` VALUES (87,'2017_04_20_171943_AddScriptsToServiceOptions',1);
772
INSERT INTO `migrations` VALUES (88,'2017_04_21_151432_AddServiceScriptTrackingToServers',1);
773
INSERT INTO `migrations` VALUES (89,'2017_04_27_145300_AddCopyScriptFromColumn',1);
774
INSERT INTO `migrations` VALUES (90,'2017_04_27_223629_AddAbilityToDefineConnectionOverSSLWithDaemonBehindProxy',1);
775
INSERT INTO `migrations` VALUES (91,'2017_05_01_141528_DeleteDownloadTable',1);
776
INSERT INTO `migrations` VALUES (92,'2017_05_01_141559_DeleteNodeConfigurationTable',1);
777
INSERT INTO `migrations` VALUES (93,'2017_06_10_152951_add_external_id_to_users',1);
778
INSERT INTO `migrations` VALUES (94,'2017_06_25_133923_ChangeForeignKeyToBeOnCascadeDelete',1);
779
INSERT INTO `migrations` VALUES (95,'2017_07_08_152806_ChangeUserPermissionsToDeleteOnUserDeletion',1);
780
INSERT INTO `migrations` VALUES (96,'2017_07_08_154416_SetAllocationToReferenceNullOnServerDelete',1);
781
INSERT INTO `migrations` VALUES (97,'2017_07_08_154650_CascadeDeletionWhenAServerOrVariableIsDeleted',1);
782
INSERT INTO `migrations` VALUES (98,'2017_07_24_194433_DeleteTaskWhenParentServerIsDeleted',1);
783
INSERT INTO `migrations` VALUES (99,'2017_08_05_115800_CascadeNullValuesForDatabaseHostWhenNodeIsDeleted',1);
784
INSERT INTO `migrations` VALUES (100,'2017_08_05_144104_AllowNegativeValuesForOverallocation',1);
785
INSERT INTO `migrations` VALUES (101,'2017_08_05_174811_SetAllocationUnqiueUsingMultipleFields',1);
786
INSERT INTO `migrations` VALUES (102,'2017_08_15_214555_CascadeDeletionWhenAParentServiceIsDeleted',1);
787
INSERT INTO `migrations` VALUES (103,'2017_08_18_215428_RemovePackWhenParentServiceOptionIsDeleted',1);
788
INSERT INTO `migrations` VALUES (104,'2017_09_10_225749_RenameTasksTableForStructureRefactor',1);
789
INSERT INTO `migrations` VALUES (105,'2017_09_10_225941_CreateSchedulesTable',1);
790
INSERT INTO `migrations` VALUES (106,'2017_09_10_230309_CreateNewTasksTableForSchedules',1);
791
INSERT INTO `migrations` VALUES (107,'2017_09_11_002938_TransferOldTasksToNewScheduler',1);
792
INSERT INTO `migrations` VALUES (108,'2017_09_13_211810_UpdateOldPermissionsToPointToNewScheduleSystem',1);
793
INSERT INTO `migrations` VALUES (109,'2017_09_23_170933_CreateDaemonKeysTable',1);
794
INSERT INTO `migrations` VALUES (110,'2017_09_23_173628_RemoveDaemonSecretFromServersTable',1);
795
INSERT INTO `migrations` VALUES (111,'2017_09_23_185022_RemoveDaemonSecretFromSubusersTable',1);
796
INSERT INTO `migrations` VALUES (112,'2017_10_02_202000_ChangeServicesToUseAMoreUniqueIdentifier',1);
797
INSERT INTO `migrations` VALUES (113,'2017_10_02_202007_ChangeToABetterUniqueServiceConfiguration',1);
798
INSERT INTO `migrations` VALUES (114,'2017_10_03_233202_CascadeDeletionWhenServiceOptionIsDeleted',1);
799
INSERT INTO `migrations` VALUES (115,'2017_10_06_214026_ServicesToNestsConversion',1);
800
INSERT INTO `migrations` VALUES (116,'2017_10_06_214053_ServiceOptionsToEggsConversion',1);
801
INSERT INTO `migrations` VALUES (117,'2017_10_06_215741_ServiceVariablesToEggVariablesConversion',1);
802
INSERT INTO `migrations` VALUES (118,'2017_10_24_222238_RemoveLegacySFTPInformation',1);
803
INSERT INTO `migrations` VALUES (119,'2017_11_11_161922_Add2FaLastAuthorizationTimeColumn',1);
804
INSERT INTO `migrations` VALUES (120,'2017_11_19_122708_MigratePubPrivFormatToSingleKey',1);
805
INSERT INTO `migrations` VALUES (121,'2017_12_04_184012_DropAllocationsWhenNodeIsDeleted',1);
806
INSERT INTO `migrations` VALUES (122,'2017_12_12_220426_MigrateSettingsTableToNewFormat',1);
807
INSERT INTO `migrations` VALUES (123,'2018_01_01_122821_AllowNegativeValuesForServerSwap',1);
808
INSERT INTO `migrations` VALUES (124,'2018_01_11_213943_AddApiKeyPermissionColumns',1);
809
INSERT INTO `migrations` VALUES (125,'2018_01_13_142012_SetupTableForKeyEncryption',1);
810
INSERT INTO `migrations` VALUES (126,'2018_01_13_145209_AddLastUsedAtColumn',1);
811
INSERT INTO `migrations` VALUES (127,'2018_02_04_145617_AllowTextInUserExternalId',1);
812
INSERT INTO `migrations` VALUES (128,'2018_02_10_151150_remove_unique_index_on_external_id_column',1);
813
INSERT INTO `migrations` VALUES (129,'2018_02_17_134254_ensure_unique_allocation_id_on_servers_table',1);
814
INSERT INTO `migrations` VALUES (130,'2018_02_24_112356_add_external_id_column_to_servers_table',1);
815
INSERT INTO `migrations` VALUES (131,'2018_02_25_160152_remove_default_null_value_on_table',1);
816
INSERT INTO `migrations` VALUES (132,'2018_02_25_160604_define_unique_index_on_users_external_id',1);
817
INSERT INTO `migrations` VALUES (133,'2018_03_01_192831_add_database_and_port_limit_columns_to_servers_table',1);
818
INSERT INTO `migrations` VALUES (134,'2018_03_15_124536_add_description_to_nodes',1);
819
INSERT INTO `migrations` VALUES (135,'2018_05_04_123826_add_maintenance_to_nodes',1);
820
INSERT INTO `migrations` VALUES (136,'2018_09_03_143756_allow_egg_variables_to_have_longer_values',1);
821
INSERT INTO `migrations` VALUES (137,'2018_09_03_144005_allow_server_variables_to_have_longer_values',1);
822
INSERT INTO `migrations` VALUES (138,'2019_03_02_142328_set_allocation_limit_default_null',1);
823
INSERT INTO `migrations` VALUES (139,'2019_03_02_151321_fix_unique_index_to_account_for_host',1);
824
INSERT INTO `migrations` VALUES (140,'2020_03_22_163911_merge_permissions_table_into_subusers',1);
825
INSERT INTO `migrations` VALUES (141,'2020_03_22_164814_drop_permissions_table',1);
826
INSERT INTO `migrations` VALUES (142,'2020_04_03_203624_add_threads_column_to_servers_table',1);
827
INSERT INTO `migrations` VALUES (143,'2020_04_03_230614_create_backups_table',1);
828
INSERT INTO `migrations` VALUES (144,'2020_04_04_131016_add_table_server_transfers',1);
829
INSERT INTO `migrations` VALUES (145,'2020_04_10_141024_store_node_tokens_as_encrypted_value',1);
830
INSERT INTO `migrations` VALUES (146,'2020_04_17_203438_allow_nullable_descriptions',1);
831
INSERT INTO `migrations` VALUES (147,'2020_04_22_055500_add_max_connections_column',1);
832
INSERT INTO `migrations` VALUES (148,'2020_04_26_111208_add_backup_limit_to_servers',1);
833
INSERT INTO `migrations` VALUES (149,'2020_05_20_234655_add_mounts_table',1);
834
INSERT INTO `migrations` VALUES (150,'2020_05_21_192756_add_mount_server_table',1);
835
INSERT INTO `migrations` VALUES (151,'2020_07_02_213612_create_user_recovery_tokens_table',1);
836
INSERT INTO `migrations` VALUES (152,'2020_07_09_201845_add_notes_column_for_allocations',1);
837
INSERT INTO `migrations` VALUES (153,'2020_08_20_205533_add_backup_state_column_to_backups',1);
838
INSERT INTO `migrations` VALUES (154,'2020_08_22_132500_update_bytes_to_unsigned_bigint',1);
839
INSERT INTO `migrations` VALUES (155,'2020_08_23_175331_modify_checksums_column_for_backups',1);
840
INSERT INTO `migrations` VALUES (156,'2020_09_13_110007_drop_packs_from_servers',1);
841
INSERT INTO `migrations` VALUES (157,'2020_09_13_110021_drop_packs_from_api_key_permissions',1);
842
INSERT INTO `migrations` VALUES (158,'2020_09_13_110047_drop_packs_table',1);
843
INSERT INTO `migrations` VALUES (159,'2020_09_13_113503_drop_daemon_key_table',1);
844
INSERT INTO `migrations` VALUES (160,'2020_10_10_165437_change_unique_database_name_to_account_for_server',1);
845
INSERT INTO `migrations` VALUES (161,'2020_10_26_194904_remove_nullable_from_schedule_name_field',1);
846
INSERT INTO `migrations` VALUES (162,'2020_11_02_201014_add_features_column_to_eggs',1);
847
INSERT INTO `migrations` VALUES (163,'2020_12_12_102435_support_multiple_docker_images_and_updates',1);
848
INSERT INTO `migrations` VALUES (164,'2020_12_14_013707_make_successful_nullable_in_server_transfers',1);
849
INSERT INTO `migrations` VALUES (165,'2020_12_17_014330_add_archived_field_to_server_transfers_table',1);
850
INSERT INTO `migrations` VALUES (166,'2020_12_24_092449_make_allocation_fields_json',1);
851
INSERT INTO `migrations` VALUES (167,'2020_12_26_184914_add_upload_id_column_to_backups_table',1);
852
INSERT INTO `migrations` VALUES (168,'2021_01_10_153937_add_file_denylist_to_egg_configs',1);
853
INSERT INTO `migrations` VALUES (169,'2021_01_13_013420_add_cron_month',1);
854
INSERT INTO `migrations` VALUES (170,'2021_01_17_102401_create_audit_logs_table',1);
855
INSERT INTO `migrations` VALUES (171,'2021_01_17_152623_add_generic_server_status_column',1);
856
INSERT INTO `migrations` VALUES (172,'2021_01_26_210502_update_file_denylist_to_json',1);
857
INSERT INTO `migrations` VALUES (173,'2021_02_23_205021_add_index_for_server_and_action',1);
858
INSERT INTO `migrations` VALUES (174,'2021_02_23_212657_make_sftp_port_unsigned_int',1);
859
INSERT INTO `migrations` VALUES (175,'2021_03_21_104718_force_cron_month_field_to_have_value_if_missing',1);
860
INSERT INTO `migrations` VALUES (176,'2021_05_01_092457_add_continue_on_failure_option_to_tasks',1);
861
INSERT INTO `migrations` VALUES (177,'2021_05_01_092523_add_only_run_when_server_online_option_to_schedules',1);
862
INSERT INTO `migrations` VALUES (178,'2021_05_03_201016_add_support_for_locking_a_backup',1);
863
INSERT INTO `migrations` VALUES (179,'2021_07_12_013420_remove_userinteraction',1);
864
INSERT INTO `migrations` VALUES (180,'2021_07_17_211512_create_user_ssh_keys_table',1);
865
INSERT INTO `migrations` VALUES (181,'2021_08_03_210600_change_successful_field_to_default_to_false_on_backups_table',1);
866
INSERT INTO `migrations` VALUES (182,'2021_08_21_175111_add_foreign_keys_to_mount_node_table',1);
867
INSERT INTO `migrations` VALUES (183,'2021_08_21_175118_add_foreign_keys_to_mount_server_table',1);
868
INSERT INTO `migrations` VALUES (184,'2021_08_21_180921_add_foreign_keys_to_egg_mount_table',1);
869
INSERT INTO `migrations` VALUES (185,'2022_01_25_030847_drop_google_analytics',1);
870
INSERT INTO `migrations` VALUES (186,'2022_05_07_165334_migrate_egg_images_array_to_new_format',1);
871
INSERT INTO `migrations` VALUES (187,'2022_05_28_135717_create_activity_logs_table',1);
872
INSERT INTO `migrations` VALUES (188,'2022_05_29_140349_create_activity_log_actors_table',1);
873
INSERT INTO `migrations` VALUES (189,'2022_06_18_112822_track_api_key_usage_for_activity_events',1);
874
INSERT INTO `migrations` VALUES (190,'2022_08_16_214400_add_force_outgoing_ip_column_to_eggs_table',1);
875
INSERT INTO `migrations` VALUES (191,'2022_08_16_230204_add_installed_at_column_to_servers_table',1);
876
INSERT INTO `migrations` VALUES (192,'2022_12_12_213937_update_mail_settings_to_new_format',1);
877
INSERT INTO `migrations` VALUES (193,'2023_01_24_210051_add_uuid_column_to_failed_jobs_table',1);
878
INSERT INTO `migrations` VALUES (194,'2023_02_23_191004_add_expires_at_column_to_api_keys_table',1);
879

880
Product

Resources

Company
