· 8 years ago · Nov 24, 2017, 06:30 PM
1SET FOREIGN_KEY_CHECKS=0;
2-- ----------------------------
3-- Table structure for `player_factionchange_reputations`
4-- ----------------------------
5CREATE TABLE IF NOT EXISTS `player_factionchange_reputations` (
6 `race_A` int(8) NOT NULL DEFAULT '0',
7 `alliance_id` int(8) NOT NULL,
8 `commentA` varchar(255) DEFAULT NULL,
9 `race_H` int(8) NOT NULL DEFAULT '0',
10 `horde_id` int(8) NOT NULL,
11 `commentH` varchar(255) DEFAULT NULL,
12 PRIMARY KEY (`race_A`, `alliance_id`, `race_H`, `horde_id`)
13) DEFAULT CHARSET=UTF8;
14
15INSERT INTO `player_factionchange_reputations` VALUES ('0', '47', 'Ironforge', '0', '530', 'Darkspear Trolls');
16INSERT INTO `player_factionchange_reputations` VALUES ('0', '54', 'Gnomeregan Exiles', '0', '81', 'Thunder Bluff');
17INSERT INTO `player_factionchange_reputations` VALUES ('0', '69', 'Darnassus', '0', '68', 'Undercity');
18INSERT INTO `player_factionchange_reputations` VALUES ('0', '72', 'Stormwind', '0', '76', 'Orgrimmar');
19INSERT INTO `player_factionchange_reputations` VALUES ('0', '509', 'The League of Arathor', '0', '510', 'The Defilers');
20INSERT INTO `player_factionchange_reputations` VALUES ('0', '730', 'Stormpike Guard', '0', '729', 'Frostwolf Clan');
21INSERT INTO `player_factionchange_reputations` VALUES ('0', '890', 'Silverwing Sentinels', '0', '889', 'Warsong Outriders');
22INSERT INTO `player_factionchange_reputations` VALUES ('0', '930', 'Exodar', '0', '911', 'Silvermoon City');
23INSERT INTO `player_factionchange_reputations` VALUES ('0', '946', 'Honor Hold', '0', '947', 'Thrallmar');
24INSERT INTO `player_factionchange_reputations` VALUES ('0', '978', 'Kurenai', '0', '941', 'The Mag\'har');
25INSERT INTO `player_factionchange_reputations` VALUES ('0', '1037', 'Alliance Vanguard', '0', '1052', 'Horde Expedition');
26INSERT INTO `player_factionchange_reputations` VALUES ('0', '1050', 'Valiance Expedition', '0', '1085', 'Warsong Offensive');
27INSERT INTO `player_factionchange_reputations` VALUES ('0', '1068', 'Explorers\' League', '0', '1064', 'The Taunka');
28INSERT INTO `player_factionchange_reputations` VALUES ('0', '1126', 'The Frostborn', '0', '1067', 'The Hand of Vengeance');
29INSERT INTO `player_factionchange_reputations` VALUES ('1', '69', 'Darnassus', '5', '76', 'Orgrimmar');
30INSERT INTO `player_factionchange_reputations` VALUES ('1', '72', 'Stormwind', '5', '68', 'Undercity');
31INSERT INTO `player_factionchange_reputations` VALUES ('1', '54', 'Gnomeregan Exiles', '6', '76', 'Orgrimmar');
32INSERT INTO `player_factionchange_reputations` VALUES ('1', '72', 'Stormwind', '6', '81', 'Thunder Bluff');
33INSERT INTO `player_factionchange_reputations` VALUES ('1', '47', 'Ironforge', '8', '76', 'Orgrimmar');
34INSERT INTO `player_factionchange_reputations` VALUES ('1', '72', 'Stormwind', '8', '530', 'Darkspear Trolls');
35INSERT INTO `player_factionchange_reputations` VALUES ('1', '930', 'Exodar', '10', '76', 'Orgrimmar');
36INSERT INTO `player_factionchange_reputations` VALUES ('1', '72', 'Stormwind', '10', '911', 'Silvermoon City');
37INSERT INTO `player_factionchange_reputations` VALUES ('3', '47', 'Ironforge', '2', '76', 'Orgrimmar');
38INSERT INTO `player_factionchange_reputations` VALUES ('3', '72', 'Stormwind', '2', '530', 'Darkspear Trolls');
39INSERT INTO `player_factionchange_reputations` VALUES ('3', '69', 'Darnassus', '5', '530', 'Darkspear Trolls');
40INSERT INTO `player_factionchange_reputations` VALUES ('3', '47', 'Ironforge', '5', '68', 'Undercity');
41INSERT INTO `player_factionchange_reputations` VALUES ('3', '54', 'Gnomeregan Exiles', '6', '530', 'Darkspear Trolls');
42INSERT INTO `player_factionchange_reputations` VALUES ('3', '47', 'Ironforge', '6', '81', 'Thunder Bluff');
43INSERT INTO `player_factionchange_reputations` VALUES ('3', '930', 'Exodar', '10', '530', 'Darkspear Trolls');
44INSERT INTO `player_factionchange_reputations` VALUES ('3', '47', 'Ironforge', '10', '911', 'Silvermoon City');
45INSERT INTO `player_factionchange_reputations` VALUES ('4', '69', 'Darnassus', '2', '76', 'Orgrimmar');
46INSERT INTO `player_factionchange_reputations` VALUES ('4', '72', 'Stormwind', '2', '68', 'Undercity');
47INSERT INTO `player_factionchange_reputations` VALUES ('4', '69', 'Darnassus', '6', '81', 'Thunder Bluff');
48INSERT INTO `player_factionchange_reputations` VALUES ('4', '54', 'Gnomeregan Exiles', '6', '68', 'Undercity');
49INSERT INTO `player_factionchange_reputations` VALUES ('4', '69', 'Darnassus', '8', '530', 'Darkspear Trolls');
50INSERT INTO `player_factionchange_reputations` VALUES ('4', '47', 'Ironforge', '8', '68', 'Undercity');
51INSERT INTO `player_factionchange_reputations` VALUES ('4', '69', 'Darnassus', '10', '911', 'Silvermoon City');
52INSERT INTO `player_factionchange_reputations` VALUES ('4', '930', 'Exodar', '10', '68', 'Undercity');
53INSERT INTO `player_factionchange_reputations` VALUES ('7', '54', 'Gnomeregan Exiles', '2', '76', 'Orgrimmar');
54INSERT INTO `player_factionchange_reputations` VALUES ('7', '72', 'Stormwind', '2', '81', 'Thunder Bluff');
55INSERT INTO `player_factionchange_reputations` VALUES ('7', '69', 'Darnassus', '5', '81', 'Thunder Bluff');
56INSERT INTO `player_factionchange_reputations` VALUES ('7', '54', 'Gnomeregan Exiles', '5', '68', 'Undercity');
57INSERT INTO `player_factionchange_reputations` VALUES ('7', '54', 'Gnomeregan Exiles', '8', '530', 'Darkspear Trolls');
58INSERT INTO `player_factionchange_reputations` VALUES ('7', '47', 'Ironforge', '8', '81', 'Thunder Bluff');
59INSERT INTO `player_factionchange_reputations` VALUES ('7', '930', 'Exodar', '10', '81', 'Thunder Bluff');
60INSERT INTO `player_factionchange_reputations` VALUES ('7', '54', 'Gnomeregan Exiles', '10', '911', 'Silvermoon City');
61INSERT INTO `player_factionchange_reputations` VALUES ('11', '930', 'Exodar', '2', '76', 'Orgrimmar');
62INSERT INTO `player_factionchange_reputations` VALUES ('11', '72', 'Stormwind', '2', '911', 'Silvermoon City');
63INSERT INTO `player_factionchange_reputations` VALUES ('11', '69', 'Darnassus', '5', '911', 'Silvermoon City');
64INSERT INTO `player_factionchange_reputations` VALUES ('11', '930', 'Exodar', '5', '68', 'Undercity');
65INSERT INTO `player_factionchange_reputations` VALUES ('11', '930', 'Exodar', '6', '81', 'Thunder Bluff');
66INSERT INTO `player_factionchange_reputations` VALUES ('11', '54', 'Gnomeregan Exiles', '6', '911', 'Silvermoon City');
67INSERT INTO `player_factionchange_reputations` VALUES ('11', '930', 'Exodar', '8', '530', 'Darkspear Trolls');
68INSERT INTO `player_factionchange_reputations` VALUES ('11', '47', 'Ironforge', '8', '911', 'Silvermoon City');