-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: -- Erstellungszeit: 14. Jul 2021 um 15:50 -- Server-Version: 5.7.30-33-log -- PHP-Version: 5.6.40 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Datenbank: `db_412216_1` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `graderatings` -- CREATE TABLE `graderatings` ( `i` int(15) NOT NULL, `id` int(10) NOT NULL, `username` varchar(15) NOT NULL, `grade` varchar(3) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten für Tabelle `graderatings` -- INSERT INTO `graderatings` (`i`, `id`, `username`, `grade`) VALUES (86, 79, 'Thomas Bauer', '5c'), (85, 78, 'Thomas Bauer', '5b'), (84, 77, 'Thomas Bauer', '5b'), (79, 76, 'thomas', '4b'), (76, 73, 'famann', '4b'), (75, 72, 'famann', '4c'), (74, 71, 'famann', '4c'), (73, 68, 'famann', '5b'), (72, 68, 'consti', '5a'), (71, 67, 'consti', '4c'), (66, 69, 'jakobamann', '5c'), (67, 70, 'jakobamann', '5a'), (68, 67, 'jakobamann', '4c'), (69, 68, 'jakobamann', '5a'), (70, 69, 'consti', '5c'), (87, 83, 'Thomas Bauer', '5c'), (88, 84, 'Thomas Bauer', '5c'), (89, 85, 'consti', '5b'), (90, 86, 'consti', '5a'), (91, 87, 'famann', '5b'), (101, 94, 'consti', '3b'), (93, 89, 'famann', '4a'), (94, 90, 'famann', '4b'), (95, 84, 'famann', '5b'), (99, 92, 'thomas', '5a'), (102, 86, 'famann', '4c'), (120, 108, 'famann', '6a'), (103, 95, 'famann', '5a'), (104, 96, 'famann', '5b'), (105, 97, 'famann', '5c'), (106, 83, 'famann', '6b'), (107, 98, 'famann', '6a'), (108, 99, 'famann', '5c'), (109, 100, 'famann', '5c'), (110, 101, 'famann', '5c'), (111, 102, 'famann', '5c'), (113, 90, 'consti', '4b'), (114, 104, 'consti', '5b'), (115, 105, 'consti', '5b'), (116, 105, 'famann', '5b'), (117, 78, 'famann', '5a'), (118, 106, 'famann', '5b'), (119, 107, 'famann', '5b'), (121, 109, 'famann', '6a'), (128, 114, 'consti', '5c'), (127, 107, 'test', '5a'), (126, 95, 'test', '4c'), (129, 115, 'famann', '5b'), (130, 116, 'famann', '5c'), (131, 117, 'famann', '5c'), (132, 102, 'test', '5c'), (133, 118, 'test', '4b'), (134, 119, 'consti', '4c'), (135, 120, 'consti', '5b'), (136, 117, 'consti', '5c'), (137, 121, 'consti', '5c'), (138, 121, 'famann', '5c'), (139, 122, 'famann', '5c'), (140, 123, 'famann', '5a'), (141, 124, 'famann', '5b'), (142, 125, 'famann', '5c'), (143, 126, 'famann', '5c'), (144, 127, 'famann', '6b'), (145, 128, 'Luigi', '5c'), (146, 129, 'Luigi', '6a'), (147, 130, 'consti', '5c'), (148, 131, 'Luigi', '6b'), (149, 132, 'Luigi', '5b'), (150, 133, 'consti', '5a'), (151, 134, 'consti', '5a'), (152, 135, 'consti', '5b'), (153, 136, 'consti', '5c'), (154, 137, 'consti', '5b'), (155, 138, 'consti', '5b'), (156, 139, 'consti', '5b'), (157, 140, 'consti', '5c'), (158, 141, 'famann', '6a'), (159, 142, 'famann', '5a'), (160, 143, 'famann', '5a'), (161, 144, 'famann', '6a'), (162, 145, 'famann', '6a'), (163, 146, 'famann', '6a'), (164, 147, 'famann', '4a'), (165, 148, 'famann', '4c'), (166, 149, 'famann', '5a'), (167, 150, 'famann', '5b'), (168, 151, 'famann', '5b'), (169, 152, 'consti', '5a'), (170, 153, 'consti', '5a'), (171, 154, 'consti', '5b'), (172, 155, 'consti', '5c'), (173, 156, 'consti', '5b'), (174, 157, 'Luigi', '6a'), (175, 158, 'Luigi', '6c'), (176, 159, 'consti', '4c'), (177, 160, 'consti', '5c'), (178, 161, 'consti', '5b'), (179, 162, 'consti', '5b'), (180, 119, 'famann', '4b'), (181, 159, 'famann', '5b'), (182, 77, 'famann', '6a'), (183, 163, 'famann', '4a'), (184, 164, 'famann', '4b'), (185, 165, 'famann', '4b'), (186, 166, 'famann', '5c'), (187, 167, 'consti', '5a'), (188, 168, 'consti', '6a'), (189, 169, 'Luigi', '5b'), (190, 124, 'consti', '5a'), (191, 170, 'famann', '5a'), (192, 171, 'famann', '5c'), (193, 172, 'famann', '5b'), (194, 173, 'famann', '6a'), (195, 174, 'famann', '5b'), (196, 175, 'famann', '5b'), (197, 176, 'famann', '5c'), (198, 177, 'famann', '5c'), (199, 178, 'consti', '5a'), (200, 179, 'Thomas Bauer ', '5a'), (201, 180, 'Thomas Bauer ', '6a'), (202, 181, 'Thomas Bauer ', '6b'), (203, 182, 'Thomas Bauer ', '6b'), (204, 183, 'Thomas Bauer ', '5c'), (205, 184, 'Thomas Bauer ', '6b'), (206, 185, 'consti', '5b'), (207, 186, 'Luigi', '5b'), (208, 187, 'Luigi', '5b'), (209, 188, 'consti', '5c'), (210, 189, 'Luigi', '6a'), (211, 190, 'Luigi', '6c'), (212, 133, 'famann', '5b'), (213, 104, 'famann', '5c'), (214, 191, 'famann', '5a'), (215, 128, 'famann', '5c'), (216, 155, 'famann', '5c'), (217, 142, 'Karl Bauer', '4c'), (218, 192, 'famann', '5b'), (219, 193, 'famann', '4a'), (220, 194, 'famann', '6a'), (221, 195, 'famann', '5c'), (222, 196, 'famann', '5c'), (223, 197, 'famann', '4b'), (224, 198, 'famann', '4b'), (225, 199, 'consti', '6b'), (226, 138, 'famann', '5c'), (227, 185, 'famann', '5b'), (228, 156, 'famann', '5b'), (229, 152, 'famann', '5b'), (230, 200, 'consti', '4b'), (231, 201, 'famann', '5c'), (232, 202, 'famann', '5b'), (233, 203, 'famann', '4c'), (234, 204, 'famann', '4b'), (235, 205, 'famann', '4a'), (236, 206, 'famann', '5c'), (237, 186, 'famann', '5b'), (238, 207, 'Thomas Bauer ', '5b'), (239, 208, 'Thomas Bauer ', '5c'), (240, 209, 'Thomas Bauer ', '5c'), (241, 210, 'Thomas Bauer ', '6a'), (242, 211, 'Thomas Bauer ', '5a'), (243, 212, 'Luigi', '6a'), (244, 213, 'Luigi', '5c'), (245, 214, 'Luigi', '6a'), (246, 215, 'Luigi', '6a'), (247, 214, 'famann', '6b'), (248, 160, 'Karl Bauer', '5b'), (249, 216, 'famann', '5a'), (250, 217, 'consti', '4c'), (251, 218, 'famann', '5c'), (252, 219, 'consti', '5c'), (253, 220, 'Luigi', '6a'), (254, 221, 'Luigi', '6b'), (255, 222, 'Luigi', '6a'), (256, 223, 'famann', '6a'), (257, 224, 'famann', '4a'), (258, 225, 'famann', '3b'), (259, 226, 'famann', '3b'), (260, 227, 'famann', '4c'), (261, 228, 'famann', '5b'), (262, 229, 'famann', '6a'), (263, 230, 'famann', '3b'), (264, 231, 'famann', '4a'), (265, 232, 'famann', '4a'), (266, 233, 'famann', '4b'), (267, 234, 'famann', '4b'), (268, 235, 'famann', '5a'), (269, 236, 'famann', '3a'), (270, 237, 'famann', '4a'), (271, 238, 'famann', '4b'), (272, 239, 'famann', '3a'), (273, 240, 'famann', '3a'), (274, 241, 'famann', '4a'), (275, 242, 'famann', '3b'), (276, 243, 'famann', '4a'), (277, 244, 'famann', '4b'), (278, 245, 'famann', '4c'), (279, 246, 'famann', '3a'), (280, 247, 'famann', '3a'), (281, 248, 'famann', '4a'), (282, 249, 'famann', '4b'), (283, 250, 'famann', '5a'), (284, 251, 'famann', '5a'), (285, 252, 'famann', '5b'), (286, 253, 'famann', '4a'), (287, 217, 'famann', '5a'), (288, 254, 'famann', '4b'), (289, 255, 'famann', '4c'), (290, 256, 'famann', '3b'), (291, 257, 'famann', '3b'), (292, 258, 'famann', '3a'), (293, 259, 'famann', '5a'), (294, 260, 'famann', '4c'), (295, 261, 'famann', '4c'), (296, 262, 'famann', '4b'), (297, 263, 'famann', '5a'), (298, 264, 'famann', '4b'), (299, 265, 'famann', '3c'), (300, 160, 'famann', '5c'), (301, 266, 'Luigi', '6b'), (302, 267, 'Luigi', '6c'), (303, 268, 'Luigi', '6b+'), (304, 269, 'famann', '5c+'), (305, 270, 'famann', '5c'), (306, 271, 'famann', '3c'), (307, 272, 'famann', '4b'), (308, 273, 'famann', '4c'), (309, 274, 'famann', '5a'), (310, 275, 'famann', '4c'), (311, 276, 'famann', '5a'), (312, 277, 'famann', '5b'), (313, 278, 'famann', '5b+'), (314, 279, 'famann', '5a+'), (315, 280, 'famann', '5a+'), (316, 281, 'famann', '5b'), (317, 282, 'famann', '5b'), (318, 283, 'famann', '5b'), (319, 284, 'consti', '4b'), (320, 285, 'consti', '5c+'), (321, 286, 'consti', '6a+'), (322, 287, 'luigi', '6a'), (323, 288, 'Michi', '6a'), (324, 289, 'Michi', '4a'), (325, 290, 'Michi', '3b'), (326, 291, 'Michi', '3c'), (327, 292, 'Michi', '4b'), (328, 293, 'Michi', '4b'), (329, 294, 'Michi', '4c'), (330, 295, 'Michi', '5a'), (331, 296, 'Michi', '5b'), (332, 297, 'Michi', '5c'), (333, 298, 'Michi', '6b'), (334, 299, 'Michi', '5a'), (335, 300, 'Michi', '5c+'), (336, 301, 'Michi', '6b'), (337, 149, 'Michi', '5a'), (338, 227, 'Michi', '4c'), (339, 179, 'Michi', '5a'), (340, 161, 'Michi', '6a'), (341, 145, 'Michi', '6a'), (342, 302, 'Michi', '5c'), (343, 181, 'Michi', '6b'), (344, 303, 'Michi', '6b'), (345, 304, 'Michi', '6a+'), (346, 305, 'Michi', '6b'), (347, 134, 'Michi', '5b'), (348, 130, 'Michi', '5c'), (349, 182, 'Michi', '6b'), (350, 189, 'Michi', '6a+'), (351, 173, 'Michi', '6a'), (352, 306, 'Michi', '6a+'), (353, 307, 'Michi', '6a+'), (354, 308, 'Michi', '6a'), (355, 187, 'Michi', '5c'), (356, 309, 'Michi', '5a'), (357, 310, 'Michi', '5a'), (358, 311, 'Michi', '5b'), (359, 312, 'Michi', '5a+'), (360, 313, 'Michi', '5b+'), (361, 314, 'Michi', '5b'), (362, 315, 'Michi', '5b+'), (363, 316, 'Michi', '5c'), (364, 150, 'consti', '5b+'), (365, 121, 'famann', '5c'), (366, 317, 'famann', '3c'), (367, 318, 'famann', '4b'), (368, 319, 'famann', '5b'), (369, 320, 'famann', '5b+'), (370, 78, 'famann', '5b'), (371, 321, 'famann', '5c'), (372, 322, 'famann', '6b'), (373, 323, 'famann', '5b+'), (374, 324, 'famann', '5b+'), (375, 325, 'famann', '5c'), (376, 305, 'famann', '6a+'), (377, 326, 'famann', '6a'), (378, 327, 'famann', '4c'), (379, 328, 'famann', '5b'), (380, 329, 'famann', '5b'), (381, 330, 'famann', '5a'), (382, 331, 'famann', '5b+'), (383, 160, 'famann', '5c'), (384, 332, 'famann', '5b+'), (385, 333, 'famann', '6b'), (386, 267, 'Michi', '6c'), (387, 334, 'famann', '6a+'), (388, 158, 'Michi', '6c'), (389, 335, 'famann', '7a'), (390, 336, 'famann', '4b'), (391, 337, 'famann', '4c'), (392, 338, 'famann', '4b'), (393, 339, 'famann', '4b'), (394, 340, 'famann', '4c'), (395, 341, 'famann', '5a'), (396, 100, 'Michi', '5b'), (397, 97, 'Michi', '5c'), (398, 146, 'Michi', '6a'), (399, 184, 'Michi', '6b'), (400, 84, 'Michi', '6a'), (401, 141, 'Michi', '6b'), (402, 342, 'Thomas Bauer ', '6a'), (403, 343, 'Thomas Bauer ', '6b'), (404, 344, 'Thomas Bauer ', '6b'), (405, 98, 'Michi', '6a'), (406, 342, 'famann', '6a'), (407, 343, 'Michi', '6a+'), (408, 141, 'famann', '6b'), (409, 345, 'famann', '5c'), (410, 288, 'famann', '6a+'), (411, 344, 'Michi', '6b'), (412, 346, 'famann', '5a'), (413, 347, 'famann', '5c'), (414, 348, 'famann', '6a+'), (415, 349, 'famann', '6a'), (416, 350, 'famann', '5b+'), (417, 307, 'famann', '6b+'), (418, 307, 'famann', '6b'), (419, 351, 'famann', '6b+'), (420, 352, 'famann', '7a'), (421, 353, 'famann', '5c'), (422, 354, 'famann', '6b'), (423, 355, 'famann', '4a'), (424, 356, 'famann', '5b+'), (425, 357, 'famann', '6a+'), (426, 358, 'famann', '5a'), (427, 359, 'famann', '5b'), (428, 360, 'famann', '5c'), (429, 361, 'famann', '5b'), (430, 362, 'famann', '5a+'), (431, 363, 'famann', '5c'), (432, 364, 'famann', '5b'), (433, 365, 'famann', '5b+'), (434, 366, 'famann', '5b+'), (435, 367, 'famann', '6a+'), (436, 368, 'famann', '6c+'), (437, 369, 'famann', '5b+'), (438, 370, 'Michi', '6b+'), (439, 371, 'famann', '5c'), (440, 372, 'famann', '6a'), (441, 373, 'Michi', '6b+'), (442, 374, 'famann', '5c+'), (443, 375, 'famann', '5c'), (444, 376, 'famann', '5a+'), (445, 377, 'famann', '5c'), (446, 378, 'famann', '5c'), (447, 379, 'famann', '5c'), (448, 380, 'famann', '5a+'), (449, 381, 'famann', '5c+'), (450, 382, 'famann', '4c'), (451, 383, 'famann', '6a'), (452, 384, 'famann', '5a+'), (453, 385, 'famann', '5a+'), (454, 386, 'famann', '3c'), (455, 387, 'famann', '5a'), (456, 388, 'famann', '5b'), (457, 208, 'consti', '5c+'), (458, 361, 'consti', '5a'), (459, 321, 'consti', '5c'), (460, 125, 'consti', '5c'), (461, 263, 'consti', '5a+'), (462, 207, 'consti', '5b'), (463, 389, 'famann', '5b+'), (464, 390, 'famann', '6a+'), (465, 391, 'famann', '6b'), (466, 392, 'famann', '5b'), (467, 393, 'famann', '5c+'), (468, 394, 'famann', '5b+'), (469, 395, 'famann', '5b+'), (470, 396, 'Michi', '6a+'), (471, 397, 'famann', '5a+'), (472, 398, 'famann', '4b'), (473, 399, 'famann', '5a+'), (474, 400, 'famann', '5a+'), (475, 401, 'famann', '5b'), (476, 402, 'famann', '5b+'), (477, 403, 'famann', '5c'), (478, 359, 'Michi', '5a'), (479, 404, 'famann', '6a'), (480, 405, 'Michi', '6b'), (481, 406, 'famann', '5c+'), (482, 220, 'Michi', '6a+'), (483, 358, 'Michi', '5a'), (484, 282, 'Michi', '5b'), (485, 407, 'famann', '5c+'), (486, 408, 'famann', '5c+'), (487, 409, 'Michi', '6b'), (488, 410, 'famann', '6a'), (489, 411, 'famann', '6a+'), (490, 412, 'famann', '6a+'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `probs` -- CREATE TABLE `probs` ( `id` int(10) NOT NULL, `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `grade` varchar(3) COLLATE utf8_unicode_ci NOT NULL, `time` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `angle` float NOT NULL, `moves` text COLLATE utf8_unicode_ci NOT NULL, `feet` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(25) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Daten für Tabelle `probs` -- INSERT INTO `probs` (`id`, `name`, `grade`, `time`, `angle`, `moves`, `feet`, `author`) VALUES (67, 'Jakobs First - with nine years', '4c', '30.01.2021', 15, 'G2/D2/D3/C4/F6/G10/I10/L11/N11', NULL, 'famann'), (68, 'Kinderpower', '5a', '30.01.2021', 15, 'N1+K2/M5/J7/J8/G8/E9/C9/A11', NULL, 'famann'), (69, 'Schweeer', '5c', '30.01.2021', 15, 'G1+K2/K4/L5/K7/I9/F8/E7/B8/A11', NULL, 'jakobamann'), (71, 'Henkelhangel', '4c', '31.01.2021', 15, 'I1+K2/J4/H6/F6/D7/B9/A11', NULL, 'famann'), (72, 'Weite Züge', '4c', '31.01.2021', 15, 'B1+D2/C4/F6/G10/J10/L11/N10', NULL, 'famann'), (73, 'Nicht ohne aufwärmen! ', '4b', '31.01.2021', 15, 'A3+D2/C5/D7/E10/G10/I11/K11', NULL, 'famann'), (77, 'First Love', '5c', '01.02.2021', 30, 'I3+N3/J8/D10/C11/A11', NULL, 'Thomas Bauer'), (78, 'Try hard', '5a+', '01.02.2021', 30, 'I1+G2/I6/D8/H10/H11/M11', NULL, 'Thomas Bauer'), (79, 'Try harder ', '5c', '01.02.2021', 30, 'A1+E3/C8/H10/H11/M11', NULL, 'Thomas Bauer'), (83, 'Turn right', '6a', '02.02.2021', 30, 'B3+F3/E7/D8/I9/J9/N11', NULL, 'Thomas Bauer'), (84, 'Turn left', '5c', '02.02.2021', 30, 'F2+G4/J7/L9/L10/H10/F11/A11', NULL, 'Thomas Bauer'), (85, 'Cross Your Arms', '5b', '02.02.2021', 15, 'G2+I3/J7/M9/I11/E10/C11', NULL, 'consti'), (86, 'Snake', '5a', '02.02.2021', 15, 'J4+N4/H7/F6/E5/C6/B9/C11', NULL, 'consti'), (87, 'Shorty', '5c', '02.02.2021', 15, 'I3+N3/J8/D10/C11/A11', NULL, 'famann'), (89, 'Kathis First', '4a', '02.02.2021', 15, 'F1+H4/K7/F6/J10/M11', NULL, 'famann'), (90, 'Asterix der Gallier', '4b', '02.02.2021', 15, 'G2+H4/H6/H8/J10/N11', NULL, 'famann'), (94, 'Davids kurzer Boulder', '3b', '03.02.2021', 15, 'H5+F6/D7/C8/C10/B11', NULL, 'consti'), (95, 'Der strenge Thomas', '5a', '03.02.2021', 15, 'N4+J4/H7/B9/A11', NULL, 'famann'), (96, 'Secret', '5b', '03.02.2021', 15, 'N3+L3/J7/I6/E7/D8/A11', NULL, 'famann'), (97, 'Harter 5c', '5c', '03.02.2021', 15, 'N5+L3/J7/I6/E7/C9/C11', NULL, 'famann'), (98, 'Schweizer Käse', '6a', '04.02.2021', 30, 'E3+J3/E5/C8/F9/F11/L11/N11', NULL, 'famann'), (99, 'Nicht ohne!', '5c', '04.02.2021', 15, 'N3+I2/G4/G5/D8/H10/K11', NULL, 'famann'), (100, 'Endlich wieder Sonne!', '5b+', '04.02.2021', 15, 'D2+A4/G5/G8/J8/J9/N11', NULL, 'famann'), (101, 'Lockdown!', '5c', '04.02.2021', 15, 'I3+F3/H4/H6/C7/C9/A11', NULL, 'famann'), (102, 'Finger wie immer nur am Sandpapier!!!', '5c', '04.02.2021', 15, 'K2+I3/H5/G6/E7/G9/F11', NULL, 'famann'), (104, 'Coding Headache', '5c', '05.02.2021', 15, 'D3+A4/C7/G7/J8/M11', NULL, 'consti'), (105, 'Schneemangel', '5b', '05.02.2021', 15, 'G2+J2/M5/L8/I9/E8/C11', NULL, 'consti'), (106, 'Hufeisen ', '5b', '05.02.2021', 15, 'M1+N2/M5/N9/K11/J11/H10/D10/B9/C7/A7/B4', NULL, 'famann'), (107, 'Für Kinder leichter', '5a', '05.02.2021', 15, 'M1+N2/M6/N10/K11/G10/C10/A11', NULL, 'famann'), (108, 'Leistenbruch ', '6a', '06.02.2021', 30, 'E3+G2/G6/C7/C9/A11', NULL, 'famann'), (109, 'Crossroads', '6a', '06.02.2021', 30, 'D1+B4/G5/F8/J8/J9/N11', NULL, 'famann'), (114, 'Sativa', '5c', '08.02.2021', 15, 'J2+H2/E5/C6/F8/I8/J9/M11', NULL, 'consti'), (115, 'Jeder Griff ist Pflicht!', '5b', '09.02.2021', 15, 'B4+C4/A7/B9/C11/F9/H11/K11/L9/N7/M6/L4/J4/H4/E3', NULL, 'famann'), (116, 'Jeder Griff ist Pflicht. Anders rum.', '5c', '09.02.2021', 15, 'E3/H4/J4/L4/M6/N7/M9/K11/H11/F9/C11/B9/B7/C7/B4/C4/A7/C4', NULL, 'famann'), (117, 'Schöner Boulder! (alle Griffe verpflichtend )', '5c', '09.02.2021', 15, 'B1+D2/A7/C8/E11/H10/J9/M9/L6/M5/J4/H4/G2', NULL, 'famann'), (119, 'David gibt Gas', '4b', '10.02.2021', 15, 'L4+J4/K7/I9/G10/F11', NULL, 'consti'), (120, 'Indica', '5b', '10.02.2021', 15, 'M3+I3/I6/C6/F9/J10/M11', NULL, 'consti'), (121, 'Rambazamba', '5c', '10.02.2021', 15, 'C2+D3/C7/F8/I6/J7/L10/N11', NULL, 'consti'), (122, 'Geschenk', '5c', '13.02.2021', 30, 'B1+D2/A6/A8/B11/F9/G10/K11/L8/M6/J4/H4/F6', NULL, 'famann'), (123, 'Kleine Geschenk', '5a', '13.02.2021', 15, 'B1+D2/A6/A8/B11/F9/G10/K11/L8/M6/J4/H4/F6', NULL, 'famann'), (124, 'Schweizer Käselaibchen', '5a', '13.02.2021', 15, 'E3+J3/E5/C8/F9/F11/L11/N11', NULL, 'famann'), (125, 'Turn right soft Variation on Slab 15!', '5c', '13.02.2021', 15, 'B3+F3/E7/D8/I9/J9/N11', NULL, 'famann'), (126, 'Knaller', '5c', '13.02.2021', 15, 'A1+D2/B5/E5/C8/F9/I11/N9/L6/N5/K4/N2', NULL, 'famann'), (127, 'König von Deutschland', '6a', '13.02.2021', 30, 'A1+D2/B5/E5/C8/F9/G10/L10/L9/N9/L6/N5/K4/N2', NULL, 'famann'), (128, 'Wwwarmy.UP', '5c', '14.02.2021', 15, 'J3+M3/I6/K3/K5/N7/J9/H11/F11', NULL, 'Luigi'), (129, 'Entwickler', '6a', '14.02.2021', 15, 'A2/B5/E6/F7/I9/J11/N11', NULL, 'Luigi'), (130, 'Boulder Session', '5c', '14.02.2021', 30, 'C4+C6/E7/C10/F11/G10/M9/K7/K3/H4', NULL, 'consti'), (131, 'Shizzle Dizzle', '6b', '14.02.2021', 15, 'M3+N3/L6/G7/F9/H11/J11/M11', NULL, 'Luigi'), (132, 'Release please! 🙌', '5b', '14.02.2021', 15, 'G2+D1/E5/E7/E10/H9/J7/L11', NULL, 'Luigi'), (133, 'This is the end', '5a', '14.02.2021', 15, 'I3+J2/L5/N6/L9/K11/G11', NULL, 'consti'), (134, 'Pain (all holds)', '5a+', '15.02.2021', 15, 'B1+E3/C8/H7/L6/K11/H10/E10/A11', NULL, 'consti'), (135, 'Stupid as Fuck', '5b', '15.02.2021', 15, 'I3+J2/G6/K6/H10/B8/A11', NULL, 'consti'), (136, '45°', '5c', '15.02.2021', 15, 'M2+N5/I3/G6/C6/E10/H11', NULL, 'consti'), (137, 'Pressure', '5b', '15.02.2021', 15, 'B5+D3/E7/I6/M7/N11', NULL, 'consti'), (138, 'Dont let me be misunderstood', '5c', '15.02.2021', 15, 'D1+F4/G4/J5/K7/F10/C11', NULL, 'consti'), (139, 'Pfiff', '5b', '15.02.2021', 15, 'N1+I4/G4/F6/C9/A11', NULL, 'consti'), (140, 'Pink Fingers', '5c', '15.02.2021', 15, 'A1+D2/C4/F5/J6/L9/N11', NULL, 'consti'), (141, 'Locker', '6a+', '16.02.2021', 30, 'M3+M5/J7/I8/E10/C11/A11', NULL, 'famann'), (142, 'Für den ellbogenbehinderten Opa ', '5a', '16.02.2021', 30, 'D2+C4/D7/C10/G10/H8/L8/L11/N11', NULL, 'famann'), (143, 'Wurm hinauf', '5a', '16.02.2021', 30, 'N2+J4/H4/C4/D7/C10/G10/I11/N10/M6', NULL, 'famann'), (144, 'Wurm hinauf mal 3 (3Runden)', '6a', '16.02.2021', 30, 'N2+J4/H4/C4/D7/C10/G10/I11/N10/M6', NULL, 'famann'), (145, 'Bullenfasching', '6a', '16.02.2021', 30, 'D3+B5/E7/C8/F11/H10/L10/L9/M5', NULL, 'famann'), (146, 'Griffig', '6a', '16.02.2021', 30, 'K3+I3/H6/B4/C8/A11/F9/H11/J9/M11/M9/L6', NULL, 'famann'), (147, 'Pumuckl ', '4a', '18.02.2021', 15, 'I1+J4/H6/H8/E8/E10/B11', NULL, 'famann'), (148, 'Das kleine Monster', '4c', '18.02.2021', 15, 'B1+D2/B5/C6/C8/E10/F11', NULL, 'famann'), (149, 'Der böse Wolf mit den langen Armen', '5a', '18.02.2021', 15, 'A2+D2/B5/E7/D10/H10/I10/N11', NULL, 'famann'), (150, 'Till Eulenspiegel ', '5b', '18.02.2021', 15, 'D2+F4/E6/G6/F8/G9/D10/C11/A11', NULL, 'famann'), (151, 'Immer noch 1 Finger Loch', '5b', '18.02.2021', 15, 'L2+M4/J5/I7/G8/F10/D9/B11', NULL, 'famann'), (152, 'Neustart', '5a', '21.02.2021', 15, 'A4+B4/E7/E5/H4/J4/L6/I9/H10/E10/B10/A11', NULL, 'consti'), (153, 'Treestuff', '5a', '21.02.2021', 15, 'L1+I3/J7/I9/H9/F9/D8/B11', NULL, 'consti'), (154, 'Hole staff', '5b', '21.02.2021', 15, 'J2+N4/H6/H5/E7/D6/A8/C11', NULL, 'consti'), (155, 'Low Ass', '5c', '21.02.2021', 15, 'M4+J3/I4/G2/E5/A5/G9/F11', NULL, 'consti'), (156, 'Maier ohne Eier', '5b', '21.02.2021', 15, 'B3+E5/F7/I7/J7/J11/F11', NULL, 'consti'), (157, 'Query staff', '6a', '21.02.2021', 15, 'A4+C1/C7/G5/J6/I9/N11', NULL, 'Luigi'), (158, 'Weites Feld', '6c', '21.02.2021', 15, 'G1+H3/D5/G9/E9/L6/M11', NULL, 'Luigi'), (159, 'Get Warm', '5a', '24.02.2021', 15, 'J2+M3/M5/J7/J8/H8/F7/E7/B8/C11/F11/H11/K11/N11', NULL, 'consti'), (160, 'Big Boy', '5c', '24.02.2021', 15, 'B3+G3/I6/J4/L6/G11/D11', NULL, 'consti'), (161, 'Rebell', '5c', '24.02.2021', 30, 'C4+I3/H7/M6/I9/F11/B11', NULL, 'consti'), (162, 'Strolch', '5b', '24.02.2021', 30, 'K3+J4/K7/H7/I9/G10/E11/B11/D7/B4/C4', NULL, 'consti'), (163, 'Pubertier ', '4a', '28.02.2021', 15, 'H4+J4/H6/F6/D7/C10/A11', NULL, 'famann'), (164, 'Die hässliche Jogginghose meiner Tochter', '4b', '28.02.2021', 15, 'G2+H4/H6/H8/E8/C10/A11', NULL, 'famann'), (165, 'Zahnspange', '4b', '28.02.2021', 15, 'B1+D2/C4/F6/F7/H8/G10/I11', NULL, 'famann'), (166, 'Ausflug zum Teisenberg', '5c', '28.02.2021', 15, 'B2+D2/D5/F5/F8/H10/J9/N10', NULL, 'famann'), (167, 'Short Shot', '5a', '02.03.2021', 15, 'K4+N5/J7/J8/E10/C11', NULL, 'consti'), (168, 'Long Shot (last holds K4+N5)', '6a', '02.03.2021', 15, 'K4+N5/J7/J8/E10/C11/A8/C6/E6/I3', NULL, 'consti'), (169, 'SchulterWaage', '5b', '02.03.2021', 15, 'B2+C5/E7/J7/K6/M11', NULL, 'Luigi'), (170, 'Willkommen in Franggen! ', '5a', '06.03.2021', 45, 'B1+C4/D7/G10/I11/N10', NULL, 'famann'), (171, 'OK!', '5c', '06.03.2021', 45, 'B4+C4/D7/H7/F11', NULL, 'famann'), (172, 'Kaiserschmarrn', '5b', '06.03.2021', 45, 'B4+C4/D7/H8/F11', NULL, 'famann'), (173, 'Bigfoot', '6a', '06.03.2021', 45, 'B4+E3/D7/H7/F11/K11', NULL, 'famann'), (174, 'Steil ist geil! ', '5b', '06.03.2021', 45, 'N2+J4/H6/H8/G10/C10/B11', NULL, 'famann'), (175, 'Softy', '5b', '06.03.2021', 45, 'I1+J4/K7/L8/G10/G11/C10/D7/C4', NULL, 'famann'), (176, 'Hardy', '5c', '06.03.2021', 45, 'I1+K2/K7/L8/G10/G11/C10/D7/C4', NULL, 'famann'), (177, 'Deadwood in the black hills', '5c', '06.03.2021', 45, 'G2+I1/H4/F7/E8/C8/C10/B11', NULL, 'famann'), (178, 'Made by David (Kinderboulder)', '5a', '07.03.2021', 30, 'K6+M6/L8/J10/I11/G10/F11', NULL, 'consti'), (179, 'Schneeball', '5a', '08.03.2021', 30, 'N2+M6/L8/I10/G10/E11/C10/A8/C4', NULL, 'Thomas Bauer '), (180, 'Freizeiterlebnis', '6a', '08.03.2021', 30, 'N2+M5/M8/I10/H10/E10/C9/A8/C4', NULL, 'Thomas Bauer '), (181, 'Die blutige Nase', '6b', '08.03.2021', 30, 'C2+E3/C7/H10/K11/N9/L6/N4/K3', NULL, 'Thomas Bauer '), (182, 'Doppeldyno', '6b', '08.03.2021', 30, 'A4+D3/G7/C7/J8/J11/N9', NULL, 'Thomas Bauer '), (183, 'Nummer 100', '5c', '08.03.2021', 30, 'D2+C4/F6/C8/E10/G10/L11/K7/L4/J4', NULL, 'Thomas Bauer '), (184, 'Gscheid schee', '6b', '08.03.2021', 30, 'E3+B4/A7/F8/E10/J9/J7/M5/I3', NULL, 'Thomas Bauer '), (185, 'Kimmt guad', '5b', '09.03.2021', 15, 'I3+L1/K4/J7/H10/E11/A11', NULL, 'consti'), (186, 'Graceland', '5b', '09.03.2021', 15, 'E3+D2/A5/G7/G8/K8/K11', NULL, 'Luigi'), (187, 'DownUp Staff', '5b+', '09.03.2021', 15, 'D2+C2/C6/G3/H6/N7/J11/H11', NULL, 'Luigi'), (188, 'Furz', '5c', '09.03.2021', 15, 'J3+N3/N5/G4/G6/C6/G9/G11/K11', NULL, 'consti'), (189, 'Diago staff', '6a', '09.03.2021', 30, 'M2+M3/K5/K6/G6/F8/B10/A11', NULL, 'Luigi'), (190, 'Intuition staff', '6c', '09.03.2021', 30, 'G2/D5/C7/B8/G9/H9/J11/K11/N6/L7/K5/K3/H3', NULL, 'Luigi'), (191, 'Welcome Karl.', '5a', '14.03.2021', 15, 'J1+E3/F5/D8/G9/H10/L10/N11', NULL, 'famann'), (192, 'Ping Pong', '5b', '15.03.2021', 15, 'N2+K2/J4/G2/F4/C4/F7/G10/I11/L10/N10', NULL, 'famann'), (193, 'Toni Pistolero', '4a', '15.03.2021', 15, 'I1+K2/J4/K7/H7/J10/I11', NULL, 'famann'), (194, 'Wieder ohne Helm', '6a', '15.03.2021', 15, 'A1+C2/A5/F5/G6/J6/J8/K11', NULL, 'famann'), (195, 'Sonntagstour', '5c', '15.03.2021', 15, 'B2+D3/A7/C9/E10/H10/K11/M11', NULL, 'famann'), (196, 'Hells Bells', '5c', '15.03.2021', 15, 'B2+D2/B5/B9/D10/I6/J7/N9/M11', NULL, 'famann'), (197, 'Für Kids!', '4b', '15.03.2021', 15, 'D2+B3/C4/H4/H6/K7/L8/N10', NULL, 'famann'), (198, 'Kleine Äffchen ', '4b', '15.03.2021', 15, 'D2+C4/F6/H6/K7/L8/N10/I11', NULL, 'famann'), (199, 'Knifflig! (Tip Heelhook)', '6b', '17.03.2021', 15, 'C2+D3/D8/G6/I9/M9/N11/J11/G11/C11/A10', NULL, 'consti'), (200, 'Schwierige Kreuzerei (Kindertour)', '4b', '19.03.2021', 15, 'I1+J2/I3/J5/I6/H7/I9/H10/G10/E10/D10/C10/B11', NULL, 'consti'), (201, 'Wie eine Katze!', '5c', '19.03.2021', 15, 'L1+M3/K5/J7/G6/E7/D8/F11', NULL, 'famann'), (202, 'Lieblingszug ', '5b', '19.03.2021', 15, 'M1+N2/L5/M8/J9/H10/D10/C11', NULL, 'famann'), (203, 'Sixpack', '4c', '19.03.2021', 15, 'M1+N2/J4/F7/E8/A11', NULL, 'famann'), (204, 'Die kleine Rotznase', '4b', '19.03.2021', 15, 'N2+J4/M6/L8/J10/H8/E8/B11', NULL, 'famann'), (205, 'Plaisir ', '4a', '19.03.2021', 15, 'K2+G2/F6/D7/G10/I11/N10/M6', NULL, 'famann'), (206, 'Völlig schmerzfrei', '5c', '19.03.2021', 15, 'G2+I3/I6/L10/H10/E10/A10/D8/B4', NULL, 'famann'), (207, 'Puzzle', '5b', '19.03.2021', 15, 'B1+D2/C8/F9/F11/J9/K11/M11', NULL, 'Thomas Bauer '), (208, 'Mr Internet kennt sich auch nicht aus', '5c', '19.03.2021', 15, 'D1+D2/A7/G7/F8/K8/J9/M11', NULL, 'Thomas Bauer '), (209, 'Die Griffexperten', '5c', '19.03.2021', 15, 'L1+N3/J7/H10/D8/C6/A4/E3', NULL, 'Thomas Bauer '), (210, 'Was Leisten!', '6a', '19.03.2021', 15, 'I2+L5/G6/I8/F8/G9/C9/A11', NULL, 'Thomas Bauer '), (211, 'Gut und günstig', '5a', '19.03.2021', 15, 'C4+C6/E7/C10/F11/G10/M9/K7/K3/H4', NULL, 'Thomas Bauer '), (212, 'Afterskitour Staff', '6a', '20.03.2021', 15, 'B2+C3/C7/B8/I6/J7/I10/E11/C11', NULL, 'Luigi'), (213, 'ST warm up', '5c', '20.03.2021', 15, 'I2+L4/K5/K10/F8/E10/A11', NULL, 'Luigi'), (214, 'Powpowder Steff', '6b', '20.03.2021', 15, 'J3+M2/N6/I8/H10/E6/C9/A11', NULL, 'Luigi'), (215, 'Taurils Best', '6a', '20.03.2021', 15, 'J1+K2/G7/D10/E11/J6/E7/J11/L11', NULL, 'Luigi'), (216, 'Medienprofi ', '5a', '22.03.2021', 45, 'J4+N2/K7/L8/J10/I11/G10', NULL, 'famann'), (217, 'Billy the Kid (Kinderboulder)', '5a', '22.03.2021', 15, 'G2+I3/J5/I6/H7/G8/F9/G10/I10/J10/K11', NULL, 'consti'), (218, 'Von Lockdown zu...zu. ..', '5c', '24.03.2021', 15, 'L3+N3/M5/N6/M9/K11/H7/F8/E8/C9/A11', NULL, 'famann'), (219, 'Homogen', '5c', '25.03.2021', 15, 'C2+D2/G4/E7/I8/J9/N7/N11', NULL, 'consti'), (220, 'Kruzi Kreizzug nei', '6a', '25.03.2021', 15, 'M2+M3/I4/I6/E6/C9/E11/J9/L7', NULL, 'Luigi'), (221, 'Long John Staff', '6b', '25.03.2021', 15, 'K1+L2/M5/H8/F5/B6/C11', NULL, 'Luigi'), (222, 'Both Sides', '6a', '25.03.2021', 15, 'D3+C3/A7/D10/G11/H5/I8/N6/K5/N2', NULL, 'Luigi'), (223, 'Jakob grüßt Consti', '6a', '29.03.2021', 45, 'K4+M6/L8/J10/G11/F9/C10/B11/A8/C4', NULL, 'famann'), (224, 'Monsterholds 15', '4a', '29.03.2021', 15, 'D2+C4/F6/F7/H8/J10/N10', NULL, 'famann'), (225, 'Zum Anfangen', '3b', '29.03.2021', 7.5, 'D2+C4/F6/F7/H8/J10/N10', NULL, 'famann'), (226, 'Ãœbung macht den Master', '3b', '29.03.2021', 7.5, 'D2+C4/F6/F7/H8/I10/N10', NULL, 'famann'), (227, 'Monster Griffe 30', '4c', '29.03.2021', 30, 'D2+C4/F6/F7/H8/J10/N10', NULL, 'famann'), (228, 'Steil und ziemlich beste Griffe', '5b', '29.03.2021', 45, 'D2+C4/F6/F7/H8/J10/N10', NULL, 'famann'), (229, 'Das schwarze Loch', '6a', '02.04.2021', 45, 'N2+K2/M6/L8/J10/G11/F9/C10/B11/A8/C4', NULL, 'famann'), (230, 'Pippi Langstrumpf', '3b', '02.04.2021', 7.5, 'I1+K2/H4/H6/F6/D7/C10/B11', NULL, 'famann'), (231, 'Radltour zum Königssee', '4a', '02.04.2021', 7.5, 'N2+K2/J4/H4/F7/E8/C10/B11', NULL, 'famann'), (232, 'Riesen W.', '4a', '02.04.2021', 7.5, 'L3+M3/M5/J7/H8/E10/D11', NULL, 'famann'), (233, 'Magnete haften nicht auf Holz', '4b', '02.04.2021', 7.5, 'D2+C4/E5/E7/H8/I9/M9/N11', NULL, 'famann'), (234, 'Gummibärchen', '4b', '02.04.2021', 7.5, 'F1+G2/H4/J4/K5/M6/L8/L10/K11', NULL, 'famann'), (235, 'AC DC', '5a', '02.04.2021', 7.5, 'F1+G2/G4/K4/L5/N7/L8/L10/I9/H11', NULL, 'famann'), (236, 'Sendung mit der Maus', '3a', '03.04.2021', 7.5, 'N2+J4/K7/H8/F7/D7/B9/A11', NULL, 'famann'), (237, 'Mickey Maus', '4a', '03.04.2021', 7.5, 'M3+J4/K7/H7/F6/C6/A8/B10/F11', NULL, 'famann'), (238, 'Aschenbrödel', '4b', '03.04.2021', 7.5, 'J4+H4/I6/H7/J8/J9/H11/F11', NULL, 'famann'), (239, 'Mimi die Lesemaus', '3a', '03.04.2021', 7.5, 'J4+H4/H6/H7/H8/J10/I11', NULL, 'famann'), (240, 'Osterhase', '3a', '03.04.2021', 7.5, 'A4+C4/A6/D7/C10/E11', NULL, 'famann'), (241, 'Rapunzel', '4a', '03.04.2021', 7.5, 'A4+C4/D7/F6/H6/K7/L8/N10/K11/I11', NULL, 'famann'), (242, 'Räuber Hotzenplotz', '3b', '03.04.2021', 7.5, 'G2+I1/H4/F6/F7/E8/G10/E11', NULL, 'famann'), (243, 'Idefix', '4a', '03.04.2021', 7.5, 'G2+J4/H7/F7/D7/C8/B9/B11', NULL, 'famann'), (244, 'Der kleine Prinz', '4b', '03.04.2021', 7.5, 'F1+H4/H6/G7/D7/D8/B9/D11', NULL, 'famann'), (245, 'Schule der magischen Tiere', '4c', '03.04.2021', 7.5, 'I3+G4/I6/E6/E7/D8/G9/F11', NULL, 'famann'), (246, 'Lego', '3a', '03.04.2021', 7.5, 'N2+J4/M6/K7/L8/J10/L11', NULL, 'famann'), (247, 'Geschichten von Franz', '3a', '03.04.2021', 7.5, 'K3+J4/K7/H8/J10/I11', NULL, 'famann'), (248, 'Robin Hood', '4a', '03.04.2021', 7.5, 'K3+J4/H4/H7/I9/G10/E10/B11', NULL, 'famann'), (249, 'Die Olchis', '4b', '03.04.2021', 7.5, 'E3+H4/H7/J8/I9/J10/G11/E11/B11/B9', NULL, 'famann'), (250, 'Schräg!', '5a', '03.04.2021', 7.5, 'A1+D3/B5/E5/E7/G9/H10/K11', NULL, 'famann'), (251, 'IQ 130', '5a', '03.04.2021', 7.5, 'A2+D2/A5/E6/D10/G9/I10/N11', NULL, 'famann'), (252, 'Boulder factory', '5b', '03.04.2021', 15, 'A2+D2/B6/E7/C9/G9/I10/L10/L6/M5', NULL, 'famann'), (253, 'Wohnzimmernordwand', '4a', '03.04.2021', 15, 'B1+D2/C4/F6/D7/C10/A11', NULL, 'famann'), (254, 'Kleine Hexe', '4b', '03.04.2021', 7.5, 'F2+I4/H5/I6/H7/I9/H10/K11', NULL, 'famann'), (255, 'Das kleine Gespenst', '4c', '03.04.2021', 7.5, 'G1+I4/G4/J6/J7/L9/K11', NULL, 'famann'), (256, 'Robinson Crusoe', '3b', '03.04.2021', 7.5, 'C4+E3/F6/E8/G10/I11/L11', NULL, 'famann'), (257, 'Raupe Nimmersatt', '3b', '03.04.2021', 7.5, 'F1+H4/H6/K7/L8/M9/M11', NULL, 'famann'), (258, 'Jim Knopf', '3a', '03.04.2021', 7.5, 'I1+J4/H6/K7/J9/J10/I11', NULL, 'famann'), (259, 'Immer dieser Michel', '5a', '03.04.2021', 7.5, 'G1+K4/H5/G6/D8/C9/C11', NULL, 'famann'), (260, 'Brüder Lõwenherz', '4c', '03.04.2021', 7.5, 'G1+E3/G5/E7/F8/E10/C11', NULL, 'famann'), (261, 'RitterRost', '4c', '03.04.2021', 7.5, 'D2+C4/E5/F6/G7/E8/E10/C11', NULL, 'famann'), (262, 'Struwelpetra', '4b', '04.04.2021', 15, 'K3+J4/H6/F7/E8/C8/C10/E11/G11/I11/L11/N10/M6', NULL, 'famann'), (263, 'Rübezahl(en)', '5a', '04.04.2021', 15, 'N2+K2/J4/H4/G2/C4/A6/A8/C10/E11/G10/I10/L11/N10/M9/M6', NULL, 'famann'), (264, 'Arnold Schwarzenegger', '4b', '04.04.2021', 45, 'J4+H4/H6/H8/J10/I11', NULL, 'famann'), (265, 'Angeber', '3c', '06.04.2021', 7.5, 'I1+J4/H6/H8/E8/E10/B11', NULL, 'famann'), (266, 'hard understaff', '6b', '07.04.2021', 15, 'B2+C3/E5/D4/J6/J11/N11', NULL, 'Luigi'), (267, 'crank flipp', '6c', '07.04.2021', 15, 'C2+F3/H4/L5/I8/G9/D11', NULL, 'Luigi'), (268, 'Switched HopperBoy', '6b+', '07.04.2021', 15, 'A2+A3/E6/E4/H5/I8/M11', NULL, 'Luigi'), (269, 'Jetzt aber!', '5c+', '11.04.2021', 7.5, 'F3+E4/C7/G9/I8/K8/L10/N6/K4/M1', NULL, 'famann'), (270, '16.Geburtstag', '5c', '12.04.2021', 7.5, 'C1+G3/C7/G7/I8/J8/L10/L6/K4/M1', NULL, 'famann'), (271, 'Rehtschriebfeler', '3c', '12.04.2021', 7.5, 'N2+K2/J4/H6/H7/E8/E10/B11', NULL, 'famann'), (272, 'Puzzle 500', '4b', '12.04.2021', 7.5, 'N2+K2/J4/M6/K7/J8/H8/F6/E8/B9/B11', NULL, 'famann'), (273, 'Donald Duck', '4c', '12.04.2021', 7.5, 'G2+K4/G4/I6/H7/I9/H10/F11', NULL, 'famann'), (274, 'I me myself', '5a', '12.04.2021', 7.5, 'I1+E3/I4/H5/G7/E7/E10/A11', NULL, 'famann'), (275, 'Bobby Car', '4c', '12.04.2021', 7.5, 'I1+G2/H4/C4/E7/F8/G11', NULL, 'famann'), (276, 'Stinkende Socken', '5a', '12.04.2021', 7.5, 'G2+I1/I4/E3/E7/F8/G11', NULL, 'famann'), (277, 'Rucksack', '5b', '12.04.2021', 7.5, 'I1+G2/G3/E4/G7/D8/D10/A11', NULL, 'famann'), (278, 'Nachheizen', '5b+', '12.04.2021', 7.5, 'G2+K2/G6/G7/F8/D10/H11/K11/N11', NULL, 'famann'), (279, 'Normalweg', '5a+', '12.04.2021', 7.5, 'G2+K2/I4/H5/J7/I9/K11', NULL, 'famann'), (280, 'Schwitzkasten', '5a+', '12.04.2021', 7.5, 'F1+G2/G4/L4/L5/N7/J7/K8/I9/I11', NULL, 'famann'), (281, 'So geschenkt auch wieder nicht', '5b', '12.04.2021', 7.5, 'F1+G2/G4/I4/J7/I8/F8/E9/B11', NULL, 'famann'), (282, 'Endspurt', '5b', '12.04.2021', 7.5, 'D1+G2/D3/E5/C7/G9/H10/K11', NULL, 'famann'), (283, 'Zwischenziel', '5b', '12.04.2021', 7.5, 'B1+G2/E5/D8/I9/J9/K11', NULL, 'famann'), (284, 'Sweet Child Of Mine', '4b', '12.04.2021', 15, 'K2+I3/J5/H6/H7/G8/E8/C8/B9/A10/A11', NULL, 'consti'), (285, 'Not for Warmup', '5c+', '14.04.2021', 15, 'A4+D3/D6/G7/G4/L6/K9/H10/B8/C11', NULL, 'consti'), (286, 'TeamworkBoulder', '6a+', '14.04.2021', 15, 'G2/L4/J7/J8/D4/D6/B8/H10/J9/N7', NULL, 'consti'), (287, 'TreppaufTreppab', '6a', '14.04.2021', 15, 'B3+F3/E5/C6/I9/J7/L5/N8/L11/F11', NULL, 'luigi'), (288, 'Ein paar Bier und Bleistift', '6a', '16.04.2021', 15, 'I2+N1/M8/G6/D5/B6/A11', NULL, 'Michi'), (289, 'Allein im Wald', '4a', '17.04.2021', 7.5, 'M1+J4/I6/E8/B11', NULL, 'Michi'), (290, 'Affenschaukel', '3b', '17.04.2021', 7.5, 'N2+J4/H6/D7/B11', NULL, 'Michi'), (291, 'Schaut er wirklich so easy aus?', '3c', '17.04.2021', 7.5, 'J4+M2/H8/C8/D11', NULL, 'Michi'), (292, 'Einkaufen für Anfänger', '4b', '17.04.2021', 7.5, 'G2+J2/H4/C4/E7/D8/E10/B11', NULL, 'Michi'), (293, 'Nix für kleine Flügel', '4b', '17.04.2021', 7.5, 'J2+E3/I6/C8/F11', NULL, 'Michi'), (294, 'Pommes mit Majo', '4c', '17.04.2021', 7.5, 'G2+E3/E5/C6/E9/F11/K11/K10/N11', NULL, 'Michi'), (295, 'Tschernobyl', '5a', '17.04.2021', 7.5, 'J2+F1/G4/G6/E6/C7/A7/C11/A11', NULL, 'Michi'), (296, 'Fukushima', '5b', '17.04.2021', 7.5, 'G1+J2/D2/G3/D5/C7/C9/C11', NULL, 'Michi'), (297, 'Küchenschabe', '5c', '17.04.2021', 15, 'G1+J2/D2/D5/C7/C9/C11', NULL, 'Michi'), (298, 'Ultra Kurzer!', '6b', '17.04.2021', 30, 'C1+D5/C7/C9/C11', NULL, 'Michi'), (299, 'Bierhenkel', '5a', '17.04.2021', 30, 'N2+J4/K7/J9/J10/G10/F11/C10/D7/C4', NULL, 'Michi'), (300, 'Zack...zack...zack!', '5c+', '17.04.2021', 30, 'K1+J4/N5/J7/J10/H10/H11/D10/F7/C4', NULL, 'Michi'), (301, 'Mi piace!', '6b', '17.04.2021', 30, 'G1+B4/E7/D10/H10/I9/L10/L6/M5/J4', NULL, 'Michi'), (302, 'Es gibt jetzt kein Handy!', '5c', '18.04.2021', 30, 'C4+I3/H7/M6/I10/G11/B11', NULL, 'Michi'), (303, 'Brüllaffe', '6b', '18.04.2021', 15, 'C3+F3/C7/G9/I8/L9/K8/N6/K4/M2', NULL, 'Michi'), (304, 'Flex', '6a+', '20.04.2021', 15, 'F1+A2/A7/D8/E9/J7/J11/N7', NULL, 'Michi'), (305, 'Achillesferse', '6b', '20.04.2021', 15, 'C1+F3/B4/D8/F8/K10/I5/N7/M3', NULL, 'Michi'), (306, 'Kompressor ', '6a+', '27.04.2021', 45, 'J4+N4/J7/N9/I9/L10/F11/H11/B11', NULL, 'Michi'), (307, 'Für Jakob mit E7 statt G7', '4a', '27.04.2021', 45, 'B4+E3/B5/E5/A7/G7/C8/F11', NULL, 'Michi'), (308, 'Vom Jakob für mich', '6a', '27.04.2021', 45, 'B1+C4/D7/G10/H6/J4/M6/N10', NULL, 'Michi'), (309, 'Feierabend', '5a', '28.04.2021', 45, 'B4+C4/D7/H8/I11', NULL, 'famann'), (310, 'Powerausdauer', '5a', '29.04.2021', 15, 'G2+D2/C4/A6/A8/C10/G10/I11/N10/L8/K7/H4', NULL, 'famann'), (311, 'Power für Ausdauer', '5b', '29.04.2021', 30, 'G2+D2/C4/A6/A8/C10/G10/I11/N10/L8/K7/H4', NULL, 'famann'), (312, 'Den ganzen Tag nur maulen', '5a+', '29.04.2021', 30, 'G2/C4/D7/C10/G10/I11/N10/L8/K7/H4', NULL, 'famann'), (313, 'Beleidigte Leberwurscht', '5b+', '29.04.2021', 45, 'G2+C4/D7/C10/G10/I11/N10/L8/K7/H4', NULL, 'famann'), (314, 'Entsafter', '5b', '29.04.2021', 45, 'G2+C4/F6/F7/I11/J10/N10/M6', NULL, 'famann'), (315, 'Bodybuilding', '5b+', '29.04.2021', 45, 'G2+C4/F6/F7/H8/I10/L11/N11', NULL, 'famann'), (316, 'Cliffhanger', '5c', '29.04.2021', 45, 'C4+B4/D7/H7/H8/I10/L11/N11', NULL, 'famann'), (317, 'Kätzchen', '3c', '02.05.2021', 7.5, 'I1+J4/I4/H7/E8/E10/B11', NULL, 'famann'), (318, 'Mizie', '4b', '02.05.2021', 7.5, 'I1+J4/G4/H5/E7/E10/B11', NULL, 'famann'), (319, 'Letzte Zug', '5b', '02.05.2021', 7.5, 'M1+J4/I6/D8/A11', NULL, 'famann'), (320, 'Ja so halt!', '5b+', '02.05.2021', 7.5, 'M1+K4/K8/I9/H10/D10/A11', NULL, 'famann'), (321, 'Was?', '5c', '02.05.2021', 15, 'I2+M5/I9/F11/A10/C6/B4', NULL, 'famann'), (322, 'Krawallbruder', '6b', '02.05.2021', 30, 'I2+M5/I9/F11/A10/C6/B4', NULL, 'famann'), (323, 'Boulderparadies', '5b+', '02.05.2021', 30, 'D2+C4/G6/H7/J8/I10/N10', NULL, 'famann'), (324, 'Tief im Westen', '5b+', '02.05.2021', 30, 'D2+C4/G6/F8/J8/J9/M11', NULL, 'famann'), (325, 'Konsens', '5c', '02.05.2021', 30, 'G2+E3/H7/C8/C9/A11', NULL, 'famann'), (326, 'Zwergentod', '6a', '02.05.2021', 15, 'M3+K5/M8/D8/F11', NULL, 'famann'), (327, 'Stimmungsmacher', '4c', '02.05.2021', 7.5, 'A4+C4/D7/F6/H4/L6/K11', NULL, 'famann'), (328, 'Zufällige Wiedergabe', '5b', '02.05.2021', 15, 'D3+B5/E5/F7/I6/J7/M8/K11', NULL, 'famann'), (329, 'Tote Hosen', '5b', '02.05.2021', 15, 'B3+D3/C6/G5/H7/K10/K11', NULL, 'famann'), (330, '1st love', '5a', '02.05.2021', 15, 'M3+M5/J7/J8/E10/B9/A11', NULL, 'famann'), (331, 'Geh in deine Küche ...', '5b+', '02.05.2021', 15, 'N2+I4/J8/D8/E9/A11', NULL, 'famann'), (332, 'Antigen Schnelltest', '5b+', '06.05.2021', 15, 'B2+D3/B8/G5/H7/I10/H11/E11/A11', NULL, 'famann'), (333, 'Love Child', '6b', '06.05.2021', 15, 'A1+D3/A5/D5/B8/G6/J7/K10/H11/E11/A11', NULL, 'famann'), (334, 'Flinke Finger', '6a+', '06.05.2021', 15, 'M2+N1/L5/G6/F8/C9/C7/A5/B4', NULL, 'famann'), (335, 'Frech auch noch!', '7a', '06.05.2021', 45, 'J5+M4/L8/H9/F10/D9/D6/A4', NULL, 'famann'), (336, 'Baumhaus', '4b', '06.05.2021', 7.5, 'B4+E3/A7/G7/B8/F11', NULL, 'famann'), (337, 'Offene Tür', '4c', '06.05.2021', 7.5, 'B4+E3/A7/D8/A10/F11', NULL, 'famann'), (338, 'Supersommer', '4b', '06.05.2021', 7.5, 'K2+N2/M5/H7/H10/E10/D11/B11', NULL, 'famann'), (339, 'Leute auf der Burg', '4b', '06.05.2021', 7.5, 'J4+N2/L8/H7/H8/C8/D11/B11', NULL, 'famann'), (340, 'Gebutstagstour', '4c', '06.05.2021', 7.5, 'A5+C3/C7/C9/G9/I11', NULL, 'famann'), (341, 'Spannweite austricksen möglich', '5a', '06.05.2021', 7.5, 'E3+B5/I6/I9/M8/N11', NULL, 'famann'), (342, 'Two Fingers', '6a', '18.05.2021', 30, 'F2+L4/F7/G9/B10/A8/A4/C4', NULL, 'Thomas Bauer '), (343, 'Hoffentlich Bouldern', '6b', '18.05.2021', 30, 'A1+E5/E7/F9/F11/I9/J7/N7/K3', NULL, 'Thomas Bauer '), (344, 'Spanner', '6b', '18.05.2021', 30, 'A2+B4/C9/H10/H11/N9/L6', NULL, 'Thomas Bauer '), (345, 'Königin von Deutschland', '5c', '19.05.2021', 15, 'A1+D2/B5/E5/C8/F9/G10/L10/L9/N9/L6/N5/K4/N2', NULL, 'famann'), (346, 'Jetzt neu!', '5a', '21.05.2021', 30, 'F1+C4/F7/H8/J10/M11', NULL, 'famann'), (347, 'Alter Mann aus Straubing', '5c', '21.05.2021', 30, 'A6+A4/E3/F7/H7/I9/N10', NULL, 'famann'), (348, 'Update', '6a+', '21.05.2021', 30, 'M2+N5/I3/G6/C6/E10/H10/L10/M11', NULL, 'famann'), (349, 'Männerausflug', '6a', '21.05.2021', 30, 'E3+B5/C8/I6/I10/N11', NULL, 'famann'), (350, 'Damals in der Jugend', '5b+', '21.05.2021', 15, 'N2+M5/L9/I10/H10/E10/B9/A8/C4', NULL, 'famann'), (351, 'Wenn die Hilde ihn macht ...', '6b+', '21.05.2021', 45, 'F2+K3/J7/L9/J9/H11/F11/E10/A11', NULL, 'famann'), (352, '2mal2000 Höhenmeter', '7a', '21.05.2021', 45, 'G3+D5/C7/G6/F8/I8/H10/K8/K11', NULL, 'famann'), (353, 'Auch mit Wampe!', '5c', '21.05.2021', 15, 'G3+D5/C7/G6/F8/I8/H10/K8/K11', NULL, 'famann'), (354, 'OpenAir', '6b', '21.05.2021', 30, 'G3+D5/C7/G6/F8/I8/H10/K8/K11', NULL, 'famann'), (355, 'Wilder Leon', '4a', '21.05.2021', 15, 'F1+G2/E5/F6/D8/G10/I11', NULL, 'famann'), (356, 'Großer Meister Eder', '5b+', '21.05.2021', 30, 'F1+G2/E5/F6/D8/G10/I11', NULL, 'famann'), (357, 'Toni45', '6a+', '21.05.2021', 45, 'F1+G2/E5/F6/D8/G10/I11', NULL, 'famann'), (358, 'Erholungsphae', '5a', '21.05.2021', 7.5, 'G3+D5/C7/G6/F8/I8/H10/K8/K11', NULL, 'famann'), (359, 'All das ohne Test', '5a+', '21.05.2021', 7.5, 'G3+B3/C7/G6/H7/N7/M11', NULL, 'famann'), (360, 'Barfuß am Klavier', '5c', '21.05.2021', 30, 'N2+K5/K7/J9/I10/E10/C10/A8/C4', NULL, 'famann'), (361, 'Nie schön genug.', '5a+', '21.05.2021', 15, 'N3+K4/M6/J7/I10/F11/E10/B9/A6/A4', NULL, 'famann'), (362, 'Zeichen der Erinnerung', '5a+', '21.05.2021', 15, 'D3+B3/C6/G5/H7/H10/E10/E11/A11', NULL, 'famann'), (363, 'In den besten Zeiten', '5c', '21.05.2021', 15, 'B3+D3/G5/G4/J8/E10/D11/A11', NULL, 'famann'), (364, 'Wetterfest brutal', '5b', '21.05.2021', 15, 'D3+G4/I6/J7/L6/G11/E10/B9', NULL, 'famann'), (365, 'Immer wenn wir uns sehen', '5b+', '21.05.2021', 15, 'D3+G4/H5/I6/J7/N7/J11/K11', NULL, 'famann'), (366, 'Boulderbefehl', '5b+', '23.05.2021', 15, 'B5+D3/G5/G6/L4/L8/M11', NULL, 'famann'), (367, 'Mein Schwimmreifen', '6a+', '23.05.2021', 30, 'D3+B5/G5/G6/L4/L8/M11', NULL, 'famann'), (368, 'Ambitioniert', '6c+', '23.05.2021', 45, 'D3+B5/G5/G6/L4/L8/M11', NULL, 'famann'), (369, 'Tirol plaisir', '5b+', '23.05.2021', 45, 'G2+J4/H4/K7/J9/N11', NULL, 'famann'), (370, 'Trügerische Erinnerung ', '6b+', '23.05.2021', 45, 'B4+E3/B5/E5/A7/G7/B8/F11', NULL, 'Michi'), (371, 'Eigentlich schönes Wetter', '5c', '23.05.2021', 45, 'G2+J4/H4/M6/J9/M9/L11', NULL, 'famann'), (372, 'Suche nach dem Sommer', '6a', '23.05.2021', 30, 'K2+L4/I4/I6/D8/E10/A11', NULL, 'famann'), (373, 'Kletterglück', '6b+', '23.05.2021', 45, 'K2+L4/I4/M5/J7/J8/E10/F9/A11', NULL, 'Michi'), (374, 'Schönwetterfenster', '5c+', '23.05.2021', 30, 'K2+L4/I4/M5/J7/K11/E10/F9/A11', NULL, 'famann'), (375, 'Ausleger', '5c', '23.05.2021', 15, 'I2+N3/K5/N5/J7/L10/D10/F9/A11', NULL, 'famann'), (376, 'Monsterbolts', '5a+', '23.05.2021', 15, 'I2+L4/K4/N5/J7/L10/E10/F9/A11', NULL, 'famann'), (377, 'Alles schon gesehen!', '5c', '23.05.2021', 15, 'J3+N3/K5/N5/I9/J8/D8/E9/A11', NULL, 'famann'), (378, 'Fitnesstest', '5c', '23.05.2021', 15, 'I3+N3/M8/I9/H10/B8/A11', NULL, 'famann'), (379, 'Dynamo Motivation ( English Name Sperling!)', '5c', '23.05.2021', 30, 'A6+A3/G5/F7/J8/I9/N10', NULL, 'famann'), (380, 'Dein ist mein ganzes Herz (HRK)', '5a+', '23.05.2021', 30, 'G2+C4/D7/E8/H7/I10/M9/N11', NULL, 'famann'), (381, 'Treffer', '5c+', '23.05.2021', 30, 'C4+G2/E7/C10/H10/I11/N10/L9/K7/H4', NULL, 'famann'), (382, 'Halbe Tüte Erdnussflips', '4c', '23.05.2021', 15, 'J4+N5/H6/C6/B9/A11', NULL, 'famann'), (383, 'Tanz der Moleküle (N.300)', '6a', '23.05.2021', 15, 'B5+E1/G3/E6/K4/J7/H10/A11', NULL, 'famann'), (384, 'Schönste Zeit', '5a+', '23.05.2021', 15, 'E4+J3/G6/C9/H11', NULL, 'famann'), (385, 'Boulderrausch', '5a+', '23.05.2021', 15, 'E5+I4/G7/B9/H11', NULL, 'famann'), (386, 'Kann es kaum erwarten', '3c', '23.05.2021', 15, 'C4+D2/F6/D7/C10/A11', NULL, 'famann'), (387, 'Lieblingsmensch', '5a', '23.05.2021', 15, 'B5+E1/G6/B8/E10/A11', NULL, 'famann'), (388, 'Engelsflügerl', '5b', '23.05.2021', 15, 'B5+J2/I6/B8/H11', NULL, 'famann'), (389, 'Schön genug', '5b+', '28.05.2021', 30, 'N3+K5/L8/J9/G10/F11/C10/B9/C4', NULL, 'famann'), (390, 'Putzteufel', '6a+', '28.05.2021', 30, 'E3+B4/B9/D11/F11/I9/K11/N11', NULL, 'famann'), (391, 'Prozentwert', '6b', '28.05.2021', 30, 'B2+E3/E7/G8/G9/J7/I9/L6/M11', NULL, 'famann'), (392, 'Nachhilfe', '5b', '28.05.2021', 15, 'B2+E3/E7/G8/G9/J7/I9/L6/M11', NULL, 'famann'), (393, 'Boulder Häschen', '5c+', '28.05.2021', 15, 'B2+E3/B6/F8/G9/K8/K11', NULL, 'famann'), (394, 'Kinder der Freiheit', '5b+', '28.05.2021', 15, 'B2+E3/B6/F8/G9/L6/M11', NULL, 'famann'), (395, 'Urlaubsarchitektur', '5b+', '28.05.2021', 15, 'I2+N3/I4/J7/E7/F8/C11', NULL, 'famann'), (396, 'Astsäge', '6a+', '28.05.2021', 15, 'K2+L2/K4/G1/I4/C9/D11', NULL, 'Michi'), (397, 'Am Ast sägen', '5a+', '28.05.2021', 15, 'I2+N4/J7/J8/C6/E10/A11', NULL, 'famann'), (398, 'Popcorn', '4b', '06.06.2021', 7.5, 'N1+I3/I6/D8/B11', NULL, 'famann'), (399, 'Pre Travel Clearance', '5a+', '06.06.2021', 7.5, 'J2+D3/E5/B6/E9/F11/K11/K5/N11', NULL, 'famann'), (400, 'Kein Sekt!', '5a+', '06.06.2021', 7.5, 'E1+D3/E5/C7/G9/H10/K11/L7/N11', NULL, 'famann'), (401, 'Das !! Projekt', '5b', '06.06.2021', 7.5, 'D1+G2/G4/K4/J7/I8/D8/E9/A11', NULL, 'famann'), (402, 'Abrutscher', '5b+', '06.06.2021', 7.5, 'A1+F1/B3/E5/D8/J7/K11/N11', NULL, 'famann'), (403, 'Traverse', '5c', '06.06.2021', 7.5, 'A5+B6/G3/I8/N6', NULL, 'famann'), (404, 'Billiger', '6a', '06.06.2021', 7.5, 'A2+A5/G3/J6/K4/J11', NULL, 'famann'), (405, 'Zauberleiste', '6b', '06.06.2021', 7.5, 'A5+A2/G3/J6/L5/J11', NULL, 'Michi'), (406, 'Abgesägt', '5c+', '06.06.2021', 15, 'K2+L2/K4/G1/I6/C9/D11', NULL, 'famann'), (407, 'Gewitter', '5c+', '24.06.2021', 7.5, 'A2+A5/G3/G7/L4/J11', NULL, 'famann'), (408, 'Offene Türen', '5c+', '24.06.2021', 7.5, 'N6+N5/H2/H5/B3/A7/B9/H11', NULL, 'famann'), (409, 'Fußtechnik???', '6b', '24.06.2021', 7.5, 'N6+N5/H2/L5/F5/G3/C9/J11', NULL, 'Michi'), (410, 'Textilverbot', '6a', '24.06.2021', 15, 'B2+G3/B6/F8/F9/K8/M11', NULL, 'famann'), (411, 'Athletico', '6a+', '30.06.2021', 45, 'C6+C4/E7/C10/F11/G10/M9/K7/J4', NULL, 'famann'), (412, 'H.H. und der Fliesenleger', '6a+', '30.06.2021', 45, 'I3+J4/K7/M9/G10/F11/C10/B9/A6/C4', NULL, 'famann'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `progressprobs` -- CREATE TABLE `progressprobs` ( `i` int(11) NOT NULL, `user_id` int(10) NOT NULL, `prob_id` int(10) NOT NULL, `time` varchar(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- -- Daten für Tabelle `progressprobs` -- INSERT INTO `progressprobs` (`i`, `user_id`, `prob_id`, `time`) VALUES (36, 39, 160, '21.03.2021'), (34, 38, 190, '09.03.2021'), (30, 1, 140, '15.02.2021'), (25, 1, 109, '11.02.2021'), (24, 20, 109, '11.02.2021'), (23, 37, 99, '11.02.2021'), (22, 1, 101, '11.02.2021'), (12, 1, 95, '10.02.2021'), (38, 18, 205, '28.03.2021'), (39, 18, 245, '15.04.2021'), (44, 40, 352, '23.05.2021'), (43, 40, 266, '20.05.2021'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `solvedprobs` -- CREATE TABLE `solvedprobs` ( `i` int(15) NOT NULL, `user_id` int(10) NOT NULL, `prob_id` int(10) NOT NULL, `time` varchar(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- -- Daten für Tabelle `solvedprobs` -- INSERT INTO `solvedprobs` (`i`, `user_id`, `prob_id`, `time`) VALUES (128, 1, 119, '11.02.2021'), (125, 1, 77, '11.02.2021'), (126, 37, 114, '11.02.2021'), (100, 1, 90, '10.02.2021'), (110, 1, 85, '10.02.2021'), (123, 1, 104, '11.02.2021'), (119, 1, 119, '11.02.2021'), (129, 18, 94, '13.02.2021'), (130, 18, 72, '13.02.2021'), (131, 18, 67, '13.02.2021'), (132, 18, 115, '13.02.2021'), (133, 18, 106, '13.02.2021'), (134, 18, 121, '13.02.2021'), (135, 18, 99, '13.02.2021'), (136, 18, 100, '13.02.2021'), (137, 18, 122, '13.02.2021'), (138, 18, 116, '13.02.2021'), (139, 18, 83, '13.02.2021'), (141, 38, 84, '14.02.2021'), (142, 38, 115, '14.02.2021'), (143, 38, 127, '14.02.2021'), (144, 1, 120, '15.02.2021'), (145, 1, 134, '15.02.2021'), (146, 1, 139, '15.02.2021'), (147, 1, 114, '15.02.2021'), (148, 18, 78, '16.02.2021'), (151, 18, 89, '26.02.2021'), (152, 18, 147, '26.02.2021'), (153, 18, 119, '26.02.2021'), (154, 18, 107, '26.02.2021'), (164, 18, 156, '02.03.2021'), (156, 18, 123, '26.02.2021'), (157, 18, 159, '26.02.2021'), (158, 18, 95, '26.02.2021'), (159, 18, 105, '26.02.2021'), (161, 18, 130, '27.02.2021'), (162, 18, 148, '02.03.2021'), (163, 18, 164, '02.03.2021'), (165, 38, 158, '02.03.2021'), (166, 1, 124, '04.03.2021'), (167, 18, 150, '11.03.2021'), (168, 18, 132, '11.03.2021'), (169, 18, 152, '11.03.2021'), (170, 18, 155, '14.03.2021'), (172, 18, 160, '15.03.2021'), (173, 1, 195, '17.03.2021'), (174, 1, 121, '17.03.2021'), (175, 1, 196, '17.03.2021'), (183, 18, 186, '22.03.2021'), (178, 39, 85, '21.03.2021'), (179, 18, 197, '22.03.2021'), (180, 18, 205, '22.03.2021'), (181, 18, 163, '22.03.2021'), (182, 18, 149, '22.03.2021'), (185, 18, 172, '27.03.2021'), (186, 18, 205, '28.03.2021'), (187, 18, 86, '28.03.2021'), (188, 18, 163, '28.03.2021'), (189, 18, 124, '28.03.2021'), (190, 18, 147, '28.03.2021'), (191, 18, 133, '28.03.2021'), (192, 18, 193, '29.03.2021'), (193, 18, 94, '29.03.2021'), (194, 18, 224, '29.03.2021'), (195, 18, 170, '29.03.2021'), (196, 18, 216, '29.03.2021'), (197, 18, 174, '29.03.2021'), (198, 18, 175, '29.03.2021'), (199, 18, 223, '29.03.2021'), (200, 18, 228, '29.03.2021'), (201, 18, 177, '29.03.2021'), (202, 18, 237, '03.04.2021'), (203, 18, 231, '03.04.2021'), (204, 18, 238, '03.04.2021'), (205, 18, 71, '03.04.2021'), (206, 18, 217, '03.04.2021'), (207, 18, 72, '03.04.2021'), (208, 18, 203, '03.04.2021'), (209, 18, 148, '03.04.2021'), (210, 18, 152, '03.04.2021'), (211, 18, 85, '04.04.2021'), (212, 18, 200, '04.04.2021'), (213, 18, 264, '04.04.2021'), (214, 18, 225, '06.04.2021'), (215, 18, 230, '06.04.2021'), (216, 18, 236, '06.04.2021'), (217, 18, 239, '06.04.2021'), (218, 18, 240, '06.04.2021'), (219, 18, 242, '06.04.2021'), (220, 18, 226, '06.04.2021'), (221, 18, 246, '06.04.2021'), (222, 18, 247, '06.04.2021'), (223, 18, 248, '06.04.2021'), (224, 18, 256, '06.04.2021'), (225, 18, 257, '06.04.2021'), (226, 18, 258, '06.04.2021'), (227, 18, 147, '06.04.2021'), (228, 18, 119, '06.04.2021'), (229, 18, 90, '06.04.2021'), (230, 18, 148, '06.04.2021'), (231, 18, 217, '06.04.2021'), (232, 18, 149, '06.04.2021'), (233, 18, 85, '06.04.2021'), (234, 18, 95, '06.04.2021'), (235, 18, 252, '06.04.2021'), (236, 18, 104, '06.04.2021'), (237, 18, 160, '06.04.2021'), (238, 18, 157, '06.04.2021'), (239, 18, 204, '06.04.2021'), (240, 18, 71, '06.04.2021'), (241, 18, 159, '06.04.2021'), (242, 38, 165, '08.04.2021'), (243, 18, 186, '10.04.2021'), (244, 18, 126, '10.04.2021'), (245, 18, 208, '10.04.2021'), (246, 18, 194, '10.04.2021'), (247, 18, 210, '10.04.2021'), (248, 18, 205, '15.04.2021'), (249, 18, 163, '15.04.2021'), (250, 18, 72, '15.04.2021'), (251, 18, 133, '15.04.2021'), (252, 18, 191, '15.04.2021'), (253, 18, 150, '15.04.2021'), (254, 18, 218, '15.04.2021'), (255, 18, 206, '15.04.2021'), (256, 18, 201, '15.04.2021'), (257, 18, 125, '15.04.2021'), (258, 18, 128, '15.04.2021'), (259, 18, 195, '15.04.2021'), (260, 40, 288, '16.04.2021'), (261, 18, 265, '17.04.2021'), (262, 18, 243, '17.04.2021'), (263, 18, 275, '17.04.2021'), (264, 18, 260, '17.04.2021'), (265, 18, 255, '17.04.2021'), (266, 18, 296, '17.04.2021'), (267, 18, 297, '17.04.2021'), (268, 18, 179, '17.04.2021'), (269, 18, 198, '18.04.2021'), (270, 18, 123, '18.04.2021'), (271, 18, 68, '18.04.2021'), (272, 18, 97, '18.04.2021'), (273, 18, 219, '18.04.2021'), (274, 40, 149, '18.04.2021'), (275, 40, 227, '18.04.2021'), (276, 40, 179, '18.04.2021'), (277, 40, 145, '18.04.2021'), (278, 40, 181, '18.04.2021'), (279, 40, 305, '20.04.2021'), (280, 40, 299, '27.04.2021'), (281, 40, 130, '27.04.2021'), (282, 40, 182, '27.04.2021'), (283, 40, 189, '27.04.2021'), (284, 40, 173, '27.04.2021'), (285, 40, 306, '27.04.2021'), (286, 40, 308, '27.04.2021'), (287, 18, 164, '28.04.2021'), (288, 18, 211, '28.04.2021'), (289, 18, 187, '28.04.2021'), (290, 18, 311, '29.04.2021'), (291, 18, 121, '30.04.2021'), (292, 18, 108, '02.05.2021'), (293, 18, 326, '02.05.2021'), (294, 40, 267, '06.05.2021'), (295, 40, 158, '06.05.2021'), (296, 40, 331, '12.05.2021'), (297, 40, 97, '12.05.2021'), (298, 40, 166, '12.05.2021'), (299, 40, 302, '12.05.2021'), (300, 40, 146, '12.05.2021'), (301, 40, 184, '12.05.2021'), (302, 40, 84, '12.05.2021'), (303, 40, 141, '12.05.2021'), (305, 18, 235, '19.05.2021'), (306, 18, 299, '19.05.2021'), (307, 18, 142, '19.05.2021'), (308, 18, 122, '19.05.2021'), (309, 18, 302, '19.05.2021'), (310, 18, 98, '19.05.2021'), (311, 18, 342, '19.05.2021'), (312, 40, 343, '19.05.2021'), (313, 18, 166, '19.05.2021'), (314, 40, 342, '20.05.2021'), (315, 40, 344, '20.05.2021'), (316, 40, 303, '20.05.2021'), (317, 40, 307, '20.05.2021'), (318, 40, 333, '20.05.2021'), (319, 40, 322, '20.05.2021'), (320, 40, 131, '20.05.2021'), (321, 18, 227, '21.05.2021'), (322, 18, 136, '21.05.2021'), (323, 18, 270, '21.05.2021'), (324, 18, 332, '21.05.2021'), (325, 18, 323, '23.05.2021'), (326, 18, 347, '23.05.2021'), (327, 18, 346, '23.05.2021'), (328, 18, 312, '23.05.2021'), (329, 18, 138, '23.05.2021'), (330, 18, 353, '23.05.2021'), (331, 18, 253, '23.05.2021'), (332, 41, 226, '25.05.2021'), (333, 41, 295, '25.05.2021'), (334, 41, 327, '25.05.2021'), (335, 41, 290, '25.05.2021'), (336, 41, 289, '25.05.2021'), (337, 41, 235, '25.05.2021'), (338, 41, 359, '25.05.2021'), (339, 41, 238, '25.05.2021'), (340, 41, 358, '25.05.2021'), (341, 41, 277, '25.05.2021'), (342, 18, 89, '27.05.2021'), (343, 41, 265, '27.05.2021'), (344, 41, 336, '27.05.2021'), (345, 41, 275, '27.05.2021'), (346, 41, 260, '27.05.2021'), (347, 41, 255, '27.05.2021'), (348, 41, 282, '27.05.2021'), (349, 41, 274, '27.05.2021'), (350, 18, 290, '05.06.2021'), (351, 41, 244, '05.06.2021'), (352, 41, 251, '05.06.2021'), (353, 41, 270, '05.06.2021'), (354, 41, 330, '05.06.2021'), (355, 41, 136, '05.06.2021'), (356, 18, 289, '06.06.2021'), (357, 18, 398, '06.06.2021'), (358, 18, 294, '06.06.2021'), (359, 18, 399, '06.06.2021'), (360, 18, 281, '06.06.2021'), (361, 18, 283, '06.06.2021'), (362, 18, 359, '06.06.2021'), (363, 40, 359, '06.06.2021'), (364, 41, 273, '06.06.2021'), (365, 18, 404, '06.06.2021'), (366, 41, 401, '06.06.2021'), (367, 41, 296, '06.06.2021'), (368, 40, 220, '06.06.2021'), (369, 40, 396, '06.06.2021'), (370, 40, 358, '24.06.2021'), (371, 18, 358, '24.06.2021'), (372, 18, 282, '24.06.2021'), (373, 40, 282, '24.06.2021'), (374, 18, 319, '24.06.2021'), (375, 18, 393, '24.06.2021'), (376, 18, 145, '30.06.2021'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `users` -- CREATE TABLE `users` ( `id` int(10) NOT NULL, `username` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `rstcode` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, `is_premium` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Daten für Tabelle `users` -- INSERT INTO `users` (`id`, `username`, `email`, `password`, `rstcode`, `is_premium`) VALUES (1, 'test', 'test@gmail.com', 'b1d58cdf3b01507e9165cb3ab3f8a6631abd8d89c4076981bf488add27b41b3d', '445-191', 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `viewedprobs` -- CREATE TABLE `viewedprobs` ( `i` int(15) NOT NULL, `user_id` int(10) NOT NULL, `prob_id` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- -- Daten für Tabelle `viewedprobs` -- INSERT INTO `viewedprobs` (`i`, `user_id`, `prob_id`) VALUES (99, 36, 100), (98, 1, 94), (97, 1, 89), (96, 1, 116), (95, 1, 68), (94, 1, 78), (93, 1, 119), (92, 1, 100), (91, 1, 101), (90, 1, 121), (89, 1, 97), (88, 1, 77), (87, 1, 117), (86, 1, 115), (85, 1, 119), (84, 1, 109), (83, 1, 85), (82, 1, 95), (81, 1, 104), (80, 1, 90), (100, 36, 90), (101, 36, 117), (102, 37, 121), (103, 37, 99), (104, 37, 114), (105, 20, 104), (106, 20, 109), (107, 20, 108), (108, 1, 109), (109, 1, 119), (110, 1, 85), (111, 1, 101), (112, 1, 84), (113, 1, 98), (114, 1, 115), (115, 1, 106), (116, 1, 68), (117, 37, 98), (118, 37, 72), (119, 37, 77), (120, 37, 94), (121, 1, 95), (122, 18, 94), (123, 18, 72), (124, 18, 67), (125, 18, 86), (126, 18, 87), (127, 18, 121), (128, 18, 83), (129, 18, 98), (130, 18, 122), (131, 1, 83), (132, 1, 122), (133, 38, 85), (134, 1, 123), (135, 38, 126), (136, 38, 130), (137, 38, 84), (138, 38, 115), (139, 38, 127), (140, 1, 131), (141, 1, 132), (142, 1, 130), (143, 1, 67), (144, 1, 137), (145, 1, 134), (146, 18, 132), (147, 18, 139), (148, 18, 137), (149, 18, 138), (150, 18, 135), (151, 18, 128), (152, 1, 139), (153, 1, 135), (154, 1, 136), (155, 1, 130), (156, 1, 138), (157, 1, 129), (158, 1, 102), (159, 1, 107), (160, 1, 71), (161, 1, 120), (162, 1, 67), (163, 1, 134), (164, 1, 139), (165, 1, 114), (166, 1, 140), (167, 18, 77), (168, 18, 78), (169, 18, 130), (170, 18, 146), (171, 18, 108), (172, 18, 129), (173, 18, 131), (174, 18, 136), (175, 1, 142), (176, 1, 141), (177, 1, 144), (178, 1, 145), (179, 18, 134), (180, 38, 83), (181, 38, 128), (182, 38, 131), (183, 18, 119), (184, 18, 95), (185, 18, 107), (186, 18, 142), (187, 18, 123), (188, 18, 68), (189, 18, 149), (190, 18, 124), (191, 18, 126), (192, 1, 149), (193, 1, 150), (194, 1, 151), (195, 1, 127), (196, 1, 158), (197, 1, 148), (198, 1, 126), (199, 1, 159), (200, 1, 160), (201, 1, 162), (202, 18, 147), (203, 18, 159), (204, 1, 123), (205, 1, 156), (206, 1, 96), (207, 20, 142), (208, 20, 77), (209, 18, 162), (210, 20, 161), (211, 18, 161), (212, 20, 130), (213, 18, 109), (214, 20, 141), (215, 18, 141), (216, 18, 127), (217, 20, 145), (218, 18, 133), (219, 18, 156), (220, 1, 161), (221, 1, 164), (222, 1, 163), (223, 18, 164), (224, 18, 152), (225, 1, 166), (226, 1, 146), (227, 1, 155), (228, 38, 158), (229, 38, 129), (230, 38, 168), (231, 38, 157), (232, 38, 146), (233, 38, 108), (234, 38, 145), (235, 1, 124), (236, 1, 105), (237, 1, 107), (238, 1, 124), (239, 1, 94), (240, 1, 148), (241, 1, 173), (242, 18, 163), (243, 18, 165), (244, 18, 158), (245, 18, 170), (246, 18, 120), (247, 18, 140), (248, 1, 177), (249, 1, 108), (250, 1, 174), (251, 18, 178), (252, 20, 84), (253, 20, 78), (254, 20, 158), (255, 1, 182), (256, 1, 183), (257, 1, 184), (258, 1, 171), (259, 1, 179), (260, 38, 102), (261, 38, 182), (262, 38, 122), (263, 1, 190), (264, 38, 190), (265, 18, 90), (266, 18, 73), (267, 18, 148), (268, 18, 150), (269, 18, 104), (270, 18, 179), (271, 1, 160), (272, 18, 185), (273, 18, 114), (274, 18, 188), (275, 18, 157), (276, 18, 189), (277, 1, 186), (278, 18, 153), (279, 18, 89), (280, 18, 100), (281, 18, 166), (282, 18, 155), (283, 39, 142), (284, 39, 191), (285, 1, 191), (286, 1, 181), (287, 18, 191), (288, 18, 160), (289, 1, 194), (290, 1, 192), (291, 1, 189), (292, 1, 99), (293, 38, 181), (294, 1, 199), (295, 1, 195), (296, 1, 196), (297, 18, 199), (298, 18, 186), (299, 18, 85), (300, 18, 177), (301, 18, 212), (302, 18, 201), (303, 18, 173), (304, 18, 145), (305, 18, 181), (306, 18, 182), (307, 18, 202), (308, 18, 214), (309, 39, 90), (310, 39, 95), (311, 39, 149), (312, 39, 85), (313, 39, 160), (314, 39, 187), (315, 18, 197), (316, 18, 205), (317, 1, 209), (318, 1, 215), (319, 1, 210), (320, 18, 218), (321, 1, 218), (322, 38, 212), (323, 18, 193), (324, 18, 198), (325, 18, 203), (326, 1, 145), (327, 1, 160), (328, 1, 133), (329, 18, 142), (330, 18, 85), (331, 18, 186), (332, 18, 166), (333, 18, 160), (334, 18, 181), (335, 18, 68), (336, 18, 116), (337, 18, 89), (338, 18, 67), (339, 18, 123), (340, 18, 172), (341, 18, 185), (342, 18, 216), (343, 18, 156), (344, 18, 152), (345, 18, 219), (346, 1, 172), (347, 1, 212), (348, 1, 217), (349, 1, 222), (350, 1, 187), (351, 18, 222), (352, 18, 122), (353, 18, 192), (354, 18, 99), (355, 18, 73), (356, 18, 209), (357, 18, 204), (358, 18, 164), (359, 18, 205), (360, 18, 165), (361, 18, 201), (362, 18, 86), (363, 18, 188), (364, 18, 163), (365, 18, 124), (366, 18, 147), (367, 18, 133), (368, 18, 150), (369, 18, 203), (370, 18, 193), (371, 18, 94), (372, 18, 154), (373, 18, 223), (374, 18, 226), (375, 18, 225), (376, 18, 224), (377, 18, 171), (378, 18, 173), (379, 18, 170), (380, 18, 174), (381, 18, 175), (382, 18, 176), (383, 18, 228), (384, 18, 177), (385, 18, 191), (386, 18, 153), (387, 1, 223), (388, 1, 226), (389, 1, 225), (390, 20, 173), (391, 18, 127), (392, 18, 180), (393, 18, 208), (394, 18, 210), (395, 18, 229), (396, 18, 130), (397, 18, 119), (398, 18, 148), (399, 18, 230), (400, 18, 236), (401, 18, 237), (402, 18, 231), (403, 18, 238), (404, 18, 149), (405, 1, 206), (406, 1, 201), (407, 1, 202), (408, 1, 252), (409, 18, 245), (410, 18, 71), (411, 18, 217), (412, 18, 72), (413, 18, 244), (414, 18, 189), (415, 18, 251), (416, 18, 200), (417, 18, 264), (418, 1, 253), (419, 1, 238), (420, 18, 260), (421, 18, 254), (422, 18, 198), (423, 18, 233), (424, 18, 183), (425, 18, 227), (426, 1, 261), (427, 1, 229), (428, 1, 237), (429, 1, 251), (430, 18, 225), (431, 18, 226), (432, 18, 230), (433, 18, 236), (434, 18, 239), (435, 18, 240), (436, 18, 242), (437, 18, 246), (438, 18, 247), (439, 18, 248), (440, 18, 256), (441, 18, 257), (442, 18, 258), (443, 20, 222), (444, 18, 262), (445, 18, 147), (446, 20, 180), (447, 18, 119), (448, 18, 90), (449, 18, 148), (450, 18, 217), (451, 18, 149), (452, 18, 85), (453, 18, 95), (454, 18, 252), (455, 18, 104), (456, 18, 160), (457, 18, 222), (458, 18, 157), (459, 18, 140), (460, 18, 136), (461, 18, 204), (462, 1, 264), (463, 18, 211), (464, 18, 159), (465, 1, 211), (466, 1, 153), (467, 18, 268), (468, 18, 267), (469, 18, 266), (470, 18, 265), (471, 18, 237), (472, 18, 238), (473, 18, 244), (474, 18, 255), (475, 18, 260), (476, 38, 193), (477, 38, 165), (478, 18, 264), (479, 38, 198), (480, 18, 190), (481, 18, 221), (482, 38, 267), (483, 18, 135), (484, 18, 186), (485, 18, 115), (486, 18, 126), (487, 18, 208), (488, 18, 194), (489, 18, 210), (490, 18, 131), (491, 18, 214), (492, 18, 181), (493, 18, 168), (494, 18, 270), (495, 18, 235), (496, 18, 166), (497, 1, 178), (498, 1, 269), (499, 1, 274), (500, 18, 177), (501, 18, 234), (502, 18, 261), (503, 18, 245), (504, 18, 250), (505, 18, 275), (506, 18, 276), (507, 18, 259), (508, 18, 224), (509, 18, 137), (510, 18, 162), (511, 18, 284), (512, 18, 269), (513, 18, 286), (514, 18, 287), (515, 18, 205), (516, 18, 272), (517, 18, 165), (518, 18, 72), (519, 18, 191), (520, 18, 73), (521, 18, 231), (522, 18, 241), (523, 18, 133), (524, 18, 150), (525, 18, 218), (526, 18, 215), (527, 18, 206), (528, 18, 201), (529, 18, 125), (530, 18, 128), (531, 18, 195), (532, 18, 83), (533, 38, 287), (534, 38, 284), (535, 40, 223), (536, 40, 229), (537, 40, 173), (538, 40, 166), (539, 40, 288), (540, 18, 243), (541, 18, 278), (542, 18, 296), (543, 18, 297), (544, 18, 179), (545, 18, 145), (546, 18, 98), (547, 18, 288), (548, 18, 198), (549, 18, 123), (550, 18, 68), (551, 18, 185), (552, 18, 120), (553, 18, 97), (554, 18, 219), (555, 18, 106), (556, 18, 102), (557, 18, 197), (558, 18, 107), (559, 40, 149), (560, 40, 227), (561, 40, 179), (562, 40, 161), (563, 40, 145), (564, 40, 127), (565, 40, 182), (566, 40, 181), (567, 38, 270), (568, 38, 235), (569, 38, 219), (570, 38, 279), (571, 38, 157), (572, 38, 128), (573, 38, 267), (574, 38, 301), (575, 38, 285), (576, 18, 303), (577, 18, 180), (578, 18, 305), (579, 40, 305), (580, 38, 304), (581, 38, 297), (582, 38, 294), (583, 38, 288), (584, 18, 209), (585, 18, 220), (586, 18, 298), (587, 18, 141), (588, 18, 108), (589, 18, 289), (590, 18, 67), (591, 18, 152), (592, 18, 134), (593, 18, 263), (594, 18, 158), (595, 18, 304), (596, 40, 299), (597, 40, 130), (598, 40, 189), (599, 40, 180), (600, 40, 109), (601, 40, 306), (602, 40, 308), (603, 18, 164), (604, 18, 187), (605, 18, 100), (606, 18, 188), (607, 18, 116), (608, 18, 172), (609, 18, 228), (610, 18, 307), (611, 18, 154), (612, 18, 294), (613, 18, 310), (614, 18, 311), (615, 18, 300), (616, 18, 170), (617, 38, 303), (618, 1, 306), (619, 1, 134), (620, 1, 175), (621, 1, 185), (622, 1, 105), (623, 1, 150), (624, 1, 135), (625, 1, 121), (626, 1, 195), (627, 18, 121), (628, 1, 132), (629, 1, 197), (630, 18, 290), (631, 18, 78), (632, 18, 143), (633, 18, 227), (634, 18, 315), (635, 18, 326), (636, 40, 270), (637, 18, 330), (638, 18, 212), (639, 40, 267), (640, 40, 298), (641, 40, 158), (642, 40, 307), (643, 40, 190), (644, 18, 334), (645, 1, 333), (646, 40, 212), (647, 40, 199), (648, 40, 268), (649, 40, 100), (650, 40, 97), (651, 40, 102), (652, 40, 331), (653, 40, 302), (654, 40, 77), (655, 40, 146), (656, 40, 184), (657, 40, 141), (658, 40, 301), (659, 40, 83), (660, 40, 84), (661, 18, 202), (662, 41, 305), (663, 41, 136), (664, 41, 168), (665, 41, 212), (666, 1, 284), (667, 20, 343), (668, 20, 219), (669, 18, 299), (670, 18, 142), (671, 18, 122), (672, 18, 302), (673, 40, 98), (674, 18, 342), (675, 18, 343), (676, 40, 343), (677, 18, 178), (678, 18, 332), (679, 18, 344), (680, 40, 344), (681, 40, 342), (682, 40, 303), (683, 40, 333), (684, 40, 322), (685, 40, 131), (686, 40, 221), (687, 40, 266), (688, 18, 323), (689, 18, 182), (690, 18, 335), (691, 18, 301), (692, 18, 312), (693, 18, 353), (694, 41, 105), (695, 41, 90), (696, 41, 353), (697, 18, 352), (698, 18, 331), (699, 40, 352), (700, 18, 347), (701, 18, 346), (702, 18, 336), (703, 18, 138), (704, 18, 253), (705, 1, 332), (706, 1, 335), (707, 1, 208), (708, 1, 361), (709, 1, 321), (710, 1, 125), (711, 1, 383), (712, 1, 285), (713, 1, 152), (714, 1, 387), (715, 1, 376), (716, 1, 86), (717, 1, 384), (718, 1, 263), (719, 1, 207), (720, 1, 364), (721, 18, 360), (722, 41, 338), (723, 41, 226), (724, 41, 295), (725, 41, 327), (726, 41, 290), (727, 41, 289), (728, 41, 235), (729, 41, 359), (730, 41, 238), (731, 41, 358), (732, 41, 277), (733, 41, 116), (734, 18, 89), (735, 18, 382), (736, 18, 355), (737, 18, 193), (738, 41, 265), (739, 41, 336), (740, 41, 275), (741, 41, 260), (742, 41, 255), (743, 41, 282), (744, 41, 274), (745, 18, 390), (746, 41, 244), (747, 41, 251), (748, 41, 270), (749, 41, 330), (750, 41, 222), (751, 18, 398), (752, 18, 399), (753, 18, 281), (754, 18, 371), (755, 18, 379), (756, 18, 359), (757, 40, 377), (758, 40, 359), (759, 41, 273), (760, 18, 404), (761, 18, 173), (762, 41, 401), (763, 41, 296), (764, 18, 396), (765, 40, 220), (766, 40, 396), (767, 40, 129), (768, 40, 358), (769, 18, 358), (770, 18, 282), (771, 40, 282), (772, 18, 319), (773, 18, 254), (774, 18, 393), (775, 18, 405), (776, 18, 377), (777, 18, 189), (778, 18, 109), (779, 18, 130); -- -- Indizes der exportierten Tabellen -- -- -- Indizes für die Tabelle `graderatings` -- ALTER TABLE `graderatings` ADD PRIMARY KEY (`i`); -- -- Indizes für die Tabelle `probs` -- ALTER TABLE `probs` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `progressprobs` -- ALTER TABLE `progressprobs` ADD PRIMARY KEY (`i`); -- -- Indizes für die Tabelle `solvedprobs` -- ALTER TABLE `solvedprobs` ADD PRIMARY KEY (`i`); -- -- Indizes für die Tabelle `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indizes für die Tabelle `viewedprobs` -- ALTER TABLE `viewedprobs` ADD PRIMARY KEY (`i`); -- -- AUTO_INCREMENT für exportierte Tabellen -- -- -- AUTO_INCREMENT für Tabelle `graderatings` -- ALTER TABLE `graderatings` MODIFY `i` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=491; -- -- AUTO_INCREMENT für Tabelle `probs` -- ALTER TABLE `probs` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=413; -- -- AUTO_INCREMENT für Tabelle `progressprobs` -- ALTER TABLE `progressprobs` MODIFY `i` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT für Tabelle `solvedprobs` -- ALTER TABLE `solvedprobs` MODIFY `i` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=377; -- -- AUTO_INCREMENT für Tabelle `users` -- ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT für Tabelle `viewedprobs` -- ALTER TABLE `viewedprobs` MODIFY `i` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=780; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;