[platal.git] / upgrade / 0.9.18 / 04_openid.sql

# Creates a new table to store websites trusted by each user
CREATE TABLE IF NOT EXISTS `openid_trusted` (
  # user_id == NULL means a globally trusted website
  user_id  INTEGER,
  url      VARCHAR(256) NOT NULL,
  INDEX user_id_index(user_id),
  UNIQUE INDEX user_id_url_index(user_id, url)
) CHARSET=utf8;

# vim:set syntax=mysql:
Commit	Line	Data
7eaf07e9 AA	1	# Creates a new table to store websites trusted by each user
	2	CREATE TABLE IF NOT EXISTS `openid_trusted` (
	3	# user_id == NULL means a globally trusted website
	4	user_id INTEGER,
	5	url VARCHAR(256) NOT NULL,
	6	INDEX user_id_index(user_id),
	7	UNIQUE INDEX user_id_url_index(user_id, url)
	8	) CHARSET=utf8;
	9
	10	# vim:set syntax=mysql: