From e9ebcc4479a09ebcf057664c55124caa00cf1946 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 15 Oct 2014 16:59:15 +0200 Subject: Add a time stamp to package base votes This can potentially be used to identify trending packages. Signed-off-by: Lukas Fleischer --- upgrading/3.5.0.txt | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'upgrading/3.5.0.txt') diff --git a/upgrading/3.5.0.txt b/upgrading/3.5.0.txt index 152fc84..c21a48d 100644 --- a/upgrading/3.5.0.txt +++ b/upgrading/3.5.0.txt @@ -5,3 +5,9 @@ ALTER TABLE PackageDepends ADD COLUMN DepArch VARCHAR(255) NULL DEFAULT NULL; ALTER TABLE PackageRelations ADD COLUMN RelArch VARCHAR(255) NULL DEFAULT NULL; ALTER TABLE PackageSources ADD COLUMN SourceArch VARCHAR(255) NULL DEFAULT NULL; ---- + +2. Add a time stamp column to the package votes table: + +---- +ALTER TABLE PackageVotes ADD COLUMN VoteTS BIGINT NULL DEFAULT NULL; +---- -- cgit v1.2.3-54-g00ecf