liquid_feedback_core

changeset 534:b341544beb75

Renamed table "notification_event_sent" to "event_processed"
author jbe
date Fri Apr 21 12:42:43 2017 +0200 (2017-04-21)
parents d88fd3ae32d2
children 8b6433096a58
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Thu Mar 30 20:11:59 2017 +0200
     1.2 +++ b/core.sql	Fri Apr 21 12:42:43 2017 +0200
     1.3 @@ -1682,12 +1682,12 @@
     1.4  COMMENT ON COLUMN "event"."state"      IS 'If issue_id is set: state of affected issue; If state changed: new state';
     1.5  
     1.6  
     1.7 -CREATE TABLE "notification_event_sent" (
     1.8 +CREATE TABLE "event_processed" (
     1.9          "event_id"              INT8            NOT NULL );
    1.10 -CREATE UNIQUE INDEX "notification_event_sent_singleton_idx" ON "notification_event_sent" ((1));
    1.11 -
    1.12 -COMMENT ON TABLE "notification_event_sent" IS 'This table stores one row with the last event_id, for which notifications have been sent out';
    1.13 -COMMENT ON INDEX "notification_event_sent_singleton_idx" IS 'This index ensures that "notification_event_sent" only contains one row maximum.';
    1.14 +CREATE UNIQUE INDEX "event_processed_singleton_idx" ON "event_processed" ((1));
    1.15 +
    1.16 +COMMENT ON TABLE "event_processed" IS 'This table stores one row with the last event_id, for which event handlers have been executed (e.g. notifications having been sent out)';
    1.17 +COMMENT ON INDEX "event_processed_singleton_idx" IS 'This index ensures that "event_processed" only contains one row maximum.';
    1.18  
    1.19  
    1.20  CREATE TABLE "notification_initiative_sent" (
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Thu Mar 30 20:11:59 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Apr 21 12:42:43 2017 +0200
     2.3 @@ -907,6 +907,13 @@
     2.4              "old_text_value"  ISNULL ));
     2.5  
     2.6  
     2.7 +ALTER TABLE "notification_event_sent" RENAME TO "event_processed";
     2.8 +ALTER INDEX "notification_event_sent_singleton_idx" RENAME TO "event_processed_singleton_idx";
     2.9 +
    2.10 +COMMENT ON TABLE "event_processed" IS 'This table stores one row with the last event_id, for which event handlers have been executed (e.g. notifications having been sent out)';
    2.11 +COMMENT ON INDEX "event_processed_singleton_idx" IS 'This index ensures that "event_processed" only contains one row maximum.';
    2.12 +
    2.13 +
    2.14  CREATE OR REPLACE FUNCTION "write_event_issue_state_changed_trigger"()
    2.15    RETURNS TRIGGER
    2.16    LANGUAGE 'plpgsql' VOLATILE AS $$

Impressum / About Us