Implement an OpenID identity provider.

1 files changed, 9 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index 155c7a2..49e1e63 100644
--- a/schema.sql
+++ b/schema.sql
@@ -28,6 +28,15 @@ CREATE TABLE user_email_addresses(
   FOREIGN KEY("user") REFERENCES users
 );
 
+CREATE TABLE user_nicknames(
+  "user"   INTEGER NOT NULL,
+  nickname VARCHAR NOT NULL,
+  PRIMARY KEY(nickname),
+  FOREIGN KEY("user") REFERENCES users
+);
+
+CREATE INDEX user_nicknames_user ON user_nicknames ("user");
+
 CREATE TABLE page_keys(
   "user" INTEGER NOT NULL,
   page   VARCHAR NOT NULL,