diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2013-08-04 17:16:17 +0200 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2013-08-22 17:48:16 +0200 |
| commit | 64bfa6e8282744ee14b0bde4bb8caacb43400562 (patch) | |
| tree | 75be58ecb520c5ccda8ca991373cab18e9cc8f62 | |
| parent | 86fa42f399dafb2a41b1cfb9c2e0d0b5ab9fedfe (diff) | |
| download | aurweb-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-- | UPGRADING | 6 | ||||
| -rw-r--r-- | support/schema/aur-schema.sql | 1 |
2 files changed, 5 insertions, 2 deletions
@@ -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', |