synapse/storage/schema/delta/v5.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE IF NOT EXISTS user_ips (
    user TEXT NOT NULL,
    access_token TEXT NOT NULL,
    ip TEXT NOT NULL,
    CONSTRAINT user_ip UNIQUE (user, access_token, ip) ON CONFLICT IGNORE
);

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;