Le portail francophone de la géomatique

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.4
-- Dumped by pg_dump version 9.2.4
-- Started on 2015-01-28 11:33:41

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 = oql, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 188 (class 1259 OID 23812)
-- Name: activite_club_sport; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE activite_club_sport (
    acsport_annee integer NOT NULL,
    acsport_act_sport_id integer NOT NULL,
    acsport_cspo_id integer NOT NULL
);


ALTER TABLE oql.activite_club_sport OWNER TO postgres;

--
-- TOC entry 189 (class 1259 OID 23815)
-- Name: activite_mer; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE activite_mer (
    act_annee integer NOT NULL,
    act_bouee boolean,
    act_drapeau boolean,
    act_act_mert_id integer NOT NULL,
    act_plg_id integer NOT NULL
);


ALTER TABLE oql.activite_mer OWNER TO postgres;

--
-- TOC entry 190 (class 1259 OID 23818)
-- Name: activite_mer_type; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE activite_mer_type (
    act_mert_id integer NOT NULL,
    act_mert_label character varying
);


ALTER TABLE oql.activite_mer_type OWNER TO postgres;

--
-- TOC entry 191 (class 1259 OID 23824)
-- Name: activite_mer_type_act_mert_id_seq; Type: SEQUENCE; Schema: oql; Owner: postgres
--

CREATE SEQUENCE activite_mer_type_act_mert_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE oql.activite_mer_type_act_mert_id_seq OWNER TO postgres;

--
-- TOC entry 4036 (class 0 OID 0)
-- Dependencies: 191
-- Name: activite_mer_type_act_mert_id_seq; Type: SEQUENCE OWNED BY; Schema: oql; Owner: postgres
--

ALTER SEQUENCE activite_mer_type_act_mert_id_seq OWNED BY activite_mer_type.act_mert_id;


--
-- TOC entry 192 (class 1259 OID 23826)
-- Name: activite_sportive; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE activite_sportive (
    act_sport_id integer NOT NULL,
    act_sport_label character varying
);


ALTER TABLE oql.activite_sportive OWNER TO postgres;

--
-- TOC entry 193 (class 1259 OID 23832)
-- Name: activite_sportive_act_sport_id_seq; Type: SEQUENCE; Schema: oql; Owner: postgres
--

CREATE SEQUENCE activite_sportive_act_sport_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE oql.activite_sportive_act_sport_id_seq OWNER TO postgres;

--
-- TOC entry 4037 (class 0 OID 0)
-- Dependencies: 193
-- Name: activite_sportive_act_sport_id_seq; Type: SEQUENCE OWNED BY; Schema: oql; Owner: postgres
--

ALTER SEQUENCE activite_sportive_act_sport_id_seq OWNED BY activite_sportive.act_sport_id;


--
-- TOC entry 194 (class 1259 OID 23834)
-- Name: appreciation; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE appreciation (
    apprec_id integer NOT NULL,
    apprec_annee integer,
    apprec_excellent_pourc real,
    apprec_bon_pourc real,
    apprec_moyen_pourc real,
    apprec_mauvais_pourc real,
    apprec_plg_id integer
);


ALTER TABLE oql.appreciation OWNER TO postgres;

--
-- TOC entry 195 (class 1259 OID 23837)
-- Name: appreciation_apprec_id_seq; Type: SEQUENCE; Schema: oql; Owner: postgres
--

CREATE SEQUENCE appreciation_apprec_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE oql.appreciation_apprec_id_seq OWNER TO postgres;

--
-- TOC entry 4038 (class 0 OID 0)
-- Dependencies: 195
-- Name: appreciation_apprec_id_seq; Type: SEQUENCE OWNED BY; Schema: oql; Owner: postgres
--

ALTER SEQUENCE appreciation_apprec_id_seq OWNED BY appreciation.apprec_id;


--
-- TOC entry 196 (class 1259 OID 23839)
-- Name: ch_trav_caractq; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE ch_trav_caractq (
    chtravc_id integer NOT NULL,
    chtravc_annee integer,
    chtravc_delim boolean,
    chtravc_chtrtyp_id integer,
    chtravc_chtr_id integer
);


ALTER TABLE oql.ch_trav_caractq OWNER TO postgres;

--
-- TOC entry 197 (class 1259 OID 23842)
-- Name: ch_trav_caractq_chtravc_id_seq; Type: SEQUENCE; Schema: oql; Owner: postgres
--

CREATE SEQUENCE ch_trav_caractq_chtravc_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE oql.ch_trav_caractq_chtravc_id_seq OWNER TO postgres;

--
-- TOC entry 4039 (class 0 OID 0)
-- Dependencies: 197
-- Name: ch_trav_caractq_chtravc_id_seq; Type: SEQUENCE OWNED BY; Schema: oql; Owner: postgres
--

ALTER SEQUENCE ch_trav_caractq_chtravc_id_seq OWNED BY ch_trav_caractq.chtravc_id;


--
-- TOC entry 198 (class 1259 OID 23844)
-- Name: ch_trav_type; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE ch_trav_type (
    chtrtyp_id integer NOT NULL,
    chtrtyp_label character varying
);


ALTER TABLE oql.ch_trav_type OWNER TO postgres;

--
-- TOC entry 199 (class 1259 OID 23850)
-- Name: ch_trav_type_chtrtyp_id_seq; Type: SEQUENCE; Schema: oql; Owner: postgres
--

CREATE SEQUENCE ch_trav_type_chtrtyp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE oql.ch_trav_type_chtrtyp_id_seq OWNER TO postgres;

--
-- TOC entry 4040 (class 0 OID 0)
-- Dependencies: 199
-- Name: ch_trav_type_chtrtyp_id_seq; Type: SEQUENCE OWNED BY; Schema: oql; Owner: postgres
--

ALTER SEQUENCE ch_trav_type_chtrtyp_id_seq OWNED BY ch_trav_type.chtrtyp_id;


--
-- TOC entry 200 (class 1259 OID 23852)
-- Name: chenal_traversier; Type: TABLE; Schema: oql; Owner: postgres; Tablespace: 
--

CREATE TABLE chenal_traversier (
    chtr_id integer NOT NULL,
    table_bd character varying(200),
    geom geometry(MultiPolygon,2154),
    chtr_plgid integer
);


ALTER TABLE oql.chenal_traversier OWNER TO postgres;

SET search_path = oql, public, pg_catalog;