mirror of
https://github.com/YuzuZensai/Termix.git
synced 2026-09-13 10:49:03 +00:00
890 lines
44 KiB
SQL
890 lines
44 KiB
SQL
|
+3
         
|
CREATE TABLE `alert_firings` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`rule_id` int NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`host_name` text NOT NULL,
|
||
|
|
`fired_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`resolved_at` text,
|
||
|
|
`value` double,
|
||
|
|
`message` text NOT NULL,
|
||
|
|
`severity` text NOT NULL DEFAULT ('warning'),
|
||
|
|
`acknowledged` boolean NOT NULL DEFAULT false,
|
||
|
|
CONSTRAINT `alert_firings_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `alert_rule_channels` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`rule_id` int NOT NULL,
|
||
|
|
`channel_id` int NOT NULL,
|
||
|
|
CONSTRAINT `alert_rule_channels_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `alert_rules` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`enabled` boolean NOT NULL DEFAULT true,
|
||
|
|
`trigger_type` text NOT NULL,
|
||
|
|
`threshold_value` double,
|
||
|
|
`threshold_duration_seconds` int,
|
||
|
|
`cooldown_minutes` int NOT NULL DEFAULT 15,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `alert_rules_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `api_keys` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`token_hash` text NOT NULL,
|
||
|
|
`token_prefix` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text,
|
||
|
|
`last_used_at` text,
|
||
|
|
`is_active` boolean NOT NULL DEFAULT true,
|
||
|
|
CONSTRAINT `api_keys_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `audit_logs` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255),
|
||
|
|
`username` text NOT NULL,
|
||
|
|
`action` text NOT NULL,
|
||
|
|
`resource_type` text NOT NULL,
|
||
|
|
`resource_id` text,
|
||
|
|
`resource_name` text,
|
||
|
|
`details` text,
|
||
|
|
`ip_address` text,
|
||
|
|
`user_agent` text,
|
||
|
|
`success` boolean NOT NULL,
|
||
|
|
`error_message` text,
|
||
|
|
`timestamp` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `audit_logs_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `c2s_tunnel_presets` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`config` text NOT NULL,
|
||
|
|
`platform` text,
|
||
|
|
`computer_name` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `c2s_tunnel_presets_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `command_history` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`command` text NOT NULL,
|
||
|
|
`executed_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `command_history_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `dashboard_service_links` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`label` text NOT NULL,
|
||
|
|
`url` text NOT NULL,
|
||
|
|
`order` int NOT NULL DEFAULT 0,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `dashboard_service_links_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `dashboard_service_links_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `dismissed_alerts` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`alert_id` text NOT NULL,
|
||
|
|
`dismissed_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `dismissed_alerts_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `file_manager_pinned` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`path` text NOT NULL,
|
||
|
|
`pinned_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `file_manager_pinned_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `file_manager_recent` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`path` text NOT NULL,
|
||
|
|
`last_opened` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `file_manager_recent_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `file_manager_shortcuts` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`path` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `file_manager_shortcuts_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `homepage_items` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`type_id` text NOT NULL,
|
||
|
|
`title` text,
|
||
|
|
`config` text NOT NULL DEFAULT ('{}'),
|
||
|
|
`folder_id` int,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `homepage_items_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `homepage_items_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `homepage_layouts` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`layout` text NOT NULL DEFAULT ('{}'),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `homepage_layouts_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `homepage_layouts_user_id_unique` UNIQUE(`user_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `host_access` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255),
|
||
|
|
`role_id` int,
|
||
|
|
`granted_by` varchar(255) NOT NULL,
|
||
|
|
`permission_level` text NOT NULL DEFAULT ('connect'),
|
||
|
|
`expires_at` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`last_accessed_at` text,
|
||
|
|
`access_count` int NOT NULL DEFAULT 0,
|
||
|
|
CONSTRAINT `host_access_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `host_health_checks` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`checks` text NOT NULL,
|
||
|
|
`interval_seconds` int NOT NULL DEFAULT 300,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `host_health_checks_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_host_health_checks_user_host` UNIQUE(`user_id`,`host_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `host_health_history` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`check_id` text NOT NULL,
|
||
|
|
`ts` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`ok` boolean NOT NULL,
|
||
|
|
`latency_ms` int,
|
||
|
|
`detail` text,
|
||
|
|
CONSTRAINT `host_health_history_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `host_metrics_history` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`ts` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`cpu_percent` double,
|
||
|
|
`mem_percent` double,
|
||
|
|
`disk_percent` double,
|
||
|
|
`net_rx_bytes` int,
|
||
|
|
`net_tx_bytes` int,
|
||
|
|
CONSTRAINT `host_metrics_history_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `host_metrics_preferences` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`layout` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `host_metrics_preferences_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_host_metrics_prefs_user_host` UNIQUE(`user_id`,`host_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `ssh_data` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`connection_type` text NOT NULL DEFAULT ('ssh'),
|
||
|
|
`name` varchar(255),
|
||
|
|
`ip` text NOT NULL,
|
||
|
|
`port` int NOT NULL,
|
||
|
|
`username` text NOT NULL,
|
||
|
|
`folder` text,
|
||
|
|
`tags` text,
|
||
|
|
`pin` boolean NOT NULL DEFAULT false,
|
||
|
|
`auth_type` text NOT NULL,
|
||
|
|
`use_warpgate` boolean NOT NULL DEFAULT false,
|
||
|
|
`share_ssh_auth` boolean NOT NULL DEFAULT false,
|
||
|
|
`force_keyboard_interactive` text,
|
||
|
|
`password` text,
|
||
|
|
`key` text,
|
||
|
|
`key_password` text,
|
||
|
|
`key_type` text,
|
||
|
|
`sudo_password` text,
|
||
|
|
`autostart_password` text,
|
||
|
|
`autostart_key` text,
|
||
|
|
`autostart_key_password` text,
|
||
|
|
`credential_id` int,
|
||
|
|
`override_credential_username` boolean,
|
||
|
|
`vault_profile_id` int,
|
||
|
|
`enable_terminal` boolean NOT NULL DEFAULT true,
|
||
|
|
`enable_session_logging` boolean NOT NULL DEFAULT true,
|
||
|
|
`allow_session_sharing` boolean NOT NULL DEFAULT true,
|
||
|
|
`enable_command_history` boolean NOT NULL DEFAULT true,
|
||
|
|
`enable_tunnel` boolean NOT NULL DEFAULT true,
|
||
|
|
`tunnel_connections` text,
|
||
|
|
`jump_hosts` text,
|
||
|
|
`enable_file_manager` boolean NOT NULL DEFAULT true,
|
||
|
|
`scp_legacy` boolean NOT NULL DEFAULT false,
|
||
|
|
`enable_docker` boolean NOT NULL DEFAULT false,
|
||
|
|
`enable_tmux_monitor` boolean NOT NULL DEFAULT false,
|
||
|
|
`show_terminal_in_sidebar` boolean NOT NULL DEFAULT true,
|
||
|
|
`show_file_manager_in_sidebar` boolean NOT NULL DEFAULT false,
|
||
|
|
`show_tunnel_in_sidebar` boolean NOT NULL DEFAULT false,
|
||
|
|
`show_docker_in_sidebar` boolean NOT NULL DEFAULT false,
|
||
|
|
`show_server_stats_in_sidebar` boolean NOT NULL DEFAULT false,
|
||
|
|
`default_path` text,
|
||
|
|
`stats_config` text,
|
||
|
|
`docker_config` text,
|
||
|
|
`enable_proxmox` boolean NOT NULL DEFAULT false,
|
||
|
|
`proxmox_config` text,
|
||
|
|
`terminal_config` text,
|
||
|
|
`quick_actions` text,
|
||
|
|
`notes` text,
|
||
|
|
`enable_ssh` boolean NOT NULL DEFAULT true,
|
||
|
|
`enable_rdp` boolean NOT NULL DEFAULT false,
|
||
|
|
`enable_vnc` boolean NOT NULL DEFAULT false,
|
||
|
|
`enable_telnet` boolean NOT NULL DEFAULT false,
|
||
|
|
`ssh_port` int DEFAULT 22,
|
||
|
|
`rdp_port` int DEFAULT 3389,
|
||
|
|
`vnc_port` int DEFAULT 5900,
|
||
|
|
`telnet_port` int DEFAULT 23,
|
||
|
|
`rdp_credential_id` int,
|
||
|
|
`rdp_user` text,
|
||
|
|
`rdp_password` text,
|
||
|
|
`rdp_domain` text,
|
||
|
|
`rdp_security` text,
|
||
|
|
`rdp_ignore_cert` boolean DEFAULT false,
|
||
|
|
`vnc_credential_id` int,
|
||
|
|
`vnc_password` text,
|
||
|
|
`vnc_user` text,
|
||
|
|
`telnet_user` text,
|
||
|
|
`telnet_password` text,
|
||
|
|
`telnet_credential_id` int,
|
||
|
|
`rdp_auth_type` text,
|
||
|
|
`vnc_auth_type` text,
|
||
|
|
`telnet_auth_type` text,
|
||
|
|
`domain` text,
|
||
|
|
`security` text,
|
||
|
|
`ignore_cert` boolean DEFAULT false,
|
||
|
|
`guacamole_config` text,
|
||
|
|
`use_socks5` boolean,
|
||
|
|
`socks5_host` text,
|
||
|
|
`socks5_port` int,
|
||
|
|
`socks5_username` text,
|
||
|
|
`socks5_password` text,
|
||
|
|
`socks5_proxy_chain` text,
|
||
|
|
`connection_origin` text,
|
||
|
|
`mac_address` text,
|
||
|
|
`wol_broadcast_address` text,
|
||
|
|
`port_knock_sequence` text,
|
||
|
|
`host_key_fingerprint` text,
|
||
|
|
`host_key_type` text,
|
||
|
|
`host_key_algorithm` text DEFAULT ('sha256'),
|
||
|
|
`host_key_first_seen` text,
|
||
|
|
`host_key_last_verified` text,
|
||
|
|
`host_key_changed_count` int DEFAULT 0,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `ssh_data_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `ssh_data_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `network_topology` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`topology` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `network_topology_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `notification_channels` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`type` text NOT NULL,
|
||
|
|
`config` text NOT NULL,
|
||
|
|
`enabled` boolean NOT NULL DEFAULT true,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `notification_channels_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `opkssh_tokens` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`ssh_cert` text NOT NULL,
|
||
|
|
`private_key` text NOT NULL,
|
||
|
|
`email` text,
|
||
|
|
`sub` text,
|
||
|
|
`issuer` text,
|
||
|
|
`audience` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text NOT NULL,
|
||
|
|
`last_used` text,
|
||
|
|
CONSTRAINT `opkssh_tokens_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_opkssh_tokens_user_host` UNIQUE(`user_id`,`host_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `recent_activity` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`type` text NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`host_name` text,
|
||
|
|
`timestamp` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `recent_activity_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `roles` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`display_name` text NOT NULL,
|
||
|
|
`description` text,
|
||
|
|
`is_system` boolean NOT NULL DEFAULT false,
|
||
|
|
`permissions` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `roles_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `roles_name_unique` UNIQUE(`name`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `session_recordings` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255),
|
||
|
|
`username` text,
|
||
|
|
`access_id` int,
|
||
|
|
`started_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`ended_at` text,
|
||
|
|
`duration` int,
|
||
|
|
`commands` text,
|
||
|
|
`dangerous_actions` text,
|
||
|
|
`recording_path` text,
|
||
|
|
`protocol` varchar(255) NOT NULL DEFAULT 'ssh',
|
||
|
|
`format` text NOT NULL DEFAULT ('text'),
|
||
|
|
`terminated_by_owner` boolean DEFAULT false,
|
||
|
|
`termination_reason` text,
|
||
|
|
CONSTRAINT `session_recordings_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `session_share_participants` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`share_id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255),
|
||
|
|
`guest_label` text,
|
||
|
|
`joined_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`left_at` text,
|
||
|
|
CONSTRAINT `session_share_participants_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `session_shares` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`owner_user_id` varchar(255) NOT NULL,
|
||
|
|
`protocol` varchar(255) NOT NULL,
|
||
|
|
`session_id` text NOT NULL,
|
||
|
|
`tab_instance_id` text,
|
||
|
|
`share_type` text NOT NULL,
|
||
|
|
`target_user_id` varchar(255),
|
||
|
|
`link_token` varchar(255),
|
||
|
|
`permission_level` text NOT NULL DEFAULT ('read-only'),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text NOT NULL,
|
||
|
|
`revoked_at` text,
|
||
|
|
`last_joined_at` text,
|
||
|
|
`join_count` int NOT NULL DEFAULT 0,
|
||
|
|
CONSTRAINT `session_shares_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `session_shares_link_token_unique` UNIQUE(`link_token`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `sessions` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`jwt_token` text NOT NULL,
|
||
|
|
`device_type` text NOT NULL,
|
||
|
|
`device_info` text NOT NULL,
|
||
|
|
`oidc_sub` text,
|
||
|
|
`oidc_sid` text,
|
||
|
|
`sso_provider_id` int,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text NOT NULL,
|
||
|
|
`last_active_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `sessions_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `settings` (
|
||
|
|
`key` varchar(255) NOT NULL,
|
||
|
|
`value` text NOT NULL,
|
||
|
|
CONSTRAINT `settings_key` PRIMARY KEY(`key`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `shared_host_auth_overrides` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`protocol` varchar(255) NOT NULL DEFAULT 'ssh',
|
||
|
|
`credential_id` int NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `shared_host_auth_overrides_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `shared_host_auth_overrides_host_user_protocol_unique` UNIQUE(`host_id`,`user_id`,`protocol`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `shared_host_secrets` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`host_access_id` int NOT NULL,
|
||
|
|
`target_user_id` varchar(255) NOT NULL,
|
||
|
|
`protocol` varchar(255) NOT NULL DEFAULT 'ssh',
|
||
|
|
`source_type` text NOT NULL DEFAULT ('credential'),
|
||
|
|
`original_credential_id` int,
|
||
|
|
`encrypted_username` text,
|
||
|
|
`encrypted_auth_type` text,
|
||
|
|
`encrypted_password` text,
|
||
|
|
`encrypted_key` text,
|
||
|
|
`encrypted_key_password` text,
|
||
|
|
`encrypted_key_type` text,
|
||
|
|
`encrypted_domain` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `shared_host_secrets_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_shared_host_secrets_scope` UNIQUE(`host_access_id`,`target_user_id`,`protocol`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `snippet_access` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`snippet_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255),
|
||
|
|
`role_id` int,
|
||
|
|
`granted_by` varchar(255) NOT NULL,
|
||
|
|
`permission_level` text NOT NULL DEFAULT ('view'),
|
||
|
|
`expires_at` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `snippet_access_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `snippet_folders` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`color` text,
|
||
|
|
`icon` text,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `snippet_folders_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `snippet_folders_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `snippets` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`content` text NOT NULL,
|
||
|
|
`description` text,
|
||
|
|
`folder` text,
|
||
|
|
`order` int NOT NULL DEFAULT 0,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`host_filter` text,
|
||
|
|
CONSTRAINT `snippets_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `snippets_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `ssh_credential_usage` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`credential_id` int NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`used_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `ssh_credential_usage_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `ssh_credentials` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`description` text,
|
||
|
|
`folder` text,
|
||
|
|
`tags` text,
|
||
|
|
`auth_type` text NOT NULL,
|
||
|
|
`username` text,
|
||
|
|
`password` text,
|
||
|
|
`key` text,
|
||
|
|
`private_key` text,
|
||
|
|
`public_key` text,
|
||
|
|
`key_password` text,
|
||
|
|
`key_type` text,
|
||
|
|
`detected_key_type` text,
|
||
|
|
`cert_public_key` text,
|
||
|
|
`usage_count` int NOT NULL DEFAULT 0,
|
||
|
|
`last_used` text,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `ssh_credentials_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `ssh_credentials_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `ssh_folders` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`color` text,
|
||
|
|
`icon` text,
|
||
|
|
`credential_id` int,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `ssh_folders_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `ssh_folders_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `sso_providers` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`type` text NOT NULL,
|
||
|
|
`enabled` boolean NOT NULL DEFAULT true,
|
||
|
|
`display_order` int NOT NULL DEFAULT 0,
|
||
|
|
`config` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `sso_providers_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `sync_tombstones` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`entity_type` text NOT NULL,
|
||
|
|
`sync_id` varchar(255) NOT NULL,
|
||
|
|
`deleted_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `sync_tombstones_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `termix_identities` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`handle` varchar(255) NOT NULL,
|
||
|
|
`description` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `termix_identities_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `termix_identities_user_id_unique` UNIQUE(`user_id`),
|
||
|
|
CONSTRAINT `termix_identities_handle_unique` UNIQUE(`handle`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `termix_identity_ca` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`identity_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`public_key` text NOT NULL,
|
||
|
|
`private_key` text NOT NULL,
|
||
|
|
`validity_days` int NOT NULL DEFAULT 90,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `termix_identity_ca_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `termix_identity_ca_identity_id_unique` UNIQUE(`identity_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `termix_identity_keys` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`identity_id` int NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`public_key` text NOT NULL,
|
||
|
|
`key_type` text NOT NULL,
|
||
|
|
`algorithm` text NOT NULL,
|
||
|
|
`label` text,
|
||
|
|
`comment` text,
|
||
|
|
`source` text NOT NULL DEFAULT ('manual'),
|
||
|
|
`credential_id` int,
|
||
|
|
`enabled` boolean NOT NULL DEFAULT true,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `termix_identity_keys_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `tmux_session_tags` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`host_id` int NOT NULL,
|
||
|
|
`session_name` text NOT NULL,
|
||
|
|
`tag` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `tmux_session_tags_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `transfer_recent` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`source_host_id` int NOT NULL,
|
||
|
|
`dest_host_id` int NOT NULL,
|
||
|
|
`dest_path` text NOT NULL,
|
||
|
|
`dest_path_label` text NOT NULL,
|
||
|
|
`last_used` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `transfer_recent_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `trusted_devices` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`device_fingerprint` text NOT NULL,
|
||
|
|
`device_type` text NOT NULL,
|
||
|
|
`device_info` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text NOT NULL,
|
||
|
|
`last_used_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `trusted_devices_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `user_open_tabs` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`tab_type` text NOT NULL,
|
||
|
|
`host_id` int,
|
||
|
|
`label` text NOT NULL,
|
||
|
|
`tab_order` int NOT NULL DEFAULT 0,
|
||
|
|
`backend_session_id` text,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `user_open_tabs_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `user_preferences` (
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`reopen_tabs_on_login` boolean NOT NULL DEFAULT false,
|
||
|
|
`theme` text,
|
||
|
|
`font_size` text,
|
||
|
|
`accent_color` text,
|
||
|
|
`language` text,
|
||
|
|
`storage_mode` text,
|
||
|
|
`command_autocomplete` boolean,
|
||
|
|
`command_palette_enabled` boolean,
|
||
|
|
`show_host_tags` boolean,
|
||
|
|
`host_tray_on_click` boolean,
|
||
|
|
`pin_app_rail` boolean,
|
||
|
|
`expand_app_rail_on_hover` boolean,
|
||
|
|
`folders_collapsed` boolean,
|
||
|
|
`confirm_snippet_execution` boolean,
|
||
|
|
`disable_update_check` boolean,
|
||
|
|
`confirm_tab_close` boolean,
|
||
|
|
`hidden_rail_tabs` text,
|
||
|
|
`compact_host_view` boolean,
|
||
|
|
`status_color_scheme` text,
|
||
|
|
`custom_themes` text,
|
||
|
|
`custom_keybindings` text,
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `user_preferences_user_id` PRIMARY KEY(`user_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `user_roles` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`role_id` int NOT NULL,
|
||
|
|
`granted_by` varchar(255),
|
||
|
|
`granted_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `user_roles_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_user_roles_user_role` UNIQUE(`user_id`,`role_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `users` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`username` text NOT NULL,
|
||
|
|
`password_hash` text NOT NULL,
|
||
|
|
`is_admin` boolean NOT NULL DEFAULT false,
|
||
|
|
`is_oidc` boolean NOT NULL DEFAULT false,
|
||
|
|
`oidc_identifier` text,
|
||
|
|
`sso_provider_id` int,
|
||
|
|
`client_id` text,
|
||
|
|
`client_secret` text,
|
||
|
|
`issuer_url` text,
|
||
|
|
`authorization_url` text,
|
||
|
|
`token_url` text,
|
||
|
|
`identifier_path` text,
|
||
|
|
`name_path` text,
|
||
|
|
`scopes` text DEFAULT ('openid email profile'),
|
||
|
|
`totp_secret` text,
|
||
|
|
`totp_enabled` boolean NOT NULL DEFAULT false,
|
||
|
|
`totp_backup_codes` text,
|
||
|
|
`registered_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`donation_modal_dismissed` boolean NOT NULL DEFAULT false,
|
||
|
|
CONSTRAINT `users_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `vault_profiles` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`description` text,
|
||
|
|
`folder` text,
|
||
|
|
`tags` text,
|
||
|
|
`vault_addr` text NOT NULL,
|
||
|
|
`vault_namespace` text,
|
||
|
|
`oidc_mount` text,
|
||
|
|
`oidc_role` text,
|
||
|
|
`ssh_mount` text,
|
||
|
|
`ssh_role` text NOT NULL,
|
||
|
|
`valid_principals` text,
|
||
|
|
`key_type` text,
|
||
|
|
`shared` boolean NOT NULL DEFAULT false,
|
||
|
|
`sync_id` varchar(255),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`updated_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
CONSTRAINT `vault_profiles_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `vault_profiles_sync_id_unique` UNIQUE(`sync_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `vault_tokens` (
|
||
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`profile_id` int NOT NULL,
|
||
|
|
`ssh_cert` text NOT NULL,
|
||
|
|
`private_key` text NOT NULL,
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`expires_at` text NOT NULL,
|
||
|
|
`last_used` text,
|
||
|
|
CONSTRAINT `vault_tokens_id` PRIMARY KEY(`id`),
|
||
|
|
CONSTRAINT `idx_vault_tokens_user_profile` UNIQUE(`user_id`,`profile_id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
CREATE TABLE `webauthn_credentials` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`user_id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(255) NOT NULL,
|
||
|
|
`credential_id` text NOT NULL,
|
||
|
|
`public_key` text NOT NULL,
|
||
|
|
`counter` int NOT NULL DEFAULT 0,
|
||
|
|
`device_type` text,
|
||
|
|
`backed_up` boolean NOT NULL DEFAULT false,
|
||
|
|
`transports` text,
|
||
|
|
`user_verification` text NOT NULL DEFAULT ('preferred'),
|
||
|
|
`created_at` text NOT NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`last_used_at` text,
|
||
|
|
CONSTRAINT `webauthn_credentials_id` PRIMARY KEY(`id`)
|
||
|
|
);
|
||
|
|
--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_firings` ADD CONSTRAINT `alert_firings_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_firings` ADD CONSTRAINT `alert_firings_rule_id_alert_rules_id_fk` FOREIGN KEY (`rule_id`) REFERENCES `alert_rules`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_rule_channels` ADD CONSTRAINT `alert_rule_channels_rule_id_alert_rules_id_fk` FOREIGN KEY (`rule_id`) REFERENCES `alert_rules`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_rule_channels` ADD CONSTRAINT `alert_rule_channels_channel_id_notification_channels_id_fk` FOREIGN KEY (`channel_id`) REFERENCES `notification_channels`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_rules` ADD CONSTRAINT `alert_rules_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `alert_rules` ADD CONSTRAINT `alert_rules_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `api_keys` ADD CONSTRAINT `api_keys_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `audit_logs` ADD CONSTRAINT `audit_logs_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `c2s_tunnel_presets` ADD CONSTRAINT `c2s_tunnel_presets_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `command_history` ADD CONSTRAINT `command_history_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `command_history` ADD CONSTRAINT `command_history_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `dashboard_service_links` ADD CONSTRAINT `dashboard_service_links_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `dismissed_alerts` ADD CONSTRAINT `dismissed_alerts_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_pinned` ADD CONSTRAINT `file_manager_pinned_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_pinned` ADD CONSTRAINT `file_manager_pinned_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_recent` ADD CONSTRAINT `file_manager_recent_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_recent` ADD CONSTRAINT `file_manager_recent_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_shortcuts` ADD CONSTRAINT `file_manager_shortcuts_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `file_manager_shortcuts` ADD CONSTRAINT `file_manager_shortcuts_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `homepage_items` ADD CONSTRAINT `homepage_items_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `homepage_layouts` ADD CONSTRAINT `homepage_layouts_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_access` ADD CONSTRAINT `host_access_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_access` ADD CONSTRAINT `host_access_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_access` ADD CONSTRAINT `host_access_role_id_roles_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_access` ADD CONSTRAINT `host_access_granted_by_users_id_fk` FOREIGN KEY (`granted_by`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_health_checks` ADD CONSTRAINT `host_health_checks_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_health_checks` ADD CONSTRAINT `host_health_checks_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_health_history` ADD CONSTRAINT `host_health_history_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_health_history` ADD CONSTRAINT `host_health_history_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_metrics_history` ADD CONSTRAINT `host_metrics_history_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_metrics_preferences` ADD CONSTRAINT `host_metrics_preferences_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `host_metrics_preferences` ADD CONSTRAINT `host_metrics_preferences_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_vault_profile_id_vault_profiles_id_fk` FOREIGN KEY (`vault_profile_id`) REFERENCES `vault_profiles`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_rdp_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`rdp_credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_vnc_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`vnc_credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_data` ADD CONSTRAINT `ssh_data_telnet_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`telnet_credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `network_topology` ADD CONSTRAINT `network_topology_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `notification_channels` ADD CONSTRAINT `notification_channels_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `opkssh_tokens` ADD CONSTRAINT `opkssh_tokens_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `opkssh_tokens` ADD CONSTRAINT `opkssh_tokens_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `recent_activity` ADD CONSTRAINT `recent_activity_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `recent_activity` ADD CONSTRAINT `recent_activity_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_recordings` ADD CONSTRAINT `session_recordings_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_recordings` ADD CONSTRAINT `session_recordings_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_recordings` ADD CONSTRAINT `session_recordings_access_id_host_access_id_fk` FOREIGN KEY (`access_id`) REFERENCES `host_access`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_share_participants` ADD CONSTRAINT `session_share_participants_share_id_session_shares_id_fk` FOREIGN KEY (`share_id`) REFERENCES `session_shares`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_share_participants` ADD CONSTRAINT `session_share_participants_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_shares` ADD CONSTRAINT `session_shares_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_shares` ADD CONSTRAINT `session_shares_owner_user_id_users_id_fk` FOREIGN KEY (`owner_user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `session_shares` ADD CONSTRAINT `session_shares_target_user_id_users_id_fk` FOREIGN KEY (`target_user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `sessions` ADD CONSTRAINT `sessions_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_auth_overrides` ADD CONSTRAINT `shared_host_auth_overrides_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_auth_overrides` ADD CONSTRAINT `shared_host_auth_overrides_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_auth_overrides` ADD CONSTRAINT `shared_host_auth_overrides_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_secrets` ADD CONSTRAINT `shared_host_secrets_host_access_id_host_access_id_fk` FOREIGN KEY (`host_access_id`) REFERENCES `host_access`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_secrets` ADD CONSTRAINT `shared_host_secrets_target_user_id_users_id_fk` FOREIGN KEY (`target_user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `shared_host_secrets` ADD CONSTRAINT `shared_host_secrets_original_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`original_credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippet_access` ADD CONSTRAINT `snippet_access_snippet_id_snippets_id_fk` FOREIGN KEY (`snippet_id`) REFERENCES `snippets`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippet_access` ADD CONSTRAINT `snippet_access_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippet_access` ADD CONSTRAINT `snippet_access_role_id_roles_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippet_access` ADD CONSTRAINT `snippet_access_granted_by_users_id_fk` FOREIGN KEY (`granted_by`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippet_folders` ADD CONSTRAINT `snippet_folders_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `snippets` ADD CONSTRAINT `snippets_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_credential_usage` ADD CONSTRAINT `ssh_credential_usage_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_credential_usage` ADD CONSTRAINT `ssh_credential_usage_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_credential_usage` ADD CONSTRAINT `ssh_credential_usage_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_credentials` ADD CONSTRAINT `ssh_credentials_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_folders` ADD CONSTRAINT `ssh_folders_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `ssh_folders` ADD CONSTRAINT `ssh_folders_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `sync_tombstones` ADD CONSTRAINT `sync_tombstones_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identities` ADD CONSTRAINT `termix_identities_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identity_ca` ADD CONSTRAINT `termix_identity_ca_identity_id_termix_identities_id_fk` FOREIGN KEY (`identity_id`) REFERENCES `termix_identities`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identity_ca` ADD CONSTRAINT `termix_identity_ca_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identity_keys` ADD CONSTRAINT `termix_identity_keys_identity_id_termix_identities_id_fk` FOREIGN KEY (`identity_id`) REFERENCES `termix_identities`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identity_keys` ADD CONSTRAINT `termix_identity_keys_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `termix_identity_keys` ADD CONSTRAINT `termix_identity_keys_credential_id_ssh_credentials_id_fk` FOREIGN KEY (`credential_id`) REFERENCES `ssh_credentials`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `tmux_session_tags` ADD CONSTRAINT `tmux_session_tags_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `tmux_session_tags` ADD CONSTRAINT `tmux_session_tags_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `transfer_recent` ADD CONSTRAINT `transfer_recent_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `transfer_recent` ADD CONSTRAINT `transfer_recent_source_host_id_ssh_data_id_fk` FOREIGN KEY (`source_host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `transfer_recent` ADD CONSTRAINT `transfer_recent_dest_host_id_ssh_data_id_fk` FOREIGN KEY (`dest_host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `trusted_devices` ADD CONSTRAINT `trusted_devices_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_open_tabs` ADD CONSTRAINT `user_open_tabs_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_open_tabs` ADD CONSTRAINT `user_open_tabs_host_id_ssh_data_id_fk` FOREIGN KEY (`host_id`) REFERENCES `ssh_data`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_preferences` ADD CONSTRAINT `user_preferences_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_roles` ADD CONSTRAINT `user_roles_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_roles` ADD CONSTRAINT `user_roles_role_id_roles_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `user_roles` ADD CONSTRAINT `user_roles_granted_by_users_id_fk` FOREIGN KEY (`granted_by`) REFERENCES `users`(`id`) ON DELETE set null ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `vault_profiles` ADD CONSTRAINT `vault_profiles_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `vault_tokens` ADD CONSTRAINT `vault_tokens_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `vault_tokens` ADD CONSTRAINT `vault_tokens_profile_id_vault_profiles_id_fk` FOREIGN KEY (`profile_id`) REFERENCES `vault_profiles`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
||
|
|
ALTER TABLE `webauthn_credentials` ADD CONSTRAINT `webauthn_credentials_user_id_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE cascade ON UPDATE no action;
|