2 -- patch-index-renames.sql
4 -- Rename three indices because of naming conflicts
6 DROP INDEX user_id
ON /*_*/user_newtalk
;
7 DROP INDEX user_ip
ON /*_*/user_newtalk
;
8 DROP INDEX usertext_timestamp
ON /*_*/archive
;
9 CREATE INDEX un_user_id
ON /*_*/user_newtalk (user_id
);
10 CREATE INDEX un_user_ip
ON /*_*/user_newtalk (user_ip
);
11 CREATE INDEX ar_usertext_timestamp
ON /*_*/archive (ar_user_text
,ar_timestamp
);