DB: Redo class_expansion_requirement and race_unlock_requirement data

1 files changed, 240 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_09_11_00_world.sql b/sql/updates/world/master/2021_09_11_00_world.sql
new file mode 100644
index 00000000000..e94862ebd31
--- /dev/null
+++ b/sql/updates/world/master/2021_09_11_00_world.sql
@@ -0,0 +1,240 @@
+DELETE FROM `class_expansion_requirement`;
+INSERT INTO `class_expansion_requirement` VALUES
+(1,1,0,0),
+(2,1,0,0),
+(4,1,0,0),
+(5,1,0,0),
+(8,1,0,0),
+(9,1,0,0),
+(6,1,2,0),
+(3,1,0,0),
+(10,1,4,0),
+(1,2,0,0),
+(3,2,0,0),
+(4,2,0,0),
+(7,2,0,0),
+(9,2,0,0),
+(6,2,2,0),
+(8,2,0,0),
+(10,2,4,0),
+(1,3,0,0),
+(2,3,0,0),
+(3,3,0,0),
+(5,3,0,0),
+(4,3,0,0),
+(6,3,2,0),
+(8,3,0,0),
+(7,3,0,0),
+(9,3,0,0),
+(10,3,4,0),
+(1,4,0,0),
+(3,4,0,0),
+(4,4,0,0),
+(5,4,0,0),
+(11,4,0,0),
+(6,4,2,0),
+(8,4,0,0),
+(10,4,4,0),
+(12,4,0,0),
+(1,5,0,0),
+(4,5,0,0),
+(5,5,0,0),
+(8,5,0,0),
+(9,5,0,0),
+(6,5,2,0),
+(3,5,0,0),
+(10,5,4,0),
+(1,6,0,0),
+(3,6,0,0),
+(7,6,0,0),
+(11,6,0,0),
+(6,6,2,0),
+(5,6,0,0),
+(2,6,0,0),
+(10,6,4,0),
+(1,7,0,0),
+(4,7,0,0),
+(8,7,0,0),
+(9,7,0,0),
+(6,7,2,0),
+(5,7,0,0),
+(10,7,4,0),
+(3,7,0,0),
+(1,8,0,0),
+(4,8,0,0),
+(3,8,0,0),
+(5,8,0,0),
+(7,8,0,0),
+(8,8,0,0),
+(6,8,2,0),
+(11,8,0,0),
+(9,8,0,0),
+(10,8,4,0),
+(6,9,2,0),
+(3,9,0,0),
+(8,9,0,0),
+(5,9,0,0),
+(4,9,0,0),
+(7,9,0,0),
+(9,9,0,0),
+(1,9,0,0),
+(3,10,0,0),
+(4,10,0,0),
+(5,10,0,0),
+(8,10,0,0),
+(9,10,0,0),
+(2,10,0,0),
+(6,10,2,0),
+(1,10,0,0),
+(10,10,4,0),
+(12,10,0,0),
+(1,11,0,0),
+(2,11,0,0),
+(3,11,0,0),
+(5,11,0,0),
+(8,11,0,0),
+(7,11,0,0),
+(6,11,2,0),
+(10,11,4,0),
+(6,22,2,0),
+(11,22,0,0),
+(3,22,0,0),
+(8,22,0,0),
+(4,22,0,0),
+(5,22,0,0),
+(9,22,0,0),
+(1,22,0,0),
+(3,24,0,0),
+(8,24,0,0),
+(10,24,4,0),
+(5,24,0,0),
+(4,24,0,0),
+(7,24,0,0),
+(1,24,0,0),
+(6,24,2,8),
+(1,25,0,0),
+(7,25,0,0),
+(4,25,0,0),
+(5,25,0,0),
+(10,25,4,0),
+(8,25,0,0),
+(3,25,0,0),
+(6,25,2,8),
+(1,26,0,0),
+(3,26,0,0),
+(4,26,0,0),
+(5,26,0,0),
+(7,26,0,0),
+(8,26,0,0),
+(10,26,4,0),
+(6,26,2,8),
+(8,27,6,7),
+(3,27,6,7),
+(10,27,6,7),
+(5,27,6,7),
+(4,27,6,7),
+(9,27,6,7),
+(1,27,6,7),
+(6,27,6,8),
+(3,28,6,7),
+(11,28,6,7),
+(7,28,6,7),
+(1,28,6,7),
+(10,28,6,7),
+(6,28,6,8),
+(8,29,6,7),
+(9,29,6,7),
+(3,29,6,7),
+(10,29,6,7),
+(5,29,6,7),
+(4,29,6,7),
+(1,29,6,7),
+(6,29,6,8),
+(2,30,6,7),
+(3,30,6,7),
+(8,30,6,7),
+(5,30,6,7),
+(1,30,6,7),
+(6,30,6,8),
+(7,31,7,7),
+(11,31,7,7),
+(3,31,7,7),
+(8,31,7,7),
+(5,31,7,7),
+(4,31,7,7),
+(1,31,7,7),
+(10,31,7,7),
+(2,31,7,7),
+(6,31,7,8),
+(1,32,7,7),
+(3,32,7,7),
+(4,32,7,7),
+(5,32,7,7),
+(8,32,7,7),
+(7,32,7,7),
+(11,32,7,7),
+(10,32,7,7),
+(6,32,7,8),
+(1,34,7,7),
+(3,34,7,7),
+(8,34,7,7),
+(10,34,7,7),
+(2,34,7,7),
+(5,34,7,7),
+(4,34,7,7),
+(7,34,7,7),
+(9,34,7,7),
+(6,34,7,8),
+(1,35,7,7),
+(4,35,7,7),
+(10,35,7,7),
+(3,35,7,7),
+(5,35,7,7),
+(8,35,7,7),
+(9,35,7,7),
+(7,35,7,7),
+(6,35,7,8),
+(1,36,7,7),
+(3,36,7,7),
+(8,36,7,7),
+(10,36,7,7),
+(5,36,7,7),
+(4,36,7,7),
+(7,36,7,7),
+(6,36,7,8),
+(1,37,7,7),
+(4,37,7,7),
+(10,37,7,7),
+(3,37,7,7),
+(5,37,7,7),
+(8,37,7,7),
+(9,37,7,7),
+(6,37,7,8);
+
+DELETE FROM `race_unlock_requirement`;
+INSERT INTO `race_unlock_requirement` VALUES
+(1,0,0),
+(2,0,0),
+(3,0,0),
+(4,0,0),
+(5,0,0),
+(6,0,0),
+(7,0,0),
+(8,0,0),
+(9,3,0),
+(10,1,0),
+(11,1,0),
+(22,3,0),
+(24,4,0),
+(25,4,0),
+(26,4,0),
+(27,7,12244),
+(28,7,12245),
+(29,7,12242),
+(30,7,12243),
+(31,7,13161),
+(32,7,13163),
+(34,7,12515),
+(35,7,13206),
+(36,7,12518),
+(37,7,14013);