upgrade/1.0.1/12_profiles.sql

   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: