 ALTER TABLE public.instance_mapped_values OWNER TO postgres;
 
 --
+-- Name: instance_view; Type: VIEW; Schema: public; Owner: postgres
+--
+
+CREATE VIEW instance_view AS
+    SELECT instance_mapped_values.instance_uid, instance_mapped_values.std_name, instance_mapped_values.value, instance_mapped_values.unit FROM instance_mapped_values UNION SELECT instance_derived_values.instance_uid, instance_derived_values.std_name, instance_derived_values.value, instance_derived_values.unit FROM instance_derived_values ORDER BY 1;
+
+
+ALTER TABLE public.instance_view OWNER TO postgres;
+
+--
+-- Name: known_scanners_version_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE known_scanners_version_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.known_scanners_version_id_seq OWNER TO postgres;
+
+--
+-- Name: known_scanners_version_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+--
+
+ALTER SEQUENCE known_scanners_version_id_seq OWNED BY known_scanners.version_id;
+
+
+--
+-- Name: known_scanners_version_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
+--
+
+SELECT pg_catalog.setval('known_scanners_version_id_seq', 18, true);
+
+
+--
 -- Name: mapped_values; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
 --
 

ALTER TABLE public.acquisition_mapped_values OWNER TO postgres;

--
-- Name: alerts; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--



SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: ddw; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE ddw WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252';


ALTER DATABASE ddw OWNER TO postgres;

\connect ddw

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: ddw; Type: COMMENT; Schema: -; Owner: postgres
