--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

drop table sites;
delete from "geometry_columns" where srid=26713;
drop table tables_changed;
drop table versioned_tables;
drop table changesets;

--
-- Name: archsites; Type: TABLE; Schema: public; Owner: Administrator; Tablespace: 
--

CREATE TABLE sites (
    gid serial NOT NULL,
    cat bigint,
    title character varying(128),
    img_url character varying(256),
    description character varying(256),
    the_geom geometry,
    CONSTRAINT enforce_dims_the_geom CHECK ((ndims(the_geom) = 2)),
    CONSTRAINT enforce_geotype_the_geom CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))),
    CONSTRAINT enforce_srid_the_geom CHECK ((srid(the_geom) = 26713))
);

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('sites', 'gid'), 25, true);


ALTER TABLE ONLY sites
    ADD CONSTRAINT sites_pkey PRIMARY KEY (gid);

CREATE INDEX sites_the_geom_gist ON sites USING gist (the_geom);