summaryrefslogtreecommitdiffstats
path: root/schema
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-10-15 16:59:15 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-10-16 18:15:45 +0200
commite9ebcc4479a09ebcf057664c55124caa00cf1946 (patch)
treed7a1218758fd99f2e3eb4a8c00bec28a2e622639 /schema
parentc986ba0c52a771daf3593e3e262d3345997311ad (diff)
downloadaurweb-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 'schema')
-rw-r--r--schema/aur-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 08f87d8..afe19a1 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -249,6 +249,7 @@ CREATE TABLE PackageSources (
CREATE TABLE PackageVotes (
UsersID INTEGER UNSIGNED NOT NULL,
PackageBaseID INTEGER UNSIGNED NOT NULL,
+ VoteTS BIGINT UNSIGNED NULL DEFAULT NULL,
INDEX (UsersID),
INDEX (PackageBaseID),
FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,