On Sun, Oct 3, 2010 at 1:34 PM, Lukas Fleischer <archli...@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