# HG changeset patch # User jbe # Date 1330178999 -3600 # Node ID 4a7ae2507515e18d3826ef0d5d5a4b6c0f1d2cf6 # Parent 4e3d8f1ca3a9475e85af5f5002222e1d07d2ca18 Added column "lang" to table "member" diff -r 4e3d8f1ca3a9 -r 4a7ae2507515 core.sql --- a/core.sql Sat Feb 25 15:09:27 2012 +0100 +++ b/core.sql Sat Feb 25 15:09:59 2012 +0100 @@ -94,6 +94,7 @@ "locked" BOOLEAN NOT NULL DEFAULT FALSE, "active" BOOLEAN NOT NULL DEFAULT FALSE, "admin" BOOLEAN NOT NULL DEFAULT FALSE, + "lang" TEXT, "notify_email" TEXT, "notify_email_unconfirmed" TEXT, "notify_email_secret" TEXT UNIQUE, @@ -146,6 +147,7 @@ COMMENT ON COLUMN "member"."locked" IS 'Locked members can not log in.'; 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".'; COMMENT ON COLUMN "member"."admin" IS 'TRUE for admins, which can administrate other users and setup policies and areas'; +COMMENT ON COLUMN "member"."lang" IS 'Language code of the preferred language of the member'; COMMENT ON COLUMN "member"."notify_email" IS 'Email address where notifications of the system are sent to'; COMMENT ON COLUMN "member"."notify_email_unconfirmed" IS 'Unconfirmed email address provided by the member to be copied into "notify_email" field after verification'; COMMENT ON COLUMN "member"."notify_email_secret" IS 'Secret sent to the address in "notify_email_unconformed"';