9 lines
402 B
SQL
9 lines
402 B
SQL
ALTER TABLE `aowow_taxinodes`
|
|
CHANGE COLUMN `posX` `mapX` float unsigned NOT NULL,
|
|
CHANGE COLUMN `posY` `mapY` float unsigned NOT NULL,
|
|
ADD COLUMN `areaId` smallint(5) unsigned NOT NULL AFTER `mapY`,
|
|
ADD COLUMN `areaX` float unsigned NOT NULL AFTER `areaId`,
|
|
ADD COLUMN `areaY` float unsigned NOT NULL AFTER `areaX`
|
|
;
|
|
|
|
UPDATE `aowow_dbversion` SET `sql` = CONCAT(IFNULL(`sql`, ''), ' taxi');
|