diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-10-15 16:59:15 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-10-16 18:15:45 +0200 |
| commit | e9ebcc4479a09ebcf057664c55124caa00cf1946 (patch) | |
| tree | d7a1218758fd99f2e3eb4a8c00bec28a2e622639 /upgrading | |
| parent | c986ba0c52a771daf3593e3e262d3345997311ad (diff) | |
| download | aurweb-e9ebcc4479a09ebcf057664c55124caa00cf1946.tar.xz | |
Add a time stamp to package base votes
This can potentially be used to identify trending packages.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'upgrading')
| -rw-r--r-- | upgrading/3.5.0.txt | 6 |
1 files changed, 6 insertions, 0 deletions
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; +---- |