Project

General

Profile

« Previous | Next » 

Revision 6528

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/newWorld/geoscrub.schema.~.changes.sql: Reversed order of adding unique constraints and changing types

View differences:

inputs/newWorld/geoscrub.schema.~.changes.sql
1 
ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd");
2 
ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode");
3 

  		




  4
  1
  
    
ALTER TABLE "newWorldCountries"


  		




  5
  2
  
    
  ALTER COLUMN "isoCode" TYPE text


  		




  6
  3
  
    
, ALTER COLUMN "isNewWorld" DROP DEFAULT


  		




  7
  4
  
    
, ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean


  		




  8
  5
  
    
, ALTER COLUMN "countryNameStd" TYPE text


  		




  9
  6
  
    
;


  		




  
  7
  
    

  		




  
  8
  
    
ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd");


  		




  
  9
  
    
ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode");


  		












Also available in:  Unified diff