upgrade/account/02_carnet.sql

   1 drop table if exists watch;
   2 create table watch (
   3   uid   int(6) not null,
   4   flags set('contacts', 'mail') not null default 'contacts',
   5   actions set('profile', 'registration', 'death', 'birthday') not null default '',
   6   last  timestamp not null default '0000-00-00',
   7
   8   primary key uid (uid),
   9   key flags (flags)
  10 ) ENGINE=InnoDB, CHARSET=utf8;
  11
  12 # vim:set syntax=mysql: