raw_collections.sql 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. # HeidiSQL Dump
  2. #
  3. # --------------------------------------------------------
  4. # Host: 127.0.0.1
  5. # Database: parser
  6. # Server version: 5.1.31-community
  7. # Server OS: Win32
  8. # Target-Compatibility: MySQL 5.0
  9. # max_allowed_packet: 1048576
  10. # HeidiSQL version: 3.2 Revision: 1129
  11. # --------------------------------------------------------
  12. /*!40100 SET CHARACTER SET latin1*/;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;
  14. #
  15. # Table structure for table 'raw_collections'
  16. #
  17. CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_collections` (
  18. `unknown` tinyint(3) unsigned NOT NULL,
  19. `collection_name` varchar(512) NOT NULL,
  20. `collection_category` varchar(512) NOT NULL,
  21. `unknown2` tinyint(3) unsigned NOT NULL,
  22. `unknown6` tinyint(3) unsigned NOT NULL,
  23. `unknown7` tinyint(3) unsigned NOT NULL,
  24. `unknown8` tinyint(3) unsigned NOT NULL,
  25. `unknown9` tinyint(3) unsigned NOT NULL,
  26. `unknown10` tinyint(3) unsigned NOT NULL,
  27. `level` tinyint(3) unsigned NOT NULL,
  28. `num_items` tinyint(3) unsigned NOT NULL,
  29. `item_icon` smallint(5) unsigned NOT NULL,
  30. `item_name` varchar(512) DEFAULT NULL,
  31. `unknown4` tinyint(3) unsigned DEFAULT NULL,
  32. `item_id` int(11) DEFAULT NULL,
  33. `item_crc` int(11) DEFAULT NULL,
  34. `log_file` varchar(255) DEFAULT ''
  35. ) ENGINE=InnoDB /*!40100 DEFAULT CHARSET=latin1*/;
  36. #
  37. # Dumping data for table 'raw_collections'
  38. #
  39. # (No data found.)
  40. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;