mirror of
https://github.com/YuzuZensai/Termix.git
synced 2026-09-13 18:58:52 +00:00
10 lines
583 B
SQL
10 lines
583 B
SQL
|
+5
         
|
CREATE TABLE `host_sidebar_preferences` (
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`data` text NOT NULL,
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `host_sidebar_preferences_user_id` PRIMARY KEY(`user_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD `sort_order` int;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_folders` ADD `sort_order` int;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_sidebar_preferences` ADD CONSTRAINT `host_sidebar_preferences_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;
|