111 lines
3.2 KiB
SQL
111 lines
3.2 KiB
SQL
-- table:projects
|
|
CREATE TABLE public.projects (
|
|
id integer NOT NULL,
|
|
data json NOT NULL,
|
|
created_at date DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
deleted_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
is_deleted boolean DEFAULT false NOT NULL
|
|
);
|
|
ALTER TABLE public.projects OWNER TO postgres;
|
|
ALTER TABLE public.projects ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
|
SEQUENCE NAME public.projects_id_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1
|
|
);
|
|
SELECT pg_catalog.setval('public.projects_id_seq', 1, false);
|
|
-- /table:projects
|
|
|
|
|
|
-- table:bookmarks
|
|
CREATE TABLE public.bookmarks (
|
|
id integer NOT NULL,
|
|
data json NOT NULL,
|
|
created_at date DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
deleted_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
is_deleted boolean DEFAULT false NOT NULL
|
|
);
|
|
ALTER TABLE public.bookmarks OWNER TO postgres;
|
|
ALTER TABLE public.bookmarks ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
|
SEQUENCE NAME public.bookmarks_id_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1
|
|
);
|
|
SELECT pg_catalog.setval('public.bookmarks_id_seq', 1, false);
|
|
-- /table:bookmarks
|
|
|
|
|
|
-- table:notes
|
|
CREATE TABLE public.notes (
|
|
id integer NOT NULL,
|
|
data json NOT NULL,
|
|
created_at date DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
deleted_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
is_deleted boolean DEFAULT false NOT NULL
|
|
);
|
|
ALTER TABLE public.notes OWNER TO postgres;
|
|
ALTER TABLE public.notes ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
|
SEQUENCE NAME public.notes_id_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1
|
|
);
|
|
SELECT pg_catalog.setval('public.notes_id_seq', 1, false);
|
|
-- /table:notes
|
|
|
|
|
|
-- table:contacts
|
|
CREATE TABLE public.contacts (
|
|
id integer NOT NULL,
|
|
data json NOT NULL,
|
|
created_at date DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
deleted_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
is_deleted boolean DEFAULT false NOT NULL
|
|
);
|
|
ALTER TABLE public.contacts OWNER TO postgres;
|
|
ALTER TABLE public.contacts ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
|
SEQUENCE NAME public.contacts_id_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1
|
|
);
|
|
SELECT pg_catalog.setval('public.contacts_id_seq', 1, false);
|
|
-- /table:contacts
|
|
|
|
|
|
-- table:collections
|
|
CREATE TABLE public.collections (
|
|
id integer NOT NULL,
|
|
data json NOT NULL,
|
|
created_at date DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
updated_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
deleted_at date DEFAULT '0001-01-01'::date NOT NULL,
|
|
is_deleted boolean DEFAULT false NOT NULL
|
|
);
|
|
ALTER TABLE public.collections OWNER TO postgres;
|
|
ALTER TABLE public.collections ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
|
SEQUENCE NAME public.collections_id_seq
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1
|
|
);
|
|
SELECT pg_catalog.setval('public.collections_id_seq', 1, false);
|
|
-- /table:collections
|
|
|
|
|