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 | |
12 | # vim:set syntax=mysql: |