-- -- PostgreSQL database dump -- -- Dumped from database version 11.12 -- Dumped by pg_dump version 15.2 -- Started on 2023-05-05 01:10:04 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; CREATE ROLE senslog NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT; CREATE ROLE maplog_app NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN PASSWORD 'MAPlog'; GRANT senslog TO maplog_app; -- -- TOC entry 3861 (class 1262 OID 54507) -- Name: maplog; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE maplog WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.UTF-8'; ALTER DATABASE maplog OWNER TO senslog; \connect maplog SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- TOC entry 9 (class 2615 OID 55528) -- Name: maplog; Type: SCHEMA; Schema: -; Owner: postgres -- CREATE SCHEMA maplog; ALTER SCHEMA maplog OWNER TO senslog; -- -- TOC entry 7 (class 2615 OID 2200) -- Name: public; Type: SCHEMA; Schema: -; Owner: postgres -- -- *not* creating schema, since initdb creates it ALTER SCHEMA public OWNER TO senslog; -- -- TOC entry 2 (class 3079 OID 54508) -- Name: postgis; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; -- -- TOC entry 3863 (class 0 OID 0) -- Dependencies: 2 -- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION postgis IS 'PostGIS geometry and geography spatial types and functions'; SET default_tablespace = ''; -- -- TOC entry 216 (class 1259 OID 62701) -- Name: campaign; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.campaign ( campaign_id integer NOT NULL, description text NOT NULL, from_time timestamp with time zone NOT NULL, to_time timestamp with time zone NOT NULL ); ALTER TABLE maplog.campaign OWNER TO senslog; -- -- TOC entry 215 (class 1259 OID 62699) -- Name: campaign_campaign_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.campaign_campaign_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.campaign_campaign_id_seq OWNER TO senslog; -- -- TOC entry 3864 (class 0 OID 0) -- Dependencies: 215 -- Name: campaign_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.campaign_campaign_id_seq OWNED BY maplog.campaign.campaign_id; -- -- TOC entry 224 (class 1259 OID 62784) -- Name: groups; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.groups ( group_id integer NOT NULL, group_name text, parent_group_id integer, has_children boolean DEFAULT false ); ALTER TABLE maplog.groups OWNER TO senslog; -- -- TOC entry 223 (class 1259 OID 62782) -- Name: group_group_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.group_group_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.group_group_id_seq OWNER TO senslog; -- -- TOC entry 3865 (class 0 OID 0) -- Dependencies: 223 -- Name: group_group_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.group_group_id_seq OWNED BY maplog.groups.group_id; -- -- TOC entry 212 (class 1259 OID 55614) -- Name: obs_telemetry; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.obs_telemetry ( obs_id bigint NOT NULL, time_stamp timestamp with time zone NOT NULL, unit_id bigint NOT NULL, observed_values jsonb NOT NULL, the_geom public.geometry(Point,4326), time_received timestamp with time zone DEFAULT now() NOT NULL ); ALTER TABLE maplog.obs_telemetry OWNER TO senslog; -- -- TOC entry 211 (class 1259 OID 55612) -- Name: obs_telemetry_obs_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.obs_telemetry_obs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.obs_telemetry_obs_id_seq OWNER TO senslog; -- -- TOC entry 3866 (class 0 OID 0) -- Dependencies: 211 -- Name: obs_telemetry_obs_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.obs_telemetry_obs_id_seq OWNED BY maplog.obs_telemetry.obs_id; -- -- TOC entry 209 (class 1259 OID 55579) -- Name: phenomenon; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.phenomenon ( phenomenon_id integer NOT NULL, phenomenon_name text NOT NULL, uom character varying(30) NOT NULL, uom_link text ); ALTER TABLE maplog.phenomenon OWNER TO senslog; -- -- TOC entry 208 (class 1259 OID 55577) -- Name: phenomenon_phenomenon_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.phenomenon_phenomenon_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.phenomenon_phenomenon_id_seq OWNER TO senslog; -- -- TOC entry 3867 (class 0 OID 0) -- Dependencies: 208 -- Name: phenomenon_phenomenon_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.phenomenon_phenomenon_id_seq OWNED BY maplog.phenomenon.phenomenon_id; -- -- TOC entry 207 (class 1259 OID 55566) -- Name: sensor; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.sensor ( sensor_id bigint NOT NULL, sensor_name character varying(100), sensor_type text, sensor_type_id integer, min_range text, max_range text, phenomenon_id integer NOT NULL ); ALTER TABLE maplog.sensor OWNER TO senslog; -- -- TOC entry 206 (class 1259 OID 55564) -- Name: sensor_sensor_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.sensor_sensor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.sensor_sensor_id_seq OWNER TO senslog; -- -- TOC entry 3868 (class 0 OID 0) -- Dependencies: 206 -- Name: sensor_sensor_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.sensor_sensor_id_seq OWNED BY maplog.sensor.sensor_id; -- -- TOC entry 213 (class 1259 OID 55644) -- Name: system_user; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.system_user ( user_id integer NOT NULL, user_name text NOT NULL, user_real_name text, user_password text, group_id integer, rights_id integer DEFAULT 0 ); ALTER TABLE maplog.system_user OWNER TO senslog; -- -- TOC entry 204 (class 1259 OID 55540) -- Name: unit; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.unit ( unit_id bigint NOT NULL, description text, is_mobile boolean DEFAULT true NOT NULL, unit_type_id character varying(2) DEFAULT 'X'::character varying NOT NULL ); ALTER TABLE maplog.unit OWNER TO senslog; -- -- TOC entry 218 (class 1259 OID 62712) -- Name: unit_to_campaign; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.unit_to_campaign ( id integer NOT NULL, camp_id integer NOT NULL, unit_id bigint NOT NULL, from_time timestamp with time zone NOT NULL, to_time timestamp with time zone NOT NULL ); ALTER TABLE maplog.unit_to_campaign OWNER TO senslog; -- -- TOC entry 217 (class 1259 OID 62710) -- Name: unit_to_campaign_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.unit_to_campaign_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.unit_to_campaign_id_seq OWNER TO senslog; -- -- TOC entry 3869 (class 0 OID 0) -- Dependencies: 217 -- Name: unit_to_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.unit_to_campaign_id_seq OWNED BY maplog.unit_to_campaign.id; -- -- TOC entry 226 (class 1259 OID 62796) -- Name: unit_to_group; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.unit_to_group ( id integer NOT NULL, group_id integer, unit_id bigint ); ALTER TABLE maplog.unit_to_group OWNER TO senslog; -- -- TOC entry 225 (class 1259 OID 62794) -- Name: unit_to_group_id_seq; Type: SEQUENCE; Schema: maplog; Owner: postgres -- CREATE SEQUENCE maplog.unit_to_group_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE maplog.unit_to_group_id_seq OWNER TO senslog; -- -- TOC entry 3870 (class 0 OID 0) -- Dependencies: 225 -- Name: unit_to_group_id_seq; Type: SEQUENCE OWNED BY; Schema: maplog; Owner: postgres -- ALTER SEQUENCE maplog.unit_to_group_id_seq OWNED BY maplog.unit_to_group.id; -- -- TOC entry 210 (class 1259 OID 55594) -- Name: unit_to_sensor; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.unit_to_sensor ( sensor_id bigint NOT NULL, unit_id bigint NOT NULL, first_obs_ts timestamp with time zone, last_obs_ts timestamp with time zone, last_obs_value double precision DEFAULT 'NaN'::double precision ); ALTER TABLE maplog.unit_to_sensor OWNER TO senslog; -- -- TOC entry 205 (class 1259 OID 55548) -- Name: unit_type; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.unit_type ( unit_type_id character varying(2) NOT NULL, type_name character varying(20) NOT NULL, description text ); ALTER TABLE maplog.unit_type OWNER TO senslog; -- -- TOC entry 214 (class 1259 OID 55654) -- Name: user_to_campaign; Type: TABLE; Schema: maplog; Owner: postgres -- CREATE TABLE maplog.user_to_campaign ( user_id integer NOT NULL, campaign_id integer NOT NULL ); ALTER TABLE maplog.user_to_campaign OWNER TO senslog; -- -- TOC entry 3638 (class 2604 OID 62704) -- Name: campaign campaign_id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.campaign ALTER COLUMN campaign_id SET DEFAULT nextval('maplog.campaign_campaign_id_seq'::regclass); -- -- TOC entry 3643 (class 2604 OID 62787) -- Name: groups group_id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.groups ALTER COLUMN group_id SET DEFAULT nextval('maplog.group_group_id_seq'::regclass); -- -- TOC entry 3635 (class 2604 OID 55617) -- Name: obs_telemetry obs_id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.obs_telemetry ALTER COLUMN obs_id SET DEFAULT nextval('maplog.obs_telemetry_obs_id_seq'::regclass); -- -- TOC entry 3633 (class 2604 OID 55582) -- Name: phenomenon phenomenon_id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.phenomenon ALTER COLUMN phenomenon_id SET DEFAULT nextval('maplog.phenomenon_phenomenon_id_seq'::regclass); -- -- TOC entry 3632 (class 2604 OID 55569) -- Name: sensor sensor_id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.sensor ALTER COLUMN sensor_id SET DEFAULT nextval('maplog.sensor_sensor_id_seq'::regclass); -- -- TOC entry 3639 (class 2604 OID 62715) -- Name: unit_to_campaign id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_campaign ALTER COLUMN id SET DEFAULT nextval('maplog.unit_to_campaign_id_seq'::regclass); -- -- TOC entry 3645 (class 2604 OID 62799) -- Name: unit_to_group id; Type: DEFAULT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_group ALTER COLUMN id SET DEFAULT nextval('maplog.unit_to_group_id_seq'::regclass); -- -- TOC entry 3677 (class 2606 OID 62709) -- Name: campaign campaign_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.campaign ADD CONSTRAINT campaign_pkey PRIMARY KEY (campaign_id); -- -- TOC entry 3689 (class 2606 OID 62793) -- Name: groups group_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.groups ADD CONSTRAINT group_pkey PRIMARY KEY (group_id); -- -- TOC entry 3667 (class 2606 OID 55623) -- Name: obs_telemetry obs_telemetry_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.obs_telemetry ADD CONSTRAINT obs_telemetry_pkey PRIMARY KEY (obs_id); -- -- TOC entry 3660 (class 2606 OID 55587) -- Name: phenomenon phenomenon_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.phenomenon ADD CONSTRAINT phenomenon_pkey PRIMARY KEY (phenomenon_id); -- -- TOC entry 3656 (class 2606 OID 55574) -- Name: sensor sensor_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.sensor ADD CONSTRAINT sensor_pkey PRIMARY KEY (sensor_id); -- -- TOC entry 3658 (class 2606 OID 55576) -- Name: sensor sensor_sensor_name_key; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.sensor ADD CONSTRAINT sensor_sensor_name_key UNIQUE (sensor_name); -- -- TOC entry 3670 (class 2606 OID 55653) -- Name: system_user systemuser_pk; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.system_user ADD CONSTRAINT systemuser_pk PRIMARY KEY (user_id); -- -- TOC entry 3651 (class 2606 OID 55557) -- Name: unit unit_pk; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit ADD CONSTRAINT unit_pk PRIMARY KEY (unit_id); -- -- TOC entry 3681 (class 2606 OID 62717) -- Name: unit_to_campaign unit_to_campaign_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_campaign ADD CONSTRAINT unit_to_campaign_pkey PRIMARY KEY (id); -- -- TOC entry 3693 (class 2606 OID 62801) -- Name: unit_to_group unit_to_group_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_group ADD CONSTRAINT unit_to_group_pkey PRIMARY KEY (id); -- -- TOC entry 3653 (class 2606 OID 55555) -- Name: unit_type unittype_pk; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_type ADD CONSTRAINT unittype_pk PRIMARY KEY (unit_type_id); -- -- TOC entry 3675 (class 2606 OID 55658) -- Name: user_to_campaign user_to_campaign_pkey; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.user_to_campaign ADD CONSTRAINT user_to_campaign_pkey PRIMARY KEY (user_id, campaign_id); -- -- TOC entry 3664 (class 2606 OID 55599) -- Name: unit_to_sensor uts_pk; Type: CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_sensor ADD CONSTRAINT uts_pk PRIMARY KEY (unit_id, sensor_id); -- -- TOC entry 3665 (class 1259 OID 55629) -- Name: fki_obss_unitid_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_obss_unitid_fk ON maplog.obs_telemetry USING btree (unit_id); -- -- TOC entry 3654 (class 1259 OID 55593) -- Name: fki_sens_phenom_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_sens_phenom_fk ON maplog.sensor USING btree (phenomenon_id); -- -- TOC entry 3671 (class 1259 OID 62723) -- Name: fki_u2c_campid; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_u2c_campid ON maplog.user_to_campaign USING btree (campaign_id); -- -- TOC entry 3672 (class 1259 OID 55670) -- Name: fki_u2c_campid_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_u2c_campid_fk ON maplog.user_to_campaign USING btree (campaign_id); -- -- TOC entry 3673 (class 1259 OID 55664) -- Name: fki_u2c_userid_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_u2c_userid_fk ON maplog.user_to_campaign USING btree (user_id); -- -- TOC entry 3678 (class 1259 OID 62735) -- Name: fki_un2c_campid; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_un2c_campid ON maplog.unit_to_campaign USING btree (camp_id); -- -- TOC entry 3679 (class 1259 OID 62729) -- Name: fki_un2c_unitid; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_un2c_unitid ON maplog.unit_to_campaign USING btree (unit_id); -- -- TOC entry 3690 (class 1259 OID 62813) -- Name: fki_unit2group_group_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_unit2group_group_fk ON maplog.unit_to_group USING btree (group_id); -- -- TOC entry 3691 (class 1259 OID 62819) -- Name: fki_unit2group_unit_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_unit2group_unit_fk ON maplog.unit_to_group USING btree (unit_id); -- -- TOC entry 3649 (class 1259 OID 55563) -- Name: fki_unit_unittype_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_unit_unittype_fk ON maplog.unit USING btree (unit_type_id); -- -- TOC entry 3668 (class 1259 OID 62807) -- Name: fki_user2group_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_user2group_fk ON maplog.system_user USING btree (group_id); -- -- TOC entry 3661 (class 1259 OID 55611) -- Name: fki_uts_sensorid_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_uts_sensorid_fk ON maplog.unit_to_sensor USING btree (sensor_id); -- -- TOC entry 3662 (class 1259 OID 55605) -- Name: fki_uts_unitid_fk; Type: INDEX; Schema: maplog; Owner: postgres -- CREATE INDEX fki_uts_unitid_fk ON maplog.unit_to_sensor USING btree (unit_id); -- -- TOC entry 3700 (class 2606 OID 55624) -- Name: obs_telemetry obss_unitid_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.obs_telemetry ADD CONSTRAINT obss_unitid_fk FOREIGN KEY (unit_id) REFERENCES maplog.unit(unit_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3697 (class 2606 OID 55588) -- Name: sensor sens_phenom_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.sensor ADD CONSTRAINT sens_phenom_fk FOREIGN KEY (phenomenon_id) REFERENCES maplog.phenomenon(phenomenon_id); -- -- TOC entry 3702 (class 2606 OID 62718) -- Name: user_to_campaign u2c_campid; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.user_to_campaign ADD CONSTRAINT u2c_campid FOREIGN KEY (campaign_id) REFERENCES maplog.campaign(campaign_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3703 (class 2606 OID 55659) -- Name: user_to_campaign u2c_userid_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.user_to_campaign ADD CONSTRAINT u2c_userid_fk FOREIGN KEY (user_id) REFERENCES maplog.system_user(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3704 (class 2606 OID 62730) -- Name: unit_to_campaign un2c_campid; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_campaign ADD CONSTRAINT un2c_campid FOREIGN KEY (camp_id) REFERENCES maplog.campaign(campaign_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3705 (class 2606 OID 62724) -- Name: unit_to_campaign un2c_unitid; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_campaign ADD CONSTRAINT un2c_unitid FOREIGN KEY (unit_id) REFERENCES maplog.unit(unit_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3706 (class 2606 OID 62808) -- Name: unit_to_group unit2group_group_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_group ADD CONSTRAINT unit2group_group_fk FOREIGN KEY (group_id) REFERENCES maplog.groups(group_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3707 (class 2606 OID 62814) -- Name: unit_to_group unit2group_unit_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_group ADD CONSTRAINT unit2group_unit_fk FOREIGN KEY (unit_id) REFERENCES maplog.unit(unit_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3696 (class 2606 OID 55558) -- Name: unit unit_unittype_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit ADD CONSTRAINT unit_unittype_fk FOREIGN KEY (unit_type_id) REFERENCES maplog.unit_type(unit_type_id); -- -- TOC entry 3701 (class 2606 OID 62802) -- Name: system_user user2group_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.system_user ADD CONSTRAINT user2group_fk FOREIGN KEY (group_id) REFERENCES maplog.groups(group_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3698 (class 2606 OID 55606) -- Name: unit_to_sensor uts_sensorid_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_sensor ADD CONSTRAINT uts_sensorid_fk FOREIGN KEY (sensor_id) REFERENCES maplog.sensor(sensor_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3699 (class 2606 OID 55600) -- Name: unit_to_sensor uts_unitid_fk; Type: FK CONSTRAINT; Schema: maplog; Owner: postgres -- ALTER TABLE ONLY maplog.unit_to_sensor ADD CONSTRAINT uts_unitid_fk FOREIGN KEY (unit_id) REFERENCES maplog.unit(unit_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- TOC entry 3862 (class 0 OID 0) -- Dependencies: 7 -- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres -- REVOKE USAGE ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; -- Completed on 2023-05-05 01:10:04 -- -- PostgreSQL database dump complete --