List of orphan tables: artefact_file_mime_types config usr_access_roles site_data artefact_license blocktype_taggedposts_tags oauth_server_nonce usr_session external_functions search_elasticsearch_queue site_menublocktype_openbadgedisplayer_data cron sso_session blocktype_externalfeed_data skin_fonts
** Attachment added: "orphans.html" https://bugs.launchpad.net/mahara/+bug/1855798/+attachment/5311273/+files/orphans.html ** Description changed: 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 + 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) + We have a number of orphan tables listed in the comment below. -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1855798 Title: Database anomalies and orphan tables Status in Mahara: New Bug 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 listed in the comment below. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1855798/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
