struxadotcloud/struxa

public

feat: migration, UI fixes900c35a5 months ago407 lines · 18.0 KB

1	CREATE TABLE `activity_logs` (
2	`id` varchar(36
3	`batch_uuid` varchar(36
4	`event_type` varchar(100
5	`user_id` varchar(36
6	`server_id` varchar(36
7	`node_id` varchar(36
8	`properties` text,
9	`ip` varchar(100
10	`hashed_ip` varchar(255
11	`timestamp` timestamp(3
12	CONSTRAINT `activity_logs_id` PRIMARY KEY
13	);
14	--> statement-breakpoint
15	CREATE TABLE `node_allocations` (
16	`id` varchar(36
17	`node_id` varchar(36
18	`ip` varchar(45
19	`ip_alias` varchar(255
20	`port` int NOT NULL
21	`server_id` varchar(36
22	`created_at` timestamp(3
23	CONSTRAINT `node_allocations_id` PRIMARY KEY
24	);
25	--> statement-breakpoint
26	CREATE TABLE `account` (
27	`id` varchar(36
28	`account_id` text NOT NULL
29	`provider_id` text NOT NULL
30	`user_id` varchar(36
31	`access_token` text,
32	`refresh_token` text,
33	`id_token` text,
34	`access_token_expires_at` timestamp(3
35	`refresh_token_expires_at` timestamp(3
36	`scope` text,
37	`password` text,
38	`created_at` timestamp(3
39	`updated_at` timestamp(3
40	CONSTRAINT `account_id` PRIMARY KEY
41	);
42	--> statement-breakpoint
43	CREATE TABLE `apikey` (
44	`id` varchar(36
45	`config_id` varchar(64
46	`name` varchar(255
47	`start` varchar(64
48	`prefix` varchar(64
49	`key` text NOT NULL
50	`reference_id` varchar(36
51	`refill_interval` int,
52	`refill_amount` int,
53	`last_refill_at` timestamp(3
54	`enabled` boolean DEFAULT
55	`rate_limit_enabled` boolean,
56	`rate_limit_time_window` int,
57	`rate_limit_max` int,
58	`request_count` int DEFAULT
59	`remaining` int,
60	`last_request` timestamp(3
61	`expires_at` timestamp(3
62	`created_at` timestamp(3
63	`updated_at` timestamp(3
64	`permissions` text,
65	`metadata` text,
66	CONSTRAINT `apikey_id` PRIMARY KEY
67	);
68	--> statement-breakpoint
69	CREATE TABLE `session` (
70	`id` varchar(36
71	`expires_at` timestamp(3
72	`token` varchar(255
73	`created_at` timestamp(3
74	`updated_at` timestamp(3
75	`ip_address` text,
76	`user_agent` text,
77	`user_id` varchar(36
78	`impersonated_by` varchar(36
79	CONSTRAINT `session_id` PRIMARY KEY
80	CONSTRAINT `session_token_unique` UNIQUE
81	);
82	--> statement-breakpoint
83	CREATE TABLE `twoFactor` (
84	`id` varchar(36
85	`secret` text NOT NULL
86	`backup_codes` text NOT NULL
87	`user_id` varchar(36
88	`verified` boolean DEFAULT
89	CONSTRAINT `twoFactor_id` PRIMARY KEY
90	);
91	--> statement-breakpoint
92	CREATE TABLE `user` (
93	`id` varchar(36
94	`name` varchar(255
95	`email` varchar(255
96	`email_verified` boolean NOT NULL
97	`image` text,
98	`created_at` timestamp(3
99	`updated_at` timestamp(3
100	`role` varchar(255
101	`banned` boolean,
102	`ban_reason` text,
103	`ban_expires` timestamp(3
104	`two_factor_enabled` boolean DEFAULT
105	CONSTRAINT `user_id` PRIMARY KEY
106	CONSTRAINT `user_email_unique` UNIQUE
107	);
108	--> statement-breakpoint
109	CREATE TABLE `verification` (
110	`id` varchar(36
111	`identifier` varchar(255
112	`value` text NOT NULL
113	`expires_at` timestamp(3
114	`created_at` timestamp(3
115	`updated_at` timestamp(3
116	CONSTRAINT `verification_id` PRIMARY KEY
117	);
118	--> statement-breakpoint
119	CREATE TABLE `backups` (
120	`id` varchar(36
121	`uuid` varchar(36
122	`server_id` varchar(36
123	`name` varchar(255
124	`ignored_files` text,
125	`disk` varchar(36
126	`checksum` varchar(255
127	`bytes` bigint NOT NULL
128	`completed_at` timestamp(3
129	`is_locked` boolean NOT NULL
130	`is_successful` boolean NOT NULL
131	`created_at` timestamp(3
132	`updated_at` timestamp(3
133	CONSTRAINT `backups_id` PRIMARY KEY
134	CONSTRAINT `backups_uuid_unique` UNIQUE
135	);
136	--> statement-breakpoint
137	CREATE TABLE `database_hosts` (
138	`id` varchar(36
139	`name` varchar(255
140	`host` varchar(255
141	`port` int NOT NULL
142	`username` varchar(100
143	`password` text NOT NULL
144	`max_databases` int NOT NULL
145	`created_at` timestamp(3
146	`updated_at` timestamp(3
147	CONSTRAINT `database_hosts_id` PRIMARY KEY
148	);
149	--> statement-breakpoint
150	CREATE TABLE `egg_variables` (
151	`id` varchar(36
152	`egg_id` varchar(36
153	`name` varchar(255
154	`description` text,
155	`env_variable` varchar(255
156	`default_value` text,
157	`user_viewable` boolean NOT NULL
158	`user_editable` boolean NOT NULL
159	`rules` text,
160	`created_at` timestamp(3
161	`updated_at` timestamp(3
162	CONSTRAINT `egg_variables_id` PRIMARY KEY
163	);
164	--> statement-breakpoint
165	CREATE TABLE `eggs` (
166	`id` varchar(36
167	`uuid` varchar(36
168	`nest_id` varchar(36
169	`config_from` varchar(36
170	`name` varchar(255
171	`description` text,
172	`features` text,
173	`docker_images` text NOT NULL
174	`stop_command` varchar(255
175	`startup` text NOT NULL
176	`config_files` text,
177	`config_startup` text,
178	`config_stop` text,
179	`config_logs` text,
180	`script_install` text,
181	`script_entry` varchar(255
182	`script_container` varchar(255
183	`script_extension` varchar(255
184	`created_at` timestamp(3
185	`updated_at` timestamp(3
186	CONSTRAINT `eggs_id` PRIMARY KEY
187	CONSTRAINT `eggs_uuid_unique` UNIQUE
188	);
189	--> statement-breakpoint
190	CREATE TABLE `locations` (
191	`id` varchar(36
192	`name` varchar(255
193	`short` varchar(60
194	`long` text,
195	`created_at` timestamp(3
196	`updated_at` timestamp(3
197	CONSTRAINT `locations_id` PRIMARY KEY
198	);
199	--> statement-breakpoint
200	CREATE TABLE `nodes` (
201	`id` varchar(36
202	`uuid` varchar(36
203	`name` varchar(255
204	`description` text,
205	`location_id` varchar(36
206	`fqdn` varchar(255
207	`scheme` varchar(10
208	`memory` int NOT NULL
209	`memory_overallocate` int NOT NULL
210	`disk` int NOT NULL
211	`disk_overallocate` int NOT NULL
212	`upload_size` int NOT NULL
213	`daemon_listen` int NOT NULL
214	`daemon_sftp` int NOT NULL
215	`daemon_base` varchar(255
216	`maintenance_mode` boolean NOT NULL
217	`token_id` varchar(36
218	`token` text NOT NULL
219	`created_at` timestamp(3
220	`updated_at` timestamp(3
221	CONSTRAINT `nodes_id` PRIMARY KEY
222	CONSTRAINT `nodes_uuid_unique` UNIQUE
223	CONSTRAINT `nodes_tokenId_unique` UNIQUE
224	);
225	--> statement-breakpoint
226	CREATE TABLE `nests` (
227	`id` varchar(36
228	`uuid` varchar(36
229	`name` varchar(255
230	`description` text,
231	`author` varchar(255
232	`created_at` timestamp(3
233	`updated_at` timestamp(3
234	CONSTRAINT `nests_id` PRIMARY KEY
235	CONSTRAINT `nests_uuid_unique` UNIQUE
236	);
237	--> statement-breakpoint
238	CREATE TABLE `mounts` (
239	`id` varchar(36
240	`uuid` varchar(36
241	`name` varchar(255
242	`description` text,
243	`source` varchar(255
244	`target` varchar(255
245	`read_only` boolean NOT NULL
246	`user_mountable` boolean NOT NULL
247	`created_at` timestamp(3
248	`updated_at` timestamp(3
249	CONSTRAINT `mounts_id` PRIMARY KEY
250	CONSTRAINT `mounts_uuid_unique` UNIQUE
251	);
252	--> statement-breakpoint
253	CREATE TABLE `servers` (
254	`id` varchar(36
255	`uuid` varchar(36
256	`uuid_short` varchar(8
257	`name` varchar(255
258	`description` text,
259	`user_id` varchar(36
260	`node_id` varchar(36
261	`egg_id` varchar(36
262	`allocation_id` varchar(36
263	`status` varchar(30
264	`power_state` varchar(20
265	`suspended` boolean NOT NULL
266	`memory` int NOT NULL
267	`disk` int NOT NULL
268	`cpu` int NOT NULL
269	`swap` int NOT NULL
270	`io` int NOT NULL
271	`threads` varchar(100
272	`oom_disabled` boolean NOT NULL
273	`image` varchar(255
274	`startup` text NOT NULL
275	`skip_scripts` boolean NOT NULL
276	`invocation` text NOT NULL
277	`created_at` timestamp(3
278	`updated_at` timestamp(3
279	CONSTRAINT `servers_id` PRIMARY KEY
280	CONSTRAINT `servers_uuid_unique` UNIQUE
281	CONSTRAINT `servers_uuid_short_unique` UNIQUE
282	);
283	--> statement-breakpoint
284	CREATE TABLE `server_variables` (
285	`id` varchar(36
286	`server_id` varchar(36
287	`variable_id` varchar(36
288	`variable_value` text NOT NULL
289	`created_at` timestamp(3
290	`updated_at` timestamp(3
291	CONSTRAINT `server_variables_id` PRIMARY KEY
292	CONSTRAINT `server_variables_server_variable_unique` UNIQUE
293	);
294	--> statement-breakpoint
295	CREATE TABLE `server_mounts` (
296	`id` varchar(36
297	`server_id` varchar(36
298	`mount_id` varchar(36
299	CONSTRAINT `server_mounts_id` PRIMARY KEY
300	CONSTRAINT `server_mounts_unique` UNIQUE
301	);
302	--> statement-breakpoint
303	CREATE TABLE `server_databases` (
304	`id` varchar(36
305	`uuid` varchar(36
306	`server_id` varchar(36
307	`host_id` varchar(36
308	`database` varchar(255
309	`username` varchar(100
310	`max_connections` int NOT NULL
311	`remote` varchar(15
312	`password` text NOT NULL
313	`created_at` timestamp(3
314	`updated_at` timestamp(3
315	CONSTRAINT `server_databases_id` PRIMARY KEY
316	CONSTRAINT `server_databases_uuid_unique` UNIQUE
317	);
318	--> statement-breakpoint
319	CREATE TABLE `schedule_tasks` (
320	`id` varchar(36
321	`schedule_id` varchar(36
322	`sequence_id` int NOT NULL
323	`action` varchar(60
324	`payload` text NOT NULL
325	`time_offset` int NOT NULL
326	`is_queued` boolean NOT NULL
327	`continue_on_failure` boolean NOT NULL
328	`created_at` timestamp(3
329	`updated_at` timestamp(3
330	CONSTRAINT `schedule_tasks_id` PRIMARY KEY
331	);
332	--> statement-breakpoint
333	CREATE TABLE `schedules` (
334	`id` varchar(36
335	`server_id` varchar(36
336	`name` varchar(255
337	`cron_second` varchar(30
338	`cron_minute` varchar(30
339	`cron_hour` varchar(30
340	`cron_day_of_week` varchar(30
341	`cron_day_of_month` varchar(30
342	`is_active` boolean NOT NULL
343	`is_processing` boolean NOT NULL
344	`timezone_offset` varchar(100
345	`last_run_at` timestamp(3
346	`next_run_at` timestamp(3
347	`created_at` timestamp(3
348	`updated_at` timestamp(3
349	CONSTRAINT `schedules_id` PRIMARY KEY
350	);
351	--> statement-breakpoint
352	CREATE TABLE `subusers` (
353	`id` varchar(36
354	`user_id` varchar(36
355	`server_id` varchar(36
356	`permissions` text NOT NULL
357	`created_at` timestamp(3
358	`updated_at` timestamp(3
359	CONSTRAINT `subusers_id` PRIMARY KEY
360	CONSTRAINT `subusers_user_server_unique` UNIQUE
361	);
362	--> statement-breakpoint
363	ALTER TABLE `node_allocations` ADD
364	ALTER TABLE `account` ADD
365	ALTER TABLE `session` ADD
366	ALTER TABLE `twoFactor` ADD
367	ALTER TABLE `backups` ADD
368	ALTER TABLE `egg_variables` ADD
369	ALTER TABLE `eggs` ADD
370	ALTER TABLE `nodes` ADD
371	ALTER TABLE `servers` ADD
372	ALTER TABLE `servers` ADD
373	ALTER TABLE `servers` ADD
374	ALTER TABLE `servers` ADD
375	ALTER TABLE `server_variables` ADD
376	ALTER TABLE `server_variables` ADD
377	ALTER TABLE `server_mounts` ADD
378	ALTER TABLE `server_mounts` ADD
379	ALTER TABLE `server_databases` ADD
380	ALTER TABLE `server_databases` ADD
381	ALTER TABLE `schedule_tasks` ADD
382	ALTER TABLE `schedules` ADD
383	ALTER TABLE `subusers` ADD
384	ALTER TABLE `subusers` ADD
385	CREATE INDEX `activity_logs_serverId_idx` ON
386	CREATE INDEX `activity_logs_userId_idx` ON
387	CREATE INDEX `activity_logs_timestamp_idx` ON
388	CREATE INDEX `allocations_nodeId_idx` ON
389	CREATE INDEX `allocations_serverId_idx` ON
390	CREATE INDEX `account_userId_idx` ON
391	CREATE INDEX `apikey_referenceId_idx` ON
392	CREATE INDEX `session_userId_idx` ON
393	CREATE INDEX `verification_identifier_idx` ON
394	CREATE INDEX `backups_serverId_idx` ON
395	CREATE INDEX `egg_variables_eggId_idx` ON
396	CREATE INDEX `eggs_nestId_idx` ON
397	CREATE INDEX `nodes_locationId_idx` ON
398	CREATE INDEX `servers_userId_idx` ON
399	CREATE INDEX `servers_nodeId_idx` ON
400	CREATE INDEX `servers_eggId_idx` ON
401	CREATE INDEX `server_variables_serverId_idx` ON
402	CREATE INDEX `server_mounts_serverId_idx` ON
403	CREATE INDEX `server_databases_serverId_idx` ON
404	CREATE INDEX `schedule_tasks_scheduleId_idx` ON
405	CREATE INDEX `schedules_serverId_idx` ON
406	CREATE INDEX `subusers_userId_idx` ON
407	CREATE INDEX `subusers_serverId_idx` ON