upgrade/0.10.0/04_openid.sql

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