summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-06-16 17:01:38 +0200
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2012-06-16 17:01:38 +0200
commitf58ba7296c88ca1c217f0482c18660f701e4a026 (patch)
tree78970aaaddcc55e901b6a0d10e7136b94731e5cb /schema.sql
parenta6f651c0f9def5efbd0e034514d320818d06e7c6 (diff)
Permit certificate-based login.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/schema.sql b/schema.sql
index ab9abb8..96b53a3 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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