quest_global_data.sql 595 B

1234567891011
  1. -- Table structure for global quest data (i.e. quest data not particular to a player)
  2. -- Note: We had considered using character_quests with char_id = 0 for this, but decided
  3. -- against it, primarily for aesthetic purposes, cleaningness of code, expectability, and
  4. -- to keep char-related data purely as char-related data, global purely as global.
  5. CREATE TABLE IF NOT EXISTS `quest_global_data` (
  6. `quest_name` VARCHAR(40) NOT NULL DEFAULT '',
  7. `var` VARCHAR(20) NOT NULL DEFAULT '',
  8. `value` VARCHAR(255) ,
  9. PRIMARY KEY (`quest_name`,`var`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;