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