Commit | Line | Data |
---|---|---|
a0fce0c6 SJ |
1 | DROP TABLE IF EXISTS profile_modifications; |
2 | ||
3 | CREATE TABLE profile_modifications ( | |
4 | pid INT(11) NOT NULL, | |
5 | uid INT(11) NOT NULL, | |
6 | field VARCHAR(60) NOT NULL, | |
7 | oldText TEXT NOT NULL, | |
8 | newText TEXT NOT NULL, | |
9 | pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private', | |
10 | PRIMARY KEY(pid, uid, field) | |
11 | ) ENGINE=InnoDB, CHARSET=utf8; | |
12 | ||
13 | -- vim:set syntax=mysql: |