-- 007_create_agenda_table.sql
-- Agenda del usuario (derivada de visits + manual + external).

CREATE TABLE IF NOT EXISTS agenda (
    id              TEXT PRIMARY KEY,
    source_type     TEXT NOT NULL CHECK (source_type IN ('visit','manual','external')),
    source_id       TEXT,
    title           TEXT NOT NULL,
    starts_at       TEXT NOT NULL,
    ends_at         TEXT,
    location        TEXT,
    notes           TEXT,
    version         INTEGER NOT NULL DEFAULT 0,
    updated_at      TEXT NOT NULL,
    deleted_at      TEXT
);

CREATE INDEX IF NOT EXISTS idx_agenda_starts ON agenda(starts_at);