Add created_date and updated_date fields to all tables

Bug #815313 reported by Barry van Oudtshoorn on 2011-07-24
This bug affects 1 person
Affects Status Importance Assigned to Milestone
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) on 2011-07-24
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) on 2011-08-26
Changed in openlp:
importance: Wishlist → Low
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers