diff options
author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-06-16 17:01:38 +0200 |
---|---|---|
committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2012-06-16 17:01:38 +0200 |
commit | f58ba7296c88ca1c217f0482c18660f701e4a026 (patch) | |
tree | 78970aaaddcc55e901b6a0d10e7136b94731e5cb /schema.sql | |
parent | a6f651c0f9def5efbd0e034514d320818d06e7c6 (diff) |
Permit certificate-based login.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -22,15 +22,15 @@ CREATE TABLE openids( ); CREATE TABLE rsa_keys( - modulus VARCHAR NOT NULL, - exponent VARCHAR NOT NULL, + modulus NUMERIC NOT NULL, + exponent NUMERIC NOT NULL, PRIMARY KEY(modulus, exponent) ); CREATE TABLE user_rsa_keys( "user" INTEGER NOT NULL, - modulus VARCHAR NOT NULL, - exponent VARCHAR NOT NULL, + modulus NUMERIC NOT NULL, + exponent NUMERIC NOT NULL, PRIMARY KEY("user", modulus, exponent), FOREIGN KEY("user") REFERENCES users, FOREIGN KEY(modulus, exponent) REFERENCES rsa_keys |