[platal.git] / upgrade / account / 02_carnet.sql

drop table if exists watch;
create table watch (
  uid   int(6) not null,
  flags set('contacts', 'mail') not null default 'contacts',
  actions set('profile', 'registration', 'death', 'birthday') not null default '',
  last  timestamp not null default '0000-00-00',

  primary key uid (uid),
  key flags (flags)
) ENGINE=InnoDB, CHARSET=utf8;

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