--
-- NOTE:
--
-- File paths need to be edited. Search for $$PATH$$ and
-- replace it with the path to the directory containing
-- the extracted data files.
--
--
-- PostgreSQL database dump
--

-- Dumped from database version 12.5
-- Dumped by pg_dump version 13.5

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;

DROP DATABASE postgres;

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

CREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.UTF-8';


ALTER DATABASE postgres OWNER TO postgres;

\connect postgres

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;

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

COMMENT ON DATABASE postgres IS 'default administrative connection database';


--
-- Name: c2011_meta_test; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA c2011_meta_test;


ALTER SCHEMA c2011_meta_test OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: ap1601_0_ew_mrg_rcd_agg; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.ap1601_0_ew_mrg_rcd_agg (
    geocodeid integer NOT NULL,
    cl_id integer,
    nsi_area_id character varying(15),
    ap1601ew0001 integer,
    ap1601ew0002 integer,
    ap1601ew0003 integer,
    ap1601ew0004 integer
);


ALTER TABLE c2011_meta_test.ap1601_0_ew_mrg_rcd_agg OWNER TO postgres;

--
-- Name: geography_area_relations; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.geography_area_relations (
    parent_id integer NOT NULL,
    child_id integer NOT NULL,
    parent_grouping_id integer,
    child_grouping_id integer,
    active boolean,
    id integer
);


ALTER TABLE c2011_meta_test.geography_area_relations OWNER TO postgres;

--
-- Name: geography_areas; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.geography_areas (
    geography_grouping_id integer,
    id integer NOT NULL,
    description character varying(255),
    geography_code character varying(50),
    top_level_geography_id integer
);


ALTER TABLE c2011_meta_test.geography_areas OWNER TO postgres;

--
-- Name: geography_groupings; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.geography_groupings (
    id integer NOT NULL,
    abbreviation character varying(100),
    name character varying(100),
    description text,
    geography_area_count integer,
    description_extended text,
    top_level_geography_id integer[]
);


ALTER TABLE c2011_meta_test.geography_groupings OWNER TO postgres;

--
-- Name: lc4407_0_ew_mrg_rcd_agg; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.lc4407_0_ew_mrg_rcd_agg (
    geocodeid integer NOT NULL,
    cl_id integer,
    nsi_area_id character varying(15),
    lc4407ew0001 integer,
    lc4407ew0002 integer,
    lc4407ew0003 integer,
    lc4407ew0004 integer,
    lc4407ew0005 integer,
    lc4407ew0006 integer,
    lc4407ew0007 integer,
    lc4407ew0008 integer,
    lc4407ew0009 integer,
    lc4407ew0010 integer,
    lc4407ew0011 integer,
    lc4407ew0012 integer,
    lc4407ew0013 integer,
    lc4407ew0014 integer,
    lc4407ew0015 integer,
    lc4407ew0016 integer,
    lc4407ew0017 integer,
    lc4407ew0018 integer,
    lc4407ew0019 integer,
    lc4407ew0020 integer,
    lc4407ew0021 integer,
    lc4407ew0022 integer,
    lc4407ew0023 integer,
    lc4407ew0024 integer,
    lc4407ew0025 integer,
    lc4407ew0026 integer,
    lc4407ew0027 integer,
    lc4407ew0028 integer,
    lc4407ew0029 integer,
    lc4407ew0030 integer,
    lc4407ew0031 integer,
    lc4407ew0032 integer,
    lc4407ew0033 integer,
    lc4407ew0034 integer,
    lc4407ew0035 integer,
    lc4407ew0036 integer,
    lc4407ew0037 integer,
    lc4407ew0038 integer,
    lc4407ew0039 integer,
    lc4407ew0040 integer,
    lc4407ew0041 integer,
    lc4407ew0042 integer,
    lc4407ew0043 integer,
    lc4407ew0044 integer,
    lc4407ew0045 integer,
    lc4407ew0046 integer,
    lc4407ew0047 integer,
    lc4407ew0048 integer,
    lc4407ew0049 integer,
    lc4407ew0050 integer,
    lc4407ew0051 integer,
    lc4407ew0052 integer,
    lc4407ew0053 integer,
    lc4407ew0054 integer,
    lc4407ew0055 integer,
    lc4407ew0056 integer,
    lc4407ew0057 integer,
    lc4407ew0058 integer,
    lc4407ew0059 integer,
    lc4407ew0060 integer,
    lc4407ew0061 integer,
    lc4407ew0062 integer,
    lc4407ew0063 integer,
    lc4407ew0064 integer,
    lc4407ew0065 integer,
    lc4407ew0066 integer,
    lc4407ew0067 integer,
    lc4407ew0068 integer,
    lc4407ew0069 integer,
    lc4407ew0070 integer,
    lc4407ew0071 integer,
    lc4407ew0072 integer,
    lc4407ew0073 integer,
    lc4407ew0074 integer,
    lc4407ew0075 integer,
    lc4407ew0076 integer,
    lc4407ew0077 integer,
    lc4407ew0078 integer,
    lc4407ew0079 integer,
    lc4407ew0080 integer,
    lc4407ew0081 integer,
    lc4407ew0082 integer,
    lc4407ew0083 integer,
    lc4407ew0084 integer,
    lc4407ew0085 integer,
    lc4407ew0086 integer,
    lc4407ew0087 integer,
    lc4407ew0088 integer,
    lc4407ew0089 integer,
    lc4407ew0090 integer,
    lc4407ew0091 integer,
    lc4407ew0092 integer,
    lc4407ew0093 integer,
    lc4407ew0094 integer,
    lc4407ew0095 integer,
    lc4407ew0096 integer,
    lc4407ew0097 integer,
    lc4407ew0098 integer,
    lc4407ew0099 integer,
    lc4407ew0100 integer,
    lc4407ew0101 integer,
    lc4407ew0102 integer,
    lc4407ew0103 integer,
    lc4407ew0104 integer,
    lc4407ew0105 integer,
    lc4407ew0106 integer,
    lc4407ew0107 integer,
    lc4407ew0108 integer,
    lc4407ew0109 integer,
    lc4407ew0110 integer,
    lc4407ew0111 integer,
    lc4407ew0112 integer,
    lc4407ew0113 integer,
    lc4407ew0114 integer,
    lc4407ew0115 integer,
    lc4407ew0116 integer,
    lc4407ew0117 integer,
    lc4407ew0118 integer,
    lc4407ew0119 integer,
    lc4407ew0120 integer,
    lc4407ew0121 integer,
    lc4407ew0122 integer,
    lc4407ew0123 integer,
    lc4407ew0124 integer,
    lc4407ew0125 integer,
    lc4407ew0126 integer,
    lc4407ew0127 integer,
    lc4407ew0128 integer,
    lc4407ew0129 integer,
    lc4407ew0130 integer,
    lc4407ew0131 integer,
    lc4407ew0132 integer,
    lc4407ew0133 integer,
    lc4407ew0134 integer,
    lc4407ew0135 integer,
    lc4407ew0136 integer,
    lc4407ew0137 integer,
    lc4407ew0138 integer,
    lc4407ew0139 integer,
    lc4407ew0140 integer,
    lc4407ew0141 integer,
    lc4407ew0142 integer,
    lc4407ew0143 integer,
    lc4407ew0144 integer,
    lc4407ew0145 integer,
    lc4407ew0146 integer,
    lc4407ew0147 integer,
    lc4407ew0148 integer,
    lc4407ew0149 integer,
    lc4407ew0150 integer,
    lc4407ew0151 integer,
    lc4407ew0152 integer,
    lc4407ew0153 integer,
    lc4407ew0154 integer,
    lc4407ew0155 integer,
    lc4407ew0156 integer,
    lc4407ew0157 integer,
    lc4407ew0158 integer,
    lc4407ew0159 integer,
    lc4407ew0160 integer,
    lc4407ew0161 integer,
    lc4407ew0162 integer,
    lc4407ew0163 integer,
    lc4407ew0164 integer,
    lc4407ew0165 integer,
    lc4407ew0166 integer,
    lc4407ew0167 integer,
    lc4407ew0168 integer,
    lc4407ew0169 integer,
    lc4407ew0170 integer,
    lc4407ew0171 integer,
    lc4407ew0172 integer,
    lc4407ew0173 integer,
    lc4407ew0174 integer,
    lc4407ew0175 integer,
    lc4407ew0176 integer,
    lc4407ew0177 integer,
    lc4407ew0178 integer,
    lc4407ew0179 integer,
    lc4407ew0180 integer,
    lc4407ew0181 integer,
    lc4407ew0182 integer,
    lc4407ew0183 integer,
    lc4407ew0184 integer,
    lc4407ew0185 integer,
    lc4407ew0186 integer,
    lc4407ew0187 integer,
    lc4407ew0188 integer,
    lc4407ew0189 integer,
    lc4407ew0190 integer,
    lc4407ew0191 integer,
    lc4407ew0192 integer,
    lc4407ew0193 integer,
    lc4407ew0194 integer,
    lc4407ew0195 integer,
    lc4407ew0196 integer,
    lc4407ew0197 integer,
    lc4407ew0198 integer,
    lc4407ew0199 integer,
    lc4407ew0200 integer,
    lc4407ew0201 integer,
    lc4407ew0202 integer,
    lc4407ew0203 integer,
    lc4407ew0204 integer,
    lc4407ew0205 integer,
    lc4407ew0206 integer,
    lc4407ew0207 integer,
    lc4407ew0208 integer,
    lc4407ew0209 integer,
    lc4407ew0210 integer
);


