📦 EqualifyEverything / equalify

📄 add_blocker_llm_summaries.sql · 15 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15CREATE TABLE public.blocker_llm_summaries (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    blocker_id uuid NOT NULL,
    summary text NOT NULL,
    flagged boolean DEFAULT false NOT NULL,
    created_at timestamp with time zone DEFAULT now() NOT NULL,
    updated_at timestamp with time zone DEFAULT now() NOT NULL,
    PRIMARY KEY (id),
    UNIQUE (blocker_id)
);

CREATE TRIGGER set_public_blocker_llm_summaries_updated_at
    BEFORE UPDATE ON public.blocker_llm_summaries
    FOR EACH ROW EXECUTE FUNCTION public.set_current_timestamp_updated_at();