--
--

-- Started on 2010-08-17 11:53:58 EDT

SET escape_string_warning = off;




--
-- TOC entry 1596 (class 1259 OID 23838)
-- Dependencies: 3
-- Name: auth_group; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO demo;

--
-- TOC entry 1595 (class 1259 OID 23836)
-- Dependencies: 3 1596
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO demo;

--
-- TOC entry 2135 (class 0 OID 0)
-- Dependencies: 1595
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- TOC entry 1594 (class 1259 OID 23823)
-- Dependencies: 3
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO demo;

--
-- TOC entry 1593 (class 1259 OID 23821)
-- Dependencies: 1594 3
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO demo;

--
-- TOC entry 2137 (class 0 OID 0)
-- Dependencies: 1593
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- TOC entry 1604 (class 1259 OID 23903)
-- Dependencies: 3
-- Name: auth_message; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_message (
    id integer NOT NULL,
    user_id integer NOT NULL,
    message text NOT NULL
);


ALTER TABLE public.auth_message OWNER TO demo;

--
-- TOC entry 1603 (class 1259 OID 23901)
-- Dependencies: 3 1604
-- Name: auth_message_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_message_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_message_id_seq OWNER TO demo;

--
-- TOC entry 2139 (class 0 OID 0)
-- Dependencies: 1603
-- Name: auth_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_message_id_seq OWNED BY auth_message.id;


--
-- TOC entry 1592 (class 1259 OID 23813)
-- Dependencies: 3
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO demo;

--
-- TOC entry 1591 (class 1259 OID 23811)
-- Dependencies: 3 1592
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO demo;

--
-- TOC entry 2141 (class 0 OID 0)
-- Dependencies: 1591
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;

--
-- TOC entry 1600 (class 1259 OID 23868)
-- Dependencies: 3
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO demo;

--
-- TOC entry 1599 (class 1259 OID 23866)
-- Dependencies: 3 1600
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_user_groups_id_seq OWNER TO demo;

--
-- TOC entry 2143 (class 0 OID 0)
-- Dependencies: 1599
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


--
-- TOC entry 1601 (class 1259 OID 23881)
-- Dependencies: 1602 3
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_user_id_seq OWNER TO demo;

--
-- TOC entry 2145 (class 0 OID 0)
-- Dependencies: 1601
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- TOC entry 1598 (class 1259 OID 23853)
-- Dependencies: 3
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO demo;

--
-- TOC entry 1597 (class 1259 OID 23851)
-- Dependencies: 1598 3
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO demo;

--
-- TOC entry 2147 (class 0 OID 0)
-- Dependencies: 1597
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- TOC entry 1647 (class 1259 OID 24242)
-- Dependencies: 1956 3
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    content_type_id integer,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO demo;

--
-- TOC entry 1646 (class 1259 OID 24240)
-- Dependencies: 1647 3
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.django_admin_log_id_seq OWNER TO demo;

--
-- TOC entry 2149 (class 0 OID 0)
-- Dependencies: 1646
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- TOC entry 1606 (class 1259 OID 23919)
-- Dependencies: 3
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO demo;

--
-- TOC entry 1605 (class 1259 OID 23917)
-- Dependencies: 3 1606
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.django_content_type_id_seq OWNER TO demo;

--
-- TOC entry 2151 (class 0 OID 0)
-- Dependencies: 1605
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;

--
-- TOC entry 1609 (class 1259 OID 23942)
-- Dependencies: 3
-- Name: django_site; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE django_site (
    id integer NOT NULL,
    domain character varying(100) NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.django_site OWNER TO demo;

--
-- TOC entry 1608 (class 1259 OID 23940)
-- Dependencies: 3 1609
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE django_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.django_site_id_seq OWNER TO demo;

--
-- TOC entry 2153 (class 0 OID 0)
-- Dependencies: 1608
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE django_site_id_seq OWNED BY django_site.id;


--
-- TOC entry 1641 (class 1259 OID 24187)
-- Dependencies: 1952 3
-- Name: mcconfig_application; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_application (
    id integer NOT NULL,
    name text NOT NULL,
    template text NOT NULL,
    type integer NOT NULL,
    CONSTRAINT mcconfig_application_type_check CHECK ((type >= 0))
);


ALTER TABLE public.mcconfig_application OWNER TO demo;

--
-- TOC entry 1640 (class 1259 OID 24185)
-- Dependencies: 3 1641
-- Name: mcconfig_application_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_application_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_application_id_seq OWNER TO demo;

--
-- TOC entry 2155 (class 0 OID 0)
-- Dependencies: 1640
-- Name: mcconfig_application_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_application_id_seq OWNED BY mcconfig_application.id;


--
-- TOC entry 1643 (class 1259 OID 24201)
-- Dependencies: 3
-- Name: mcconfig_applicationwidget; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_applicationwidget (
    id integer NOT NULL,
    application_id integer NOT NULL,
    widget_id integer NOT NULL,
    "order" integer
);


ALTER TABLE public.mcconfig_applicationwidget OWNER TO demo;

--
-- TOC entry 1642 (class 1259 OID 24199)
-- Dependencies: 3 1643
-- Name: mcconfig_applicationwidget_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_applicationwidget_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_applicationwidget_id_seq OWNER TO demo;

--
-- TOC entry 2157 (class 0 OID 0)
-- Dependencies: 1642
-- Name: mcconfig_applicationwidget_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_applicationwidget_id_seq OWNED BY mcconfig_applicationwidget.id;


--
-- TOC entry 1615 (class 1259 OID 23980)
-- Dependencies: 3
-- Name: mcconfig_datastore; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_datastore (
    id integer NOT NULL,
    service_id integer NOT NULL,
    name text NOT NULL,
    layers text
);


ALTER TABLE public.mcconfig_datastore OWNER TO demo;

--
-- TOC entry 1614 (class 1259 OID 23978)
-- Dependencies: 3 1615
-- Name: mcconfig_datastore_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_datastore_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_datastore_id_seq OWNER TO demo;

--
-- TOC entry 2159 (class 0 OID 0)
-- Dependencies: 1614
-- Name: mcconfig_datastore_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_datastore_id_seq OWNED BY mcconfig_datastore.id;


--
-- TOC entry 1617 (class 1259 OID 23998)
-- Dependencies: 3
-- Name: mcconfig_datastoreoption; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_datastoreoption (
    id integer NOT NULL,
    datastore_id integer NOT NULL,
    name text NOT NULL,
    value text
);


ALTER TABLE public.mcconfig_datastoreoption OWNER TO demo;

--
-- TOC entry 1616 (class 1259 OID 23996)
-- Dependencies: 1617 3
-- Name: mcconfig_datastoreoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_datastoreoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_datastoreoption_id_seq OWNER TO demo;

--
-- TOC entry 2161 (class 0 OID 0)
-- Dependencies: 1616
-- Name: mcconfig_datastoreoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_datastoreoption_id_seq OWNED BY mcconfig_datastoreoption.id;

--
-- TOC entry 1618 (class 1259 OID 24012)
-- Dependencies: 3 1619
-- Name: mcconfig_field_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_field_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_field_id_seq OWNER TO demo;

--
-- TOC entry 2163 (class 0 OID 0)
-- Dependencies: 1618
-- Name: mcconfig_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_field_id_seq OWNED BY mcconfig_field.id;


--
-- TOC entry 1621 (class 1259 OID 24027)
-- Dependencies: 3
-- Name: mcconfig_fieldoption; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_fieldoption (
    id integer NOT NULL,
    field_id integer NOT NULL,
    name text NOT NULL,
    value text
);


ALTER TABLE public.mcconfig_fieldoption OWNER TO demo;

--
-- TOC entry 1620 (class 1259 OID 24025)
-- Dependencies: 1621 3
-- Name: mcconfig_fieldoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_fieldoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_fieldoption_id_seq OWNER TO demo;

--
-- TOC entry 2165 (class 0 OID 0)
-- Dependencies: 1620
-- Name: mcconfig_fieldoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_fieldoption_id_seq OWNED BY mcconfig_fieldoption.id;


--
-- TOC entry 1635 (class 1259 OID 24140)
-- Dependencies: 3
-- Name: mcconfig_mapcontext; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_mapcontext (
    id integer NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.mcconfig_mapcontext OWNER TO demo;

--
-- TOC entry 1634 (class 1259 OID 24138)
-- Dependencies: 1635 3
-- Name: mcconfig_mapcontext_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_mapcontext_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_mapcontext_id_seq OWNER TO demo;

--
-- TOC entry 2167 (class 0 OID 0)
-- Dependencies: 1634
-- Name: mcconfig_mapcontext_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_mapcontext_id_seq OWNED BY mcconfig_mapcontext.id;


--
-- TOC entry 1637 (class 1259 OID 24153)
-- Dependencies: 3
-- Name: mcconfig_mapcontextoption; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_mapcontextoption (
    id integer NOT NULL,
    mapcontext_id integer NOT NULL,
    name text NOT NULL,
    value text
);


ALTER TABLE public.mcconfig_mapcontextoption OWNER TO demo;

--
-- TOC entry 1636 (class 1259 OID 24151)
-- Dependencies: 1637 3
-- Name: mcconfig_mapcontextoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_mapcontextoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_mapcontextoption_id_seq OWNER TO demo;

--
-- TOC entry 2169 (class 0 OID 0)
-- Dependencies: 1636
-- Name: mcconfig_mapcontextoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_mapcontextoption_id_seq OWNED BY mcconfig_mapcontextoption.id;


--
-- TOC entry 1639 (class 1259 OID 24169)
-- Dependencies: 3
-- Name: mcconfig_mapcontextresource; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_mapcontextresource (
    id integer NOT NULL,
    mapcontext_id integer NOT NULL,
    resource_id integer NOT NULL,
    "order" integer
);


ALTER TABLE public.mcconfig_mapcontextresource OWNER TO demo;

--
-- TOC entry 1638 (class 1259 OID 24167)
-- Dependencies: 1639 3
-- Name: mcconfig_mapcontextresource_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_mapcontextresource_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_mapcontextresource_id_seq OWNER TO demo;

--
-- TOC entry 2171 (class 0 OID 0)
-- Dependencies: 1638
-- Name: mcconfig_mapcontextresource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_mapcontextresource_id_seq OWNED BY mcconfig_mapcontextresource.id;

--
-- TOC entry 1624 (class 1259 OID 24056)
-- Dependencies: 1625 3
-- Name: mcconfig_resource_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_resource_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_resource_id_seq OWNER TO demo;

--
-- TOC entry 2173 (class 0 OID 0)
-- Dependencies: 1624
-- Name: mcconfig_resource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_resource_id_seq OWNED BY mcconfig_resource.id;


--
-- TOC entry 1623 (class 1259 OID 24043)
-- Dependencies: 3
-- Name: mcconfig_resourcedatastore; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_resourcedatastore (
    id integer NOT NULL,
    resource_id integer NOT NULL,
    datastore_id integer NOT NULL
);


ALTER TABLE public.mcconfig_resourcedatastore OWNER TO demo;

--
-- TOC entry 1622 (class 1259 OID 24041)
-- Dependencies: 3 1623
-- Name: mcconfig_resourcedatastore_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_resourcedatastore_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_resourcedatastore_id_seq OWNER TO demo;

--
-- TOC entry 2175 (class 0 OID 0)
-- Dependencies: 1622
-- Name: mcconfig_resourcedatastore_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_resourcedatastore_id_seq OWNED BY mcconfig_resourcedatastore.id;


--
-- TOC entry 1627 (class 1259 OID 24076)
-- Dependencies: 3
-- Name: mcconfig_resourcefield; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_resourcefield (
    id integer NOT NULL,
    resource_id integer NOT NULL,
    field_id integer NOT NULL,
    "order" integer
);


ALTER TABLE public.mcconfig_resourcefield OWNER TO demo;

--
-- TOC entry 1626 (class 1259 OID 24074)
-- Dependencies: 1627 3
-- Name: mcconfig_resourcefield_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_resourcefield_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_resourcefield_id_seq OWNER TO demo;

--
-- TOC entry 2177 (class 0 OID 0)
-- Dependencies: 1626
-- Name: mcconfig_resourcefield_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_resourcefield_id_seq OWNED BY mcconfig_resourcefield.id;

--
-- TOC entry 1628 (class 1259 OID 24092)
-- Dependencies: 3 1629
-- Name: mcconfig_resourceoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_resourceoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_resourceoption_id_seq OWNER TO demo;

--
-- TOC entry 2179 (class 0 OID 0)
-- Dependencies: 1628
-- Name: mcconfig_resourceoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_resourceoption_id_seq OWNED BY mcconfig_resourceoption.id;


--
-- TOC entry 1611 (class 1259 OID 23950)
-- Dependencies: 1935 3
-- Name: mcconfig_service; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_service (
    id integer NOT NULL,
    name text NOT NULL,
    source text NOT NULL,
    type integer NOT NULL,
    CONSTRAINT mcconfig_service_type_check CHECK ((type >= 0))
);


ALTER TABLE public.mcconfig_service OWNER TO demo;

--
-- TOC entry 1610 (class 1259 OID 23948)
-- Dependencies: 3 1611
-- Name: mcconfig_service_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_service_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_service_id_seq OWNER TO demo;

--
-- TOC entry 2181 (class 0 OID 0)
-- Dependencies: 1610
-- Name: mcconfig_service_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_service_id_seq OWNED BY mcconfig_service.id;


--
-- TOC entry 1613 (class 1259 OID 23964)
-- Dependencies: 3
-- Name: mcconfig_serviceoption; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_serviceoption (
    id integer NOT NULL,
    service_id integer NOT NULL,
    name text NOT NULL,
    value text
);


ALTER TABLE public.mcconfig_serviceoption OWNER TO demo;

--
-- TOC entry 1612 (class 1259 OID 23962)
-- Dependencies: 1613 3
-- Name: mcconfig_serviceoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_serviceoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_serviceoption_id_seq OWNER TO demo;

--
-- TOC entry 2183 (class 0 OID 0)
-- Dependencies: 1612
-- Name: mcconfig_serviceoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_serviceoption_id_seq OWNED BY mcconfig_serviceoption.id;


--
-- TOC entry 1645 (class 1259 OID 24219)
-- Dependencies: 3
-- Name: mcconfig_session; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_session (
    id integer NOT NULL,
    name text NOT NULL,
    application_id integer NOT NULL,
    mapcontext_id integer NOT NULL
);


ALTER TABLE public.mcconfig_session OWNER TO demo;

--
-- TOC entry 1644 (class 1259 OID 24217)
-- Dependencies: 1645 3
-- Name: mcconfig_session_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_session_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_session_id_seq OWNER TO demo;

--
-- TOC entry 2185 (class 0 OID 0)
-- Dependencies: 1644
-- Name: mcconfig_session_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_session_id_seq OWNED BY mcconfig_session.id;


--
-- TOC entry 1631 (class 1259 OID 24110)
-- Dependencies: 1946 3
-- Name: mcconfig_widget; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_widget (
    id integer NOT NULL,
    name text NOT NULL,
    type integer NOT NULL,
    CONSTRAINT mcconfig_widget_type_check CHECK ((type >= 0))
);


ALTER TABLE public.mcconfig_widget OWNER TO demo;

--
-- TOC entry 1630 (class 1259 OID 24108)
-- Dependencies: 1631 3
-- Name: mcconfig_widget_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_widget_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_widget_id_seq OWNER TO demo;

--
-- TOC entry 2187 (class 0 OID 0)
-- Dependencies: 1630
-- Name: mcconfig_widget_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_widget_id_seq OWNED BY mcconfig_widget.id;


--
-- TOC entry 1633 (class 1259 OID 24124)
-- Dependencies: 3
-- Name: mcconfig_widgetoption; Type: TABLE; Schema: public; Owner: demo; Tablespace: 
--

CREATE TABLE mcconfig_widgetoption (
    id integer NOT NULL,
    widget_id integer NOT NULL,
    name text NOT NULL,
    value text,
    "order" integer
);


ALTER TABLE public.mcconfig_widgetoption OWNER TO demo;

--
-- TOC entry 1632 (class 1259 OID 24122)
-- Dependencies: 1633 3
-- Name: mcconfig_widgetoption_id_seq; Type: SEQUENCE; Schema: public; Owner: demo
--

CREATE SEQUENCE mcconfig_widgetoption_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.mcconfig_widgetoption_id_seq OWNER TO demo;

--
-- TOC entry 2189 (class 0 OID 0)
-- Dependencies: 1632
-- Name: mcconfig_widgetoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: demo
--

ALTER SEQUENCE mcconfig_widgetoption_id_seq OWNED BY mcconfig_widgetoption.id;


--
-- TOC entry 1927 (class 2604 OID 23841)
-- Dependencies: 1595 1596 1596
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);


--
-- TOC entry 1926 (class 2604 OID 23826)
-- Dependencies: 1594 1593 1594
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- TOC entry 1931 (class 2604 OID 23906)
-- Dependencies: 1603 1604 1604
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_message ALTER COLUMN id SET DEFAULT nextval('auth_message_id_seq'::regclass);


--
-- TOC entry 1925 (class 2604 OID 23816)
-- Dependencies: 1592 1591 1592
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);


--
-- TOC entry 1929 (class 2604 OID 23871)
-- Dependencies: 1599 1600 1600
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- TOC entry 1928 (class 2604 OID 23856)
-- Dependencies: 1598 1597 1598
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- TOC entry 1955 (class 2604 OID 24245)
-- Dependencies: 1646 1647 1647
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- TOC entry 1932 (class 2604 OID 23922)
-- Dependencies: 1605 1606 1606
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- TOC entry 1933 (class 2604 OID 23945)
-- Dependencies: 1609 1608 1609
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE django_site ALTER COLUMN id SET DEFAULT nextval('django_site_id_seq'::regclass);


--
-- TOC entry 1951 (class 2604 OID 24190)
-- Dependencies: 1640 1641 1641
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_application ALTER COLUMN id SET DEFAULT nextval('mcconfig_application_id_seq'::regclass);


--
-- TOC entry 1953 (class 2604 OID 24204)
-- Dependencies: 1643 1642 1643
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_applicationwidget ALTER COLUMN id SET DEFAULT nextval('mcconfig_applicationwidget_id_seq'::regclass);


--
-- TOC entry 1937 (class 2604 OID 23983)
-- Dependencies: 1614 1615 1615
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_datastore ALTER COLUMN id SET DEFAULT nextval('mcconfig_datastore_id_seq'::regclass);


--
-- TOC entry 1938 (class 2604 OID 24001)
-- Dependencies: 1617 1616 1617
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_datastoreoption ALTER COLUMN id SET DEFAULT nextval('mcconfig_datastoreoption_id_seq'::regclass);


--
-- TOC entry 1940 (class 2604 OID 24030)
-- Dependencies: 1620 1621 1621
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_fieldoption ALTER COLUMN id SET DEFAULT nextval('mcconfig_fieldoption_id_seq'::regclass);


--
-- TOC entry 1948 (class 2604 OID 24143)
-- Dependencies: 1635 1634 1635
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_mapcontext ALTER COLUMN id SET DEFAULT nextval('mcconfig_mapcontext_id_seq'::regclass);


--
-- TOC entry 1949 (class 2604 OID 24156)
-- Dependencies: 1636 1637 1637
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_mapcontextoption ALTER COLUMN id SET DEFAULT nextval('mcconfig_mapcontextoption_id_seq'::regclass);


--
-- TOC entry 1950 (class 2604 OID 24172)
-- Dependencies: 1639 1638 1639
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_mapcontextresource ALTER COLUMN id SET DEFAULT nextval('mcconfig_mapcontextresource_id_seq'::regclass);


--
-- TOC entry 1941 (class 2604 OID 24046)
-- Dependencies: 1622 1623 1623
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_resourcedatastore ALTER COLUMN id SET DEFAULT nextval('mcconfig_resourcedatastore_id_seq'::regclass);


--
-- TOC entry 1943 (class 2604 OID 24079)
-- Dependencies: 1627 1626 1627
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_resourcefield ALTER COLUMN id SET DEFAULT nextval('mcconfig_resourcefield_id_seq'::regclass);


--
-- TOC entry 1934 (class 2604 OID 23953)
-- Dependencies: 1610 1611 1611
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_service ALTER COLUMN id SET DEFAULT nextval('mcconfig_service_id_seq'::regclass);


--
-- TOC entry 1936 (class 2604 OID 23967)
-- Dependencies: 1613 1612 1613
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_serviceoption ALTER COLUMN id SET DEFAULT nextval('mcconfig_serviceoption_id_seq'::regclass);


--
-- TOC entry 1954 (class 2604 OID 24222)
-- Dependencies: 1644 1645 1645
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_session ALTER COLUMN id SET DEFAULT nextval('mcconfig_session_id_seq'::regclass);


--
-- TOC entry 1945 (class 2604 OID 24113)
-- Dependencies: 1630 1631 1631
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_widget ALTER COLUMN id SET DEFAULT nextval('mcconfig_widget_id_seq'::regclass);


--
-- TOC entry 1947 (class 2604 OID 24127)
-- Dependencies: 1633 1632 1633
-- Name: id; Type: DEFAULT; Schema: public; Owner: demo
--

ALTER TABLE mcconfig_widgetoption ALTER COLUMN id SET DEFAULT nextval('mcconfig_widgetoption_id_seq'::regclass);


--
-- TOC entry 2103 (class 0 OID 23838)
-- Dependencies: 1596
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_group (id, name) FROM stdin;
\.


--
-- TOC entry 2102 (class 0 OID 23823)
-- Dependencies: 1594
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- TOC entry 2107 (class 0 OID 23903)
-- Dependencies: 1604
-- Data for Name: auth_message; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_message (id, user_id, message) FROM stdin;
\.


--
-- TOC entry 2101 (class 0 OID 23813)
-- Dependencies: 1592
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add permission	1	add_permission
2	Can change permission	1	change_permission
3	Can delete permission	1	delete_permission
4	Can add group	2	add_group
5	Can change group	2	change_group
6	Can delete group	2	delete_group
7	Can add user	3	add_user
8	Can change user	3	change_user
9	Can delete user	3	delete_user
10	Can add message	4	add_message
11	Can change message	4	change_message
12	Can delete message	4	delete_message
13	Can add content type	5	add_contenttype
14	Can change content type	5	change_contenttype
15	Can delete content type	5	delete_contenttype
16	Can add session	6	add_session
17	Can change session	6	change_session
18	Can delete session	6	delete_session
19	Can add site	7	add_site
20	Can change site	7	change_site
21	Can delete site	7	delete_site
22	Can add service	8	add_service
23	Can change service	8	change_service
24	Can delete service	8	delete_service
25	Can add service option	9	add_serviceoption
26	Can change service option	9	change_serviceoption
27	Can delete service option	9	delete_serviceoption
28	Can add datastore	10	add_datastore
29	Can change datastore	10	change_datastore
30	Can delete datastore	10	delete_datastore
31	Can add datastore option	11	add_datastoreoption
32	Can change datastore option	11	change_datastoreoption
33	Can delete datastore option	11	delete_datastoreoption
34	Can add field	12	add_field
35	Can change field	12	change_field
36	Can delete field	12	delete_field
37	Can add field option	13	add_fieldoption
38	Can change field option	13	change_fieldoption
39	Can delete field option	13	delete_fieldoption
40	Can add resource	14	add_resource
41	Can change resource	14	change_resource
42	Can delete resource	14	delete_resource
43	Can add resource field	15	add_resourcefield
44	Can change resource field	15	change_resourcefield
45	Can delete resource field	15	delete_resourcefield
46	Can add resource option	16	add_resourceoption
47	Can change resource option	16	change_resourceoption
48	Can delete resource option	16	delete_resourceoption
49	Can add widget	17	add_widget
50	Can change widget	17	change_widget
51	Can delete widget	17	delete_widget
52	Can add widget option	18	add_widgetoption
53	Can change widget option	18	change_widgetoption
54	Can delete widget option	18	delete_widgetoption
55	Can add map context	19	add_mapcontext
56	Can change map context	19	change_mapcontext
57	Can delete map context	19	delete_mapcontext
58	Can add map context option	20	add_mapcontextoption
59	Can change map context option	20	change_mapcontextoption
60	Can delete map context option	20	delete_mapcontextoption
61	Can add map context resource	21	add_mapcontextresource
62	Can change map context resource	21	change_mapcontextresource
63	Can delete map context resource	21	delete_mapcontextresource
64	Can add application	22	add_application
65	Can change application	22	change_application
66	Can delete application	22	delete_application
67	Can add application widget	23	add_applicationwidget
68	Can change application widget	23	change_applicationwidget
69	Can delete application widget	23	delete_applicationwidget
70	Can add session	24	add_session
71	Can change session	24	change_session
72	Can delete session	24	delete_session
73	Can add log entry	25	add_logentry
74	Can change log entry	25	change_logentry
75	Can delete log entry	25	delete_logentry
\.


--
-- TOC entry 2105 (class 0 OID 23868)
-- Dependencies: 1600
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- TOC entry 2104 (class 0 OID 23853)
-- Dependencies: 1598
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- TOC entry 2129 (class 0 OID 24242)
-- Dependencies: 1647
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY django_admin_log (id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message) FROM stdin;
\.


--
-- TOC entry 2108 (class 0 OID 23919)
-- Dependencies: 1606
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY django_content_type (id, name, app_label, model) FROM stdin;
22	application	mcconfig	application
23	application widget	mcconfig	applicationwidget
5	content type	contenttypes	contenttype
10	datastore	mcconfig	datastore
11	datastore option	mcconfig	datastoreoption
12	field	mcconfig	field
13	field option	mcconfig	fieldoption
2	group	auth	group
25	log entry	admin	logentry
19	map context	mcconfig	mapcontext
20	map context option	mcconfig	mapcontextoption
21	map context resource	mcconfig	mapcontextresource
4	message	auth	message
1	permission	auth	permission
14	resource	mcconfig	resource
15	resource field	mcconfig	resourcefield
16	resource option	mcconfig	resourceoption
8	service	mcconfig	service
9	service option	mcconfig	serviceoption
6	session	sessions	session
24	session	mcconfig	session
7	site	sites	site
3	user	auth	user
17	widget	mcconfig	widget
18	widget option	mcconfig	widgetoption
\.


--
-- TOC entry 2110 (class 0 OID 23942)
-- Dependencies: 1609
-- Data for Name: django_site; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY django_site (id, domain, name) FROM stdin;
1	example.com	example.com
\.


--
-- TOC entry 2126 (class 0 OID 24187)
-- Dependencies: 1641
-- Data for Name: mcconfig_application; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_application (id, name, template, type) FROM stdin;
1	AP_Default	template.xslt	1
2	Dummy	template.xslt	1
\.


--
-- TOC entry 2127 (class 0 OID 24201)
-- Dependencies: 1643
-- Data for Name: mcconfig_applicationwidget; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_applicationwidget (id, application_id, widget_id, "order") FROM stdin;
1	1	1	1
2	1	2	2
3	2	3	3
4	1	4	4
5	1	5	5
6	1	6	6
7	1	7	7
8	1	8	8
9	1	9	9
10	1	10	10
11	1	11	11
12	2	12	12
13	1	13	13
14	1	14	14
15	1	15	15
16	1	16	16
\.


--
-- TOC entry 2113 (class 0 OID 23980)
-- Dependencies: 1615
-- Data for Name: mcconfig_datastore; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_datastore (id, service_id, name, layers) FROM stdin;
1	1	DS_OpenStreetMap	\N
2	2	DS_WMS_dev4g_gmap_popp	popplace
3	3	DS_TC_dev4g_gmap_base	gmap_base
4	4	DS_FS_dev4g_gmap_popp	gmap_popp
5	2	DS_WMS_dev4g_gmap_road	road
6	5	DS_WMS_dev4g_bdga_popp	BDGA_HABIT_P_POINT
8	2	DS_WMS_dev4g_gmap_park	park
7	2	DS_WMS_dev4g_gmap_prov	prov_bound
9	3	DS_TC_dev4g_gmap_prov	gmap_prov
\.


--
-- TOC entry 2114 (class 0 OID 23998)
-- Dependencies: 1617
-- Data for Name: mcconfig_datastoreoption; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_datastoreoption (id, datastore_id, name, value) FROM stdin;
\.


--
-- TOC entry 2116 (class 0 OID 24027)
-- Dependencies: 1621
-- Data for Name: mcconfig_fieldoption; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_fieldoption (id, field_id, name, value) FROM stdin;
1	1	type	string
2	1	width	200
3	2	type	float
4	2	width	150
5	3	type	float
6	3	width	150
7	4	type	integer
8	4	width	50
9	5	type	string
10	5	width	200
11	6	type	integer
12	6	width	50
13	7	string	100
14	7	width	150
15	8	type	string
16	8	width	100
17	1	selectType	key
18	2	selectType	value
19	3	selectType	value
20	4	selectType	key
21	5	selectType	value
22	6	selectType	keyValue
23	7	selectType	keyValue
24	8	selectType	false
25	5	filter	#%
\.


--
-- TOC entry 2123 (class 0 OID 24140)
-- Dependencies: 1635
-- Data for Name: mcconfig_mapcontext; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_mapcontext (id, name) FROM stdin;
1	MC_Default
\.


--
-- TOC entry 2124 (class 0 OID 24153)
-- Dependencies: 1637
-- Data for Name: mcconfig_mapcontextoption; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_mapcontextoption (id, mapcontext_id, name, value) FROM stdin;
1	1	projection	EPSG:42304
3	1	units	m
4	1	maxextent	-2751549.750,-935783.250,3582850.250,4674119.750
6	1	maxresolution	156543.0339
7	1	numzoomlevels	5
2	1	alloverlays	false
5	1	scales	20000000,10000000,4000000,1000000,500000
\.


--
-- TOC entry 2125 (class 0 OID 24169)
-- Dependencies: 1639
-- Data for Name: mcconfig_mapcontextresource; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_mapcontextresource (id, mapcontext_id, resource_id, "order") FROM stdin;
2	1	3	1
7	1	7	2
6	1	6	3
3	1	4	4
4	1	2	5
5	1	5	6
\.


--
-- TOC entry 2117 (class 0 OID 24043)
-- Dependencies: 1623
-- Data for Name: mcconfig_resourcedatastore; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_resourcedatastore (id, resource_id, datastore_id) FROM stdin;
1	1	1
2	3	3
3	4	5
4	5	6
5	6	9
6	6	7
7	2	2
8	2	4
9	7	8
\.


--
-- TOC entry 2119 (class 0 OID 24076)
-- Dependencies: 1627
-- Data for Name: mcconfig_resourcefield; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_resourcefield (id, resource_id, field_id, "order") FROM stdin;
1	7	1	1
5	2	5	1
6	2	6	2
2	7	2	2
3	7	3	3
7	2	7	3
4	7	4	4
8	2	8	4
\.


--
-- TOC entry 2111 (class 0 OID 23950)
-- Dependencies: 1611
-- Data for Name: mcconfig_service; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_service (id, name, source, type) FROM stdin;
1	S_OpenStreetMap	http://tile.openstreetmap.org/	4
2	S_WMS_dev4g_gmap	http://dev4g.mapgears.com/cgi-bin/mswms_gmap	1
3	S_TC_dev4g_gmap	http://dev4g.mapgears.com/tilecache/trunk/tilecache.py	2
4	S_FS_dev4g_gmap	http://dev4g.mapgears.com/featureserver/trunk/featureserver.cgi	3
5	S_WMS_dev4g_bdga	http://dev4g.mapgears.com/cgi-bin/mswms_bdga	1
\.


--
-- TOC entry 2112 (class 0 OID 23964)
-- Dependencies: 1613
-- Data for Name: mcconfig_serviceoption; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_serviceoption (id, service_id, name, value) FROM stdin;
1	1	provider	openstreetmap
\.


--
-- TOC entry 2128 (class 0 OID 24219)
-- Dependencies: 1645
-- Data for Name: mcconfig_session; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_session (id, name, application_id, mapcontext_id) FROM stdin;
1	session_test	1	1
\.


--
-- TOC entry 2121 (class 0 OID 24110)
-- Dependencies: 1631
-- Data for Name: mcconfig_widget; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_widget (id, name, type) FROM stdin;
1	W_GeoExtToolbar	22
2	W_Shortcut	25
3	W_Shortcut2	25
4	W_MeasureToolArea	5
5	W_ZoomSlider	12
6	W_GetMousePosition	14
7	W_Scale	15
8	W_MousePosition	13
9	W_MapFishLayerTree	3
10	W_QueryOnClick	7
11	W_ResultExtGrid	9
12	W_FeaturePanelSelector	20
13	W_RedLining	27
14	W_MapFishRecenter	4
15	W_InitialView	11
16	W_PDFPrint	28
\.


--
-- TOC entry 2122 (class 0 OID 24124)
-- Dependencies: 1633
-- Data for Name: mcconfig_widgetoption; Type: TABLE DATA; Schema: public; Owner: demo
--

COPY mcconfig_widgetoption (id, widget_id, name, value, "order") FROM stdin;
4	1	control	ZoomIn	1
15	1	widget	10	1
13	1	widget	4	2
6	1	control	ZoomOut	2
5	1	control	Pan	3
14	1	widget	6	3
22	1	widget	16	4
19	1	widget	13	5
7	1	widget	2	6
11	1	widget	3	7
20	14	forcefilters	true	\N
3	2	fieldLabel	My field label	\N
21	16	templates	[{"name":"Portrait","model":"Letter Portrait","thumb":"images/iconA4.jpg","dpi":"254","fields":[{"type":"text","name":"mapTitle","label":"Titre"}]}]	\N
2	2	emptyText	My empty text...	\N
1	2	defaultZoom	3	\N
8	3	defaultZoom	4	\N
9	3	emptyText	Second empty text...	\N
10	3	fieldLabel	Second field label	\N
12	4	measuretype	Area	\N
16	10	result	11	\N
17	11	inwindow	false	\N
18	10	featurepanel	12	\N
\.


--
-- TOC entry 1969 (class 2606 OID 23845)
-- Dependencies: 1596 1596
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- TOC entry 1964 (class 2606 OID 23830)
-- Dependencies: 1594 1594 1594
-- Name: auth_group_permissions_group_id_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_key UNIQUE (group_id, permission_id);


--
-- TOC entry 1967 (class 2606 OID 23828)
-- Dependencies: 1594 1594
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- TOC entry 1971 (class 2606 OID 23843)
-- Dependencies: 1596 1596
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- TOC entry 1989 (class 2606 OID 23911)
-- Dependencies: 1604 1604
-- Name: auth_message_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_message
    ADD CONSTRAINT auth_message_pkey PRIMARY KEY (id);


--
-- TOC entry 1959 (class 2606 OID 23820)
-- Dependencies: 1592 1592 1592
-- Name: auth_permission_content_type_id_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_key UNIQUE (content_type_id, codename);


--
-- TOC entry 1961 (class 2606 OID 23818)
-- Dependencies: 1592 1592
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- TOC entry 1980 (class 2606 OID 23873)
-- Dependencies: 1600 1600
-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- TOC entry 1983 (class 2606 OID 23875)
-- Dependencies: 1600 1600 1600
-- Name: auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_key UNIQUE (user_id, group_id);


--
-- TOC entry 1974 (class 2606 OID 23858)
-- Dependencies: 1598 1598
-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- TOC entry 1977 (class 2606 OID 23860)
-- Dependencies: 1598 1598 1598
-- Name: auth_user_user_permissions_user_id_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_key UNIQUE (user_id, permission_id);


--
-- TOC entry 2072 (class 2606 OID 24251)
-- Dependencies: 1647 1647
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- TOC entry 1992 (class 2606 OID 23926)
-- Dependencies: 1606 1606 1606
-- Name: django_content_type_app_label_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_app_label_key UNIQUE (app_label, model);


--
-- TOC entry 1994 (class 2606 OID 23924)
-- Dependencies: 1606 1606
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- TOC entry 1998 (class 2606 OID 23947)
-- Dependencies: 1609 1609
-- Name: django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY django_site
    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);


--
-- TOC entry 2057 (class 2606 OID 24198)
-- Dependencies: 1641 1641
-- Name: mcconfig_application_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_application
    ADD CONSTRAINT mcconfig_application_name_key UNIQUE (name);


--
-- TOC entry 2059 (class 2606 OID 24196)
-- Dependencies: 1641 1641
-- Name: mcconfig_application_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_application
    ADD CONSTRAINT mcconfig_application_pkey PRIMARY KEY (id);


--
-- TOC entry 2062 (class 2606 OID 24206)
-- Dependencies: 1643 1643
-- Name: mcconfig_applicationwidget_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_applicationwidget
    ADD CONSTRAINT mcconfig_applicationwidget_pkey PRIMARY KEY (id);


--
-- TOC entry 2007 (class 2606 OID 23990)
-- Dependencies: 1615 1615
-- Name: mcconfig_datastore_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_datastore
    ADD CONSTRAINT mcconfig_datastore_name_key UNIQUE (name);


--
-- TOC entry 2009 (class 2606 OID 23988)
-- Dependencies: 1615 1615
-- Name: mcconfig_datastore_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_datastore
    ADD CONSTRAINT mcconfig_datastore_pkey PRIMARY KEY (id);


--
-- TOC entry 2013 (class 2606 OID 24006)
-- Dependencies: 1617 1617
-- Name: mcconfig_datastoreoption_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_datastoreoption
    ADD CONSTRAINT mcconfig_datastoreoption_pkey PRIMARY KEY (id);


--
-- TOC entry 2020 (class 2606 OID 24035)
-- Dependencies: 1621 1621
-- Name: mcconfig_fieldoption_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_fieldoption
    ADD CONSTRAINT mcconfig_fieldoption_pkey PRIMARY KEY (id);


--
-- TOC entry 2046 (class 2606 OID 24150)
-- Dependencies: 1635 1635
-- Name: mcconfig_mapcontext_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_mapcontext
    ADD CONSTRAINT mcconfig_mapcontext_name_key UNIQUE (name);


--
-- TOC entry 2048 (class 2606 OID 24148)
-- Dependencies: 1635 1635
-- Name: mcconfig_mapcontext_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_mapcontext
    ADD CONSTRAINT mcconfig_mapcontext_pkey PRIMARY KEY (id);


--
-- TOC entry 2051 (class 2606 OID 24161)
-- Dependencies: 1637 1637
-- Name: mcconfig_mapcontextoption_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_mapcontextoption
    ADD CONSTRAINT mcconfig_mapcontextoption_pkey PRIMARY KEY (id);


--
-- TOC entry 2054 (class 2606 OID 24174)
-- Dependencies: 1639 1639
-- Name: mcconfig_mapcontextresource_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_mapcontextresource
    ADD CONSTRAINT mcconfig_mapcontextresource_pkey PRIMARY KEY (id);


--
-- TOC entry 2023 (class 2606 OID 24048)
-- Dependencies: 1623 1623
-- Name: mcconfig_resourcedatastore_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_resourcedatastore
    ADD CONSTRAINT mcconfig_resourcedatastore_pkey PRIMARY KEY (id);


--
-- TOC entry 2026 (class 2606 OID 24050)
-- Dependencies: 1623 1623 1623
-- Name: mcconfig_resourcedatastore_resource_id_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_resourcedatastore
    ADD CONSTRAINT mcconfig_resourcedatastore_resource_id_key UNIQUE (resource_id, datastore_id);


--
-- TOC entry 2033 (class 2606 OID 24081)
-- Dependencies: 1627 1627
-- Name: mcconfig_resourcefield_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_resourcefield
    ADD CONSTRAINT mcconfig_resourcefield_pkey PRIMARY KEY (id);


--
-- TOC entry 2000 (class 2606 OID 23961)
-- Dependencies: 1611 1611
-- Name: mcconfig_service_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_service
    ADD CONSTRAINT mcconfig_service_name_key UNIQUE (name);


--
-- TOC entry 2002 (class 2606 OID 23959)
-- Dependencies: 1611 1611
-- Name: mcconfig_service_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_service
    ADD CONSTRAINT mcconfig_service_pkey PRIMARY KEY (id);


--
-- TOC entry 2004 (class 2606 OID 23972)
-- Dependencies: 1613 1613
-- Name: mcconfig_serviceoption_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_serviceoption
    ADD CONSTRAINT mcconfig_serviceoption_pkey PRIMARY KEY (id);


--
-- TOC entry 2067 (class 2606 OID 24229)
-- Dependencies: 1645 1645
-- Name: mcconfig_session_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_session
    ADD CONSTRAINT mcconfig_session_name_key UNIQUE (name);


--
-- TOC entry 2069 (class 2606 OID 24227)
-- Dependencies: 1645 1645
-- Name: mcconfig_session_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_session
    ADD CONSTRAINT mcconfig_session_pkey PRIMARY KEY (id);


--
-- TOC entry 2039 (class 2606 OID 24121)
-- Dependencies: 1631 1631
-- Name: mcconfig_widget_name_key; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_widget
    ADD CONSTRAINT mcconfig_widget_name_key UNIQUE (name);


--
-- TOC entry 2041 (class 2606 OID 24119)
-- Dependencies: 1631 1631
-- Name: mcconfig_widget_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_widget
    ADD CONSTRAINT mcconfig_widget_pkey PRIMARY KEY (id);


--
-- TOC entry 2043 (class 2606 OID 24132)
-- Dependencies: 1633 1633
-- Name: mcconfig_widgetoption_pkey; Type: CONSTRAINT; Schema: public; Owner: demo; Tablespace: 
--

ALTER TABLE ONLY mcconfig_widgetoption
    ADD CONSTRAINT mcconfig_widgetoption_pkey PRIMARY KEY (id);


--
-- TOC entry 1962 (class 1259 OID 24264)
-- Dependencies: 1594
-- Name: auth_group_permissions_group_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_group_permissions_group_id ON auth_group_permissions USING btree (group_id);


--
-- TOC entry 1965 (class 1259 OID 24265)
-- Dependencies: 1594
-- Name: auth_group_permissions_permission_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_group_permissions_permission_id ON auth_group_permissions USING btree (permission_id);


--
-- TOC entry 1990 (class 1259 OID 24270)
-- Dependencies: 1604
-- Name: auth_message_user_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_message_user_id ON auth_message USING btree (user_id);


--
-- TOC entry 1957 (class 1259 OID 24263)
-- Dependencies: 1592
-- Name: auth_permission_content_type_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_permission_content_type_id ON auth_permission USING btree (content_type_id);


--
-- TOC entry 1978 (class 1259 OID 24269)
-- Dependencies: 1600
-- Name: auth_user_groups_group_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_user_groups_group_id ON auth_user_groups USING btree (group_id);


--
-- TOC entry 1981 (class 1259 OID 24268)
-- Dependencies: 1600
-- Name: auth_user_groups_user_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_user_groups_user_id ON auth_user_groups USING btree (user_id);


--
-- TOC entry 1972 (class 1259 OID 24267)
-- Dependencies: 1598
-- Name: auth_user_user_permissions_permission_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_permission_id ON auth_user_user_permissions USING btree (permission_id);


--
-- TOC entry 1975 (class 1259 OID 24266)
-- Dependencies: 1598
-- Name: auth_user_user_permissions_user_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_user_id ON auth_user_user_permissions USING btree (user_id);


--
-- TOC entry 2070 (class 1259 OID 24289)
-- Dependencies: 1647
-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX django_admin_log_content_type_id ON django_admin_log USING btree (content_type_id);


--
-- TOC entry 2073 (class 1259 OID 24288)
-- Dependencies: 1647
-- Name: django_admin_log_user_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX django_admin_log_user_id ON django_admin_log USING btree (user_id);


--
-- TOC entry 2060 (class 1259 OID 24284)
-- Dependencies: 1643
-- Name: mcconfig_applicationwidget_application_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_applicationwidget_application_id ON mcconfig_applicationwidget USING btree (application_id);


--
-- TOC entry 2063 (class 1259 OID 24285)
-- Dependencies: 1643
-- Name: mcconfig_applicationwidget_widget_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_applicationwidget_widget_id ON mcconfig_applicationwidget USING btree (widget_id);


--
-- TOC entry 2010 (class 1259 OID 24272)
-- Dependencies: 1615
-- Name: mcconfig_datastore_service_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_datastore_service_id ON mcconfig_datastore USING btree (service_id);


--
-- TOC entry 2011 (class 1259 OID 24273)
-- Dependencies: 1617
-- Name: mcconfig_datastoreoption_datastore_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_datastoreoption_datastore_id ON mcconfig_datastoreoption USING btree (datastore_id);


--
-- TOC entry 2018 (class 1259 OID 24274)
-- Dependencies: 1621
-- Name: mcconfig_fieldoption_field_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_fieldoption_field_id ON mcconfig_fieldoption USING btree (field_id);


--
-- TOC entry 2049 (class 1259 OID 24281)
-- Dependencies: 1637
-- Name: mcconfig_mapcontextoption_mapcontext_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_mapcontextoption_mapcontext_id ON mcconfig_mapcontextoption USING btree (mapcontext_id);


--
-- TOC entry 2052 (class 1259 OID 24282)
-- Dependencies: 1639
-- Name: mcconfig_mapcontextresource_mapcontext_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_mapcontextresource_mapcontext_id ON mcconfig_mapcontextresource USING btree (mapcontext_id);


--
-- TOC entry 2055 (class 1259 OID 24283)
-- Dependencies: 1639
-- Name: mcconfig_mapcontextresource_resource_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_mapcontextresource_resource_id ON mcconfig_mapcontextresource USING btree (resource_id);


--
-- TOC entry 2021 (class 1259 OID 24276)
-- Dependencies: 1623
-- Name: mcconfig_resourcedatastore_datastore_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_resourcedatastore_datastore_id ON mcconfig_resourcedatastore USING btree (datastore_id);


--
-- TOC entry 2024 (class 1259 OID 24275)
-- Dependencies: 1623
-- Name: mcconfig_resourcedatastore_resource_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_resourcedatastore_resource_id ON mcconfig_resourcedatastore USING btree (resource_id);


--
-- TOC entry 2031 (class 1259 OID 24278)
-- Dependencies: 1627
-- Name: mcconfig_resourcefield_field_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_resourcefield_field_id ON mcconfig_resourcefield USING btree (field_id);


--
-- TOC entry 2034 (class 1259 OID 24277)
-- Dependencies: 1627
-- Name: mcconfig_resourcefield_resource_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_resourcefield_resource_id ON mcconfig_resourcefield USING btree (resource_id);


--
-- TOC entry 2005 (class 1259 OID 24271)
-- Dependencies: 1613
-- Name: mcconfig_serviceoption_service_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_serviceoption_service_id ON mcconfig_serviceoption USING btree (service_id);


--
-- TOC entry 2064 (class 1259 OID 24286)
-- Dependencies: 1645
-- Name: mcconfig_session_application_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_session_application_id ON mcconfig_session USING btree (application_id);


--
-- TOC entry 2065 (class 1259 OID 24287)
-- Dependencies: 1645
-- Name: mcconfig_session_mapcontext_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_session_mapcontext_id ON mcconfig_session USING btree (mapcontext_id);


--
-- TOC entry 2044 (class 1259 OID 24280)
-- Dependencies: 1633
-- Name: mcconfig_widgetoption_widget_id; Type: INDEX; Schema: public; Owner: demo; Tablespace: 
--

CREATE INDEX mcconfig_widgetoption_widget_id ON mcconfig_widgetoption USING btree (widget_id);


--
-- TOC entry 2075 (class 2606 OID 23831)
-- Dependencies: 1594 1592 1960
-- Name: auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2081 (class 2606 OID 23912)
-- Dependencies: 1604 1602 1984
-- Name: auth_message_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_message
    ADD CONSTRAINT auth_message_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2079 (class 2606 OID 23876)
-- Dependencies: 1970 1600 1596
-- Name: auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2077 (class 2606 OID 23861)
-- Dependencies: 1598 1960 1592
-- Name: auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2074 (class 2606 OID 23927)
-- Dependencies: 1993 1592 1606
-- Name: content_type_id_refs_id_728de91f; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT content_type_id_refs_id_728de91f FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2100 (class 2606 OID 24257)
-- Dependencies: 1647 1993 1606
-- Name: django_admin_log_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2099 (class 2606 OID 24252)
-- Dependencies: 1647 1984 1602
-- Name: django_admin_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2076 (class 2606 OID 23846)
-- Dependencies: 1596 1970 1594
-- Name: group_id_refs_id_3cea63fe; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT group_id_refs_id_3cea63fe FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2095 (class 2606 OID 24207)
-- Dependencies: 1643 2058 1641
-- Name: mcconfig_applicationwidget_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_applicationwidget
    ADD CONSTRAINT mcconfig_applicationwidget_application_id_fkey FOREIGN KEY (application_id) REFERENCES mcconfig_application(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2096 (class 2606 OID 24212)
-- Dependencies: 2040 1631 1643
-- Name: mcconfig_applicationwidget_widget_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_applicationwidget
    ADD CONSTRAINT mcconfig_applicationwidget_widget_id_fkey FOREIGN KEY (widget_id) REFERENCES mcconfig_widget(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2083 (class 2606 OID 23991)
-- Dependencies: 1611 1615 2001
-- Name: mcconfig_datastore_service_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_datastore
    ADD CONSTRAINT mcconfig_datastore_service_id_fkey FOREIGN KEY (service_id) REFERENCES mcconfig_service(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2084 (class 2606 OID 24007)
-- Dependencies: 2008 1617 1615
-- Name: mcconfig_datastoreoption_datastore_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_datastoreoption
    ADD CONSTRAINT mcconfig_datastoreoption_datastore_id_fkey FOREIGN KEY (datastore_id) REFERENCES mcconfig_datastore(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2085 (class 2606 OID 24036)
-- Dependencies: 1621 2016 1619
-- Name: mcconfig_fieldoption_field_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_fieldoption
    ADD CONSTRAINT mcconfig_fieldoption_field_id_fkey FOREIGN KEY (field_id) REFERENCES mcconfig_field(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2092 (class 2606 OID 24162)
-- Dependencies: 1637 1635 2047
-- Name: mcconfig_mapcontextoption_mapcontext_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_mapcontextoption
    ADD CONSTRAINT mcconfig_mapcontextoption_mapcontext_id_fkey FOREIGN KEY (mapcontext_id) REFERENCES mcconfig_mapcontext(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2093 (class 2606 OID 24175)
-- Dependencies: 1639 1635 2047
-- Name: mcconfig_mapcontextresource_mapcontext_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_mapcontextresource
    ADD CONSTRAINT mcconfig_mapcontextresource_mapcontext_id_fkey FOREIGN KEY (mapcontext_id) REFERENCES mcconfig_mapcontext(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2094 (class 2606 OID 24180)
-- Dependencies: 1625 1639 2029
-- Name: mcconfig_mapcontextresource_resource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_mapcontextresource
    ADD CONSTRAINT mcconfig_mapcontextresource_resource_id_fkey FOREIGN KEY (resource_id) REFERENCES mcconfig_resource(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2086 (class 2606 OID 24051)
-- Dependencies: 1623 1615 2008
-- Name: mcconfig_resourcedatastore_datastore_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_resourcedatastore
    ADD CONSTRAINT mcconfig_resourcedatastore_datastore_id_fkey FOREIGN KEY (datastore_id) REFERENCES mcconfig_datastore(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2089 (class 2606 OID 24087)
-- Dependencies: 2016 1619 1627
-- Name: mcconfig_resourcefield_field_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_resourcefield
    ADD CONSTRAINT mcconfig_resourcefield_field_id_fkey FOREIGN KEY (field_id) REFERENCES mcconfig_field(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2088 (class 2606 OID 24082)
-- Dependencies: 2029 1627 1625
-- Name: mcconfig_resourcefield_resource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_resourcefield
    ADD CONSTRAINT mcconfig_resourcefield_resource_id_fkey FOREIGN KEY (resource_id) REFERENCES mcconfig_resource(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2082 (class 2606 OID 23973)
-- Dependencies: 1611 1613 2001
-- Name: mcconfig_serviceoption_service_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_serviceoption
    ADD CONSTRAINT mcconfig_serviceoption_service_id_fkey FOREIGN KEY (service_id) REFERENCES mcconfig_service(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2097 (class 2606 OID 24230)
-- Dependencies: 1645 2058 1641
-- Name: mcconfig_session_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_session
    ADD CONSTRAINT mcconfig_session_application_id_fkey FOREIGN KEY (application_id) REFERENCES mcconfig_application(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2098 (class 2606 OID 24235)
-- Dependencies: 1635 2047 1645
-- Name: mcconfig_session_mapcontext_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_session
    ADD CONSTRAINT mcconfig_session_mapcontext_id_fkey FOREIGN KEY (mapcontext_id) REFERENCES mcconfig_mapcontext(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2091 (class 2606 OID 24133)
-- Dependencies: 2040 1631 1633
-- Name: mcconfig_widgetoption_widget_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_widgetoption
    ADD CONSTRAINT mcconfig_widgetoption_widget_id_fkey FOREIGN KEY (widget_id) REFERENCES mcconfig_widget(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2087 (class 2606 OID 24069)
-- Dependencies: 1625 2029 1623
-- Name: resource_id_refs_id_d394f98d; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY mcconfig_resourcedatastore
    ADD CONSTRAINT resource_id_refs_id_d394f98d FOREIGN KEY (resource_id) REFERENCES mcconfig_resource(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2080 (class 2606 OID 23896)
-- Dependencies: 1602 1984 1600
-- Name: user_id_refs_id_831107f1; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT user_id_refs_id_831107f1 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2078 (class 2606 OID 23891)
-- Dependencies: 1984 1598 1602
-- Name: user_id_refs_id_f2045483; Type: FK CONSTRAINT; Schema: public; Owner: demo
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT user_id_refs_id_f2045483 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2134 (class 0 OID 0)
-- Dependencies: 3
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

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


-- Completed on 2010-08-17 11:53:58 EDT

--
--

