From cf982a7931c52f4502d281af1f602fa60a1dd8eb Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 7 Nov 2018 10:31:05 -0500 Subject: [PATCH] lp1709698_nullable_reporter_descriptions --- Open-ILS/src/sql/Pg/reporter-schema.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/xxxx.schema.reporter.template.sql | 2 ++ Open-ILS/src/templates/staff/reporter/t_edit_template.tt2 | 2 +- 3 files changed, 4 insertions(+), 2 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.reporter.template.sql diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index ce302a6f9b..116802fea3 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -66,7 +66,7 @@ CREATE TABLE reporter.template ( owner INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), name TEXT NOT NULL, - description TEXT NOT NULL, + description TEXT, data TEXT NOT NULL, folder INT NOT NULL REFERENCES reporter.template_folder (id) DEFERRABLE INITIALLY DEFERRED ); diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.reporter.template.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.reporter.template.sql new file mode 100644 index 0000000000..ff16f4c972 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.reporter.template.sql @@ -0,0 +1,2 @@ +ALTER TABLE reporter.template ALTER COLUMN description DROP NOT NULL; + diff --git a/Open-ILS/src/templates/staff/reporter/t_edit_template.tt2 b/Open-ILS/src/templates/staff/reporter/t_edit_template.tt2 index fbb266d3a0..135a5bae5d 100644 --- a/Open-ILS/src/templates/staff/reporter/t_edit_template.tt2 +++ b/Open-ILS/src/templates/staff/reporter/t_edit_template.tt2 @@ -21,7 +21,7 @@ [% l('Template Description') %]
-