[platal.git] / upgrade / 1.1.4 / 06_hobby.sql

CREATE TABLE profile_hobby (
  pid INT(11) UNSIGNED NOT NULL DEFAULT 0,
  id TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of the hobby for the user',
  type ENUM('Sport', 'Loisir', 'Hobby') NOT NULL DEFAULT 'Hobby',
  text VARCHAR(255) NOT NULL DEFAULT '',
  pub ENUM('hidden','private','ax','public') NOT NULL DEFAULT 'private',
  PRIMARY KEY (pid, id),
  KEY pid (pid),
  CONSTRAINT FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
8fcfc71f SJ	1	CREATE TABLE profile_hobby (
	2	pid INT(11) UNSIGNED NOT NULL DEFAULT 0,
	3	id TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of the hobby for the user',
	4	type ENUM('Sport', 'Loisir', 'Hobby') NOT NULL DEFAULT 'Hobby',
	5	text VARCHAR(255) NOT NULL DEFAULT '',
	6	pub ENUM('hidden','private','ax','public') NOT NULL DEFAULT 'private',
	7	PRIMARY KEY (pid, id),
	8	KEY pid (pid),
	9	CONSTRAINT FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
	10	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	11
	12	-- vim:set syntax=mysql: