Project

General

Profile

Download (341 Bytes) Statistics
| Revision:

root/inputs/newWorld/geoscrub.schema.~.changes.sql @ 7748

1 6017 aaronmk 
ALTER TABLE "newWorldCountries"
2 6527 aaronmk 
  ALTER COLUMN "isoCode" TYPE text
3 
, ALTER COLUMN "isNewWorld" DROP DEFAULT
4 6107 aaronmk 
, ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean
5 6108 aaronmk 
, ALTER COLUMN "countryNameStd" TYPE text
6 6107 aaronmk 
;
7 6528 aaronmk 

      

      

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


      

      

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