From 824744f1d20614c25e972dda7a0b7ac9506dd46f Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Thu, 11 Jun 2015 18:41:58 +0200 Subject: Add a field for package base popularity Create a new field Popularity in the PackageBases table. The field is updated by the popupdate script and reflects the popularity of a package. Popularity is the sum of all votes with each vote being weighted with a factor of 0.98 per day since its creation. Signed-off-by: Lukas Fleischer --- upgrading/4.0.0.txt | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'upgrading') diff --git a/upgrading/4.0.0.txt b/upgrading/4.0.0.txt index ed39c9f..aa1e535 100644 --- a/upgrading/4.0.0.txt +++ b/upgrading/4.0.0.txt @@ -31,4 +31,11 @@ CREATE TABLE PackageComaintainers ( ) ENGINE = InnoDB; ---- -5. (optional) Setup cgit to browse the Git repositories via HTTP. +5. Add a field for the package base popularity to the PackageBases table: + +---- +ALTER TABLE PackageBases + ADD COLUMN Popularity DECIMAL(6,2) UNSIGNED NOT NULL DEFAULT 0; +---- + +6. (optional) Setup cgit to browse the Git repositories via HTTP. -- cgit v1.2.3-70-g09d2