From cf7fabd64e8ccd98012a80a8e9b7a84b5d17e966 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 16 Mar 2011 19:16:43 +0000 Subject: [PATCH] Make a back-compat version of item_lang for QP git-svn-id: svn://svn.open-ils.org/ILS/trunk@19788 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 1 + .../upgrade/0501.data.QP_language_vs_item_lang.sql | 9 +++++++++ 2 files changed, 10 insertions(+), 0 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0501.data.QP_language_vs_item_lang.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index e0727e9..0c33834 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -3475,6 +3475,7 @@ INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('gpub INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('ills','Ills','Ills'); INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('indx','Indx','Indx'); INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('item_lang','Lang','Lang'); +INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('language','Language (2.0 compat version)','Lang'); INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('lit_form','LitF','LitF'); INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('mrec','MRec','MRec'); INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('ff_sl','S/L','S/L'); diff --git a/Open-ILS/src/sql/Pg/upgrade/0501.data.QP_language_vs_item_lang.sql b/Open-ILS/src/sql/Pg/upgrade/0501.data.QP_language_vs_item_lang.sql new file mode 100644 index 0000000..8d1864d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0501.data.QP_language_vs_item_lang.sql @@ -0,0 +1,9 @@ + +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0501'); -- miker + +INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('language','Language (2.0 compat version)','Lang'); +UPDATE metabib.record_attr SET attrs = attrs || hstore('language',(attrs->'item_lang')); + +COMMIT; -- 1.7.2.5