[platal.git] / upgrade / 1.0.2 / 05_educations.sql

-- Fixes error about duplicated Stuttgart University.
UPDATE IGNORE  profile_education_degree
          SET  eduid = 51
        WHERE  eduid = 212;
UPDATE  profile_education
   SET  eduid = 51
 WHERE  eduid = 212;
DELETE FROM profile_education_enum WHERE id = 212;

-- Inserts missing couple (education, degree) required by AX data.
INSERT IGNORE INTO  profile_education_degree (eduid, degreeid)
            VALUES  (184, 1),
                    (267, 1),
                    (247, 1),
                    (189, 1),
                    (190, 1),
                    (191, 1),
                    (192, 1),
                    (244, 1),
                    (193, 1),
                    (245, 1),
                    (194, 1),
                    (243, 1),
                    (195, 1),
                    (196, 1),
                    (197, 1),
                    (246, 1),
                    (205, 1),
                    (183, 1),
                    (233, 2),
                    (236, 2),
                    (187, 2),
                    (235, 2),
                    (188, 2),
                    (185, 2),
                    (238, 2),
                    (202, 2),
                    (46, 2),
                    (51, 2),
                    (213, 2),
                    (240, 2),
                    (228, 4),
                    (268, 4),
                    (218, 4),
                    (232, 4),
                    (226, 4),
                    (219, 4),
                    (229, 4),
                    (151, 4),
                    (175, 4),
                    (214, 4),
                    (133, 4),
                    (69, 4),
                    (241, 4),
                    (1, 4),
                    (127, 5),
                    (63, 5),
                    (222, 5),
                    (230, 5),
                    (217, 5),
                    (215, 5),
                    (220, 5),
                    (164, 5),
                    (221, 5),
                    (265, 5),
                    (14, 5),
                    (266, 5),
                    (237, 5),
                    (231, 5),
                    (18, 5),
                    (241, 5),
                    (259, 6),
                    (231, 6),
                    (178, 6),
                    (145, 6),
                    (85, 6),
                    (109, 7),
                    (241, 7),
                    (140, 8),
                    (208, 8),
                    (91, 8),
                    (23, 8),
                    (224, 8),
                    (239, 8),
                    (25, 8),
                    (209, 8),
                    (223, 8),
                    (61, 8),
                    (171, 8),
                    (204, 8),
                    (242, 8),
                    (108, 11),
                    (252, 11),
                    (151, 14),
                    (234, 14),
                    (108, 14),
                    (91, 14),
                    (92, 14),
                    (62, 16),
                    (22, 16),
                    (225, 16),
                    (84, 16),
                    (206, 16),
                    (92, 17),
                    (92, 18),
                    (210, 18),
                    (71, 18),
                    (83, 19),
                    (216, 21),
                    (119, 21),
                    (104, 22),
                    (20, 24),
                    (23, 25),
                    (99, 27),
                    (12, 28),
                    (97, 31),
                    (32, 31),
                    (23, 31),
                    (31, 33),
                    (24, 33),
                    (20, 33),
                    (62, 33),
                    (86, 33),
                    (69, 33),
                    (207, 33),
                    (27, 33),
                    (110, 33),
                    (30, 33),
                    (12, 33),
                    (75, 33),
                    (79, 33),
                    (128, 33),
                    (175, 33),
                    (28, 33),
                    (166, 33),
                    (1, 33),
                    (74, 33),
                    (65, 33),
                    (124, 33),
                    (82, 33),
                    (43, 33),
                    (72, 33),
                    (46, 33),
                    (77, 33),
                    (22, 33),
                    (81, 33),
                    (93, 33),
                    (76, 33),
                    (92, 33),
                    (145, 33);

-- vim:set syntax=mysql:
Commit	Line	Data
dbe3674d SJ	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.
a8cfc697 SJ	11	INSERT IGNORE 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);
dbe3674d SJ	151
dbe3674d SJ	152	-- vim:set syntax=mysql: