upgrade/newdirectory-0.0.1/14_watchnames.sql

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