liquid_feedback_core
changeset 203:976e7dafe641
Added table "unit_setting"
author | jbe |
---|---|
date | Sat Oct 08 20:48:30 2011 +0200 (2011-10-08) |
parents | fa394b8a0157 |
children | b8fa47ee5d82 |
files | core.sql |
line diff
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,