[aur-dev] [PATCH] Add timestamp when a package is flagged out-of-date (FS#20848).

[Lukas Fleischer]

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 at 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?