upgrade/0.9.18/04_openid.sql

   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: