[aur-dev] [PATCH 4/7] Add a quorum column to TU_VoteInfo

[Alexander Cherniaev]

i leave community. install fucking debian. surprizes like grub->grub2, / ->
/usr etc when i need to do my work is awesome!


2013/8/5 Lukas Fleischer <archlinux at cryptocrack.de>

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


-- 
______________________________
С уважением, Черняев Александр.