-
Notifications
You must be signed in to change notification settings - Fork 3
/
QuestSort.sql
61 lines (61 loc) · 4.97 KB
/
QuestSort.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
DROP TABLE IF EXISTS `QuestSort`;
CREATE TABLE `QuestSort` ( `ID` INT NOT NULL DEFAULT '0',
`SortName_Lang_enUS` TEXT NULL,
`SortName_Lang_enGB` TEXT NULL,
`SortName_Lang_koKR` TEXT NULL,
`SortName_Lang_frFR` TEXT NULL,
`SortName_Lang_deDE` TEXT NULL,
`SortName_Lang_enCN` TEXT NULL,
`SortName_Lang_zhCN` TEXT NULL,
`SortName_Lang_enTW` TEXT NULL,
`SortName_Lang_zhTW` TEXT NULL,
`SortName_Lang_esES` TEXT NULL,
`SortName_Lang_esMX` TEXT NULL,
`SortName_Lang_ruRU` TEXT NULL,
`SortName_Lang_ptPT` TEXT NULL,
`SortName_Lang_ptBR` TEXT NULL,
`SortName_Lang_itIT` TEXT NULL,
`SortName_Lang_Unk` TEXT NULL,
`SortName_Lang_Mask` INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `QuestSort` VALUES (1,"Epic","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (21,"REUSE - old wailing caverns","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (22,"Seasonal","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (23,"REUSE - old undercity one","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (24,"Herbalism","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (25,"Battlegrounds","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (41,"Day of the Dead","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (61,"Warlock","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (81,"Warrior","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (82,"Shaman","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (101,"Fishing","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (121,"Blacksmithing","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (141,"Paladin","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (161,"Mage","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (162,"Rogue","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (181,"Alchemy","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (182,"Leatherworking","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (201,"Engineering","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (221,"Treasure Map","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (241,"Tournament","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (261,"Hunter","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (262,"Priest","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (263,"Druid","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (264,"Tailoring","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (284,"Special","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (304,"Cooking","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (324,"First Aid","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (344,"Legendary","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (364,"Darkmoon Faire","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (365,"Ahn\\'Qiraj War","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (366,"Lunar Festival","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (367,"Reputation","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (368,"Invasion","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (369,"Midsummer","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (370,"Brewfest","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (371,"Inscription","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (372,"Death Knight","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (373,"Jewelcrafting","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (374,"Noblegarden","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (375,"Pilgrim\\'s Bounty","","","","","","","","","","","","","","","",16712190);
INSERT INTO `QuestSort` VALUES (376,"Love is in the Air","","","","","","","","","","","","","","","",16712190);