mirror of
https://github.com/nicotsx/ironmount.git
synced 2025-12-10 12:10:51 +01:00
95a0d44b45
* refactor: unify backend and frontend servers * refactor: correct paths for openapi & drizzle * refactor: move api-client to client * fix: drizzle paths * chore: fix linting issues * fix: form reset issue
15 lines
556 B
SQL
15 lines
556 B
SQL
CREATE TABLE `repositories_table` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`name` text NOT NULL,
|
|
`backend` text NOT NULL,
|
|
`config` text NOT NULL,
|
|
`compression_mode` text DEFAULT 'auto',
|
|
`status` text DEFAULT 'unknown',
|
|
`last_checked` integer,
|
|
`last_error` text,
|
|
`created_at` integer DEFAULT (unixepoch()) NOT NULL,
|
|
`updated_at` integer DEFAULT (unixepoch()) NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `repositories_table_name_unique` ON `repositories_table` (`name`);--> statement-breakpoint
|
|
ALTER TABLE `volumes_table` DROP COLUMN `path`; |