source: ether_eccad/trunk/ECCAD_INTERFACE/pinaud_save_eccad.sql @ 68

--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


--
-- Name: pltcl; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE pltcl;


SET search_path = public, pg_catalog;

--
-- Name: __infosgrille; Type: TYPE; Schema: public; Owner: wwwadm
--

CREATE TYPE __infosgrille AS (
        id_grille integer,
        id_sequence integer,
        id_produit integer,
        id_codification integer,
        id_param integer,
        valeurs_grille oid,
        date_grille date,
        deltadate_grille interval,
        ncol_grille integer,
        nlign_grille integer,
        level_grille double precision,
        legend_code character varying(128)
);


ALTER TYPE public.__infosgrille OWNER TO wwwadm;

--
-- Name: date_updater(); Type: FUNCTION; Schema: public; Owner: wwwadm
--

CREATE FUNCTION date_updater() RETURNS "trigger"
    AS $$
   DECLARE
   date_max date;
   date_min date;
   date_cur date;
   BEGIN
   SELECT INTO date_max endtime_produit FROM produit WHERE id_produit=NEW.id_produit;
   SELECT INTO date_min begintime_produit FROM produit WHERE id_produit=NEW.id_produit;
   date_cur := NEW.DATE_GRILLE;

   IF date_cur <= date_max THEN
   ELSE
       UPDATE produit SET endtime_produit=date_cur WHERE id_produit=NEW.id_produit;
   END IF;

   IF date_cur >= date_min THEN
   ELSE
       UPDATE produit SET begintime_produit=date_cur WHERE id_produit=NEW.id_produit;
   END IF;

       RETURN NULL;
   END;
$$
    LANGUAGE plpgsql;


ALTER FUNCTION public.date_updater() OWNER TO wwwadm;

--
-- Name: extractinfos(integer, integer, date, date); Type: FUNCTION; Schema: public; Owner: wwwadm
--

CREATE FUNCTION extractinfos(integer, integer, date, date) RETURNS SETOF __infosgrille
    AS $_$
SELECT  id_grille, id_sequence, id_produit, grille.id_codification, id_param, valeurs_grille, date_grille, deltaDate_grille, ncol_grille, nlign_grille, level_grille, legend_code FROM grille JOIN code ON (id_grille = num_code AND grille.id_codification = code.id_codification)  WHERE id_param = $2 AND id_produit = $1 AND date_grille >= $3 AND date_grille <= $4 ORDER BY date_grille, legend_code;
$_$
    LANGUAGE sql;


ALTER FUNCTION public.extractinfos(integer, integer, date, date) OWNER TO wwwadm;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: REFERENCES; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE "REFERENCES" (
    id_references serial NOT NULL,
    pubtitle_references text NOT NULL,
    puburl_references character varying(128),
    pubeditor_references text,
    pubyear_references character varying(128),
    pubauthors_references text,
    journal_references text,
    volum_references character varying(128),
    page_references character varying(128),
    status_references character varying(128),
    abstract_references text,
    number_references character varying(128)
);


ALTER TABLE public."REFERENCES" OWNER TO wwwadm;

--
-- Name: categorieparametre; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE categorieparametre (
    id_categorieparametre serial NOT NULL,
    fullname_categorieparametre character varying(128) NOT NULL,
    shortname_categorieparametre character varying(128)
);


ALTER TABLE public.categorieparametre OWNER TO wwwadm;

--
-- Name: code; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE code (
    id_code serial NOT NULL,
    id_codification integer NOT NULL,
    num_code integer NOT NULL,
    legend_code character varying(128) NOT NULL
);


ALTER TABLE public.code OWNER TO wwwadm;

--
-- Name: codification; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE codification (
    id_codification serial NOT NULL,
    id_typecodification integer,
    nom_codification character varying(128),
    comment_codification character varying(128)
);


ALTER TABLE public.codification OWNER TO wwwadm;

--
-- Name: color; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE color (
    col_id serial NOT NULL,
    col_r integer,
    col_g integer,
    col_b integer
);


ALTER TABLE public.color OWNER TO wwwadm;

--
-- Name: color_index; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE color_index (
    cm_id integer NOT NULL,
    col_id integer NOT NULL,
    ci_max double precision NOT NULL
);


