db8c66782343391afda94d70f86d2656ff820c6b
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');
6 UPDATE watch_profile
SET field
= 'search_names' WHERE field
= 'nom' OR field
= 'nick';
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');
13 # vim
:set syntax
=mysql
: