Details
-
Type: Improvement
-
Status: Closed
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: Aquidneck
-
Fix Version/s: 2.0.0, sprint 7: 09-05-2012, Aquidneck
-
Component/s: Database/Schema
-
Labels:None
-
Environment:
QA Server: Optus-QA-Mysql (192.168.70.81)
Database: tsacommon
-
Sprint:Sprint 6, Sprint 7
Description
Since we use the same global tsacommon master database configuration to create all the slave tsacommon databases as well, the slave tsacommon databases have replication triggers and few additional logging tables in them.
For replication to work fine, these triggers and tables need to be removed manually. If this task can be automated by using a different db structure, user will not have to do the task manually.
Attaching the drop trigger and drop tables sql files.