| 1 | -- Fixes error about duplicated Stuttgart University. |
| 2 | UPDATE IGNORE profile_education_degree |
| 3 | SET eduid = 51 |
| 4 | WHERE eduid = 212; |
| 5 | UPDATE profile_education |
| 6 | SET eduid = 51 |
| 7 | WHERE eduid = 212; |
| 8 | DELETE FROM profile_education_enum WHERE id = 212; |
| 9 | |
| 10 | -- Inserts missing couple (education, degree) required by AX data. |
| 11 | INSERT INTO profile_education_degree (eduid, degreeid) |
| 12 | VALUES (184, 1), |
| 13 | (267, 1), |
| 14 | (247, 1), |
| 15 | (189, 1), |
| 16 | (190, 1), |
| 17 | (191, 1), |
| 18 | (192, 1), |
| 19 | (244, 1), |
| 20 | (193, 1), |
| 21 | (245, 1), |
| 22 | (194, 1), |
| 23 | (243, 1), |
| 24 | (195, 1), |
| 25 | (196, 1), |
| 26 | (197, 1), |
| 27 | (246, 1), |
| 28 | (205, 1), |
| 29 | (183, 1), |
| 30 | (233, 2), |
| 31 | (236, 2), |
| 32 | (187, 2), |
| 33 | (235, 2), |
| 34 | (188, 2), |
| 35 | (185, 2), |
| 36 | (238, 2), |
| 37 | (202, 2), |
| 38 | (46, 2), |
| 39 | (51, 2), |
| 40 | (213, 2), |
| 41 | (240, 2), |
| 42 | (228, 4), |
| 43 | (268, 4), |
| 44 | (218, 4), |
| 45 | (232, 4), |
| 46 | (226, 4), |
| 47 | (219, 4), |
| 48 | (229, 4), |
| 49 | (151, 4), |
| 50 | (175, 4), |
| 51 | (214, 4), |
| 52 | (133, 4), |
| 53 | (69, 4), |
| 54 | (241, 4), |
| 55 | (1, 4), |
| 56 | (127, 5), |
| 57 | (63, 5), |
| 58 | (222, 5), |
| 59 | (230, 5), |
| 60 | (217, 5), |
| 61 | (215, 5), |
| 62 | (220, 5), |
| 63 | (164, 5), |
| 64 | (221, 5), |
| 65 | (265, 5), |
| 66 | (14, 5), |
| 67 | (266, 5), |
| 68 | (237, 5), |
| 69 | (231, 5), |
| 70 | (18, 5), |
| 71 | (241, 5), |
| 72 | (259, 6), |
| 73 | (231, 6), |
| 74 | (178, 6), |
| 75 | (145, 6), |
| 76 | (85, 6), |
| 77 | (109, 7), |
| 78 | (241, 7), |
| 79 | (140, 8), |
| 80 | (208, 8), |
| 81 | (91, 8), |
| 82 | (23, 8), |
| 83 | (224, 8), |
| 84 | (239, 8), |
| 85 | (25, 8), |
| 86 | (209, 8), |
| 87 | (223, 8), |
| 88 | (61, 8), |
| 89 | (171, 8), |
| 90 | (204, 8), |
| 91 | (242, 8), |
| 92 | (108, 11), |
| 93 | (252, 11), |
| 94 | (151, 14), |
| 95 | (234, 14), |
| 96 | (108, 14), |
| 97 | (91, 14), |
| 98 | (92, 14), |
| 99 | (62, 16), |
| 100 | (22, 16), |
| 101 | (225, 16), |
| 102 | (84, 16), |
| 103 | (206, 16), |
| 104 | (92, 17), |
| 105 | (92, 18), |
| 106 | (210, 18), |
| 107 | (71, 18), |
| 108 | (83, 19), |
| 109 | (216, 21), |
| 110 | (119, 21), |
| 111 | (104, 22), |
| 112 | (20, 24), |
| 113 | (23, 25), |
| 114 | (99, 27), |
| 115 | (12, 28), |
| 116 | (97, 31), |
| 117 | (32, 31), |
| 118 | (23, 31), |
| 119 | (31, 33), |
| 120 | (24, 33), |
| 121 | (20, 33), |
| 122 | (62, 33), |
| 123 | (86, 33), |
| 124 | (69, 33), |
| 125 | (207, 33), |
| 126 | (27, 33), |
| 127 | (110, 33), |
| 128 | (30, 33), |
| 129 | (12, 33), |
| 130 | (75, 33), |
| 131 | (79, 33), |
| 132 | (128, 33), |
| 133 | (175, 33), |
| 134 | (28, 33), |
| 135 | (166, 33), |
| 136 | (1, 33), |
| 137 | (74, 33), |
| 138 | (65, 33), |
| 139 | (124, 33), |
| 140 | (82, 33), |
| 141 | (43, 33), |
| 142 | (72, 33), |
| 143 | (46, 33), |
| 144 | (77, 33), |
| 145 | (22, 33), |
| 146 | (81, 33), |
| 147 | (93, 33), |
| 148 | (76, 33), |
| 149 | (92, 33), |
| 150 | (145, 33); |
| 151 | |
| 152 | -- vim:set syntax=mysql: |