Searched refs:user_threepids (Results 1 – 6 of 6) sorted by relevance
23 UPDATE user_threepids31 user_threepids AS u,36 FROM user_threepids AS u137 …INNER JOIN user_threepids AS u2 ON u1.medium = u2.medium AND lower(u1.address) = lower(u2.address)…48 UPDATE user_threepids SET address = LOWER(address) WHERE medium = 'email';52 CREATE INDEX user_threepids_medium_address on user_threepids (medium, address);
11 SELECT * FROM user_threepids WHERE added_at IN (12 SELECT max(added_at) FROM user_threepids GROUP BY medium, address16 DROP TABLE user_threepids;17 ALTER TABLE user_threepids2 RENAME TO user_threepids;19 CREATE INDEX user_threepids_user_id ON user_threepids(user_id);
1 CREATE TABLE user_threepids ( table9 CREATE INDEX user_threepids_user_id ON user_threepids(user_id);
1081 CREATE TABLE user_threepids (1297 ALTER TABLE ONLY user_threepids1959 CREATE INDEX user_threepids_medium_address ON user_threepids USING btree (medium, address);1963 CREATE INDEX user_threepids_user_id ON user_threepids USING btree (user_id);
66 CREATE TABLE IF NOT EXISTS "user_threepids" ( user_id TEXT NOT NULL, medium TEXT NOT NULL, address …67 CREATE INDEX user_threepids_user_id ON user_threepids(user_id);121 CREATE INDEX user_threepids_medium_address on user_threepids (medium, address);
8207 - Fix `user_threepids` schema delta, which in some instances prevented startup after upgrade (PR …