9
3

spawn_location_placement-5-9-22.sql 1.7 KB

1234567891011121314151617
  1. ALTER TABLE `spawn_location_placement` ADD COLUMN `lvl_override` INT NOT NULL DEFAULT '0' AFTER `instance_id`;
  2. ALTER TABLE `spawn_location_placement` ADD COLUMN `hp_override` INT NOT NULL DEFAULT '0' AFTER `lvl_override`;
  3. ALTER TABLE `spawn_location_placement` ADD COLUMN `mp_override` INT NOT NULL DEFAULT '0' AFTER `hp_override`;
  4. ALTER TABLE `spawn_location_placement` ADD COLUMN `str_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `mp_override`;
  5. ALTER TABLE `spawn_location_placement` ADD COLUMN `sta_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `str_override`;
  6. ALTER TABLE `spawn_location_placement` ADD COLUMN `wis_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `sta_override`;
  7. ALTER TABLE `spawn_location_placement` ADD COLUMN `int_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `wis_override`;
  8. ALTER TABLE `spawn_location_placement` ADD COLUMN `agi_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `int_override`;
  9. ALTER TABLE `spawn_location_placement`
  10. ADD COLUMN `heat_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `agi_override`,
  11. ADD COLUMN `cold_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `heat_override`,
  12. ADD COLUMN `magic_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `cold_override`,
  13. ADD COLUMN `mental_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `magic_override`,
  14. ADD COLUMN `divine_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `mental_override`,
  15. ADD COLUMN `disease_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `divine_override`,
  16. ADD COLUMN `poison_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `disease_override`,
  17. ADD COLUMN `difficulty_override` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `poison_override`;