From 33a16597aaca4179707d66e5052d4512218627c6 Mon Sep 17 00:00:00 2001
From: soryu <soryu@soryu.co>
Date: Sun, 15 Feb 2026 01:00:13 +0000
Subject: Fixup: override order table

---
 makima/migrations/20260214000000_create_orders.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'makima/migrations/20260214000000_create_orders.sql')

diff --git a/makima/migrations/20260214000000_create_orders.sql b/makima/migrations/20260214000000_create_orders.sql
index cb2fbae..cbccbe1 100644
--- a/makima/migrations/20260214000000_create_orders.sql
+++ b/makima/migrations/20260214000000_create_orders.sql
@@ -2,7 +2,7 @@
 -- Orders represent planned work items (features, bugs, spikes) that can later be
 -- attached to directives (as steps) or contracts for execution.
 
-CREATE TABLE orders (
+CREATE TABLE IF NOT EXISTS orders (
     id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
     owner_id UUID NOT NULL REFERENCES owners(id) ON DELETE CASCADE,
     title VARCHAR(500) NOT NULL,
@@ -29,10 +29,10 @@ CREATE TABLE orders (
 );
 
 -- Index for listing orders by owner
-CREATE INDEX idx_orders_owner_id ON orders(owner_id);
+CREATE INDEX IF NOT EXISTS idx_orders_owner_id ON orders(owner_id);
 -- Composite index for filtering by owner + status (common query pattern)
-CREATE INDEX idx_orders_owner_status ON orders(owner_id, status);
+CREATE INDEX IF NOT EXISTS idx_orders_owner_status ON orders(owner_id, status);
 -- Index for looking up orders linked to a directive
-CREATE INDEX idx_orders_directive_id ON orders(directive_id);
+CREATE INDEX IF NOT EXISTS idx_orders_directive_id ON orders(directive_id);
 -- Index for looking up orders linked to a contract
-CREATE INDEX idx_orders_contract_id ON orders(contract_id);
+CREATE INDEX IF NOT EXISTS idx_orders_contract_id ON orders(contract_id);
-- 
cgit v1.2.3

