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: