← Back to team overview

mahara-contributors team mailing list archive

[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