1CREATE TABLE user_threepids (
2    user_id TEXT NOT NULL,
3    medium TEXT NOT NULL,
4    address TEXT NOT NULL,
5    validated_at BIGINT NOT NULL,
6    added_at BIGINT NOT NULL,
7    CONSTRAINT user_medium_address UNIQUE (user_id, medium, address)
8);
9CREATE INDEX user_threepids_user_id ON user_threepids(user_id);
10