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

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)
);

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