parser_stats.sql 3.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. DROP TABLE IF EXISTS `parser_stats`;
  2. CREATE TABLE `parser_stats` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  5. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  6. `total_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `unique_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  8. `new_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  9. `total_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  10. `unique_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  11. `new_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  12. `total_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  13. `unique_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  14. `new_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  15. `total_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  16. `unique_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  17. `new_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  18. `total_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  19. `unique_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  20. `new_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  21. `total_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  22. `unique_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  23. `new_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  24. `total_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  25. `unique_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  26. `new_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  27. `total_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  28. `unique_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  29. `new_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  30. `total_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  31. `unique_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  32. `new_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  33. `total_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  34. `unique_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  35. `new_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  36. `total_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  37. `unique_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  38. `new_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  39. `total_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  40. `unique_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  41. `new_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  42. `total_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  43. `unique_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  44. `new_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  45. `total_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  46. `unique_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  47. `new_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  48. `total_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  49. `unique_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  50. `new_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  51. `total_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  52. `unique_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  53. `new_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  54. `total_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  55. `unique_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  56. `new_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  57. `total_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  58. `unique_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  59. `new_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  60. `total_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  61. `unique_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  62. `new_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  63. PRIMARY KEY (`id`)
  64. ) ENGINE=MYISAM;