myheats

Live heats, scoring and leaderboard for sport events
git clone https://git.in0rdr.ch/myheats.git
Log | Files | Refs | Pull requests | README | LICENSE

02-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);