From 98a343f005bfbd845a80a96c0b9adcaa58c6ebf0 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Sat, 3 Dec 2011 10:40:05 -0500
Subject: [PATCH] adding config.metabib_field fix to pre-1.6 upgrade script

---
 .../sql/Pg/pines-16-21-auth_recs_to_be_deleted.sql | 3903 ++++++++++++++++++++
 .../src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql     |   70 +-
 2 files changed, 3972 insertions(+), 1 deletion(-)
 create mode 100644 Open-ILS/src/sql/Pg/pines-16-21-auth_recs_to_be_deleted.sql

diff --git a/Open-ILS/src/sql/Pg/pines-16-21-auth_recs_to_be_deleted.sql b/Open-ILS/src/sql/Pg/pines-16-21-auth_recs_to_be_deleted.sql
new file mode 100644
index 0000000000..aa4157473c
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/pines-16-21-auth_recs_to_be_deleted.sql
@@ -0,0 +1,3903 @@
+BEGIN;
+UPDATE authority.record_entry SET editor = 1, edit_date = now(), deleted = TRUE WHERE id IN (
+167761,
+55251,
+173250,
+62409,
+187674,
+164911,
+162394,
+159238,
+181261,
+167425,
+173620,
+156689,
+235420,
+39786,
+176657,
+199001,
+188657,
+186875,
+329745,
+58806,
+93155,
+166337,
+177809,
+374947,
+187533,
+137455,
+170030,
+53512,
+182532,
+188147,
+23234,
+357495,
+26449,
+26281,
+507147,
+140976,
+71555,
+180113,
+498867,
+166995,
+182518,
+186686,
+222062,
+297975,
+44860,
+156812,
+175612,
+68263,
+153226,
+158969,
+143655,
+180209,
+189016,
+215280,
+182692,
+181304,
+152675,
+164573,
+180228,
+287484,
+251150,
+103609,
+61283,
+153791,
+335079,
+52993,
+227001,
+188104,
+99545,
+312446,
+499426,
+261690,
+191683,
+158615,
+185898,
+268244,
+18847,
+167117,
+148642,
+158067,
+166742,
+154833,
+183792,
+56018,
+502539,
+182620,
+167324,
+167921,
+6296,
+182963,
+163115,
+179325,
+35027,
+346853,
+10113,
+185841,
+55533,
+177814,
+177271,
+172838,
+180469,
+181181,
+364529,
+47256,
+167978,
+153010,
+173041,
+505950,
+144098,
+181361,
+480851,
+156365,
+159150,
+172496,
+184395,
+22288,
+22289,
+181674,
+114017,
+183411,
+170752,
+186280,
+173368,
+168571,
+45956,
+172419,
+219118,
+167401,
+169126,
+221485,
+341427,
+203972,
+234457,
+171954,
+159639,
+165218,
+35745,
+177804,
+175323,
+183089,
+177226,
+279179,
+17765,
+245405,
+157519,
+152225,
+168697,
+306875,
+339397,
+16037,
+239240,
+149419,
+139117,
+104314,
+15948,
+649,
+384443,
+219367,
+160961,
+386925,
+160386,
+161984,
+242912,
+37570,
+141342,
+53290,
+170454,
+161249,
+144550,
+464099,
+273303,
+173579,
+42115,
+164898,
+200187,
+168740,
+167367,
+181063,
+43487,
+113289,
+172729,
+98253,
+292771,
+496886,
+335504,
+152046,
+302734,
+181692,
+173517,
+485307,
+186445,
+490551,
+187787,
+158500,
+482344,
+169687,
+61460,
+351995,
+336379,
+186655,
+185859,
+95745,
+181382,
+178630,
+138921,
+480856,
+318449,
+153797,
+78351,
+231471,
+168013,
+171025,
+169729,
+157129,
+186161,
+159477,
+180931,
+263014,
+164837,
+277602,
+213207,
+161123,
+174472,
+171054,
+171252,
+166981,
+180587,
+342621,
+157480,
+48369,
+177288,
+85151,
+212014,
+3708,
+171968,
+498970,
+402340,
+167850,
+181216,
+496973,
+295637,
+172679,
+63657,
+166587,
+69893,
+363935,
+173309,
+169468,
+156680,
+279535,
+35305,
+101469,
+175356,
+185979,
+1134,
+56014,
+173282,
+188052,
+181952,
+188045,
+183488,
+170990,
+166252,
+48382,
+170675,
+40944,
+171531,
+99603,
+49349,
+185917,
+187072,
+188610,
+231666,
+188955,
+159256,
+172584,
+114030,
+497133,
+188152,
+178831,
+58335,
+6517,
+27797,
+167751,
+167391,
+84644,
+92240,
+161058,
+77423,
+181199,
+85415,
+146199,
+169526,
+496019,
+183012,
+173146,
+469704,
+127230,
+167532,
+165801,
+160834,
+172579,
+151894,
+187133,
+188350,
+190046,
+229802,
+333369,
+169499,
+171970,
+163878,
+159966,
+167845,
+158536,
+168884,
+166720,
+171961,
+32136,
+188996,
+177842,
+147805,
+170865,
+161197,
+339584,
+304418,
+159264,
+183453,
+201955,
+172637,
+167689,
+72101,
+151877,
+498752,
+164618,
+153039,
+131794,
+152858,
+167370,
+170685,
+172106,
+156234,
+179943,
+147383,
+166282,
+148041,
+188199,
+109649,
+222363,
+126977,
+172120,
+479978,
+60797,
+487084,
+322879,
+256762,
+44457,
+180564,
+26031,
+216957,
+291293,
+392296,
+42044,
+184007,
+141631,
+173333,
+152360,
+193157,
+27352,
+138131,
+161151,
+334241,
+181413,
+170840,
+267537,
+267974,
+162849,
+151787,
+155490,
+466627,
+183736,
+187373,
+159595,
+371885,
+171007,
+171414,
+110924,
+182576,
+178824,
+156175,
+171106,
+173266,
+182675,
+471524,
+78152,
+183625,
+302567,
+161426,
+60982,
+311770,
+158682,
+362023,
+23107,
+160146,
+90506,
+151931,
+163325,
+171081,
+22740,
+209407,
+188178,
+224237,
+180278,
+177365,
+170170,
+181968,
+145722,
+293911,
+53819,
+377191,
+193369,
+390074,
+56091,
+482490,
+153504,
+182548,
+178578,
+188783,
+165734,
+178829,
+235497,
+170715,
+321498,
+186567,
+163852,
+473360,
+24980,
+186803,
+171940,
+496656,
+159121,
+193352,
+180974,
+237183,
+496855,
+188452,
+93970,
+24815,
+168456,
+186843,
+164784,
+187829,
+160927,
+23662,
+158817,
+149542,
+160413,
+158501,
+165942,
+496958,
+171423,
+142194,
+24481,
+166646,
+168620,
+171941,
+335808,
+165539,
+277917,
+341896,
+183465,
+338490,
+282252,
+251417,
+360724,
+188250,
+388395,
+205927,
+188252,
+188046,
+192388,
+159584,
+163168,
+213279,
+474484,
+25403,
+82696,
+166800,
+339353,
+116110,
+172111,
+31675,
+61201,
+103079,
+186914,
+49210,
+168794,
+25247,
+183173,
+123703,
+197498,
+26700,
+90805,
+170140,
+167337,
+26947,
+144241,
+242146,
+133942,
+214046,
+162431,
+180212,
+39755,
+125265,
+74167,
+302953,
+120748,
+181446,
+299920,
+86949,
+255187,
+182652,
+173512,
+305527,
+358719,
+73147,
+166706,
+74276,
+144251,
+145307,
+66409,
+164955,
+189058,
+170774,
+309785,
+131219,
+82192,
+86484,
+185998,
+200755,
+5049,
+325118,
+165850,
+170645,
+163943,
+187895,
+183579,
+258663,
+463095,
+180029,
+116496,
+98605,
+219750,
+497833,
+186762,
+159215,
+42766,
+160126,
+131450,
+170163,
+120201,
+303474,
+172663,
+124706,
+319019,
+170181,
+52287,
+158156,
+167012,
+139097,
+258237,
+302975,
+188014,
+169611,
+187071,
+157304,
+185940,
+170950,
+172594,
+312683,
+407772,
+321948,
+164232,
+125975,
+188459,
+375785,
+36832,
+111583,
+76414,
+159094,
+231010,
+186461,
+80148,
+167366,
+164757,
+73332,
+165920,
+181688,
+171566,
+449509,
+224832,
+86116,
+336382,
+62587,
+482630,
+491807,
+16697,
+156467,
+181187,
+17079,
+161048,
+17080,
+133692,
+224574,
+169236,
+188472,
+179385,
+163405,
+162834,
+163404,
+311188,
+180419,
+182462,
+25791,
+188583,
+180848,
+161727,
+168661,
+281308,
+183834,
+166889,
+104671,
+167869,
+166713,
+167571,
+183009,
+160309,
+182102,
+171753,
+232925,
+187959,
+148967,
+496698,
+327325,
+38561,
+162965,
+337385,
+166578,
+167464,
+300983,
+172898,
+169959,
+57651,
+24808,
+187853,
+201888,
+21081,
+278483,
+167302,
+188340,
+159165,
+158873,
+166045,
+350643,
+89367,
+183413,
+180614,
+344524,
+171660,
+66802,
+188405,
+183520,
+175882,
+67348,
+151872,
+186234,
+170924,
+26848,
+496938,
+172769,
+168201,
+178902,
+147289,
+180440,
+156395,
+169169,
+221357,
+163113,
+172099,
+3726,
+158844,
+40428,
+177322,
+173474,
+165989,
+188132,
+151578,
+160170,
+177793,
+161744,
+170908,
+173079,
+172844,
+159192,
+230891,
+163797,
+45472,
+183230,
+158529,
+162469,
+341973,
+187431,
+147077,
+188501,
+188640,
+186981,
+175311,
+179888,
+167416,
+158683,
+164452,
+300765,
+169452,
+187501,
+96458,
+464635,
+178473,
+219584,
+180657,
+358371,
+357786,
+44910,
+177237,
+320995,
+204691,
+180968,
+153387,
+175520,
+130614,
+188088,
+181998,
+173299,
+20134,
+172734,
+167057,
+180396,
+163381,
+188222,
+186759,
+155229,
+175636,
+170102,
+377521,
+497161,
+140957,
+164086,
+168855,
+183183,
+170121,
+188418,
+287429,
+60662,
+166243,
+172813,
+148473,
+126873,
+180452,
+50000,
+62637,
+174049,
+151878,
+183475,
+185882,
+161653,
+153948,
+188934,
+169211,
+410015,
+201960,
+172846,
+161834,
+213539,
+75802,
+104688,
+462501,
+181973,
+65218,
+172900,
+167725,
+172589,
+229062,
+239958,
+21887,
+187378,
+186742,
+181954,
+175542,
+156261,
+171284,
+172817,
+121205,
+186297,
+176369,
+149373,
+181051,
+186757,
+188201,
+201597,
+170787,
+33064,
+57455,
+283470,
+172726,
+13754,
+173304,
+146633,
+12381,
+356981,
+248736,
+161606,
+46235,
+153108,
+64250,
+158860,
+283965,
+57784,
+158949,
+177206,
+216630,
+13714,
+172553,
+173154,
+316852,
+167716,
+463291,
+168774,
+173406,
+85488,
+215250,
+164588,
+479777,
+52006,
+168968,
+258142,
+165982,
+4079,
+148611,
+180596,
+187183,
+151415,
+168618,
+5705,
+154446,
+483237,
+9500,
+396438,
+160764,
+170202,
+158111,
+323037,
+186103,
+180364,
+175655,
+181784,
+253674,
+167895,
+280232,
+135439,
+149552,
+180933,
+188504,
+187657,
+167095,
+169344,
+162047,
+171564,
+188679,
+183797,
+119535,
+172229,
+339734,
+166822,
+10261,
+242370,
+180945,
+151924,
+170045,
+395957,
+10302,
+153703,
+177219,
+387022,
+36549,
+180962,
+162675,
+161584,
+19678,
+146674,
+231918,
+41064,
+181065,
+93994,
+139155,
+258274,
+170794,
+172381,
+133976,
+165535,
+86996,
+156620,
+52224,
+165559,
+64441,
+164638,
+171028,
+216378,
+74762,
+304493,
+81874,
+235843,
+172741,
+171392,
+154455,
+183247,
+171697,
+152593,
+163303,
+365478,
+72349,
+188374,
+183865,
+168491,
+88298,
+170195,
+178090,
+56025,
+182007,
+180362,
+156010,
+161011,
+163299,
+189007,
+318933,
+153243,
+56048,
+186508,
+188035,
+496363,
+18938,
+172465,
+18932,
+15666,
+185958,
+79168,
+169962,
+261350,
+180000,
+222035,
+179301,
+148275,
+494233,
+9239,
+171156,
+186484,
+181927,
+337442,
+87792,
+156891,
+191959,
+186328,
+158700,
+157840,
+154656,
+158944,
+139337,
+170252,
+183861,
+43374,
+182962,
+159218,
+15522,
+1829,
+188058,
+287343,
+328563,
+175687,
+171427,
+95332,
+182031,
+165811,
+188182,
+168875,
+86771,
+171396,
+148754,
+169624,
+56829,
+162283,
+186209,
+183518,
+219192,
+496725,
+186838,
+173175,
+173174,
+163587,
+156258,
+34375,
+349617,
+234645,
+163059,
+161173,
+147825,
+158251,
+168943,
+355897,
+168827,
+170796,
+172214,
+166983,
+141020,
+173603,
+166930,
+464509,
+300204,
+158508,
+108056,
+169198,
+163211,
+186660,
+51004,
+194997,
+167627,
+169811,
+317920,
+169456,
+286440,
+344158,
+69434,
+470619,
+175649,
+499841,
+123816,
+154486,
+79673,
+152535,
+414798,
+23823,
+45175,
+77275,
+73954,
+188841,
+137540,
+168348,
+311286,
+292826,
+55787,
+118374,
+240981,
+3737,
+74996,
+146668,
+168206,
+67469,
+496579,
+390625,
+323829,
+163092,
+9309,
+295128,
+183146,
+165943,
+211202,
+171480,
+157136,
+166008,
+393286,
+104001,
+487386,
+163751,
+160314,
+58763,
+130646,
+181972,
+185953,
+202113,
+188701,
+166719,
+245323,
+153756,
+168279,
+183640,
+87344,
+54277,
+183617,
+21953,
+25135,
+188536,
+147771,
+112613,
+133113,
+163001,
+73414,
+147903,
+174711,
+363806,
+225837,
+57041,
+161046,
+349042,
+181353,
+162856,
+357028,
+186691,
+196145,
+174048,
+462798,
+169696,
+62367,
+169471,
+23116,
+156200,
+168366,
+183028,
+188535,
+90387,
+113385,
+92758,
+482894,
+163846,
+183213,
+166554,
+161025,
+353996,
+163397,
+178917,
+170724,
+82949,
+182043,
+376158,
+165915,
+447328,
+163594,
+165739,
+169387,
+163769,
+183525,
+258234,
+167881,
+159158,
+223640,
+175360,
+181362,
+187538,
+196733,
+16595,
+187716,
+177251,
+396868,
+207055,
+1936,
+177811,
+177841,
+65859,
+335751,
+186496,
+481126,
+145322,
+167328,
+330872,
+16536,
+170211,
+45683,
+186580,
+169726,
+121472,
+17257,
+171389,
+372217,
+369578,
+22518,
+36596,
+172076,
+179032,
+183106,
+175411,
+16154,
+170580,
+180438,
+164368,
+277990,
+185829,
+173352,
+186452,
+295743,
+56788,
+188272,
+166870,
+165051,
+357097,
+165421,
+352771,
+19005,
+218600,
+160954,
+337050,
+329735,
+322705,
+158890,
+249557,
+179250,
+146680,
+173153,
+94863,
+148164,
+171528,
+111772,
+168589,
+166796,
+148762,
+166325,
+186948,
+78801,
+188974,
+169368,
+152032,
+168048,
+45120,
+480912,
+167130,
+168822,
+154686,
+179919,
+19994,
+85192,
+193475,
+151856,
+340693,
+195157,
+181386,
+239433,
+169173,
+173134,
+173446,
+176641,
+105786,
+482835,
+183950,
+180194,
+181356,
+24924,
+141990,
+168305,
+45145,
+157878,
+26013,
+348668,
+182459,
+380262,
+373393,
+24169,
+23499,
+166953,
+158008,
+81803,
+41070,
+107196,
+395409,
+165749,
+225589,
+290581,
+180468,
+83509,
+170233,
+166232,
+97854,
+495158,
+471798,
+223769,
+163854,
+73233,
+466295,
+466903,
+344986,
+182674,
+159644,
+27808,
+154547,
+169659,
+129679,
+162840,
+168966,
+338677,
+446569,
+186565,
+168694,
+179299,
+187228,
+277598,
+175301,
+175693,
+129657,
+188361,
+245850,
+167580,
+93243,
+187479,
+175433,
+161028,
+291810,
+163849,
+396743,
+165707,
+91252,
+171357,
+156168,
+182034,
+178033,
+157363,
+381285,
+277453,
+463622,
+170700,
+187483,
+187617,
+163065,
+138631,
+144117,
+323739,
+327609,
+163203,
+168762,
+67926,
+164241,
+187857,
+394456,
+137945,
+21342,
+464533,
+372984,
+98107,
+180255,
+84198,
+326849,
+303092,
+21434,
+85150,
+135111,
+186995,
+102631,
+168769,
+152107,
+175547,
+212865,
+166189,
+96865,
+186555,
+111463,
+183182,
+456813,
+40550,
+168312,
+167309,
+221564,
+205088,
+187275,
+186987,
+190042,
+48064,
+169594,
+168235,
+187491,
+497852,
+171195,
+156027,
+41471,
+167137,
+152280,
+59964,
+73051,
+357715,
+169488,
+186596,
+160335,
+182055,
+179231,
+176664,
+179275,
+502531,
+160937,
+474722,
+161280,
+180752,
+264734,
+167496,
+103155,
+179999,
+170776,
+32972,
+44989,
+103793,
+182681,
+123883,
+200593,
+172762,
+343859,
+162916,
+261545,
+178863,
+217340,
+156884,
+176656,
+341617,
+162559,
+182021,
+177305,
+105012,
+167900,
+168110,
+69447,
+188930,
+127036,
+159025,
+512558,
+163782,
+175393,
+276737,
+167886,
+25886,
+188898,
+172490,
+254731,
+169286,
+28092,
+168815,
+98903,
+172602,
+165907,
+182545,
+188158,
+155344,
+83548,
+367565,
+218778,
+73890,
+186725,
+181339,
+170782,
+77177,
+222119,
+479760,
+297640,
+162775,
+171559,
+36036,
+232260,
+36955,
+242056,
+25618,
+479436,
+83621,
+377984,
+185911,
+154777,
+3177,
+166845,
+37191,
+153573,
+203592,
+71781,
+283960,
+170805,
+161644,
+142162,
+270247,
+68328,
+91560,
+111297,
+159958,
+35054,
+223941,
+36424,
+157891,
+321087,
+179354,
+180810,
+197760,
+67221,
+91908,
+168882,
+188669,
+740,
+153220,
+157792,
+265089,
+180400,
+183429,
+181228,
+180266,
+28561,
+466219,
+466996,
+187888,
+200038,
+168993,
+172773,
+172820,
+465349,
+70597,
+496979,
+160970,
+169217,
+217157,
+486351,
+228887,
+28745,
+60779,
+138848,
+137632,
+28760,
+165912,
+247115,
+136308,
+180696,
+179387,
+187452,
+169420,
+258078,
+144632,
+181963,
+183768,
+157361,
+187032,
+143679,
+359999,
+115434,
+160791,
+163945,
+179288,
+28180,
+188883,
+229070,
+115354,
+520541,
+180686,
+166797,
+188337,
+463039,
+175335,
+52050,
+205809,
+134801,
+83633,
+259110,
+351485,
+481093,
+179081,
+155470,
+166813,
+167814,
+480779,
+241411,
+171374,
+463032,
+464311,
+119522,
+159134,
+186098,
+64282,
+186489,
+165742,
+296664,
+180381,
+188607,
+147384,
+181549,
+171421,
+181357,
+180754,
+188903,
+468729,
+257655,
+180191,
+188420,
+341887,
+497089,
+163759,
+470202,
+170221,
+464395,
+172363,
+499371,
+181969,
+327984,
+169370,
+134235,
+163421,
+170822,
+171246,
+186726,
+154846,
+160807,
+166046,
+187758,
+152390,
+217933,
+143878,
+153082,
+213883,
+157998,
+77176,
+391130,
+241905,
+107729,
+236477,
+55061,
+163626,
+165877,
+171038,
+187124,
+29030,
+183022,
+278574,
+165150,
+56565,
+167454,
+164467,
+481106,
+361173,
+216414,
+161659,
+182491,
+38728,
+181949,
+166964,
+187469,
+186490,
+95864,
+85185,
+183532,
+160137,
+169505,
+170810,
+464128,
+163871,
+112004,
+186844,
+113343,
+168447,
+2899,
+371200,
+183586,
+165830,
+168129,
+59919,
+352569,
+161523,
+147786,
+163547,
+119724,
+395196,
+169205,
+169674,
+157445,
+182648,
+305556,
+77836,
+171224,
+171687,
+180845,
+390356,
+387634,
+159062,
+178957,
+261710,
+169511,
+162219,
+158722,
+181986,
+53990,
+176458,
+280692,
+335086,
+72787,
+254841,
+160802,
+110117,
+186119,
+217231,
+29836,
+239520,
+387839,
+168032,
+167423,
+168748,
+497173,
+183851,
+182045,
+165448,
+183527,
+169021,
+187225,
+155702,
+249029,
+171536,
+185929,
+183741,
+171669,
+180631,
+168155,
+51102,
+154320,
+472337,
+284819,
+158669,
+464489,
+225802,
+166962,
+169098,
+171727,
+331455,
+496453,
+104414,
+161265,
+30236,
+151383,
+201637,
+167686,
+170679,
+474944,
+48746,
+159147,
+236294,
+106520,
+335027,
+512583,
+37886,
+188426,
+175110,
+383596,
+141857,
+187695,
+170383,
+69216,
+171494,
+25871,
+169943,
+166354,
+443971,
+162449,
+180366,
+162938,
+163281,
+239832,
+464166,
+46231,
+171242,
+182668,
+235111,
+48251,
+165436,
+175692,
+64854,
+147935,
+515422,
+395236,
+168629,
+180793,
+187436,
+168028,
+190481,
+157512,
+47961,
+178969,
+165941,
+181212,
+168567,
+166372,
+480626,
+146904,
+182536,
+147856,
+161198,
+167355,
+134981,
+173176,
+166566,
+187422,
+186999,
+48967,
+83027,
+363914,
+383306,
+164078,
+157155,
+422130,
+187511,
+105772,
+155194,
+169184,
+166307,
+310891,
+153934,
+187438,
+314536,
+98538,
+188987,
+158229,
+178825,
+337117,
+183271,
+181008,
+464180,
+188571,
+161023,
+302722,
+154113,
+160955,
+181996,
+129445,
+479809,
+186619,
+186979,
+166308,
+333697,
+365452,
+179342,
+481124,
+182091,
+89368,
+168007,
+241917,
+168217,
+144967,
+224703,
+322752,
+180733,
+182642,
+239253,
+166762,
+165900,
+160924,
+183647,
+180748,
+192308,
+183443,
+180731,
+273793,
+155135,
+317508,
+295252,
+159245,
+222133,
+511382,
+168979,
+182524,
+174724,
+163344,
+187832,
+306125,
+13740,
+186924,
+160130,
+168052,
+161228,
+154549,
+169485,
+11729,
+186488,
+187277,
+172713,
+167090,
+361881,
+465503,
+375535,
+170838,
+161989,
+159402,
+163284,
+189009,
+465708,
+183295,
+499094,
+179238,
+176797,
+129313,
+164269,
+183060,
+287734,
+164274,
+11624,
+181562,
+172750,
+308772,
+313600,
+190142,
+154118,
+497137,
+168099,
+189178,
+166917,
+171171,
+172320,
+312339,
+163326,
+169447,
+165435,
+159623,
+172190,
+168989,
+143448,
+164496,
+183438,
+61361,
+14356,
+172896,
+165818,
+169424,
+178809,
+168359,
+183296,
+166036,
+116255,
+188589,
+178840,
+183687,
+165768,
+90471,
+187770,
+161267,
+329153,
+160078,
+189048,
+72428,
+197054,
+229812,
+166182,
+179887,
+171481,
+164798,
+167174,
+168293,
+112221,
+148136,
+187550,
+152549,
+69992,
+173348,
+172686,
+163656,
+156747,
+389734,
+183620,
+179298,
+192415,
+130332,
+187025,
+302694,
+358350,
+117323,
+86577,
+179270,
+173069,
+165673,
+261531,
+217515,
+125698,
+373682,
+154371,
+167062,
+464415,
+168297,
+213397,
+40233,
+389059,
+159503,
+168488,
+318305,
+49684,
+164527,
+162410,
+480920,
+182076,
+347776,
+480191,
+168055,
+176655,
+168316,
+188923,
+10472,
+166577,
+166089,
+110557,
+240650,
+173916,
+34884,
+170075,
+163552,
+3981,
+191116,
+67797,
+170050,
+187495,
+159213,
+180927,
+300336,
+464041,
+86644,
+167172,
+78745,
+165895,
+369153,
+169472,
+158358,
+179249,
+171719,
+168356,
+172615,
+173516,
+161873,
+186273,
+57627,
+98172,
+102578,
+202943,
+120742,
+188790,
+180706,
+185967,
+367057,
+506299,
+111176,
+172911,
+169406,
+169041,
+38673,
+153191,
+181019,
+186283,
+218770,
+148727,
+187934,
+462188,
+171716,
+181950,
+99602,
+183745,
+188393,
+471429,
+171318,
+164377,
+182583,
+295962,
+186141,
+160544,
+186177,
+480562,
+334774,
+468866,
+1587,
+161905,
+174670,
+161879,
+146464,
+88871,
+167160,
+187808,
+66117,
+115159,
+161079,
+171936,
+183600,
+177292,
+313641,
+183635,
+212112,
+166159,
+177764,
+227939,
+80700,
+173747,
+163149,
+23029,
+195728,
+130436,
+392560,
+393216,
+274800,
+187932,
+10670,
+45427,
+187976,
+68116,
+183646,
+32901,
+172837,
+156637,
+180456,
+145545,
+175529,
+10371,
+188967,
+161026,
+180354,
+235918,
+188069,
+11115,
+243542,
+181031,
+181449,
+383210,
+496013,
+71305,
+170408,
+185959,
+152388,
+159978,
+257011,
+21602,
+181430,
+464413,
+68141,
+175250,
+506061,
+173255,
+154917,
+61357,
+9920,
+166725,
+167525,
+183699,
+480792,
+187588,
+35814,
+463940,
+361767,
+243219,
+181030,
+157174,
+167757,
+177817,
+87725,
+482674,
+171316,
+220384,
+157513,
+187352,
+29971,
+160340,
+108215,
+160239,
+175598,
+88231,
+187633,
+167544,
+146869,
+148201,
+165904,
+183207,
+244068,
+177348,
+125353,
+166253,
+160965,
+233723,
+216235,
+63448,
+160902,
+187151,
+173443,
+392586,
+30063,
+142796,
+232586,
+179340,
+140676,
+171700,
+40491,
+30472,
+161037,
+183539,
+154685,
+164152,
+228555,
+166310,
+178963,
+491154,
+152240,
+461387,
+496994,
+311220,
+203061,
+340366,
+230347,
+132945,
+170775,
+169279,
+11848,
+174359,
+482093,
+164576,
+37876,
+270011,
+230834,
+173302,
+173841,
+173842,
+224505,
+134111,
+181211,
+37725,
+164122,
+166286,
+230017,
+181547,
+186104,
+187394,
+160104,
+169055,
+171438,
+169199,
+158637,
+182183,
+51909,
+83530,
+179229,
+183385,
+232951,
+157494,
+173457,
+496160,
+115196,
+160169,
+369432,
+466244,
+187918,
+186758,
+267151,
+168983,
+94422,
+171447,
+161002,
+124910,
+273711,
+167511,
+149517,
+168372,
+205085,
+170607,
+162944,
+316924,
+172555,
+168962,
+103058,
+226138,
+103782,
+166563,
+464051,
+182926,
+127815,
+245936,
+70890,
+175503,
+263850,
+129696,
+464193,
+158143,
+448468,
+137049,
+221356,
+80488,
+55505,
+178004,
+477964,
+183592,
+468724,
+134627,
+170988,
+166207,
+187738,
+319092,
+483821,
+156076,
+189276,
+105002,
+120840,
+188848,
+162361,
+66636,
+165488,
+162211,
+174668,
+173330,
+132697,
+180646,
+496552,
+496551,
+169697,
+309584,
+172080,
+187526,
+119421,
+9352,
+234592,
+466177,
+180384,
+158666,
+171966,
+174594,
+186014,
+160946,
+212837,
+244029,
+331138,
+251165,
+159166,
+185862,
+185897,
+179230,
+179226,
+159193,
+210668,
+28618,
+88736,
+174733,
+168245,
+167919,
+181139,
+186877,
+266529,
+163304,
+33843,
+221306,
+30357,
+168238,
+397099,
+389103,
+168641,
+169415,
+174555,
+172718,
+119193,
+185853,
+161764,
+172549,
+156749,
+28352,
+166244,
+28368,
+169396,
+246548,
+160976,
+118764,
+232130,
+121081,
+167574,
+28225,
+307722,
+293192,
+90757,
+166572,
+172047,
+151649,
+109593,
+65014,
+66514,
+175561,
+187974,
+187393,
+167131,
+180467,
+173482,
+173440,
+172498,
+186225,
+301677,
+187531,
+186527,
+30377,
+182479,
+337600,
+469985,
+304097,
+369290,
+66438,
+181987,
+49921,
+161887,
+186740,
+43006,
+159836,
+187143,
+180443,
+463872,
+183884,
+187437,
+29644,
+192983,
+51790,
+183558,
+149438,
+149479,
+29679,
+51892,
+166769,
+178935,
+270370,
+160752,
+170052,
+48601,
+171951,
+187574,
+206553,
+188627,
+164393,
+188138,
+152737,
+464375,
+186150,
+159609,
+29461,
+336472,
+188939,
+79655,
+59845,
+157291,
+157168,
+168612,
+90490,
+464294,
+160484,
+173180,
+173524,
+170765,
+65194,
+464481,
+173340,
+187628,
+172914,
+164140,
+194316,
+170152,
+119943,
+182033,
+486490,
+497148,
+166275,
+154119,
+177794,
+18044,
+189736,
+181213,
+186218,
+56125,
+156754,
+169128,
+224092,
+177291,
+154490,
+497114,
+394225,
+161444,
+250622,
+291768,
+171319,
+194054,
+164584,
+183836,
+189471,
+188087,
+154576,
+262095,
+470095,
+183021,
+176828,
+100631,
+465526,
+162925,
+216747,
+499935,
+169216,
+156020,
+188991,
+93,
+253844,
+186959,
+171395,
+16946,
+496431,
+175351,
+132511,
+502851,
+162905,
+189045,
+177309,
+154078,
+124217,
+15492,
+154458,
+51289,
+162454,
+170130,
+183587,
+160968,
+168023,
+246271,
+168601,
+467091,
+271383,
+481092,
+158901,
+187709,
+163635,
+83084,
+152556,
+66535,
+169391,
+175401,
+303652,
+180638,
+89034,
+259447,
+181184,
+160446,
+178882,
+162496,
+166401,
+309208,
+124514,
+259342,
+151418,
+95755,
+480670,
+1002,
+162377,
+117551,
+255346,
+148537,
+186451,
+495846,
+102422,
+12366,
+186744,
+351055,
+169574,
+10458,
+247709,
+465084,
+142095,
+211878,
+167572,
+162380,
+242160,
+201799,
+172869,
+223042,
+35041,
+338524,
+173039,
+79679,
+155020,
+167682,
+188931,
+161705,
+287351,
+165779,
+70494,
+168910,
+464479,
+189225,
+243565,
+242509,
+33969,
+173754,
+170621,
+173311,
+185930,
+43970,
+167645,
+168261,
+163755,
+205266,
+162440,
+158283,
+188643,
+343307,
+194085,
+18222,
+18181,
+187631,
+40949,
+100727,
+188299,
+180096,
+170650,
+494688,
+173403,
+188403,
+171186,
+144752,
+186934,
+152923,
+165825,
+235210,
+164198,
+162408,
+169082,
+18572,
+130167,
+18556,
+169515,
+177315,
+155830,
+108923,
+171509,
+167600,
+255854,
+171631,
+434036,
+314526,
+338163,
+469642,
+148539,
+144250,
+183609,
+274350,
+161008,
+180089,
+279630,
+167684,
+368061,
+171278,
+171964,
+189044,
+480325,
+154556,
+168407,
+161682,
+109959,
+187560,
+172590,
+44521,
+166569,
+165110,
+166557,
+180640,
+13892,
+13893,
+113912,
+204850,
+110926,
+241042,
+304233,
+38754,
+120846,
+256332,
+29193,
+188063,
+184042,
+147881,
+177975,
+190431,
+188117,
+173380,
+255888,
+139363,
+167317,
+127119,
+142677,
+171026,
+235868,
+181098,
+213394,
+111205,
+204080,
+129832,
+263436,
+189036,
+182478,
+181273,
+182661,
+57157,
+159611,
+179246,
+162545,
+496906,
+92871,
+37355,
+183189,
+55350,
+14093,
+166761,
+60820,
+189220,
+159739,
+166828,
+168651,
+479550,
+183493,
+175629,
+243702,
+58336,
+168896,
+167381,
+109908,
+388949,
+172452,
+172052,
+181585,
+172101,
+167175,
+187584,
+154967,
+376806,
+169815,
+127666,
+165418,
+54633,
+167316,
+235419,
+187324,
+180007,
+181277,
+175290,
+171017,
+172853,
+171565,
+205716,
+182557,
+289489,
+352000,
+88039,
+516832,
+173455,
+51809,
+162432,
+292117,
+167504,
+287528,
+173208,
+108061,
+228223,
+211413,
+168823,
+54776,
+104181,
+165474,
+155741,
+171965,
+176620,
+215972,
+163975,
+181385,
+178604,
+138498,
+85791,
+174486,
+169766,
+146167,
+163858,
+265126,
+261243,
+57630,
+180645,
+178954,
+231603,
+54358,
+281920,
+187821,
+145679,
+144745,
+55628,
+172085,
+187132,
+183224,
+186737,
+170318,
+167141,
+155487,
+170053,
+181195,
+213340,
+72161,
+169685,
+385783,
+86690,
+187897,
+171321,
+151782,
+164578,
+56546,
+152969,
+155291,
+180204,
+92688,
+655,
+317466,
+173710,
+49361,
+189860,
+179911,
+183846,
+181383,
+161993,
+78637,
+161146,
+167419,
+169252,
+53080,
+25516,
+173589,
+171341,
+120577,
+161077,
+134693,
+159863,
+172484,
+66132,
+74143,
+162365,
+86622,
+139709,
+179977,
+210207,
+480192,
+72555,
+311418,
+182512,
+165716,
+314123,
+76693,
+13842,
+39821,
+181280,
+187898,
+368712,
+186607,
+34506,
+158239,
+56119,
+123614,
+479703,
+207068,
+86734,
+258607,
+104119,
+186805,
+171485,
+496799,
+169496,
+73913,
+168597,
+11790,
+177307,
+188174,
+74607,
+497084,
+168314,
+167318,
+216504,
+12891,
+186335,
+183240,
+112985,
+216744,
+175055,
+141375,
+173135,
+187849,
+162371,
+187757,
+49051,
+229321,
+113692,
+490667,
+170719,
+183482,
+161169,
+167752,
+203546,
+102322,
+154850,
+29187,
+183045,
+182487,
+132981,
+465777,
+168595,
+133497,
+462983,
+185873,
+179960,
+65303,
+55348,
+161538,
+177852,
+185988,
+146103,
+171655,
+186845,
+174216,
+185846,
+186422,
+183437,
+166363,
+170734,
+85152,
+175708,
+166361,
+181559,
+166212,
+188136,
+254816,
+187864,
+223795,
+183612,
+86920,
+50224,
+187520,
+196991,
+59393,
+228110,
+197886,
+183107,
+46677,
+146698,
+468475,
+224036,
+490257,
+173425,
+93658,
+169719,
+86966,
+179391,
+28282,
+180241,
+480807,
+47616,
+178838,
+96598,
+210224,
+167105,
+209831,
+240816,
+38622,
+225740,
+189997,
+165644,
+181207,
+494254,
+486376,
+167605,
+34822,
+46044,
+160389,
+185996,
+172031,
+54147,
+183097,
+88008,
+163653,
+72923,
+155181,
+169440,
+183915,
+182526,
+19697,
+162453,
+292375,
+186429,
+182538,
+54789,
+172682,
+159959,
+187585,
+277119,
+186790,
+187830,
+175974,
+17860,
+61642,
+118528,
+102686,
+497171,
+224770,
+59117,
+506627,
+181166,
+168664,
+171092,
+173136,
+35343,
+87507,
+188805,
+154841,
+498968,
+355295,
+164581,
+341644,
+222401,
+316553,
+378327,
+311260,
+180391,
+183683,
+156381,
+93779,
+290867,
+55865,
+465189,
+188330,
+172346,
+170824,
+183471,
+177388,
+169188,
+70129,
+487995,
+188461,
+230931,
+170923,
+173706,
+209261,
+325056,
+188043,
+154093,
+223536,
+387574,
+166866,
+152267,
+153290,
+316719,
+271314,
+499441,
+165786,
+156595,
+147807,
+188557,
+173394,
+170103,
+128299,
+110806,
+166776,
+113595,
+316040,
+77011,
+166508,
+186204,
+380157,
+179884,
+167610,
+51392,
+172661,
+187005,
+187224,
+9879,
+486161,
+159962,
+160325,
+206918,
+512473,
+180492,
+167882,
+227428,
+239332,
+182400,
+163257,
+187141,
+156580,
+271525,
+218346,
+346073,
+328183,
+53346,
+168700,
+164928,
+166217,
+169302,
+134953,
+72266,
+163269,
+187926,
+168178,
+20829,
+163106,
+169607,
+162936,
+15488,
+72693,
+64859,
+185991,
+181545,
+185941,
+148574,
+190456,
+183567,
+186448,
+169235,
+258657,
+464372,
+182523,
+153758,
+122785,
+54871,
+337138,
+174985,
+322523,
+187380,
+82006,
+483947,
+319945,
+15741,
+174126,
+242296,
+290027,
+186909,
+180833,
+55209,
+42543,
+56037,
+36447,
+64764,
+182601,
+188744,
+186886,
+181410,
+171298,
+33962,
+179368,
+97442,
+186399,
+61320,
+69053,
+140985,
+24075,
+168777,
+461219,
+170972,
+186022,
+164172,
+167128,
+238730,
+287603,
+186902,
+178543,
+186269,
+237120,
+464485,
+171956,
+172060,
+199502,
+461540,
+159862,
+175387,
+183911,
+2801,
+271756,
+167594,
+14974,
+152048,
+248484,
+221103,
+167772,
+180304,
+168576,
+85319,
+183682,
+163866,
+179291,
+186785,
+274285,
+483650,
+5190,
+249133,
+252500,
+480281,
+186307,
+169793,
+186146,
+336664,
+191941,
+14127,
+163080,
+182474,
+389753,
+45116,
+81241,
+182493,
+347557,
+87174,
+172298,
+94472,
+159463,
+157350,
+93604,
+28985,
+56787,
+242075,
+174056,
+167628,
+194995,
+172223,
+162520,
+39912,
+392765,
+493129,
+160885,
+265969,
+38174,
+183158,
+342131,
+240579,
+163930,
+92689,
+188139,
+190140,
+163904,
+169775,
+301707,
+186688,
+100575,
+188988,
+136250,
+396446,
+59631,
+56276,
+84727,
+165909,
+480504,
+261338,
+43195,
+157195,
+67664,
+265721,
+47950,
+177103,
+383612,
+476530,
+162277,
+369834,
+498072,
+175608,
+90637,
+481046,
+80874,
+123966,
+187410,
+464477,
+167516,
+166184,
+488892,
+65140,
+214092,
+489200,
+218331,
+258278,
+258281,
+343093,
+399611,
+179363,
+181146,
+152133,
+141220,
+339077,
+170659,
+172667,
+179953,
+179946,
+181426,
+238119,
+172681,
+54178,
+56352,
+166355,
+161168,
+463433,
+180609,
+352561,
+175654,
+152405,
+287833,
+50932,
+160809,
+170057,
+49706,
+91177,
+167152,
+159676,
+268902,
+31493,
+173062,
+52821,
+384526,
+92829,
+160197,
+163271,
+167875,
+179038,
+105000,
+188901,
+165408,
+166053,
+15895,
+284852,
+161305,
+172512,
+488528,
+167402,
+163411,
+54165,
+133657,
+474806,
+162316,
+163746,
+159007,
+52841,
+80243,
+167584,
+49110,
+495141,
+165195,
+238295,
+166013,
+165704,
+54421,
+179673,
+63908,
+32206,
+168890,
+186483,
+188935,
+188215,
+183316,
+102547,
+186323,
+388485,
+95463,
+159039,
+151750,
+464156,
+472961,
+32622,
+496683,
+349191,
+226135,
+93461,
+144129,
+180010,
+118490,
+57661,
+180802,
+228161,
+463738,
+171226,
+169036,
+70489,
+293570,
+170223,
+362490,
+179886,
+155397,
+481049,
+163735,
+80924,
+67134,
+86666,
+62195,
+183485,
+85985,
+58315,
+158843,
+156504,
+77414,
+94930,
+79143,
+94248,
+169466,
+364217,
+173320,
+167043,
+167729,
+160830,
+62730,
+161681,
+110640,
+73682,
+155593,
+177327,
+174421,
+114427,
+498682,
+287843,
+45114,
+168120,
+54171,
+462878,
+145981,
+483592,
+172673,
+160108,
+173297,
+171020,
+155879,
+168954,
+186281,
+143942,
+511722,
+497147,
+178821,
+195769,
+396508,
+183017,
+275701,
+492910,
+34134,
+170148,
+183318,
+180917,
+51471,
+160172,
+158083,
+144011,
+159898,
+156713,
+144591,
+157377,
+362491,
+80542,
+167336,
+97544,
+185856,
+497154,
+346354,
+185792,
+180404,
+279413,
+496583,
+461913,
+163545,
+245600,
+167384,
+192707,
+153813,
+228738,
+31184,
+172109,
+497748,
+347948,
+143752,
+481339,
+185784,
+157317,
+165929,
+9327,
+195178,
+50813,
+148332,
+272245,
+69405,
+66443,
+180922,
+175161,
+160341,
+113659,
+160871,
+480328,
+131384,
+463999,
+124871,
+273240,
+187939,
+199659,
+188860,
+353597,
+512084,
+466811,
+313765,
+251816,
+167292,
+33310,
+99593,
+332848,
+470490,
+47028,
+32234,
+163737,
+64687,
+54154,
+83494,
+180243,
+368338,
+45203,
+61718,
+74268,
+83538,
+88489,
+233169,
+170648,
+160150,
+171684,
+122950,
+53020,
+198897,
+171705,
+77806,
+168065,
+85115,
+31997,
+171640,
+47621,
+143212,
+175279,
+51715,
+52445,
+63702,
+46486,
+153364,
+187008,
+167001,
+475038,
+69822,
+163738,
+482357,
+73773,
+344476,
+299154,
+106289,
+43503,
+464501,
+64889,
+449087,
+175904,
+31873,
+159081,
+495500,
+481090,
+31353,
+64770,
+106001,
+32440,
+243604,
+138895,
+179984,
+196748,
+265605,
+521377,
+167558,
+181142,
+185480,
+323357,
+185166,
+284794,
+185518,
+282110,
+325389,
+185621,
+168509,
+150719,
+227758,
+150216,
+185635,
+309976,
+150535,
+150852,
+1992,
+99038,
+153622,
+47535,
+506751,
+51662,
+94778,
+166365,
+160163,
+65927,
+185662,
+150849,
+62202,
+185313,
+253393,
+150028,
+150981,
+499505,
+185686,
+156519,
+7031,
+185096,
+7346,
+185177,
+149818,
+168730,
+150337,
+150534,
+185331,
+462180,
+185731,
+5557,
+185664,
+185735,
+149908,
+150877,
+150369,
+165047,
+7478,
+150179,
+150345,
+150974,
+310783,
+185359,
+185464,
+185405,
+217474,
+185338,
+150891,
+173413,
+150214,
+185159,
+185460,
+480522,
+185679,
+185488,
+150504,
+7664,
+150298,
+185660,
+185349,
+185671,
+185539,
+151225,
+185678,
+32592,
+185186,
+185299,
+185251,
+185727,
+150147,
+184717,
+185634,
+152111,
+185243,
+185623,
+309794,
+185272,
+185520,
+185245,
+149977,
+150383,
+481127,
+184826,
+185241,
+150541,
+150207,
+50703,
+149746,
+185683,
+282079,
+328078,
+184605,
+185261,
+150756,
+185326,
+185362,
+149660,
+149728,
+216387,
+149712,
+53764,
+211700,
+185410,
+185710,
+154590,
+150856,
+481068,
+149751,
+185484,
+150241,
+212844,
+185591,
+185687,
+464472,
+185335,
+150140,
+150173,
+464467,
+185308,
+481060,
+185650,
+150545,
+289871,
+302307,
+302311,
+280384,
+150684,
+252022,
+150308,
+185347,
+171399,
+310374,
+149976,
+306384,
+185311,
+33016,
+464459,
+185632,
+185435,
+185713,
+327545,
+185400,
+257489,
+150156,
+185459,
+149862,
+150223,
+150274,
+496665,
+184788,
+185770,
+185248,
+149658,
+185189,
+185702,
+185734,
+71611,
+150266,
+184726,
+157676,
+71626,
+149725,
+189062,
+150430,
+151139,
+150093,
+185757,
+70117,
+477820,
+185483,
+185516,
+184776,
+185578,
+150734,
+170264,
+496651,
+353100,
+150060,
+8616,
+400831,
+398682,
+399756,
+399770,
+399996,
+400087,
+401339,
+402394,
+403192,
+403528,
+403920,
+404463,
+404570,
+457830,
+406051,
+442015,
+406358,
+406780,
+407086,
+409007,
+410052,
+447432,
+411829,
+413305,
+413695,
+414698,
+415514,
+415943,
+417017,
+417254,
+417742,
+417718,
+417875,
+418089,
+418203,
+418885,
+419025,
+419501,
+419502,
+419580,
+397661,
+437817,
+421190,
+421831,
+445632,
+423433,
+424267,
+425177,
+426717,
+429715,
+426958,
+427275,
+430083,
+457245,
+431328,
+431518,
+432312,
+432323,
+432725,
+433121,
+433162,
+433171,
+433781,
+433967,
+434629,
+434795,
+434796,
+435908,
+436549,
+436554,
+510013,
+436598,
+436961,
+437533,
+443140,
+437847,
+397329,
+510059,
+443936,
+447734,
+440911,
+441461,
+446526,
+66614,
+77166,
+86667,
+36045,
+235964,
+106212,
+82391,
+79628,
+84595,
+495755,
+58387,
+77142,
+98712,
+50012,
+126149,
+31255,
+85385,
+99035,
+122655,
+64892,
+413641,
+235322,
+114709,
+279389,
+465391,
+135184,
+58840,
+253082,
+83181,
+67615,
+54209,
+449833,
+94228,
+482217,
+32475,
+61922,
+64684,
+97085,
+44975,
+298510,
+423479,
+423998,
+232221,
+98782,
+56621,
+79222,
+78435,
+83164,
+81030,
+45490,
+88097,
+77141,
+85615,
+47214,
+118628,
+91372,
+101826,
+77140,
+9308,
+295562,
+479502,
+80142,
+495798,
+247594,
+82612,
+47478,
+56020,
+134385,
+442123,
+171668,
+104287,
+454749,
+79746,
+87084);
+COMMIT;
diff --git a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
index ded6b8b073..9c1a556c6a 100644
--- a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
+++ b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
@@ -61,7 +61,7 @@ BEGIN
 			RETURNS TRIGGER AS $func$
 			BEGIN
 				INSERT INTO auditor.$$ || sch || $$_$$ || tbl || $$_history
-					SELECT	nextval('auditor.$$ || sch || $$_$$ || tbl || $$_pkey_seq'),
+					SELECT	nextval('auditor.$$ || sch || $$_$$ || tbl || $$_pkey_seq' ),
 						now(),
 						SUBSTR(TG_OP,1,1),
 						OLD.*;
@@ -120,6 +120,74 @@ SELECT auditor.create_auditor ( 'asset', 'copy' );
 
 COMMIT;
 
+-- remove all data from config.metabib_field and replace with seed values for 1.6 
+-- and customized pines data with id numbers above 100
+BEGIN;
+DELETE FROM config.metabib_field;
+
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 1, 'series', 'seriestitle', 'mods32', $$//mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 2, 'title', 'abbreviated', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='abbreviated' )]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 3, 'title', 'translated', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='translated' )]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 4, 'title', 'alternative', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='alternative' )]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 5, 'title', 'uniform', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='uniform' )]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 6, 'title', 'proper', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and not (@type)]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 7, 'author', 'corporate', 'mods32', $$//mods32:mods/mods32:name[@type='corporate']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 8, 'author', 'personal', 'mods32', $$//mods32:mods/mods32:name[@type='personal']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 9, 'author', 'conference', 'mods32', $$//mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 10, 'author', 'other', 'mods32', $$//mods32:mods/mods32:name[@type='personal']/mods32:namePart[not(../mods32:role)]$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 11, 'subject', 'geographic', 'mods32', $$//mods32:mods/mods32:subject/mods32:geographic$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 12, 'subject', 'name', 'mods32', $$//mods32:mods/mods32:subject/mods32:name$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 13, 'subject', 'temporal', 'mods32', $$//mods32:mods/mods32:subject/mods32:temporal$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 14, 'subject', 'topic', 'mods32', $$//mods32:mods/mods32:subject/mods32:topic$$ );
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 15, 'keyword', 'keyword', 'mods32', $$//mods32:mods/*[not(local-name()='originInfo' )]$$ ); -- /* to fool vim */;
+INSERT INTO config.metabib_field ( id, field_class, name, format, xpath ) VALUES
+    ( 16, 'subject', 'complete', 'mods32', $$//mods32:mods/mods32:subject//text()$$ );
+
+-- custom PINES fields:
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES 
+ ( 120, 'title', '222', $$//marcxml:datafield[@tag="222"]/marcxml:subfield[contains("ab",@code)]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES 
+ ( 121, 'title', '243', $$//marcxml:datafield[@tag="243"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 122, 'title', '240', $$//marcxml:datafield[@tag="240"]/marcxml:subfield[contains("gn",@code)]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES 
+ ( 123, 'title', '246', $$//marcxml:datafield[@tag="246"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 124, 'title', '247', $$//marcxml:datafield[@tag="247"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 126, 'title', '730', $$//marcxml:datafield[@tag="730"]/marcxml:subfield[contains("gn",@code)]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 127, 'title', '740', $$//marcxml:datafield[@tag="740"]/marcxml:subfield[contains("anp",@code)]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES 
+ ( 131, 'title', '505t', $$//marcxml:datafield[@tag="505"]/marcxml:subfield[@code="t"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES 
+ ( 133, 'subject', '655', $$//marcxml:datafield[@tag="655"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 134, 'subject', '690', $$//marcxml:datafield[@tag="690"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 135, 'subject', '654', $$//marcxml:datafield[@tag="654"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 136, 'subject', '657', $$//marcxml:datafield[@tag="657"]$$, 1, 'marcxml', 't', 'f' );
+INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format, search_field, facet_field ) VALUES
+ ( 137, 'subject', '658', $$//marcxml:datafield[@tag="658"]$$, 1, 'marcxml', 't', 'f' );
+
+COMMIT;
+
 
 -- These are restored by the post-upgrade PINES sql script.
 
-- 
2.11.0