EQ2EMu/EQ2/devtools/PacketParser/sql_updates/parser_stats.sql

DROP TABLE IF EXISTS `parser_stats`;
CREATE TABLE `parser_stats` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  `total_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_items` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_spawns` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_spells` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_specials` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_achievements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_advancements` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_abilities` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_traditions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_trainings` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_poi` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_locations` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_quests` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_factions` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_collections` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_aa_class` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_aa_subclass` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_aa_tso` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_titles` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `total_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `unique_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `new_books` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MYISAM;