back to the first page..

CREATE TABLE rht.model_mod
(
  mod_id serial NOT NULL,
  mod_name character varying(30) NOT NULL,
  mod_date date,
  mod_description text NOT NULL,
  mod_location character varying(25), -- Geographical area to which the model is applied, should be consistent with europe.wso
  mod_formula text,
  CONSTRAINT model_mod_pkey PRIMARY KEY (mod_id),
  CONSTRAINT model_mod_mod_name_key UNIQUE (mod_name)
);

DROP TABLE IF EXISTS rht.resultmodel;
CREATE TABLE rht.resultmodel
(
  res_id serial NOT NULL,
  res_id_drain integer,
  res_value double precision,
  res_mod_id integer,
  CONSTRAINT resultmodel_pkey PRIMARY KEY (res_id),
  CONSTRAINT c_fk_res_mod_id FOREIGN KEY (res_mod_id)
      REFERENCES rht.model_mod (mod_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
);

drop table if exists ccm21.resultmodelBasque;
create table ccm21.resultmodelBasque as (
select sub1.*,
        sub2.res_value as mdxmpa
          from
        (select wso1_id,cum_len_sea as dsea,res_value as mpa, the_geom from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
        res_mod_id=12) as sub1
join
        (select wso1_id, res_value from ccm21.riversegments join ccm21.resultmodel on res_wso1_id=wso1_id where 
        res_mod_id=15) as sub2
        on sub1.wso1_id=sub2.wso1_id
);

create index indextableresultmod on ccm21.resultmodelBasque using gist(the_geom);

alter table ccm21.resultmodelBasque add CONSTRAINT resultmodel_pkey PRIMARY KEY (wso1_id);