upgrade/1.0.1/xxx.educations.sql

   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: