changeset 221:4a7ae2507515

Added column "lang" to table "member"
author jbe
date Sat Feb 25 15:09:59 2012 +0100 (2012-02-25)
parents 4e3d8f1ca3a9
children cd5fa6c46e13
files core.sql
line diff
     1.1 --- a/core.sql	Sat Feb 25 15:09:27 2012 +0100
     1.2 +++ b/core.sql	Sat Feb 25 15:09:59 2012 +0100
     1.3 @@ -94,6 +94,7 @@
     1.4          "locked"                BOOLEAN         NOT NULL DEFAULT FALSE,
     1.5          "active"                BOOLEAN         NOT NULL DEFAULT FALSE,
     1.6          "admin"                 BOOLEAN         NOT NULL DEFAULT FALSE,
     1.7 +        "lang"                  TEXT,
     1.8          "notify_email"          TEXT,
     1.9          "notify_email_unconfirmed"     TEXT,
    1.10          "notify_email_secret"          TEXT     UNIQUE,
    1.11 @@ -146,6 +147,7 @@
    1.12  COMMENT ON COLUMN "member"."locked"               IS 'Locked members can not log in.';
    1.13  COMMENT ON COLUMN "member"."active"               IS 'Memberships, support and votes are taken into account when corresponding members are marked as active. Automatically set to FALSE, if "last_activity" is older than "system_setting"."member_ttl".';
    1.14  COMMENT ON COLUMN "member"."admin"                IS 'TRUE for admins, which can administrate other users and setup policies and areas';
    1.15 +COMMENT ON COLUMN "member"."lang"                 IS 'Language code of the preferred language of the member';
    1.16  COMMENT ON COLUMN "member"."notify_email"         IS 'Email address where notifications of the system are sent to';
    1.17  COMMENT ON COLUMN "member"."notify_email_unconfirmed"   IS 'Unconfirmed email address provided by the member to be copied into "notify_email" field after verification';
    1.18  COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';

Impressum / About Us