Changes between Version 26 and Version 27 of Download and load RHT

Timestamp:

Sep 22, 2011 2:17:49 PM (14 years ago)

Author:

celine

Comment:

--

Download and load RHT

@@ -137 +137 @@
 alter table rht_simulation set schema rht
 }}}
+
+New version attribut
+{{{
+drop table if exists rht.attributs_rht_fev_2011;
+alter table "Attributs_RHT_fev_2011_vs2" set schema rht;
+ALTER TABLE rht."Attributs_RHT_fev_2011_vs2" RENAME TO attributs_rht_fev_2011_vs2;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "ID_DRAIN" TO ID_DRAIN;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "TJAN_MOY" TO TJAN_MOY;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "TJUIL_MOY" TO TJUIL_MOY;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "NONCALC" TO NONCALC;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "REGION_CSP" TO REGION_CSP;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "D_SOURCE" TO D_SOURCE;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "ALTITUDE" TO ALTITUDE;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "SFBVU" TO SFBVU;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "long" TO LONG_;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "STRAHLER" TO STRAHLER;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "SURF_BVICinf" TO SURF_BVICinf;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "SURF_BV" TO SURF_BV;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "SURF_BVICsup" TO SURF_BVICsup;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PENTEICinf" TO PENTEICinf;      
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PENTE" TO PENTE;      
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PENTEICsup" TO PENTEICsup;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MINQMXICinf" TO MINQMXICinf;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MINQMX" TO MINQMX;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MINQMXICsup" TO MINQMXICsup;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MODULE_ICinf" TO MODULE_ICinf;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MODULE_" TO MODULE;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "MODULE_ICsup" TO MODULE_ICsup;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "LICinf" TO LICinf;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "L" TO L;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "LICsup" TO LICsup;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "HICinf" TO HICinf;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "H" TO H;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "HICsup" TO HICsup;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_ABL" TO PESP_ABL;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_ANG" TO PESP_ANG;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BAF" TO PESP_BAF;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BAM" TO PESP_BAM;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BLN" TO PESP_BLN;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BOU" TO PESP_BOU;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BRB" TO PESP_BRB;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_BRO" TO PESP_BRO;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_CAS" TO PESP_CAS;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_CCO" TO PESP_CCO;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_CHA" TO PESP_CHA;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_CHE" TO PESP_CHE;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_EPI" TO PESP_EPI;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_EPT" TO PESP_EPT;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_GAR" TO PESP_GAR;
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_GOU" TO PESP_GOU;  
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_GRE" TO PESP_GRE;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_HOT" TO PESP_HOT;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_LOF" TO PESP_LOF;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_LOT" TO PESP_LOT;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_LPP" TO PESP_LPP;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_OBR" TO PESP_OBR;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_PCH" TO PESP_PCH;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_PER" TO PESP_PER;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_PES" TO PESP_PES;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_ROT" TO PESP_ROT;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_SAN" TO PESP_SAN;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_SAT" TO PESP_SAT;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_SPI" TO PESP_SPI;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_TAN" TO PESP_TAN;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_TOX" TO PESP_TOX;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_TRF" TO PESP_TRF;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_VAI" TO PESP_VAI;   
+ALTER TABLE rht.Attributs_RHT_fev_2011_vs2 RENAME COLUMN "PESP_VAN" TO PESP_VAN;   
+
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.tjan_moy IS 'Température minimale moyenne de air en janvier(°C)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.tjuil_moy IS 'Température maximale moyenne de air en juillet(°C)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.surf_bv IS 'Surperficie du bassin versant (km²)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.surf_bvicinf IS 'Limite inférieure IC de Surperficie du bassin versant (km²)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.surf_bvicsup IS 'Limite supérieure IC de Surperficie du bassin versant (km²)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.pente IS 'Pente moyenne du bassin versant (m/km)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.penteicinf IS 'Limite inférieure IC de la Pente moyenne du bassin versant (m/km)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.penteicsup IS 'Limite supérieure IC de la Pente moyenne du bassin versant (m/km)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.altitude IS 'Altitude moyenne du bassin versant (m)';
+COMMENT ON COLUMN rht.attributs_rht_fev_2011_vs2.module IS 'Module (m^3/s)';
+}}}