From bba6eb8d3dfe73a02063a7cefe6f465dae69334b Mon Sep 17 00:00:00 2001 From: Carbenium Date: Sun, 19 Apr 2015 23:37:29 +0200 Subject: Core/Player: Added character templates * Characters with predefined levels can be created * Avaiable factions and classes can be configured * Valid values for `factionGroup` in table `character_template_class` are 3 (Alliance) or 5 (Horde) * Added new permission RBAC_PERM_USE_CHARACTER_TEMPLATES - has to be set, to allow the usage of the templates Closes #13952 --- sql/updates/characters/2015_04_21_00_characters.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/characters/2015_04_21_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/2015_04_21_00_characters.sql b/sql/updates/characters/2015_04_21_00_characters.sql new file mode 100644 index 00000000000..b5fc1bd2ac8 --- /dev/null +++ b/sql/updates/characters/2015_04_21_00_characters.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=InnoDB 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=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.2.3