Commit | Line | Data |
---|---|---|
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 | ||
11 | # vim:set syntax=mysql: |