MerchantItems.sql 1.2 KB

123456789101112131415161718192021222324
  1. CREATE TABLE `raw_merchant_items` (
  2. `id` int(10) unsigned NOT NULL auto_increment,
  3. `spawn_id` int(10) unsigned NOT NULL default '0',
  4. `item_id` int(10) unsigned NOT NULL,
  5. `item_name` varchar(128) NOT NULL default ' ',
  6. `unknown` tinyint(3) unsigned NOT NULL default '0',
  7. `price` int(10) unsigned NOT NULL default '0',
  8. `unknown2` int(10) unsigned NOT NULL default '0',
  9. `stack_size` smallint(5) unsigned NOT NULL default '0',
  10. `icon` smallint(5) unsigned NOT NULL default '0',
  11. `unknown3` tinyint(3) unsigned NOT NULL default '0',
  12. `level` tinyint(3) unsigned NOT NULL default '0',
  13. `unknown4` tinyint(3) unsigned NOT NULL default '0',
  14. `unknown5` smallint(5) unsigned NOT NULL default '0',
  15. `tier` tinyint(3) unsigned NOT NULL default '0',
  16. `unknown6` int(10) unsigned NOT NULL default '0',
  17. `item_id2` int(10) unsigned NOT NULL default '0',
  18. `stack_size2` smallint(5) unsigned NOT NULL default '0',
  19. `description` varchar(512) NOT NULL default ' ',
  20. `log_file` varchar(128) NOT NULL default ' ',
  21. `language_type` tinyint(3) unsigned NOT NULL default '0',
  22. PRIMARY KEY (`id`),
  23. UNIQUE KEY `SpawnItemNDX` (`item_id`,`spawn_id`)
  24. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;