Changes between Version 7 and Version 8 of CLC upstream


Ignore:
Timestamp:
Jun 18, 2010 11:04:24 AM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CLC upstream

    v7 v8  
    3131{{{ 
    3232#!sql 
    33 ALTER TABLE ccm21.riversegments add column catchment_area numeric; 
     33ALTER TABLE ccm21.riversegments drop column catchment_area numeric; 
    3434ALTER TABLE ccm21.riversegments add column up_catchment_area numeric; 
    35 ALTER TABLE ccm21.riversegments add column art_11_13 numeric; 
     35ALTER TABLE ccm21.riversegments drop column art_11_13 numeric; 
    3636ALTER TABLE ccm21.riversegments add column up_art_11_13 numeric; 
    37 ALTER TABLE ccm21.riversegments add column art_14 numeric; 
     37ALTER TABLE ccm21.riversegments drop column art_14 numeric; 
    3838ALTER TABLE ccm21.riversegments add column up_art_14 numeric; 
    39 ALTER TABLE ccm21.riversegments add column arable_21 numeric; 
     39ALTER TABLE ccm21.riversegments drop column arable_21 numeric; 
    4040ALTER TABLE ccm21.riversegments add column up_arable_21 numeric; 
    41 ALTER TABLE ccm21.riversegments add column permcrop_22 numeric; 
     41ALTER TABLE ccm21.riversegments drop column permcrop_22 numeric; 
    4242ALTER TABLE ccm21.riversegments add column up_permcrop_22 numeric; 
    43 ALTER TABLE ccm21.riversegments add column pasture_23 numeric; 
     43ALTER TABLE ccm21.riversegments drop column pasture_23 numeric; 
    4444ALTER TABLE ccm21.riversegments add column up_pasture_23 numeric; 
    45 ALTER TABLE ccm21.riversegments add column hetagr_24 numeric; 
     45ALTER TABLE ccm21.riversegments drop column hetagr_24 numeric; 
    4646ALTER TABLE ccm21.riversegments add column up_hetagr_24 numeric; 
    47 ALTER TABLE ccm21.riversegments add column forest_31 numeric; 
     47ALTER TABLE ccm21.riversegments drop column forest_31 numeric; 
    4848ALTER TABLE ccm21.riversegments add column up_forest_31 numeric; 
    49 ALTER TABLE ccm21.riversegments add column natural_32_33 numeric; 
     49ALTER TABLE ccm21.riversegments drop column natural_32_33 numeric; 
    5050ALTER TABLE ccm21.riversegments add column up_natural_32_33 numeric; 
    51 ALTER TABLE ccm21.riversegments add column wetlands_4 numeric; 
     51ALTER TABLE ccm21.riversegments drop column wetlands_4 numeric; 
    5252ALTER TABLE ccm21.riversegments add column up_wetlands_4 numeric; 
    53 ALTER TABLE ccm21.riversegments add column inwat_51 numeric; 
     53ALTER TABLE ccm21.riversegments drop column inwat_51 numeric; 
    5454ALTER TABLE ccm21.riversegments add column up_inwat_51 numeric; 
    55 ALTER TABLE ccm21.riversegments add column marwat_52 numeric; 
     55ALTER TABLE ccm21.riversegments drop column marwat_52 numeric; 
    5656ALTER TABLE ccm21.riversegments add column up_marwat_52 numeric; 
    5757}}}