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