1 DROP TABLE IF EXISTS profile_modifications
;
3 CREATE TABLE profile_modifications (
6 field
VARCHAR(60) NOT NULL,
9 pub
ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
10 PRIMARY KEY(pid
, uid
, field
)
11 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
13 -- vim:set syntax=mysql: