[platal.git] / upgrade / 1.0.1 / xxx.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 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.
	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: