diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-06-15 12:29:24 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-06-15 22:37:45 +0200 |
| commit | 2284cb3e4a2ef86b1a2a548ed0b4431ace978d87 (patch) | |
| tree | 64fc20eea94200e6dde3c3feb4f62e5e043606da /upgrading/4.0.0.txt | |
| parent | 74c7cf70ffe49d907df13521edd760467d0602b0 (diff) | |
Store 10 significant digits of the popularity score
Even if we only display two digits after the decimal point, storing more
digits internally allows us to order the search results more accurately.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading/4.0.0.txt')
| -rw-r--r-- | upgrading/4.0.0.txt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrading/4.0.0.txt b/upgrading/4.0.0.txt index fd04c44..954dfcc 100644 --- a/upgrading/4.0.0.txt +++ b/upgrading/4.0.0.txt @@ -35,7 +35,7 @@ CREATE TABLE PackageComaintainers ( ---- ALTER TABLE PackageBases - ADD COLUMN Popularity DECIMAL(6,2) UNSIGNED NOT NULL DEFAULT 0; + ADD COLUMN Popularity DECIMAL(10,6) UNSIGNED NOT NULL DEFAULT 0; ---- 6. Drop the category ID foreign key from the PackageBases table: |