devsnd/cherrymusic — pull request #169 by tilboerner (2013-03-08 17:24:57+00:00)
Title: sqlite rowids may change

When implementing the load-db into ram feature, I came across a strange bug... and then this page:
http://www.sqlabs.com/blog/2010/12/sqlite-and-unique-rowid-something-you-really-need-to-know/

We need to redesign the database column to have real uids.
And while we're at it, we should introduce "date_created" and "date_modified" as well as "date_deleted" fields... well the latter is open for discussion, but the former has to be addressed in a timely manner.