Files
MonkeyCode/backend/migration/000007_gitbot.up.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
);