ALTER TABLE public.color_index OWNER TO wwwadm;

--
-- Name: colormap; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE colormap (
    cm_id serial NOT NULL,
    cm_name character varying(50)
);


ALTER TABLE public.colormap OWNER TO wwwadm;

--
-- Name: concerne; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE concerne (
    id_produit integer NOT NULL,
    id_references integer NOT NULL
);


ALTER TABLE public.concerne OWNER TO wwwadm;

--
-- Name: domaine; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE domaine (
    id_domaine serial NOT NULL,
    lonmin_domaine double precision NOT NULL,
    lonmax_domaine double precision NOT NULL,
    latmin_domaine double precision NOT NULL,
    latmax_domaine double precision NOT NULL
);


ALTER TABLE public.domaine OWNER TO wwwadm;

--
-- Name: fichier; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE fichier (
    id_fichier serial NOT NULL,
    id_produit integer NOT NULL,
    name_fichier character varying(128) NOT NULL,
    date_fichier timestamp without time zone NOT NULL,
    state_fichier character varying(128) NOT NULL
);


ALTER TABLE public.fichier OWNER TO wwwadm;

--
-- Name: grille; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE grille (
    id_grille serial NOT NULL,
    id_sequence integer,
    id_produit integer,
    id_codification integer,
    id_param integer,
    valeurs_grille oid,
    date_grille date,
    deltadate_grille interval,
    ncol_grille integer,
    nlign_grille integer,
    level_grille double precision
);


ALTER TABLE public.grille OWNER TO wwwadm;

--
-- Name: TABLE grille; Type: COMMENT; Schema: public; Owner: wwwadm
--

COMMENT ON TABLE grille IS 'Delta date fournit, l''intervalle de cumul, de moyenne ......
le type d''aggrégation est fournit par le type de la grille
Date est la fin de cette période

ValeursGrille est un tableau à deux dimensions 720x360 par defaut
les valeurs sont entieres et comprimées via le min/max du parametre de la grille
    v= min + v -min /max-min';


--
-- Name: organisme; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE organisme (
    id_organisme serial NOT NULL,
    fullname_organisme character varying(128) NOT NULL,
    shortname_organisme character varying(128),
    phone_organisme character varying(128),
    fax_organisme character varying(128),
    url_organisme character varying(128),
    address_organisme character varying(128),
    zipcode_organisme character varying(128),
    city_organisme character varying(128),
    country_organisme character varying(128)
);


ALTER TABLE public.organisme OWNER TO wwwadm;

--
-- Name: param_color; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE param_color (
    cm_id integer NOT NULL,
    id_param integer NOT NULL,
    pc_defaut integer
);


ALTER TABLE public.param_color OWNER TO wwwadm;

--
-- Name: parametre; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE parametre (
    id_param serial NOT NULL,
    id_categorieparametre integer,
    id_unite integer,
    fullname_param character varying(128) NOT NULL,
    shortname_param character varying(128),
    min_param character varying(128),
    max_param character varying(128)
);


ALTER TABLE public.parametre OWNER TO wwwadm;

--
-- Name: personne; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE personne (
    id_personne serial NOT NULL,
    id_organisme integer,
    lastname_personne character varying(128) NOT NULL,
    firstname_personne character varying(128) NOT NULL,
    email_personne character varying(128) NOT NULL,
    phone_personne character varying(128),
    fax_personne character varying(128)
);


ALTER TABLE public.personne OWNER TO wwwadm;

--
-- Name: produit; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE produit (
    id_produit serial NOT NULL,
    id_produitorig integer,
    id_contacttech integer,
    id_contactthem integer,
    id_contactbase integer,
    id_domaine integer,
    id_organisme integer,
    title_produit character varying(128) NOT NULL,
    description_produit text,
    begintime_produit date,
    endtime_produit date,
    temporalres_produit character varying(128),
    spatialres_produit character varying(128),
    textcitation_produit text,
    informpub_produit text,
    annotationcitation_produit text
);


ALTER TABLE public.produit OWNER TO wwwadm;

--
-- Name: produitorig; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE produitorig (
    id_produitorig serial NOT NULL,
    title_produitorig character varying(128) NOT NULL,
    temporalres_produitorig character varying(128),
    spatialres_produitorig character varying(128),
    projection_produitorig character varying(128),
    method_produitorig text,
    dataurl_produitorig character varying(128),
    documentation_produitorig character varying(128)[]
);


ALTER TABLE public.produitorig OWNER TO wwwadm;

--
-- Name: requete; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE requete (
    id_requete serial NOT NULL,
    date_requete character varying(128),
    contained_requete text,
    userlastname_requete character varying(128),
    userfirstname_requete character varying(128),
    useremail_requete character varying(128)
);


ALTER TABLE public.requete OWNER TO wwwadm;

--
-- Name: sequence; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE "sequence" (
    id_sequence serial NOT NULL,
    comment_sequence character varying(128)
);


ALTER TABLE public."sequence" OWNER TO wwwadm;

--
-- Name: typecodification; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE typecodification (
    id_typecodification serial NOT NULL,
    name_typecodification character varying(128),
    comment_typecodification character varying(128)
);


ALTER TABLE public.typecodification OWNER TO wwwadm;

--
-- Name: unite; Type: TABLE; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE TABLE unite (
    id_unite serial NOT NULL,
    fullname_unite character varying(128) NOT NULL,
    shortname_unite character varying(128) NOT NULL
);


ALTER TABLE public.unite OWNER TO wwwadm;

--
-- Name: ak_cle_2_domaine; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY domaine
    ADD CONSTRAINT ak_cle_2_domaine UNIQUE (lonmin_domaine, lonmax_domaine, latmin_domaine, latmax_domaine);


--
-- Name: ak_cle_2_organism; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY organisme
    ADD CONSTRAINT ak_cle_2_organism UNIQUE (fullname_organisme);


--
-- Name: ak_cle_2_personne; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY personne
    ADD CONSTRAINT ak_cle_2_personne UNIQUE (lastname_personne, email_personne);


--
-- Name: ak_cle_2_produit; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT ak_cle_2_produit UNIQUE (title_produit);


--
-- Name: ak_cle_2_produito; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY produitorig
    ADD CONSTRAINT ak_cle_2_produito UNIQUE (title_produitorig);


--
-- Name: color_col_r_key; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY color
    ADD CONSTRAINT color_col_r_key UNIQUE (col_r, col_g, col_b);


--
-- Name: color_index_pkey; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY color_index
    ADD CONSTRAINT color_index_pkey PRIMARY KEY (cm_id, col_id, ci_max);


--
-- Name: color_pkey; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY color
    ADD CONSTRAINT color_pkey PRIMARY KEY (col_id);


--
-- Name: colormap_cm_name_key; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY colormap
    ADD CONSTRAINT colormap_cm_name_key UNIQUE (cm_name);


--
-- Name: colormap_pkey; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY colormap
    ADD CONSTRAINT colormap_pkey PRIMARY KEY (cm_id);


--
-- Name: param_color_pkey; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY param_color
    ADD CONSTRAINT param_color_pkey PRIMARY KEY (cm_id, id_param);


--
-- Name: pk_categorieparametre; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY categorieparametre
    ADD CONSTRAINT pk_categorieparametre PRIMARY KEY (id_categorieparametre);


--
-- Name: pk_code; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY code
    ADD CONSTRAINT pk_code PRIMARY KEY (id_code);


--
-- Name: pk_codification; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY codification
    ADD CONSTRAINT pk_codification PRIMARY KEY (id_codification);


--
-- Name: pk_concerne; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY concerne
    ADD CONSTRAINT pk_concerne PRIMARY KEY (id_produit, id_references);


--
-- Name: pk_domaine; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY domaine
    ADD CONSTRAINT pk_domaine PRIMARY KEY (id_domaine);


--
-- Name: pk_fichier; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY fichier
    ADD CONSTRAINT pk_fichier PRIMARY KEY (id_fichier);


--
-- Name: pk_grille; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY grille
    ADD CONSTRAINT pk_grille PRIMARY KEY (id_grille);


--
-- Name: pk_organisme; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY organisme
    ADD CONSTRAINT pk_organisme PRIMARY KEY (id_organisme);


--
-- Name: pk_parametre; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY parametre
    ADD CONSTRAINT pk_parametre PRIMARY KEY (id_param);


--
-- Name: pk_personne; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY personne
    ADD CONSTRAINT pk_personne PRIMARY KEY (id_personne);


--
-- Name: pk_produit; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT pk_produit PRIMARY KEY (id_produit);


--
-- Name: pk_produitorig; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY produitorig
    ADD CONSTRAINT pk_produitorig PRIMARY KEY (id_produitorig);


--
-- Name: pk_references; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY "REFERENCES"
    ADD CONSTRAINT pk_references PRIMARY KEY (id_references);


--
-- Name: pk_requete; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY requete
    ADD CONSTRAINT pk_requete PRIMARY KEY (id_requete);


--
-- Name: pk_sequence; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY "sequence"
    ADD CONSTRAINT pk_sequence PRIMARY KEY (id_sequence);


--
-- Name: pk_typecodification; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY typecodification
    ADD CONSTRAINT pk_typecodification PRIMARY KEY (id_typecodification);


--
-- Name: pk_unite; Type: CONSTRAINT; Schema: public; Owner: wwwadm; Tablespace: 
--

ALTER TABLE ONLY unite
    ADD CONSTRAINT pk_unite PRIMARY KEY (id_unite);


--
-- Name: _references__pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX _references__pk ON "REFERENCES" USING btree (id_references);


--
-- Name: appartient_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX appartient_fk ON grille USING btree (id_sequence);


--
-- Name: appartienta_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX appartienta_fk ON personne USING btree (id_organisme);


--
-- Name: categorieparametre_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX categorieparametre_pk ON categorieparametre USING btree (id_categorieparametre);


--
-- Name: code_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX code_pk ON code USING btree (id_code);


--
-- Name: codification_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX codification_pk ON codification USING btree (id_codification);


--
-- Name: concerne2_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX concerne2_fk ON concerne USING btree (id_references);


--
-- Name: concerne_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX concerne_fk ON concerne USING btree (id_produit);


--
-- Name: concerne_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX concerne_pk ON concerne USING btree (id_produit, id_references);


--
-- Name: contactdatabase_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contactdatabase_fk ON produit USING btree (id_contactthem);


--
-- Name: contacttechnique_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contacttechnique_fk ON produit USING btree (id_contactbase);


--
-- Name: contactthematique_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contactthematique_fk ON produit USING btree (id_contacttech);


--
-- Name: contient_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contient_fk ON fichier USING btree (id_produit);


--
-- Name: contientlescodes_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contientlescodes_fk ON code USING btree (id_codification);


--
-- Name: contientlesgrilles_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX contientlesgrilles_fk ON grille USING btree (id_produit);


--
-- Name: decategorie_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX decategorie_fk ON parametre USING btree (id_categorieparametre);


--
-- Name: deparametre_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX deparametre_fk ON grille USING btree (id_param);


--
-- Name: detype_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX detype_fk ON codification USING btree (id_typecodification);


--
-- Name: domaine_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX domaine_pk ON domaine USING btree (id_domaine);


--
-- Name: dunite_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX dunite_fk ON parametre USING btree (id_unite);


--
-- Name: est_code_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX est_code_fk ON grille USING btree (id_codification);


--
-- Name: fichier_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX fichier_pk ON fichier USING btree (id_fichier);


--
-- Name: fournitpar_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX fournitpar_fk ON produit USING btree (id_organisme);


--
-- Name: grille_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX grille_pk ON grille USING btree (id_grille);


--
-- Name: organisme_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX organisme_pk ON organisme USING btree (id_organisme);


--
-- Name: origine2_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX origine2_fk ON produit USING btree (id_produitorig);


--
-- Name: parametre_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX parametre_pk ON parametre USING btree (id_param);


--
-- Name: personne_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX personne_pk ON personne USING btree (id_personne);


--
-- Name: produit_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX produit_pk ON produit USING btree (id_produit);


--
-- Name: produitorig_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX produitorig_pk ON produitorig USING btree (id_produitorig);


--
-- Name: sequence_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX sequence_pk ON "sequence" USING btree (id_sequence);


--
-- Name: surledomaine_fk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE INDEX surledomaine_fk ON produit USING btree (id_domaine);


--
-- Name: typecodification_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX typecodification_pk ON typecodification USING btree (id_typecodification);


--
-- Name: unite_pk; Type: INDEX; Schema: public; Owner: wwwadm; Tablespace: 
--

