CREATE TABLE group_has_users (
    group_id integer DEFAULT 0 NOT NULL,
    users_id integer NOT NULL
);


ALTER TABLE public.group_has_users OWNER TO postgres;
ALTER TABLE ONLY group_has_users
    ADD CONSTRAINT group_has_users_pkey PRIMARY KEY (group_id, users_id);

CREATE INDEX fk_group_has_users_group1 ON group_has_users USING btree (group_id);

CREATE INDEX fk_group_has_users_users1 ON group_has_users USING btree (users_id);

ALTER TABLE ONLY group_has_users
    ADD CONSTRAINT group_has_users_group_id_fkey FOREIGN KEY (group_id) REFERENCES "group"(id) ON DELETE CASCADE;

ALTER TABLE ONLY group_has_users
    ADD CONSTRAINT group_has_users_users_id_fkey FOREIGN KEY (users_id) REFERENCES users(id) ON DELETE CASCADE;

undefined table: 7 ERROR:  relation "group_has_users_id_seq" does not exist
LINE 1: SELECT CURRVAL('group_has_users_id_seq')