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 $$