X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2F21-fixed-fields.sql;h=8f79934d84dc02e97c4f5784ac64916362c2ed03;hp=7ab674823567e665c508041b8fa21c25e1a02373;hb=6ed678d10d4446c64e90db7b585ffe748353c24c;hpb=2b587ddbb20cc567e3435c6d936e1521eb380047

diff --git a/sql/base/21-fixed-fields.sql b/sql/base/21-fixed-fields.sql
index 7ab6748..8f79934 100644
--- a/sql/base/21-fixed-fields.sql
+++ b/sql/base/21-fixed-fields.sql
@@ -1,7 +1,7 @@
 DROP TABLE IF EXISTS migration_tools.search_format_map;
 CREATE TABLE migration_tools.search_format_map (code TEXT, itype CHAR(1), iform CHAR(1), phy CHAR(1), phyv CHAR(1), phyp SMALLINT,
     biblevel CHAR(1), iform_exclude CHAR(1)[], srform_exclude CHAR(1)[] );
-INSERT INTO search_format_map (code, itype, iform, phy, phyv, phyp, biblevel, iform_exclude, srform_exclude) VALUES
+INSERT INTO migration_tools.search_format_map (code, itype, iform, phy, phyv, phyp, biblevel, iform_exclude, srform_exclude) VALUES
     --                  itype iform phy   phyv  phyp  bib   itemform exclude     sr format exclude
      ('blu-ray',        'g',  NULL, 'v',  's',  4,    NULL, NULL,                NULL)
     ,('book',           'a',  NULL, NULL, NULL, NULL, 'a',  '{a,b,c,f,o,q,r,s}', NULL)
@@ -249,7 +249,7 @@ DECLARE
     icon    TEXT[];
     vlist   INTEGER[];
 BEGIN
-    SELECT reingest_staged_record_attributes(rid) INTO vlist;
+    SELECT migration_tools.reingest_staged_record_attributes(rid) INTO vlist;
 
     RETURN QUERY SELECT ctype, code, value FROM config.coded_value_map WHERE id IN (SELECT UNNEST(vlist));
 END;
@@ -260,7 +260,7 @@ DECLARE
 	search	TEXT[];
 	vlist	INTEGER[];
 BEGIN
-	SELECT reingest_staged_record_attributes(rid) INTO vlist;
+	SELECT migration_tools.reingest_staged_record_attributes(rid) INTO vlist;
 
 	SELECT ARRAY_AGG(code) FROM config.coded_value_map WHERE id IN (SELECT UNNEST(vlist)) 
 		AND ctype = 'search_format' INTO search;
@@ -274,7 +274,7 @@ DECLARE
     search  TEXT[];
     vlist   INTEGER[];
 BEGIN
-    SELECT reingest_staged_record_attributes(rid) INTO vlist;
+    SELECT migration_tools.reingest_staged_record_attributes(rid) INTO vlist;
 
     SELECT ARRAY_AGG(code) FROM config.coded_value_map WHERE id IN (SELECT UNNEST(vlist))
         AND ctype = 'search_format' INTO search;
@@ -289,7 +289,7 @@ DECLARE
     search  TEXT[];
     vlist   INTEGER[];
 BEGIN
-    SELECT reingest_staged_record_attributes(rid) INTO vlist;
+    SELECT migration_tools.reingest_staged_record_attributes(rid) INTO vlist;
 
     SELECT ARRAY_AGG(code) FROM config.coded_value_map WHERE id IN (SELECT UNNEST(vlist))
         AND ctype = 'search_format' INTO search;
@@ -406,7 +406,7 @@ DECLARE
 	yiform_exclude 		TEXT;
 	ysrform_exclude     TEXT;
 BEGIN
-    SELECT itype, iform, phy, phyv, phyp, biblevel, iform_exclude, srform_exclude FROM search_format_map WHERE code = xcode
+    SELECT itype, iform, phy, phyv, phyp, biblevel, iform_exclude, srform_exclude FROM migration_tools.search_format_map WHERE code = xcode
         INTO xitype, xiform, xphy, xphyv, xphyp, xbiblevel, xiform_exclude, xsrform_exclude;
 	IF xiform_exclude IS NOT NULL THEN 
 		yiform_exclude := ARRAY_TO_STRING(xiform_exclude,',');