From a6d238b833baa28e3d607b615f1296ea676bbcb8 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Sun, 29 Jan 2017 16:09:46 +0100 Subject: Core/Player: Moved character_template from character to world db --- .../characters/master/2017_01_29_00_characters.sql | 2 ++ sql/updates/world/master/2017_01_29_02_world.sql | 16 ++++++++++++++++ 2 files changed, 18 insertions(+) create mode 100644 sql/updates/characters/master/2017_01_29_00_characters.sql create mode 100644 sql/updates/world/master/2017_01_29_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2017_01_29_00_characters.sql b/sql/updates/characters/master/2017_01_29_00_characters.sql new file mode 100644 index 00000000000..b7cb4126ccd --- /dev/null +++ b/sql/updates/characters/master/2017_01_29_00_characters.sql @@ -0,0 +1,2 @@ +DROP TABLE IF EXISTS `character_template`; +DROP TABLE IF EXISTS `character_template_class`; diff --git a/sql/updates/world/master/2017_01_29_02_world.sql b/sql/updates/world/master/2017_01_29_02_world.sql new file mode 100644 index 00000000000..d50e0a41d82 --- /dev/null +++ b/sql/updates/world/master/2017_01_29_02_world.sql @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS `character_template`; +CREATE TABLE IF NOT EXISTS `character_template` ( + `Id` int(10) unsigned NOT NULL, + `Name` varchar(70) NOT NULL, + `Description` varchar(100) NOT NULL, + `Level` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`Id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +DROP TABLE IF EXISTS `character_template_class`; +CREATE TABLE IF NOT EXISTS `character_template_class` ( + `TemplateId` int(10) unsigned NOT NULL, + `FactionGroup` tinyint(3) unsigned NOT NULL COMMENT '3 - Alliance, 5 - Horde', + `Class` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`TemplateId`,`FactionGroup`,`Class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3