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

DROP TABLE IF EXISTS profile_modifications;

CREATE TABLE profile_modifications (
  pid INT(11) NOT NULL,
  uid INT(11) NOT 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)
) 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 (
	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: