--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


SET SESSION AUTHORIZATION 'badboy';

SET search_path = public, pg_catalog;

--
-- TOC entry 5 (OID 25623)
-- Name: users_u_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE users_u_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 6 (OID 25623)
-- Name: users_u_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users_u_id_seq FROM PUBLIC;
GRANT ALL ON TABLE users_u_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 17 (OID 25625)
-- Name: users; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE users (
    u_id integer DEFAULT nextval('"users_u_id_seq"'::text) NOT NULL,
    u_username text DEFAULT ''::text NOT NULL,
    u_name text DEFAULT ''::text NOT NULL,
    u_wwc_id text DEFAULT ''::text NOT NULL,
    u_code text DEFAULT ''::text NOT NULL,
    u_disabled boolean DEFAULT false NOT NULL,
    u_deleted boolean DEFAULT false NOT NULL,
    u_created timestamp without time zone DEFAULT now() NOT NULL,
    u_expires timestamp without time zone,
    u_password text,
    u_lastlogin timestamp without time zone
);


--
-- TOC entry 18 (OID 25625)
-- Name: users; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users FROM PUBLIC;
GRANT ALL ON TABLE users TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 7 (OID 25638)
-- Name: groups_g_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE groups_g_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 8 (OID 25638)
-- Name: groups_g_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE groups_g_id_seq FROM PUBLIC;
GRANT ALL ON TABLE groups_g_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 19 (OID 25640)
-- Name: groups; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE groups (
    g_id integer DEFAULT nextval('"groups_g_id_seq"'::text) NOT NULL,
    g_name text DEFAULT ''::text NOT NULL,
    g_descr text DEFAULT ''::text NOT NULL,
    g_disabled boolean DEFAULT false NOT NULL,
    g_deleted boolean DEFAULT false NOT NULL,
    g_can_openmode boolean DEFAULT false NOT NULL
);


--
-- TOC entry 20 (OID 25640)
-- Name: groups; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE groups FROM PUBLIC;
GRANT ALL ON TABLE groups TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 9 (OID 25651)
-- Name: users_groups_map_ugm_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE users_groups_map_ugm_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 10 (OID 25651)
-- Name: users_groups_map_ugm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users_groups_map_ugm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE users_groups_map_ugm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 21 (OID 25653)
-- Name: users_groups_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE users_groups_map (
    ugm_id integer DEFAULT nextval('"users_groups_map_ugm_id_seq"'::text) NOT NULL,
    ugm_u_id integer,
    ugm_g_id integer
);


--
-- TOC entry 22 (OID 25653)
-- Name: users_groups_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users_groups_map FROM PUBLIC;
GRANT ALL ON TABLE users_groups_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 11 (OID 25656)
-- Name: doors_d_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE doors_d_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 12 (OID 25656)
-- Name: doors_d_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE doors_d_id_seq FROM PUBLIC;
GRANT ALL ON TABLE doors_d_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 23 (OID 25658)
-- Name: doors; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE doors (
    d_id integer DEFAULT nextval('"doors_d_id_seq"'::text) NOT NULL,
    d_name text DEFAULT ''::text NOT NULL,
    d_code character varying(7) DEFAULT ''::character varying NOT NULL,
    d_disabled boolean DEFAULT false NOT NULL,
    d_deleted boolean DEFAULT false NOT NULL
);


--
-- TOC entry 24 (OID 25658)
-- Name: doors; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE doors FROM PUBLIC;
GRANT ALL ON TABLE doors TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 13 (OID 25668)
-- Name: users_doors_map_udm_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE users_doors_map_udm_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 14 (OID 25668)
-- Name: users_doors_map_udm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users_doors_map_udm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE users_doors_map_udm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 25 (OID 25670)
-- Name: users_doors_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE users_doors_map (
    udm_id integer DEFAULT nextval('"users_doors_map_udm_id_seq"'::text) NOT NULL,
    udm_u_id integer,
    udm_d_id integer
);


--
-- TOC entry 26 (OID 25670)
-- Name: users_doors_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE users_doors_map FROM PUBLIC;
GRANT ALL ON TABLE users_doors_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 15 (OID 25673)
-- Name: groups_doors_map_gdm_id_seq; Type: SEQUENCE; Schema: public; Owner: badboy
--

CREATE SEQUENCE groups_doors_map_gdm_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- TOC entry 16 (OID 25673)
-- Name: groups_doors_map_gdm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE groups_doors_map_gdm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE groups_doors_map_gdm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 27 (OID 25675)
-- Name: groups_doors_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE groups_doors_map (
    gdm_id integer DEFAULT nextval('"groups_doors_map_gdm_id_seq"'::text) NOT NULL,
    gdm_g_id integer,
    gdm_d_id integer
);


--
-- TOC entry 28 (OID 25675)
-- Name: groups_doors_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE groups_doors_map FROM PUBLIC;
GRANT ALL ON TABLE groups_doors_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 29 (OID 25680)
-- Name: one_time_events; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE one_time_events (
    ote_id serial NOT NULL,
    ote_descr text DEFAULT ''::text NOT NULL,
    ote_begin timestamp without time zone NOT NULL,
    ote_end timestamp without time zone NOT NULL
);


--
-- TOC entry 30 (OID 25680)
-- Name: one_time_events; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE one_time_events FROM PUBLIC;
GRANT ALL ON TABLE one_time_events TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 51 (OID 25680)
-- Name: one_time_events_ote_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE one_time_events_ote_id_seq FROM PUBLIC;
GRANT ALL ON TABLE one_time_events_ote_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 31 (OID 25689)
-- Name: one_time_events_doors_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE one_time_events_doors_map (
    otedm_id serial NOT NULL,
    otedm_ote_id integer,
    otedm_d_id integer
);


--
-- TOC entry 32 (OID 25689)
-- Name: one_time_events_doors_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE one_time_events_doors_map FROM PUBLIC;
GRANT ALL ON TABLE one_time_events_doors_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 52 (OID 25689)
-- Name: one_time_events_doors_map_otedm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE one_time_events_doors_map_otedm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE one_time_events_doors_map_otedm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 33 (OID 25694)
-- Name: weekly_events_dates; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE weekly_events_dates (
    wed_id serial NOT NULL,
    wed_we_id integer,
    wed_begin date NOT NULL,
    wed_end date NOT NULL
);


--
-- TOC entry 34 (OID 25694)
-- Name: weekly_events_dates; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_dates FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_dates TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 53 (OID 25694)
-- Name: weekly_events_dates_wed_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_dates_wed_id_seq FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_dates_wed_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 35 (OID 25699)
-- Name: weekly_events_doors_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE weekly_events_doors_map (
    wedm_id serial NOT NULL,
    wedm_we_id integer,
    wedm_d_id integer
);


--
-- TOC entry 36 (OID 25699)
-- Name: weekly_events_doors_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_doors_map FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_doors_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 54 (OID 25699)
-- Name: weekly_events_doors_map_wedm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_doors_map_wedm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_doors_map_wedm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 37 (OID 25704)
-- Name: weekly_events; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE weekly_events (
    we_id serial NOT NULL,
    we_descr text DEFAULT ''::text NOT NULL,
    we_days_of_week boolean[] DEFAULT '{f,f,f,f,f,f,f}'::boolean[] NOT NULL,
    we_begin time without time zone NOT NULL,
    we_end time without time zone NOT NULL,
    we_disabled boolean DEFAULT false NOT NULL
);


--
-- TOC entry 38 (OID 25704)
-- Name: weekly_events; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events FROM PUBLIC;
GRANT ALL ON TABLE weekly_events TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 55 (OID 25704)
-- Name: weekly_events_we_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_we_id_seq FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_we_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 39 (OID 25715)
-- Name: date_groups; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE date_groups (
    dg_id serial NOT NULL,
    dg_descr text DEFAULT ''::text NOT NULL
);


--
-- TOC entry 40 (OID 25715)
-- Name: date_groups; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE date_groups FROM PUBLIC;
GRANT ALL ON TABLE date_groups TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 56 (OID 25715)
-- Name: date_groups_dg_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE date_groups_dg_id_seq FROM PUBLIC;
GRANT ALL ON TABLE date_groups_dg_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 41 (OID 25724)
-- Name: weekly_events_date_groups_map; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE weekly_events_date_groups_map (
    wedgm_id serial NOT NULL,
    wedgm_we_id integer,
    wedgm_dg_id integer
);


--
-- TOC entry 42 (OID 25724)
-- Name: weekly_events_date_groups_map; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_date_groups_map FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_date_groups_map TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 57 (OID 25724)
-- Name: weekly_events_date_groups_map_wedgm_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE weekly_events_date_groups_map_wedgm_id_seq FROM PUBLIC;
GRANT ALL ON TABLE weekly_events_date_groups_map_wedgm_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 43 (OID 25729)
-- Name: date_groups_dates; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE date_groups_dates (
    dgd_id serial NOT NULL,
    dgd_dg_id integer,
    dgd_begin date NOT NULL,
    dgd_end date NOT NULL
);


--
-- TOC entry 44 (OID 25729)
-- Name: date_groups_dates; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE date_groups_dates FROM PUBLIC;
GRANT ALL ON TABLE date_groups_dates TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 58 (OID 25729)
-- Name: date_groups_dates_dgd_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE date_groups_dates_dgd_id_seq FROM PUBLIC;
GRANT ALL ON TABLE date_groups_dates_dgd_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 45 (OID 25734)
-- Name: events; Type: VIEW; Schema: public; Owner: badboy
--

CREATE VIEW events AS
    (SELECT doors.d_code AS code, one_time_events.ote_begin AS begin_time, one_time_events.ote_end AS end_time FROM doors, one_time_events, one_time_events_doors_map WHERE ((doors.d_id = one_time_events_doors_map.otedm_d_id) AND (one_time_events_doors_map.otedm_ote_id = one_time_events.ote_id)) UNION SELECT doors.d_code AS code, (('now'::text)::date + weekly_events.we_begin) AS begin_time, (('now'::text)::date + weekly_events.we_end) AS end_time FROM doors, weekly_events, weekly_events_doors_map, weekly_events_dates WHERE (((((((doors.d_id = weekly_events_doors_map.wedm_d_id) AND (weekly_events_doors_map.wedm_we_id = weekly_events.we_id)) AND (weekly_events.we_id = weekly_events_dates.wed_we_id)) AND (weekly_events_dates.wed_begin <= ('now'::text)::date)) AND (weekly_events_dates.wed_end >= ('now'::text)::date)) AND (weekly_events.we_disabled = false)) AND (weekly_events.we_days_of_week[(date_part('dow'::text, ('now'::text)::date) + (1)::double precision)] = true))) UNION SELECT doors.d_code AS code, (('now'::text)::date + weekly_events.we_begin) AS begin_time, (('now'::text)::date + weekly_events.we_end) AS end_time FROM doors, weekly_events, weekly_events_doors_map, weekly_events_date_groups_map, date_groups, date_groups_dates WHERE (((((((((doors.d_id = weekly_events_doors_map.wedm_d_id) AND (weekly_events_doors_map.wedm_we_id = weekly_events.we_id)) AND (weekly_events.we_id = weekly_events_date_groups_map.wedgm_we_id)) AND (weekly_events_date_groups_map.wedgm_dg_id = date_groups.dg_id)) AND (date_groups_dates.dgd_dg_id = date_groups.dg_id)) AND (date_groups_dates.dgd_begin <= ('now'::text)::date)) AND (date_groups_dates.dgd_end >= ('now'::text)::date)) AND (weekly_events.we_disabled = false)) AND (weekly_events.we_days_of_week[(date_part('dow'::text, ('now'::text)::date) + (1)::double precision)] = true));


--
-- TOC entry 46 (OID 25734)
-- Name: events; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE events FROM PUBLIC;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 47 (OID 25738)
-- Name: d_doors; Type: TABLE; Schema: public; Owner: badboy
--

CREATE TABLE d_doors (
    dd_id serial NOT NULL,
    dd_mac macaddr NOT NULL,
    dd_script character varying(255),
    dd_ip inet NOT NULL,
    dd_d_id integer
);


--
-- TOC entry 48 (OID 25738)
-- Name: d_doors; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE d_doors FROM PUBLIC;
GRANT ALL ON TABLE d_doors TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 59 (OID 25738)
-- Name: d_doors_dd_id_seq; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE d_doors_dd_id_seq FROM PUBLIC;
GRANT ALL ON TABLE d_doors_dd_id_seq TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 49 (OID 25746)
-- Name: ethdoors; Type: VIEW; Schema: public; Owner: badboy
--

CREATE VIEW ethdoors AS
    SELECT doors.d_id AS id, doors.d_name AS name, doors.d_code AS code, d_doors.dd_mac AS mac, d_doors.dd_ip AS ip, doors.d_disabled AS disabled, doors.d_deleted AS deleted FROM doors, d_doors WHERE (d_doors.dd_d_id = doors.d_id);


--
-- TOC entry 50 (OID 25746)
-- Name: ethdoors; Type: ACL; Schema: public; Owner: badboy
--

REVOKE ALL ON TABLE ethdoors FROM PUBLIC;
GRANT ALL ON TABLE ethdoors TO apache;


SET SESSION AUTHORIZATION 'badboy';

--
-- TOC entry 66 (OID 28313)
-- Name: one_time_events_begin_end_idx; Type: INDEX; Schema: public; Owner: badboy
--

CREATE INDEX one_time_events_begin_end_idx ON one_time_events USING btree (ote_begin, ote_end);


--
-- TOC entry 68 (OID 28314)
-- Name: one_time_events_door_map_ote_idx; Type: INDEX; Schema: public; Owner: badboy
--

CREATE INDEX one_time_events_door_map_ote_idx ON one_time_events_doors_map USING btree (otedm_ote_id);


--
-- TOC entry 60 (OID 28315)
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (u_id);


--
-- TOC entry 61 (OID 28317)
-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (g_id);


--
-- TOC entry 62 (OID 28319)
-- Name: users_groups_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY users_groups_map
    ADD CONSTRAINT users_groups_map_pkey PRIMARY KEY (ugm_id);


--
-- TOC entry 63 (OID 28321)
-- Name: doors_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY doors
    ADD CONSTRAINT doors_pkey PRIMARY KEY (d_id);


--
-- TOC entry 64 (OID 28323)
-- Name: users_doors_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY users_doors_map
    ADD CONSTRAINT users_doors_map_pkey PRIMARY KEY (udm_id);


--
-- TOC entry 65 (OID 28325)
-- Name: groups_doors_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY groups_doors_map
    ADD CONSTRAINT groups_doors_map_pkey PRIMARY KEY (gdm_id);


--
-- TOC entry 67 (OID 28327)
-- Name: one_time_events_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY one_time_events
    ADD CONSTRAINT one_time_events_pkey PRIMARY KEY (ote_id);


--
-- TOC entry 69 (OID 28329)
-- Name: one_time_events_doors_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY one_time_events_doors_map
    ADD CONSTRAINT one_time_events_doors_map_pkey PRIMARY KEY (otedm_id);


--
-- TOC entry 70 (OID 28339)
-- Name: weekly_events_dates_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_dates
    ADD CONSTRAINT weekly_events_dates_pkey PRIMARY KEY (wed_id);


--
-- TOC entry 71 (OID 28341)
-- Name: weekly_events_doors_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_doors_map
    ADD CONSTRAINT weekly_events_doors_map_pkey PRIMARY KEY (wedm_id);


--
-- TOC entry 72 (OID 28347)
-- Name: weekly_events_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events
    ADD CONSTRAINT weekly_events_pkey PRIMARY KEY (we_id);


--
-- TOC entry 73 (OID 28349)
-- Name: date_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY date_groups
    ADD CONSTRAINT date_groups_pkey PRIMARY KEY (dg_id);


--
-- TOC entry 74 (OID 28351)
-- Name: weekly_events_date_groups_map_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_date_groups_map
    ADD CONSTRAINT weekly_events_date_groups_map_pkey PRIMARY KEY (wedgm_id);


--
-- TOC entry 75 (OID 28361)
-- Name: date_groups_dates_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY date_groups_dates
    ADD CONSTRAINT date_groups_dates_pkey PRIMARY KEY (dgd_id);


--
-- TOC entry 78 (OID 28367)
-- Name: d_doors_pkey; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY d_doors
    ADD CONSTRAINT d_doors_pkey PRIMARY KEY (dd_id);


--
-- TOC entry 77 (OID 28369)
-- Name: d_doors_dd_mac_key; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY d_doors
    ADD CONSTRAINT d_doors_dd_mac_key UNIQUE (dd_mac);


--
-- TOC entry 76 (OID 28371)
-- Name: d_doors_dd_ip_key; Type: CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY d_doors
    ADD CONSTRAINT d_doors_dd_ip_key UNIQUE (dd_ip);


--
-- TOC entry 79 (OID 28331)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY one_time_events_doors_map
    ADD CONSTRAINT "$1" FOREIGN KEY (otedm_ote_id) REFERENCES one_time_events(ote_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 80 (OID 28335)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY one_time_events_doors_map
    ADD CONSTRAINT "$2" FOREIGN KEY (otedm_d_id) REFERENCES doors(d_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 81 (OID 28343)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_doors_map
    ADD CONSTRAINT "$2" FOREIGN KEY (wedm_d_id) REFERENCES doors(d_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 82 (OID 28353)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_date_groups_map
    ADD CONSTRAINT "$1" FOREIGN KEY (wedgm_we_id) REFERENCES weekly_events(we_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 83 (OID 28357)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY weekly_events_date_groups_map
    ADD CONSTRAINT "$2" FOREIGN KEY (wedgm_dg_id) REFERENCES date_groups(dg_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 84 (OID 28363)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY date_groups_dates
    ADD CONSTRAINT "$1" FOREIGN KEY (dgd_dg_id) REFERENCES date_groups(dg_id);


--
-- TOC entry 85 (OID 28373)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: badboy
--

ALTER TABLE ONLY d_doors
    ADD CONSTRAINT "$1" FOREIGN KEY (dd_d_id) REFERENCES doors(d_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- TOC entry 102 (OID 28377)
-- Name: RI_ConstraintTrigger_28377; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_groups_map
    FROM users
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 86 (OID 28378)
-- Name: RI_ConstraintTrigger_28378; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON users
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 87 (OID 28379)
-- Name: RI_ConstraintTrigger_28379; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON users
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 103 (OID 28380)
-- Name: RI_ConstraintTrigger_28380; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_groups_map
    FROM groups
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 94 (OID 28381)
-- Name: RI_ConstraintTrigger_28381; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON groups
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 95 (OID 28382)
-- Name: RI_ConstraintTrigger_28382; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON groups
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 114 (OID 28383)
-- Name: RI_ConstraintTrigger_28383; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_doors_map
    FROM users
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 88 (OID 28384)
-- Name: RI_ConstraintTrigger_28384; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON users
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 89 (OID 28385)
-- Name: RI_ConstraintTrigger_28385; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON users
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 115 (OID 28386)
-- Name: RI_ConstraintTrigger_28386; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_doors_map
    FROM doors
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 106 (OID 28387)
-- Name: RI_ConstraintTrigger_28387; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON doors
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 107 (OID 28388)
-- Name: RI_ConstraintTrigger_28388; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON doors
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 118 (OID 28389)
-- Name: RI_ConstraintTrigger_28389; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON groups_doors_map
    FROM groups
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 96 (OID 28390)
-- Name: RI_ConstraintTrigger_28390; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON groups
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 97 (OID 28391)
-- Name: RI_ConstraintTrigger_28391; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON groups
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 119 (OID 28392)
-- Name: RI_ConstraintTrigger_28392; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON groups_doors_map
    FROM doors
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


--
-- TOC entry 108 (OID 28393)
-- Name: RI_ConstraintTrigger_28393; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON doors
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


--
-- TOC entry 109 (OID 28394)
-- Name: RI_ConstraintTrigger_28394; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON doors
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


--
-- TOC entry 104 (OID 28395)
-- Name: RI_ConstraintTrigger_28395; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_groups_map
    FROM users
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 90 (OID 28396)
-- Name: RI_ConstraintTrigger_28396; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON users
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 91 (OID 28397)
-- Name: RI_ConstraintTrigger_28397; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON users
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_groups_map', 'users', 'UNSPECIFIED', 'ugm_u_id', 'u_id');


--
-- TOC entry 105 (OID 28398)
-- Name: RI_ConstraintTrigger_28398; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_groups_map
    FROM groups
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 98 (OID 28399)
-- Name: RI_ConstraintTrigger_28399; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON groups
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 99 (OID 28400)
-- Name: RI_ConstraintTrigger_28400; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON groups
    FROM users_groups_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_groups_map', 'groups', 'UNSPECIFIED', 'ugm_g_id', 'g_id');


--
-- TOC entry 116 (OID 28401)
-- Name: RI_ConstraintTrigger_28401; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_doors_map
    FROM users
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 92 (OID 28402)
-- Name: RI_ConstraintTrigger_28402; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON users
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 93 (OID 28403)
-- Name: RI_ConstraintTrigger_28403; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON users
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_doors_map', 'users', 'UNSPECIFIED', 'udm_u_id', 'u_id');


--
-- TOC entry 117 (OID 28404)
-- Name: RI_ConstraintTrigger_28404; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON users_doors_map
    FROM doors
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 110 (OID 28405)
-- Name: RI_ConstraintTrigger_28405; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON doors
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 111 (OID 28406)
-- Name: RI_ConstraintTrigger_28406; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON doors
    FROM users_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'users_doors_map', 'doors', 'UNSPECIFIED', 'udm_d_id', 'd_id');


--
-- TOC entry 120 (OID 28407)
-- Name: RI_ConstraintTrigger_28407; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON groups_doors_map
    FROM groups
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 100 (OID 28408)
-- Name: RI_ConstraintTrigger_28408; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON groups
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 101 (OID 28409)
-- Name: RI_ConstraintTrigger_28409; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON groups
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'groups_doors_map', 'groups', 'UNSPECIFIED', 'gdm_g_id', 'g_id');


--
-- TOC entry 121 (OID 28410)
-- Name: RI_ConstraintTrigger_28410; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER INSERT OR UPDATE ON groups_doors_map
    FROM doors
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


--
-- TOC entry 112 (OID 28411)
-- Name: RI_ConstraintTrigger_28411; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER DELETE ON doors
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


--
-- TOC entry 113 (OID 28412)
-- Name: RI_ConstraintTrigger_28412; Type: TRIGGER; Schema: public; Owner: badboy
--

CREATE CONSTRAINT TRIGGER "<unnamed>"
    AFTER UPDATE ON doors
    FROM groups_doors_map
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_cascade_upd"('<unnamed>', 'groups_doors_map', 'doors', 'UNSPECIFIED', 'gdm_d_id', 'd_id');


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';