mirror of
https://github.com/chaitin/MonkeyCode.git
synced 2026-11-22 03:18:50 +08:00
41 lines
1.5 KiB
SQL
41 lines
1.5 KiB
SQL
CREATE TABLE IF NOT EXISTS git_bots (
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v1() NOT NULL,
|
|
user_id uuid NOT NULL,
|
|
name character varying(64),
|
|
host_id character varying(64) NOT NULL,
|
|
token text,
|
|
platform character varying(32) NOT NULL,
|
|
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
deleted_at timestamp with time zone,
|
|
secret_token text
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_git_bots_host_id ON git_bots USING btree (host_id);
|
|
CREATE INDEX IF NOT EXISTS idx_git_bots_token ON git_bots USING btree (token);
|
|
CREATE INDEX IF NOT EXISTS idx_git_bots_user_id ON git_bots USING btree (user_id);
|
|
|
|
CREATE TABLE IF NOT EXISTS git_bot_users (
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v1() NOT NULL,
|
|
git_bot_id uuid NOT NULL,
|
|
user_id uuid NOT NULL,
|
|
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS unique_idx_git_bot_user ON git_bot_users USING btree (git_bot_id, user_id);
|
|
|
|
CREATE TABLE IF NOT EXISTS git_bot_tasks (
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v1() NOT NULL,
|
|
git_bot_id uuid NOT NULL,
|
|
task_id uuid NOT NULL,
|
|
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS unique_idx_git_bot_tasks_id ON git_bot_tasks USING btree (git_bot_id, task_id);
|
|
|
|
CREATE TABLE IF NOT EXISTS project_git_bots (
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v1() NOT NULL,
|
|
project_id uuid NOT NULL,
|
|
git_bot_id uuid NOT NULL,
|
|
created_at timestamp with time zone DEFAULT now() NOT NULL
|
|
);
|