myheats

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

05-settings.sql (401B)

      1 CREATE TABLE public.settings (
      2     id bigint NOT NULL,
      3     name text NOT NULL,
      4     value text NOT NULL
      5 );
      6 
      7 ALTER TABLE public.settings ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
      8     SEQUENCE NAME public.settings_id_seq
      9     START WITH 1
     10     INCREMENT BY 1
     11     NO MINVALUE
     12     NO MAXVALUE
     13     CACHE 1
     14 );
     15 
     16 ALTER TABLE ONLY public.settings
     17     ADD CONSTRAINT settings_pkey PRIMARY KEY (name);