Details
-
Type:
Improvement
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 2.1.0
-
Fix Version/s: All Time Backlog
-
Component/s: Architecture / Design
-
Labels:None
-
Sprint:High Priority
-
Epic Link:
Description
There are few tables in the databases (smb/mms_common) which we never used it.
I) Check mms_common
mysql> show tables;
-----------------------------------
| Tables_in_mms_common |
-----------------------------------
| accounts |
| blacklist |
| businessAreaLoader |
| businessAreas |
| businessCategories |
| businessCategoryAreaMap |
| businessCategoryLoader |
| businessFunctions |
| businessLocationMap |
| businessLocationPointRadiusLoader |
| businessLocationTypes |
| businessLocations |
| businessLocationsLoader |
| businessTypeFunctionMap |
| businessTypes |
| business_taxonomy |
| callbackEvent |
| campUpdateResp |
| campaigns |
| coverageLocationMap |
| customerCampaignIdMap |
| exemptionRequests |
| googleBudgetEstimates |
| googleLocationTargetMap |
| googleLocationTargets |
| languages |
| locationAliases |
| locationAliasesLoader |
| location_taxonomy |
| locations |
| pointRadius |
| pointRadiusModifiers |
| pointradius |
| postcodeLocationMap |
| requests |
-----------------------------------
35 rows in set (0.00 sec)
Here we haven't used tables "businessFunctions,businessTypes,pointradius,locations,businessTypeFunctionMap"
II) Check smb
----------------------
| Tables_in_smb |
----------------------
| assigned_members |
| assigned_permissions |
| assigned_roles |
| business_taxonomy |
| content |
| content_metadata |
| groups |
| location_taxonomy |
| merchant_properties |
| merchants |
| permissions |
| pointradius |
| realms |
| reseller_properties |
| resellers |
| roles |
| schema_version |
| users |
----------------------
18 rows in set (0.00 sec)
Here table "pointradius"
Suggestions:
In my opinion,we should remove the tables which we are NOT using it to avoid confusion.
