-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_tables.sql
36 lines (32 loc) · 1.17 KB
/
create_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
CREATE TABLE public.users
(
id bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
username character varying(255) COLLATE pg_catalog."default",
password character varying(255) COLLATE pg_catalog."default",
CONSTRAINT users_pkey PRIMARY KEY (id)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.users
OWNER to api_restful;
CREATE TABLE public.user_authorizations
(
id bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
type character varying(255) COLLATE pg_catalog."default",
user_id bigint,
CONSTRAINT user_authorizations_pkey PRIMARY KEY (id),
CONSTRAINT fkgek2c3qxjc3g29pk0gaqkythi FOREIGN KEY (user_id)
REFERENCES public.users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.user_authorizations
OWNER to api_restful;
\COPY public.users FROM './csv/users.csv' DELIMITER ';' CSV HEADER;
\COPY public.user_authorizations FROM './csv/user_authorizations.csv' DELIMITER ';' CSV HEADER;