From d380c12c562800b4b073cc0ec49808c256789519 Mon Sep 17 00:00:00 2001 From: ShinDarth Date: Mon, 19 Oct 2015 13:44:36 +0200 Subject: Core/Battleground: implement deserters tracker feature --- sql/updates/characters/2015_10_28_00_characters.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/characters/2015_10_28_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2015_10_28_00_characters.sql b/sql/updates/characters/2015_10_28_00_characters.sql new file mode 100644 index 00000000000..9d353773a33 --- /dev/null +++ b/sql/updates/characters/2015_10_28_00_characters.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `battleground_deserters`; +CREATE TABLE `battleground_deserters` ( + `guid` INT(10) UNSIGNED NOT NULL COMMENT 'characters.guid', + `type` TINYINT(3) UNSIGNED NOT NULL COMMENT 'type of the desertion', + `datetime` DATETIME NOT NULL COMMENT 'datetime of the desertion' +); -- cgit v1.2.3