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