mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #56996
[Bug 1855798] [NEW] Database anomalies and orphan tables
Public bug reported:
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)
** Affects: mahara
Importance: Undecided
Status: New
--
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 that should probably be attached.
(See attached file)
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1855798/+subscriptions
Follow ups