raw db updates.sql 942 B

12345678
  1. ALTER TABLE `raw_items` CHANGE COLUMN `item_type` `item_type` ENUM('Normal','Armor','Food','Bag','Weapon','Ranged','Shield','Spell Scroll','Recipe','Book','House','Thrown','Bauble','House Container','Adornment','Pattern','Armor Set') NOT NULL DEFAULT 'Normal' AFTER `name`;
  2. ALTER TABLE `raw_items` ADD `lore_equip` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `evil_only`;
  3. ALTER TABLE `raw_items` ADD `ornate` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `lore_equip`;
  4. ALTER TABLE `raw_items` ADD `heirloom` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `ornate`;
  5. ALTER TABLE `raw_items` ADD `appearance_only` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `heirloom`;
  6. ALTER TABLE `raw_item_descriptions` DROP COLUMN `flags`;
  7. ALTER TABLE `raw_item_descriptions` ADD `flags1` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `tier`;
  8. ALTER TABLE `raw_item_descriptions` ADD `flags2` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `flags1`;