| 1 | DROP TABLE IF EXISTS profile_modifications; |
| 2 | |
| 3 | CREATE TABLE profile_modifications ( |
| 4 | pid INT(11) UNSIGNED DEFAULT NULL, |
| 5 | uid INT(11) UNSIGNED DEFAULT 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 | FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE, |
| 12 | FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE |
| 13 | ) ENGINE=InnoDB, CHARSET=utf8; |
| 14 | |
| 15 | -- vim:set syntax=mysql: |