Database anomalies and orphan tables
Bug #1855798 reported by
Rebecca Blundell
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Triaged
|
Undecided
|
Unassigned |
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:/
That highlighted some issues with our db schema:
'Anomalies'
We have 3 tables that contain a single column:
artefact_
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.
Changed in mahara: | |
status: | New → Triaged |
tags: | added: code-cleanup |
To post a comment you must log in.
List of orphan tables:
artefact_ file_mime_ types config taggedposts_ tags elasticsearch_ queue ype_openbadgedi splayer_ data externalfeed_ data
usr_access_roles site_data
artefact_license
blocktype_
oauth_server_nonce
usr_session external_functions
search_
site_menublockt
cron
sso_session
blocktype_
skin_fonts