diff options
| author | Erik Johnston <erik@matrix.org> | 2014-09-29 15:59:05 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-09-29 15:59:05 +0100 |
| commit | f1bdf40dda5eaba622103b64e749b539e5ce6bf1 (patch) | |
| tree | a2a09ff016223528aafa4ce50c9b12698e44c6b1 /synapse/storage/schema/delta/v5.sql | |
| parent | No longer need the Freenode verification key file (diff) | |
| parent | Unbreak tests after changing storage API (diff) | |
| download | synapse-f1bdf40dda5eaba622103b64e749b539e5ce6bf1.tar.xz | |
Merge branch 'whois' of github.com:matrix-org/synapse into develop
Diffstat (limited to 'synapse/storage/schema/delta/v5.sql')
| -rw-r--r-- | synapse/storage/schema/delta/v5.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/v5.sql b/synapse/storage/schema/delta/v5.sql new file mode 100644 index 0000000000..af9df11aa9 --- /dev/null +++ b/synapse/storage/schema/delta/v5.sql @@ -0,0 +1,16 @@ + +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); + +ALTER TABLE users ADD COLUMN admin BOOL DEFAULT 0 NOT NULL; + +PRAGMA user_version = 5; |