Commit | Line | Data |
---|---|---|
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: |