CREATE UNIQUE INDEX unite_pk ON unite USING btree (id_unite);


--
-- Name: date_updater; Type: TRIGGER; Schema: public; Owner: wwwadm
--

CREATE TRIGGER date_updater
    AFTER INSERT OR UPDATE ON grille
    FOR EACH ROW
    EXECUTE PROCEDURE date_updater();


--
-- Name: color_index_cm_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY color_index
    ADD CONSTRAINT color_index_cm_id_fkey FOREIGN KEY (cm_id) REFERENCES colormap(cm_id);


--
-- Name: color_index_col_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY color_index
    ADD CONSTRAINT color_index_col_id_fkey FOREIGN KEY (col_id) REFERENCES color(col_id);


--
-- Name: fk_code_contientl_codifica; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY code
    ADD CONSTRAINT fk_code_contientl_codifica FOREIGN KEY (id_codification) REFERENCES codification(id_codification) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_codifica_detype_typecodi; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY codification
    ADD CONSTRAINT fk_codifica_detype_typecodi FOREIGN KEY (id_typecodification) REFERENCES typecodification(id_typecodification) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_concerne_concerne2_referenc; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY concerne
    ADD CONSTRAINT fk_concerne_concerne2_referenc FOREIGN KEY (id_references) REFERENCES "REFERENCES"(id_references) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_concerne_concerne_produit; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY concerne
    ADD CONSTRAINT fk_concerne_concerne_produit FOREIGN KEY (id_produit) REFERENCES produit(id_produit) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_fichier_contient_produit; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY fichier
    ADD CONSTRAINT fk_fichier_contient_produit FOREIGN KEY (id_produit) REFERENCES produit(id_produit) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_grille_appartien_sequence; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY grille
    ADD CONSTRAINT fk_grille_appartien_sequence FOREIGN KEY (id_sequence) REFERENCES "sequence"(id_sequence) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_grille_contientl_produit; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY grille
    ADD CONSTRAINT fk_grille_contientl_produit FOREIGN KEY (id_produit) REFERENCES produit(id_produit) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_grille_deparamet_parametr; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY grille
    ADD CONSTRAINT fk_grille_deparamet_parametr FOREIGN KEY (id_param) REFERENCES parametre(id_param) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_grille_est_code_codifica; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY grille
    ADD CONSTRAINT fk_grille_est_code_codifica FOREIGN KEY (id_codification) REFERENCES codification(id_codification) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_parametr_decategor_categori; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY parametre
    ADD CONSTRAINT fk_parametr_decategor_categori FOREIGN KEY (id_categorieparametre) REFERENCES categorieparametre(id_categorieparametre) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_parametr_dunite_unite; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY parametre
    ADD CONSTRAINT fk_parametr_dunite_unite FOREIGN KEY (id_unite) REFERENCES unite(id_unite) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_personne_appartien_organism; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY personne
    ADD CONSTRAINT fk_personne_appartien_organism FOREIGN KEY (id_organisme) REFERENCES organisme(id_organisme) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_contactda_personne; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_contactda_personne FOREIGN KEY (id_contactthem) REFERENCES personne(id_personne) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_contactte_personne; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_contactte_personne FOREIGN KEY (id_contactbase) REFERENCES personne(id_personne) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_contactth_personne; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_contactth_personne FOREIGN KEY (id_contacttech) REFERENCES personne(id_personne) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_fournitpa_organism; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_fournitpa_organism FOREIGN KEY (id_organisme) REFERENCES organisme(id_organisme) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_origine2_produito; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_origine2_produito FOREIGN KEY (id_produitorig) REFERENCES produitorig(id_produitorig) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: fk_produit_surledoma_domaine; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY produit
    ADD CONSTRAINT fk_produit_surledoma_domaine FOREIGN KEY (id_domaine) REFERENCES domaine(id_domaine) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: param_color_cm_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY param_color
    ADD CONSTRAINT param_color_cm_id_fkey FOREIGN KEY (cm_id) REFERENCES colormap(cm_id);


--
-- Name: param_color_id_param_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wwwadm
--

ALTER TABLE ONLY param_color
    ADD CONSTRAINT param_color_id_param_fkey FOREIGN KEY (id_param) REFERENCES parametre(id_param);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--