Loading...   

  • Created By Uleat On: 02:02 PM March 11, 2018
  • Link

ALTER TABLE `buyer`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augment_1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `quantity`,
 ADD COLUMN `augment_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_1`,
 ADD COLUMN `augment_2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_1_guid`,
 ADD COLUMN `augment_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_2`,
 ADD COLUMN `augment_3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_2_guid`,
 ADD COLUMN `augment_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_3`,
 ADD COLUMN `augment_4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_3_guid`,
 ADD COLUMN `augment_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_4`,
 ADD COLUMN `augment_5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_4_guid`,
 ADD COLUMN `augment_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_5`,
 ADD COLUMN `augment_6` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_5_guid`,
 ADD COLUMN `augment_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_6`;

ALTER TABLE `character_bandolier`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`;

ALTER TABLE `character_corpse_items`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `color` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `charges`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `character_data`
 ADD COLUMN `item_guid_alias_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE `character_pet_inventory`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `augment_1` INT(11) NOT NULL DEFAULT '0' AFTER `item_guid`,
 ADD COLUMN `augment_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_1`,
 ADD COLUMN `augment_2` INT(11) NOT NULL DEFAULT '0' AFTER `augment_1_guid`,
 ADD COLUMN `augment_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_2`,
 ADD COLUMN `augment_3` INT(11) NOT NULL DEFAULT '0' AFTER `augment_2_guid`,
 ADD COLUMN `augment_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_3`,
 ADD COLUMN `augment_4` INT(11) NOT NULL DEFAULT '0' AFTER `augment_3_guid`,
 ADD COLUMN `augment_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_4`,
 ADD COLUMN `augment_5` INT(11) NOT NULL DEFAULT '0' AFTER `augment_4_guid`,
 ADD COLUMN `augment_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_5`,
 ADD COLUMN `augment_6` INT(11) NOT NULL DEFAULT '0' AFTER `augment_5_guid`,
 ADD COLUMN `augment_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_6`;

ALTER TABLE `character_potionbelt`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`;

ALTER TABLE `guild_bank`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augment_1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `qty`,
 ADD COLUMN `augment_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_1`,
 ADD COLUMN `augment_2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_1_guid`,
 ADD COLUMN `augment_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_2`,
 ADD COLUMN `augment_3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_2_guid`,
 ADD COLUMN `augment_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_3`,
 ADD COLUMN `augment_4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_3_guid`,
 ADD COLUMN `augment_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_4`,
 ADD COLUMN `augment_5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_4_guid`,
 ADD COLUMN `augment_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_5`,
 ADD COLUMN `augment_6` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_5_guid`,
 ADD COLUMN `augment_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_6`;

ALTER TABLE `inventory`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augslot1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot1`,
 ADD COLUMN `augslot2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot2`,
 ADD COLUMN `augslot3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot3`,
 ADD COLUMN `augslot4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot4`,
 ADD COLUMN `augslot5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot5`,
 ADD COLUMN `augslot6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot6`;

ALTER TABLE `inventory_snapshots`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augslot1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot1`,
 ADD COLUMN `augslot2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot2`,
 ADD COLUMN `augslot3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot3`,
 ADD COLUMN `augslot4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot4`,
 ADD COLUMN `augslot5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot5`,
 ADD COLUMN `augslot6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot6`;

-- ALTER TABLE `merc_inventory`
--  ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
--  ADD COLUMN `augment_1` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `item_guid`,
--  ADD COLUMN `augment_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_1`,
--  ADD COLUMN `augment_2` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_1_guid`,
--  ADD COLUMN `augment_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_2`,
--  ADD COLUMN `augment_3` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_2_guid`,
--  ADD COLUMN `augment_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_3`,
--  ADD COLUMN `augment_4` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_3_guid`,
--  ADD COLUMN `augment_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_4`,
--  ADD COLUMN `augment_5` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_4_guid`,
--  ADD COLUMN `augment_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_5`,
--  ADD COLUMN `augment_6` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_5_guid`,
--  ADD COLUMN `augment_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_6`;

ALTER TABLE `object_contents`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augslot1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot1`,
 ADD COLUMN `augslot2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot2`,
 ADD COLUMN `augslot3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot3`,
 ADD COLUMN `augslot4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot4`,
 ADD COLUMN `augslot5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot5`,
 ADD COLUMN `augslot6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot6`;

ALTER TABLE `qs_merchant_transaction_record_entries`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6` INT(11) NOT NULL DEFAULT '0' AFTER `aug_5_guid`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `qs_player_delete_record_entries`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6` INT(11) NOT NULL DEFAULT '0' AFTER `aug_5_guid`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `qs_player_handin_record_entries`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6` INT(11) NOT NULL DEFAULT '0' AFTER `aug_5_guid`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `qs_player_move_record_entries`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6` INT(11) NOT NULL DEFAULT '0' AFTER `aug_5_guid`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `qs_player_trade_record_entries`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `aug_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_1`,
 ADD COLUMN `aug_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_2`,
 ADD COLUMN `aug_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_3`,
 ADD COLUMN `aug_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_4`,
 ADD COLUMN `aug_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_5`,
 ADD COLUMN `aug_6` INT(11) NOT NULL DEFAULT '0' AFTER `aug_5_guid`,
 ADD COLUMN `aug_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `aug_6`;

ALTER TABLE `sharedbank`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `itemid`,
 ADD COLUMN `augslot1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot1`,
 ADD COLUMN `augslot2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot2`,
 ADD COLUMN `augslot3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot3`,
 ADD COLUMN `augslot4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot4`,
 ADD COLUMN `augslot5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot5`,
 ADD COLUMN `augslot6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augslot6`;

ALTER TABLE `trader`
 ADD COLUMN `item_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `item_id`,
 ADD COLUMN `augment_1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `charges`,
 ADD COLUMN `augment_1_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_1`,
 ADD COLUMN `augment_2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_1_guid`,
 ADD COLUMN `augment_2_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_2`,
 ADD COLUMN `augment_3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_2_guid`,
 ADD COLUMN `augment_3_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_3`,
 ADD COLUMN `augment_4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_3_guid`,
 ADD COLUMN `augment_4_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_4`,
 ADD COLUMN `augment_5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_4_guid`,
 ADD COLUMN `augment_5_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_5`,
 ADD COLUMN `augment_6` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `augment_5_guid`,
 ADD COLUMN `augment_6_guid` CHAR(17) NOT NULL DEFAULT '0000000000000000' AFTER `augment_6`;

REPLACE INTO `variables` (`varname`, `value`, `information`) VALUES
('item_guid_id_seed', (FLOOR(4999 + (RAND() * 95001))), 'Random seed to start character item guid alias id numbers');

Raw Paste Data