diff options
| author | simo <simo> | 2005-05-08 02:01:15 +0000 |
|---|---|---|
| committer | simo <simo> | 2005-05-08 02:01:15 +0000 |
| commit | f7a0009ed7ad537606e6ed1b1e4404f1134d8565 (patch) | |
| tree | e22c3abae489669126a1f7075d7d3817063deb63 /support/schema | |
| parent | f40e1fb77ddb36fd7d35b2ffedd4275db5068748 (diff) | |
| download | aurweb-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.sql | 1 |
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 |