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` ( | |
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: |