Page MenuHomePhabricator

CT-to-Civi-Phase 2 - drop the drupal contribution_tracking table
Closed, ResolvedPublic2 Estimated Story Points

Description

Once all usages are gone , including those by @JMando, then clean it up

Event Timeline

Dwisehaupt set the point value for this task to 2.May 1 2023, 8:09 PM

will have another silverpop clean up ticket

Eileenmcnaughton renamed this task from CT-to-Civi-Phase 2 - drop the interim drupal view to CT-to-Civi-Phase 2 - drop the drupal contribution_tracking table.Jun 9 2023, 12:41 AM
Eileenmcnaughton updated the task description. (Show Details)
Dwisehaupt claimed this task.
Dwisehaupt subscribed.

Deleted yesterday. Dropped the 3 tables and 1 view:

MariaDB [drupal]> drop view drupal.contribution_tracking_view;
Query OK, 0 rows affected (0.001 sec)

MariaDB [drupal]> drop table drupal.contribution_tracking_owa_ref;
Query OK, 0 rows affected (0.009 sec)

MariaDB [drupal]> drop table drupal.contribution_tracking;
Query OK, 0 rows affected (0.307 sec)

MariaDB [drupal]> drop table drupal.contribution_source;
Query OK, 0 rows affected (0.085 sec)

Backup files are currently on frdb1005 and frlog1002

dallas@frdb1005:/srv/archive/database_dumps$ ls
drupal.contribution_source_backup-20240305.sql.gz
drupal.contribution_tracking_backup-20240301.sql.gz
drupal.contribution_tracking_owa_ref_backup-20240301.sql.gz
drupal.contribution_tracking_view_backup-20240301.sql.gz