Commit | Line | Data |
---|---|---|
caa04db8 SJ |
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:; |