aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
diff options
context:
space:
mode:
authorSeline <none@none>2008-10-14 11:57:03 -0500
committerSeline <none@none>2008-10-14 11:57:03 -0500
commit2265aef916e3b2d63d87faa68a2b51e7d747c54c (patch)
treeb05420685b7d202aade6f70a6f511adbfb79e37f /sql/characters.sql
parent222cbfd4644412fb8e5aeed7c37c88797d09964a (diff)
[svn] * Merge Temp dev SVN with Assembla.
* Changes include: - Implementation of w12x's Outdoor PvP and Game Event Systems. - Temporary removal of IRC Chat Bot (until infinite loop when disabled is fixed). - All mangos -> trinity (to convert your mangos_string table, please run mangos_string_to_trinity_string.sql). - Improved Config cleanup. - And many more changes. --HG-- branch : trunk
Diffstat (limited to 'sql/characters.sql')
-rw-r--r--sql/characters.sql22
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/characters.sql b/sql/characters.sql
index 4f398afe75a..2454e74bb80 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -662,6 +662,28 @@ LOCK TABLES `corpse` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `game_event_condition_save`
+--
+
+CREATE TABLE `game_event_condition_save` (
+ `event_id` mediumint(8) unsigned NOT NULL,
+ `condition_id` mediumint(8) unsigned NOT NULL default '0',
+ `done` float default '0',
+ PRIMARY KEY (`event_id`,`condition_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `game_event_save`
+--
+
+CREATE TABLE `game_event_save` (
+ `event_id` mediumint(8) unsigned NOT NULL,
+ `state` tinyint(3) unsigned NOT NULL default '1',
+ `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
+ PRIMARY KEY (`event_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `groups`
--