diff options
author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-03-27 20:14:38 +0200 |
---|---|---|
committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-03-27 20:15:34 +0200 |
commit | 285529a532743d52af94d3d571178a413dd944c8 (patch) | |
tree | 1d25919aba233f3cde3c98dfab0f987dafb878b0 /schema.sql | |
parent | 89e5ee140a4becefa4d4023102107727c5921efb (diff) |
Implement BrowserID-based login.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
@@ -21,6 +21,13 @@ CREATE TABLE openids( FOREIGN KEY("user") REFERENCES users ); +CREATE TABLE user_email_addresses( + "user" INTEGER NOT NULL, + email VARCHAR NOT NULL, + PRIMARY KEY(email), + FOREIGN KEY("user") REFERENCES users +); + CREATE TABLE page_keys( "user" INTEGER NOT NULL, page VARCHAR NOT NULL, |