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 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: