schema.sql

--
-- PostgreSQL database dump
--

\restrict kAaEjsPWLLEcViniWnrQZu7LrzsULDle34hUHzdBk5twSi0Sd3NsjVeLWJhhZoe

-- Dumped from database version 17.9 (Debian 17.9-0+deb13u1)
-- Dumped by pg_dump version 17.9 (Debian 17.9-0+deb13u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: vector; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS vector WITH SCHEMA public;


--
-- Name: EXTENSION vector; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION vector IS 'vector data type and ivfflat and hnsw access methods';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: actor_visibility_configuration; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.actor_visibility_configuration (
    id integer NOT NULL,
    actor_id integer NOT NULL,
    target_actor_id integer,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.actor_visibility_configuration OWNER TO postgres;

--
-- Name: actor_visibility_configuration_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.actor_visibility_configuration_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.actor_visibility_configuration_id_seq OWNER TO postgres;

--
-- Name: actor_visibility_configuration_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.actor_visibility_configuration_id_seq OWNED BY public.actor_visibility_configuration.id;


--
-- Name: actors; Type: TABLE; Schema: public; Owner: memory_api
--

CREATE TABLE public.actors (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    token_hash character varying(128),
    token_salt character varying(64),
    password_hash text,
    password_salt text,
    passphrase_rotated_at timestamp with time zone,
    status character varying(20) DEFAULT 'active'::character varying NOT NULL,
    last_seen timestamp with time zone,
    active_since timestamp with time zone,
    expertise text DEFAULT '[]'::text NOT NULL,
    CONSTRAINT chk_actors_status CHECK (((status)::text = 'active'::text))
);


ALTER TABLE public.actors OWNER TO memory_api;

--
-- Name: actors_id_seq; Type: SEQUENCE; Schema: public; Owner: memory_api
--

CREATE SEQUENCE public.actors_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.actors_id_seq OWNER TO memory_api;

--
-- Name: actors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: memory_api
--

ALTER SEQUENCE public.actors_id_seq OWNED BY public.actors.id;


--
-- Name: admin_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.admin_permissions (
    id integer NOT NULL,
    actor_id integer NOT NULL,
    resource character varying(50) NOT NULL,
    action character varying(50) NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.admin_permissions OWNER TO postgres;

--
-- Name: admin_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.admin_permissions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.admin_permissions_id_seq OWNER TO postgres;

--
-- Name: admin_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.admin_permissions_id_seq OWNED BY public.admin_permissions.id;


--
-- Name: agent_api_keys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.agent_api_keys (
    id integer NOT NULL,
    key_hash character varying(255) NOT NULL,
    key_salt character varying(64) NOT NULL,
    label character varying(100),
    created_at timestamp with time zone DEFAULT now(),
    last_used_at timestamp with time zone,
    revoked_at timestamp with time zone,
    actor_id integer NOT NULL
);


ALTER TABLE public.agent_api_keys OWNER TO postgres;

--
-- Name: agent_api_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.agent_api_keys_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.agent_api_keys_id_seq OWNER TO postgres;

--
-- Name: agent_api_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.agent_api_keys_id_seq OWNED BY public.agent_api_keys.id;


--
-- Name: agent_configuration; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.agent_configuration (
    startup_instructions text,
    provider character varying(50),
    model character varying(100),
    virtual boolean DEFAULT false NOT NULL,
    personality text,
    api_key character varying(512),
    configuration text,
    cache_prompts boolean DEFAULT false NOT NULL,
    learning_enabled boolean DEFAULT true NOT NULL,
    max_tokens integer,
    temperature numeric,
    cost_budget_daily numeric(10,2),
    cost_budget_monthly numeric(10,2),
    actor_id integer NOT NULL,
    CONSTRAINT chk_agent_configuration_provider CHECK (((provider IS NULL) OR ((provider)::text = ANY ((ARRAY['anthropic'::character varying, 'google'::character varying, 'openai'::character varying, 'perplexity'::character varying])::text[]))))
);


ALTER TABLE public.agent_configuration OWNER TO postgres;

--
-- Name: agent_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.agent_permissions (
    permission_id integer NOT NULL,
    granted_at timestamp with time zone DEFAULT now(),
    actor_id integer NOT NULL
);


ALTER TABLE public.agent_permissions OWNER TO postgres;

--
-- Name: agent_status; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.agent_status AS
 SELECT ac.id AS actor_id,
    ac.name AS agent,
        CASE
            WHEN (agc.virtual = true) THEN 'available'::text
            WHEN (ac.last_seen > (now() - '00:15:00'::interval)) THEN 'online'::text
            WHEN (ac.last_seen IS NOT NULL) THEN 'offline'::text
            ELSE 'unknown'::text
        END AS status,
    ac.last_seen,
    ac.passphrase_rotated_at,
    ac.created_at AS registered_at,
    ac.expertise,
    agc.provider,
    agc.model,
    agc.virtual,
    agc.personality,
    agc.cost_budget_daily,
    agc.cost_budget_monthly,
        CASE
            WHEN ((ac.active_since IS NOT NULL) AND (ac.active_since > (now() - '00:30:00'::interval))) THEN ac.active_since
            ELSE NULL::timestamp with time zone
        END AS active_since,
    agc.cache_prompts,
    agc.learning_enabled,
    agc.max_tokens,
    agc.temperature,
    agc.configuration
   FROM (public.actors ac
     JOIN public.agent_configuration agc ON ((agc.actor_id = ac.id)));


ALTER VIEW public.agent_status OWNER TO postgres;

--
-- Name: chat_message_texts; Type: TABLE; Schema: public; Owner: postgres
-- Stores message content once per logical send (MEM-107)
--

CREATE TABLE public.chat_message_texts (
    id integer NOT NULL,
    message text NOT NULL,
    from_actor_id integer NOT NULL,
    discussion_id integer,
    sent_at timestamp with time zone DEFAULT now() NOT NULL
);

ALTER TABLE public.chat_message_texts OWNER TO postgres;

CREATE SEQUENCE public.chat_message_texts_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE public.chat_message_texts_id_seq OWNER TO postgres;
ALTER SEQUENCE public.chat_message_texts_id_seq OWNED BY public.chat_message_texts.id;

--
-- Name: chat_messages; Type: TABLE; Schema: public; Owner: postgres
-- Delivery/recipient tracking table (MEM-107)
--

CREATE TABLE public.chat_messages (
    id integer NOT NULL,
    message_text_id integer NOT NULL,
    to_actor_id integer,
    acked_at timestamp with time zone,
    deleted_at timestamp with time zone
);


ALTER TABLE public.chat_messages OWNER TO postgres;

--
-- Name: chat_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.chat_messages_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.chat_messages_id_seq OWNER TO postgres;

--
-- Name: chat_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.chat_messages_id_seq OWNED BY public.chat_messages.id;


--
-- Name: memory_chunks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.memory_chunks (
    id integer NOT NULL,
    namespace character varying(50) NOT NULL,
    source_file character varying(500) NOT NULL,
    heading character varying(500),
    chunk_text text NOT NULL,
    embedding public.vector(1536),
    ingested_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.memory_chunks OWNER TO postgres;

--
-- Name: chunks_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.chunks_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.chunks_id_seq OWNER TO postgres;

--
-- Name: chunks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.chunks_id_seq OWNED BY public.memory_chunks.id;


--
-- Name: config; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.config (
    key character varying(100) NOT NULL,
    value text NOT NULL,
    description text,
    updated_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.config OWNER TO postgres;

--
-- Name: discussion_ballots; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.discussion_ballots (
    vote_id integer NOT NULL,
    choice integer NOT NULL,
    reason text,
    cast_at timestamp with time zone DEFAULT now() NOT NULL,
    actor_id integer NOT NULL
);


ALTER TABLE public.discussion_ballots OWNER TO postgres;

--
-- Name: discussion_participants; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.discussion_participants (
    discussion_id integer NOT NULL,
    status character varying(20) DEFAULT 'invited'::character varying NOT NULL,
    invited_at timestamp with time zone DEFAULT now() NOT NULL,
    joined_at timestamp with time zone,
    role character varying(20) DEFAULT 'required'::character varying NOT NULL,
    deferred_at timestamp with time zone,
    defer_count integer DEFAULT 0,
    actor_id integer NOT NULL,
    CONSTRAINT chk_discussion_participants_role CHECK (((role)::text = ANY ((ARRAY['required'::character varying, 'optional'::character varying])::text[]))),
    CONSTRAINT chk_discussion_participants_status CHECK (((status)::text = ANY ((ARRAY['invited'::character varying, 'joined'::character varying, 'left'::character varying, 'timed_out'::character varying])::text[]))),
    CONSTRAINT discussion_participants_status_check CHECK (((status)::text = ANY ((ARRAY['invited'::character varying, 'joined'::character varying, 'left'::character varying, 'timed_out'::character varying, 'deferred'::character varying])::text[])))
);


ALTER TABLE public.discussion_participants OWNER TO postgres;

--
-- Name: discussion_votes; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.discussion_votes (
    id integer NOT NULL,
    discussion_id integer NOT NULL,
    question text NOT NULL,
    status character varying(20) DEFAULT 'open'::character varying NOT NULL,
    type character varying(20) DEFAULT 'general'::character varying NOT NULL,
    threshold character varying(20) DEFAULT 'unanimous'::character varying NOT NULL,
    closes_at timestamp with time zone,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    closed_at timestamp with time zone,
    proposed_by_actor_id integer NOT NULL,
    CONSTRAINT chk_discussion_votes_status CHECK (((status)::text = ANY ((ARRAY['open'::character varying, 'closed'::character varying])::text[]))),
    CONSTRAINT chk_discussion_votes_threshold CHECK (((threshold)::text = ANY ((ARRAY['unanimous'::character varying, 'majority'::character varying])::text[]))),
    CONSTRAINT chk_discussion_votes_type CHECK (((type)::text = ANY ((ARRAY['general'::character varying, 'conclude'::character varying])::text[])))
);


ALTER TABLE public.discussion_votes OWNER TO postgres;

--
-- Name: discussion_votes_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.discussion_votes_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.discussion_votes_id_seq OWNER TO postgres;

--
-- Name: discussion_votes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.discussion_votes_id_seq OWNED BY public.discussion_votes.id;


--
-- Name: discussions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.discussions (
    id integer NOT NULL,
    topic text NOT NULL,
    status character varying(20) DEFAULT 'active'::character varying NOT NULL,
    channel character varying(50),
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    concluded_at timestamp with time zone,
    mode character varying(20) DEFAULT 'realtime'::character varying NOT NULL,
    context text,
    timeout_at timestamp with time zone,
    outcome character varying(20),
    created_by_actor_id integer NOT NULL,
    CONSTRAINT chk_discussions_mode CHECK (((mode)::text = ANY ((ARRAY['realtime'::character varying, 'async'::character varying])::text[]))),
    CONSTRAINT chk_discussions_outcome CHECK (((outcome)::text = ANY ((ARRAY['consensus'::character varying, 'deadlock'::character varying, 'partial'::character varying, 'abandoned'::character varying])::text[]))),
    CONSTRAINT chk_discussions_status CHECK (((status)::text = ANY ((ARRAY['waiting'::character varying, 'active'::character varying, 'concluded'::character varying, 'cancelled'::character varying, 'timed_out'::character varying])::text[])))
);


ALTER TABLE public.discussions OWNER TO postgres;

--
-- Name: discussions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.discussions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.discussions_id_seq OWNER TO postgres;

--
-- Name: discussions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.discussions_id_seq OWNED BY public.discussions.id;


--
-- Name: documents; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.documents (
    id integer NOT NULL,
    namespace character varying(64) NOT NULL,
    slug character varying(255) NOT NULL,
    title character varying(500),
    content text NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    deleted_at timestamp with time zone,
    created_by_actor_id integer
);


ALTER TABLE public.documents OWNER TO postgres;

--
-- Name: documents_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.documents_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.documents_id_seq OWNER TO postgres;

--
-- Name: documents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.documents_id_seq OWNED BY public.documents.id;


--
-- Name: error_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.error_log (
    id integer NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    subsystem text NOT NULL,
    action text NOT NULL,
    context text,
    context_id text,
    error_message text NOT NULL,
    error_detail text,
    actor_id integer
);


ALTER TABLE public.error_log OWNER TO postgres;

--
-- Name: error_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.error_log_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.error_log_id_seq OWNER TO postgres;

--
-- Name: error_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.error_log_id_seq OWNED BY public.error_log.id;


--
-- Name: mail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.mail (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    subject character varying(500) NOT NULL,
    body text NOT NULL,
    sent_at timestamp with time zone DEFAULT now() NOT NULL,
    acked_at timestamp with time zone,
    deleted_at timestamp with time zone,
    from_actor_id integer,
    to_actor_id integer NOT NULL
);


ALTER TABLE public.mail OWNER TO postgres;

--
-- Name: mcp_sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.mcp_sessions (
    session_id text NOT NULL,
    tools_hash text NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    actor_id integer NOT NULL
);


ALTER TABLE public.mcp_sessions OWNER TO postgres;

--
-- Name: migrations_applied; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migrations_applied (
    migration_id character varying(50) NOT NULL,
    applied_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.migrations_applied OWNER TO postgres;

--
-- Name: namespace_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.namespace_permissions (
    id integer NOT NULL,
    actor_id integer NOT NULL,
    namespace character varying(100) NOT NULL,
    can_read boolean DEFAULT false NOT NULL,
    can_write boolean DEFAULT false NOT NULL,
    can_delete boolean DEFAULT false NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.namespace_permissions OWNER TO postgres;

--
-- Name: namespace_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.namespace_permissions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.namespace_permissions_id_seq OWNER TO postgres;

--
-- Name: namespace_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.namespace_permissions_id_seq OWNED BY public.namespace_permissions.id;


--
-- Name: permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.permissions (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    created_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.permissions OWNER TO postgres;

--
-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.permissions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.permissions_id_seq OWNER TO postgres;

--
-- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;


--
-- Name: request_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.request_log (
    id integer NOT NULL,
    "timestamp" timestamp with time zone DEFAULT now() NOT NULL,
    method character varying(10) NOT NULL,
    path text,
    status integer,
    duration_ms integer,
    ip character varying(45),
    request_length integer,
    response_length integer,
    actor_id integer
);


ALTER TABLE public.request_log OWNER TO postgres;

--
-- Name: request_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.request_log_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.request_log_id_seq OWNER TO postgres;

--
-- Name: request_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.request_log_id_seq OWNED BY public.request_log.id;


--
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sessions (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    actor_id integer NOT NULL,
    token_hash text NOT NULL,
    token_salt text NOT NULL,
    kind character varying(10) NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    expires_at timestamp with time zone NOT NULL,
    subsystem text,
    CONSTRAINT sessions_kind_check CHECK (((kind)::text = ANY ((ARRAY['web'::character varying, 'api'::character varying])::text[])))
);


ALTER TABLE public.sessions OWNER TO postgres;

--
-- Name: system_errors; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.system_errors (
    id integer NOT NULL,
    source text NOT NULL,
    error_code text NOT NULL,
    context jsonb,
    status text DEFAULT 'unhandled'::text NOT NULL,
    handler_action text,
    resolved_at timestamp with time zone,
    reported_at timestamp with time zone DEFAULT now(),
    actor_id integer
);


ALTER TABLE public.system_errors OWNER TO postgres;

--
-- Name: system_errors_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.system_errors_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.system_errors_id_seq OWNER TO postgres;

--
-- Name: system_errors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.system_errors_id_seq OWNED BY public.system_errors.id;


--
-- Name: templates; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.templates (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    content text NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    kind character varying(50) DEFAULT 'welcome'::character varying NOT NULL,
    CONSTRAINT templates_kind_check CHECK (((kind)::text = 'welcome'::text))
);


ALTER TABLE public.templates OWNER TO postgres;

--
-- Name: virtual_agent_usage; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.virtual_agent_usage (
    id integer NOT NULL,
    provider character varying(50),
    model character varying(100),
    input_tokens integer DEFAULT 0,
    output_tokens integer DEFAULT 0,
    cache_write_tokens integer DEFAULT 0,
    cache_read_tokens integer DEFAULT 0,
    cost numeric(10,6) DEFAULT 0 NOT NULL,
    context character varying(50),
    created_at timestamp with time zone DEFAULT now(),
    actor_id integer NOT NULL
);


ALTER TABLE public.virtual_agent_usage OWNER TO postgres;

--
-- Name: virtual_agent_usage_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.virtual_agent_usage_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.virtual_agent_usage_id_seq OWNER TO postgres;

--
-- Name: virtual_agent_usage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.virtual_agent_usage_id_seq OWNED BY public.virtual_agent_usage.id;


--
-- Name: welcome_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.welcome_templates_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.welcome_templates_id_seq OWNER TO postgres;

--
-- Name: welcome_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.welcome_templates_id_seq OWNED BY public.templates.id;


--
-- Name: actor_visibility_configuration id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.actor_visibility_configuration ALTER COLUMN id SET DEFAULT nextval('public.actor_visibility_configuration_id_seq'::regclass);


--
-- Name: actors id; Type: DEFAULT; Schema: public; Owner: memory_api
--

ALTER TABLE ONLY public.actors ALTER COLUMN id SET DEFAULT nextval('public.actors_id_seq'::regclass);


--
-- Name: admin_permissions id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_permissions ALTER COLUMN id SET DEFAULT nextval('public.admin_permissions_id_seq'::regclass);


--
-- Name: agent_api_keys id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_api_keys ALTER COLUMN id SET DEFAULT nextval('public.agent_api_keys_id_seq'::regclass);


--
-- Name: chat_messages id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chat_message_texts ALTER COLUMN id SET DEFAULT nextval('public.chat_message_texts_id_seq'::regclass);

ALTER TABLE ONLY public.chat_messages ALTER COLUMN id SET DEFAULT nextval('public.chat_messages_id_seq'::regclass);


--
-- Name: discussion_votes id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_votes ALTER COLUMN id SET DEFAULT nextval('public.discussion_votes_id_seq'::regclass);


--
-- Name: discussions id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussions ALTER COLUMN id SET DEFAULT nextval('public.discussions_id_seq'::regclass);


--
-- Name: documents id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documents ALTER COLUMN id SET DEFAULT nextval('public.documents_id_seq'::regclass);


--
-- Name: error_log id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.error_log ALTER COLUMN id SET DEFAULT nextval('public.error_log_id_seq'::regclass);


--
-- Name: memory_chunks id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.memory_chunks ALTER COLUMN id SET DEFAULT nextval('public.chunks_id_seq'::regclass);


--
-- Name: namespace_permissions id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.namespace_permissions ALTER COLUMN id SET DEFAULT nextval('public.namespace_permissions_id_seq'::regclass);


--
-- Name: permissions id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass);


--
-- Name: request_log id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.request_log ALTER COLUMN id SET DEFAULT nextval('public.request_log_id_seq'::regclass);


--
-- Name: system_errors id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.system_errors ALTER COLUMN id SET DEFAULT nextval('public.system_errors_id_seq'::regclass);


--
-- Name: templates id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.templates ALTER COLUMN id SET DEFAULT nextval('public.welcome_templates_id_seq'::regclass);


--
-- Name: virtual_agent_usage id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.virtual_agent_usage ALTER COLUMN id SET DEFAULT nextval('public.virtual_agent_usage_id_seq'::regclass);


--
-- Name: actor_visibility_configuration actor_visibility_configuration_actor_id_target_actor_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.actor_visibility_configuration
    ADD CONSTRAINT actor_visibility_configuration_actor_id_target_actor_id_key UNIQUE (actor_id, target_actor_id);


--
-- Name: actor_visibility_configuration actor_visibility_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.actor_visibility_configuration
    ADD CONSTRAINT actor_visibility_configuration_pkey PRIMARY KEY (id);


--
-- Name: actors actors_name_key; Type: CONSTRAINT; Schema: public; Owner: memory_api
--

ALTER TABLE ONLY public.actors
    ADD CONSTRAINT actors_name_key UNIQUE (name);


--
-- Name: actors actors_pkey; Type: CONSTRAINT; Schema: public; Owner: memory_api
--

ALTER TABLE ONLY public.actors
    ADD CONSTRAINT actors_pkey PRIMARY KEY (id);


--
-- Name: admin_permissions admin_permissions_actor_id_resource_action_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_permissions
    ADD CONSTRAINT admin_permissions_actor_id_resource_action_key UNIQUE (actor_id, resource, action);


--
-- Name: admin_permissions admin_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_permissions
    ADD CONSTRAINT admin_permissions_pkey PRIMARY KEY (id);


--
-- Name: agent_api_keys agent_api_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_api_keys
    ADD CONSTRAINT agent_api_keys_pkey PRIMARY KEY (id);


--
-- Name: agent_configuration agent_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_configuration
    ADD CONSTRAINT agent_configuration_pkey PRIMARY KEY (actor_id);


--
-- Name: agent_permissions agent_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_permissions
    ADD CONSTRAINT agent_permissions_pkey PRIMARY KEY (actor_id, permission_id);


--
-- Name: chat_messages chat_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chat_messages
    ADD CONSTRAINT chat_messages_pkey PRIMARY KEY (id);


--
-- Name: memory_chunks chunks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.memory_chunks
    ADD CONSTRAINT chunks_pkey PRIMARY KEY (id);


--
-- Name: config config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.config
    ADD CONSTRAINT config_pkey PRIMARY KEY (key);


--
-- Name: discussion_ballots discussion_ballots_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_ballots
    ADD CONSTRAINT discussion_ballots_pkey PRIMARY KEY (vote_id, actor_id);


--
-- Name: discussion_participants discussion_participants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_participants
    ADD CONSTRAINT discussion_participants_pkey PRIMARY KEY (discussion_id, actor_id);


--
-- Name: discussion_votes discussion_votes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_votes
    ADD CONSTRAINT discussion_votes_pkey PRIMARY KEY (id);


--
-- Name: discussions discussions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussions
    ADD CONSTRAINT discussions_pkey PRIMARY KEY (id);


--
-- Name: documents documents_namespace_slug_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documents
    ADD CONSTRAINT documents_namespace_slug_key UNIQUE (namespace, slug);


--
-- Name: documents documents_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documents
    ADD CONSTRAINT documents_pkey PRIMARY KEY (id);


--
-- Name: error_log error_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.error_log
    ADD CONSTRAINT error_log_pkey PRIMARY KEY (id);


--
-- Name: mail mail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mail
    ADD CONSTRAINT mail_pkey PRIMARY KEY (id);


--
-- Name: mcp_sessions mcp_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mcp_sessions
    ADD CONSTRAINT mcp_sessions_pkey PRIMARY KEY (session_id);


--
-- Name: migrations_applied migrations_applied_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations_applied
    ADD CONSTRAINT migrations_applied_pkey PRIMARY KEY (migration_id);


--
-- Name: namespace_permissions namespace_permissions_actor_id_namespace_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.namespace_permissions
    ADD CONSTRAINT namespace_permissions_actor_id_namespace_key UNIQUE (actor_id, namespace);


--
-- Name: namespace_permissions namespace_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.namespace_permissions
    ADD CONSTRAINT namespace_permissions_pkey PRIMARY KEY (id);


--
-- Name: permissions permissions_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_key UNIQUE (name);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: request_log request_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.request_log
    ADD CONSTRAINT request_log_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: system_errors system_errors_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.system_errors
    ADD CONSTRAINT system_errors_pkey PRIMARY KEY (id);


--
-- Name: agent_configuration uq_agent_configuration_actor_id; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_configuration
    ADD CONSTRAINT uq_agent_configuration_actor_id UNIQUE (actor_id);


--
-- Name: virtual_agent_usage virtual_agent_usage_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.virtual_agent_usage
    ADD CONSTRAINT virtual_agent_usage_pkey PRIMARY KEY (id);


--
-- Name: templates welcome_templates_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.templates
    ADD CONSTRAINT welcome_templates_name_key UNIQUE (name);


--
-- Name: templates welcome_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.templates
    ADD CONSTRAINT welcome_templates_pkey PRIMARY KEY (id);


--
-- Name: idx_agent_api_keys_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_agent_api_keys_actor ON public.agent_api_keys USING btree (actor_id);


--
-- Name: idx_avc_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_avc_actor ON public.actor_visibility_configuration USING btree (actor_id);


--
-- Name: idx_avc_target; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_avc_target ON public.actor_visibility_configuration USING btree (target_actor_id);


--
-- Name: idx_avc_wildcard; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX idx_avc_wildcard ON public.actor_visibility_configuration USING btree (actor_id) WHERE (target_actor_id IS NULL);


--
-- Name: idx_chat_messages_to_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_cmt_discussion ON public.chat_message_texts USING btree (discussion_id) WHERE (discussion_id IS NOT NULL);
CREATE INDEX idx_cmt_from_actor ON public.chat_message_texts USING btree (from_actor_id);
CREATE INDEX idx_cmt_sent_at ON public.chat_message_texts USING btree (sent_at);

CREATE INDEX idx_chat_messages_to_actor ON public.chat_messages USING btree (to_actor_id, id);
CREATE INDEX idx_cm_message_text ON public.chat_messages USING btree (message_text_id);

--
-- Name: idx_chat_messages_unacked; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_chat_messages_unacked ON public.chat_messages USING btree (to_actor_id) WHERE (acked_at IS NULL);


--
-- Name: idx_chunks_embedding; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_chunks_embedding ON public.memory_chunks USING ivfflat (embedding public.vector_cosine_ops) WITH (lists='100');


--
-- Name: idx_chunks_namespace_source; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_chunks_namespace_source ON public.memory_chunks USING btree (namespace, source_file);


--
-- Name: idx_discussion_participants_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_discussion_participants_actor ON public.discussion_participants USING btree (actor_id, status);


--
-- Name: idx_discussion_votes_discussion; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_discussion_votes_discussion ON public.discussion_votes USING btree (discussion_id, status);


--
-- Name: idx_discussions_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_discussions_status ON public.discussions USING btree (status);


--
-- Name: idx_documents_namespace; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_documents_namespace ON public.documents USING btree (namespace);


--
-- Name: idx_error_log_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_error_log_actor ON public.error_log USING btree (actor_id) WHERE (actor_id IS NOT NULL);


--
-- Name: idx_error_log_created; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_error_log_created ON public.error_log USING btree (created_at DESC);


--
-- Name: idx_error_log_subsystem; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_error_log_subsystem ON public.error_log USING btree (subsystem);


--
-- Name: idx_mail_to_actor_acked; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mail_to_actor_acked ON public.mail USING btree (to_actor_id, acked_at);


--
-- Name: idx_mcp_sessions_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mcp_sessions_actor ON public.mcp_sessions USING btree (actor_id);


--
-- Name: idx_ns_perm_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ns_perm_actor ON public.namespace_permissions USING btree (actor_id);


--
-- Name: idx_ns_perm_namespace; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_ns_perm_namespace ON public.namespace_permissions USING btree (namespace);


--
-- Name: idx_request_log_timestamp; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_request_log_timestamp ON public.request_log USING btree ("timestamp");


--
-- Name: idx_sessions_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_sessions_actor ON public.sessions USING btree (actor_id);


--
-- Name: idx_sessions_expires; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_sessions_expires ON public.sessions USING btree (expires_at);


--
-- Name: idx_system_errors_actor; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_system_errors_actor ON public.system_errors USING btree (actor_id) WHERE (actor_id IS NOT NULL);


--
-- Name: idx_system_errors_error_code; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_system_errors_error_code ON public.system_errors USING btree (error_code);


--
-- Name: idx_system_errors_status; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_system_errors_status ON public.system_errors USING btree (status);


--
-- Name: idx_va_usage_actor_date; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_va_usage_actor_date ON public.virtual_agent_usage USING btree (actor_id, created_at);


--
-- Name: actor_visibility_configuration actor_visibility_configuration_actor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.actor_visibility_configuration
    ADD CONSTRAINT actor_visibility_configuration_actor_id_fkey FOREIGN KEY (actor_id) REFERENCES public.actors(id) ON DELETE CASCADE;


--
-- Name: actor_visibility_configuration actor_visibility_configuration_target_actor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.actor_visibility_configuration
    ADD CONSTRAINT actor_visibility_configuration_target_actor_id_fkey FOREIGN KEY (target_actor_id) REFERENCES public.actors(id) ON DELETE CASCADE;


--
-- Name: admin_permissions admin_permissions_actor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_permissions
    ADD CONSTRAINT admin_permissions_actor_id_fkey FOREIGN KEY (actor_id) REFERENCES public.actors(id) ON DELETE CASCADE;


--
-- Name: agent_permissions agent_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_permissions
    ADD CONSTRAINT agent_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES public.permissions(id);


--
-- Name: discussion_ballots discussion_ballots_vote_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_ballots
    ADD CONSTRAINT discussion_ballots_vote_id_fkey FOREIGN KEY (vote_id) REFERENCES public.discussion_votes(id);


--
-- Name: discussion_participants discussion_participants_discussion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_participants
    ADD CONSTRAINT discussion_participants_discussion_id_fkey FOREIGN KEY (discussion_id) REFERENCES public.discussions(id);


--
-- Name: discussion_votes discussion_votes_discussion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_votes
    ADD CONSTRAINT discussion_votes_discussion_id_fkey FOREIGN KEY (discussion_id) REFERENCES public.discussions(id);


--
-- Name: agent_api_keys fk_aak_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_api_keys
    ADD CONSTRAINT fk_aak_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: agent_configuration fk_agent_configuration_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_configuration
    ADD CONSTRAINT fk_agent_configuration_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: agent_permissions fk_ap_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agent_permissions
    ADD CONSTRAINT fk_ap_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: chat_messages fk_chat_from_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chat_message_texts
    ADD CONSTRAINT fk_cmt_from_actor FOREIGN KEY (from_actor_id) REFERENCES public.actors(id);

ALTER TABLE ONLY public.chat_message_texts
    ADD CONSTRAINT fk_cmt_discussion FOREIGN KEY (discussion_id) REFERENCES public.discussions(id);

ALTER TABLE ONLY public.chat_messages
    ADD CONSTRAINT fk_cm_message_text FOREIGN KEY (message_text_id) REFERENCES public.chat_message_texts(id);

--
-- Name: chat_messages fk_chat_to_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.chat_messages
    ADD CONSTRAINT fk_chat_to_actor FOREIGN KEY (to_actor_id) REFERENCES public.actors(id);


--
-- Name: discussion_ballots fk_db_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_ballots
    ADD CONSTRAINT fk_db_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: discussions fk_discussions_created_by; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussions
    ADD CONSTRAINT fk_discussions_created_by FOREIGN KEY (created_by_actor_id) REFERENCES public.actors(id);


--
-- Name: documents fk_docs_created_by; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.documents
    ADD CONSTRAINT fk_docs_created_by FOREIGN KEY (created_by_actor_id) REFERENCES public.actors(id);


--
-- Name: discussion_participants fk_dp_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_participants
    ADD CONSTRAINT fk_dp_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: discussion_votes fk_dv_proposed_by; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.discussion_votes
    ADD CONSTRAINT fk_dv_proposed_by FOREIGN KEY (proposed_by_actor_id) REFERENCES public.actors(id);


--
-- Name: mail fk_mail_from_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mail
    ADD CONSTRAINT fk_mail_from_actor FOREIGN KEY (from_actor_id) REFERENCES public.actors(id);


--
-- Name: mail fk_mail_to_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mail
    ADD CONSTRAINT fk_mail_to_actor FOREIGN KEY (to_actor_id) REFERENCES public.actors(id);


--
-- Name: mcp_sessions fk_mcp_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mcp_sessions
    ADD CONSTRAINT fk_mcp_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: virtual_agent_usage fk_vau_actor; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.virtual_agent_usage
    ADD CONSTRAINT fk_vau_actor FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: namespace_permissions namespace_permissions_actor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.namespace_permissions
    ADD CONSTRAINT namespace_permissions_actor_id_fkey FOREIGN KEY (actor_id) REFERENCES public.actors(id) ON DELETE CASCADE;


--
-- Name: sessions sessions_actor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_actor_id_fkey FOREIGN KEY (actor_id) REFERENCES public.actors(id);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: pg_database_owner
--

GRANT USAGE ON SCHEMA public TO claude;


--
-- Name: TABLE actor_visibility_configuration; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.actor_visibility_configuration TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.actor_visibility_configuration TO claude;


--
-- Name: SEQUENCE actor_visibility_configuration_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.actor_visibility_configuration_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.actor_visibility_configuration_id_seq TO claude;


--
-- Name: TABLE actors; Type: ACL; Schema: public; Owner: memory_api
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.actors TO claude;


--
-- Name: SEQUENCE actors_id_seq; Type: ACL; Schema: public; Owner: memory_api
--

GRANT SELECT,USAGE ON SEQUENCE public.actors_id_seq TO claude;


--
-- Name: TABLE admin_permissions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.admin_permissions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.admin_permissions TO claude;


--
-- Name: SEQUENCE admin_permissions_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.admin_permissions_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.admin_permissions_id_seq TO claude;


--
-- Name: TABLE agent_api_keys; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.agent_api_keys TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.agent_api_keys TO claude;


--
-- Name: SEQUENCE agent_api_keys_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.agent_api_keys_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.agent_api_keys_id_seq TO claude;


--
-- Name: TABLE agent_configuration; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.agent_configuration TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.agent_configuration TO claude;


--
-- Name: TABLE agent_permissions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.agent_permissions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.agent_permissions TO claude;


--
-- Name: TABLE agent_status; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.agent_status TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.agent_status TO claude;


--
-- Name: TABLE chat_messages; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.chat_message_texts TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.chat_message_texts TO claude;

GRANT ALL ON SEQUENCE public.chat_message_texts_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.chat_message_texts_id_seq TO claude;

GRANT ALL ON TABLE public.chat_messages TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.chat_messages TO claude;


--
-- Name: SEQUENCE chat_messages_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.chat_messages_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.chat_messages_id_seq TO claude;


--
-- Name: TABLE memory_chunks; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.memory_chunks TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.memory_chunks TO claude;


--
-- Name: SEQUENCE chunks_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.chunks_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.chunks_id_seq TO claude;


--
-- Name: TABLE config; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.config TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.config TO claude;


--
-- Name: TABLE discussion_ballots; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.discussion_ballots TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.discussion_ballots TO claude;


--
-- Name: TABLE discussion_participants; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.discussion_participants TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.discussion_participants TO claude;


--
-- Name: TABLE discussion_votes; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.discussion_votes TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.discussion_votes TO claude;


--
-- Name: SEQUENCE discussion_votes_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.discussion_votes_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.discussion_votes_id_seq TO claude;


--
-- Name: TABLE discussions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.discussions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.discussions TO claude;


--
-- Name: SEQUENCE discussions_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.discussions_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.discussions_id_seq TO claude;


--
-- Name: TABLE documents; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.documents TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.documents TO claude;


--
-- Name: SEQUENCE documents_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.documents_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.documents_id_seq TO claude;


--
-- Name: TABLE error_log; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.error_log TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.error_log TO claude;


--
-- Name: SEQUENCE error_log_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.error_log_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.error_log_id_seq TO claude;


--
-- Name: TABLE mail; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.mail TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.mail TO claude;


--
-- Name: TABLE mcp_sessions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.mcp_sessions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.mcp_sessions TO claude;


--
-- Name: TABLE migrations_applied; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.migrations_applied TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.migrations_applied TO claude;


--
-- Name: TABLE namespace_permissions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.namespace_permissions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.namespace_permissions TO claude;


--
-- Name: SEQUENCE namespace_permissions_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.namespace_permissions_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.namespace_permissions_id_seq TO claude;


--
-- Name: TABLE permissions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.permissions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.permissions TO claude;


--
-- Name: SEQUENCE permissions_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.permissions_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.permissions_id_seq TO claude;


--
-- Name: TABLE request_log; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.request_log TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.request_log TO claude;


--
-- Name: SEQUENCE request_log_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.request_log_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.request_log_id_seq TO claude;


--
-- Name: TABLE sessions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.sessions TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.sessions TO claude;


--
-- Name: TABLE system_errors; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.system_errors TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.system_errors TO claude;


--
-- Name: SEQUENCE system_errors_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.system_errors_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.system_errors_id_seq TO claude;


--
-- Name: TABLE templates; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.templates TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.templates TO claude;


--
-- Name: TABLE virtual_agent_usage; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.virtual_agent_usage TO memory_api;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.virtual_agent_usage TO claude;


--
-- Name: SEQUENCE virtual_agent_usage_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.virtual_agent_usage_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.virtual_agent_usage_id_seq TO claude;


--
-- Name: SEQUENCE welcome_templates_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.welcome_templates_id_seq TO memory_api;
GRANT SELECT,USAGE ON SEQUENCE public.welcome_templates_id_seq TO claude;


--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT ALL ON SEQUENCES TO memory_api;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT,USAGE ON SEQUENCES TO claude;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT ALL ON TABLES TO memory_api;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT,INSERT,DELETE,UPDATE ON TABLES TO claude;


--
-- PostgreSQL database dump complete
--

\unrestrict kAaEjsPWLLEcViniWnrQZu7LrzsULDle34hUHzdBk5twSi0Sd3NsjVeLWJhhZoe