From b1f4d599b87a375ab43b7439dcc2ba1208c7c5be 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 Signed-off-by: Chris Sharp Signed-off-by: Mike Rylander --- 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 0c8e9ad520..6feebdd335 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -1007,7 +1007,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