-- Chains table - DAG of contracts for multi-contract orchestration
-- Fits Makima's control theme - she controls through invisible chains
CREATE TABLE IF NOT EXISTS chains (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    owner_id UUID NOT NULL REFERENCES owners(id) ON DELETE CASCADE,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    status VARCHAR(32) NOT NULL DEFAULT 'active',  -- active/completed/archived
    -- Loop control for iterative execution
    loop_enabled BOOLEAN NOT NULL DEFAULT false,
    loop_max_iterations INTEGER DEFAULT 10,
    loop_current_iteration INTEGER DEFAULT 0,
    loop_progress_check TEXT,  -- Prompt/criteria for evaluating progress
    -- Repository reference (optional - contracts may have their own repos)
    repository_url VARCHAR(512),
    local_path VARCHAR(512),
    -- Versioning for optimistic locking
    version INTEGER NOT NULL DEFAULT 1,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX idx_chains_owner_id ON chains(owner_id);
CREATE INDEX idx_chains_status ON chains(status);

-- Chain contracts - links contracts to chains with DAG dependency info
-- The depends_on array forms the DAG edges (directed acyclic graph)
CREATE TABLE IF NOT EXISTS chain_contracts (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    chain_id UUID NOT NULL REFERENCES chains(id) ON DELETE CASCADE,
    contract_id UUID NOT NULL REFERENCES contracts(id) ON DELETE CASCADE,
    -- DAG edges: contract IDs this contract depends on (must complete before this starts)
    depends_on UUID[] DEFAULT '{}',
    -- Order for display/processing (topological sort order)
    order_index INTEGER NOT NULL DEFAULT 0,
    -- Position for GUI editor
    editor_x FLOAT DEFAULT 0,
    editor_y FLOAT DEFAULT 0,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    UNIQUE(chain_id, contract_id)
);

CREATE INDEX idx_chain_contracts_chain_id ON chain_contracts(chain_id);
CREATE INDEX idx_chain_contracts_contract_id ON chain_contracts(contract_id);

-- Add chain_id to contracts table for reverse lookup
ALTER TABLE contracts ADD COLUMN IF NOT EXISTS chain_id UUID REFERENCES chains(id) ON DELETE SET NULL;
CREATE INDEX IF NOT EXISTS idx_contracts_chain_id ON contracts(chain_id);

-- Chain events for audit trail
CREATE TABLE IF NOT EXISTS chain_events (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    chain_id UUID NOT NULL REFERENCES chains(id) ON DELETE CASCADE,
    event_type VARCHAR(64) NOT NULL,  -- created, contract_added, contract_completed, loop_iteration, completed
    contract_id UUID REFERENCES contracts(id) ON DELETE SET NULL,
    event_data JSONB,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX idx_chain_events_chain_id ON chain_events(chain_id);