20110210update.sql 343 B

123456789
  1. ALTER TABLE `character_offline_trade_items`
  2. MODIFY `charId` int(10) unsigned NOT NULL;
  3. ALTER TABLE `character_offline_trade`
  4. MODIFY `charId` int(10) unsigned NOT NULL;
  5. UPDATE `character_reco_bonus` SET `rec_have`=255 WHERE `rec_have`>255;
  6. ALTER TABLE `character_reco_bonus`
  7. MODIFY `rec_have` tinyint(3) unsigned NOT NULL DEFAULT '0';