From c722ff3a68ed5e20a765d8055cb464dfaee55b6f Mon Sep 17 00:00:00 2001 From: TDB Release Date: Tue, 3 Sep 2024 00:52:11 +0000 Subject: TDB 1102.24091 - 2024/09/03 --- sql/base/auth_database.sql | 590 +++++++++++++++++++------------------ sql/base/characters_database.sql | 16 +- sql/base/dev/hotfixes_database.sql | 357 +++++++++++++++------- sql/base/dev/world_database.sql | 109 +++++-- 4 files changed, 641 insertions(+), 431 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 7d6808fd248..a3fe2545736 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 8.0.36-0ubuntu0.22.04.1 +-- Server version 8.0.39-0ubuntu0.22.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -521,262 +521,262 @@ CREATE TABLE `build_auth_key` ( LOCK TABLES `build_auth_key` WRITE; /*!40000 ALTER TABLE `build_auth_key` DISABLE KEYS */; INSERT INTO `build_auth_key` VALUES -(25549,'Mac','x64','WoW',0x66FC5E09B8706126795F140308C8C1D8), -(25549,'Win','x64','WoW',0x1252624ED8CBD6FAC7D33F5D67A535F3), -(25549,'Win','x86','WoW',0xFE594FC35E7F9AFF86D99D8A364AB297), -(25996,'Mac','x64','WoW',0x210B970149D6F56CAC9BADF2AAC91E8E), -(25996,'Win','x64','WoW',0xC7FF932D6A2174A3D538CA7212136D2B), -(25996,'Win','x86','WoW',0x23C59C5963CBEF5B728D13A50878DFCB), -(26124,'Mac','x64','WoW',0xC9CA997AB8EDE1C65465CB2920869C4E), -(26124,'Win','x64','WoW',0x46DF06D0147BA67BA49AF553435E093F), -(26124,'Win','x86','WoW',0xF8C05AE372DECA1D6C81DA7A8D1C5C39), -(26365,'Mac','x64','WoW',0xDBE7F860276D6B400AAA86B35D51A417), -(26365,'Win','x64','WoW',0x59A53F307288454B419B13E694DF503C), -(26365,'Win','x86','WoW',0x2AAC82C80E829E2CA902D70CFA1A833A), -(26654,'Mac','x64','WoW',0x9234C1BD5E9687ADBD19F764F2E0E811), -(26654,'Win','x64','WoW',0xA752640E8B99FE5B57C1320BC492895A), -(26654,'Win','x86','WoW',0xFAC2D693E702B9EC9F750F17245696D8), -(26822,'Mac','x64','WoW',0x91003668C245D14ECD8DF094E065E06B), -(26822,'Win','x64','WoW',0x2B05F6D746C0C6CC7EF79450B309E595), -(26822,'Win','x86','WoW',0x283E8D77ECF7060BE6347BE4EB99C7C7), -(26899,'Mac','x64','WoW',0x8368EFC2021329110A16339D298200D4), -(26899,'Win','x64','WoW',0x3551EF0028B51E92170559BD25644B03), -(26899,'Win','x86','WoW',0xF462CD2FE4EA3EADF875308FDBB18C99), -(26972,'Mac','x64','WoW',0x341CFEFE3D72ACA9A4407DC535DED66A), -(26972,'Win','x64','WoW',0x6E212DEF6A0124A3D9AD07F5E322F7AE), -(26972,'Win','x86','WoW',0x797ECC19662DCBD5090A4481173F1D26), -(28153,'Win','x64','WoW',0xDD626517CC6D31932B479934CCDC0ABF), -(30706,'Win','x64','WoW',0xBB6D9866FE4A19A568015198783003FC), -(30993,'Win','x64','WoW',0x2BAD61655ABC2FC3D04893B536403A91), -(31229,'Win','x64','WoW',0x8A46F23670309F2AAE85C9A47276382B), -(31429,'Win','x64','WoW',0x7795A507AF9DC3525EFF724FEE17E70C), -(31478,'Win','x64','WoW',0x7973A8D54BDB8B798D9297B096E771EF), -(32305,'Win','x64','WoW',0x21F5A6FC7AD89FBF411FDA8B8738186A), -(32494,'Win','x64','WoW',0x58984ACE04919401835C61309A848F8A), -(32580,'Win','x64','WoW',0x87C2FAA0D7931BF016299025C0DDCA14), -(32638,'Win','x64','WoW',0x5D07ECE7D4A867DDDE615DAD22B76D4E), -(32722,'Win','x64','WoW',0x1A09BE1D38A122586B4931BECCEAD4AA), -(32750,'Mac','x64','WoW',0xEF1F4E4D099EA2A81FD4C0DEBC1E7086), -(32750,'Win','x64','WoW',0xC5CB669F5A5B237D1355430877173207), -(32978,'Mac','x64','WoW',0x1852C1F847E795D6EB45278CD433F339), -(32978,'Win','x64','WoW',0x76AE2EA03E525D97F5688843F5489000), -(33369,'Mac','x64','WoW',0xF5A849C70A1054F07EA3AB833EBF6671), -(33369,'Win','x64','WoW',0x5986AC18B04D3C403F56A0CF8C4F0A14), -(33528,'Win','x64','WoW',0x0ECE033CA9B11D92F7D2792C785B47DF), -(33724,'Win','x64','WoW',0x38F7BBCF284939DD20E8C64CDBF9FE77), -(33775,'Mac','x64','WoW',0x354D2DE619D124EE1398F76B0436FCFC), -(33775,'Win','x64','WoW',0xB826300A8449ED0F6EF16EA747FA2D2E), -(33941,'Win','x64','WoW',0x88AF1A36D2770D0A6CA086497096A889), -(34220,'Win','x64','WoW',0xB5E35B976C6BAF82505700E7D9666A2C), -(34601,'Win','x64','WoW',0x0D7DF38F725FABA4F009257799A10563), -(34769,'Win','x64','WoW',0x93F9B9AF6397E3E4EED94D36D16907D2), -(34963,'Mac','x64','WoW',0xC5658A17E702163447BAAAE46D130A1B), -(34963,'Win','x64','WoW',0x7BA50C879C5D04221423B02AC3603A11), -(35249,'Win','x64','WoW',0xC7B11F9AE9FF1409F5582902B3D10D1C), -(35284,'Mac','x64','WoW',0xA6201B0AC5A73D13AB2FDCC79BB252AF), -(35284,'Win','x64','WoW',0xEA3818E7DCFD2009DBFC83EE3C1E4F1B), -(35435,'Mac','x64','WoW',0x8FE657C14A46BCDB2CE6DA37E430450E), -(35435,'Win','x64','WoW',0xBB397A92FE23740EA52FC2B5BA2EC8E0), -(35662,'Mac','x64','WoW',0x5966016C368ED9F7AAB603EE6703081C), -(35662,'Win','x64','WoW',0x578BC94870C278CB6962F30E6DC203BB), -(36753,'Win','x64','WoW',0x386FDE8559B5EAD67B791B490B200B88), -(36839,'Win','x64','WoW',0x356EB4412B8EFCF72E3AF50D5181D529), -(36949,'Win','x64','WoW',0x51C074CD8A09A75384B9B44188C56981), -(37142,'Win','x64','WoW',0x5D9CFB3139F0D1B6C2B304261F9EABC9), -(37176,'Win','x64','WoW',0x3C725EA504EC3DAED143EB6FF3B48CDA), -(37474,'Mac','x64','WoW',0x024C9BE7E44237B7E81C6D42E678D433), -(37474,'Win','x64','WoW',0x0DE685BBB0551086E7FBDC0B4BB06A5B), -(38134,'Win','x64','WoW',0x32275ED0F13B357C28BDB0E611EF9E31), -(38556,'Win','x64','WoW',0xEC7D5AF64364AC3E7181F3FBA1B3A882), -(39653,'Win','x64','WoW',0x10D015AB1EEB91310428D9C57EE24632), -(39804,'Win','x64','WoW',0xE42D2BBA12ED260A76F9B1E477E19EA5), -(40000,'Win','x64','WoW',0x4CB1433AB637F09F03FBBD1B221B04B0), -(40120,'Mac','x64','WoW',0x853F0F2985CEAED46DF422583CD07A7C), -(40120,'Win','x64','WoW',0x04F47EAEFD8BDEFE14AA0350EA336678), -(40443,'Win','x64','WoW',0x8597BB43E8AB38C85504E8BFB72ABBF5), -(40593,'Win','x64','WoW',0xBA14570F2D62D5F61953394164A8DAE2), -(40725,'Win','x64','WoW',0xC1EBDBEB9BB2956EBCCEF7C9D27A1B3B), -(40906,'Win','x64','WoW',0xF5FC259C8635488AFE0D0CD023F361D4), -(40944,'Win','x64','WoW',0x368FC7FABAF487A8A049C11970657074), -(40966,'Win','x64','WoW',0xD90F47AF21F381D2D8F3763B994BAC88), -(41031,'Win','x64','WoW',0x019A0FACD6B0D6374B7BA69A5B677449), -(41079,'Win','x64','WoW',0xF8853CF823BC0BBE8A9677A762DFAEE1), -(41288,'Win','x64','WoW',0x871C0C9691DBC536EB24B68EC73FAD5B), -(41323,'Win','x64','WoW',0xE53D0DF1FAC1A59A1C8071B295A04A1D), -(41359,'Win','x64','WoW',0x5F8D7F2A690A4375A1B52A28D6D681FA), -(41488,'Win','x64','WoW',0x1BC91EC368705815F3F532B553DAD981), -(41793,'Win','x64','WoW',0xB3B47DA3B7615570742A55B96614EE1C), -(42010,'Win','x64','WoW',0x302970161D16417B5BE553CC530E011A), -(42423,'Win','x64','WoW',0x0B03614A7E94DD57548596BE420E9DC2), -(42488,'Win','x64','WoW',0xA78755E6928D83A271C5D1EE3CDB6F15), -(42521,'Win','x64','WoW',0x5FE6C12FC407C6B15B4A5D3B5B4A5D3B), -(42538,'Win','x64','WoW',0x71A7504BD53F8DE518F24265D37310AE), -(42560,'Win','x64','WoW',0x115FE8C38A8D67CA4664BB192E0F0DFE), -(42614,'Win','x64','WoW',0x772BE726FEEF42124255D2EA7973CA18), -(42698,'Win','x64','WoW',0xB4497B1CD11FC974C5FB09548AC27269), -(42825,'Win','x64','WoW',0xA14DA228C6A6AFF1DDBA51218939E557), -(42852,'Win','x64','WoW',0xDE9F9F0C3CC8FD54D3AFF99CEFFCE129), -(42937,'Win','x64','WoW',0xF5FC75E70874752C92846B3333920E63), -(42979,'Win','x64','WoW',0xE1DD38AE6450FC4D2AE4609233C59E54), -(43114,'Win','x64','WoW',0xF75C9380CCB24A48A24EEE52C1594A7E), -(43206,'Win','x64','WoW',0xDDE806532C7704FFB75F256DC5F1F3D9), -(43340,'Win','x64','WoW',0x70E46D2D888E84DF9316EA849B068CF4), -(43345,'Win','x64','WoW',0xD911ABFCDA030DEE8CAF4EE3F60DEE13), -(43971,'Win','x64','WoW',0x681CF99E61FB0005A5C7D31D0AAD1ED9), -(44015,'Win','x64','WoW',0xFCF0BDA7C98BFEF92AE6D8C39A217ABD), -(44061,'Win','x64','WoW',0xFD2B5C0B3293FE0E9CAA6EB0B7788119), -(44127,'Win','x64','WoW',0x787887CEC9FCC9B516481F60E4FC34A8), -(44232,'Win','x64','WoW',0x81F0A71DF7E9873BB3750022D64D33CF), -(44325,'Win','x64','WoW',0x138A7D524D268A7F9934C3D148E8F01B), -(44730,'Win','x64','WoW',0xFC0B18C47BB4C79F4300CA0FF3E5CAC7), -(44908,'Win','x64','WoW',0xBFFAEC40C9BCD591C7C959A9D5A8BA8C), -(45114,'Win','x64','WoW',0xD7AFE240BD00F06C30D0C2D16E54A8BE), -(45161,'Win','x64','WoW',0x74BD2E787A98B145B063BDA9A98F6CBD), -(45338,'Win','x64','WoW',0x5CE2094A41B61EDA9DF56378BC3B1DE0), -(45745,'Win','x64','WoW',0x0F6DC90161694D765A595A3AF603166B), -(46479,'Win','x64','WoW',0xCB9AF4D89B60A3ABA288D395D315D932), -(46658,'Win','x64','WoW',0x3F8EFB085428D75360E9EFE25CD8639A), -(46689,'Win','x64','WoW',0xD9A11D188D6AD60906F5467510EFD3AA), -(46702,'Win','x64','WoW',0x01B4D1688FF97DC9AAFCCD0A0B842C0B), -(46741,'Win','x64','WoW',0x4C0F4A7EC2098AF1FBA745848EC79A78), -(46801,'Win','x64','WoW',0xE6AC18D1EA5D36ABFFAE5EDED80630DF), -(46879,'Win','x64','WoW',0xEFEC43936051DD1A210633AF1F6B63DB), -(46924,'Win','x64','WoW',0xE6CE0B1A8119F069ECF1E7DBAA7BB2F8), -(47067,'Win','x64','WoW',0x63862CFCDEA6BD2BD7F740EB36B65657), -(47187,'Win','x64','WoW',0x711F8455C5000C237292E1E6E90631E1), -(47213,'Win','x64','WoW',0x23C50D88CEAC0A8696ADDE8DD244D4A2), -(47631,'Win','x64','WoW',0xF986AB91D0AEB20822EFB72F4256713C), -(47777,'Win','x64','WoW',0xA88C04915AB9E035A104E55C4DCF5F9F), -(47799,'Win','x64','WoW',0x7364EB093C23DB2CDC9513D5A7B4933E), -(47825,'Win','x64','WoW',0x82A3B94E5E727AF3A208B471FF2054C0), -(47849,'Win','x64','WoW',0xDD8BBE2087A28C0AF4984CBE23A1C707), -(47871,'Win','x64','WoW',0x8E4F7D30EE4982B02B3B3F8837C2C4F2), -(47884,'Win','x64','WoW',0x2B7A002BC359F2C31104BC2DE04302BF), -(47936,'Win','x64','WoW',0x833D30D8FBC43B3FAE99CD3898D70849), -(47967,'Win','x64','WoW',0xCFE225D0089E224D9E7541D3B5C26478), -(48001,'Win','x64','WoW',0x4B0260A37BD95B615E71048469E6D5BB), -(48069,'Win','x64','WoW',0x558CDF958FA082E95849779C7C6945E5), -(48317,'Win','x64','WoW',0xC096E37B45B43244E9C79916604DD4AF), -(48397,'Win','x64','WoW',0x64BA8779EAA97E6C57982B6B1A5B32E7), -(48526,'Win','x64','WoW',0xD5B7D3303A2A741E6913EE1AEB0BCB65), -(48676,'Win','x64','WoW',0xE059FB74DFF6438CC20C7F28900F64CA), -(48749,'Win','x64','WoW',0x92DBCCA0E33DFB8A17A2B6A39246B288), -(48838,'Win','x64','WoW',0x9E6F4E1E46EF228D2DE90F7BC48AAA96), -(48865,'Win','x64','WoW',0x4B774ABE7B34D6702571B4279A4B6A13), -(48892,'Win','x64','WoW',0xAA31BF27458321B03A1A346964DD7B9D), -(48966,'Win','x64','WoW',0x823142CA131FBB715FF55D4343E55C6D), -(48999,'Win','x64','WoW',0x79BA6FF0F9672EEF875F64155C8B62D4), -(49267,'Win','x64','WoW',0xEEE77EA5A216E0731ADBB41AEFB1DF31), -(49318,'Win','x64','WoW',0xAF439AEE62EE48B36C1725111E3D9BBF), -(49343,'Win','x64','WoW',0x301A0B4C0942B9B6F605B903AD6C1F60), -(49407,'Win','x64','WoW',0x6413820DC9885BB0693B37090CBB2F30), -(49426,'Win','x64','WoW',0xD85EDFBFE9A94A55E2B4510BE41C19B2), -(49444,'Win','x64','WoW',0x363B2B05285BDD8857419D2866316D3C), -(49474,'Win','x64','WoW',0x44A7D2B352EE3D098A3CB4C2F1065E37), -(49570,'Win','x64','WoW',0xB024DE67ACAEB9E8EE6DB38DC53E8281), -(49679,'Win','x64','WoW',0x9CE59B68D8797EBF00581F41138F4316), -(49741,'Win','x64','WoW',0x0EF181E2BB0E946CF3B7422ADEB6CD1A), -(49801,'Win','x64','WoW',0x0832179567B66CA85DBD5678B604C683), -(49890,'Win','x64','WoW',0x22A5B8A1EB797A64995F705B3DBCB14C), -(50000,'Win','x64','WoW',0x02F06FFA2296FD66384295DBFD5A4C91), -(50401,'Win','x64','WoW',0x3EEF52D902CCE81D16D0E255F0AA4938), -(50438,'Win','x64','WoW',0x0B5F68F06B129CB4C57702F6D30F260B), -(50467,'Win','x64','WoW',0x5E996B1CDCEE68432D6340138E68D1EB), -(50469,'Win','x64','WoW',0x1768CCB6589E16AB3BEFA9D608A393A2), -(50504,'Win','x64','WoW',0x7D5FD20C0B32C9AF5DD65433B391D49C), -(50585,'Win','x64','WoW',0xC4F7CC38A3B84935A485F7EDAD3E764B), -(50622,'Win','x64','WoW',0xD23A26FD75FD9A6073EB7060AA28E6A7), -(50747,'Win','x64','WoW',0x2D3C386A9C45C27304ED3A3C6EB3F7C8), -(50791,'Win','x64','WoW',0x0BE7D0BB07EF37C25CBC682409091EA0), -(51130,'Win','x64','WoW',0x44CD2C91E4F0655DA387483726CE4035), -(51187,'Win','x64','WoW',0x74E2055D3965269447B5CB1B31FC71C6), -(51237,'Win','x64','WoW',0xC8660A21B766646FBD67F481CFCF55C3), -(51261,'Win','x64','WoW',0x1BEBB57AE450331E9F8C301AA7876FAB), -(51313,'Win','x64','WoW',0x35419ED0AB16735CF720858F45DC300C), -(51421,'Win','x64','WoW',0x45E24D6F3335269787DF2B2063939002), -(51485,'Win','x64','WoW',0xEC549E1D0A5DD85C03E7A9D93B7DC6D1), -(51536,'Win','x64','WoW',0x570EEA10A8EC169C3FF9621D1B635BB4), -(51754,'Win','x64','WoW',0xBED5A861C071AB41FEF6087E0C37BB1A), -(51886,'Win','x64','WoW',0x09CF8919FD2EABDEAEBC0C810F53B511), -(51972,'Win','x64','WoW',0x444DC7EF3544B6670C18884DADA00428), -(52038,'Win','x64','WoW',0xA8EF004ADED8A3AFF5A67D2BB8D95795), -(52068,'Win','x64','WoW',0xA44F842BACCC7EE8E2975FAF01F12474), -(52095,'Win','x64','WoW',0xBA36382887D16D274EA9149695F0C9C8), -(52106,'Win','x64','WoW',0x95F43869B7D881212CBC1690B8F393ED), -(52129,'Win','x64','WoW',0x02DD842F2A7162EEB8FD5B9D325606F8), -(52148,'Win','x64','WoW',0x8A969717C8CDC6E7FF4C54D5CB00C224), -(52188,'Win','x64','WoW',0x977DF9993E94855DED5E328BA7A2F21F), -(52301,'Win','x64','WoW',0x821AA3BB237B400B82F44970250539AA), -(52393,'Win','x64','WoW',0xB013ED23B7EF51B29A45594D9BBB0D03), -(52485,'Win','x64','WoW',0x5805CEB4650730AE489258DD30E34441), -(52545,'Win','x64','WoW',0xFB52179A8355A46EDBFBDC8E8E5CDAFD), -(52607,'Win','x64','WoW',0x8F002E4AADCAEABB08ABC2880B31AD60), -(52649,'Win','x64','WoW',0xD0B779FBECEBC1ED5A85D83F03C8A75B), -(52808,'Win','x64','WoW',0x6276712B6C8AEA21CD5D94D52FEE70EE), -(52902,'Win','x64','WoW',0xD4F0A24CDF165628538C1C387A326AF3), -(52968,'Win','x64','WoW',0x2D247FD440C44D4F1BF80B075B8720F2), -(52983,'Win','x64','WoW',0xB1E5ADA5FDD06C9AB5E5D8A6983324AC), -(53007,'Win','x64','WoW',0xA21AFB4D381C56AF471D994258C0EEF5), -(53040,'Win','x64','WoW',0x2F1283BF7B7F307B70DBBD75CC42D7C3), -(53104,'Win','x64','WoW',0xDBD79EC8DF044B53C78931B985CAB406), -(53162,'Win','x64','WoW',0x8A67511FBF8984EEE2B630F7CB23376A), -(53212,'Win','x64','WoW',0x08761EFF2F9B639364B9A9FBFFFFB949), -(53262,'Win','x64','WoW',0x614A72D53126348A4927EC0F53FD2B7A), -(53441,'Win','x64','WoW',0xBFDD7D0FE87D5F75E6DEB4F5C99D7C99), -(53584,'Win','x64','WoW',0xCDD7A93659A03460B5A6CE1C4ACE5554), -(53840,'Win','x64','WoW',0xAC97D745C60DD3DC5F973E55C0E3649E), -(53877,'Win','x64','WoW',0x16320F95B63846A2276E1D2612C34AD4), -(53913,'Win','x64','WoW',0x475680680B2192EBCF6744D14F755199), -(53989,'Win','x64','WoW',0x3AEB90ACB9E18B88BA1021F52D51B857), -(54070,'Win','x64','WoW',0xFDA08264B7587250CF78F9B960218169), -(54205,'Win','x64','WoW',0x589D59EB3F0D6D77C2175D9302F78FDD), -(54358,'Win','x64','WoW',0x89C733D366E845FB9264404CD48CCA89), -(54499,'Win','x64','WoW',0x6AC1F6180FC4C390F782DB933BD83326), -(54577,'Win','x64','WoW',0xCBBBBBFFB2C652F0F4A7848D86E1B063), -(54601,'Win','x64','WoW',0xF8B866CF7DB9A12273F35B3929627375), -(54604,'Win','x64','WoW',0xA5FF4CE535F69D4D7F638CB2C11F2243), -(54630,'Win','x64','WoW',0xF37935510BA6B559363C160E1DF18230), -(54673,'Win','x64','WoW',0xAF8B9C8A9C6128498E85228B965A004D), -(54717,'Win','x64','WoW',0x862BBA15158DFF6B56BCF71C1B34D41A), -(54736,'Win','x64','WoW',0xFE58F039D91E1C248886A2828127CA2F), -(54762,'Win','x64','WoW',0x5F7FDA560030255445B713456A286CFA), -(54847,'Win','x64','WoW',0x32FDA0353160EC51EB36195CFACEF2B7), -(54904,'Win','x64','WoW',0x09CBEC3C0DEA28BCA79F1FD9B879B0E3), -(54988,'Win','x64','WoW',0x8F2791553226871977B4F9D7F1137311), -(55142,'Win','x64','WoW',0x298B99B5AD67EA3D2AB4B3E07A415305), -(55165,'Win','x64','WoW',0x26D4D1C01434A8A6723DCABC944B6FD0), -(55261,'Win','x64','WoW',0x84E153A3DD1F8249274B91047AAC7AED), -(55461,'Win','x64','WoW',0xC4522674F854EFECC76C898EC9545099), -(55664,'Win','x64','WoW',0xDBCA58486FAAA0FE54EA287A3047E923), -(55666,'Win','x64','WoW',0xF7E5A88E4D3615B652C8B9D76E7F617C), -(55792,'Win','x64','WoW',0xC4DECDAA44BC548FF09EF3BB837D2147), -(55793,'Win','x64','WoW',0xF9CF3232AD1C38C2028668D5BB64198F), -(55818,'Win','x64','WoW',0x903A9B546248F71B16D9D9B06A072C24), -(55824,'Win','x64','WoW',0x8A6F13269A2896067A1E88789FB41BA7), -(55846,'Win','x64','WoW',0xBB5E1BED705872C226834B95A9E9F8A9), -(55933,'Win','x64','WoW',0xC34D42CB351C400D1319D221197CF18D), -(55939,'Win','x64','WoW',0x91529F4CE41DE4E54E132660ACDCADC5), -(55959,'Win','x64','WoW',0xED57E0538FD1CE99B171BE34823148A9), -(55960,'Win','x64','WoW',0x078C056CFC7B371BDE1BAF308E6C19AF), -(56008,'Win','x64','WoW',0x00FCD6BFFCCCBA7A8E71E307EA6EBD0C), -(56110,'Win','x64','WoW',0x800BCA228E2FAE37ED160F3C09E21F3A), -(56162,'Win','x64','WoW',0x6F5C93BA436665A94DB67CE5361D4EA8), -(56196,'Mac','A64','WoW',0x778F6A5DF79A4EF1B86F651F3B303CE7), -(56196,'Win','x64','WoW',0x81FC14274BFF0347FFF9C8B1AA6BED9B), -(56263,'Win','x64','WoW',0xEA8472C99236CC617BF518A924014D56), -(56288,'Mac','A64','WoW',0x41710C793EF021721F14B06EC1896D3F), -(56288,'Win','x64','WoW',0x03544E35D0480938E5C1238B3A26BDDD), -(56311,'Mac','A64','WoW',0x412D3200715AAFDC0522DF031A941F0E), -(56311,'Win','x64','WoW',0xAC6415575AEE4D32735FFAD0C57226B2), -(56313,'Mac','A64','WoW',0xA83ED19EE659BC95CC322D1E49BDEDBB), -(56313,'Win','x64','WoW',0xEAF769009A9AD3B1AA0414E1C344074B), -(56380,'Win','x64','WoW',0xD081784493233E2869933FCC01F1A3C1), -(56380,'Win','x64','WoWC',0x4FB3D72D89F5FF01DD7F4E028494A4E6), -(56382,'Win','x64','WoW',0x67C36A3EF655534C58AD50942192BFDA), -(56382,'Win','x64','WoWC',0xA5BD7A1C33039F58CD45CD5C7EBDF122), -(56421,'Mac','A64','WoW',0x5892FFABAEFDCECB0CFFAAA55D2F9B13), -(56421,'Win','x64','WoW',0x3BDFA9AA4B70041F2C8B8CDE3C8DC255), -(56421,'Win','x64','WoWC',0x0DDB8F8738647F3CD8FD585A3A78ED1B); +(25549,'Mac','x64','WoW',_binary 'f^ pa&y_\\'), +(25549,'Win','x64','WoW',_binary 'RbN\\\\\?]g5\'), +(25549,'Win','x86','WoW',_binary 'YO\^ٝ6J'), +(25996,'Mac','x64','WoW',_binary '! I\\l\\'), +(25996,'Win','x64','WoW',_binary '\-j!t\8\rm+'), +(25996,'Win','x86','WoW',_binary '#ŜYc\\[rx\\'), +(26124,'Mac','x64','WoW',_binary '\ʙz\\\Te\) N'), +(26124,'Win','x64','WoW',_binary 'F\\{{\SC^ ?'), +(26124,'Win','x86','WoW',_binary 'Z\r\\l\z\\9'), +(26365,'Mac','x64','WoW',_binary '\\`\'mk@\n]Q'), +(26365,'Win','x64','WoW',_binary 'Y?0rEKA\\P<'), +(26365,'Win','x86','WoW',_binary '*\,\ \Z:'), +(26654,'Mac','x64','WoW',_binary '4^\d\\\'), +(26654,'Win','x64','WoW',_binary 'Rd[W2 ĒZ'), +(26654,'Win','x86','WoW',_binary '\֓\\u$V\'), +(26822,'Mac','x64','WoW',_binary '\06h\E\N͍\\e\k'), +(26822,'Win','x64','WoW',_binary '+\\F\\~\P \'), +(26822,'Win','x86','WoW',_binary '(>w\\ \4{\\\\'), +(26899,'Mac','x64','WoW',_binary 'h\\)\n3)\0\'), +(26899,'Win','x64','WoW',_binary '5Q\\0(Y%dK'), +(26899,'Win','x86','WoW',_binary '\b\/\\>u0۱'), +(26972,'Mac','x64','WoW',_binary '4=r@}\5\\j'), +(26972,'Win','x64','WoW',_binary 'n!-\j$٭\\\"\'), +(26972,'Win','x86','WoW',_binary 'y~\f-\\ \nD?&'), +(28153,'Win','x64','WoW',_binary '\be\m1+G4\\\n'), +(30706,'Win','x64','WoW',_binary 'mfJhQx0'), +(30993,'Win','x64','WoW',_binary '+aeZ/\\H6@:'), +(31229,'Win','x64','WoW',_binary 'F\6p0*ɤrv8+'), +(31429,'Win','x64','WoW',_binary 'w\R^rO\\ '), +(31478,'Win','x64','WoW',_binary 'ys\Kۋy\q\'), +(32305,'Win','x64','WoW',_binary '!\z؟Aڋ8j'), +(32494,'Win','x64','WoW',_binary 'XJ\\\a0'), +(32580,'Win','x64','WoW',_binary '\ד\)%\\'), +(32638,'Win','x64','WoW',_binary ']\\Ԩg\\a]\"mN'), +(32722,'Win','x64','WoW',_binary '\Z 8\"XkI1\\Ԫ'), +(32750,'Mac','x64','WoW',_binary '\NM \޼p'), +(32750,'Win','x64','WoW',_binary '\\fZ[#}UCw2'), +(32978,'Mac','x64','WoW',_binary 'RG\\\E\'\3\9'), +(32978,'Win','x64','WoW',_binary 'v.>R]\hC\H\0'), +(33369,'Mac','x64','WoW',_binary '\I\\nT\~>fq'), +(33369,'Win','x64','WoW',_binary 'YM<@?VόO\n'), +(33528,'Win','x64','WoW',_binary '\<\\y,x[G\'), +(33724,'Win','x64','WoW',_binary '8\\(I9\ \\L\w'), +(33775,'Mac','x64','WoW',_binary '5M-\\$\\k6'), +(33775,'Win','x64','WoW',_binary '&0\nI\n\nG-.'), +(33941,'Win','x64','WoW',_binary '\Z6\w\r\nlIp'), +(34220,'Win','x64','WoW',_binary '\[lkPW\0\\fj,'), +(34601,'Win','x64','WoW',_binary '\r}\r_\ %wc'), +(34769,'Win','x64','WoW',_binary 'c\\\\M6\i\'), +(34963,'Mac','x64','WoW',_binary '\e\4G\m\n'), +(34963,'Win','x64','WoW',_binary '{ ]\"#*\`:'), +(35249,'Win','x64','WoW',_binary 'DZ\ \X)\\r'), +(35284,'Mac','x64','WoW',_binary ' \nŧ=/\ǛR'), +(35284,'Win','x64','WoW',_binary '\8\\ \\<O'), +(35435,'Mac','x64','WoW',_binary '\WJF\,\\7\0E'), +(35435,'Win','x64','WoW',_binary '9z#t/µ.\\'), +(35662,'Mac','x64','WoW',_binary 'Yfl6\\\g'), +(35662,'Win','x64','WoW',_binary 'W\Hp\x\ib\m\'), +(36753,'Win','x64','WoW',_binary '8oޅY\\{yI '), +(36839,'Win','x64','WoW',_binary '5nA+\.:\\rQ\)'), +(36949,'Win','x64','WoW',_binary 'Qt͊ SA\i'), +(37142,'Win','x64','WoW',_binary ']19\Ѷ³&\'), +(37176,'Win','x64','WoW',_binary 'q\'), +(39653,'Win','x64','WoW',_binary '\\1(\\~\F2'), +(39804,'Win','x64','WoW',_binary '\-+\&\nv\wឥ'), +(40000,'Win','x64','WoW',_binary 'LC:7\\"'), +(40120,'Mac','x64','WoW',_binary '?)ή\m\\"X<\z|'), +(40120,'Win','x64','WoW',_binary '\~\P\3fx'), +(40443,'Win','x64','WoW',_binary 'C\8\U迷*\'), +(40593,'Win','x64','WoW',_binary 'W-b\\S9Ad\\'), +(40725,'Win','x64','WoW',_binary '\\뛲n\\\\z;'), +(40906,'Win','x64','WoW',_binary '\%5H\r \#\a\'), +(40944,'Win','x64','WoW',_binary '6\􇨠Ipept'), +(40966,'Win','x64','WoW',_binary '\G!\\\\v;K'), +(41031,'Win','x64','WoW',_binary 'ְ\7K{[gtI'), +(41079,'Win','x64','WoW',_binary '<# wb߮\'), +(41288,'Win','x64','WoW',_binary ' \\6\$\?['), +(41323,'Win','x64','WoW',_binary '\=\r\qJ'), +(41359,'Win','x64','WoW',_binary '_*i\nCu*(\ց'), +(41488,'Win','x64','WoW',_binary '\\hpX\\2S\ف'), +(41793,'Win','x64','WoW',_binary '}aUpt*Uf\'), +(42010,'Win','x64','WoW',_binary '0)pA{[\S\S\Z'), +(42423,'Win','x64','WoW',_binary ' aJ~\WTB\'), +(42488,'Win','x64','WoW',_binary 'U撍q\\\<\o'), +(42521,'Win','x64','WoW',_binary '_\/\Ʊ[J];[J];'), +(42538,'Win','x64','WoW',_binary 'qPK\?\\Be\s'), +(42560,'Win','x64','WoW',_binary '_\Êg\Fd.\r'), +(42614,'Win','x64','WoW',_binary 'w+\&\BBU\\ys\'), +(42698,'Win','x64','WoW',_binary 'I{\\t\ T\ri'), +(42825,'Win','x64','WoW',_binary 'M(Ʀ\ݺQ!9\W'), +(42852,'Win','x64','WoW',_binary 'ޟ <\Tӯ\\)'), +(42937,'Win','x64','WoW',_binary '\u\tu,k33c'), +(42979,'Win','x64','WoW',_binary '\\8dPM*\`3ŞT'), +(43114,'Win','x64','WoW',_binary '\\\̲JHN\RYJ~'), +(43206,'Win','x64','WoW',_binary '\\S,w_%m\\\\'), +(43340,'Win','x64','WoW',_binary 'p\m-ߓꄛ\'), +(43345,'Win','x64','WoW',_binary '\\\rN\\\r\'), +(43971,'Win','x64','WoW',_binary 'ha\0\\\n\'), +(44015,'Win','x64','WoW',_binary '\ɋ*\\Ú!z'), +(44061,'Win','x64','WoW',_binary '+\\ 2nx'), +(44127,'Win','x64','WoW',_binary 'xx\\ɵH`\4'), +(44232,'Win','x64','WoW',_binary '\\\;u\0\"\M3\'), +(44325,'Win','x64','WoW',_binary '}RM&4\\H\\'), +(44730,'Win','x64','WoW',_binary ' \{ǟC\0\\\\\'), +(44908,'Win','x64','WoW',_binary '\@ɼՑ\\Yը'), +(45114,'Win','x64','WoW',_binary 'ׯ\@\0\l0\\\nT'), +(45161,'Win','x64','WoW',_binary 't.xzEcl'), +(45338,'Win','x64','WoW',_binary '\\\ JAڝ\cx;\'), +(45745,'Win','x64','WoW',_binary 'm\aiMvZYZ:\k'), +(46479,'Win','x64','WoW',_binary '˚\؛`ӕ\\2'), +(46658,'Win','x64','WoW',_binary '?T(\S`\\\\\\c'), +(46689,'Win','x64','WoW',_binary '١j\ \Fu\Ӫ'), +(46702,'Win','x64','WoW',_binary '\h}ɪ\\n , '), +(46741,'Win','x64','WoW',_binary 'LJ~\ \Eǚx'), +(46801,'Win','x64','WoW',_binary '\\\]6^\\0\'), +(46879,'Win','x64','WoW',_binary '\\C`Q\\Z!3kc\'), +(46924,'Win','x64','WoW',_binary '\\ \Z\i\\\۪{'), +(47067,'Win','x64','WoW',_binary 'c,ަ+\\@\6VW'), +(47187,'Win','x64','WoW',_binary 'qU\\0 #r\\\1\'), +(47213,'Win','x64','WoW',_binary '#\\rά\nލ\DԢ'), +(47631,'Win','x64','WoW',_binary 'Ю\"\/BVq<'), +(47777,'Win','x64','WoW',_binary 'Z\5\\\M\_'), +(47799,'Win','x64','WoW',_binary 'sd\ <#\,ܕէ>'), +(47825,'Win','x64','WoW',_binary 'N^rz\q T'), +(47849,'Win','x64','WoW',_binary '݋ \n\L#\'), +(47871,'Win','x64','WoW',_binary 'O}0\I+;?7\\\'), +(47884,'Win','x64','WoW',_binary '+z\0+\Y\\-\C'), +(47936,'Win','x64','WoW',_binary '=0\\;?\8\I'), +(47967,'Win','x64','WoW',_binary '\\%\\"MuAӵ\dx'), +(48001,'Win','x64','WoW',_binary 'K`{\[a^qi\ջ'), +(48069,'Win','x64','WoW',_binary 'Uߕ\XIw|iE\'), +(48317,'Win','x64','WoW',_binary '\{E2D\Ǚ`Mԯ'), +(48397,'Win','x64','WoW',_binary 'dy\~lW+k\Z[2\'), +(48526,'Win','x64','WoW',_binary 'շ\0:*ti\\Z\ \e'), +(48676,'Win','x64','WoW',_binary '\Yt\\C\ (d\'), +(48749,'Win','x64','WoW',_binary '\̠\=F'), +(48838,'Win','x64','WoW',_binary 'oNF\\"-\{Ċ'), +(48865,'Win','x64','WoW',_binary 'KwJ{4\p%q\'Kj'), +(48892,'Win','x64','WoW',_binary '1\'E!:\Z4id\{'), +(48966,'Win','x64','WoW',_binary '1B\q_\]CC\\\m'), +(48999,'Win','x64','WoW',_binary 'yo\g.\_d\\b\'), +(49267,'Win','x64','WoW',_binary '\\~\s\Z۴\Z\\1'), +(49318,'Win','x64','WoW',_binary 'C\b\Hl%='), +(49343,'Win','x64','WoW',_binary '0\Z L B\l`'), +(49407,'Win','x64','WoW',_binary 'd\rɈ[i;7 /0'), +(49426,'Win','x64','WoW',_binary '\^߿\JU\Q \'), +(49444,'Win','x64','WoW',_binary '6;+([݈WA(f1m<'), +(49474,'Win','x64','WoW',_binary 'DҳR\= <\\^7'), +(49570,'Win','x64','WoW',_binary '$\g\\m\>'), +(49679,'Win','x64','WoW',_binary '\h\y~\0XAC'), +(49741,'Win','x64','WoW',_binary '\\l\B*޶\\Z'), +(49801,'Win','x64','WoW',_binary '2gl]Vxƃ'), +(49890,'Win','x64','WoW',_binary '\"\yzd_p[=L'), +(50000,'Win','x64','WoW',_binary '\o\"f8B\ZL'), +(50401,'Win','x64','WoW',_binary '>\R\\\\\U\I8'), +(50438,'Win','x64','WoW',_binary ' _h\k\w\\& '), +(50467,'Win','x64','WoW',_binary '^k\\hC-c@h\\'), +(50469,'Win','x64','WoW',_binary 'h̶X;\\'), +(50504,'Win','x64','WoW',_binary '}_\ 2ɯ]\T3Ԝ'), +(50585,'Win','x64','WoW',_binary '\\\8I5\\>vK'), +(50622,'Win','x64','WoW',_binary '\:&u`s\p`(\'), +(50747,'Win','x64','WoW',_binary '-<8jE\s\:]\^2\'), +(52301,'Win','x64','WoW',_binary '\Z#{@ \Ip%9'), +(52393,'Win','x64','WoW',_binary '\#\QEYM\r'), +(52485,'Win','x64','WoW',_binary 'Xδe0HX\0\DA'), +(52545,'Win','x64','WoW',_binary 'RUn\܎\\\'), +(52607,'Win','x64','WoW',_binary '\0.J\\ˆ 1`'), +(52649,'Win','x64','WoW',_binary 'зy\\\Z\?ȧ['), +(52808,'Win','x64','WoW',_binary 'bvq+l\!\]\/\p\'), +(52902,'Win','x64','WoW',_binary '\\L\V(S8z2j\'), +(52968,'Win','x64','WoW',_binary '-$\@\MO [ \'), +(52983,'Win','x64','WoW',_binary '孥\l\ئ3$'), +(53007,'Win','x64','WoW',_binary '\ZM8VGBX\\'), +(53040,'Win','x64','WoW',_binary '/{0{p۽u\B\\'), +(53104,'Win','x64','WoW',_binary '\מ\\KSlj1ʴ'), +(53162,'Win','x64','WoW',_binary 'gQ\\0\\#7j'), +(53212,'Win','x64','WoW',_binary 'v/cdI'), +(53262,'Win','x64','WoW',_binary 'aJr\1&4I\'\S+z'), +(53441,'Win','x64','WoW',_binary '\}\}_u\޴\ɝ|'), +(53584,'Win','x64','WoW',_binary '\ש6Y4`\J\UT'), +(53840,'Win','x64','WoW',_binary '\E\\r\\_>U\d'), +(53877,'Win','x64','WoW',_binary '28F\'n&\J\'), +(53913,'Win','x64','WoW',_binary 'GVh !\\gD\OuQ'), +(53989,'Win','x64','WoW',_binary ':됬ወ!\-QW'), +(54070,'Win','x64','WoW',_binary 'dXrP\x`!i'), +(54205,'Win','x64','WoW',_binary 'XY\?\rmw\]\\'), +(54358,'Win','x64','WoW',_binary '\3\f\Ed@LԌʉ'), +(54499,'Win','x64','WoW',_binary 'j\\Ð\ۓ;\3&'), +(54577,'Win','x64','WoW',_binary '˻\R\\\c'), +(54601,'Win','x64','WoW',_binary 'f\}\"s\[9)bsu'), +(54604,'Win','x64','WoW',_binary 'L\5\Mc\"C'), +(54630,'Win','x64','WoW',_binary '\y5Q Y6<\0'), +(54673,'Win','x64','WoW',_binary 'a(I\"Z\0M'), +(54717,'Win','x64','WoW',_binary '+kV\4\\Z'), +(54736,'Win','x64','WoW',_binary 'X\9\$\'\/'), +(54762,'Win','x64','WoW',_binary '_\V\00%TEEj(l'), +(54847,'Win','x64','WoW',_binary '251`\Q\6\\\\'), +(54904,'Win','x64','WoW',_binary ' \\<\r\(ٸy\'), +(54988,'Win','x64','WoW',_binary '\'U2&w\\s'), +(55142,'Win','x64','WoW',_binary ')g\=*\zAS'), +(55165,'Win','x64','WoW',_binary '&\\4r=ʼKo\'), +(55261,'Win','x64','WoW',_binary '\S\I\'Kzz\'), +(55461,'Win','x64','WoW',_binary '\R&tT\\\l\TP'), +(55664,'Win','x64','WoW',_binary '\\XHoT\(z0G\#'), +(55666,'Win','x64','WoW',_binary '\娎M6Rȹ\na|'), +(55792,'Win','x64','WoW',_binary '\\ͪDT\\}!G'), +(55793,'Win','x64','WoW',_binary '\228\hջd'), +(55818,'Win','x64','WoW',_binary ':TbH\\ٰj,$'), +(55824,'Win','x64','WoW',_binary 'o&(zx'), +(55846,'Win','x64','WoW',_binary '^\pXr\&K\'), +(55933,'Win','x64','WoW',_binary '\MB\5@\r\!|\'), +(55939,'Win','x64','WoW',_binary 'RL\\\N&`ܭ\'), +(55959,'Win','x64','WoW',_binary '\W\S\Ιq41H'), +(55960,'Win','x64','WoW',_binary 'l{7\0l'), +(56008,'Win','x64','WoW',_binary '\0ֿ̺zq\\n '), +(56110,'Win','x64','WoW',_binary ' \\"/7\< \:'), +(56162,'Win','x64','WoW',_binary 'o\\CfeM|\6N'), +(56196,'Mac','A64','WoW',_binary 'wj]\N\oe;0<\'), +(56196,'Win','x64','WoW',_binary '\'KGȱk\'), +(56263,'Win','x64','WoW',_binary '\rɒ6\a{\$MV'), +(56288,'Mac','A64','WoW',_binary 'Aq y>\!rnm?'), +(56288,'Win','x64','WoW',_binary 'TN5\H 8\#:&\'), +(56311,'Mac','A64','WoW',_binary 'A-2\0qZ\\"\\Z'), +(56311,'Win','x64','WoW',_binary 'dWZ\M2s_\\r&'), +(56313,'Mac','A64','WoW',_binary '>ў\Y\2-I\'), +(56313,'Win','x64','WoW',_binary '\\i\0ӱ\\DK'), +(56380,'Win','x64','WoW',_binary 'ЁxD#>(i?\\'), +(56380,'Win','x64','WoWC',_binary 'O\-\\N\'), +(56382,'Win','x64','WoW',_binary 'g\j>\USLXP!\'), +(56382,'Win','x64','WoWC',_binary 'z3X\E\\\~\\"'), +(56421,'Mac','A64','WoW',_binary 'X\\ ]/'), +(56421,'Win','x64','WoW',_binary ';ߩKp,\<\U'), +(56421,'Win','x64','WoWC',_binary '\rۏ8d<\XZ:x\'); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -802,12 +802,12 @@ CREATE TABLE `build_executable_hash` ( LOCK TABLES `build_executable_hash` WRITE; /*!40000 ALTER TABLE `build_executable_hash` DISABLE KEYS */; INSERT INTO `build_executable_hash` VALUES -(5875,'OSX',0x8D173CC381961EEBABF336F5E6675B101BB513E5), -(5875,'Win',0x95EDB27C7823B363CBDDAB56A392E7CB73FCCA20), -(8606,'OSX',0xD8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F), -(8606,'Win',0x319AFAA3F2559682F9FF658BE01456255F456FB1), -(12340,'OSX',0xB706D13FF2F4018839729461E3F8A0E2B5FDC034), -(12340,'Win',0xCDCBBD5188315E6B4D19449D492DBCFAF156A347); +(5875,'OSX',_binary '<Á\\6\\g[\'), +(5875,'Win',_binary '\|x#c\ݫV\\s\ '), +(8606,'OSX',_binary 'ذ\SK\\\\\O'), +(8606,'Win',_binary '1\Ue\V%_Eo'), +(12340,'OSX',_binary '\?\\9ra\\4'), +(12340,'Win',_binary '\˽Q1^kMDI-\VG'); /*!40000 ALTER TABLE `build_executable_hash` ENABLE KEYS */; UNLOCK TABLES; @@ -3171,35 +3171,36 @@ INSERT INTO `updates` VALUES ('2024_05_08_00_auth.sql','F2EEE0D225CB82DBB3A478E0BF6A0116C9265355','ARCHIVED','2024-05-08 20:35:53',0), ('2024_05_10_00_auth.sql','8A6E48012413EA769601A8E4C9F82BEFBE1FCA5C','ARCHIVED','2024-05-10 00:50:46',0), ('2024_05_11_00_auth.sql','8D703BE97247DBC4A4935EAEA9CB681B0EEFBB3C','ARCHIVED','2024-05-11 03:06:52',0), -('2024_05_14_00_auth.sql','C36612C0215E255E1D4917876FD52C8F1F9BCDA7','RELEASED','2024-05-14 03:39:01',0), -('2024_05_16_00_auth.sql','5980F77073B6AD55ABCF0F9735408A4F35C97159','RELEASED','2024-05-16 08:13:11',0), -('2024_05_17_00_auth.sql','E02B96055C887BED76442B2C3C49C51659BCC602','RELEASED','2024-05-17 14:24:15',0), -('2024_05_18_00_auth.sql','C3392BDA5AAC304AD72BAC631DA1C9802D20EDAC','RELEASED','2024-05-18 01:52:01',0), -('2024_05_25_00_auth.sql','A34E299F5D75535D17C6295023910539897D1392','RELEASED','2024-05-25 12:10:08',0), -('2024_05_29_00_auth.sql','6F42C6565CB748E3C1231F4EA0A6D04F2F95C0A3','RELEASED','2024-05-29 19:12:53',0), -('2024_06_05_00_auth.sql','B6306773C94879872E0B3FDAFE12ECDEA4C9264F','RELEASED','2024-06-05 09:37:55',0), -('2024_06_15_00_auth.sql','FDF2F29F5AB0213C9C2AB937852F0BAE552CFDCE','RELEASED','2024-06-15 00:01:40',0), -('2024_06_17_00_auth.sql','3781820B8F3B238F89BC8E83EC164B767A63BBB3','RELEASED','2024-06-17 22:34:47',0), -('2024_06_26_00_auth.sql','428762D840B37F2569FC477E0B5B452C7E98B301','RELEASED','2024-06-26 13:59:17',0), -('2024_07_09_00_auth.sql','C58A8D47CAFA34055EEB079E72AA820EF7C55368','RELEASED','2024-07-09 12:00:23',0), -('2024_07_16_00_auth.sql','4161C07EACA71CE3D0269D2067563594D26DEC27','RELEASED','2024-07-16 19:02:24',0), -('2024_08_02_00_auth.sql','6BE2A6DA2F2BE21B18396F120427E973F1CAA58F','RELEASED','2024-08-02 00:45:10',0), -('2024_08_07_00_auth.sql','88070C3A95DE7242B3E3662D7B5B9648128DC187','RELEASED','2024-08-07 01:06:23',0), -('2024_08_09_00_auth.sql','854C24AAF0B3F673DAD8C0F3059DB266B0F34488','RELEASED','2024-08-09 15:40:42',0), -('2024_08_15_00_auth.sql','06E9AD907DC2B2CC0CF78414AB516BBA3ED0CE65','RELEASED','2024-08-15 19:40:50',0), -('2024_08_17_00_auth.sql','3584B5A910334447D6E948DBAA0EEC43C42FE631','RELEASED','2024-08-17 15:17:22',0), -('2024_08_18_00_auth.sql','5C1D0A3FE0245F4030FE446288AE533556EC6C9E','RELEASED','2024-08-17 23:01:21',0), -('2024_08_21_00_auth.sql','6F2844107F0501E7631C8196CC04E75853381319','RELEASED','2024-08-21 15:25:46',0), -('2024_08_22_00_auth.sql','D5466F5E9D1475323ED90553361D7F7B4CF83BF7','RELEASED','2024-08-22 23:35:36',0), -('2024_08_23_00_auth.sql','A591DA576EAEA3F48AB9E8269A2E4071B2C3C930','RELEASED','2024-08-23 17:35:52',0), -('2024_08_23_01_auth.sql','1ABD54E76B2D6712BF3DE06DD60A18C38BCF9CF1','RELEASED','2024-08-23 19:59:36',0), -('2024_08_24_00_auth.sql','6D2CE419F8E8512051B63D0F68B30BAA769F9D4A','RELEASED','2024-08-24 10:23:33',0), -('2024_08_28_00_auth.sql','F39CA1C18CAC207418C3D3703DA0F038471D308A','RELEASED','2024-08-28 10:50:31',0), -('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','RELEASED','2024-08-28 14:55:05',0), -('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','RELEASED','2024-08-30 19:24:30',0), -('2024_08_30_01_auth.sql','0AAC95A9216114177AF0A3A7DE664D061FED21EA','RELEASED','2024-08-30 22:23:08',0), -('2024_08_31_00_auth.sql','D10F12D25D526A2C5E12FCEA2DEB55C342879F06','RELEASED','2024-08-31 10:32:16',0), -('2024_08_31_01_auth.sql','3ADC34DAE405697983EDDD32D0F3FC6F122CA819','RELEASED','2024-09-01 15:48:43',0); +('2024_05_14_00_auth.sql','C36612C0215E255E1D4917876FD52C8F1F9BCDA7','ARCHIVED','2024-05-14 03:39:01',0), +('2024_05_16_00_auth.sql','5980F77073B6AD55ABCF0F9735408A4F35C97159','ARCHIVED','2024-05-16 08:13:11',0), +('2024_05_17_00_auth.sql','E02B96055C887BED76442B2C3C49C51659BCC602','ARCHIVED','2024-05-17 14:24:15',0), +('2024_05_18_00_auth.sql','C3392BDA5AAC304AD72BAC631DA1C9802D20EDAC','ARCHIVED','2024-05-18 01:52:01',0), +('2024_05_25_00_auth.sql','A34E299F5D75535D17C6295023910539897D1392','ARCHIVED','2024-05-25 12:10:08',0), +('2024_05_29_00_auth.sql','6F42C6565CB748E3C1231F4EA0A6D04F2F95C0A3','ARCHIVED','2024-05-29 19:12:53',0), +('2024_06_05_00_auth.sql','B6306773C94879872E0B3FDAFE12ECDEA4C9264F','ARCHIVED','2024-06-05 09:37:55',0), +('2024_06_15_00_auth.sql','FDF2F29F5AB0213C9C2AB937852F0BAE552CFDCE','ARCHIVED','2024-06-15 00:01:40',0), +('2024_06_17_00_auth.sql','3781820B8F3B238F89BC8E83EC164B767A63BBB3','ARCHIVED','2024-06-17 22:34:47',0), +('2024_06_26_00_auth.sql','428762D840B37F2569FC477E0B5B452C7E98B301','ARCHIVED','2024-06-26 13:59:17',0), +('2024_07_09_00_auth.sql','C58A8D47CAFA34055EEB079E72AA820EF7C55368','ARCHIVED','2024-07-09 12:00:23',0), +('2024_07_16_00_auth.sql','4161C07EACA71CE3D0269D2067563594D26DEC27','ARCHIVED','2024-07-16 19:02:24',0), +('2024_08_02_00_auth.sql','6BE2A6DA2F2BE21B18396F120427E973F1CAA58F','ARCHIVED','2024-08-02 00:45:10',0), +('2024_08_07_00_auth.sql','88070C3A95DE7242B3E3662D7B5B9648128DC187','ARCHIVED','2024-08-07 01:06:23',0), +('2024_08_09_00_auth.sql','854C24AAF0B3F673DAD8C0F3059DB266B0F34488','ARCHIVED','2024-08-09 15:40:42',0), +('2024_08_15_00_auth.sql','06E9AD907DC2B2CC0CF78414AB516BBA3ED0CE65','ARCHIVED','2024-08-15 19:40:50',0), +('2024_08_17_00_auth.sql','3584B5A910334447D6E948DBAA0EEC43C42FE631','ARCHIVED','2024-08-17 15:17:22',0), +('2024_08_18_00_auth.sql','5C1D0A3FE0245F4030FE446288AE533556EC6C9E','ARCHIVED','2024-08-17 23:01:21',0), +('2024_08_21_00_auth.sql','6F2844107F0501E7631C8196CC04E75853381319','ARCHIVED','2024-08-21 15:25:46',0), +('2024_08_22_00_auth.sql','D5466F5E9D1475323ED90553361D7F7B4CF83BF7','ARCHIVED','2024-08-22 23:35:36',0), +('2024_08_23_00_auth.sql','A591DA576EAEA3F48AB9E8269A2E4071B2C3C930','ARCHIVED','2024-08-23 17:35:52',0), +('2024_08_23_01_auth.sql','1ABD54E76B2D6712BF3DE06DD60A18C38BCF9CF1','ARCHIVED','2024-08-23 19:59:36',0), +('2024_08_24_00_auth.sql','6D2CE419F8E8512051B63D0F68B30BAA769F9D4A','ARCHIVED','2024-08-24 10:23:33',0), +('2024_08_28_00_auth.sql','F39CA1C18CAC207418C3D3703DA0F038471D308A','ARCHIVED','2024-08-28 10:50:31',0), +('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','ARCHIVED','2024-08-28 14:55:05',0), +('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','ARCHIVED','2024-08-30 19:24:30',0), +('2024_08_30_01_auth.sql','0AAC95A9216114177AF0A3A7DE664D061FED21EA','ARCHIVED','2024-08-30 22:23:08',0), +('2024_08_31_00_auth.sql','D10F12D25D526A2C5E12FCEA2DEB55C342879F06','ARCHIVED','2024-08-31 10:32:16',0), +('2024_08_31_01_auth.sql','3ADC34DAE405697983EDDD32D0F3FC6F122CA819','ARCHIVED','2024-09-01 15:48:43',0), +('2024_09_03_00_auth.sql','BF65B550256CA64F0936D98A619E8A2A7E7A9B59','ARCHIVED','2024-09-03 00:47:42',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3226,6 +3227,7 @@ LOCK TABLES `updates_include` WRITE; INSERT INTO `updates_include` VALUES ('$/sql/custom/auth','RELEASED'), ('$/sql/old/10.x/auth','ARCHIVED'), +('$/sql/old/11.x/auth','ARCHIVED'), ('$/sql/old/6.x/auth','ARCHIVED'), ('$/sql/old/7/auth','ARCHIVED'), ('$/sql/old/8.x/auth','ARCHIVED'), @@ -3342,4 +3344,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-05-11 3:06:54 +-- Dump completed on 2024-09-03 0:47:44 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 5555e63e456..556f50eb348 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 8.0.36-0ubuntu0.22.04.1 +-- Server version 8.0.39-0ubuntu0.22.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -3743,10 +3743,11 @@ INSERT INTO `updates` VALUES ('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','ARCHIVED','2024-04-12 00:23:51',0), ('2024_04_28_00_characters.sql','F80F476704BE535B5DCB0BCEBDD56024FCFBBAA2','ARCHIVED','2024-04-28 19:26:58',0), ('2024_05_11_00_characters.sql','A65765D87C1BA181561A6517040DC1A3A8103B71','ARCHIVED','2024-05-11 03:06:52',0), -('2024_07_31_00_characters.sql','F7E7AE0B8077CB9A1EA0AE4F49693BB05A742AC3','RELEASED','2024-07-31 16:18:36',0), -('2024_08_04_00_characters.sql','7D153C59998416E6EA1455086730A2321AD0F2A8','RELEASED','2024-08-04 17:58:59',0), -('2024_08_05_00_characters.sql','7E4AE28F9EC370A1B22DBD8DD718EE027A321F33','RELEASED','2024-08-05 11:19:40',0), -('2024_08_26_00_characters.sql','68EEBE1D639D59B24F5121008C2D103CA67FFC9A','RELEASED','2024-08-26 00:49:08',0); +('2024_07_31_00_characters.sql','F7E7AE0B8077CB9A1EA0AE4F49693BB05A742AC3','ARCHIVED','2024-07-31 16:18:36',0), +('2024_08_04_00_characters.sql','7D153C59998416E6EA1455086730A2321AD0F2A8','ARCHIVED','2024-08-04 17:58:59',0), +('2024_08_05_00_characters.sql','7E4AE28F9EC370A1B22DBD8DD718EE027A321F33','ARCHIVED','2024-08-05 11:19:40',0), +('2024_08_26_00_characters.sql','68EEBE1D639D59B24F5121008C2D103CA67FFC9A','ARCHIVED','2024-08-26 00:49:08',0), +('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3773,6 +3774,7 @@ LOCK TABLES `updates_include` WRITE; INSERT INTO `updates_include` VALUES ('$/sql/custom/characters','RELEASED'), ('$/sql/old/10.x/characters','ARCHIVED'), +('$/sql/old/11.x/characters','ARCHIVED'), ('$/sql/old/6.x/characters','ARCHIVED'), ('$/sql/old/7/characters','ARCHIVED'), ('$/sql/old/8.x/characters','ARCHIVED'), @@ -3873,4 +3875,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-05-11 3:06:54 +-- Dump completed on 2024-09-03 0:47:44 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 90420b08f7b..5b32be0a424 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 8.0.36-0ubuntu0.22.04.1 +-- Server version 8.0.39-0ubuntu0.22.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -270,7 +270,7 @@ CREATE TABLE `animation_data` ( `ID` int unsigned NOT NULL DEFAULT '0', `Fallback` smallint unsigned NOT NULL DEFAULT '0', `BehaviorTier` tinyint unsigned NOT NULL DEFAULT '0', - `BehaviorID` int NOT NULL DEFAULT '0', + `BehaviorID` smallint NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -392,6 +392,21 @@ CREATE TABLE `area_trigger` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `area_trigger_action_set` +-- + +DROP TABLE IF EXISTS `area_trigger_action_set`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `area_trigger_action_set` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `armor_location` -- @@ -599,7 +614,7 @@ CREATE TABLE `artifact_power` ( `MaxPurchasableRank` tinyint unsigned NOT NULL DEFAULT '0', `Label` int NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', - `Tier` tinyint unsigned NOT NULL DEFAULT '0', + `Tier` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1287,22 +1302,6 @@ CREATE TABLE `battlemaster_list` ( `Flags` int NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', `RequiredPlayerConditionID` int NOT NULL DEFAULT '0', - `MapID1` smallint NOT NULL DEFAULT '0', - `MapID2` smallint NOT NULL DEFAULT '0', - `MapID3` smallint NOT NULL DEFAULT '0', - `MapID4` smallint NOT NULL DEFAULT '0', - `MapID5` smallint NOT NULL DEFAULT '0', - `MapID6` smallint NOT NULL DEFAULT '0', - `MapID7` smallint NOT NULL DEFAULT '0', - `MapID8` smallint NOT NULL DEFAULT '0', - `MapID9` smallint NOT NULL DEFAULT '0', - `MapID10` smallint NOT NULL DEFAULT '0', - `MapID11` smallint NOT NULL DEFAULT '0', - `MapID12` smallint NOT NULL DEFAULT '0', - `MapID13` smallint NOT NULL DEFAULT '0', - `MapID14` smallint NOT NULL DEFAULT '0', - `MapID15` smallint NOT NULL DEFAULT '0', - `MapID16` smallint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1338,6 +1337,22 @@ CREATE TABLE `battlemaster_list_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `battlemaster_list_x_map` +-- + +DROP TABLE IF EXISTS `battlemaster_list_x_map`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `battlemaster_list_x_map` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `MapID` int NOT NULL DEFAULT '0', + `BattlemasterListID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `broadcast_text` -- @@ -1490,10 +1505,8 @@ CREATE TABLE `challenge_mode_item_bonus_override` ( `ID` int unsigned NOT NULL DEFAULT '0', `ItemBonusTreeGroupID` int NOT NULL DEFAULT '0', `DstItemBonusTreeID` int NOT NULL DEFAULT '0', - `Type` tinyint NOT NULL DEFAULT '0', `Value` int NOT NULL DEFAULT '0', - `MythicPlusSeasonID` int NOT NULL DEFAULT '0', - `PvPSeasonID` int NOT NULL DEFAULT '0', + `RequiredTimeEventPassed` int NOT NULL DEFAULT '0', `SrcItemBonusTreeID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -1699,7 +1712,7 @@ CREATE TABLE `chr_classes` ( `CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0', `DefaultSpec` smallint unsigned NOT NULL DEFAULT '0', `PrimaryStatPriority` tinyint unsigned NOT NULL DEFAULT '0', - `DisplayPower` tinyint unsigned NOT NULL DEFAULT '0', + `DisplayPower` tinyint NOT NULL DEFAULT '0', `RangedAttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0', `AttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0', `AttackPowerPerStrength` tinyint unsigned NOT NULL DEFAULT '0', @@ -1873,6 +1886,8 @@ CREATE TABLE `chr_customization_option` ( `ID` int unsigned NOT NULL DEFAULT '0', `SecondaryID` smallint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', + `ChrRacesID` int NOT NULL DEFAULT '0', + `Sex` int NOT NULL DEFAULT '0', `ChrModelID` int NOT NULL DEFAULT '0', `SortIndex` int NOT NULL DEFAULT '0', `ChrCustomizationCategoryID` int NOT NULL DEFAULT '0', @@ -2468,7 +2483,7 @@ CREATE TABLE `creature_display_info` ( `PortraitTextureFileDataID` int NOT NULL DEFAULT '0', `ObjectEffectPackageID` smallint unsigned NOT NULL DEFAULT '0', `AnimReplacementSetID` smallint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `StateSpellVisualKitID` int NOT NULL DEFAULT '0', `PlayerOverrideScale` float NOT NULL DEFAULT '0', `PetInstanceScale` float NOT NULL DEFAULT '0', @@ -2478,6 +2493,9 @@ CREATE TABLE `creature_display_info` ( `Gender` tinyint NOT NULL DEFAULT '0', `DissolveOutEffectID` int NOT NULL DEFAULT '0', `CreatureModelMinLod` tinyint NOT NULL DEFAULT '0', + `ConditionalCreatureModelID` smallint unsigned NOT NULL DEFAULT '0', + `Unknown_1100_1` float NOT NULL DEFAULT '0', + `Unknown_1100_2` smallint unsigned NOT NULL DEFAULT '0', `TextureVariationFileDataID1` int NOT NULL DEFAULT '0', `TextureVariationFileDataID2` int NOT NULL DEFAULT '0', `TextureVariationFileDataID3` int NOT NULL DEFAULT '0', @@ -2573,7 +2591,7 @@ CREATE TABLE `creature_model_data` ( `GeoBox4` float NOT NULL DEFAULT '0', `GeoBox5` float NOT NULL DEFAULT '0', `GeoBox6` float NOT NULL DEFAULT '0', - `Flags` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `FileDataID` int unsigned NOT NULL DEFAULT '0', `WalkSpeed` float NOT NULL DEFAULT '0', `RunSpeed` float NOT NULL DEFAULT '0', @@ -2602,10 +2620,11 @@ CREATE TABLE `creature_model_data` ( `OverrideNameScale` float NOT NULL DEFAULT '0', `OverrideSelectionRadius` float NOT NULL DEFAULT '0', `TamedPetBaseScale` float NOT NULL DEFAULT '0', - `Unknown820_1` tinyint NOT NULL DEFAULT '0', - `Unknown820_2` float NOT NULL DEFAULT '0', - `Unknown820_31` float NOT NULL DEFAULT '0', - `Unknown820_32` float NOT NULL DEFAULT '0', + `MountScaleOtherIndex` tinyint NOT NULL DEFAULT '0', + `MountScaleSelf` float NOT NULL DEFAULT '0', + `Unknown1100` smallint unsigned NOT NULL DEFAULT '0', + `MountScaleOther1` float NOT NULL DEFAULT '0', + `MountScaleOther2` float NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2802,6 +2821,7 @@ CREATE TABLE `currency_types` ( `MaxQtyWorldStateID` int NOT NULL DEFAULT '0', `RechargingAmountPerCycle` int unsigned NOT NULL DEFAULT '0', `RechargingCycleDurationMS` int unsigned NOT NULL DEFAULT '0', + `AccountTransferPercentage` float NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2926,7 +2946,7 @@ CREATE TABLE `difficulty` ( `MinPlayers` tinyint unsigned NOT NULL DEFAULT '0', `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0', `Flags` smallint unsigned NOT NULL DEFAULT '0', - `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', + `ItemContext` tinyint NOT NULL DEFAULT '0', `ToggleDifficultyID` tinyint unsigned NOT NULL DEFAULT '0', `GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT '0', `GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT '0', @@ -3082,9 +3102,9 @@ CREATE TABLE `emotes` ( `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', `EmoteSlashCommand` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `AnimID` int NOT NULL DEFAULT '0', - `EmoteFlags` int unsigned NOT NULL DEFAULT '0', - `EmoteSpecProc` tinyint unsigned NOT NULL DEFAULT '0', + `AnimID` smallint NOT NULL DEFAULT '0', + `EmoteFlags` int NOT NULL DEFAULT '0', + `EmoteSpecProc` int NOT NULL DEFAULT '0', `EmoteSpecProcParam` int unsigned NOT NULL DEFAULT '0', `EventSoundID` int unsigned NOT NULL DEFAULT '0', `SpellVisualKitID` int unsigned NOT NULL DEFAULT '0', @@ -3263,7 +3283,7 @@ DROP TABLE IF EXISTS `faction_template`; CREATE TABLE `faction_template` ( `ID` int unsigned NOT NULL DEFAULT '0', `Faction` smallint unsigned NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `FactionGroup` tinyint unsigned NOT NULL DEFAULT '0', `FriendGroup` tinyint unsigned NOT NULL DEFAULT '0', `EnemyGroup` tinyint unsigned NOT NULL DEFAULT '0', @@ -3298,8 +3318,8 @@ DROP TABLE IF EXISTS `friendship_rep_reaction`; CREATE TABLE `friendship_rep_reaction` ( `ID` int unsigned NOT NULL DEFAULT '0', `Reaction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `FriendshipRepID` int unsigned NOT NULL DEFAULT '0', - `ReactionThreshold` smallint unsigned NOT NULL DEFAULT '0', + `FriendshipRepID` int NOT NULL DEFAULT '0', + `ReactionThreshold` int NOT NULL DEFAULT '0', `OverrideColor` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -3422,6 +3442,7 @@ CREATE TABLE `gameobject_display_info` ( `AlternateDisplayType` int NOT NULL DEFAULT '0', `ClientCreatureDisplayInfoID` int NOT NULL DEFAULT '0', `ClientItemID` int NOT NULL DEFAULT '0', + `Unknown1100` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3451,6 +3472,7 @@ CREATE TABLE `gameobjects` ( `PhaseUseFlags` int NOT NULL DEFAULT '0', `PhaseID` int NOT NULL DEFAULT '0', `PhaseGroupID` int NOT NULL DEFAULT '0', + `Unknown1100` smallint unsigned NOT NULL DEFAULT '0', `PropValue1` int NOT NULL DEFAULT '0', `PropValue2` int NOT NULL DEFAULT '0', `PropValue3` int NOT NULL DEFAULT '0', @@ -3697,7 +3719,7 @@ CREATE TABLE `garr_follower` ( `AllianceGarrFollRaceID` tinyint unsigned NOT NULL DEFAULT '0', `HordeGarrClassSpecID` int NOT NULL DEFAULT '0', `AllianceGarrClassSpecID` int NOT NULL DEFAULT '0', - `Quality` tinyint NOT NULL DEFAULT '0', + `Quality` int NOT NULL DEFAULT '0', `FollowerLevel` tinyint unsigned NOT NULL DEFAULT '0', `ItemLevelWeapon` smallint unsigned NOT NULL DEFAULT '0', `ItemLevelArmor` smallint unsigned NOT NULL DEFAULT '0', @@ -3789,7 +3811,7 @@ CREATE TABLE `garr_mission` ( `WorldPosY` float NOT NULL DEFAULT '0', `GarrTypeID` tinyint NOT NULL DEFAULT '0', `GarrMissionTypeID` tinyint unsigned NOT NULL DEFAULT '0', - `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0', + `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0', `MaxFollowers` tinyint unsigned NOT NULL DEFAULT '0', `MissionCost` int unsigned NOT NULL DEFAULT '0', `MissionCostCurrencyTypesID` smallint unsigned NOT NULL DEFAULT '0', @@ -3857,7 +3879,7 @@ DROP TABLE IF EXISTS `garr_plot`; CREATE TABLE `garr_plot` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `PlotType` tinyint unsigned NOT NULL DEFAULT '0', + `PlotType` tinyint NOT NULL DEFAULT '0', `HordeConstructObjID` int NOT NULL DEFAULT '0', `AllianceConstructObjID` int NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', @@ -4055,7 +4077,7 @@ DROP TABLE IF EXISTS `glyph_properties`; CREATE TABLE `glyph_properties` ( `ID` int unsigned NOT NULL DEFAULT '0', `SpellID` int unsigned NOT NULL DEFAULT '0', - `GlyphType` tinyint unsigned NOT NULL DEFAULT '0', + `GlyphType` tinyint NOT NULL DEFAULT '0', `GlyphExclusiveCategoryID` tinyint unsigned NOT NULL DEFAULT '0', `SpellIconFileDataID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -4091,7 +4113,7 @@ CREATE TABLE `gossip_npc_option` ( `GossipNpcOption` int NOT NULL DEFAULT '0', `LFGDungeonsID` int NOT NULL DEFAULT '0', `TrainerID` int NOT NULL DEFAULT '0', - `GarrFollowerTypeID` int NOT NULL DEFAULT '0', + `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0', `CharShipmentID` int NOT NULL DEFAULT '0', `GarrTalentTreeID` int NOT NULL DEFAULT '0', `UiMapID` int NOT NULL DEFAULT '0', @@ -4453,7 +4475,7 @@ DROP TABLE IF EXISTS `item_appearance`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_appearance` ( `ID` int unsigned NOT NULL DEFAULT '0', - `DisplayType` int NOT NULL DEFAULT '0', + `DisplayType` tinyint NOT NULL DEFAULT '0', `ItemDisplayInfoID` int NOT NULL DEFAULT '0', `DefaultIconFileDataID` int NOT NULL DEFAULT '0', `UiOrder` int NOT NULL DEFAULT '0', @@ -4735,7 +4757,7 @@ DROP TABLE IF EXISTS `item_context_picker_entry`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_context_picker_entry` ( `ID` int unsigned NOT NULL DEFAULT '0', - `ItemCreationContext` tinyint unsigned NOT NULL DEFAULT '0', + `ItemCreationContext` tinyint NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', `PVal` int NOT NULL DEFAULT '0', `LabelID` int NOT NULL DEFAULT '0', @@ -5190,6 +5212,7 @@ CREATE TABLE `item_search_name` ( `Flags2` int NOT NULL DEFAULT '0', `Flags3` int NOT NULL DEFAULT '0', `Flags4` int NOT NULL DEFAULT '0', + `Flags5` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5346,6 +5369,16 @@ CREATE TABLE `item_sparse` ( `StatPercentEditor8` int NOT NULL DEFAULT '0', `StatPercentEditor9` int NOT NULL DEFAULT '0', `StatPercentEditor10` int NOT NULL DEFAULT '0', + `StatModifierBonusStat1` int NOT NULL DEFAULT '0', + `StatModifierBonusStat2` int NOT NULL DEFAULT '0', + `StatModifierBonusStat3` int NOT NULL DEFAULT '0', + `StatModifierBonusStat4` int NOT NULL DEFAULT '0', + `StatModifierBonusStat5` int NOT NULL DEFAULT '0', + `StatModifierBonusStat6` int NOT NULL DEFAULT '0', + `StatModifierBonusStat7` int NOT NULL DEFAULT '0', + `StatModifierBonusStat8` int NOT NULL DEFAULT '0', + `StatModifierBonusStat9` int NOT NULL DEFAULT '0', + `StatModifierBonusStat10` int NOT NULL DEFAULT '0', `Stackable` int NOT NULL DEFAULT '0', `MaxCount` int NOT NULL DEFAULT '0', `MinReputation` int NOT NULL DEFAULT '0', @@ -5359,6 +5392,7 @@ CREATE TABLE `item_sparse` ( `Flags2` int NOT NULL DEFAULT '0', `Flags3` int NOT NULL DEFAULT '0', `Flags4` int NOT NULL DEFAULT '0', + `Flags5` int NOT NULL DEFAULT '0', `FactionRelated` int NOT NULL DEFAULT '0', `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', @@ -5392,16 +5426,6 @@ CREATE TABLE `item_sparse` ( `PageMaterialID` tinyint unsigned NOT NULL DEFAULT '0', `Bonding` tinyint unsigned NOT NULL DEFAULT '0', `DamageDamageType` tinyint unsigned NOT NULL DEFAULT '0', - `StatModifierBonusStat1` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat2` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat3` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat4` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat5` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat6` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat7` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat8` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat9` tinyint NOT NULL DEFAULT '0', - `StatModifierBonusStat10` tinyint NOT NULL DEFAULT '0', `ContainerSlots` tinyint unsigned NOT NULL DEFAULT '0', `RequiredPVPMedal` tinyint unsigned NOT NULL DEFAULT '0', `RequiredPVPRank` tinyint unsigned NOT NULL DEFAULT '0', @@ -5684,6 +5708,7 @@ DROP TABLE IF EXISTS `journal_tier`; CREATE TABLE `journal_tier` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Expansion` int NOT NULL DEFAULT '0', `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6039,6 +6064,26 @@ CREATE TABLE `liquid_type` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `location` +-- + +DROP TABLE IF EXISTS `location`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `location` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PosX` float NOT NULL DEFAULT '0', + `PosY` float NOT NULL DEFAULT '0', + `PosZ` float NOT NULL DEFAULT '0', + `Rot1` float NOT NULL DEFAULT '0', + `Rot2` float NOT NULL DEFAULT '0', + `Rot3` float NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `lock` -- @@ -6161,6 +6206,7 @@ CREATE TABLE `map` ( `ZmpFileDataID` int NOT NULL DEFAULT '0', `WdtFileDataID` int NOT NULL DEFAULT '0', `NavigationMaxDistance` int NOT NULL DEFAULT '0', + `PreloadFileDataID` int NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `Flags3` int NOT NULL DEFAULT '0', @@ -6232,10 +6278,11 @@ CREATE TABLE `map_difficulty` ( `LockID` int NOT NULL DEFAULT '0', `ResetInterval` tinyint NOT NULL DEFAULT '0', `MaxPlayers` int NOT NULL DEFAULT '0', - `ItemContext` int NOT NULL DEFAULT '0', + `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', `ItemContextPickerID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', + `WorldStateExpressionID` int NOT NULL DEFAULT '0', `MapID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6488,6 +6535,7 @@ CREATE TABLE `mount_x_display` ( `ID` int unsigned NOT NULL DEFAULT '0', `CreatureDisplayInfoID` int NOT NULL DEFAULT '0', `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', + `Unknown1100` smallint unsigned NOT NULL DEFAULT '0', `MountID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6523,6 +6571,7 @@ DROP TABLE IF EXISTS `mythic_plus_season`; CREATE TABLE `mythic_plus_season` ( `ID` int unsigned NOT NULL DEFAULT '0', `MilestoneSeason` int NOT NULL DEFAULT '0', + `StartTimeEvent` int NOT NULL DEFAULT '0', `ExpansionLevel` int NOT NULL DEFAULT '0', `HeroicLFGDungeonMinGear` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -6654,6 +6703,61 @@ CREATE TABLE `paragon_reputation` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `path` +-- + +DROP TABLE IF EXISTS `path`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `path` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Type` tinyint unsigned NOT NULL DEFAULT '0', + `SplineType` tinyint unsigned NOT NULL DEFAULT '0', + `Red` tinyint unsigned NOT NULL DEFAULT '0', + `Green` tinyint unsigned NOT NULL DEFAULT '0', + `Blue` tinyint unsigned NOT NULL DEFAULT '0', + `Alpha` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `path_node` +-- + +DROP TABLE IF EXISTS `path_node`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `path_node` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PathID` smallint unsigned NOT NULL DEFAULT '0', + `Sequence` smallint NOT NULL DEFAULT '0', + `LocationID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `path_property` +-- + +DROP TABLE IF EXISTS `path_property`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `path_property` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PathID` smallint unsigned NOT NULL DEFAULT '0', + `PropertyIndex` tinyint unsigned NOT NULL DEFAULT '0', + `Value` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `phase` -- @@ -6739,7 +6843,7 @@ CREATE TABLE `player_condition` ( `ChrSpecializationRole` tinyint NOT NULL DEFAULT '0', `ModifierTreeID` int unsigned NOT NULL DEFAULT '0', `PowerType` tinyint NOT NULL DEFAULT '0', - `PowerTypeComp` tinyint unsigned NOT NULL DEFAULT '0', + `PowerTypeComp` tinyint NOT NULL DEFAULT '0', `PowerTypeValue` tinyint unsigned NOT NULL DEFAULT '0', `WeaponSubclassMask` int NOT NULL DEFAULT '0', `MaxGuildLevel` tinyint unsigned NOT NULL DEFAULT '0', @@ -6895,7 +6999,7 @@ DROP TABLE IF EXISTS `power_display`; CREATE TABLE `power_display` ( `ID` int unsigned NOT NULL DEFAULT '0', `GlobalStringBaseTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `ActualType` tinyint unsigned NOT NULL DEFAULT '0', + `ActualType` tinyint NOT NULL DEFAULT '0', `Red` tinyint unsigned NOT NULL DEFAULT '0', `Green` tinyint unsigned NOT NULL DEFAULT '0', `Blue` tinyint unsigned NOT NULL DEFAULT '0', @@ -6924,7 +7028,7 @@ CREATE TABLE `power_type` ( `RegenInterruptTimeMS` int NOT NULL DEFAULT '0', `RegenPeace` float NOT NULL DEFAULT '0', `RegenCombat` float NOT NULL DEFAULT '0', - `Flags` smallint NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7342,6 +7446,7 @@ CREATE TABLE `quest_sort` ( `ID` int unsigned NOT NULL DEFAULT '0', `SortName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `UiOrderIndex` tinyint NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7570,9 +7675,9 @@ DROP TABLE IF EXISTS `scenario_step`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `scenario_step` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `ScenarioID` smallint unsigned NOT NULL DEFAULT '0', `Criteriatreeid` int unsigned NOT NULL DEFAULT '0', `RewardQuestID` int NOT NULL DEFAULT '0', @@ -7741,7 +7846,7 @@ CREATE TABLE `skill_line` ( `CanLink` tinyint NOT NULL DEFAULT '0', `ParentSkillLineID` int unsigned NOT NULL DEFAULT '0', `ParentTierIndex` int NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `SpellBookSpellID` int NOT NULL DEFAULT '0', `ExpansionNameSharedStringID` int NOT NULL DEFAULT '0', `HordeExpansionNameSharedStringID` int NOT NULL DEFAULT '0', @@ -7767,7 +7872,7 @@ CREATE TABLE `skill_line_ability` ( `MinSkillLineRank` smallint NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', `SupercedesSpell` int NOT NULL DEFAULT '0', - `AcquireMethod` tinyint NOT NULL DEFAULT '0', + `AcquireMethod` int NOT NULL DEFAULT '0', `TrivialSkillLineRankHigh` smallint NOT NULL DEFAULT '0', `TrivialSkillLineRankLow` smallint NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -7867,8 +7972,8 @@ CREATE TABLE `skill_race_class_info` ( `RaceMask` bigint NOT NULL DEFAULT '0', `SkillID` smallint NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', - `Availability` tinyint NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `Availability` int NOT NULL DEFAULT '0', `MinLevel` tinyint NOT NULL DEFAULT '0', `SkillTierID` smallint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -8379,6 +8484,7 @@ CREATE TABLE `spell_item_enchantment` ( `EffectArg1` int unsigned NOT NULL DEFAULT '0', `EffectArg2` int unsigned NOT NULL DEFAULT '0', `EffectArg3` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `EffectScalingPoints1` float NOT NULL DEFAULT '0', `EffectScalingPoints2` float NOT NULL DEFAULT '0', `EffectScalingPoints3` float NOT NULL DEFAULT '0', @@ -8391,7 +8497,6 @@ CREATE TABLE `spell_item_enchantment` ( `EffectPointsMin2` smallint NOT NULL DEFAULT '0', `EffectPointsMin3` smallint NOT NULL DEFAULT '0', `ItemVisual` smallint unsigned NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', `RequiredSkillID` smallint unsigned NOT NULL DEFAULT '0', `RequiredSkillRank` smallint unsigned NOT NULL DEFAULT '0', `ItemLevel` smallint unsigned NOT NULL DEFAULT '0', @@ -8579,6 +8684,7 @@ CREATE TABLE `spell_misc` ( `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', `CastingTimeIndex` smallint unsigned NOT NULL DEFAULT '0', `DurationIndex` smallint unsigned NOT NULL DEFAULT '0', + `PvPDurationIndex` smallint unsigned NOT NULL DEFAULT '0', `RangeIndex` smallint unsigned NOT NULL DEFAULT '0', `SchoolMask` tinyint unsigned NOT NULL DEFAULT '0', `Speed` float NOT NULL DEFAULT '0', @@ -8903,9 +9009,6 @@ CREATE TABLE `spell_shapeshift_form` ( `CombatRoundTime` smallint NOT NULL DEFAULT '0', `DamageVariance` float NOT NULL DEFAULT '0', `MountTypeID` smallint unsigned NOT NULL DEFAULT '0', - `CreatureDisplayID2` int unsigned NOT NULL DEFAULT '0', - `CreatureDisplayID3` int unsigned NOT NULL DEFAULT '0', - `CreatureDisplayID4` int unsigned NOT NULL DEFAULT '0', `PresetSpellID1` int unsigned NOT NULL DEFAULT '0', `PresetSpellID2` int unsigned NOT NULL DEFAULT '0', `PresetSpellID3` int unsigned NOT NULL DEFAULT '0', @@ -9045,6 +9148,7 @@ CREATE TABLE `spell_visual_effect_name` ( `DissolveEffectID` int NOT NULL DEFAULT '0', `ModelPosition` int NOT NULL DEFAULT '0', `Unknown901` tinyint NOT NULL DEFAULT '0', + `Unknown1100` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9059,7 +9163,7 @@ DROP TABLE IF EXISTS `spell_visual_kit`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_visual_kit` ( `ID` int unsigned NOT NULL DEFAULT '0', - `FallbackPriority` tinyint NOT NULL DEFAULT '0', + `ClutterLevel` int NOT NULL DEFAULT '0', `FallbackSpellVisualKitId` int NOT NULL DEFAULT '0', `DelayMin` smallint unsigned NOT NULL DEFAULT '0', `DelayMax` smallint unsigned NOT NULL DEFAULT '0', @@ -9097,8 +9201,9 @@ CREATE TABLE `spell_visual_missile` ( `Flags` int unsigned NOT NULL DEFAULT '0', `SpellMissileMotionID` smallint unsigned NOT NULL DEFAULT '0', `AnimKitID` int unsigned NOT NULL DEFAULT '0', - `ClutterLevel` tinyint NOT NULL DEFAULT '0', + `ClutterLevel` int NOT NULL DEFAULT '0', `DecayTimeAfterImpact` int NOT NULL DEFAULT '0', + `Unused1100` smallint unsigned NOT NULL DEFAULT '0', `SpellVisualMissileSetID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9439,12 +9544,14 @@ CREATE TABLE `trait_cond` ( `SpecSetID` int NOT NULL DEFAULT '0', `TraitNodeGroupID` int NOT NULL DEFAULT '0', `TraitNodeID` int NOT NULL DEFAULT '0', + `TraitNodeEntryID` int NOT NULL DEFAULT '0', `TraitCurrencyID` int NOT NULL DEFAULT '0', `SpentAmountRequired` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `RequiredLevel` int NOT NULL DEFAULT '0', `FreeSharedStringID` int NOT NULL DEFAULT '0', `SpendMoreSharedStringID` int NOT NULL DEFAULT '0', + `TraitCondAccountElementID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9632,8 +9739,9 @@ CREATE TABLE `trait_node` ( `TraitTreeID` int NOT NULL DEFAULT '0', `PosX` int NOT NULL DEFAULT '0', `PosY` int NOT NULL DEFAULT '0', - `Type` tinyint NOT NULL DEFAULT '0', + `Type` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', + `TraitSubTreeID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9651,6 +9759,7 @@ CREATE TABLE `trait_node_entry` ( `TraitDefinitionID` int NOT NULL DEFAULT '0', `MaxRanks` int NOT NULL DEFAULT '0', `NodeEntryType` tinyint unsigned NOT NULL DEFAULT '0', + `TraitSubTreeID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9666,7 +9775,7 @@ DROP TABLE IF EXISTS `trait_node_entry_x_trait_cond`; CREATE TABLE `trait_node_entry_x_trait_cond` ( `ID` int unsigned NOT NULL DEFAULT '0', `TraitCondID` int NOT NULL DEFAULT '0', - `TraitNodeEntryID` int unsigned NOT NULL DEFAULT '0', + `TraitNodeEntryID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9802,6 +9911,52 @@ CREATE TABLE `trait_node_x_trait_node_entry` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `trait_sub_tree` +-- + +DROP TABLE IF EXISTS `trait_sub_tree`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `trait_sub_tree` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `Description` text COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', + `UiTextureAtlasElementID` int NOT NULL DEFAULT '0', + `TraitTreeID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `trait_sub_tree_locale` +-- + +DROP TABLE IF EXISTS `trait_sub_tree_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `trait_sub_tree_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `Description_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `trait_tree` -- @@ -9935,15 +10090,15 @@ CREATE TABLE `transmog_set` ( `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', - `TrackingQuestID` int unsigned NOT NULL DEFAULT '0', + `TrackingQuestID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `TransmogSetGroupID` int unsigned NOT NULL DEFAULT '0', + `TransmogSetGroupID` int NOT NULL DEFAULT '0', `ItemNameDescriptionID` int NOT NULL DEFAULT '0', - `ParentTransmogSetID` smallint unsigned NOT NULL DEFAULT '0', - `Unknown810` tinyint unsigned NOT NULL DEFAULT '0', - `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0', + `ParentTransmogSetID` int NOT NULL DEFAULT '0', + `Unknown810` int NOT NULL DEFAULT '0', + `ExpansionID` int NOT NULL DEFAULT '0', `PatchID` int NOT NULL DEFAULT '0', - `UiOrder` smallint NOT NULL DEFAULT '0', + `UiOrder` int NOT NULL DEFAULT '0', `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -10098,6 +10253,8 @@ CREATE TABLE `ui_map` ( `BkgAtlasID` int NOT NULL DEFAULT '0', `AlternateUiMapGroup` int NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', + `AdventureMapTextureKitID` int NOT NULL DEFAULT '0', + `MapArtZoneTextPosition` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -10273,7 +10430,7 @@ DROP TABLE IF EXISTS `unit_condition`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `unit_condition` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `Variable1` tinyint unsigned NOT NULL DEFAULT '0', `Variable2` tinyint unsigned NOT NULL DEFAULT '0', `Variable3` tinyint unsigned NOT NULL DEFAULT '0', @@ -10282,14 +10439,14 @@ CREATE TABLE `unit_condition` ( `Variable6` tinyint unsigned NOT NULL DEFAULT '0', `Variable7` tinyint unsigned NOT NULL DEFAULT '0', `Variable8` tinyint unsigned NOT NULL DEFAULT '0', - `Op1` tinyint NOT NULL DEFAULT '0', - `Op2` tinyint NOT NULL DEFAULT '0', - `Op3` tinyint NOT NULL DEFAULT '0', - `Op4` tinyint NOT NULL DEFAULT '0', - `Op5` tinyint NOT NULL DEFAULT '0', - `Op6` tinyint NOT NULL DEFAULT '0', - `Op7` tinyint NOT NULL DEFAULT '0', - `Op8` tinyint NOT NULL DEFAULT '0', + `Op1` tinyint unsigned NOT NULL DEFAULT '0', + `Op2` tinyint unsigned NOT NULL DEFAULT '0', + `Op3` tinyint unsigned NOT NULL DEFAULT '0', + `Op4` tinyint unsigned NOT NULL DEFAULT '0', + `Op5` tinyint unsigned NOT NULL DEFAULT '0', + `Op6` tinyint unsigned NOT NULL DEFAULT '0', + `Op7` tinyint unsigned NOT NULL DEFAULT '0', + `Op8` tinyint unsigned NOT NULL DEFAULT '0', `Value1` int NOT NULL DEFAULT '0', `Value2` int NOT NULL DEFAULT '0', `Value3` int NOT NULL DEFAULT '0', @@ -10463,7 +10620,7 @@ CREATE TABLE `vehicle_seat` ( `Flags` int NOT NULL DEFAULT '0', `FlagsB` int NOT NULL DEFAULT '0', `FlagsC` int NOT NULL DEFAULT '0', - `AttachmentID` tinyint NOT NULL DEFAULT '0', + `AttachmentID` int NOT NULL DEFAULT '0', `EnterPreDelay` float NOT NULL DEFAULT '0', `EnterSpeed` float NOT NULL DEFAULT '0', `EnterGravity` float NOT NULL DEFAULT '0', @@ -10471,12 +10628,12 @@ CREATE TABLE `vehicle_seat` ( `EnterMaxDuration` float NOT NULL DEFAULT '0', `EnterMinArcHeight` float NOT NULL DEFAULT '0', `EnterMaxArcHeight` float NOT NULL DEFAULT '0', - `EnterAnimStart` int NOT NULL DEFAULT '0', - `EnterAnimLoop` int NOT NULL DEFAULT '0', - `RideAnimStart` int NOT NULL DEFAULT '0', - `RideAnimLoop` int NOT NULL DEFAULT '0', - `RideUpperAnimStart` int NOT NULL DEFAULT '0', - `RideUpperAnimLoop` int NOT NULL DEFAULT '0', + `EnterAnimStart` smallint NOT NULL DEFAULT '0', + `EnterAnimLoop` smallint NOT NULL DEFAULT '0', + `RideAnimStart` smallint NOT NULL DEFAULT '0', + `RideAnimLoop` smallint NOT NULL DEFAULT '0', + `RideUpperAnimStart` smallint NOT NULL DEFAULT '0', + `RideUpperAnimLoop` smallint NOT NULL DEFAULT '0', `ExitPreDelay` float NOT NULL DEFAULT '0', `ExitSpeed` float NOT NULL DEFAULT '0', `ExitGravity` float NOT NULL DEFAULT '0', @@ -10484,9 +10641,9 @@ CREATE TABLE `vehicle_seat` ( `ExitMaxDuration` float NOT NULL DEFAULT '0', `ExitMinArcHeight` float NOT NULL DEFAULT '0', `ExitMaxArcHeight` float NOT NULL DEFAULT '0', - `ExitAnimStart` int NOT NULL DEFAULT '0', - `ExitAnimLoop` int NOT NULL DEFAULT '0', - `ExitAnimEnd` int NOT NULL DEFAULT '0', + `ExitAnimStart` smallint NOT NULL DEFAULT '0', + `ExitAnimLoop` smallint NOT NULL DEFAULT '0', + `ExitAnimEnd` smallint NOT NULL DEFAULT '0', `VehicleEnterAnim` smallint NOT NULL DEFAULT '0', `VehicleEnterAnimBone` tinyint NOT NULL DEFAULT '0', `VehicleExitAnim` smallint NOT NULL DEFAULT '0', @@ -10533,7 +10690,7 @@ DROP TABLE IF EXISTS `vignette`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vignette` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Name` text COLLATE utf8mb4_unicode_ci, + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', `VisibleTrackingQuestID` int unsigned NOT NULL DEFAULT '0', `QuestFeedbackEffectID` int unsigned NOT NULL DEFAULT '0', @@ -10557,8 +10714,8 @@ DROP TABLE IF EXISTS `vignette_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `vignette_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name_lang` text COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -10707,4 +10864,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-05-11 3:06:58 +-- Dump completed on 2024-09-03 0:47:48 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 14d9b29da71..7793ce17634 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.39, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.36-0ubuntu0.22.04.1 +-- Server version 8.0.39-0ubuntu0.22.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -127,7 +127,6 @@ CREATE TABLE `areatrigger` ( `PhaseUseFlags` tinyint unsigned DEFAULT '0', `PhaseId` int unsigned DEFAULT '0', `PhaseGroup` int unsigned DEFAULT '0', - `SpellForVisuals` int DEFAULT NULL, `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -155,6 +154,7 @@ CREATE TABLE `areatrigger_create_properties` ( `AnimId` int NOT NULL DEFAULT '-1', `AnimKitId` int NOT NULL DEFAULT '0', `DecalPropertiesId` int unsigned NOT NULL DEFAULT '0', + `SpellForVisuals` int DEFAULT NULL, `TimeToTarget` int unsigned NOT NULL DEFAULT '0', `TimeToTargetScale` int unsigned NOT NULL DEFAULT '0', `Shape` tinyint unsigned NOT NULL DEFAULT '0', @@ -302,6 +302,8 @@ CREATE TABLE `areatrigger_template` ( `Id` int unsigned NOT NULL, `IsCustom` tinyint unsigned NOT NULL, `Flags` int unsigned NOT NULL DEFAULT '0', + `ActionSetId` int unsigned NOT NULL DEFAULT '0', + `ActionSetFlags` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`,`IsCustom`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -741,8 +743,8 @@ DROP TABLE IF EXISTS `creature_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -750,7 +752,7 @@ CREATE TABLE `creature_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1196,7 +1198,7 @@ CREATE TABLE `creature_text` ( `ID` tinyint unsigned NOT NULL DEFAULT '0', `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Type` tinyint unsigned NOT NULL DEFAULT '0', - `Language` tinyint NOT NULL DEFAULT '0', + `Language` tinyint unsigned NOT NULL DEFAULT '0', `Probability` float NOT NULL DEFAULT '0', `Emote` int unsigned NOT NULL DEFAULT '0', `Duration` int unsigned NOT NULL DEFAULT '0', @@ -1301,8 +1303,8 @@ DROP TABLE IF EXISTS `disenchant_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `disenchant_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -1310,7 +1312,7 @@ CREATE TABLE `disenchant_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1373,8 +1375,8 @@ DROP TABLE IF EXISTS `fishing_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `fishing_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -1382,7 +1384,7 @@ CREATE TABLE `fishing_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1723,8 +1725,8 @@ DROP TABLE IF EXISTS `gameobject_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -1732,7 +1734,7 @@ CREATE TABLE `gameobject_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1964,6 +1966,7 @@ DROP TABLE IF EXISTS `gossip_menu_addon`; CREATE TABLE `gossip_menu_addon` ( `MenuID` int unsigned NOT NULL DEFAULT '0', `FriendshipFactionID` int NOT NULL DEFAULT '0', + `LfgDungeonsID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`MenuID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2102,8 +2105,8 @@ DROP TABLE IF EXISTS `item_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -2111,7 +2114,7 @@ CREATE TABLE `item_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2259,8 +2262,8 @@ DROP TABLE IF EXISTS `mail_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -2268,7 +2271,7 @@ CREATE TABLE `mail_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2281,8 +2284,8 @@ DROP TABLE IF EXISTS `milling_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `milling_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -2290,7 +2293,7 @@ CREATE TABLE `milling_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2503,8 +2506,8 @@ DROP TABLE IF EXISTS `pickpocketing_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pickpocketing_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -2512,7 +2515,7 @@ CREATE TABLE `pickpocketing_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3021,8 +3024,8 @@ DROP TABLE IF EXISTS `prospecting_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prospecting_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -3030,7 +3033,7 @@ CREATE TABLE `prospecting_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3547,7 +3550,6 @@ CREATE TABLE `quest_template` ( `AreaGroupID` int unsigned NOT NULL DEFAULT '0', `TimeAllowed` bigint NOT NULL DEFAULT '0', `AllowableRaces` bigint unsigned DEFAULT '0', - `TreasurePickerID` int NOT NULL DEFAULT '0', `Expansion` int NOT NULL DEFAULT '0', `ManagedWorldStateID` int NOT NULL DEFAULT '0', `QuestSessionBonus` int NOT NULL DEFAULT '0', @@ -3560,6 +3562,7 @@ CREATE TABLE `quest_template` ( `PortraitTurnInText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PortraitTurnInName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ResetByScheduler` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System'; @@ -3620,6 +3623,21 @@ CREATE TABLE `quest_template_locale` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `quest_treasure_pickers` +-- + +DROP TABLE IF EXISTS `quest_treasure_pickers`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `quest_treasure_pickers` ( + `QuestID` int unsigned NOT NULL, + `TreasurePickerID` int NOT NULL, + `OrderIndex` int NOT NULL DEFAULT '0', + PRIMARY KEY (`QuestID`,`TreasurePickerID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `quest_visual_effect` -- @@ -3660,8 +3678,8 @@ DROP TABLE IF EXISTS `reference_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reference_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -3669,7 +3687,7 @@ CREATE TABLE `reference_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4074,8 +4092,8 @@ DROP TABLE IF EXISTS `skinning_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skinning_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -4083,7 +4101,7 @@ CREATE TABLE `skinning_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4285,8 +4303,8 @@ DROP TABLE IF EXISTS `spell_loot_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_loot_template` ( `Entry` int unsigned NOT NULL DEFAULT '0', + `ItemType` tinyint NOT NULL DEFAULT '0', `Item` int unsigned NOT NULL DEFAULT '0', - `Reference` int unsigned NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '100', `QuestRequired` tinyint(1) NOT NULL DEFAULT '0', `LootMode` smallint unsigned NOT NULL DEFAULT '1', @@ -4294,7 +4312,7 @@ CREATE TABLE `spell_loot_template` ( `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`Entry`,`Item`) + KEY `idx_primary` (`Entry`,`ItemType`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4572,6 +4590,36 @@ CREATE TABLE `trinity_string` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `ui_map_quest` +-- + +DROP TABLE IF EXISTS `ui_map_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `ui_map_quest` ( + `UiMapId` int unsigned NOT NULL, + `QuestId` int unsigned NOT NULL, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`UiMapId`,`QuestId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `ui_map_quest_line` +-- + +DROP TABLE IF EXISTS `ui_map_quest_line`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `ui_map_quest_line` ( + `UiMapId` int unsigned NOT NULL, + `QuestLineId` int unsigned NOT NULL, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`UiMapId`,`QuestLineId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `updates` -- @@ -4844,6 +4892,7 @@ CREATE TABLE `world_safe_locs` ( `LocY` float DEFAULT NULL, `LocZ` float DEFAULT NULL, `Facing` float DEFAULT NULL, + `TransportSpawnId` bigint unsigned DEFAULT NULL, `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4934,4 +4983,4 @@ CREATE TABLE `world_state` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-05-11 3:06:56 +-- Dump completed on 2024-09-03 0:47:46 -- cgit v1.2.3