[aur-dev] [PATCH 1/3] Add a quorum column to TU_VoteInfo

[Lukas Fleischer]

This allows for specifying a quorum per vote and sets a basis for
implementing automated acceptance/rejection of TU votes later.

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
 UPGRADING                     | 6 ++++--
 support/schema/aur-schema.sql | 1 +
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/UPGRADING b/UPGRADING
index 307ed8d..a300a91 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -10,11 +10,13 @@ From 2.2.0 to 2.3.0
 ALTER TABLE Users ADD COLUMN InactivityTS BIGINT NOT NULL DEFAULT 0;
 ----
 
-2. Add a field to store the number of active TUs to the "TU_VoteInfo" table:
+2. Add fields to store the number of active TUs and the quorum to the
+   "TU_VoteInfo" table:
 
 ----
 ALTER TABLE TU_VoteInfo
-	ADD COLUMN ActiveTUs tinyint(3) unsigned NOT NULL default '0';
+	ADD COLUMN ActiveTUs tinyint(3) unsigned NOT NULL default '0',
+	ADD COLUMN Quorum decimal(2, 2) unsigned NOT NULL;
 ----
 
 From 2.1.0 to 2.2.0
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 51f9601..59da3aa 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -198,6 +198,7 @@ CREATE TABLE IF NOT EXISTS TU_VoteInfo (
   User VARCHAR(32) NOT NULL,
   Submitted bigint(20) unsigned NOT NULL,
   End bigint(20) unsigned NOT NULL,
+  Quorum decimal(2, 2) unsigned NOT NULL,
   SubmitterID int(10) unsigned NOT NULL,
   Yes tinyint(3) unsigned NOT NULL default '0',
   No tinyint(3) unsigned NOT NULL default '0',
-- 
1.8.4.rc1.383.g13e9f3f