liquid_feedback_core

changeset 99:46260129d0ce

Added new field "locked" to member, redefined meaning of "active" flag
author jbe
date Tue Jan 04 02:15:22 2011 +0100 (2011-01-04)
parents 07e6a4f11b5b
children 994dd8ff5ad1 9b18ee4682c7
files core.sql
line diff
     1.1 --- a/core.sql	Mon Dec 06 23:50:32 2010 +0100
     1.2 +++ b/core.sql	Tue Jan 04 02:15:22 2011 +0100
     1.3 @@ -7,7 +7,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('1.3.0', 1, 3, 0))
     1.8 +  SELECT * FROM (VALUES ('1.3.1', 1, 3, 1))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -60,6 +60,7 @@
    1.13          "last_login"            TIMESTAMPTZ,
    1.14          "login"                 TEXT            UNIQUE,
    1.15          "password"              TEXT,
    1.16 +        "locked"                BOOLEAN         NOT NULL DEFAULT FALSE,
    1.17          "active"                BOOLEAN         NOT NULL DEFAULT TRUE,
    1.18          "admin"                 BOOLEAN         NOT NULL DEFAULT FALSE,
    1.19          "notify_email"          TEXT,
    1.20 @@ -99,7 +100,8 @@
    1.21  
    1.22  COMMENT ON COLUMN "member"."login"                IS 'Login name';
    1.23  COMMENT ON COLUMN "member"."password"             IS 'Password (preferably as crypto-hash, depending on the frontend or access layer)';
    1.24 -COMMENT ON COLUMN "member"."active"               IS 'Inactive members can not login and their supports/votes are not counted by the system.';
    1.25 +COMMENT ON COLUMN "member"."locked"               IS 'Locked members can not log in.';
    1.26 +COMMENT ON COLUMN "member"."active"               IS 'Memberships, support and votes are taken into account when corresponding members are marked as active. When the user does not log in for an extended period of time, this flag may be set to FALSE. If the user is not locked, he/she may reset the active flag by logging in.';
    1.27  COMMENT ON COLUMN "member"."admin"                IS 'TRUE for admins, which can administrate other users and setup policies and areas';
    1.28  COMMENT ON COLUMN "member"."notify_email"         IS 'Email address where notifications of the system are sent to';
    1.29  COMMENT ON COLUMN "member"."notify_email_unconfirmed"   IS 'Unconfirmed email address provided by the member to be copied into "notify_email" field after verification';

Impressum / About Us