9
3

raw_merchants.sql 2.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. DROP TABLE IF EXISTS `raw_merchant_items`;
  2. DROP TABLE IF EXISTS `raw_merchants`;
  3. CREATE TABLE `raw_merchants` (
  4. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  5. `spawn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  6. `description` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  7. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  8. `log_file` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  9. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  10. PRIMARY KEY (`id`),
  11. UNIQUE KEY `MerchantsIDX` (`spawn_id`,`language_type`)
  12. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  13. DROP TABLE IF EXISTS `raw_merchant_inventory`;
  14. CREATE TABLE `raw_merchant_inventory` (
  15. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  16. `inventory_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  17. `item_name` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  18. `price` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  19. `item_id` INT(10) NOT NULL DEFAULT '0',
  20. `unique_item_id` INT(10) NOT NULL DEFAULT '0',
  21. `stack_size` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  22. `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  23. `item_difficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  24. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  25. `unknown4a` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  26. `unknown4b` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  27. `quantity` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  28. `unknown5` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  29. `tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  30. `status` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  31. `item_id2` INT(10) NOT NULL DEFAULT '0',
  32. `stack_size2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  33. `status2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  34. `station_cash` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  35. `unknown7a` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  36. `unknown7b` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  37. `num_tokens` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  38. `description` TEXT COLLATE latin1_general_ci,
  39. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  40. PRIMARY KEY (`id`),
  41. UNIQUE KEY `InventoryIDX` (`inventory_id`,`item_id`)
  42. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  43. DROP TABLE IF EXISTS `raw_merchant_inventory_tokens`;
  44. CREATE TABLE `raw_merchant_inventory_tokens` (
  45. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  46. `inventory_item_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  47. `token_icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  48. `token_quantity` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  49. `token_id` INT(10) NOT NULL DEFAULT '0',
  50. `token_id2` INT(10) NOT NULL DEFAULT '0',
  51. `token_name` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  52. PRIMARY KEY (`id`),
  53. KEY `TokenIDX` (`inventory_item_id`,`token_id`)
  54. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;