111 lines
3.2 KiB
MySQL
111 lines
3.2 KiB
MySQL
|
-- 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
|
||
|
|
||
|
|