From d0f7edf29a63cde08dc1d72a94eb3dcc7c31dca2 Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 11 Jul 2010 23:41:36 +0000 Subject: [PATCH] thinko in upgrade script git-svn-id: svn://svn.open-ils.org/ILS/trunk@16905 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/sql/Pg/upgrade/0330.schema.facet_entry_table.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0330.schema.facet_entry_table.sql b/Open-ILS/src/sql/Pg/upgrade/0330.schema.facet_entry_table.sql index 799aa43b7a..dfb0babfaa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0330.schema.facet_entry_table.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0330.schema.facet_entry_table.sql @@ -11,17 +11,17 @@ CREATE TABLE metabib.facet_entry ( INSERT INTO metabib.facet_entry (source, field, value) SELECT source, field, value FROM ( - SELECT source, field, value FROM metabib.author_field_entry + SELECT * FROM metabib.author_field_entry UNION ALL - SELECT source, field, value FROM metabib.keyword_field_entry + SELECT * FROM metabib.keyword_field_entry UNION ALL - SELECT source, field, value FROM metabib.identifier_field_entry + SELECT * FROM metabib.identifier_field_entry UNION ALL - SELECT source, field, value FROM metabib.title_field_entry + SELECT * FROM metabib.title_field_entry UNION ALL - SELECT source, field, value FROM metabib.subject_field_entry + SELECT * FROM metabib.subject_field_entry UNION ALL - SELECT source, field, value FROM metabib.series_field_entry + SELECT * FROM metabib.series_field_entry )x WHERE x.index_vector = ''; -- 2.11.0