root/trunk/sql/updates/45_characters.sql @ 162

Revision 44, 0.5 kB (checked in by yumileroy, 17 years ago)

[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.

Original author: Seline
Date: 2008-10-14 11:57:03-05:00
Line 
1CREATE TABLE `game_event_save` (
2 `event_id` mediumint(8) unsigned NOT NULL,
3 `state` tinyint(3) unsigned NOT NULL default '1',
4 `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
5 PRIMARY KEY  (`event_id`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7
8CREATE TABLE `game_event_condition_save` (                   
9 `event_id` mediumint(8) unsigned NOT NULL,
10 `condition_id` mediumint(8) unsigned NOT NULL default '0',
11 `done` float default '0',
12 PRIMARY KEY  (`event_id`,`condition_id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Note: See TracBrowser for help on using the browser.