[committed] DB improvements, '/object copy'

[Dre]

I do some changes, it's separed in 2 files:

db_improvements.patch:
- Changed: some indexes in tables based on queries.

minor_changes.patch
- Add: '/object copy' command to copy a targeted object.
- Bugfix: LanguageMgr.GetTranslation don't fail when "client.Account" is null.
- Change: No more useless cast when access to GuildMgr.SocialWindowMember indexer.

[Dre]

I forget sql script for conversion of existing databases:

Code: Select all

ALTER TABLE `appeal` CHANGE `Name` `Name` VARCHAR(255) NOT NULL , CHANGE `Account` `Account` VARCHAR(255) NOT NULL;
ALTER TABLE `appeal` ADD INDEX (`Name`);
ALTER TABLE `appeal` ADD INDEX (`Accout`);
ALTER TABLE `dbhousemerchant` ADD INDEX (`HouseNumber`);
ALTER TABLE `door` ADD INDEX (`InternalID`);
ALTER TABLE `factionaggrolevel` CHANGE `CharacterID` `CharacterID` VARCHAR(255) NOT NULL;
ALTER TABLE `factionaggrolevel` ADD INDEX (`CharacterID`);
ALTER TABLE `inventory` ADD INDEX (`SlotPosition`);
ALTER TABLE `keephookpoint` ADD INDEX (`HookPointID`);
ALTER TABLE `keephookpoint` ADD INDEX (`Height`);
ALTER TABLE `keephookpointitem` ADD INDEX (`KeepID`);
ALTER TABLE `keephookpointitem` ADD INDEX (`ComponentID`);
ALTER TABLE `keephookpointitem` ADD INDEX (`HookPointID`);
ALTER TABLE `keepposition` CHANGE `TemplateID` `TemplateID` VARCHAR(255) NULL DEFAULT NULL, CHANGE `ClassType` `ClassType` VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE `keepposition` ADD INDEX (`ComponentSkin`);
ALTER TABLE `keepposition` ADD INDEX (`TemplateID`);
ALTER TABLE `keepposition` ADD INDEX (`Height`);
ALTER TABLE `keepposition` ADD INDEX (`ClassType`);
ALTER TABLE `loototd` ADD INDEX (`ItemTemplateID`);
ALTER TABLE `mob` ADD INDEX (`Name`);
ALTER TABLE `mob` ADD INDEX (`HouseNumber`);
ALTER TABLE `mobxloottemplate` ADD INDEX (`MobName`);
ALTER TABLE `mobxloottemplate` ADD INDEX (`LootTemplateName`);
ALTER TABLE `salvage` ADD INDEX (`ObjectType`);
ALTER TABLE `salvage` ADD INDEX (`SalvageLevel`);
ALTER TABLE `salvage` ADD INDEX (`Realm`);
ALTER TABLE `teleport` CHANGE `TeleportID` `TeleportID` VARCHAR(255) NOT NULL;
ALTER TABLE `teleport` ADD INDEX (`TeleportID`);
ALTER TABLE `zones` ADD INDEX (`RegionID`);

[Graveen]

Thank you Dre

[Dre]

I forget a line in "/object copy":

Code: Select all

item.LoadedFromScript = targetObject.LoadedFromScript;

[Graveen]

Accepted, soon in SVN, thank you.