[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

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/45_characters.sql b/sql/updates/45_characters.sql
new file mode 100644
index 00000000000..9f370ba909c
--- /dev/null
+++ b/sql/updates/45_characters.sql
@@ -0,0 +1,13 @@
+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;
+
+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;