20110514update.sql 754 B

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