Add created_date and updated_date fields to all tables

Bug #815313 reported by Barry van Oudtshoorn
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Low
Tim Bentley

Bug Description

I was just asked to produce a report showing which songs have been added to OpenLP in the past six months. Unfortunately, however, there's no easy way to do this, as the data simply isn't available in the database. What I would propose is the addition of two fields to most (all?) tables in the "songs" db, to track the timestamps for insertion and last update.

Yes, there is the "songusage" database, but that solves a slightly different problem, although admittedly with some cross-over. (I was able to get useful data out of it to satisfy the request.)

Related branches

Tim Bentley (trb143)
Changed in openlp:
importance: Undecided → Wishlist
Changed in openlp:
assignee: nobody → Tim Bentley (trb143)
milestone: none → 1.9.7
status: New → In Progress
Tim Bentley (trb143)
Changed in openlp:
importance: Wishlist → Low
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.