sql/updates/0.6/2448_game_graveyard.sql

   1 ALTER TABLE `game_graveyard_zone`
   2   ADD COLUMN `faction` int(11) unsigned NOT NULL default '0' AFTER `ghost_zone`;
   3
   4 UPDATE `game_graveyard_zone`,`game_graveyard`
   5   SET `game_graveyard_zone`.`faction`     = `game_graveyard`.`faction`
   6   WHERE `game_graveyard_zone`.`id` = `game_graveyard`.`id`;
   7
   8
   9 DROP TABLE IF EXISTS `game_graveyard`;