summary refs log tree commit diff
path: root/synapse/storage/schema/delta/v5.sql
blob: f5a667a2501f9d9916aec10720005bdce769f5ed (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE IF NOT EXISTS user_ips (
    user TEXT NOT NULL,
    access_token TEXT NOT NULL,
    ip TEXT NOT NULL,
    user_agent TEXT NOT NULL,
    last_used 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;