liquid_feedback_core

diff init.sql @ 97:58451b5565ae

Introduced (organizational) units

- New table "unit"
- Each "area" refers to one unit
- "invite_code"s are valid for one or many units
- New table "privilege" stores "voting_right" for units
- Delegation scope 'global' is replaced by delegation scope 'unit'
- View "global_delegation" is replaced by "unit_delegation"
- Removed helper view "active_delegation"
- Checking that members have "voting_right" in several views and functions
- New view "unit_member_count" to update "member_count" column of new unit table
- New argument list for function "delegation_chain"(...) containing "unit_id"
- Renamed column "member_active" to "member_valid" in "delegation_chain_row"
- Modified demo.sql and init.sql to support units
author jbe
date Tue Dec 07 00:04:44 2010 +0100 (2010-12-07)
parents 4af4df1415f9
children 6fce4f08157b
line diff
     1.1 --- a/init.sql	Mon Dec 06 23:50:32 2010 +0100
     1.2 +++ b/init.sql	Tue Dec 07 00:04:44 2010 +0100
     1.3 @@ -2,6 +2,17 @@
     1.4  
     1.5  BEGIN;
     1.6  
     1.7 +INSERT INTO "unit" (
     1.8 +        "active",
     1.9 +        "name",
    1.10 +        "description"
    1.11 +    ) VALUES (
    1.12 +        true,
    1.13 +        'Default unit',
    1.14 +        'Default unit created by init script.'
    1.15 +    );
    1.16 +        
    1.17 +
    1.18  INSERT INTO "member" (
    1.19          "login",
    1.20          "password",
    1.21 @@ -63,10 +74,12 @@
    1.22          1, 100 );
    1.23  
    1.24  INSERT INTO "area" (
    1.25 +        "unit_id",
    1.26          "active",
    1.27          "name",
    1.28          "description"
    1.29      ) VALUES (
    1.30 +        1,
    1.31          TRUE,
    1.32          'Generic area',
    1.33          DEFAULT );

Impressum / About Us