From f7a0009ed7ad537606e6ed1b1e4404f1134d8565 Mon Sep 17 00:00:00 2001
From: simo <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 d269d4b..0b6d5e5 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-70-g09d2

