From 2265aef916e3b2d63d87faa68a2b51e7d747c54c Mon Sep 17 00:00:00 2001 From: Seline Date: Tue, 14 Oct 2008 11:57:03 -0500 Subject: [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 --- sql/characters.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'sql/characters.sql') diff --git a/sql/characters.sql b/sql/characters.sql index 4f398afe75a..2454e74bb80 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -661,6 +661,28 @@ LOCK TABLES `corpse` WRITE; /*!40000 ALTER TABLE `corpse` ENABLE KEYS */; 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` -- -- cgit v1.2.3