From eda713032ce9bed773b6c927b2f6ac4b445fe577 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 6 Oct 2010 04:25:53 +0200 Subject: Add timestamp when a package is flagged out-of-date (FS#20848). Signed-off-by: Loui Chang - resolve conflict and omit i18n changes. --- support/schema/aur-schema.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'support') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 250d4058..93ec9a06 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -119,7 +119,7 @@ CREATE TABLE Packages ( License CHAR(40) NOT NULL DEFAULT '', LocationID TINYINT UNSIGNED NOT NULL DEFAULT 1, NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, - OutOfDate TINYINT UNSIGNED DEFAULT 0, + OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL, SubmittedTS BIGINT UNSIGNED NOT NULL, ModifiedTS BIGINT UNSIGNED NOT NULL, SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it? @@ -130,7 +130,6 @@ CREATE TABLE Packages ( INDEX (CategoryID), INDEX (LocationID), INDEX (DummyPkg), - INDEX (OutOfDate), INDEX (NumVotes), INDEX (SubmitterUID), INDEX (MaintainerUID), -- cgit v1.2.3-24-g4f1b