Jump to content

[11876][patch][sql]`creature_linking_template`


Guest virusav

Recommended Posts

Somehow, in the table `creature_linking_template` field in a format different from counterparts in other tables, and `entry` in general have auto-incremented.

Patch:

ALTER TABLE `creature_linking_template` CHANGE COLUMN `entry` `entry` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'creature_template.entry of the slave mob that is linked';
ALTER TABLE `creature_linking_template` CHANGE COLUMN `map` `map` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Id of map of the mobs';
ALTER TABLE `creature_linking_template` CHANGE COLUMN `master_entry` `master_entry` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'master to trigger events';
ALTER TABLE `creature_linking_template` CHANGE COLUMN `flag` `flag` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'flag - describing what should happen when';

In mangos.sql make table query should look like this:

CREATE TABLE `creature_linking_template` (
 `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'creature_template.entry of the slave mob that is linked',
 `map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Id of map of the mobs',
 `master_entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'master to trigger events',
 `flag` mediumint(8) unsigned NOT NULL default '0' COMMENT 'flag - describing what should happen when',
 PRIMARY KEY  (`entry`,`map`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature Linking System';

And again, in the tables `spell_pet_auras` and `spell_script_target` somehow encoding is latin1, though always utf8.

Link to comment
Share on other sites

  • 3 weeks later...
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use