--
-- 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: feature_comments; Type: TABLE; Schema: public; Owner: jpfiset; Tablespace: 
--

CREATE TABLE feature_comments (
    position integer NOT NULL
    ,uid text
    ,date bigint
    ,author text
    ,comment text
    ,the_geom geometry
);


ALTER TABLE public.feature_comments OWNER TO jpfiset;

--
-- Name: feature_comments_position_seq; Type: SEQUENCE; Schema: public; Owner: jpfiset
--

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


ALTER TABLE public.feature_comments_position_seq OWNER TO jpfiset;

--
-- Name: feature_comments_position_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jpfiset
--

ALTER SEQUENCE feature_comments_position_seq OWNED BY feature_comments.position;


--
-- Name: feature_comments_position_seq; Type: SEQUENCE SET; Schema: public; Owner: jpfiset
--

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


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

ALTER TABLE feature_comments ALTER COLUMN position SET DEFAULT nextval('feature_comments_position_seq'::regclass);


--
-- Name: feature_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: jpfiset; Tablespace: 
--

ALTER TABLE ONLY feature_comments
    ADD CONSTRAINT feature_comments_pkey PRIMARY KEY (position);


--
-- Name: feature_comments; Type: ACL; Schema: public; Owner: jpfiset
--

REVOKE ALL ON TABLE feature_comments FROM PUBLIC;
REVOKE ALL ON TABLE feature_comments FROM jpfiset;
GRANT ALL ON TABLE feature_comments TO jpfiset;
GRANT ALL ON TABLE feature_comments TO postgres;
GRANT SELECT ON TABLE feature_comments TO test_read;
GRANT ALL ON TABLE feature_comments TO test_write;


--
-- Name: feature_comments_position_seq; Type: ACL; Schema: public; Owner: jpfiset
--

REVOKE ALL ON SEQUENCE feature_comments_position_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE feature_comments_position_seq FROM jpfiset;
GRANT ALL ON SEQUENCE feature_comments_position_seq TO jpfiset;
GRANT ALL ON SEQUENCE feature_comments_position_seq TO postgres;
GRANT SELECT ON SEQUENCE feature_comments_position_seq TO test_read;
GRANT ALL ON SEQUENCE feature_comments_position_seq TO test_write;


--
-- Add geometry attribute to geometry table
--

INSERT INTO geometry_columns (f_table_catalog,f_table_schema,f_table_name,f_geometry_column,coord_dimension,srid,type)
VALUES ('','public','feature_comments','the_geom',2,4326,'MULTIPOINT');

--
-- PostgreSQL database dump complete
--

-- DROP TABLE feature_comments;
-- DELETE FROM geometry_columns WHERE f_table_name = 'feature_comments';