mirror of
https://github.com/Termix-SSH/Termix.git
synced 2026-08-27 16:37:26 +00:00
ZacharyZcR
302ac19e6c
* feat: folder shares apply to hosts added later Sharing a folder only fanned grants out to the hosts in it at the time. The share is now also kept as a standing rule on the folder, and a host created in or moved into it (or a subfolder) inherits the same access and secret snapshots. Rules follow folder renames and can be stopped from the share dialog. * fix: stabilize folder access migrations
17 lines
816 B
SQL
17 lines
816 B
SQL
CREATE TABLE `folder_access` (
|
|
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
`owner_user_id` text NOT NULL,
|
|
`folder` text NOT NULL,
|
|
`user_id` text,
|
|
`role_id` integer,
|
|
`granted_by` text NOT NULL,
|
|
`permission_level` text DEFAULT 'connect' NOT NULL,
|
|
`expires_at` text,
|
|
`created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
FOREIGN KEY (`owner_user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade,
|
|
FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade,
|
|
FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON UPDATE no action ON DELETE cascade,
|
|
FOREIGN KEY (`granted_by`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `idx_folder_access_owner_folder` ON `folder_access` (`owner_user_id`,`folder`); |