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

[virusav]

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.

[Schmoozerd]

Thanks very much for pointing.

I will look into this beginning of next year, probably a simple problem I wasn't aware of (me = sql n00b)

[virusav]

Checking the relevance of the topic.

[Schmoozerd]

hmm, isn't it best to just remove the AUTO_INCREMENT from the first collumn?

I see no reason for 0 as default values

[virusav]

Now that the tables have mangos specific format for the fields, we have to stick to this format and in this table.

[Schmoozerd]

in [11876]. THank you