Details
-
Type:
Task
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: None
-
Labels:None
-
Sprint:Sprint 23
Description
This is a very minor task to remove unused datatabase tables. The feature/mysql-5-5-46-upgrade branch, which involved some database cleanup (mostly removing unused or duplicate files) was recently merged into feature/mercury. This task is an extension of that work.
Added the following to the Mercury db_changes.sql file :
-- Sprint 23 Database Cleanup drop table if exists `staging`.`askDailyCheck`; drop table if exists `staging`.`askReports`; drop table if exists `staging`.`msnDailyCheck`; drop table if exists `staging`.`msnDailyCheckV5`; drop table if exists `staging`.`msnReports`; drop table if exists `staging`.`msnReportsV5`; drop table if exists `staging`.`msnSummaryCheck`; drop table if exists `staging`.`overtureDailyCheck`; drop table if exists `staging`.`overtureSummaryCheck`; drop table if exists `sesystem`.`msnLogins`; drop table if exists `tsacommon`.`MSNErrorCodes`; -- This will drop the accountReportMap, accountReportScheduleMap, reportDataAvailability, reportInfo, reportSchedule, and userContactMap tables drop database if exists `report_service`;
