liquid_feedback_core
changeset 542:f5c5d2b12726
Removed settings tables
author | jbe |
---|---|
date | Fri Jul 14 20:27:33 2017 +0200 (2017-07-14) |
parents | 5d96f5fc4af0 |
children | 4e0ee8416bbc |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Fri Jul 14 20:20:26 2017 +0200 1.2 +++ b/core.sql Fri Jul 14 20:27:33 2017 +0200 1.3 @@ -232,43 +232,6 @@ 1.4 COMMENT ON TABLE "rendered_member_statement" IS 'This table may be used by frontends to cache "rendered" member statements (e.g. HTML output generated from wiki text)'; 1.5 1.6 1.7 -CREATE TABLE "setting" ( 1.8 - PRIMARY KEY ("member_id", "key"), 1.9 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.10 - "key" TEXT NOT NULL, 1.11 - "value" TEXT NOT NULL ); 1.12 -CREATE INDEX "setting_key_idx" ON "setting" ("key"); 1.13 - 1.14 -COMMENT ON TABLE "setting" IS 'Place to store a frontend specific setting for members as a string'; 1.15 - 1.16 -COMMENT ON COLUMN "setting"."key" IS 'Name of the setting, preceded by a frontend specific prefix'; 1.17 - 1.18 - 1.19 -CREATE TABLE "setting_map" ( 1.20 - PRIMARY KEY ("member_id", "key", "subkey"), 1.21 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.22 - "key" TEXT NOT NULL, 1.23 - "subkey" TEXT NOT NULL, 1.24 - "value" TEXT NOT NULL ); 1.25 -CREATE INDEX "setting_map_key_idx" ON "setting_map" ("key"); 1.26 - 1.27 -COMMENT ON TABLE "setting_map" IS 'Place to store a frontend specific setting for members as a map of key value pairs'; 1.28 - 1.29 -COMMENT ON COLUMN "setting_map"."key" IS 'Name of the setting, preceded by a frontend specific prefix'; 1.30 -COMMENT ON COLUMN "setting_map"."subkey" IS 'Key of a map entry'; 1.31 -COMMENT ON COLUMN "setting_map"."value" IS 'Value of a map entry'; 1.32 - 1.33 - 1.34 -CREATE TABLE "member_relation_setting" ( 1.35 - PRIMARY KEY ("member_id", "key", "other_member_id"), 1.36 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.37 - "key" TEXT NOT NULL, 1.38 - "other_member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.39 - "value" TEXT NOT NULL ); 1.40 - 1.41 -COMMENT ON TABLE "member_relation_setting" IS 'Place to store a frontend specific setting related to relations between members as a string'; 1.42 - 1.43 - 1.44 CREATE TYPE "member_image_type" AS ENUM ('photo', 'avatar'); 1.45 1.46 COMMENT ON TYPE "member_image_type" IS 'Types of images for a member'; 1.47 @@ -623,16 +586,6 @@ 1.48 COMMENT ON TABLE "subscription" IS 'An entry in this table denotes that the member wishes to receive notifications regardless of his/her privileges in the given unit'; 1.49 1.50 1.51 -CREATE TABLE "unit_setting" ( 1.52 - PRIMARY KEY ("member_id", "key", "unit_id"), 1.53 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.54 - "key" TEXT NOT NULL, 1.55 - "unit_id" INT4 REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.56 - "value" TEXT NOT NULL ); 1.57 - 1.58 -COMMENT ON TABLE "unit_setting" IS 'Place for frontend to store unit specific settings of members as strings'; 1.59 - 1.60 - 1.61 CREATE TABLE "area" ( 1.62 UNIQUE ("unit_id", "id"), -- index needed for foreign-key on table "event" 1.63 "id" SERIAL4 PRIMARY KEY, 1.64 @@ -682,16 +635,6 @@ 1.65 COMMENT ON TABLE "ignored_area" IS 'An entry in this table denotes that the member does not wish to receive notifications for the given subject area unless he/she declared interested in a particular issue'; 1.66 1.67 1.68 -CREATE TABLE "area_setting" ( 1.69 - PRIMARY KEY ("member_id", "key", "area_id"), 1.70 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.71 - "key" TEXT NOT NULL, 1.72 - "area_id" INT4 REFERENCES "area" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.73 - "value" TEXT NOT NULL ); 1.74 - 1.75 -COMMENT ON TABLE "area_setting" IS 'Place for frontend to store area specific settings of members as strings'; 1.76 - 1.77 - 1.78 CREATE TABLE "allowed_policy" ( 1.79 PRIMARY KEY ("area_id", "policy_id"), 1.80 "area_id" INT4 REFERENCES "area" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.81 @@ -858,16 +801,6 @@ 1.82 COMMENT ON COLUMN "issue_order_in_admission_state"."order_in_unit" IS 'Order of issues in admission state within all areas of a unit; NULL values sort last'; 1.83 1.84 1.85 -CREATE TABLE "issue_setting" ( 1.86 - PRIMARY KEY ("member_id", "key", "issue_id"), 1.87 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.88 - "key" TEXT NOT NULL, 1.89 - "issue_id" INT4 REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.90 - "value" TEXT NOT NULL ); 1.91 - 1.92 -COMMENT ON TABLE "issue_setting" IS 'Place for frontend to store issue specific settings of members as strings'; 1.93 - 1.94 - 1.95 CREATE TABLE "initiative" ( 1.96 UNIQUE ("issue_id", "id"), -- index needed for foreign-key on table "vote" 1.97 "issue_id" INT4 NOT NULL REFERENCES "issue" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.98 @@ -991,16 +924,6 @@ 1.99 COMMENT ON TABLE "ignored_initiative" IS 'An entry in this table denotes that the member does not wish to receive notifications for the given initiative'; 1.100 1.101 1.102 -CREATE TABLE "initiative_setting" ( 1.103 - PRIMARY KEY ("member_id", "key", "initiative_id"), 1.104 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.105 - "key" TEXT NOT NULL, 1.106 - "initiative_id" INT4 REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.107 - "value" TEXT NOT NULL ); 1.108 - 1.109 -COMMENT ON TABLE "initiative_setting" IS 'Place for frontend to store initiative specific settings of members as strings'; 1.110 - 1.111 - 1.112 CREATE TABLE "draft" ( 1.113 UNIQUE ("initiative_id", "id"), -- index needed for foreign-key on table "supporter" 1.114 "initiative_id" INT4 NOT NULL REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.115 @@ -1096,16 +1019,6 @@ 1.116 COMMENT ON TABLE "rendered_suggestion" IS 'This table may be used by frontends to cache "rendered" drafts (e.g. HTML output generated from wiki text)'; 1.117 1.118 1.119 -CREATE TABLE "suggestion_setting" ( 1.120 - PRIMARY KEY ("member_id", "key", "suggestion_id"), 1.121 - "member_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.122 - "key" TEXT NOT NULL, 1.123 - "suggestion_id" INT8 REFERENCES "suggestion" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.124 - "value" TEXT NOT NULL ); 1.125 - 1.126 -COMMENT ON TABLE "suggestion_setting" IS 'Place for frontend to store suggestion specific settings of members as strings'; 1.127 - 1.128 - 1.129 CREATE TABLE "temporary_suggestion_counts" ( 1.130 "id" INT8 PRIMARY KEY, -- NOTE: no referential integrity due to performance/locking issues; REFERENCES "suggestion" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.131 "minus2_unfulfilled_count" INT4 NOT NULL, 1.132 @@ -6313,18 +6226,11 @@ 1.133 "location" = NULL 1.134 WHERE "id" = "member_id_p"; 1.135 -- "text_search_data" is updated by triggers 1.136 - DELETE FROM "setting" WHERE "member_id" = "member_id_p"; 1.137 - DELETE FROM "setting_map" WHERE "member_id" = "member_id_p"; 1.138 - DELETE FROM "member_relation_setting" WHERE "member_id" = "member_id_p"; 1.139 DELETE FROM "member_image" WHERE "member_id" = "member_id_p"; 1.140 DELETE FROM "contact" WHERE "member_id" = "member_id_p"; 1.141 DELETE FROM "ignored_member" WHERE "member_id" = "member_id_p"; 1.142 DELETE FROM "session" WHERE "member_id" = "member_id_p"; 1.143 - DELETE FROM "area_setting" WHERE "member_id" = "member_id_p"; 1.144 - DELETE FROM "issue_setting" WHERE "member_id" = "member_id_p"; 1.145 DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p"; 1.146 - DELETE FROM "initiative_setting" WHERE "member_id" = "member_id_p"; 1.147 - DELETE FROM "suggestion_setting" WHERE "member_id" = "member_id_p"; 1.148 DELETE FROM "delegation" WHERE "truster_id" = "member_id_p"; 1.149 DELETE FROM "non_voter" WHERE "member_id" = "member_id_p"; 1.150 DELETE FROM "direct_voter" USING "issue" 1.151 @@ -6371,18 +6277,11 @@ 1.152 "password_reset_secret_expiry" = NULL, 1.153 "location" = NULL; 1.154 -- "text_search_data" is updated by triggers 1.155 - DELETE FROM "setting"; 1.156 - DELETE FROM "setting_map"; 1.157 - DELETE FROM "member_relation_setting"; 1.158 DELETE FROM "member_image"; 1.159 DELETE FROM "contact"; 1.160 DELETE FROM "ignored_member"; 1.161 DELETE FROM "session"; 1.162 - DELETE FROM "area_setting"; 1.163 - DELETE FROM "issue_setting"; 1.164 DELETE FROM "ignored_initiative"; 1.165 - DELETE FROM "initiative_setting"; 1.166 - DELETE FROM "suggestion_setting"; 1.167 DELETE FROM "non_voter"; 1.168 DELETE FROM "direct_voter" USING "issue" 1.169 WHERE "direct_voter"."issue_id" = "issue"."id"
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Fri Jul 14 20:20:26 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Fri Jul 14 20:27:33 2017 +0200 2.3 @@ -660,6 +660,15 @@ 2.4 CREATE INDEX "non_voter_issue_id_idx" ON "non_voter" ("issue_id"); 2.5 2.6 2.7 +DROP TABLE "setting"; 2.8 +DROP TABLE "setting_map"; 2.9 +DROP TABLE "member_relation_setting"; 2.10 +DROP TABLE "unit_setting"; 2.11 +DROP TABLE "area_setting"; 2.12 +DROP TABLE "initiative_setting"; 2.13 +DROP TABLE "suggestion_setting"; 2.14 + 2.15 + 2.16 ALTER TABLE "event" ADD COLUMN "other_member_id" INT4 REFERENCES "member" ("id") ON DELETE RESTRICT ON UPDATE CASCADE; 2.17 ALTER TABLE "event" ADD COLUMN "scope" "delegation_scope"; 2.18 ALTER TABLE "event" ADD COLUMN "unit_id" INT4 REFERENCES "unit" ("id") ON DELETE CASCADE ON UPDATE CASCADE; 2.19 @@ -3233,18 +3242,11 @@ 2.20 "location" = NULL 2.21 WHERE "id" = "member_id_p"; 2.22 -- "text_search_data" is updated by triggers 2.23 - DELETE FROM "setting" WHERE "member_id" = "member_id_p"; 2.24 - DELETE FROM "setting_map" WHERE "member_id" = "member_id_p"; 2.25 - DELETE FROM "member_relation_setting" WHERE "member_id" = "member_id_p"; 2.26 DELETE FROM "member_image" WHERE "member_id" = "member_id_p"; 2.27 DELETE FROM "contact" WHERE "member_id" = "member_id_p"; 2.28 DELETE FROM "ignored_member" WHERE "member_id" = "member_id_p"; 2.29 DELETE FROM "session" WHERE "member_id" = "member_id_p"; 2.30 - DELETE FROM "area_setting" WHERE "member_id" = "member_id_p"; 2.31 - DELETE FROM "issue_setting" WHERE "member_id" = "member_id_p"; 2.32 DELETE FROM "ignored_initiative" WHERE "member_id" = "member_id_p"; 2.33 - DELETE FROM "initiative_setting" WHERE "member_id" = "member_id_p"; 2.34 - DELETE FROM "suggestion_setting" WHERE "member_id" = "member_id_p"; 2.35 DELETE FROM "delegation" WHERE "truster_id" = "member_id_p"; 2.36 DELETE FROM "non_voter" WHERE "member_id" = "member_id_p"; 2.37 DELETE FROM "direct_voter" USING "issue" 2.38 @@ -3289,18 +3291,11 @@ 2.39 "password_reset_secret_expiry" = NULL, 2.40 "location" = NULL; 2.41 -- "text_search_data" is updated by triggers 2.42 - DELETE FROM "setting"; 2.43 - DELETE FROM "setting_map"; 2.44 - DELETE FROM "member_relation_setting"; 2.45 DELETE FROM "member_image"; 2.46 DELETE FROM "contact"; 2.47 DELETE FROM "ignored_member"; 2.48 DELETE FROM "session"; 2.49 - DELETE FROM "area_setting"; 2.50 - DELETE FROM "issue_setting"; 2.51 DELETE FROM "ignored_initiative"; 2.52 - DELETE FROM "initiative_setting"; 2.53 - DELETE FROM "suggestion_setting"; 2.54 DELETE FROM "non_voter"; 2.55 DELETE FROM "direct_voter" USING "issue" 2.56 WHERE "direct_voter"."issue_id" = "issue"."id"