[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
	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 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);
	151
	152	-- vim:set syntax=mysql: