Files
2014-12-13 15:01:32 +01:00

16 lines
496 B
SQL

UPDATE `Countries` SET `CurrencyCode`='EUR', `PostalCodeLength`='6' WHERE `Code`='NL'
#
ALTER TABLE `PostalCodes`
CHANGE COLUMN `Lat` `Latitude` DOUBLE NOT NULL DEFAULT 0.0 ,
CHANGE COLUMN `Long` `Longitude` DOUBLE NOT NULL DEFAULT 0.0
#
ALTER TABLE `People`
ADD COLUMN `Latitude` DOUBLE NOT NULL DEFAULT 0.0 AFTER `GeographyId`,
ADD COLUMN `Longitude` DOUBLE NOT NULL DEFAULT 0.0 AFTER `Latitude`,
ADD INDEX `Index_Latitude` (`Latitude` ASC),
ADD INDEX `Index_Longitude` (`Longitude` ASC)