Commit | Line | Data |
---|---|---|
8450c2aa SJ |
1 | ALTER TABLE auth_user_md5 ADD COLUMN nationalite2 CHAR(2) DEFAULT NULL, |
2 | ADD COLUMN nationalite3 CHAR(2) DEFAULT NULL, | |
3 | ADD KEY nationalite2 (nationalite2), | |
4 | ADD KEY nationalite3 (nationalite3), | |
5 | MODIFY nationalite CHAR(2) DEFAULT NULL; | |
6 | ||
7 | UPDATE auth_user_md5 SET nationalite=NULL WHERE nationalite="00" OR nationalite=''; | |
8 | ||
9 | DELETE FROM geoloc_pays WHERE a2="00"; | |
10 | ||
3a703848 SJ |
11 | ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', 'nationalite3', |
12 | 'nick', 'web', 'networking', 'appli1', 'appli2', 'addresses', | |
13 | 'section', 'binets', 'medals', 'cv', 'jobs', 'photo'); | |
14 | ||
8450c2aa | 15 | # vim:set syntax=mysql: |