From e9ebcc4479a09ebcf057664c55124caa00cf1946 Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
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 <archlinux@cryptocrack.de>
---
 schema/aur-schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/aur-schema.sql')

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.3.1

