From 7c082abec97e1ca5090a9b5d0956d53549d19a9f Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sun, 1 Jul 2012 15:11:25 +0200 Subject: Support WebID login for registered users. --- schema.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 96b53a3..4170b3b 100644 --- a/schema.sql +++ b/schema.sql @@ -21,6 +21,13 @@ CREATE TABLE openids( FOREIGN KEY("user") REFERENCES users ); +CREATE TABLE webids( + "user" INTEGER NOT NULL, + webid VARCHAR NOT NULL, + PRIMARY KEY(webid), + FOREIGN KEY("user") REFERENCES users +); + CREATE TABLE rsa_keys( modulus NUMERIC NOT NULL, exponent NUMERIC NOT NULL, -- cgit v1.2.3