5 Oct
2010
5 Oct
'10
2:06 p.m.
On Sun, Oct 03, 2010 at 01:35:45PM -0500, Dan McGee wrote:
On Sun, Oct 3, 2010 at 1:34 PM, Lukas Fleischer <archlinux@cryptocrack.de> 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?