3
ALTER SCHEMA admin OWNER TO postgres;
5
SET search_path = admin, pg_catalog;
7
CREATE TABLE acl_role (
11
ALTER TABLE admin.acl_role OWNER TO postgres;
13
ALTER TABLE ONLY acl_role
14
ADD CONSTRAINT acl_role_pkey PRIMARY KEY (id);
18
email character varying(255) NOT NULL,
19
name character varying(255) NOT NULL,
20
password character varying(40) NOT NULL,
21
is_active boolean DEFAULT false NOT NULL,
22
updated timestamp without time zone DEFAULT now() NOT NULL,
23
created timestamp without time zone DEFAULT now() NOT NULL,
24
role_id bigint NOT NULL,
25
last_visit timestamp without time zone DEFAULT now() NOT NULL
28
ALTER TABLE admin."user" OWNER TO postgres;
30
CREATE INDEX fki_user_role_id_fkey ON "user" USING btree (role_id);
32
ALTER TABLE ONLY "user"
33
ADD CONSTRAINT user_role_id_fkey FOREIGN KEY (role_id) REFERENCES acl_role(id);
b'\\ No newline at end of file'