12 lines
416 B
SQL
12 lines
416 B
SQL
CREATE TABLE `credential` (
|
|
`id` text PRIMARY KEY,
|
|
`connector_id` text NOT NULL,
|
|
`method_id` text NOT NULL,
|
|
`label` text NOT NULL,
|
|
`value` text NOT NULL,
|
|
`active` integer DEFAULT false NOT NULL,
|
|
`time_created` integer NOT NULL,
|
|
`time_updated` integer NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `credential_connector_active_idx` ON `credential` (`connector_id`) WHERE "credential"."active" = 1;
|