20110514update.sql 1.0 KB

12345678910111213141516
  1. ALTER TABLE `character_summons` MODIFY `ownerId` int(10) unsigned NOT NULL;
  2. ALTER TABLE `character_summons` MODIFY `summonSkillId` int(10) unsigned NOT NULL;
  3. ALTER TABLE `character_summons` MODIFY `curHp` int(9) unsigned DEFAULT '0';
  4. ALTER TABLE `character_summons` MODIFY `curMp` int(9) unsigned DEFAULT '0';
  5. ALTER TABLE `character_summons` MODIFY `time` int(10) unsigned NOT NULL DEFAULT '0';
  6. ALTER TABLE `pets` MODIFY `item_obj_id` int(10) unsigned NOT NULL;
  7. ALTER TABLE `pets` MODIFY `name` varchar(16);
  8. ALTER TABLE `pets` MODIFY `level` smallint(2) unsigned NOT NULL;
  9. ALTER TABLE `pets` MODIFY `curHp` int(9) unsigned DEFAULT '0';
  10. ALTER TABLE `pets` MODIFY `curMp` int(9) unsigned DEFAULT '0';
  11. ALTER TABLE `pets` MODIFY `exp` bigint(20) unsigned DEFAULT '0';
  12. ALTER TABLE `pets` MODIFY `sp` int(10) unsigned DEFAULT '0';
  13. ALTER TABLE `pets` MODIFY `fed` int(10) unsigned DEFAULT '0';
  14. ALTER TABLE `pets` MODIFY `ownerId` int(10) NOT NULL DEFAULT '0';
  15. ALTER TABLE `pets` MODIFY `restore` enum('true','false') NOT NULL DEFAULT 'false';