upgrade/1.0.1/01_profiles.sql

   1 DROP TABLE IF EXISTS profile_modifications;
   2
   3 CREATE TABLE profile_modifications (
   4   pid INT(11) NOT NULL,
   5   uid INT(11) NOT 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 ) ENGINE=InnoDB, CHARSET=utf8;
  12
  13 -- vim:set syntax=mysql: