diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2010-10-06 04:25:53 +0200 |
|---|---|---|
| committer | Loui Chang <louipc.ist@gmail.com> | 2010-11-10 14:50:35 -0500 |
| commit | eda713032ce9bed773b6c927b2f6ac4b445fe577 (patch) | |
| tree | 8091bc77f982d2d71a50dcd7b1facdd50a3f14c3 /support/schema | |
| parent | dbb8bb783f2f22b68ad2d65f020390428e77c479 (diff) | |
| download | aurweb-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.sql | 3 |
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), |