From 0e3545f4fad072b1348af23bbe6bf5a338ecbf41 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 13 Apr 2009 15:52:01 +0000 Subject: [PATCH] Clean up another minor typo (not referenced anywhere, apparently) git-svn-id: svn://svn.open-ils.org/ILS/trunk@12851 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 2 +- Open-ILS/src/sql/Pg/1.4-2.0-upgrade-db.sql | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index bc43428801..3d029ce75e 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -209,7 +209,7 @@ CREATE OR REPLACE VIEW action.open_circulation AS ORDER BY due_date; -CREATE OR REPLACE VIEW action.billable_cirulations AS +CREATE OR REPLACE VIEW action.billable_circulations AS SELECT * FROM action.circulation WHERE xact_finish IS NULL; diff --git a/Open-ILS/src/sql/Pg/1.4-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.4-2.0-upgrade-db.sql index f62b04e3f2..838ade78a6 100644 --- a/Open-ILS/src/sql/Pg/1.4-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.4-2.0-upgrade-db.sql @@ -25,4 +25,6 @@ ALTER TABLE asset.copy_tranparency_map RENAME COLUMN tansparency TO transparency ALTER TABLE asset.copy_tranparency_map RENAME TO copy_transparency_map; CREATE INDEX cp_tr_cp_idx ON asset.copy_transparency_map (transparency); +ALTER VIEW action.billable_cirulations RENAME TO billable_circulations; + COMMIT; -- 2.11.0