upgrade/newdirectory-0.0.1/14_watchnames.sql

   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: