Changes between Version 2 and Version 3 of CLC upstream


Ignore:
Timestamp:
Jun 15, 2010 5:43:19 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • CLC upstream

    v2 v3  
    2727  (gid); 
    2828}}} 
     29 
     30{{{ 
     31#!sql 
     32ALTER TABLE ccm21.riversegments add column catchment_area numeric; 
     33ALTER TABLE ccm21.riversegments add column up_catchment_area numeric; 
     34ALTER TABLE ccm21.riversegments add column art_11_13 numeric; 
     35ALTER TABLE ccm21.riversegments add column up_art_11_13 numeric; 
     36ALTER TABLE ccm21.riversegments add column art_14 numeric; 
     37ALTER TABLE ccm21.riversegments add column up_art_14 numeric; 
     38ALTER TABLE ccm21.riversegments add column arable_21 numeric; 
     39ALTER TABLE ccm21.riversegments add column up_arable_21 numeric; 
     40ALTER TABLE ccm21.riversegments add column permcrop_22 numeric; 
     41ALTER TABLE ccm21.riversegments add column up_permcrop_22 numeric; 
     42ALTER TABLE ccm21.riversegments add column pasture_23 numeric; 
     43ALTER TABLE ccm21.riversegments add column up_pasture_23 numeric; 
     44ALTER TABLE ccm21.riversegments add column harable_24 numeric; 
     45ALTER TABLE ccm21.riversegments add column up_harable_24 numeric; 
     46ALTER TABLE ccm21.riversegments add column forest_31 numeric; 
     47ALTER TABLE ccm21.riversegments add column up_forest_31 numeric; 
     48ALTER TABLE ccm21.riversegments add column natural_32_33 numeric; 
     49ALTER TABLE ccm21.riversegments add column up_natural_32_33 numeric; 
     50ALTER TABLE ccm21.riversegments add column wetlands_4 numeric; 
     51ALTER TABLE ccm21.riversegments add column up_wetlands_4 numeric; 
     52ALTER TABLE ccm21.riversegments add column inwat_51 numeric; 
     53ALTER TABLE ccm21.riversegments add column up_inwat_51 numeric; 
     54ALTER TABLE ccm21.riversegments add column marwat_52 numeric; 
     55ALTER TABLE ccm21.riversegments add column up_marwat_52 numeric; 
     56}}}