· 8 years ago · May 25, 2018, 04:16 AM
1-- MySQL dump 10.13 Distrib 5.5.12, for Win64 (x86)
2-- Host: localhost Database: world
3-- ------------------------------------------------------
4-- Server version 5.5.12
5-- Dumping routines for database 'world'
6--
7/*!50003 DROP PROCEDURE IF EXISTS `sp_dev_reguid` */;
8DELIMITER ;;
9/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `sp_dev_reguid`()
10BEGIN
11
12 DROP TABLE IF EXISTS `creature_temp`;
13 CREATE TABLE IF NOT EXISTS `creature_temp` (
14 `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
15 `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
16 `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
17 `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
18 `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
19 `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0',
20 `equipment_id` mediumint(9) NOT NULL DEFAULT '0',
21 `position_x` float NOT NULL DEFAULT '0',
22 `position_y` float NOT NULL DEFAULT '0',
23 `position_z` float NOT NULL DEFAULT '0',
24 `orientation` float NOT NULL DEFAULT '0',
25 `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120',
26 `spawndist` float NOT NULL DEFAULT '0',
27 `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0',
28 `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
29 `curmana` int(10) unsigned NOT NULL DEFAULT '0',
30 `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
31 `npcflag` int(10) unsigned NOT NULL DEFAULT '0',
32 `unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
33 `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
34 `old_guid` int(10) unsigned NOT NULL DEFAULT '0',
35 PRIMARY KEY (`guid`),
36 KEY `idx_map` (`map`),
37 KEY `idx_id` (`id`),
38 KEY `idx_oldguid_tmp` (`old_guid`)
39 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System' AUTO_INCREMENT=250001;
40
41
42 ALTER TABLE `creature_addon` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
43 ALTER TABLE `creature_formations` ADD COLUMN `new_guid_leader` INT(10) UNSIGNED NOT NULL;
44 ALTER TABLE `creature_formations` ADD COLUMN `new_guid_member` INT(10) UNSIGNED NOT NULL;
45 ALTER TABLE `game_event_creature` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
46 ALTER TABLE `pool_creature` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
47 ALTER TABLE `game_event_model_equip` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
48 ALTER TABLE `game_event_npc_vendor` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
49 ALTER TABLE `game_event_npcflag` ADD COLUMN `new_guid` INT(10) UNSIGNED NOT NULL;
50 ALTER TABLE `smart_scripts` ADD COLUMN `new_guid` INT(10) NOT NULL;
51
52
53
54 INSERT INTO `creature_temp`
55 (
56 `guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`,
57 `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`,
58 `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`,
59 `unit_flags`, `dynamicflags`, `old_guid`
60 ) SELECT
61 `guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`,
62 `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`,
63 `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`,
64 `unit_flags`, `dynamicflags`, `guid`
65 FROM `creature` WHERE `guid` < 250001 ORDER BY `id` ASC;
66
67 INSERT INTO `creature_temp`
68 (
69 `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`,
70 `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`,
71 `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`,
72 `unit_flags`, `dynamicflags`, `old_guid`
73 ) SELECT
74 `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`,
75 `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`,
76 `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`,
77 `unit_flags`, `dynamicflags`, `guid`
78 FROM `creature` WHERE `guid` > 250000 ORDER BY `id` ASC;
79
80
81 UPDATE game_event_npc_vendor p
82 INNER JOIN creature_temp pp
83 ON p.guid = pp.old_guid
84 SET p.new_guid = pp.guid;
85 UPDATE game_event_npcflag p
86 INNER JOIN creature_temp pp
87 ON p.guid = pp.old_guid
88 SET p.new_guid = pp.guid;
89 UPDATE game_event_model_equip p
90 INNER JOIN creature_temp pp
91 ON p.guid = pp.old_guid
92 SET p.new_guid = pp.guid;
93 UPDATE creature_addon p
94 INNER JOIN creature_temp pp
95 ON p.guid = pp.old_guid
96 SET p.new_guid = pp.guid;
97 UPDATE creature_formations p
98 INNER JOIN creature_temp pp
99 ON p.leaderGUID = pp.old_guid
100 SET p.new_guid_leader = pp.guid;
101 UPDATE creature_formations p
102 INNER JOIN creature_temp pp
103 ON p.memberGUID = pp.old_guid
104 SET p.new_guid_member = pp.guid;
105 UPDATE game_event_creature p
106 INNER JOIN creature_temp pp
107 ON p.guid = pp.old_guid
108 SET p.new_guid = pp.guid;
109 UPDATE pool_creature p
110 INNER JOIN creature_temp pp
111 ON p.guid = pp.old_guid
112 SET p.new_guid = pp.guid;
113 UPDATE smart_scripts p
114 INNER JOIN creature_temp pp
115 ON p.entryorguid = pp.old_guid
116 SET p.new_guid = -pp.guid
117 WHERE
118 entryorguid < 0 AND
119 source_type = 0;
120
121
122 DROP TABLE `creature`;
123 ALTER TABLE `creature_temp` DROP COLUMN `old_guid`;
124 RENAME TABLE `creature_temp` TO `creature`;
125
126
127 ALTER TABLE game_event_npc_vendor DISABLE KEYS;
128 UPDATE `game_event_npc_vendor` SET `guid`=`new_guid`;
129 ALTER TABLE `game_event_npc_vendor` DROP COLUMN `new_guid`;
130 ALTER TABLE game_event_npc_vendor ENABLE KEYS;
131
132 ALTER TABLE game_event_npcflag DISABLE KEYS;
133 UPDATE `game_event_npcflag` SET `guid`=`new_guid`;
134 ALTER TABLE `game_event_npcflag` DROP COLUMN `new_guid`;
135 ALTER TABLE game_event_npcflag ENABLE KEYS;
136
137 ALTER TABLE game_event_model_equip DISABLE KEYS;
138 UPDATE `game_event_model_equip` SET `guid`=`new_guid`;
139 ALTER TABLE `game_event_model_equip` DROP COLUMN `new_guid`;
140 ALTER TABLE game_event_model_equip ENABLE KEYS;
141
142 ALTER TABLE `creature_addon` DROP PRIMARY KEY;
143 UPDATE `creature_addon` SET `guid`=`new_guid`;
144 ALTER TABLE `creature_addon` DROP COLUMN `new_guid`;
145 ALTER TABLE `creature_addon` ADD PRIMARY KEY(`guid`);
146
147 ALTER TABLE creature_formations DISABLE KEYS;
148 UPDATE `creature_formations` SET leaderGUID = new_guid_leader;
149 ALTER TABLE `creature_formations` DROP COLUMN `new_guid_leader`;
150 UPDATE `creature_formations` SET memberGUID = new_guid_member;
151 ALTER TABLE `creature_formations` DROP COLUMN `new_guid_member`;
152 ALTER TABLE creature_formations ENABLE KEYS;
153
154 ALTER TABLE `game_event_creature` DROP PRIMARY KEY;
155 UPDATE `game_event_creature` SET guid = new_guid;
156 ALTER TABLE `game_event_creature` DROP COLUMN `new_guid`;
157 ALTER TABLE `game_event_creature` ADD PRIMARY KEY(`guid`, `eventEntry`);
158
159 ALTER TABLE `pool_creature` DROP PRIMARY KEY;
160 UPDATE `pool_creature` SET guid = new_guid;
161 ALTER TABLE `pool_creature` DROP COLUMN `new_guid`;
162 ALTER TABLE `pool_creature` ADD PRIMARY KEY(`guid`);
163
164 ALTER TABLE `smart_scripts` DROP PRIMARY KEY;
165 UPDATE `smart_scripts` SET `entryorguid` = `new_guid`
166 WHERE entryorguid < 0 AND new_guid < 0 AND source_type = 0;
167 ALTER TABLE `smart_scripts` DROP COLUMN `new_guid`;
168 ALTER TABLE `smart_scripts` ADD PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`);
169
170 END */;;