[platal.git] / upgrade / 1.1.4 / 03_watch_group.sql

CREATE TABLE watch_group (
  uid int(11) unsigned NOT NULL DEFAULT '0',
  groupid smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (uid, groupid),
  CONSTRAINT FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT FOREIGN KEY (groupid) REFERENCES groups (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
fe286e5f SJ	1	CREATE TABLE watch_group (
	2	uid int(11) unsigned NOT NULL DEFAULT '0',
	3	groupid smallint(5) unsigned NOT NULL DEFAULT '0',
	4	PRIMARY KEY (uid, groupid),
	5	CONSTRAINT FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
	6	CONSTRAINT FOREIGN KEY (groupid) REFERENCES groups (id) ON DELETE CASCADE ON UPDATE CASCADE
	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	8
	9	-- vim:set syntax=mysql: