diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 9 insertions, 0 deletions
@@ -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, |