openlp-core team mailing list archive

[Tim Bentley <815313@xxxxxxxxxxxxxxxxxx>]

** Branch linked: lp:~trb143/openlp/bug-815313

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/815313

Title:
  Add created_date and updated_date fields to all tables

Status in OpenLP - Worship Presentation Software:
  New

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.)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/815313/+subscriptions