9
3

character_quest_rewards_aug6th_2022.sql 798 B

1234567891011121314151617
  1. CREATE TABLE `character_quest_rewards` (
  2. `char_id` int(10) unsigned NOT NULL default 0,
  3. `quest_id` int(10) unsigned NOT NULL default 0,
  4. `indexed` int(10) unsigned NOT NULL default 0,
  5. `is_temporary` tinyint(3) unsigned NOT NULL default 0,
  6. `is_collection` tinyint(3) unsigned NOT NULL default 0,
  7. `has_displayed` tinyint(3) unsigned NOT NULL default 0,
  8. `tmp_coin` bigint unsigned NOT NULL DEFAULT 0,
  9. `tmp_status` int(10) unsigned NOT NULL default 0,
  10. `description` text not null default ''
  11. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  12. CREATE TABLE `character_quest_temporary_rewards` (
  13. `char_id` int(10) unsigned NOT NULL default 0,
  14. `quest_id` int(10) unsigned NOT NULL default 0,
  15. `item_id` int(10) unsigned NOT NULL default 0
  16. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;