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.

1 files changed, 6 insertions, 0 deletions

diff --git a/UPGRADING b/UPGRADING
index 743f4042..bbf60f08 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -1,6 +1,12 @@
 Upgrading
 =========
 
+From 1.7.0 to 1.8.0
+-------------------
+ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL;
+UPDATE Packages SET OutOfDateTS = UNIX_TIMESTAMP() WHERE OutOfDate = 1;
+ALTER TABLE Packages DROP OutOfDate;
+
 From 1.6.0 to 1.7.0
 -------------------
 ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';