[platal.git] / upgrade / 1.0.1 / 12_profiles.sql

DROP TABLE IF EXISTS profile_modifications;

CREATE TABLE profile_modifications (
  pid INT(11) UNSIGNED DEFAULT NULL,
  uid INT(11) UNSIGNED DEFAULT NULL,
  field VARCHAR(60) NOT NULL,
  oldText TEXT NOT NULL,
  newText TEXT NOT NULL,
  pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
  PRIMARY KEY(pid, uid, field)
  FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB, CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
a0fce0c6 SJ	1	DROP TABLE IF EXISTS profile_modifications;
	2
	3	CREATE TABLE profile_modifications (
f73d9281 FB	4	pid INT(11) UNSIGNED DEFAULT NULL,
f73d9281 FB	5	uid INT(11) UNSIGNED DEFAULT NULL,
a0fce0c6 SJ	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)
60db728a SJ	11	FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
60db728a SJ	12	FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
a0fce0c6 SJ	13	) ENGINE=InnoDB, CHARSET=utf8;
	14
	15	-- vim:set syntax=mysql: