summaryrefslogtreecommitdiff
path: root/makima/migrations/20260205000000_chain_repositories.sql
diff options
context:
space:
mode:
authorsoryu <soryu@soryu.co>2026-02-05 01:55:49 +0000
committersoryu <soryu@soryu.co>2026-02-05 01:55:49 +0000
commit41897cc090bdeacca881ecd75cc19c4e0926fd58 (patch)
treed9741af2b5686f39c7c3e2ba9fb551052f78657d /makima/migrations/20260205000000_chain_repositories.sql
parent6a0c912a3fbd8e9b3e87ef40e960803d819d966d (diff)
downloadsoryu-41897cc090bdeacca881ecd75cc19c4e0926fd58.tar.gz
soryu-41897cc090bdeacca881ecd75cc19c4e0926fd58.zip
Fixup: overlapping migration timestamps
Diffstat (limited to 'makima/migrations/20260205000000_chain_repositories.sql')
-rw-r--r--makima/migrations/20260205000000_chain_repositories.sql27
1 files changed, 0 insertions, 27 deletions
diff --git a/makima/migrations/20260205000000_chain_repositories.sql b/makima/migrations/20260205000000_chain_repositories.sql
deleted file mode 100644
index 5be8cf2..0000000
--- a/makima/migrations/20260205000000_chain_repositories.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- Chain repositories - allow chains to have multiple repositories
--- Similar to contract_repositories but for chains
-CREATE TABLE IF NOT EXISTS chain_repositories (
- id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
- chain_id UUID NOT NULL REFERENCES chains(id) ON DELETE CASCADE,
- name VARCHAR(255) NOT NULL, -- display name / repo name
- repository_url VARCHAR(512), -- NULL for local repos
- local_path VARCHAR(512), -- local filesystem path (for local repos)
- source_type VARCHAR(32) NOT NULL DEFAULT 'remote', -- remote/local/managed
- status VARCHAR(32) NOT NULL DEFAULT 'ready', -- ready/pending/creating/failed
- is_primary BOOLEAN NOT NULL DEFAULT false, -- primary repo for contract defaults
- created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
- updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
-);
-
--- source_type values:
--- 'remote' = existing remote repo (GitHub, GitLab, etc) - has repository_url
--- 'local' = existing local repo - has local_path
--- 'managed' = new repo created/managed by Makima daemon - gets repository_url after creation
-
-CREATE INDEX idx_chain_repositories_chain_id ON chain_repositories(chain_id);
--- Only one primary per chain
-CREATE UNIQUE INDEX idx_chain_repositories_primary ON chain_repositories(chain_id) WHERE is_primary = true;
-
--- Remove the old single repository fields from chains table (they're now in chain_repositories)
-ALTER TABLE chains DROP COLUMN IF EXISTS repository_url;
-ALTER TABLE chains DROP COLUMN IF EXISTS local_path;