summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2010-10-06 04:25:53 +0200
committerLoui Chang <louipc.ist@gmail.com>2010-11-10 14:50:35 -0500
commiteda713032ce9bed773b6c927b2f6ac4b445fe577 (patch)
tree8091bc77f982d2d71a50dcd7b1facdd50a3f14c3 /support/schema
parentdbb8bb783f2f22b68ad2d65f020390428e77c479 (diff)
downloadaurweb-eda713032ce9bed773b6c927b2f6ac4b445fe577.tar.xz
Add timestamp when a package is flagged out-of-date (FS#20848).
Signed-off-by: Loui Chang <louipc.ist@gmail.com> - resolve conflict and omit i18n changes.
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 250d405..93ec9a0 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),