| 1 | -- Updates promo for oranjes who only stated their orajisation to AX. |
| 2 | -- WARNING: this does not affect the display of their promotion anywhere. It will just allow them to attend events to both promotions. |
| 3 | -- Also they will not need to require a validation if they want to change promo on the site. |
| 4 | |
| 5 | UPDATE profile_education |
| 6 | SET grad_year = grad_year + 1 |
| 7 | WHERE FIND_IN_SET('primary', flags) AND pid IN (41342, 41581, 41670, 42220, 43438, 43529, 43699); |
| 8 | |
| 9 | -- Same as before but double orajisation. |
| 10 | UPDATE profile_education |
| 11 | SET grad_year = grad_year + 2 |
| 12 | WHERE FIND_IN_SET('primary', flags) AND pid IN (41441, 42307); |
| 13 | |
| 14 | -- vim:set syntax=mysql:; |