From f7a0009ed7ad537606e6ed1b1e4404f1134d8565 Mon Sep 17 00:00:00 2001 From: simo Date: Sun, 8 May 2005 02:01:15 +0000 Subject: Added ModifiedTS to Packages database Implemented ModifiedTS such that: -ModifiedTS changed ONLY when package updated -SubmittedTS changed ONLY when new package Also made DummyPkg fixups in tupkgupdate --- support/schema/aur-schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'support/schema/aur-schema.sql') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index d269d4bb..0b6d5e5f 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -118,6 +118,7 @@ CREATE TABLE Packages ( NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, SubmittedTS BIGINT UNSIGNED NOT NULL, + ModifiedTS BIGINT UNSIGNED NOT NULL, SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it? MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- User AURMaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- TU/Dev -- cgit v1.2.3-24-g4f1b