-
Task
-
Resolution: Done
-
Major
-
SaaS
-
None
-
0
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Engineering
-
3scale 2019-08-12, 3scale 2019-10-28, 3scale 2019-11-11, 3scale 2019-11-25, 3scale 2019-12-23, 3scale 2020-01-13, 3scale 2020-01-27, 3scale 2020-02-03, 3scale 2020-02-17, 3scale 2020-03-09, 3scale 2020-03-23, Invalid Sprint
Database cleaning
Some tables like accounts and services have too many columns and some of them are not used anymore. We just programmatically hide them instead of removing them.
Goal
Having unused columns is not really good for database (taking time and place), unecessary indices and also for programming (code maintenance)
Those columns are not used for years. It is time to drop them and make our database ligher.
Maintenance window needed
This needs a maintenance window as we are touching some important tables, not allowing any scripts and requests to update the database
1.
|
Remove Account column deleted_at from the DB |
|
Closed | 
|
Unassigned |
2.
|
Remove tech_support_email and admin_support_email fields from the DB |
|
Closed |
|
Unassigned |
3.
|
Remove Account column service_prefix from code & DB |
|
Closed |
|
Unassigned |
4.
|
Remove unused columns from Account & Service (and more) from DB! |
|
Closed |
|
Unassigned |
5.
|
Investigate and list the fields that should be removed from Account |
|
Closed |
|
Unassigned |
6.
|
Investigate and list the fields that should be removed from Service |
|
Closed |
|
Unassigned |
7.
|
Maintenance window for SaaS |
|
Closed |
|
Unassigned |