1.1 --- a/update/core-update.v2.0.3-v2.0.4.sql	Sat Feb 25 16:37:18 2012 +0100
     1.2 +++ b/update/core-update.v2.0.3-v2.0.4.sql	Tue Feb 28 11:59:19 2012 +0100
     1.3 @@ -5,6 +5,14 @@
     1.4    SELECT * FROM (VALUES ('2.0.4', 2, 0, 4))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 +-- drop NOT NULL constraints on columns "name" and "notify_level"
     1.8 +-- in table "member", and add new constraint for "name":
     1.9 +ALTER TABLE "member" ALTER COLUMN "notify_level" DROP NOT NULL;
    1.10 +ALTER TABLE "member" ALTER COLUMN "name" DROP NOT NULL;
    1.11 +ALTER TABLE "member" ADD CONSTRAINT "name_not_null_if_activated" CHECK ("activated" ISNULL OR "name" NOTNULL);
    1.12 +COMMENT ON COLUMN "member"."notify_level" IS 'Selects which event notifications are to be sent to the "notify_email" mail address, may be NULL if member did not make any selection yet';
    1.13 +COMMENT ON COLUMN "member"."name"         IS 'Distinct name of the member, may be NULL if account has not been activated yet';
    1.14 +
    1.15  -- add table "session":
    1.16  CREATE TABLE "session" (
    1.17          "ident"                 TEXT            PRIMARY KEY,