summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authorsimo <simo>2005-05-08 02:01:15 +0000
committersimo <simo>2005-05-08 02:01:15 +0000
commitf7a0009ed7ad537606e6ed1b1e4404f1134d8565 (patch)
treee22c3abae489669126a1f7075d7d3817063deb63 /support/schema
parentf40e1fb77ddb36fd7d35b2ffedd4275db5068748 (diff)
downloadaurweb-f7a0009ed7ad537606e6ed1b1e4404f1134d8565.tar.xz
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
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
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