Activity log for bug #1855798

Date Who What changed Old value New value Message
2019-12-10 02:21:32 Rebecca Blundell bug added bug
2019-12-10 03:50:23 Rebecca Blundell attachment added orphans.html https://bugs.launchpad.net/mahara/+bug/1855798/+attachment/5311273/+files/orphans.html
2019-12-10 03:50:54 Rebecca Blundell description While investigating how to map out Mahara and see what connects to what a discovered a db schema-mapping tool. (Details in the bug report: https://bugs.launchpad.net/mahara/+bug/1855630) That highlighted some issues with our db schema: 'Anomalies' We have 3 tables that contain a single column: artefact_comment_deletedby event_type view_type We have 1 table with incrementing column names, potentially indicating denormalization usr_friend We have a number of orphan tables that should probably be attached. (See attached file) While investigating how to map out Mahara and see what connects to what a discovered a db schema-mapping tool. (Details in the bug report: https://bugs.launchpad.net/mahara/+bug/1855630) That highlighted some issues with our db schema: 'Anomalies' We have 3 tables that contain a single column: artefact_comment_deletedby event_type view_type We have 1 table with incrementing column names, potentially indicating denormalization usr_friend We have a number of orphan tables listed in the comment below.
2020-07-19 22:46:15 Kristina Hoeppner mahara: status New Triaged
2020-09-05 06:41:24 Kristina Hoeppner tags code-cleanup