1CREATE TABLE IF NOT EXISTS "projects" (
 2    "id" SERIAL PRIMARY KEY,
 3    "host_user_id" INTEGER REFERENCES users (id) NOT NULL,
 4    "unregistered" BOOLEAN NOT NULL DEFAULT false
 5);
 6
 7CREATE TABLE IF NOT EXISTS "worktree_extensions" (
 8    "id" SERIAL PRIMARY KEY,
 9    "project_id" INTEGER REFERENCES projects (id) NOT NULL,
10    "worktree_id" INTEGER NOT NULL,
11    "extension" VARCHAR(255),
12    "count" INTEGER NOT NULL
13);
14
15CREATE TABLE IF NOT EXISTS "project_activity_periods" (
16    "id" SERIAL PRIMARY KEY,
17    "duration_millis" INTEGER NOT NULL,
18    "ended_at" TIMESTAMP NOT NULL,
19    "user_id" INTEGER REFERENCES users (id) NOT NULL,
20    "project_id" INTEGER REFERENCES projects (id) NOT NULL
21);
22
23CREATE INDEX "index_project_activity_periods_on_ended_at" ON "project_activity_periods" ("ended_at");
24CREATE UNIQUE INDEX "index_worktree_extensions_on_project_id_and_worktree_id_and_extension" ON "worktree_extensions" ("project_id", "worktree_id", "extension");