On Sun, Oct 03, 2010 at 01:35:45PM -0500, Dan McGee wrote: > On Sun, Oct 3, 2010 at 1:34 PM, Lukas Fleischer > <[email protected]> wrote: > > 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.
It isn't a DATETIME cause I just copy/pasted the "ModifiedTS" column. Loui, is there any reason for using BIGINTs instead of DATETIMEs for timestamps?
