On Sun, Oct 3, 2010 at 1:34 PM, Lukas Fleischer <archlinux@cryptocrack.de> wrote:
On Fri, Oct 01, 2010 at 10:39:37PM -0400, Loui Chang wrote:
I was thinking - could we just change things so that OutOfDateTS is the sole indicator of whether a package has been flagged or not?
If it's set, then it's out of date. If it's zero or null, then it's up to date.
I basically agree and I already changed the patch to only the "OutOfDateTS" column only. The only thing that I'm not sure how to implement is the migration code, notably the default timestamp to use for packages that are flagged out-of-date when upgrading.
Which is the best value to choose? Zero? UNIX_TIMESTAMP()?
Current time is probably the best idea. I also have no idea why this isn't just a datetime column. -Dan