From 87044a747b47bd83249d61a45842c7f7b2eae56d Mon Sep 17 00:00:00 2001 From: soryu 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