9
3

Misc item unknown updates.sql 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. DROP TABLE IF EXISTS `raw_item_details_thrown`;
  2. CREATE TABLE `raw_item_details_thrown` (
  3. `id` int(10) unsigned NOT NULL auto_increment,
  4. `item_id` int(11) NOT NULL default '0',
  5. `range` int(11) NOT NULL default '0',
  6. `damage_modifier` int(11) NOT NULL default '0',
  7. `hit_bonus` float NOT NULL default '0',
  8. `damage_type` int(10) unsigned NOT NULL default '0',
  9. `language_type` tinyint(3) unsigned NOT NULL default '1',
  10. PRIMARY KEY (`id`),
  11. UNIQUE KEY `NewIndex` (`item_id`,`language_type`)
  12. ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
  13. ALTER TABLE `raw_item_details_house` CHANGE `status_rent_reduction` `status_rent_reduction` INT DEFAULT '0' NOT NULL;
  14. ALTER TABLE `raw_item_details_house_container` DROP `disallowed_types`;
  15. ALTER TABLE `raw_item_details_house_container` CHANGE `allowed_types` `allowed_types` INT UNSIGNED DEFAULT '0' NOT NULL;
  16. ALTER TABLE `raw_item_details_house_container` CHANGE `unknown13` `unknown13` TINYINT UNSIGNED DEFAULT '0' NOT NULL;
  17. ALTER TABLE `raw_item_details_house_container` CHANGE `unknown14` `broker_commission` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
  18. ALTER TABLE `raw_item_details_house_container` CHANGE `unknown15` `fence_commission` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
  19. ALTER TABLE `raw_item_details_recipe` CHANGE `unknown12` `uses` SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL;
  20. ALTER TABLE `raw_item_details_recipe` DROP `unknown13`, DROP `unknown14`;
  21. ALTER TABLE `raw_item_details_book` CHANGE `unknown1` `language` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
  22. ALTER TABLE `raw_item_details_book` DROP `unknown2`;
  23. ALTER TABLE `raw_item_details_book` ADD `author` VARCHAR(255) NOT NULL AFTER `language`;
  24. ALTER TABLE `raw_item_details_book` ADD `title` VARCHAR(255) NOT NULL AFTER `author`;
  25. ALTER TABLE `raw_spawn_unknowns` CHANGE `value` `value` VARCHAR(50) NOT NULL;