diff options
author | Paul "LeoNerd" Evans <paul@matrix.org> | 2014-09-29 18:37:28 +0100 |
---|---|---|
committer | Paul "LeoNerd" Evans <paul@matrix.org> | 2014-09-29 18:37:28 +0100 |
commit | dca75a08ba5e64554f22813bd0a0356760a1be25 (patch) | |
tree | cb28d1e16cc825d4b88bc814e9e6ea1b34783f15 /synapse/storage/schema/users.sql | |
parent | Extended docs about the registration/login flows (diff) | |
parent | Add a 'Redactions' section. (diff) | |
download | synapse-dca75a08ba5e64554f22813bd0a0356760a1be25.tar.xz |
Merge remote-tracking branch 'origin/develop' into develop
Diffstat (limited to 'synapse/storage/schema/users.sql')
-rw-r--r-- | synapse/storage/schema/users.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/synapse/storage/schema/users.sql b/synapse/storage/schema/users.sql index 2519702971..8244f733bd 100644 --- a/synapse/storage/schema/users.sql +++ b/synapse/storage/schema/users.sql @@ -17,6 +17,7 @@ CREATE TABLE IF NOT EXISTS users( name TEXT, password_hash TEXT, creation_ts INTEGER, + admin BOOL DEFAULT 0 NOT NULL, UNIQUE(name) ON CONFLICT ROLLBACK ); @@ -29,3 +30,16 @@ CREATE TABLE IF NOT EXISTS access_tokens( FOREIGN KEY(user_id) REFERENCES users(id), UNIQUE(token) ON CONFLICT ROLLBACK ); + +CREATE TABLE IF NOT EXISTS user_ips ( + user TEXT NOT NULL, + access_token TEXT NOT NULL, + device_id TEXT, + ip TEXT NOT NULL, + user_agent TEXT NOT NULL, + last_seen INTEGER NOT NULL, + CONSTRAINT user_ip UNIQUE (user, access_token, ip, user_agent) ON CONFLICT REPLACE +); + +CREATE INDEX IF NOT EXISTS user_ips_user ON user_ips(user); + |