1.1 --- a/core.sql	Thu Oct 06 16:38:51 2011 +0200
     1.2 +++ b/core.sql	Sat Oct 08 20:48:30 2011 +0200
     1.3 @@ -379,6 +379,16 @@
     1.4  COMMENT ON COLUMN "unit"."member_count" IS 'Count of members as determined by column "voting_right" in table "privilege"';
     1.5  
     1.6  
     1.7 +CREATE TABLE "unit_setting" (
     1.8 +        PRIMARY KEY ("member_id", "key", "unit_id"),
     1.9 +        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.10 +        "key"                   TEXT            NOT NULL,
    1.11 +        "unit_id"               INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.12 +        "value"                 TEXT            NOT NULL );
    1.13 +
    1.14 +COMMENT ON TABLE "unit_setting" IS 'Place for frontend to store unit specific settings of members as strings';
    1.15 +
    1.16 +
    1.17  CREATE TABLE "area" (
    1.18          "id"                    SERIAL4         PRIMARY KEY,
    1.19          "unit_id"               INT4            NOT NULL REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,