20080614update.sql 1.0 KB

123456789101112
  1. ALTER TABLE `custom_armorsets` ADD `skill_lvl` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `skill_id`;
  2. ALTER TABLE `custom_armorsets` MODIFY id SMALLINT UNSIGNED NOT NULL auto_increment;
  3. ALTER TABLE `custom_armorsets` MODIFY chest SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  4. ALTER TABLE `custom_armorsets` MODIFY legs SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  5. ALTER TABLE `custom_armorsets` MODIFY head SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  6. ALTER TABLE `custom_armorsets` MODIFY gloves SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  7. ALTER TABLE `custom_armorsets` MODIFY feet SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  8. ALTER TABLE `custom_armorsets` MODIFY skill_id SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  9. ALTER TABLE `custom_armorsets` MODIFY skill_lvl TINYINT UNSIGNED NOT NULL DEFAULT 0;
  10. ALTER TABLE `custom_armorsets` MODIFY shield SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  11. ALTER TABLE `custom_armorsets` MODIFY shield_skill_id SMALLINT UNSIGNED NOT NULL DEFAULT 0;
  12. ALTER TABLE `custom_armorsets` MODIFY enchant6skill SMALLINT UNSIGNED NOT NULL DEFAULT 0;