mirror of
https://github.com/Termix-SSH/Termix.git
synced 2026-08-27 08:28:04 +00:00
ZacharyZcR
5f55289e00
* feat: 1Password Connect secret sources for SSH credentials Hosts and credentials can hold op://vault/item/field references instead of secrets; they are resolved at connect time from the user's secret source (1Password Connect) at the single point where every subsystem receives plaintext credentials, so terminal, SFTP, Docker, metrics and tunnels all work without per-subsystem changes. Sources are per user, optionally shared, with the access token encrypted under the owner's data key; resolved values are cached briefly in memory. * style: format secret source changes
14 lines
557 B
SQL
14 lines
557 B
SQL
CREATE TABLE `secret_sources` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`user_id` text NOT NULL,
|
|
`name` text NOT NULL,
|
|
`kind` text DEFAULT 'onepassword-connect' NOT NULL,
|
|
`base_url` text NOT NULL,
|
|
`token` text NOT NULL,
|
|
`shared` integer DEFAULT false NOT NULL,
|
|
`created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
`updated_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `idx_secret_sources_user` ON `secret_sources` (`user_id`); |