Project

General

Profile

« Previous | Next » 

Revision 6107

inputs/newWorld/geoscrub.schema.~.changes.sql: ALTER TABLE ... ALTER COLUMN statement: Reformatted to allow adding additional ALTER COLUMN clauses

View differences:

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

  
3 3
ALTER TABLE "newWorldCountries"
4
ALTER COLUMN "isNewWorld" DROP DEFAULT
5
, ALTER COLUMN "isNewWorld" TYPE boolean
6
USING "isNewWorld"::boolean;
4
  ALTER COLUMN "isNewWorld" DROP DEFAULT
5
, ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean
6
;

Also available in: Unified diff