raw_item_details_house_update.sql 572 B

123456789101112
  1. DROP TABLE `raw_item_details_house`;
  2. CREATE TABLE `raw_item_details_house` (
  3. `id` int(10) unsigned NOT NULL auto_increment,
  4. `item_id` int(11) NOT NULL default '0',
  5. `status_rent_reduction` int(10) unsigned NOT NULL default '0',
  6. `coin_rent_reduction` float unsigned default '0' NOT NULL,
  7. `house_unknown2` smallint(6) unsigned default '0' NOT NULL,
  8. `house_only` tinyint(3) unsigned default '0' NOT NULL,
  9. `language_type` tinyint(3) unsigned NOT NULL default '1',
  10. PRIMARY KEY (`id`),
  11. UNIQUE KEY `ItemLanguageIDX` (`item_id`,`language_type`)
  12. ) ENGINE=MyISAM;