ALTER TABLE c2011_meta_test.lc4407_0_ew_mrg_rcd_agg OWNER TO postgres;

--
-- Name: st606_0_ew_mrg_rcd_agg; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.st606_0_ew_mrg_rcd_agg (
    geocodeid integer NOT NULL,
    cl_id integer,
    nsi_area_id character varying(15),
    st606ewla0001 integer,
    st606ewla0002 integer,
    st606ewla0003 integer,
    st606ewla0004 integer,
    st606ewla0005 integer,
    st606ewla0006 integer,
    st606ewla0007 integer,
    st606ewla0008 integer,
    st606ewla0009 integer,
    st606ewla0010 integer
);


ALTER TABLE c2011_meta_test.st606_0_ew_mrg_rcd_agg OWNER TO postgres;

--
-- Name: themes; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.themes (
    id integer NOT NULL,
    theme character varying(255),
    description character varying(255)
);


ALTER TABLE c2011_meta_test.themes OWNER TO postgres;

--
-- Name: top_level_geographies; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.top_level_geographies (
    geography_type_id integer,
    id integer NOT NULL,
    description character varying(255),
    geography_code character varying(50),
    hidden_from_ui boolean
);


ALTER TABLE c2011_meta_test.top_level_geographies OWNER TO postgres;

--
-- Name: topic_combinations; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.topic_combinations (
    id integer NOT NULL,
    variable_combination_count integer,
    ordinal integer,
    combination text[],
    geography_combinations text[],
    geography_groupings integer[],
    top_level_geographies integer[],
    title character varying(255),
    universe character varying(255),
    units integer[],
    theme_id integer
);


ALTER TABLE c2011_meta_test.topic_combinations OWNER TO postgres;

--
-- Name: topics; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.topics (
    id integer NOT NULL,
    abbreviation character varying(255),
    name character varying(255),
    description text,
    ordinal integer,
    top_level_geography_coverage integer[]
);


ALTER TABLE c2011_meta_test.topics OWNER TO postgres;

--
-- Name: variable_combinations; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.variable_combinations (
    id integer NOT NULL,
    table_column_name character varying(50),
    combination integer[],
    topic_combination text[],
    topic_variable_combination text[],
    geography_combination text[],
    geography_groupings text[],
    description character varying,
    table_name character varying(50),
    top_level_geography integer[]
);


ALTER TABLE c2011_meta_test.variable_combinations OWNER TO postgres;

--
-- Name: variables; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.variables (
    topic_id integer,
    id integer NOT NULL,
    description character varying(500),
    ordinal integer,
    parent_code integer,
    full_description text
);


ALTER TABLE c2011_meta_test.variables OWNER TO postgres;

--
-- Name: wd501_0_ew_mrg_rcd_agg; Type: TABLE; Schema: c2011_meta_test; Owner: postgres
--

CREATE TABLE c2011_meta_test.wd501_0_ew_mrg_rcd_agg (
    geocodeid integer NOT NULL,
    cl_id integer,
    nsi_area_id character varying(15),
    wd501ew0001 integer,
    wd501ew0002 integer,
    wd501ew0003 integer,
    wd501ew0004 integer,
    wd501ew0005 integer,
    wd501ew0006 integer,
    wd501ew0007 integer,
    wd501ew0008 integer
);


ALTER TABLE c2011_meta_test.wd501_0_ew_mrg_rcd_agg OWNER TO postgres;

--
-- Data for Name: ap1601_0_ew_mrg_rcd_agg; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.ap1601_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, ap1601ew0001, ap1601ew0002, ap1601ew0003, ap1601ew0004) FROM stdin;
\.
COPY c2011_meta_test.ap1601_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, ap1601ew0001, ap1601ew0002, ap1601ew0003, ap1601ew0004) FROM '/docker-entrypoint-initdb.d/9109.dat';

--
-- Data for Name: geography_area_relations; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.geography_area_relations (parent_id, child_id, parent_grouping_id, child_grouping_id, active, id) FROM stdin;
\.
COPY c2011_meta_test.geography_area_relations (parent_id, child_id, parent_grouping_id, child_grouping_id, active, id) FROM '/docker-entrypoint-initdb.d/9100.dat';

--
-- Data for Name: geography_areas; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.geography_areas (geography_grouping_id, id, description, geography_code, top_level_geography_id) FROM stdin;
\.
COPY c2011_meta_test.geography_areas (geography_grouping_id, id, description, geography_code, top_level_geography_id) FROM '/docker-entrypoint-initdb.d/9101.dat';

--
-- Data for Name: geography_groupings; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.geography_groupings (id, abbreviation, name, description, geography_area_count, description_extended, top_level_geography_id) FROM stdin;
\.
COPY c2011_meta_test.geography_groupings (id, abbreviation, name, description, geography_area_count, description_extended, top_level_geography_id) FROM '/docker-entrypoint-initdb.d/9102.dat';

--
-- Data for Name: lc4407_0_ew_mrg_rcd_agg; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.lc4407_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, lc4407ew0001, lc4407ew0002, lc4407ew0003, lc4407ew0004, lc4407ew0005, lc4407ew0006, lc4407ew0007, lc4407ew0008, lc4407ew0009, lc4407ew0010, lc4407ew0011, lc4407ew0012, lc4407ew0013, lc4407ew0014, lc4407ew0015, lc4407ew0016, lc4407ew0017, lc4407ew0018, lc4407ew0019, lc4407ew0020, lc4407ew0021, lc4407ew0022, lc4407ew0023, lc4407ew0024, lc4407ew0025, lc4407ew0026, lc4407ew0027, lc4407ew0028, lc4407ew0029, lc4407ew0030, lc4407ew0031, lc4407ew0032, lc4407ew0033, lc4407ew0034, lc4407ew0035, lc4407ew0036, lc4407ew0037, lc4407ew0038, lc4407ew0039, lc4407ew0040, lc4407ew0041, lc4407ew0042, lc4407ew0043, lc4407ew0044, lc4407ew0045, lc4407ew0046, lc4407ew0047, lc4407ew0048, lc4407ew0049, lc4407ew0050, lc4407ew0051, lc4407ew0052, lc4407ew0053, lc4407ew0054, lc4407ew0055, lc4407ew0056, lc4407ew0057, lc4407ew0058, lc4407ew0059, lc4407ew0060, lc4407ew0061, lc4407ew0062, lc4407ew0063, lc4407ew0064, lc4407ew0065, lc4407ew0066, lc4407ew0067, lc4407ew0068, lc4407ew0069, lc4407ew0070, lc4407ew0071, lc4407ew0072, lc4407ew0073, lc4407ew0074, lc4407ew0075, lc4407ew0076, lc4407ew0077, lc4407ew0078, lc4407ew0079, lc4407ew0080, lc4407ew0081, lc4407ew0082, lc4407ew0083, lc4407ew0084, lc4407ew0085, lc4407ew0086, lc4407ew0087, lc4407ew0088, lc4407ew0089, lc4407ew0090, lc4407ew0091, lc4407ew0092, lc4407ew0093, lc4407ew0094, lc4407ew0095, lc4407ew0096, lc4407ew0097, lc4407ew0098, lc4407ew0099, lc4407ew0100, lc4407ew0101, lc4407ew0102, lc4407ew0103, lc4407ew0104, lc4407ew0105, lc4407ew0106, lc4407ew0107, lc4407ew0108, lc4407ew0109, lc4407ew0110, lc4407ew0111, lc4407ew0112, lc4407ew0113, lc4407ew0114, lc4407ew0115, lc4407ew0116, lc4407ew0117, lc4407ew0118, lc4407ew0119, lc4407ew0120, lc4407ew0121, lc4407ew0122, lc4407ew0123, lc4407ew0124, lc4407ew0125, lc4407ew0126, lc4407ew0127, lc4407ew0128, lc4407ew0129, lc4407ew0130, lc4407ew0131, lc4407ew0132, lc4407ew0133, lc4407ew0134, lc4407ew0135, lc4407ew0136, lc4407ew0137, lc4407ew0138, lc4407ew0139, lc4407ew0140, lc4407ew0141, lc4407ew0142, lc4407ew0143, lc4407ew0144, lc4407ew0145, lc4407ew0146, lc4407ew0147, lc4407ew0148, lc4407ew0149, lc4407ew0150, lc4407ew0151, lc4407ew0152, lc4407ew0153, lc4407ew0154, lc4407ew0155, lc4407ew0156, lc4407ew0157, lc4407ew0158, lc4407ew0159, lc4407ew0160, lc4407ew0161, lc4407ew0162, lc4407ew0163, lc4407ew0164, lc4407ew0165, lc4407ew0166, lc4407ew0167, lc4407ew0168, lc4407ew0169, lc4407ew0170, lc4407ew0171, lc4407ew0172, lc4407ew0173, lc4407ew0174, lc4407ew0175, lc4407ew0176, lc4407ew0177, lc4407ew0178, lc4407ew0179, lc4407ew0180, lc4407ew0181, lc4407ew0182, lc4407ew0183, lc4407ew0184, lc4407ew0185, lc4407ew0186, lc4407ew0187, lc4407ew0188, lc4407ew0189, lc4407ew0190, lc4407ew0191, lc4407ew0192, lc4407ew0193, lc4407ew0194, lc4407ew0195, lc4407ew0196, lc4407ew0197, lc4407ew0198, lc4407ew0199, lc4407ew0200, lc4407ew0201, lc4407ew0202, lc4407ew0203, lc4407ew0204, lc4407ew0205, lc4407ew0206, lc4407ew0207, lc4407ew0208, lc4407ew0209, lc4407ew0210) FROM stdin;
\.
COPY c2011_meta_test.lc4407_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, lc4407ew0001, lc4407ew0002, lc4407ew0003, lc4407ew0004, lc4407ew0005, lc4407ew0006, lc4407ew0007, lc4407ew0008, lc4407ew0009, lc4407ew0010, lc4407ew0011, lc4407ew0012, lc4407ew0013, lc4407ew0014, lc4407ew0015, lc4407ew0016, lc4407ew0017, lc4407ew0018, lc4407ew0019, lc4407ew0020, lc4407ew0021, lc4407ew0022, lc4407ew0023, lc4407ew0024, lc4407ew0025, lc4407ew0026, lc4407ew0027, lc4407ew0028, lc4407ew0029, lc4407ew0030, lc4407ew0031, lc4407ew0032, lc4407ew0033, lc4407ew0034, lc4407ew0035, lc4407ew0036, lc4407ew0037, lc4407ew0038, lc4407ew0039, lc4407ew0040, lc4407ew0041, lc4407ew0042, lc4407ew0043, lc4407ew0044, lc4407ew0045, lc4407ew0046, lc4407ew0047, lc4407ew0048, lc4407ew0049, lc4407ew0050, lc4407ew0051, lc4407ew0052, lc4407ew0053, lc4407ew0054, lc4407ew0055, lc4407ew0056, lc4407ew0057, lc4407ew0058, lc4407ew0059, lc4407ew0060, lc4407ew0061, lc4407ew0062, lc4407ew0063, lc4407ew0064, lc4407ew0065, lc4407ew0066, lc4407ew0067, lc4407ew0068, lc4407ew0069, lc4407ew0070, lc4407ew0071, lc4407ew0072, lc4407ew0073, lc4407ew0074, lc4407ew0075, lc4407ew0076, lc4407ew0077, lc4407ew0078, lc4407ew0079, lc4407ew0080, lc4407ew0081, lc4407ew0082, lc4407ew0083, lc4407ew0084, lc4407ew0085, lc4407ew0086, lc4407ew0087, lc4407ew0088, lc4407ew0089, lc4407ew0090, lc4407ew0091, lc4407ew0092, lc4407ew0093, lc4407ew0094, lc4407ew0095, lc4407ew0096, lc4407ew0097, lc4407ew0098, lc4407ew0099, lc4407ew0100, lc4407ew0101, lc4407ew0102, lc4407ew0103, lc4407ew0104, lc4407ew0105, lc4407ew0106, lc4407ew0107, lc4407ew0108, lc4407ew0109, lc4407ew0110, lc4407ew0111, lc4407ew0112, lc4407ew0113, lc4407ew0114, lc4407ew0115, lc4407ew0116, lc4407ew0117, lc4407ew0118, lc4407ew0119, lc4407ew0120, lc4407ew0121, lc4407ew0122, lc4407ew0123, lc4407ew0124, lc4407ew0125, lc4407ew0126, lc4407ew0127, lc4407ew0128, lc4407ew0129, lc4407ew0130, lc4407ew0131, lc4407ew0132, lc4407ew0133, lc4407ew0134, lc4407ew0135, lc4407ew0136, lc4407ew0137, lc4407ew0138, lc4407ew0139, lc4407ew0140, lc4407ew0141, lc4407ew0142, lc4407ew0143, lc4407ew0144, lc4407ew0145, lc4407ew0146, lc4407ew0147, lc4407ew0148, lc4407ew0149, lc4407ew0150, lc4407ew0151, lc4407ew0152, lc4407ew0153, lc4407ew0154, lc4407ew0155, lc4407ew0156, lc4407ew0157, lc4407ew0158, lc4407ew0159, lc4407ew0160, lc4407ew0161, lc4407ew0162, lc4407ew0163, lc4407ew0164, lc4407ew0165, lc4407ew0166, lc4407ew0167, lc4407ew0168, lc4407ew0169, lc4407ew0170, lc4407ew0171, lc4407ew0172, lc4407ew0173, lc4407ew0174, lc4407ew0175, lc4407ew0176, lc4407ew0177, lc4407ew0178, lc4407ew0179, lc4407ew0180, lc4407ew0181, lc4407ew0182, lc4407ew0183, lc4407ew0184, lc4407ew0185, lc4407ew0186, lc4407ew0187, lc4407ew0188, lc4407ew0189, lc4407ew0190, lc4407ew0191, lc4407ew0192, lc4407ew0193, lc4407ew0194, lc4407ew0195, lc4407ew0196, lc4407ew0197, lc4407ew0198, lc4407ew0199, lc4407ew0200, lc4407ew0201, lc4407ew0202, lc4407ew0203, lc4407ew0204, lc4407ew0205, lc4407ew0206, lc4407ew0207, lc4407ew0208, lc4407ew0209, lc4407ew0210) FROM '/docker-entrypoint-initdb.d/9110.dat';

--
-- Data for Name: st606_0_ew_mrg_rcd_agg; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.st606_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, st606ewla0001, st606ewla0002, st606ewla0003, st606ewla0004, st606ewla0005, st606ewla0006, st606ewla0007, st606ewla0008, st606ewla0009, st606ewla0010) FROM stdin;
\.
COPY c2011_meta_test.st606_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, st606ewla0001, st606ewla0002, st606ewla0003, st606ewla0004, st606ewla0005, st606ewla0006, st606ewla0007, st606ewla0008, st606ewla0009, st606ewla0010) FROM '/docker-entrypoint-initdb.d/9111.dat';

--
-- Data for Name: themes; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.themes (id, theme, description) FROM stdin;
\.
COPY c2011_meta_test.themes (id, theme, description) FROM '/docker-entrypoint-initdb.d/9103.dat';

--
-- Data for Name: top_level_geographies; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.top_level_geographies (geography_type_id, id, description, geography_code, hidden_from_ui) FROM stdin;
\.
COPY c2011_meta_test.top_level_geographies (geography_type_id, id, description, geography_code, hidden_from_ui) FROM '/docker-entrypoint-initdb.d/9104.dat';

--
-- Data for Name: topic_combinations; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.topic_combinations (id, variable_combination_count, ordinal, combination, geography_combinations, geography_groupings, top_level_geographies, title, universe, units, theme_id) FROM stdin;
\.
COPY c2011_meta_test.topic_combinations (id, variable_combination_count, ordinal, combination, geography_combinations, geography_groupings, top_level_geographies, title, universe, units, theme_id) FROM '/docker-entrypoint-initdb.d/9105.dat';

