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

CREATE TABLE jp_points (
    fid integer NOT NULL
    ,location text
    ,image text
    ,movie text
    ,the_geom geometry
);


ALTER TABLE public.jp_points OWNER TO jpfiset;

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

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


ALTER TABLE public.jp_points_fid_seq OWNER TO jpfiset;

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

ALTER SEQUENCE jp_points_fid_seq OWNED BY jp_points.fid;


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

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


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

ALTER TABLE jp_points ALTER COLUMN fid SET DEFAULT nextval('jp_points_fid_seq'::regclass);


--
-- Data for Name: jp_points; Type: TABLE DATA; Schema: public; Owner: jpfiset
--

-- INSERT INTO jp_points (fid, uid, date, author, comment, the_geom) VALUES
-- (1,'Canada','2007-07-17','Jean-Pierre Fiset','I just love this country!',GeomFromText('MULTIPOINT(0 0)',4326))
-- ;


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

ALTER TABLE ONLY jp_points
    ADD CONSTRAINT jp_points_pkey PRIMARY KEY (fid);


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

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


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

REVOKE ALL ON SEQUENCE jp_points_fid_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE jp_points_fid_seq FROM jpfiset;
GRANT ALL ON SEQUENCE jp_points_fid_seq TO jpfiset;
GRANT ALL ON SEQUENCE jp_points_fid_seq TO postgres;
GRANT SELECT ON SEQUENCE jp_points_fid_seq TO test_read;
GRANT ALL ON SEQUENCE jp_points_fid_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','jp_points','the_geom',2,4326,'MULTIPOINT');

--
-- PostgreSQL database dump complete
--

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