20130603update.sql 490 B

12345678
  1. DROP TABLE `merchant_buylists`;
  2. DROP TABLE `merchant_shopids`;
  3. ALTER TABLE `npcskills` DROP PRIMARY KEY, ADD PRIMARY KEY (`npcid`, `skillid`);
  4. ALTER TABLE `custom_droplist` MODIFY `mobId` MEDIUMINT(7) UNSIGNED;
  5. DROP TABLE `custom_merchant_buylists`;
  6. DROP TABLE `custom_merchant_shopids`;
  7. ALTER TABLE `custom_npc_buffer` MODIFY `npc_id` MEDIUMINT(7) UNSIGNED;
  8. ALTER TABLE `custom_npcskills` DROP PRIMARY KEY, ADD PRIMARY KEY (`npcid`, `skillid`), MODIFY `npcid` MEDIUMINT(7) UNSIGNED;