summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2013-08-04 17:16:17 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2013-08-22 17:48:16 +0200
commit64bfa6e8282744ee14b0bde4bb8caacb43400562 (patch)
tree75be58ecb520c5ccda8ca991373cab18e9cc8f62
parent86fa42f399dafb2a41b1cfb9c2e0d0b5ab9fedfe (diff)
downloadaurweb-64bfa6e8282744ee14b0bde4bb8caacb43400562.tar.xz
Add a quorum column to TU_VoteInfo
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@cryptocrack.de>
-rw-r--r--UPGRADING6
-rw-r--r--support/schema/aur-schema.sql1
2 files changed, 5 insertions, 2 deletions
diff --git a/UPGRADING b/UPGRADING
index c584647..357f2a6 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 total number of TUs to the "TU_VoteInfo" table:
+2. Add fields to store the total number of 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',