judges.sql (1692B)
1 -- 2 -- PostgreSQL database dump 3 -- 4 5 -- Dumped from database version 15.1 6 -- Dumped by pg_dump version 15.3 7 8 SET statement_timeout = 0; 9 SET lock_timeout = 0; 10 SET idle_in_transaction_session_timeout = 0; 11 SET client_encoding = 'UTF8'; 12 SET standard_conforming_strings = on; 13 SELECT pg_catalog.set_config('search_path', '', false); 14 SET check_function_bodies = false; 15 SET xmloption = content; 16 SET client_min_messages = warning; 17 SET row_security = off; 18 19 SET default_tablespace = ''; 20 21 SET default_table_access_method = heap; 22 23 -- 24 -- Name: judges; Type: TABLE; Schema: public; Owner: postgres 25 -- 26 27 CREATE TABLE public.judges ( 28 id uuid NOT NULL, 29 created_at timestamp with time zone DEFAULT now(), 30 firstname text, 31 lastname text 32 ); 33 34 35 ALTER TABLE public.judges OWNER TO postgres; 36 37 -- 38 -- Name: TABLE judges; Type: COMMENT; Schema: public; Owner: postgres 39 -- 40 41 COMMENT ON TABLE public.judges IS 'List of judges'; 42 43 44 -- 45 -- Name: judges judges_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres 46 -- 47 48 ALTER TABLE ONLY public.judges 49 ADD CONSTRAINT judges_pkey PRIMARY KEY (id); 50 51 52 -- 53 -- Name: judges judges_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres 54 -- 55 56 ALTER TABLE ONLY public.judges 57 ADD CONSTRAINT judges_id_fkey FOREIGN KEY (id) REFERENCES auth.users(id) ON DELETE CASCADE; 58 59 60 -- 61 -- Name: judges; Type: ROW SECURITY; Schema: public; Owner: postgres 62 -- 63 64 ALTER TABLE public.judges ENABLE ROW LEVEL SECURITY; 65 66 -- 67 -- Name: TABLE judges; Type: ACL; Schema: public; Owner: postgres 68 -- 69 70 GRANT ALL ON TABLE public.judges TO anon; 71 GRANT ALL ON TABLE public.judges TO authenticated; 72 GRANT ALL ON TABLE public.judges TO service_role; 73 74 75 -- 76 -- PostgreSQL database dump complete 77 -- 78