Commit | Line | Data |
---|---|---|
86c104d1 SJ |
1 | ALTER TABLE watch_profile |
2 | MODIFY field ENUM('search_names', 'nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3', | |
3 | 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals', | |
4 | 'cv', 'jobs', 'photo', 'corps'); | |
981d6bb2 SJ |
5 | |
6 | UPDATE watch_profile SET field = 'search_names' WHERE field = 'nom' OR field = 'nick'; | |
7 | ||
86c104d1 SJ |
8 | ALTER TABLE watch_profile |
9 | MODIFY field ENUM('search_names', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3', | |
10 | 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals', | |
11 | 'cv', 'jobs', 'photo', 'corps'); | |
981d6bb2 SJ |
12 | |
13 | # vim:set syntax=mysql: |