diff options
author | Kornel <kornel@geekhood.net> | 2020-03-01 22:05:05 +0000 |
---|---|---|
committer | Kornel <kornel@geekhood.net> | 2020-03-01 22:14:40 +0000 |
commit | d45cb1fde8fc6e015d1045ac11604779380d4ec8 (patch) | |
tree | 0726df99929487637a8ba9275a4e1d4d47a8d75c /user_db | |
parent | 4060ea48873fdb5dfceae78b1cb1a6c5c0360e2b (diff) |
Keep history of logins
Diffstat (limited to 'user_db')
-rw-r--r-- | user_db/src/schema.rs | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/user_db/src/schema.rs b/user_db/src/schema.rs index 9c5aa0b..73a1ba2 100644 --- a/user_db/src/schema.rs +++ b/user_db/src/schema.rs @@ -8,7 +8,7 @@ impl UserDb { conn.execute_batch(r#" BEGIN; CREATE TABLE IF NOT EXISTS github_users ( - id INTEGER NOT NULL PRIMARY KEY, + id INTEGER NOT NULL, login TEXT NOT NULL, name TEXT, avatar_url TEXT, @@ -16,7 +16,8 @@ impl UserDb { html_url TEXT, type TEXT NOT NULL DEFAULT 'user' ); - CREATE INDEX IF NOT EXISTS github_users_idx on github_users(login); -- not unique, logins change! + DROP INDEX IF EXISTS "github_users_idx"; + CREATE UNIQUE INDEX IF NOT EXISTS github_users_idx2 on github_users(id, login); -- not just unique login, logins change! CREATE TABLE IF NOT EXISTS github_emails ( github_id INTEGER NOT NULL, |