1 ALTER TABLE `game_graveyard_zone`
2 DROP COLUMN `ghost_map`;
4 UPDATE `game_graveyard_zone` as G1,`game_graveyard_zone` as G2
6 WHERE G1.`id`=G2.`id` AND G1.`ghost_zone`=G2.`ghost_zone` AND G1.`faction`=67 AND (G2.`faction`=469 OR G2.`faction`=0);
8 UPDATE `game_graveyard_zone` as G1,`game_graveyard_zone` as G2
10 WHERE G1.`id`=G2.`id` AND G1.`ghost_zone`=G2.`ghost_zone` AND G1.`faction`=469 AND (G2.`faction`=67 OR G2.`faction`=0);
12 DELETE FROM `game_graveyard_zone` WHERE `ghost_zone`= 0;
14 DROP TABLE IF EXISTS `game_graveyard_zone_new`;
15 CREATE TABLE `game_graveyard_zone_new` (
16 `id` int(11) unsigned NOT NULL default '0',
17 `ghost_zone` int(11) unsigned NOT NULL default '0',
18 `faction` int(11) unsigned NOT NULL default '0',
19 PRIMARY KEY (`id`,`ghost_zone`)
20 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
22 INSERT IGNORE INTO `game_graveyard_zone_new` SELECT `id`,`ghost_zone`,`faction` FROM `game_graveyard_zone`;
24 DROP TABLE `game_graveyard_zone`;
25 RENAME TABLE `game_graveyard_zone_new` TO `game_graveyard_zone`;