# HG changeset patch
# User jbe
# Date 1318099710 -7200
# Node ID 976e7dafe641bcd9e722c3a7d5100ebd67e265b8
# Parent  fa394b8a01574be279c87aee12e03cc08aff72dc
Added table "unit_setting"

diff -r fa394b8a0157 -r 976e7dafe641 core.sql
--- a/core.sql	Thu Oct 06 16:38:51 2011 +0200
+++ b/core.sql	Sat Oct 08 20:48:30 2011 +0200
@@ -379,6 +379,16 @@
 COMMENT ON COLUMN "unit"."member_count" IS 'Count of members as determined by column "voting_right" in table "privilege"';
 
 
+CREATE TABLE "unit_setting" (
+        PRIMARY KEY ("member_id", "key", "unit_id"),
+        "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "key"                   TEXT            NOT NULL,
+        "unit_id"               INT4            REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
+        "value"                 TEXT            NOT NULL );
+
+COMMENT ON TABLE "unit_setting" IS 'Place for frontend to store unit specific settings of members as strings';
+
+
 CREATE TABLE "area" (
         "id"                    SERIAL4         PRIMARY KEY,
         "unit_id"               INT4            NOT NULL REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE,