140 lines · 4.3 KB · Text
RawDownload
CREATE TABLE `blob` (	`namespace` text NOT NULL,	`key` text NOT NULL,	`value` text NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`id` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `blob_id_uidx` ON `blob` (`id`);--> statement-breakpointCREATE TABLE `connection` (	`integration` text NOT NULL,	`name` text NOT NULL,	`template` text NOT NULL,	`provider` text NOT NULL,	`item_ids` text NOT NULL,	`identity_label` text,	`oauth_client` text,	`oauth_client_owner` text,	`refresh_item_id` text,	`expires_at` blob,	`oauth_scope` text,	`provider_state` text,	`created_at` integer NOT NULL,	`updated_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `connection_uidx` ON `connection` (`tenant`,`owner`,`subject`,`integration`,`name`);--> statement-breakpointCREATE TABLE `definition` (	`integration` text NOT NULL,	`connection` text NOT NULL,	`plugin_id` text NOT NULL,	`name` text NOT NULL,	`schema` text NOT NULL,	`created_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `definition_uidx` ON `definition` (`tenant`,`owner`,`subject`,`integration`,`connection`,`name`);--> statement-breakpointCREATE TABLE `integration` (	`slug` text NOT NULL,	`plugin_id` text NOT NULL,	`description` text NOT NULL,	`config` text,	`can_remove` integer DEFAULT 1 NOT NULL,	`can_refresh` integer DEFAULT 0 NOT NULL,	`created_at` integer NOT NULL,	`updated_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `integration_uidx` ON `integration` (`tenant`,`slug`);--> statement-breakpointCREATE TABLE `oauth_client` (	`slug` text NOT NULL,	`authorization_url` text NOT NULL,	`token_url` text NOT NULL,	`grant` text NOT NULL,	`client_id` text NOT NULL,	`client_secret_item_id` text,	`resource` text,	`created_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `oauth_client_uidx` ON `oauth_client` (`tenant`,`owner`,`subject`,`slug`);--> statement-breakpointCREATE TABLE `oauth_session` (	`state` text NOT NULL,	`client_slug` text NOT NULL,	`integration` text NOT NULL,	`name` text NOT NULL,	`template` text NOT NULL,	`redirect_url` text NOT NULL,	`pkce_verifier` text,	`identity_label` text,	`payload` text NOT NULL,	`expires_at` blob NOT NULL,	`created_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `oauth_session_uidx` ON `oauth_session` (`tenant`,`state`);--> statement-breakpointCREATE TABLE `plugin_storage` (	`plugin_id` text NOT NULL,	`collection` text NOT NULL,	`key` text NOT NULL,	`data` text NOT NULL,	`created_at` integer NOT NULL,	`updated_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `plugin_storage_uidx` ON `plugin_storage` (`tenant`,`owner`,`subject`,`plugin_id`,`collection`,`key`);--> statement-breakpointCREATE TABLE `tool` (	`integration` text NOT NULL,	`connection` text NOT NULL,	`plugin_id` text NOT NULL,	`name` text NOT NULL,	`description` text NOT NULL,	`input_schema` text,	`output_schema` text,	`annotations` text,	`created_at` integer NOT NULL,	`updated_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `tool_uidx` ON `tool` (`tenant`,`owner`,`subject`,`integration`,`connection`,`name`);--> statement-breakpointCREATE TABLE `tool_policy` (	`id` text NOT NULL,	`pattern` text NOT NULL,	`action` text NOT NULL,	`position` text NOT NULL,	`created_at` integer NOT NULL,	`updated_at` integer NOT NULL,	`row_id` text PRIMARY KEY NOT NULL,	`tenant` text NOT NULL,	`owner` text NOT NULL,	`subject` text NOT NULL);--> statement-breakpointCREATE UNIQUE INDEX `tool_policy_uidx` ON `tool_policy` (`tenant`,`owner`,`subject`,`id`);