1CREATE TABLE "worktree_settings_files" (
2 "project_id" INTEGER NOT NULL,
3 "worktree_id" INT8 NOT NULL,
4 "path" VARCHAR NOT NULL,
5 "content" TEXT NOT NULL,
6 PRIMARY KEY(project_id, worktree_id, path),
7 FOREIGN KEY(project_id, worktree_id) REFERENCES worktrees (project_id, id) ON DELETE CASCADE
8);
9CREATE INDEX "index_settings_files_on_project_id" ON "worktree_settings_files" ("project_id");
10CREATE INDEX "index_settings_files_on_project_id_and_wt_id" ON "worktree_settings_files" ("project_id", "worktree_id");