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