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
6 url
VARCHAR(256) NOT NULL,
8 UNIQUE INDEX user_id_url_index(user_id
, url
)
11 # vim
:set syntax
=mysql
: