diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2017_01_29_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/master/2017_01_29_02_world.sql | 16 |
2 files changed, 18 insertions, 0 deletions
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; |