1CREATE TABLE "project_repositories" (
 2    "project_id" INTEGER NOT NULL,
 3    "abs_path" VARCHAR,
 4    "id" INT8 NOT NULL,
 5    "legacy_worktree_id" INT8,
 6    "entry_ids" VARCHAR,
 7    "branch" VARCHAR,
 8    "scan_id" INT8 NOT NULL,
 9    "is_deleted" BOOL NOT NULL,
10    "current_merge_conflicts" VARCHAR,
11    "branch_summary" VARCHAR,
12    PRIMARY KEY (project_id, id)
13);
14
15CREATE INDEX "index_project_repositories_on_project_id" ON "project_repositories" ("project_id");
16
17CREATE TABLE "project_repository_statuses" (
18    "project_id" INTEGER NOT NULL,
19    "repository_id" INT8 NOT NULL,
20    "repo_path" VARCHAR NOT NULL,
21    "status" INT8 NOT NULL,
22    "status_kind" INT4 NOT NULL,
23    "first_status" INT4 NULL,
24    "second_status" INT4 NULL,
25    "scan_id" INT8 NOT NULL,
26    "is_deleted" BOOL NOT NULL,
27    PRIMARY KEY (project_id, repository_id, repo_path)
28);
29
30CREATE INDEX "index_project_repos_statuses_on_project_id" ON "project_repository_statuses" ("project_id");
31
32CREATE INDEX "index_project_repos_statuses_on_project_id_and_repo_id" ON "project_repository_statuses" ("project_id", "repository_id");