← Back to team overview

mahara-contributors team mailing list archive

[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