From e9ebcc4479a09ebcf057664c55124caa00cf1946 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Wed, 15 Oct 2014 16:59:15 +0200 Subject: Add a time stamp to package base votes This can potentially be used to identify trending packages. Signed-off-by: Lukas Fleischer --- schema/aur-schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'schema') 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, -- cgit v1.2.3-54-g00ecf