AchievementUpdates SQL.txt 646 B

1234567891011121314151617181920
  1. CREATE TABLE `raw_achievement_updates` (
  2. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3. `achievement_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  4. `completed_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `num_items` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  6. PRIMARY KEY (`id`),
  7. UNIQUE INDEX `achievement_id` (`achievement_id`)
  8. )
  9. COLLATE='latin1_swedish_ci'
  10. ENGINE=MyISAM;
  11. CREATE TABLE `raw_achievement_update_items` (
  12. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  13. `achievement_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  14. `item_update` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  15. PRIMARY KEY (`id`)
  16. )
  17. COLLATE='latin1_swedish_ci'
  18. ENGINE=MyISAM;