quest_global_data.sql 625 B

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