| -- |
| -- PostgreSQL database dump |
| -- |
| |
| -- Dumped from database version 13.3 (Debian 13.3-1.pgdg100+1) |
| -- Dumped by pg_dump version 13.3 (Debian 13.3-1.pgdg100+1) |
| |
| SET statement_timeout = 0; |
| SET lock_timeout = 0; |
| SET idle_in_transaction_session_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; |
| |
| SET default_tablespace = ''; |
| |
| SET default_table_access_method = heap; |
| |
| -- |
| -- Name: migrations; Type: TABLE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE TABLE public.migrations ( |
| version bigint NOT NULL, |
| dirty boolean NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.migrations OWNER TO postgres; |
| |
| -- |
| -- Name: tasks; Type: TABLE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE TABLE public.tasks ( |
| workflow_id uuid NOT NULL, |
| name text NOT NULL, |
| finished boolean DEFAULT false NOT NULL, |
| result jsonb, |
| error text, |
| created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
| updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.tasks OWNER TO postgres; |
| |
| -- |
| -- Name: workflows; Type: TABLE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE TABLE public.workflows ( |
| id uuid NOT NULL, |
| params jsonb, |
| name text, |
| created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
| updated_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.workflows OWNER TO postgres; |
| |
| -- |
| -- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY public.migrations |
| ADD CONSTRAINT migrations_pkey PRIMARY KEY (version); |
| |
| |
| -- |
| -- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY public.tasks |
| ADD CONSTRAINT tasks_pkey PRIMARY KEY (workflow_id, name); |
| |
| |
| -- |
| -- Name: workflows workflows_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY public.workflows |
| ADD CONSTRAINT workflows_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: tasks tasks_workflow_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY public.tasks |
| ADD CONSTRAINT tasks_workflow_id_fkey FOREIGN KEY (workflow_id) REFERENCES public.workflows(id); |
| |
| |
| -- |
| -- PostgreSQL database dump complete |
| -- |
| |