From 2318520622ef5924c43c1ce2063012c8ebe9057e Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Mon, 13 Jun 2011 11:00:36 -0400 Subject: [PATCH] Typo, we need commas Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/990.schema.unapi.sql | 10 ++++++++-- .../0557.schema.in-db_unapi_copy_related_visibility-1.sql | 2 +- .../0558.schema.in-db_unapi_copy_related_visibility-2.sql | 2 +- 3 files changed, 10 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/990.schema.unapi.sql b/Open-ILS/src/sql/Pg/990.schema.unapi.sql index 4cfa20cb7f..c12a3a864d 100644 --- a/Open-ILS/src/sql/Pg/990.schema.unapi.sql +++ b/Open-ILS/src/sql/Pg/990.schema.unapi.sql @@ -529,7 +529,11 @@ CREATE OR REPLACE FUNCTION unapi.acl ( obj_id BIGINT, format TEXT, ename TEXT, name location, XMLATTRIBUTES( CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, - id AS ident + id AS ident, + holdable, + opac_visible, + label_prefix AS prefix, + label_suffix AS suffix ), name ) @@ -542,7 +546,9 @@ CREATE OR REPLACE FUNCTION unapi.ccs ( obj_id BIGINT, format TEXT, ename TEXT, name status, XMLATTRIBUTES( CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, - id AS ident + id AS ident, + holdable, + opac_visible ), name ) diff --git a/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql b/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql index 8157b6b59c..15c1e9d13e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0557.schema.in-db_unapi_copy_related_visibility-1.sql @@ -12,7 +12,7 @@ CREATE OR REPLACE FUNCTION unapi.acl ( obj_id BIGINT, format TEXT, ename TEXT, name location, XMLATTRIBUTES( CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, - id AS ident + id AS ident, holdable, opac_visible, label_prefix AS prefix, diff --git a/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql b/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql index 3931f0fb60..0d5eb6307a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0558.schema.in-db_unapi_copy_related_visibility-2.sql @@ -12,7 +12,7 @@ CREATE OR REPLACE FUNCTION unapi.ccs ( obj_id BIGINT, format TEXT, ename TEXT, name status, XMLATTRIBUTES( CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, - id AS ident + id AS ident, holdable, opac_visible ), -- 2.11.0