20180531.sql
671 Bytes
ALTER TABLE error_report MODIFY udid varchar(250);
ALTER TABLE error_report MODIFY route varchar(500);
ALTER TABLE error_report MODIFY useragent text;
ALTER TABLE error_report MODIFY url text;
ALTER TABLE slow_duration_new MODIFY udid varchar(250);
ALTER TABLE slow_duration_new MODIFY route varchar(500);
ALTER TABLE perf_report MODIFY useragent text;
ALTER TABLE perf_report MODIFY browserName varchar(100);
ALTER TABLE perf_report MODIFY browserVersion varchar(100);
ALTER TABLE perf_report MODIFY osName varchar(100);
ALTER TABLE perf_report MODIFY osVersion varchar(100);
ALTER TABLE perf_report MODIFY url text;
DELETE FROM perf_report WHERE responseTime > 5000