mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #56997
[Bug 1855798] Re: Database anomalies and orphan tables
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
References