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 /schema | |
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 'schema')
-rw-r--r-- | schema/aur-schema.sql | 1 |
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, |