mirror of
https://github.com/mod-playerbots/mod-playerbots
synced 2025-11-29 15:58:20 +08:00
25 lines
723 B
SQL
25 lines
723 B
SQL
DROP TABLE IF EXISTS `playerbots_dungeon_suggestion_abbrevation`;
|
|
CREATE TABLE `playerbots_dungeon_suggestion_abbrevation` (
|
|
`id` TINYINT(3) NOT NULL AUTO_INCREMENT UNIQUE,
|
|
`definition_slug` VARCHAR(255) NOT NULL,
|
|
`abbrevation` VARCHAR(16) NOT NULL,
|
|
|
|
PRIMARY KEY (`id`),
|
|
KEY `definition_slug` (`definition_slug`)
|
|
)
|
|
ENGINE=MyISAM
|
|
DEFAULT CHARSET=utf8
|
|
ROW_FORMAT=FIXED
|
|
COMMENT='Playerbot dungeon suggestion abbrevations';
|
|
|
|
-- = Example =
|
|
|
|
-- INSERT INTO `playerbots_dungeon_suggestion_abbrevation` VALUES
|
|
|
|
-- (NULL, 'rfc', 'Ragefire'),
|
|
-- (NULL, 'rfc', 'RFC'),
|
|
-- (NULL, 'st', 'Sunken Temple'),
|
|
-- (NULL, 'st', 'ST'),
|
|
-- (NULL, 'stocks', 'Stockades');
|
|
-- (NULL, 'stocks', 'Stockade');
|