From 490f2925da4bc4fdeb70870f2bef5be045224c1a Mon Sep 17 00:00:00 2001 From: scottmk Date: Wed, 21 Oct 2009 20:39:24 +0000 Subject: [PATCH] Add new column to auditor.actor_user_history to match the one just added to actor.usr. M Pg/002.schema.config.sql A Pg/upgrade/0046.au_hist_claims_never_checked_out.sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@14543 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../src/sql/Pg/upgrade/0046.au_hist_claims_never_checked_out.sql | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0046.au_hist_claims_never_checked_out.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index e79f10508c..62863bd161 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -51,7 +51,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0045'); -- berick +INSERT INTO config.upgrade_log (version) VALUES ('0046'); -- Scott McKellar CREATE TABLE config.bib_source ( diff --git a/Open-ILS/src/sql/Pg/upgrade/0046.au_hist_claims_never_checked_out.sql b/Open-ILS/src/sql/Pg/upgrade/0046.au_hist_claims_never_checked_out.sql new file mode 100644 index 0000000000..468f912257 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0046.au_hist_claims_never_checked_out.sql @@ -0,0 +1,8 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0046'); -- Scott McKellar + +ALTER TABLE AUDITOR.actor_usr_history ADD COLUMN + claims_never_checked_out_count INT NOT NULL DEFAULT 0; + +COMMIT; -- 2.11.0