 
 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
 
-CREATE SCHEMA pgis;
+CREATE SCHEMA IF NOT EXISTS pgis;
 CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA pgis;
 
 
--- wrapper de fichiers txt type csv utilisé pour les imports gtfs
-CREATE EXTENSION IF NOT EXISTS file_fdw;
-COMMENT ON EXTENSION file_fdw IS 'foreign-data wrapper which can be used to access data files in the (server)file system';
-CREATE SERVER file_fdw_server FOREIGN DATA WRAPPER file_fdw;
+-- C'est quoi ça ? Je commente
+--
+-- CREATE EXTENSION IF NOT EXISTS file_fdw;
+-- COMMENT ON EXTENSION file_fdw IS 'foreign-data wrapper which can be used to access data files in the (server)file system';
+-- REATE SERVER file_fdw_server FOREIGN DATA WRAPPER file_fdw;
 
 SET default_tablespace = '';
 SET default_with_oids = false;
 SET search_path = public, pg_catalog, pgis;
-
-
 
 CREATE TYPE address AS (
 	address character varying,

COMMENT ON COLUMN route_section.start_date IS 'Date de la creation de ce troncon. Un nouveau troncon est cree si arret debut ou arret fin ou geom est nouvelle.';
COMMENT ON COLUMN route_section.end_date IS 'Date de fin d''utilisation du troncon. Lorsqu''un nouveau troncon (meme debut, meme fin mais geom differente) est cree, le precedentest cloture.';
COMMENT ON COLUMN route_section.the_geom IS 'Geometrie de Tigre.';
CREATE SEQUENCE route_section_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
ALTER SEQUENCE route_section_id_seq OWNED BY route_section.id;




CREATE TABLE route_stop (
    id integer NOT NULL,
    route_id integer NOT NULL,
    waypoint_id integer NOT NULL,
    rank integer NOT NULL,

COMMENT ON COLUMN poi.city_id IS 'Commune du POI.';
COMMENT ON COLUMN poi.poi_type_id IS 'Categorie de POI.';
COMMENT ON COLUMN poi.priority IS 'Importance du POI. 1 = prioritaire, 5 = peu important.';
ALTER TABLE ONLY poi ADD CONSTRAINT poi_pk PRIMARY KEY (id);
ALTER TABLE ONLY poi ADD CONSTRAINT poi_poi_type_id_fk FOREIGN KEY (poi_type_id) REFERENCES poi_type(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
CREATE INDEX poi_poi_type_id_idx ON poi USING btree (poi_type_id);

CREATE TABLE poi_address (
    id serial,
    poi_id integer NOT NULL,
    address text,
    is_entrance boolean NOT NULL,
