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