9
3

eq2_achievements.sql 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. DROP TABLE IF EXISTS `raw_achievements`;
  2. CREATE TABLE `raw_achievements` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `unknown_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `name` VARCHAR(50) NOT NULL,
  6. `uncompleted_text` VARCHAR(255) DEFAULT NULL,
  7. `completed_text` VARCHAR(255) DEFAULT NULL,
  8. `category` VARCHAR(50) DEFAULT NULL,
  9. `expansion` VARCHAR(50) DEFAULT NULL,
  10. `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  11. `point_value` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  12. `qty_req` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  13. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  14. `log_file` VARCHAR(250) NOT NULL,
  15. PRIMARY KEY (`id`),
  16. UNIQUE KEY `id` (`unknown_id`,`name`)
  17. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;
  18. DROP TABLE IF EXISTS `raw_achievements_items`;
  19. CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_achievements_items` (
  20. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  21. `unknown_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  22. `name` VARCHAR(250) DEFAULT NULL,
  23. `qty_req` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  24. PRIMARY KEY (`id`),
  25. UNIQUE KEY `NewIndex` (`name`)
  26. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;
  27. DROP TABLE IF EXISTS `raw_achievements_rewards`;
  28. CREATE TABLE /*!32312 IF NOT EXISTS*/ `raw_achievements_rewards` (
  29. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  30. `unknown_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  31. `reward` VARCHAR(250) DEFAULT '"',
  32. PRIMARY KEY (`id`),
  33. UNIQUE KEY `id` (`unknown_id`)
  34. ) ENGINE=MYISAM DEFAULT CHARSET=latin1;