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

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 (file)
--- 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 (file)
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;