--- /dev/null
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = true;
+
+CREATE TABLE l49 (
+ id_work character varying(256) NOT NULL,
+ description character varying(256),
+ date_debut date,
+ date_fin date,
+ date_limite date,
+ longueur double precision,
+ referent character varying(256),
+ date_maj_work date,
+ source_maj_work character varying(256),
+ geom geometry,
+ tel character varying(255),
+ mail character varying(255),
+ organisation character varying(255),
+ nom character varying(255),
+ prenom character varying(255),
+ CONSTRAINT enforce_dims_geom CHECK ((st_ndims(geom) = 2)),
+ CONSTRAINT enforce_geotype_geom CHECK (((geometrytype(geom) = 'POINT'::text) OR (geom IS NULL))),
+ CONSTRAINT enforce_srid_geom CHECK ((st_srid(geom) = 2154))
+);
+
+
+ALTER TABLE ONLY l49
+ ADD CONSTRAINT work_pk PRIMARY KEY (id_work);
+
+
+CREATE INDEX l49_indgist ON l49 USING gist (geom);
+
+GRANT ALL ON TABLE l49 TO geonode;