Commit | Line | Data |
---|---|---|
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: |