create.sql
1 create table public.home_entries ( 2 id bigint generated by default as identity not null, 3 "order" numeric not null, 4 title text null, 5 image_url text null, 6 content json null, 7 constraint home_entries_pkey primary key (id), 8 constraint home_entries_order_key unique ("order") 9 ) TABLESPACE pg_default; 10 11 create table public.agents ( 12 id bigint generated by default as identity not null, 13 "order" numeric not null, 14 image_url text null, 15 name text not null, 16 content text[] null, 17 links json[] null, 18 description text null, 19 constraint agents_pkey primary key (id), 20 constraint agents_order_key unique ("order") 21 ) TABLESPACE pg_default; 22 23 create table public.partners ( 24 id bigint generated by default as identity not null, 25 title text not null, 26 description text null, 27 image_url text null, 28 constraint partners_pkey primary key (id), 29 constraint partners_title_key unique (title) 30 ) TABLESPACE pg_default;