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

# Creates a new table to store websites trusted by each user
CREATE TABLE IF NOT EXISTS `openid_trusted` (
  id       INTEGER UNSIGNED NOT NULL auto_increment,
  # user_id == NULL means a globally trusted website
  user_id  INTEGER,
  url      VARCHAR(256) NOT NULL,
  PRIMARY KEY id_pk(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
7eaf07e9 AA	2	CREATE TABLE IF NOT EXISTS `openid_trusted` (
b8f1396f	3	id INTEGER UNSIGNED NOT NULL auto_increment,
7eaf07e9 AA	4	# user_id == NULL means a globally trusted website
	5	user_id INTEGER,
	6	url VARCHAR(256) NOT NULL,
b8f1396f	7	PRIMARY KEY id_pk(id),
7eaf07e9 AA	8	UNIQUE INDEX user_id_url_index(user_id, url)
	9	) CHARSET=utf8;
	10
	11	# vim:set syntax=mysql: