--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: foo; Type: TABLE; Schema: public; Owner: cmoe; Tablespace: 
--

CREATE TABLE foo (
    ogc_fid integer NOT NULL,
    wkb_geometry geometry,
    bar integer NOT NULL,
    foobar integer,
    archive integer DEFAULT 0,
    CONSTRAINT "$1" CHECK ((srid(wkb_geometry) = (-1))),
    CONSTRAINT "$2" CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL)))
);



--
-- Name: foo_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: cmoe
--

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



--
-- Name: foo_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cmoe
--

ALTER SEQUENCE foo_ogc_fid_seq OWNED BY foo.ogc_fid;


--
-- Name: foo_ogc_fid_seq; Type: SEQUENCE SET; Schema: public; Owner: cmoe
--

SELECT pg_catalog.setval('foo_ogc_fid_seq', 3, true);


--
-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: cmoe
--

ALTER TABLE foo ALTER COLUMN ogc_fid SET DEFAULT nextval('foo_ogc_fid_seq'::regclass);


--
-- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: cmoe
--

INSERT INTO foo VALUES (1, '0101000000E659C23E583D234148821E1E8E3B0D41', 1, 1, 0);
INSERT INTO foo VALUES (3, '01010000008DC41522F7422341889EC8EB3D280D41', 3, 1, 0);
INSERT INTO foo VALUES (2, '01010000005B983D7DBD4A2341264618A2CA370D41', 1, 1, 1);


--
-- Name: foo_pkey; Type: CONSTRAINT; Schema: public; Owner: cmoe; Tablespace: 
--

ALTER TABLE ONLY foo
    ADD CONSTRAINT foo_pkey PRIMARY KEY (ogc_fid);


--
-- Name: foo_bar_unique_idx; Type: INDEX; Schema: public; Owner: cmoe; Tablespace: 
--

CREATE UNIQUE INDEX foo_bar_unique_idx ON foo USING btree (bar) WHERE (archive = 0);


--
-- PostgreSQL database dump complete
--

