upgrade/0.9.16/00_profile.sql

   1 create table watch_profile (
   2   uid int(5) unsigned not null,
   3   ts timestamp not null default CURRENT_TIMESTAMP,
   4   field enum('nom', 'freetext', 'mobile', 'nationalite', 'nick', 'web', 'appli1', 'appli2',
   5              'addresses', 'section', 'binets', 'medals', 'cv', 'jobs', 'photo'),
   6
   7   primary key field (uid, field)
   8 ) charset=utf8;
   9
  10 # vim:set syntax=mysql: