judges.sql (521B)
1 CREATE TABLE public.judges ( 2 id bigint NOT NULL, 3 created_at timestamp with time zone DEFAULT now(), 4 email text, 5 token text, 6 expires_at timestamp with time zone DEFAULT now(), 7 firstname text, 8 lastname text 9 ); 10 11 ALTER TABLE public.judges ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( 12 SEQUENCE NAME public.judges_id_seq 13 START WITH 1 14 INCREMENT BY 1 15 NO MINVALUE 16 NO MAXVALUE 17 CACHE 1 18 ); 19 20 ALTER TABLE ONLY public.judges 21 ADD CONSTRAINT judges_pkey PRIMARY KEY (id);