From 792d12df6b1b1bc4f327cbe8e71e7986c67e98f6 Mon Sep 17 00:00:00 2001 From: soryu Date: Sat, 24 Jan 2026 18:11:41 +0000 Subject: Fix history and add retries to makima CLI --- .../20250124000000_fix_history_events_owner_fk.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 makima/migrations/20250124000000_fix_history_events_owner_fk.sql (limited to 'makima/migrations') diff --git a/makima/migrations/20250124000000_fix_history_events_owner_fk.sql b/makima/migrations/20250124000000_fix_history_events_owner_fk.sql new file mode 100644 index 0000000..1f97779 --- /dev/null +++ b/makima/migrations/20250124000000_fix_history_events_owner_fk.sql @@ -0,0 +1,12 @@ +-- Fix history_events owner_id foreign key +-- The owner_id should reference owners(id), not users(id) +-- This was causing all history event inserts to fail silently + +-- Drop the incorrect foreign key constraint +ALTER TABLE history_events + DROP CONSTRAINT IF EXISTS history_events_owner_id_fkey; + +-- Add the correct foreign key constraint referencing owners +ALTER TABLE history_events + ADD CONSTRAINT history_events_owner_id_fkey + FOREIGN KEY (owner_id) REFERENCES owners(id) ON DELETE CASCADE; -- cgit v1.2.3