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"

Impressum / About Us