aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_06_02_00_world_phases_434.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/sql/updates/world/2014_06_02_00_world_phases_434.sql b/sql/updates/world/2014_06_02_00_world_phases_434.sql
index e36d4f50deb..1c1b0a19f23 100644
--- a/sql/updates/world/2014_06_02_00_world_phases_434.sql
+++ b/sql/updates/world/2014_06_02_00_world_phases_434.sql
@@ -24,4 +24,8 @@ CREATE TABLE `phase_info` (
`terrainswapmap` int(10) unsigned NOT NULL DEFAULT '0',
`comment` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `transports`
+ ADD COLUMN `phaseid` INT(10) NOT NULL DEFAULT 0 AFTER `name`,
+ ADD COLUMN `phasegroup` INT(10) NOT NULL DEFAULT 0 AFTER `phaseid`; \ No newline at end of file