1 DROP TABLE IF EXISTS profile_modifications
;
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,
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
;
15 -- vim:set syntax=mysql: