From 5f5a6b785076cd97c10b43bf717b8bf8bd49c1e7 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 15 Apr 2016 11:23:33 -0400 Subject: [PATCH] LP#1570909 User activity transient default Only retain the most recent user activity entry (per activity type) by default. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql | 10 ++++++++++ 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 344c31658b..31ffca615d 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -1004,7 +1004,7 @@ CREATE TABLE config.usr_activity_type ( label TEXT NOT NULL, -- i18n egroup config.usr_activity_group NOT NULL, enabled BOOL NOT NULL DEFAULT TRUE, - transient BOOL NOT NULL DEFAULT FALSE, + transient BOOL NOT NULL DEFAULT TRUE, CONSTRAINT one_of_wwh CHECK (COALESCE(ewho,ewhat,ehow) IS NOT NULL) ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql new file mode 100644 index 0000000000..02d4a8bc29 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql @@ -0,0 +1,10 @@ + +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE config.usr_activity_type + ALTER COLUMN transient SET DEFAULT TRUE; + +COMMIT; + -- 2.11.0