From 2d716e8f14d1c5c7aa830f9010287a14dd2f1fdc Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Sun, 8 Apr 2012 23:04:05 +0200
Subject: Implement an OpenID identity provider.

---
 schema.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'schema.sql')

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,
-- 
cgit v1.2.3

