From 87044a747b47bd83249d61a45842c7f7b2eae56d Mon Sep 17 00:00:00 2001
From: soryu <soryu@soryu.co>
Date: Sun, 11 Jan 2026 05:52:14 +0000
Subject:  Contract system

---
 .../20250112000000_cascade_delete_contract_children.sql   | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 makima/migrations/20250112000000_cascade_delete_contract_children.sql

(limited to 'makima/migrations/20250112000000_cascade_delete_contract_children.sql')

diff --git a/makima/migrations/20250112000000_cascade_delete_contract_children.sql b/makima/migrations/20250112000000_cascade_delete_contract_children.sql
new file mode 100644
index 0000000..6ef8a43
--- /dev/null
+++ b/makima/migrations/20250112000000_cascade_delete_contract_children.sql
@@ -0,0 +1,15 @@
+-- Change files and tasks to cascade delete when contract is deleted
+-- Previously these were ON DELETE SET NULL, which orphaned records
+
+-- Drop existing foreign key constraints
+ALTER TABLE files DROP CONSTRAINT IF EXISTS files_contract_id_fkey;
+ALTER TABLE tasks DROP CONSTRAINT IF EXISTS tasks_contract_id_fkey;
+
+-- Re-add with CASCADE
+ALTER TABLE files
+    ADD CONSTRAINT files_contract_id_fkey
+    FOREIGN KEY (contract_id) REFERENCES contracts(id) ON DELETE CASCADE;
+
+ALTER TABLE tasks
+    ADD CONSTRAINT tasks_contract_id_fkey
+    FOREIGN KEY (contract_id) REFERENCES contracts(id) ON DELETE CASCADE;
-- 
cgit v1.2.3

