diff options
Diffstat (limited to 'sql/base')
-rw-r--r-- | sql/base/auth_database.sql | 119 |
1 files changed, 118 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 6c710464b68..25b16ce36e7 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -164,6 +164,122 @@ LOCK TABLES `autobroadcast` WRITE; UNLOCK TABLES; -- +-- Table structure for table `build_info` +-- + +DROP TABLE IF EXISTS `build_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8mb4 */; +CREATE TABLE `build_info` ( + `build` int(11) NOT NULL, + `majorVersion` int(11) DEFAULT NULL, + `minorVersion` int(11) DEFAULT NULL, + `bugfixVersion` int(11) DEFAULT NULL, + `hotfixVersion` char(3) DEFAULT NULL, + `winAuthSeed` varchar(32) DEFAULT NULL, + `win64AuthSeed` varchar(32) DEFAULT NULL, + `mac64AuthSeed` varchar(32) DEFAULT NULL, + `winChecksumSeed` varchar(40) DEFAULT NULL, + `macChecksumSeed` varchar(40) DEFAULT NULL, + PRIMARY KEY (`build`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `build_info` +-- + +LOCK TABLES `build_info` WRITE; +/*!40000 ALTER TABLE `build_info` DISABLE KEYS */; +INSERT INTO `build_info` VALUES +(5875,1,12,1,NULL,NULL,NULL,NULL,'95EDB27C7823B363CBDDAB56A392E7CB73FCCA20','8D173CC381961EEBABF336F5E6675B101BB513E5'), +(6005,1,12,2,NULL,NULL,NULL,NULL,NULL,NULL), +(6141,1,12,3,NULL,NULL,NULL,NULL,NULL,NULL), +(8606,2,4,3,NULL,NULL,NULL,NULL,'319AFAA3F2559682F9FF658BE01456255F456FB1','D8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F'), +(9947,3,1,3,NULL,NULL,NULL,NULL,NULL,NULL), +(10505,3,2,2,'a',NULL,NULL,NULL,NULL,NULL), +(11159,3,3,0,'a',NULL,NULL,NULL,NULL,NULL), +(11403,3,3,2,NULL,NULL,NULL,NULL,NULL,NULL), +(11723,3,3,3,'a',NULL,NULL,NULL,NULL,NULL), +(12340,3,3,5,'a',NULL,NULL,NULL,'CDCBBD5188315E6B4D19449D492DBCFAF156A347','B706D13FF2F4018839729461E3F8A0E2B5FDC034'), +(13623,4,0,6,'a',NULL,NULL,NULL,NULL,NULL), +(13930,3,3,5,'a',NULL,NULL,NULL,NULL,NULL), +(14545,4,2,2,NULL,NULL,NULL,NULL,NULL,NULL), +(15595,4,3,4,NULL,NULL,NULL,NULL,NULL,NULL), +(19116,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(19243,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(19342,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(19702,6,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(19802,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), +(19831,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), +(19865,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL), +(20182,6,2,0,'a',NULL,NULL,NULL,NULL,NULL), +(20201,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(20216,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(20253,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(20338,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(20444,6,2,2,NULL,NULL,NULL,NULL,NULL,NULL), +(20490,6,2,2,'a',NULL,NULL,NULL,NULL,NULL), +(20574,6,2,2,'a',NULL,NULL,NULL,NULL,NULL), +(20726,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), +(20779,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), +(20886,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL), +(21355,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), +(21463,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), +(21742,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL), +(22248,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22293,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22345,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22410,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22423,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22498,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22522,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22566,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22594,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22624,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22747,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22810,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL), +(22900,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(22908,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(22950,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(22995,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(22996,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(23171,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(23222,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL), +(23360,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL), +(23420,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL), +(23911,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(23937,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(24015,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL), +(24330,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(24367,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(24415,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(24430,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(24461,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(24742,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL), +(25549,7,3,2,NULL,'FE594FC35E7F9AFF86D99D8A364AB297','1252624ED8CBD6FAC7D33F5D67A535F3','66FC5E09B8706126795F140308C8C1D8',NULL,NULL), +(25996,7,3,5,NULL,'23C59C5963CBEF5B728D13A50878DFCB','C7FF932D6A2174A3D538CA7212136D2B','210B970149D6F56CAC9BADF2AAC91E8E',NULL,NULL), +(26124,7,3,5,NULL,'F8C05AE372DECA1D6C81DA7A8D1C5C39','46DF06D0147BA67BA49AF553435E093F','C9CA997AB8EDE1C65465CB2920869C4E',NULL,NULL), +(26365,7,3,5,NULL,'2AAC82C80E829E2CA902D70CFA1A833A','59A53F307288454B419B13E694DF503C','DBE7F860276D6B400AAA86B35D51A417',NULL,NULL), +(26654,7,3,5,NULL,'FAC2D693E702B9EC9F750F17245696D8','A752640E8B99FE5B57C1320BC492895A','9234C1BD5E9687ADBD19F764F2E0E811',NULL,NULL), +(26822,7,3,5,NULL,'283E8D77ECF7060BE6347BE4EB99C7C7','2B05F6D746C0C6CC7EF79450B309E595','91003668C245D14ECD8DF094E065E06B',NULL,NULL), +(26899,7,3,5,NULL,'F462CD2FE4EA3EADF875308FDBB18C99','3551EF0028B51E92170559BD25644B03','8368EFC2021329110A16339D298200D4',NULL,NULL), +(26972,7,3,5,NULL,'797ECC19662DCBD5090A4481173F1D26','6E212DEF6A0124A3D9AD07F5E322F7AE','341CFEFE3D72ACA9A4407DC535DED66A',NULL,NULL), +(28153,8,0,1,NULL,NULL,'DD626517CC6D31932B479934CCDC0ABF',NULL,NULL,NULL), +(30706,8,1,5,NULL,NULL,'BB6D9866FE4A19A568015198783003FC',NULL,NULL,NULL), +(30993,8,2,0,NULL,NULL,'2BAD61655ABC2FC3D04893B536403A91',NULL,NULL,NULL), +(31229,8,2,0,NULL,NULL,'8A46F23670309F2AAE85C9A47276382B',NULL,NULL,NULL), +(31429,8,2,0,NULL,NULL,'7795A507AF9DC3525EFF724FEE17E70C',NULL,NULL,NULL), +(31478,8,2,0,NULL,NULL,'7973A8D54BDB8B798D9297B096E771EF',NULL,NULL,NULL), +(32305,8,2,5,NULL,NULL,'21F5A6FC7AD89FBF411FDA8B8738186A',NULL,NULL,NULL), +(32494,8,2,5,NULL,NULL,'58984ACE04919401835C61309A848F8A',NULL,NULL,NULL), +(32580,8,2,5,NULL,NULL,'87C2FAA0D7931BF016299025C0DDCA14',NULL,NULL,NULL), +(32638,8,2,5,NULL,NULL,'5D07ECE7D4A867DDDE615DAD22B76D4E',NULL,NULL,NULL), +(32722,8,2,5,NULL,NULL,'1A09BE1D38A122586B4931BECCEAD4AA',NULL,NULL,NULL); +/*!40000 ALTER TABLE `build_info` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `ip_banned` -- @@ -1836,7 +1952,8 @@ INSERT INTO `updates` VALUES ('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0), ('2019_09_15_00_auth.sql','2EEE632B5A365D45747B7BB25DE5239FB5B1A1BD','ARCHIVED','2019-09-15 09:21:36',0), ('2019_10_18_00_auth.sql','DFEDA33D7B9A108773B6AD8DE3016C6B12BD3832','ARCHIVED','2019-10-18 08:37:37',0), -('2019_11_16_00_auth.sql','A7CC55B9329F0DDFE91ADC31BFABD0D934ED0A5E','ARCHIVED','2019-11-16 12:06:06',0); +('2019_11_16_00_auth.sql','A7CC55B9329F0DDFE91ADC31BFABD0D934ED0A5E','ARCHIVED','2019-11-16 12:06:06',0), +('2019_12_07_00_auth.sql','F354DA31D5B300609C6AE8A25667CA4DE0A7349F','RELEASED','2019-12-07 12:57:23',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |