--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
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 = false;

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

CREATE TABLE comments (
    "position" integer NOT NULL,
    discussion text,
    date bigint,
    author text,
    "comment" text,
    the_geom geometry,
    forum text
);


ALTER TABLE public.comments OWNER TO postgres;

--
-- Name: comments_position_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.comments_position_seq OWNER TO postgres;

--
-- Name: comments_position_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE comments_position_seq OWNED BY comments."position";


--
-- Name: comments_position_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('comments_position_seq', 1, true);


--
-- Name: position; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE comments ALTER COLUMN "position" SET DEFAULT nextval('comments_position_seq'::regclass);


--
-- Name: comments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY comments
    ADD CONSTRAINT comments_pkey PRIMARY KEY ("position");


--
-- Name: comments; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE comments FROM PUBLIC;
REVOKE ALL ON TABLE comments FROM postgres;
GRANT ALL ON TABLE comments TO postgres;


--
-- Name: comments_position_seq; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON SEQUENCE comments_position_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE comments_position_seq FROM postgres;
GRANT ALL ON SEQUENCE comments_position_seq TO postgres;


--
-- Add comments table to the geometry columns
-- 
INSERT INTO geometry_columns 
   (f_table_catalog,f_table_schema,f_table_name,f_geometry_column,coord_dimension,srid,type) 
   VALUES ('','public','comments','the_geom',2,4326,'MULTIPOINT');
 
--
-- PostgreSQL database dump complete
--