--
-- Data for Name: topics; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.topics (id, abbreviation, name, description, ordinal, top_level_geography_coverage) FROM stdin;
\.
COPY c2011_meta_test.topics (id, abbreviation, name, description, ordinal, top_level_geography_coverage) FROM '/docker-entrypoint-initdb.d/9106.dat';

--
-- Data for Name: variable_combinations; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.variable_combinations (id, table_column_name, combination, topic_combination, topic_variable_combination, geography_combination, geography_groupings, description, table_name, top_level_geography) FROM stdin;
\.
COPY c2011_meta_test.variable_combinations (id, table_column_name, combination, topic_combination, topic_variable_combination, geography_combination, geography_groupings, description, table_name, top_level_geography) FROM '/docker-entrypoint-initdb.d/9108.dat';

--
-- Data for Name: variables; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.variables (topic_id, id, description, ordinal, parent_code, full_description) FROM stdin;
\.
COPY c2011_meta_test.variables (topic_id, id, description, ordinal, parent_code, full_description) FROM '/docker-entrypoint-initdb.d/9107.dat';

--
-- Data for Name: wd501_0_ew_mrg_rcd_agg; Type: TABLE DATA; Schema: c2011_meta_test; Owner: postgres
--

COPY c2011_meta_test.wd501_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, wd501ew0001, wd501ew0002, wd501ew0003, wd501ew0004, wd501ew0005, wd501ew0006, wd501ew0007, wd501ew0008) FROM stdin;
\.
COPY c2011_meta_test.wd501_0_ew_mrg_rcd_agg (geocodeid, cl_id, nsi_area_id, wd501ew0001, wd501ew0002, wd501ew0003, wd501ew0004, wd501ew0005, wd501ew0006, wd501ew0007, wd501ew0008) FROM '/docker-entrypoint-initdb.d/9112.dat';

--
-- Name: geography_areas geography_areas_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.geography_areas
    ADD CONSTRAINT geography_areas_pk PRIMARY KEY (id);


--
-- Name: geography_groupings geography_groupings_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.geography_groupings
    ADD CONSTRAINT geography_groupings_pk PRIMARY KEY (id);


--
-- Name: themes themes_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.themes
    ADD CONSTRAINT themes_pk PRIMARY KEY (id);


--
-- Name: top_level_geographies top_level_geographies_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.top_level_geographies
    ADD CONSTRAINT top_level_geographies_pk PRIMARY KEY (id);


--
-- Name: topic_combinations topic_combinations_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.topic_combinations
    ADD CONSTRAINT topic_combinations_pk PRIMARY KEY (id);


--
-- Name: topics topics_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.topics
    ADD CONSTRAINT topics_pk PRIMARY KEY (id);


--
-- Name: variable_combinations variable_combinations_pk_1; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.variable_combinations
    ADD CONSTRAINT variable_combinations_pk_1 PRIMARY KEY (id);


--
-- Name: variables variables_pk; Type: CONSTRAINT; Schema: c2011_meta_test; Owner: postgres
--

ALTER TABLE ONLY c2011_meta_test.variables
    ADD CONSTRAINT variables_pk PRIMARY KEY (id);


--
-- Name: geography_groupings_id_idx; Type: INDEX; Schema: c2011_meta_test; Owner: postgres
--

CREATE UNIQUE INDEX geography_groupings_id_idx ON c2011_meta_test.geography_groupings USING btree (id);


--
-- Name: top_level_geographies_id_idx; Type: INDEX; Schema: c2011_meta_test; Owner: postgres
--

CREATE UNIQUE INDEX top_level_geographies_id_idx ON c2011_meta_test.top_level_geographies USING btree (id);


--
-- Name: topics_id_idx; Type: INDEX; Schema: c2011_meta_test; Owner: postgres
--

CREATE UNIQUE INDEX topics_id_idx ON c2011_meta_test.topics USING btree (id);


--
-- Name: variables_id_idx; Type: INDEX; Schema: c2011_meta_test; Owner: postgres
--

CREATE UNIQUE INDEX variables_id_idx ON c2011_meta_test.variables USING btree (id);


--
-- PostgreSQL database dump complete
--

