From ca4032feaeccb0e6168335d78be69a54c5d2ee55 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 13 Aug 2015 12:52:34 -0400 Subject: [PATCH] JBAS-837 clean up sql dir with legacy dir Move old SQL files into a new legacy directory (for now). Legacy directory may later be deleted. Signed-off-by: Bill Erickson --- .../HoldingsMaintenance/holdings_maintenance.SQL | 0 .../holdings_maintenance_rollback.SQL | 0 .../KMAIN-1639-Add-update-permissions-rollback.sql | 0 .../KMAIN-1639/KMAIN-1639-Add-update-permissions.sql | 0 KCLS/sql/legacy/README | 2 ++ ..._setting_for_selecting_lists_per_page_for_my_list.sql | 0 .../001.0815.schema.config-metabib-interauthority.sql | 0 .../browse/002.0816.schema.bib-auth-browse.sql | 0 .../browse/003.0821.function.browse-normalize-timing.sql | 0 .../004.0837.schema.browse-auth-linking.plus-joiner.sql | 0 .../browse/005.0839.data.alternative-title-indexing.sql | 0 .../browse/006.0844.data.better_mods_for_browse_etc.sql | 0 .../browse/007.0845.schema.browse_pivots_stable.sql | 0 .../browse/008.0846.function.vand-add_field.sql | 0 ...09.kmain538.create_and_index_truncated_sort_value.sql | 0 .../browse/010.kmain538.replace_browse_function.sql | 0 ...38.replace_metabib_reingest_metabib_field_entries.sql | 0 KCLS/sql/{ => legacy}/browse/012.kmain553.Author.SQL | 0 KCLS/sql/{ => legacy}/browse/013.kmain553.Series.SQL | 0 KCLS/sql/{ => legacy}/browse/014.kmain553.Subject.SQL | 0 KCLS/sql/{ => legacy}/browse/015.kmain553.Title.SQL | 0 .../browse/016.kmain553.metabib_browse_function.SQL | 0 .../017.kmain553.metabib.staged_browse_function.SQL | 0 ...8.kmain553.metabib.reingest_metabib_field_entries.SQL | 0 .../browse/020.kmain212.metabib.staged_browse.SQL | 0 .../021.kmain212.biblio.extract_metabib_field_entry.SQL | 0 ...2.kmain212.metabib.reingest_metabib_field_entries.SQL | 0 .../sql/{ => legacy}/browse/023.kmain212.Call_Number.SQL | 0 .../browse/024.kmain212.metabib_browse_function.SQL | 0 .../025.kmain936.remove_browse_entry_references.SQL | 0 KCLS/sql/{ => legacy}/browse/KMAIN-877.sql | 0 .../browse/combined/000.remove_old_auth_data.sql | 0 .../combined/0001.public.export-ids-086-092-099.sql | 0 .../browse/combined/0002.public.export-ids-001.sql | 0 .../browse/combined/0003.public.export-ids-998.sql | 0 .../browse/combined/0004.public.export-ids-has-copy.sql | 0 .../browse/combined/0005.public.export-ids-ldr.sql | 0 .../browse/combined/0006.public.export-ids-cat-date.sql | 0 .../browse/combined/0007.public.export-generate-ids.sql | 0 KCLS/sql/{ => legacy}/browse/combined/001.tables.sql | 0 .../002.large_update_to_config_xml_transform.sql | 0 ...main-806-separate_browse_entry_simple_heading_map.sql | 0 .../combined/0026.kmain-762-public_replace_ampersand.sql | 0 .../browse/combined/003.split_up_browse_into_tables.sql | 0 .../browse/combined/004.naco_normalize_keep_decimal.sql | 0 .../browse/combined/005.call_number_browse.sql | 0 .../{ => legacy}/browse/combined/006.data-type-etc.sql | 0 KCLS/sql/{ => legacy}/browse/combined/007.functions.sql | 0 .../browse/combined/008.kmain-223-auth-match.sql | 0 ...populate_separate_browse_entry_simple_heading_map.sql | 0 ...kmain-935-modify_biblio_indexing_ingest_or_delete.sql | 0 ...kmain-1011-metabib.triggered_reingest_for_bib_set.sql | 0 .../012.kmain-1039-authority-unlinked-bibs-to-auth.sql | 0 .../combined/013.kmain-1053-auth_n_bib_generator.sql | 0 ...in-1105-authority.unlinked_auths_to_given_auth_id.sql | 0 .../015.create_vandelay_queue_and_merge_profile.sql | 0 ...ing_generate_auth_ids_for_auth_to_auth_given_date.sql | 0 .../017.kmain-1119-remove_duplicate_browse_entries.sql | 0 .../browse/combined/018.kmain-1128-ui_improvements.sql | 0 ....kmain-1175-metabib-triggered_reingest_for_bib_id.sql | 0 ...in-1160-update_config_xml_transform_for_name_kcls.sql | 0 ...n-1213-update_authority_generate_overlay_template.sql | 0 .../combined/022.kmain-1199-fix-auth-to-auth-link.sql | 0 ...authority-control-set-bib-field-metabib-field-map.sql | 0 .../browse/combined/browse_speed_improvements_CMD/README | 0 .../combined/browse_speed_improvements_CMD/deploy.sql | 0 .../browse_speed_improvements_CMD/metabib.browse.sql | 0 .../metabib.browse_author_authority_refs_pivot.sql | 0 .../metabib.browse_author_bib_pivot.sql | 0 .../metabib.browse_author_pivot.sql | 0 .../metabib.browse_call_number_authority_refs_pivot.sql | 0 .../metabib.browse_call_number_bib_pivot.sql | 0 .../metabib.browse_call_number_pivot.sql | 0 .../metabib.browse_series_authority_refs_pivot.sql | 0 .../metabib.browse_series_bib_pivot.sql | 0 .../metabib.browse_series_pivot.sql | 0 .../metabib.browse_subject_authority_refs_pivot.sql | 0 .../metabib.browse_subject_bib_pivot.sql | 0 .../metabib.browse_subject_pivot.sql | 0 .../metabib.browse_table_bounds.sql | 0 .../metabib.browse_title_authority_refs_pivot.sql | 0 .../metabib.browse_title_bib_pivot.sql | 0 .../metabib.browse_title_pivot.sql | 0 .../combined/browse_speed_improvements_CMD/tables.sql | 0 .../combined/browse_speed_improvements_CMD/test.sql | 0 .../{ => legacy}/browse/combined/kmain212.testsForSQL | 0 .../browse/combined/reingest/data_update_driver.html | 0 .../browse/combined/reingest/data_update_driver.pl | 0 .../browse/combined/reingest/reingest_metabib_data.sql | 0 KCLS/sql/{ => legacy}/browse/combined/runReingestSh.sh | 0 KCLS/sql/{ => legacy}/browse/combined/runSh.sh | 0 .../browse/kmain-706/kmain-706.4-to-1-rollback.sql | 0 .../{ => legacy}/browse/kmain-706/kmain-706.4-to-1.sql | 0 KCLS/sql/{ => legacy}/browse/kmain212.README | 0 KCLS/sql/{ => legacy}/browse/kmain212.testsForSQL | 0 KCLS/sql/{ => legacy}/browse/kmain553.README | 0 KCLS/sql/{ => legacy}/browse/kmain691.sql | 0 .../kmain925/kmain925-remove_duplicate_auth_records | 0 ....kmain936.remove_browse_entry_references.rollback.SQL | 0 .../browse/rollback/kmain212.Call_Number.SQL.Rollback | 0 ...in212.biblio.extract_metabib_field_entry.SQL.Rollback | 0 ...2.metabib.reingest_metabib_field_entries.SQL.Rollback | 0 .../rollback/kmain212.metabib.staged_browse.SQL.Rollback | 0 .../kmain212.metabib_browse_function.SQL.ROLLBACK | 0 ...38.create_and_index_truncated_sort_value.rollback.sql | 0 .../kmain538.replace_browse_function.rollback.sql | 0 ...e_metabib_reingest_metabib_field_entries-rollback.sql | 0 .../browse/rollback/kmain553.All.SQL.Rollback | 0 ...3.metabib.reingest_metabib_field_entries.SQL.Rollback | 0 .../kmain553.metabib.staged_browse_function.SQL.ROLLBACK | 0 .../kmain553.metabib_browse_function.SQL.ROLLBACK | 0 .../001.public.export-generate-ids-rollback.sql | 0 .../002.public.export-ids-001-rollback.sql | 0 .../003.public.export-ids-998-rollback.sql | 0 .../004.public.export-ids-has-copy-rollback.sql | 0 .../005.public.export-ids-ldr-rollback.sql | 0 .../006.public.export-ids-cat-date-rollback.sql | 0 .../007.public.export-ids-086-092-099-rollback.sql | 0 .../export_process/rollback_scripts/runSh.sh | 0 KCLS/sql/{ => legacy}/export_process/runSh.sh | 0 .../0869.schema.pre-calculate-prox-adjustment.sql | 0 .../jbas-149/XXXX.schema.clear_hold_copy_map.sql | 0 .../jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql | 0 .../jbas-149-and-jbas-228-combined-upgrade.undo.sql | 0 .../jbas-228/XXXX.schema.fund_debit_invoice_links.sql | 0 .../jbas-408/jbas-408-copy-map-delete-fulfill.sql | 0 .../jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql | 0 .../sql/{ => legacy}/jbas-495/01.2.4.1-2.5.7-upgrade.sql | 0 .../{ => legacy}/jbas-495/02.collection-hq-items-2.5.sql | 0 KCLS/sql/{ => legacy}/jbas-495/03.mods-for-2.5.sql | 0 ...KMAIN-1765-reingest-causing-false-browse-headings.sql | 0 .../kmain-1060/authority-indexing-ingest-or-delete.sql | 0 .../kmain-1060/authority-simple-heading-set.sql | 0 .../metabib-reingest-metabib-field-entries.sql | 0 .../authority-indexing-ingest-or-delete-rollback.sql | 0 .../authority-simple-heading-set-rollback.sql | 0 .../metabib-reingest-metabib-field-entries-rollback.sql | 0 .../kmain-1074/kmain-1074-indexing_ingest_or_delete.sql | 0 KCLS/sql/{ => legacy}/kmain-1074/kmain-1074-rollback.sql | 0 .../kmain-1102-authority-reingest-rollback.sql | 0 .../kmain-1102/kmain-1102-authority-reingest.sql | 0 .../kmain-1102/kmain-1102-metabib-reingest-rollback.sql | 0 .../kmain-1102/kmain-1102-metabib-reingest.sql | 0 .../kmain-1128/authority-get_5xx_heading.sql | 0 ...reate_and_populate-authority-display_5xx_headings.sql | 0 .../metabib-get_browse_author_entry_marc_record.sql | 0 .../kmain-1128/metabib-get_browse_entry_marc_record.sql | 0 .../metabib-get_browse_series_entry_marc_record.sql | 0 .../metabib-get_browse_subject_entry_marc_record.sql | 0 .../authority-get_5xx_heading-rollback.sql | 0 ...abib-get_browse_author_entry_marc_record-rollback.sql | 0 .../metabib-get_browse_entry_marc_record-rollback.sql | 0 ...abib-get_browse_series_entry_marc_record-rollback.sql | 0 ...bib-get_browse_subject_entry_marc_record-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1199/kmain-1199-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1199/kmain-1199.sql | 0 ...-control-set-bib-field-metabib-field-map-rollback.sql | 0 ...authority-control-set-bib-field-metabib-field-map.sql | 0 ...dd-export-and-import-biblio-record-entry-rollback.sql | 0 ...in-1264-add-export-and-import-biblio-record-entry.sql | 0 ...se-sensitive-browse-call-number-searches-rollback.sql | 0 ...n-1271-case-sensitive-browse-call-number-searches.sql | 0 .../kmain-1312/create_metabib_bib_export_data.sql | 0 .../create_metabib_bib_export_data_rollback.sql | 0 .../{ => legacy}/kmain-1312/metabib_set_export_date.sql | 0 .../kmain-1312/metabib_set_export_date_rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1314/kmain-1314-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1314/kmain-1314.sql | 0 .../kmain-1324/metabib-bib-export-data-rollback.sql | 0 .../{ => legacy}/kmain-1324/metabib-bib-export-data.sql | 0 .../kmain-1324/metabib-set-import-date-rollback.sql | 0 .../{ => legacy}/kmain-1324/metabib-set-import-date.sql | 0 .../kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql | 0 .../KMAIN_1448_Bug_from_KMAIN_268_rollback.sql | 0 .../kmain-1521/authority_heading_changed.sql | 0 .../kmain-1521/authority_heading_changed_rollback.sql | 0 .../kmain-1521/authority_indexing_ingest_or_delete.sql | 0 .../authority_indexing_ingest_or_delete_rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1528/kmain-1528-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-1528/kmain-1528.sql | 0 .../kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql | 0 .../KMAIN_1729_Bug_from_KMAIN_268_rollback.sql | 0 ...5-reingest-causing-false-browse-headings-rollback.sql | 0 ...KMAIN-1765-reingest-causing-false-browse-headings.sql | 0 KCLS/sql/{ => legacy}/kmain-223/kmain-223-auth-match.sql | 0 KCLS/sql/{ => legacy}/kmain-223/kmain-223-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-268/kmain-268-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-268/kmain-268.sql | 0 .../sql/{ => legacy}/kmain-310/kclsupgrad34.rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-310/kclsupgrad34.sql | 0 .../{ => legacy}/kmain-385-standard-default-messages.sql | 0 KCLS/sql/{ => legacy}/kmain-392/kmain392.sql | 0 KCLS/sql/{ => legacy}/kmain-695/kmain-695-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-695/kmain-695.sql | 0 .../metabib-browse-author-authority-refs-pivot.sql | 0 .../kmain-762/metabib-browse-author-bib-pivot.sql | 0 .../metabib-browse-series-authority-refs-pivot.sql | 0 .../kmain-762/metabib-browse-series-bib-pivot.sql | 0 .../metabib-browse-subject-authority-refs-pivot.sql | 0 .../kmain-762/metabib-browse-subject-bib-pivot.sql | 0 KCLS/sql/{ => legacy}/kmain-762/metabib-browse-text.sql | 0 .../metabib-browse-title-authority-refs-pivot.sql | 0 .../kmain-762/metabib-browse-title-bib-pivot.sql | 0 .../{ => legacy}/kmain-762/public-replace-ampersand.sql | 0 ...tabib-browse-author-authority-refs-pivot-rollback.sql | 0 .../metabib-browse-author-bib-pivot-rollback.sql | 0 ...tabib-browse-series-authority-refs-pivot-rollback.sql | 0 .../metabib-browse-series-bib-pivot-rollback.sql | 0 ...abib-browse-subject-authority-refs-pivot-rollback.sql | 0 .../metabib-browse-subject-bib-pivot-rollback.sql | 0 .../rollback_scripts/metabib-browse-text-rollback.sql | 0 ...etabib-browse-title-authority-refs-pivot-rollback.sql | 0 .../metabib-browse-title-bib-pivot-rollback.sql | 0 .../public-replace-ampersand-rollback.sql | 0 .../kmain-81-upgrad-98_usr_activity_types.sql | 0 .../kmain-81-upgrad-98_usr_activity_types_rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-903/kmain-903-rollback.sql | 0 KCLS/sql/{ => legacy}/kmain-903/kmain-903.sql | 0 .../kmain-972/public.export-generate-ids.sql | 0 .../public.export-generate-ids-params-rollback.sql | 0 .../kmain-976/kmain-976-constraints-rollback.sql | 0 .../sql/{ => legacy}/kmain-976/kmain-976-constraints.sql | 0 .../kmain-976-indexing_ingest_or_delete-rollback.sql | 0 .../kmain-976/kmain-976-indexing_ingest_or_delete.sql | 0 ...kmain-976-reingest_metabib_field_entries-rollback.sql | 0 .../kmain-976-reingest_metabib_field_entries.sql | 0 .../{ => legacy}/kmain-976/kmain-976-upgrade-prep.sql | 0 .../0815.schema.config-metabib-interauthority.sql | 0 .../kmain221/0816.schema.bib-auth-browse.sql | 0 .../kmain221/0821.function.browse-normalize-timing.sql | 0 .../0837.schema.browse-auth-linking.plus-joiner.sql | 0 .../kmain221/0839.data.alternative-title-indexing.sql | 0 .../kmain221/0844.data.better_mods_for_browse_etc.sql | 0 .../kmain221/0845.schema.browse_pivots_stable.sql | 0 .../kmain221/0846.function.vand-add_field.sql | 0 .../kmain228/add_cataloging_date_column_to_bre.sql | 0 .../rollback-add_cataloging_date_column_to_bre.sql | 0 KCLS/sql/{ => legacy}/kmig-147.sql | 0 KCLS/sql/{ => legacy}/kmig-187.sql | 0 .../kmig57-default_search_location_trigger.sql | 0 KCLS/sql/sample-data/deploy/no_op_initialization.sql | 8 ++++++++ .../{dev-data => sample-data/exports}/kcls-dev-aous.sql | 0 .../{dev-data => sample-data/exports}/kcls-dev-auths.sql | 0 .../{dev-data => sample-data/exports}/kcls-dev-cns.sql | 0 .../exports}/kcls-dev-copies.sql | 0 .../exports}/kcls-dev-db-export.sql | 0 .../exports}/kcls-dev-db-extras.sql | 0 .../{dev-data => sample-data/exports}/kcls-dev-recs.sql | 0 .../{dev-data => sample-data/exports}/kcls-dev-users.sql | 0 .../{dev-data => sample-data/exports}/kcls-dev-xacts.sql | 0 KCLS/sql/sample-data/revert/no_op_initialization.sql | 7 +++++++ KCLS/{sqitch => sql/sample-data}/sqitch.conf | 0 KCLS/sql/sample-data/sqitch.plan | 5 +++++ .../sql/{dev-data => sample-data/tools}/create-dev-db.sh | 0 .../{dev-data => sample-data}/tools/export-dev-data.sh | 0 .../{dev-data => sample-data}/tools/export-tables.txt | 0 .../{dev-data => sample-data}/tools/kcls-dev-rec-ids.txt | 0 KCLS/sql/sample-data/verify/no_op_initialization.sql | 7 +++++++ .../schema}/deploy/01.2.4.1-2.5.7-deps.sql | 0 .../schema}/deploy/01.2.4.1-2.5.7-upgrade.sql | 0 .../schema}/deploy/02.collection-hq-items-2.5.sql | 0 ...KMAIN-1765-reingest-causing-false-browse-headings.sql | 0 .../schema}/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql | 0 .../schema}/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql | 0 .../{sqitch => sql/schema}/deploy/kcls-2.4-base-prod.sql | 0 .../schema}/revert/01.2.4.1-2.5.7-deps.sql | 0 .../schema}/revert/01.2.4.1-2.5.7-upgrade.sql | 0 .../schema}/revert/02.collection-hq-items-2.5.sql | 0 ...KMAIN-1765-reingest-causing-false-browse-headings.sql | 0 .../schema}/revert/KMAIN_1448_Bug_from_KMAIN_268.sql | 0 .../schema}/revert/KMAIN_1729_Bug_from_KMAIN_268.sql | 0 .../{sqitch => sql/schema}/revert/kcls-2.4-base-prod.sql | 0 KCLS/sql/schema/sqitch.conf | 16 ++++++++++++++++ KCLS/{sqitch => sql/schema}/sqitch.plan | 0 .../schema}/verify/01.2.4.1-2.5.7-deps.sql | 0 .../schema}/verify/01.2.4.1-2.5.7-upgrade.sql | 0 .../schema}/verify/02.collection-hq-items-2.5.sql | 0 ...KMAIN-1765-reingest-causing-false-browse-headings.sql | 0 .../schema}/verify/KMAIN_1448_Bug_from_KMAIN_268.sql | 0 .../schema}/verify/KMAIN_1729_Bug_from_KMAIN_268.sql | 0 .../{sqitch => sql/schema}/verify/kcls-2.4-base-prod.sql | 0 281 files changed, 45 insertions(+) rename KCLS/sql/{ => legacy}/HoldingsMaintenance/holdings_maintenance.SQL (100%) rename KCLS/sql/{ => legacy}/HoldingsMaintenance/holdings_maintenance_rollback.SQL (100%) rename KCLS/sql/{ => legacy}/KMAIN-1639/KMAIN-1639-Add-update-permissions-rollback.sql (100%) rename KCLS/sql/{ => legacy}/KMAIN-1639/KMAIN-1639-Add-update-permissions.sql (100%) create mode 100644 KCLS/sql/legacy/README rename KCLS/sql/{ => legacy}/add_setting_for_selecting_lists_per_page_for_my_list.sql (100%) rename KCLS/sql/{ => legacy}/browse/001.0815.schema.config-metabib-interauthority.sql (100%) rename KCLS/sql/{ => legacy}/browse/002.0816.schema.bib-auth-browse.sql (100%) rename KCLS/sql/{ => legacy}/browse/003.0821.function.browse-normalize-timing.sql (100%) rename KCLS/sql/{ => legacy}/browse/004.0837.schema.browse-auth-linking.plus-joiner.sql (100%) rename KCLS/sql/{ => legacy}/browse/005.0839.data.alternative-title-indexing.sql (100%) rename KCLS/sql/{ => legacy}/browse/006.0844.data.better_mods_for_browse_etc.sql (100%) rename KCLS/sql/{ => legacy}/browse/007.0845.schema.browse_pivots_stable.sql (100%) rename KCLS/sql/{ => legacy}/browse/008.0846.function.vand-add_field.sql (100%) rename KCLS/sql/{ => legacy}/browse/009.kmain538.create_and_index_truncated_sort_value.sql (100%) rename KCLS/sql/{ => legacy}/browse/010.kmain538.replace_browse_function.sql (100%) rename KCLS/sql/{ => legacy}/browse/011.kmain538.replace_metabib_reingest_metabib_field_entries.sql (100%) rename KCLS/sql/{ => legacy}/browse/012.kmain553.Author.SQL (100%) rename KCLS/sql/{ => legacy}/browse/013.kmain553.Series.SQL (100%) rename KCLS/sql/{ => legacy}/browse/014.kmain553.Subject.SQL (100%) rename KCLS/sql/{ => legacy}/browse/015.kmain553.Title.SQL (100%) rename KCLS/sql/{ => legacy}/browse/016.kmain553.metabib_browse_function.SQL (100%) rename KCLS/sql/{ => legacy}/browse/017.kmain553.metabib.staged_browse_function.SQL (100%) rename KCLS/sql/{ => legacy}/browse/018.kmain553.metabib.reingest_metabib_field_entries.SQL (100%) rename KCLS/sql/{ => legacy}/browse/020.kmain212.metabib.staged_browse.SQL (100%) rename KCLS/sql/{ => legacy}/browse/021.kmain212.biblio.extract_metabib_field_entry.SQL (100%) rename KCLS/sql/{ => legacy}/browse/022.kmain212.metabib.reingest_metabib_field_entries.SQL (100%) rename KCLS/sql/{ => legacy}/browse/023.kmain212.Call_Number.SQL (100%) rename KCLS/sql/{ => legacy}/browse/024.kmain212.metabib_browse_function.SQL (100%) rename KCLS/sql/{ => legacy}/browse/025.kmain936.remove_browse_entry_references.SQL (100%) rename KCLS/sql/{ => legacy}/browse/KMAIN-877.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/000.remove_old_auth_data.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0001.public.export-ids-086-092-099.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0002.public.export-ids-001.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0003.public.export-ids-998.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0004.public.export-ids-has-copy.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0005.public.export-ids-ldr.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0006.public.export-ids-cat-date.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0007.public.export-generate-ids.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/001.tables.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/002.large_update_to_config_xml_transform.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0025.kmain-806-separate_browse_entry_simple_heading_map.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/0026.kmain-762-public_replace_ampersand.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/003.split_up_browse_into_tables.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/004.naco_normalize_keep_decimal.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/005.call_number_browse.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/006.data-type-etc.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/007.functions.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/008.kmain-223-auth-match.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/009.kmain-806-populate_separate_browse_entry_simple_heading_map.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/010.kmain-935-modify_biblio_indexing_ingest_or_delete.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/011.kmain-1011-metabib.triggered_reingest_for_bib_set.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/012.kmain-1039-authority-unlinked-bibs-to-auth.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/013.kmain-1053-auth_n_bib_generator.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/014.kmain-1105-authority.unlinked_auths_to_given_auth_id.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/015.create_vandelay_queue_and_merge_profile.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/016.kmain-1113-ongoing_generate_auth_ids_for_auth_to_auth_given_date.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/017.kmain-1119-remove_duplicate_browse_entries.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/018.kmain-1128-ui_improvements.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/019.kmain-1175-metabib-triggered_reingest_for_bib_id.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/020.kmain-1160-update_config_xml_transform_for_name_kcls.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/021.kmain-1213-update_authority_generate_overlay_template.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/022.kmain-1199-fix-auth-to-auth-link.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/023.kmain-1204-update-authority-control-set-bib-field-metabib-field-map.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/README (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/deploy.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_authority_refs_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_bib_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_authority_refs_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_bib_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_authority_refs_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_bib_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_authority_refs_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_bib_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_table_bounds.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_authority_refs_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_bib_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_pivot.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/tables.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/browse_speed_improvements_CMD/test.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/kmain212.testsForSQL (100%) rename KCLS/sql/{ => legacy}/browse/combined/reingest/data_update_driver.html (100%) rename KCLS/sql/{ => legacy}/browse/combined/reingest/data_update_driver.pl (100%) rename KCLS/sql/{ => legacy}/browse/combined/reingest/reingest_metabib_data.sql (100%) rename KCLS/sql/{ => legacy}/browse/combined/runReingestSh.sh (100%) rename KCLS/sql/{ => legacy}/browse/combined/runSh.sh (100%) rename KCLS/sql/{ => legacy}/browse/kmain-706/kmain-706.4-to-1-rollback.sql (100%) rename KCLS/sql/{ => legacy}/browse/kmain-706/kmain-706.4-to-1.sql (100%) rename KCLS/sql/{ => legacy}/browse/kmain212.README (100%) rename KCLS/sql/{ => legacy}/browse/kmain212.testsForSQL (100%) rename KCLS/sql/{ => legacy}/browse/kmain553.README (100%) rename KCLS/sql/{ => legacy}/browse/kmain691.sql (100%) rename KCLS/sql/{ => legacy}/browse/kmain925/kmain925-remove_duplicate_auth_records (100%) rename KCLS/sql/{ => legacy}/browse/rollback/025.kmain936.remove_browse_entry_references.rollback.SQL (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain212.Call_Number.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain212.biblio.extract_metabib_field_entry.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain212.metabib.reingest_metabib_field_entries.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain212.metabib.staged_browse.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain212.metabib_browse_function.SQL.ROLLBACK (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain538.create_and_index_truncated_sort_value.rollback.sql (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain538.replace_browse_function.rollback.sql (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain538.replace_metabib_reingest_metabib_field_entries-rollback.sql (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain553.All.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain553.metabib.reingest_metabib_field_entries.SQL.Rollback (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain553.metabib.staged_browse_function.SQL.ROLLBACK (100%) rename KCLS/sql/{ => legacy}/browse/rollback/kmain553.metabib_browse_function.SQL.ROLLBACK (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/001.public.export-generate-ids-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/002.public.export-ids-001-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/003.public.export-ids-998-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/004.public.export-ids-has-copy-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/005.public.export-ids-ldr-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/006.public.export-ids-cat-date-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/007.public.export-ids-086-092-099-rollback.sql (100%) rename KCLS/sql/{ => legacy}/export_process/rollback_scripts/runSh.sh (100%) rename KCLS/sql/{ => legacy}/export_process/runSh.sh (100%) rename KCLS/sql/{ => legacy}/jbas-149/0869.schema.pre-calculate-prox-adjustment.sql (100%) rename KCLS/sql/{ => legacy}/jbas-149/XXXX.schema.clear_hold_copy_map.sql (100%) rename KCLS/sql/{ => legacy}/jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql (100%) rename KCLS/sql/{ => legacy}/jbas-149/jbas-149-and-jbas-228-combined-upgrade.undo.sql (100%) rename KCLS/sql/{ => legacy}/jbas-228/XXXX.schema.fund_debit_invoice_links.sql (100%) rename KCLS/sql/{ => legacy}/jbas-408/jbas-408-copy-map-delete-fulfill.sql (100%) rename KCLS/sql/{ => legacy}/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql (100%) rename KCLS/sql/{ => legacy}/jbas-495/01.2.4.1-2.5.7-upgrade.sql (100%) rename KCLS/sql/{ => legacy}/jbas-495/02.collection-hq-items-2.5.sql (100%) rename KCLS/sql/{ => legacy}/jbas-495/03.mods-for-2.5.sql (100%) rename KCLS/sql/{ => legacy}/jbas-495/04.KMAIN-1765-reingest-causing-false-browse-headings.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/authority-indexing-ingest-or-delete.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/authority-simple-heading-set.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/metabib-reingest-metabib-field-entries.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/rollback_scripts/authority-indexing-ingest-or-delete-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/rollback_scripts/authority-simple-heading-set-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1060/rollback_scripts/metabib-reingest-metabib-field-entries-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1074/kmain-1074-indexing_ingest_or_delete.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1074/kmain-1074-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1102/kmain-1102-authority-reingest-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1102/kmain-1102-authority-reingest.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1102/kmain-1102-metabib-reingest-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1102/kmain-1102-metabib-reingest.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/authority-get_5xx_heading.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/create_and_populate-authority-display_5xx_headings.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/metabib-get_browse_author_entry_marc_record.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/metabib-get_browse_entry_marc_record.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/metabib-get_browse_series_entry_marc_record.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/metabib-get_browse_subject_entry_marc_record.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/rollback_scripts/authority-get_5xx_heading-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/rollback_scripts/metabib-get_browse_author_entry_marc_record-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/rollback_scripts/metabib-get_browse_entry_marc_record-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/rollback_scripts/metabib-get_browse_series_entry_marc_record-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1128/rollback_scripts/metabib-get_browse_subject_entry_marc_record-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1199/kmain-1199-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1199/kmain-1199.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1204/update-authority-control-set-bib-field-metabib-field-map-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1204/update-authority-control-set-bib-field-metabib-field-map.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1312/create_metabib_bib_export_data.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1312/create_metabib_bib_export_data_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1312/metabib_set_export_date.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1312/metabib_set_export_date_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1314/kmain-1314-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1314/kmain-1314.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1324/metabib-bib-export-data-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1324/metabib-bib-export-data.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1324/metabib-set-import-date-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1324/metabib-set-import-date.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1521/authority_heading_changed.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1521/authority_heading_changed_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1521/authority_indexing_ingest_or_delete.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1521/authority_indexing_ingest_or_delete_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1528/kmain-1528-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1528/kmain-1528.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings.sql (100%) rename KCLS/sql/{ => legacy}/kmain-223/kmain-223-auth-match.sql (100%) rename KCLS/sql/{ => legacy}/kmain-223/kmain-223-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-268/kmain-268-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-268/kmain-268.sql (100%) rename KCLS/sql/{ => legacy}/kmain-310/kclsupgrad34.rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-310/kclsupgrad34.sql (100%) rename KCLS/sql/{ => legacy}/kmain-385-standard-default-messages.sql (100%) rename KCLS/sql/{ => legacy}/kmain-392/kmain392.sql (100%) rename KCLS/sql/{ => legacy}/kmain-695/kmain-695-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-695/kmain-695.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-author-authority-refs-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-author-bib-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-series-authority-refs-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-series-bib-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-subject-authority-refs-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-subject-bib-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-text.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-title-authority-refs-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/metabib-browse-title-bib-pivot.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/public-replace-ampersand.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-author-authority-refs-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-author-bib-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-series-authority-refs-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-series-bib-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-subject-authority-refs-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-subject-bib-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-text-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-title-authority-refs-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/metabib-browse-title-bib-pivot-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-762/rollback_scripts/public-replace-ampersand-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-81-upgrad-98_usr_activity_types.sql (100%) rename KCLS/sql/{ => legacy}/kmain-81-upgrad-98_usr_activity_types_rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-903/kmain-903-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-903/kmain-903.sql (100%) rename KCLS/sql/{ => legacy}/kmain-972/public.export-generate-ids.sql (100%) rename KCLS/sql/{ => legacy}/kmain-972/rollback_scripts/public.export-generate-ids-params-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-constraints-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-constraints.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-indexing_ingest_or_delete-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-indexing_ingest_or_delete.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-reingest_metabib_field_entries-rollback.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-reingest_metabib_field_entries.sql (100%) rename KCLS/sql/{ => legacy}/kmain-976/kmain-976-upgrade-prep.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0815.schema.config-metabib-interauthority.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0816.schema.bib-auth-browse.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0821.function.browse-normalize-timing.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0837.schema.browse-auth-linking.plus-joiner.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0839.data.alternative-title-indexing.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0844.data.better_mods_for_browse_etc.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0845.schema.browse_pivots_stable.sql (100%) rename KCLS/sql/{ => legacy}/kmain221/0846.function.vand-add_field.sql (100%) rename KCLS/sql/{ => legacy}/kmain228/add_cataloging_date_column_to_bre.sql (100%) rename KCLS/sql/{ => legacy}/kmain228/rollback-add_cataloging_date_column_to_bre.sql (100%) rename KCLS/sql/{ => legacy}/kmig-147.sql (100%) rename KCLS/sql/{ => legacy}/kmig-187.sql (100%) rename KCLS/sql/{ => legacy}/kmig57-default_search_location_trigger.sql (100%) create mode 100644 KCLS/sql/sample-data/deploy/no_op_initialization.sql rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-aous.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-auths.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-cns.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-copies.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-db-export.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-db-extras.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-recs.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-users.sql (100%) rename KCLS/sql/{dev-data => sample-data/exports}/kcls-dev-xacts.sql (100%) create mode 100644 KCLS/sql/sample-data/revert/no_op_initialization.sql rename KCLS/{sqitch => sql/sample-data}/sqitch.conf (100%) create mode 100644 KCLS/sql/sample-data/sqitch.plan rename KCLS/sql/{dev-data => sample-data/tools}/create-dev-db.sh (100%) rename KCLS/sql/{dev-data => sample-data}/tools/export-dev-data.sh (100%) rename KCLS/sql/{dev-data => sample-data}/tools/export-tables.txt (100%) rename KCLS/sql/{dev-data => sample-data}/tools/kcls-dev-rec-ids.txt (100%) create mode 100644 KCLS/sql/sample-data/verify/no_op_initialization.sql rename KCLS/{sqitch => sql/schema}/deploy/01.2.4.1-2.5.7-deps.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/01.2.4.1-2.5.7-upgrade.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/02.collection-hq-items-2.5.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/KMAIN-1765-reingest-causing-false-browse-headings.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/deploy/kcls-2.4-base-prod.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/01.2.4.1-2.5.7-deps.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/01.2.4.1-2.5.7-upgrade.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/02.collection-hq-items-2.5.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/KMAIN-1765-reingest-causing-false-browse-headings.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/KMAIN_1448_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/KMAIN_1729_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/revert/kcls-2.4-base-prod.sql (100%) create mode 100644 KCLS/sql/schema/sqitch.conf rename KCLS/{sqitch => sql/schema}/sqitch.plan (100%) rename KCLS/{sqitch => sql/schema}/verify/01.2.4.1-2.5.7-deps.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/01.2.4.1-2.5.7-upgrade.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/02.collection-hq-items-2.5.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/KMAIN_1448_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/KMAIN_1729_Bug_from_KMAIN_268.sql (100%) rename KCLS/{sqitch => sql/schema}/verify/kcls-2.4-base-prod.sql (100%) diff --git a/KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL b/KCLS/sql/legacy/HoldingsMaintenance/holdings_maintenance.SQL similarity index 100% rename from KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL rename to KCLS/sql/legacy/HoldingsMaintenance/holdings_maintenance.SQL diff --git a/KCLS/sql/HoldingsMaintenance/holdings_maintenance_rollback.SQL b/KCLS/sql/legacy/HoldingsMaintenance/holdings_maintenance_rollback.SQL similarity index 100% rename from KCLS/sql/HoldingsMaintenance/holdings_maintenance_rollback.SQL rename to KCLS/sql/legacy/HoldingsMaintenance/holdings_maintenance_rollback.SQL diff --git a/KCLS/sql/KMAIN-1639/KMAIN-1639-Add-update-permissions-rollback.sql b/KCLS/sql/legacy/KMAIN-1639/KMAIN-1639-Add-update-permissions-rollback.sql similarity index 100% rename from KCLS/sql/KMAIN-1639/KMAIN-1639-Add-update-permissions-rollback.sql rename to KCLS/sql/legacy/KMAIN-1639/KMAIN-1639-Add-update-permissions-rollback.sql diff --git a/KCLS/sql/KMAIN-1639/KMAIN-1639-Add-update-permissions.sql b/KCLS/sql/legacy/KMAIN-1639/KMAIN-1639-Add-update-permissions.sql similarity index 100% rename from KCLS/sql/KMAIN-1639/KMAIN-1639-Add-update-permissions.sql rename to KCLS/sql/legacy/KMAIN-1639/KMAIN-1639-Add-update-permissions.sql diff --git a/KCLS/sql/legacy/README b/KCLS/sql/legacy/README new file mode 100644 index 0000000000..41adeb5152 --- /dev/null +++ b/KCLS/sql/legacy/README @@ -0,0 +1,2 @@ +Collection of SQL updates from days gone by. +Leaving there here for now for reference. diff --git a/KCLS/sql/add_setting_for_selecting_lists_per_page_for_my_list.sql b/KCLS/sql/legacy/add_setting_for_selecting_lists_per_page_for_my_list.sql similarity index 100% rename from KCLS/sql/add_setting_for_selecting_lists_per_page_for_my_list.sql rename to KCLS/sql/legacy/add_setting_for_selecting_lists_per_page_for_my_list.sql diff --git a/KCLS/sql/browse/001.0815.schema.config-metabib-interauthority.sql b/KCLS/sql/legacy/browse/001.0815.schema.config-metabib-interauthority.sql similarity index 100% rename from KCLS/sql/browse/001.0815.schema.config-metabib-interauthority.sql rename to KCLS/sql/legacy/browse/001.0815.schema.config-metabib-interauthority.sql diff --git a/KCLS/sql/browse/002.0816.schema.bib-auth-browse.sql b/KCLS/sql/legacy/browse/002.0816.schema.bib-auth-browse.sql similarity index 100% rename from KCLS/sql/browse/002.0816.schema.bib-auth-browse.sql rename to KCLS/sql/legacy/browse/002.0816.schema.bib-auth-browse.sql diff --git a/KCLS/sql/browse/003.0821.function.browse-normalize-timing.sql b/KCLS/sql/legacy/browse/003.0821.function.browse-normalize-timing.sql similarity index 100% rename from KCLS/sql/browse/003.0821.function.browse-normalize-timing.sql rename to KCLS/sql/legacy/browse/003.0821.function.browse-normalize-timing.sql diff --git a/KCLS/sql/browse/004.0837.schema.browse-auth-linking.plus-joiner.sql b/KCLS/sql/legacy/browse/004.0837.schema.browse-auth-linking.plus-joiner.sql similarity index 100% rename from KCLS/sql/browse/004.0837.schema.browse-auth-linking.plus-joiner.sql rename to KCLS/sql/legacy/browse/004.0837.schema.browse-auth-linking.plus-joiner.sql diff --git a/KCLS/sql/browse/005.0839.data.alternative-title-indexing.sql b/KCLS/sql/legacy/browse/005.0839.data.alternative-title-indexing.sql similarity index 100% rename from KCLS/sql/browse/005.0839.data.alternative-title-indexing.sql rename to KCLS/sql/legacy/browse/005.0839.data.alternative-title-indexing.sql diff --git a/KCLS/sql/browse/006.0844.data.better_mods_for_browse_etc.sql b/KCLS/sql/legacy/browse/006.0844.data.better_mods_for_browse_etc.sql similarity index 100% rename from KCLS/sql/browse/006.0844.data.better_mods_for_browse_etc.sql rename to KCLS/sql/legacy/browse/006.0844.data.better_mods_for_browse_etc.sql diff --git a/KCLS/sql/browse/007.0845.schema.browse_pivots_stable.sql b/KCLS/sql/legacy/browse/007.0845.schema.browse_pivots_stable.sql similarity index 100% rename from KCLS/sql/browse/007.0845.schema.browse_pivots_stable.sql rename to KCLS/sql/legacy/browse/007.0845.schema.browse_pivots_stable.sql diff --git a/KCLS/sql/browse/008.0846.function.vand-add_field.sql b/KCLS/sql/legacy/browse/008.0846.function.vand-add_field.sql similarity index 100% rename from KCLS/sql/browse/008.0846.function.vand-add_field.sql rename to KCLS/sql/legacy/browse/008.0846.function.vand-add_field.sql diff --git a/KCLS/sql/browse/009.kmain538.create_and_index_truncated_sort_value.sql b/KCLS/sql/legacy/browse/009.kmain538.create_and_index_truncated_sort_value.sql similarity index 100% rename from KCLS/sql/browse/009.kmain538.create_and_index_truncated_sort_value.sql rename to KCLS/sql/legacy/browse/009.kmain538.create_and_index_truncated_sort_value.sql diff --git a/KCLS/sql/browse/010.kmain538.replace_browse_function.sql b/KCLS/sql/legacy/browse/010.kmain538.replace_browse_function.sql similarity index 100% rename from KCLS/sql/browse/010.kmain538.replace_browse_function.sql rename to KCLS/sql/legacy/browse/010.kmain538.replace_browse_function.sql diff --git a/KCLS/sql/browse/011.kmain538.replace_metabib_reingest_metabib_field_entries.sql b/KCLS/sql/legacy/browse/011.kmain538.replace_metabib_reingest_metabib_field_entries.sql similarity index 100% rename from KCLS/sql/browse/011.kmain538.replace_metabib_reingest_metabib_field_entries.sql rename to KCLS/sql/legacy/browse/011.kmain538.replace_metabib_reingest_metabib_field_entries.sql diff --git a/KCLS/sql/browse/012.kmain553.Author.SQL b/KCLS/sql/legacy/browse/012.kmain553.Author.SQL similarity index 100% rename from KCLS/sql/browse/012.kmain553.Author.SQL rename to KCLS/sql/legacy/browse/012.kmain553.Author.SQL diff --git a/KCLS/sql/browse/013.kmain553.Series.SQL b/KCLS/sql/legacy/browse/013.kmain553.Series.SQL similarity index 100% rename from KCLS/sql/browse/013.kmain553.Series.SQL rename to KCLS/sql/legacy/browse/013.kmain553.Series.SQL diff --git a/KCLS/sql/browse/014.kmain553.Subject.SQL b/KCLS/sql/legacy/browse/014.kmain553.Subject.SQL similarity index 100% rename from KCLS/sql/browse/014.kmain553.Subject.SQL rename to KCLS/sql/legacy/browse/014.kmain553.Subject.SQL diff --git a/KCLS/sql/browse/015.kmain553.Title.SQL b/KCLS/sql/legacy/browse/015.kmain553.Title.SQL similarity index 100% rename from KCLS/sql/browse/015.kmain553.Title.SQL rename to KCLS/sql/legacy/browse/015.kmain553.Title.SQL diff --git a/KCLS/sql/browse/016.kmain553.metabib_browse_function.SQL b/KCLS/sql/legacy/browse/016.kmain553.metabib_browse_function.SQL similarity index 100% rename from KCLS/sql/browse/016.kmain553.metabib_browse_function.SQL rename to KCLS/sql/legacy/browse/016.kmain553.metabib_browse_function.SQL diff --git a/KCLS/sql/browse/017.kmain553.metabib.staged_browse_function.SQL b/KCLS/sql/legacy/browse/017.kmain553.metabib.staged_browse_function.SQL similarity index 100% rename from KCLS/sql/browse/017.kmain553.metabib.staged_browse_function.SQL rename to KCLS/sql/legacy/browse/017.kmain553.metabib.staged_browse_function.SQL diff --git a/KCLS/sql/browse/018.kmain553.metabib.reingest_metabib_field_entries.SQL b/KCLS/sql/legacy/browse/018.kmain553.metabib.reingest_metabib_field_entries.SQL similarity index 100% rename from KCLS/sql/browse/018.kmain553.metabib.reingest_metabib_field_entries.SQL rename to KCLS/sql/legacy/browse/018.kmain553.metabib.reingest_metabib_field_entries.SQL diff --git a/KCLS/sql/browse/020.kmain212.metabib.staged_browse.SQL b/KCLS/sql/legacy/browse/020.kmain212.metabib.staged_browse.SQL similarity index 100% rename from KCLS/sql/browse/020.kmain212.metabib.staged_browse.SQL rename to KCLS/sql/legacy/browse/020.kmain212.metabib.staged_browse.SQL diff --git a/KCLS/sql/browse/021.kmain212.biblio.extract_metabib_field_entry.SQL b/KCLS/sql/legacy/browse/021.kmain212.biblio.extract_metabib_field_entry.SQL similarity index 100% rename from KCLS/sql/browse/021.kmain212.biblio.extract_metabib_field_entry.SQL rename to KCLS/sql/legacy/browse/021.kmain212.biblio.extract_metabib_field_entry.SQL diff --git a/KCLS/sql/browse/022.kmain212.metabib.reingest_metabib_field_entries.SQL b/KCLS/sql/legacy/browse/022.kmain212.metabib.reingest_metabib_field_entries.SQL similarity index 100% rename from KCLS/sql/browse/022.kmain212.metabib.reingest_metabib_field_entries.SQL rename to KCLS/sql/legacy/browse/022.kmain212.metabib.reingest_metabib_field_entries.SQL diff --git a/KCLS/sql/browse/023.kmain212.Call_Number.SQL b/KCLS/sql/legacy/browse/023.kmain212.Call_Number.SQL similarity index 100% rename from KCLS/sql/browse/023.kmain212.Call_Number.SQL rename to KCLS/sql/legacy/browse/023.kmain212.Call_Number.SQL diff --git a/KCLS/sql/browse/024.kmain212.metabib_browse_function.SQL b/KCLS/sql/legacy/browse/024.kmain212.metabib_browse_function.SQL similarity index 100% rename from KCLS/sql/browse/024.kmain212.metabib_browse_function.SQL rename to KCLS/sql/legacy/browse/024.kmain212.metabib_browse_function.SQL diff --git a/KCLS/sql/browse/025.kmain936.remove_browse_entry_references.SQL b/KCLS/sql/legacy/browse/025.kmain936.remove_browse_entry_references.SQL similarity index 100% rename from KCLS/sql/browse/025.kmain936.remove_browse_entry_references.SQL rename to KCLS/sql/legacy/browse/025.kmain936.remove_browse_entry_references.SQL diff --git a/KCLS/sql/browse/KMAIN-877.sql b/KCLS/sql/legacy/browse/KMAIN-877.sql similarity index 100% rename from KCLS/sql/browse/KMAIN-877.sql rename to KCLS/sql/legacy/browse/KMAIN-877.sql diff --git a/KCLS/sql/browse/combined/000.remove_old_auth_data.sql b/KCLS/sql/legacy/browse/combined/000.remove_old_auth_data.sql similarity index 100% rename from KCLS/sql/browse/combined/000.remove_old_auth_data.sql rename to KCLS/sql/legacy/browse/combined/000.remove_old_auth_data.sql diff --git a/KCLS/sql/browse/combined/0001.public.export-ids-086-092-099.sql b/KCLS/sql/legacy/browse/combined/0001.public.export-ids-086-092-099.sql similarity index 100% rename from KCLS/sql/browse/combined/0001.public.export-ids-086-092-099.sql rename to KCLS/sql/legacy/browse/combined/0001.public.export-ids-086-092-099.sql diff --git a/KCLS/sql/browse/combined/0002.public.export-ids-001.sql b/KCLS/sql/legacy/browse/combined/0002.public.export-ids-001.sql similarity index 100% rename from KCLS/sql/browse/combined/0002.public.export-ids-001.sql rename to KCLS/sql/legacy/browse/combined/0002.public.export-ids-001.sql diff --git a/KCLS/sql/browse/combined/0003.public.export-ids-998.sql b/KCLS/sql/legacy/browse/combined/0003.public.export-ids-998.sql similarity index 100% rename from KCLS/sql/browse/combined/0003.public.export-ids-998.sql rename to KCLS/sql/legacy/browse/combined/0003.public.export-ids-998.sql diff --git a/KCLS/sql/browse/combined/0004.public.export-ids-has-copy.sql b/KCLS/sql/legacy/browse/combined/0004.public.export-ids-has-copy.sql similarity index 100% rename from KCLS/sql/browse/combined/0004.public.export-ids-has-copy.sql rename to KCLS/sql/legacy/browse/combined/0004.public.export-ids-has-copy.sql diff --git a/KCLS/sql/browse/combined/0005.public.export-ids-ldr.sql b/KCLS/sql/legacy/browse/combined/0005.public.export-ids-ldr.sql similarity index 100% rename from KCLS/sql/browse/combined/0005.public.export-ids-ldr.sql rename to KCLS/sql/legacy/browse/combined/0005.public.export-ids-ldr.sql diff --git a/KCLS/sql/browse/combined/0006.public.export-ids-cat-date.sql b/KCLS/sql/legacy/browse/combined/0006.public.export-ids-cat-date.sql similarity index 100% rename from KCLS/sql/browse/combined/0006.public.export-ids-cat-date.sql rename to KCLS/sql/legacy/browse/combined/0006.public.export-ids-cat-date.sql diff --git a/KCLS/sql/browse/combined/0007.public.export-generate-ids.sql b/KCLS/sql/legacy/browse/combined/0007.public.export-generate-ids.sql similarity index 100% rename from KCLS/sql/browse/combined/0007.public.export-generate-ids.sql rename to KCLS/sql/legacy/browse/combined/0007.public.export-generate-ids.sql diff --git a/KCLS/sql/browse/combined/001.tables.sql b/KCLS/sql/legacy/browse/combined/001.tables.sql similarity index 100% rename from KCLS/sql/browse/combined/001.tables.sql rename to KCLS/sql/legacy/browse/combined/001.tables.sql diff --git a/KCLS/sql/browse/combined/002.large_update_to_config_xml_transform.sql b/KCLS/sql/legacy/browse/combined/002.large_update_to_config_xml_transform.sql similarity index 100% rename from KCLS/sql/browse/combined/002.large_update_to_config_xml_transform.sql rename to KCLS/sql/legacy/browse/combined/002.large_update_to_config_xml_transform.sql diff --git a/KCLS/sql/browse/combined/0025.kmain-806-separate_browse_entry_simple_heading_map.sql b/KCLS/sql/legacy/browse/combined/0025.kmain-806-separate_browse_entry_simple_heading_map.sql similarity index 100% rename from KCLS/sql/browse/combined/0025.kmain-806-separate_browse_entry_simple_heading_map.sql rename to KCLS/sql/legacy/browse/combined/0025.kmain-806-separate_browse_entry_simple_heading_map.sql diff --git a/KCLS/sql/browse/combined/0026.kmain-762-public_replace_ampersand.sql b/KCLS/sql/legacy/browse/combined/0026.kmain-762-public_replace_ampersand.sql similarity index 100% rename from KCLS/sql/browse/combined/0026.kmain-762-public_replace_ampersand.sql rename to KCLS/sql/legacy/browse/combined/0026.kmain-762-public_replace_ampersand.sql diff --git a/KCLS/sql/browse/combined/003.split_up_browse_into_tables.sql b/KCLS/sql/legacy/browse/combined/003.split_up_browse_into_tables.sql similarity index 100% rename from KCLS/sql/browse/combined/003.split_up_browse_into_tables.sql rename to KCLS/sql/legacy/browse/combined/003.split_up_browse_into_tables.sql diff --git a/KCLS/sql/browse/combined/004.naco_normalize_keep_decimal.sql b/KCLS/sql/legacy/browse/combined/004.naco_normalize_keep_decimal.sql similarity index 100% rename from KCLS/sql/browse/combined/004.naco_normalize_keep_decimal.sql rename to KCLS/sql/legacy/browse/combined/004.naco_normalize_keep_decimal.sql diff --git a/KCLS/sql/browse/combined/005.call_number_browse.sql b/KCLS/sql/legacy/browse/combined/005.call_number_browse.sql similarity index 100% rename from KCLS/sql/browse/combined/005.call_number_browse.sql rename to KCLS/sql/legacy/browse/combined/005.call_number_browse.sql diff --git a/KCLS/sql/browse/combined/006.data-type-etc.sql b/KCLS/sql/legacy/browse/combined/006.data-type-etc.sql similarity index 100% rename from KCLS/sql/browse/combined/006.data-type-etc.sql rename to KCLS/sql/legacy/browse/combined/006.data-type-etc.sql diff --git a/KCLS/sql/browse/combined/007.functions.sql b/KCLS/sql/legacy/browse/combined/007.functions.sql similarity index 100% rename from KCLS/sql/browse/combined/007.functions.sql rename to KCLS/sql/legacy/browse/combined/007.functions.sql diff --git a/KCLS/sql/browse/combined/008.kmain-223-auth-match.sql b/KCLS/sql/legacy/browse/combined/008.kmain-223-auth-match.sql similarity index 100% rename from KCLS/sql/browse/combined/008.kmain-223-auth-match.sql rename to KCLS/sql/legacy/browse/combined/008.kmain-223-auth-match.sql diff --git a/KCLS/sql/browse/combined/009.kmain-806-populate_separate_browse_entry_simple_heading_map.sql b/KCLS/sql/legacy/browse/combined/009.kmain-806-populate_separate_browse_entry_simple_heading_map.sql similarity index 100% rename from KCLS/sql/browse/combined/009.kmain-806-populate_separate_browse_entry_simple_heading_map.sql rename to KCLS/sql/legacy/browse/combined/009.kmain-806-populate_separate_browse_entry_simple_heading_map.sql diff --git a/KCLS/sql/browse/combined/010.kmain-935-modify_biblio_indexing_ingest_or_delete.sql b/KCLS/sql/legacy/browse/combined/010.kmain-935-modify_biblio_indexing_ingest_or_delete.sql similarity index 100% rename from KCLS/sql/browse/combined/010.kmain-935-modify_biblio_indexing_ingest_or_delete.sql rename to KCLS/sql/legacy/browse/combined/010.kmain-935-modify_biblio_indexing_ingest_or_delete.sql diff --git a/KCLS/sql/browse/combined/011.kmain-1011-metabib.triggered_reingest_for_bib_set.sql b/KCLS/sql/legacy/browse/combined/011.kmain-1011-metabib.triggered_reingest_for_bib_set.sql similarity index 100% rename from KCLS/sql/browse/combined/011.kmain-1011-metabib.triggered_reingest_for_bib_set.sql rename to KCLS/sql/legacy/browse/combined/011.kmain-1011-metabib.triggered_reingest_for_bib_set.sql diff --git a/KCLS/sql/browse/combined/012.kmain-1039-authority-unlinked-bibs-to-auth.sql b/KCLS/sql/legacy/browse/combined/012.kmain-1039-authority-unlinked-bibs-to-auth.sql similarity index 100% rename from KCLS/sql/browse/combined/012.kmain-1039-authority-unlinked-bibs-to-auth.sql rename to KCLS/sql/legacy/browse/combined/012.kmain-1039-authority-unlinked-bibs-to-auth.sql diff --git a/KCLS/sql/browse/combined/013.kmain-1053-auth_n_bib_generator.sql b/KCLS/sql/legacy/browse/combined/013.kmain-1053-auth_n_bib_generator.sql similarity index 100% rename from KCLS/sql/browse/combined/013.kmain-1053-auth_n_bib_generator.sql rename to KCLS/sql/legacy/browse/combined/013.kmain-1053-auth_n_bib_generator.sql diff --git a/KCLS/sql/browse/combined/014.kmain-1105-authority.unlinked_auths_to_given_auth_id.sql b/KCLS/sql/legacy/browse/combined/014.kmain-1105-authority.unlinked_auths_to_given_auth_id.sql similarity index 100% rename from KCLS/sql/browse/combined/014.kmain-1105-authority.unlinked_auths_to_given_auth_id.sql rename to KCLS/sql/legacy/browse/combined/014.kmain-1105-authority.unlinked_auths_to_given_auth_id.sql diff --git a/KCLS/sql/browse/combined/015.create_vandelay_queue_and_merge_profile.sql b/KCLS/sql/legacy/browse/combined/015.create_vandelay_queue_and_merge_profile.sql similarity index 100% rename from KCLS/sql/browse/combined/015.create_vandelay_queue_and_merge_profile.sql rename to KCLS/sql/legacy/browse/combined/015.create_vandelay_queue_and_merge_profile.sql diff --git a/KCLS/sql/browse/combined/016.kmain-1113-ongoing_generate_auth_ids_for_auth_to_auth_given_date.sql b/KCLS/sql/legacy/browse/combined/016.kmain-1113-ongoing_generate_auth_ids_for_auth_to_auth_given_date.sql similarity index 100% rename from KCLS/sql/browse/combined/016.kmain-1113-ongoing_generate_auth_ids_for_auth_to_auth_given_date.sql rename to KCLS/sql/legacy/browse/combined/016.kmain-1113-ongoing_generate_auth_ids_for_auth_to_auth_given_date.sql diff --git a/KCLS/sql/browse/combined/017.kmain-1119-remove_duplicate_browse_entries.sql b/KCLS/sql/legacy/browse/combined/017.kmain-1119-remove_duplicate_browse_entries.sql similarity index 100% rename from KCLS/sql/browse/combined/017.kmain-1119-remove_duplicate_browse_entries.sql rename to KCLS/sql/legacy/browse/combined/017.kmain-1119-remove_duplicate_browse_entries.sql diff --git a/KCLS/sql/browse/combined/018.kmain-1128-ui_improvements.sql b/KCLS/sql/legacy/browse/combined/018.kmain-1128-ui_improvements.sql similarity index 100% rename from KCLS/sql/browse/combined/018.kmain-1128-ui_improvements.sql rename to KCLS/sql/legacy/browse/combined/018.kmain-1128-ui_improvements.sql diff --git a/KCLS/sql/browse/combined/019.kmain-1175-metabib-triggered_reingest_for_bib_id.sql b/KCLS/sql/legacy/browse/combined/019.kmain-1175-metabib-triggered_reingest_for_bib_id.sql similarity index 100% rename from KCLS/sql/browse/combined/019.kmain-1175-metabib-triggered_reingest_for_bib_id.sql rename to KCLS/sql/legacy/browse/combined/019.kmain-1175-metabib-triggered_reingest_for_bib_id.sql diff --git a/KCLS/sql/browse/combined/020.kmain-1160-update_config_xml_transform_for_name_kcls.sql b/KCLS/sql/legacy/browse/combined/020.kmain-1160-update_config_xml_transform_for_name_kcls.sql similarity index 100% rename from KCLS/sql/browse/combined/020.kmain-1160-update_config_xml_transform_for_name_kcls.sql rename to KCLS/sql/legacy/browse/combined/020.kmain-1160-update_config_xml_transform_for_name_kcls.sql diff --git a/KCLS/sql/browse/combined/021.kmain-1213-update_authority_generate_overlay_template.sql b/KCLS/sql/legacy/browse/combined/021.kmain-1213-update_authority_generate_overlay_template.sql similarity index 100% rename from KCLS/sql/browse/combined/021.kmain-1213-update_authority_generate_overlay_template.sql rename to KCLS/sql/legacy/browse/combined/021.kmain-1213-update_authority_generate_overlay_template.sql diff --git a/KCLS/sql/browse/combined/022.kmain-1199-fix-auth-to-auth-link.sql b/KCLS/sql/legacy/browse/combined/022.kmain-1199-fix-auth-to-auth-link.sql similarity index 100% rename from KCLS/sql/browse/combined/022.kmain-1199-fix-auth-to-auth-link.sql rename to KCLS/sql/legacy/browse/combined/022.kmain-1199-fix-auth-to-auth-link.sql diff --git a/KCLS/sql/browse/combined/023.kmain-1204-update-authority-control-set-bib-field-metabib-field-map.sql b/KCLS/sql/legacy/browse/combined/023.kmain-1204-update-authority-control-set-bib-field-metabib-field-map.sql similarity index 100% rename from KCLS/sql/browse/combined/023.kmain-1204-update-authority-control-set-bib-field-metabib-field-map.sql rename to KCLS/sql/legacy/browse/combined/023.kmain-1204-update-authority-control-set-bib-field-metabib-field-map.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/README b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/README similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/README rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/README diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/deploy.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/deploy.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/deploy.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/deploy.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_authority_refs_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_authority_refs_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_authority_refs_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_authority_refs_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_bib_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_bib_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_bib_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_bib_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_author_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_authority_refs_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_authority_refs_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_authority_refs_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_authority_refs_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_bib_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_bib_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_bib_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_bib_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_call_number_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_authority_refs_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_authority_refs_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_authority_refs_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_authority_refs_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_bib_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_bib_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_bib_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_bib_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_series_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_authority_refs_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_authority_refs_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_authority_refs_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_authority_refs_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_bib_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_bib_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_bib_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_bib_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_subject_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_table_bounds.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_table_bounds.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_table_bounds.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_table_bounds.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_authority_refs_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_authority_refs_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_authority_refs_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_authority_refs_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_bib_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_bib_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_bib_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_bib_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_pivot.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_pivot.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_pivot.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/metabib.browse_title_pivot.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/tables.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/tables.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/tables.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/tables.sql diff --git a/KCLS/sql/browse/combined/browse_speed_improvements_CMD/test.sql b/KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/test.sql similarity index 100% rename from KCLS/sql/browse/combined/browse_speed_improvements_CMD/test.sql rename to KCLS/sql/legacy/browse/combined/browse_speed_improvements_CMD/test.sql diff --git a/KCLS/sql/browse/combined/kmain212.testsForSQL b/KCLS/sql/legacy/browse/combined/kmain212.testsForSQL similarity index 100% rename from KCLS/sql/browse/combined/kmain212.testsForSQL rename to KCLS/sql/legacy/browse/combined/kmain212.testsForSQL diff --git a/KCLS/sql/browse/combined/reingest/data_update_driver.html b/KCLS/sql/legacy/browse/combined/reingest/data_update_driver.html similarity index 100% rename from KCLS/sql/browse/combined/reingest/data_update_driver.html rename to KCLS/sql/legacy/browse/combined/reingest/data_update_driver.html diff --git a/KCLS/sql/browse/combined/reingest/data_update_driver.pl b/KCLS/sql/legacy/browse/combined/reingest/data_update_driver.pl similarity index 100% rename from KCLS/sql/browse/combined/reingest/data_update_driver.pl rename to KCLS/sql/legacy/browse/combined/reingest/data_update_driver.pl diff --git a/KCLS/sql/browse/combined/reingest/reingest_metabib_data.sql b/KCLS/sql/legacy/browse/combined/reingest/reingest_metabib_data.sql similarity index 100% rename from KCLS/sql/browse/combined/reingest/reingest_metabib_data.sql rename to KCLS/sql/legacy/browse/combined/reingest/reingest_metabib_data.sql diff --git a/KCLS/sql/browse/combined/runReingestSh.sh b/KCLS/sql/legacy/browse/combined/runReingestSh.sh similarity index 100% rename from KCLS/sql/browse/combined/runReingestSh.sh rename to KCLS/sql/legacy/browse/combined/runReingestSh.sh diff --git a/KCLS/sql/browse/combined/runSh.sh b/KCLS/sql/legacy/browse/combined/runSh.sh similarity index 100% rename from KCLS/sql/browse/combined/runSh.sh rename to KCLS/sql/legacy/browse/combined/runSh.sh diff --git a/KCLS/sql/browse/kmain-706/kmain-706.4-to-1-rollback.sql b/KCLS/sql/legacy/browse/kmain-706/kmain-706.4-to-1-rollback.sql similarity index 100% rename from KCLS/sql/browse/kmain-706/kmain-706.4-to-1-rollback.sql rename to KCLS/sql/legacy/browse/kmain-706/kmain-706.4-to-1-rollback.sql diff --git a/KCLS/sql/browse/kmain-706/kmain-706.4-to-1.sql b/KCLS/sql/legacy/browse/kmain-706/kmain-706.4-to-1.sql similarity index 100% rename from KCLS/sql/browse/kmain-706/kmain-706.4-to-1.sql rename to KCLS/sql/legacy/browse/kmain-706/kmain-706.4-to-1.sql diff --git a/KCLS/sql/browse/kmain212.README b/KCLS/sql/legacy/browse/kmain212.README similarity index 100% rename from KCLS/sql/browse/kmain212.README rename to KCLS/sql/legacy/browse/kmain212.README diff --git a/KCLS/sql/browse/kmain212.testsForSQL b/KCLS/sql/legacy/browse/kmain212.testsForSQL similarity index 100% rename from KCLS/sql/browse/kmain212.testsForSQL rename to KCLS/sql/legacy/browse/kmain212.testsForSQL diff --git a/KCLS/sql/browse/kmain553.README b/KCLS/sql/legacy/browse/kmain553.README similarity index 100% rename from KCLS/sql/browse/kmain553.README rename to KCLS/sql/legacy/browse/kmain553.README diff --git a/KCLS/sql/browse/kmain691.sql b/KCLS/sql/legacy/browse/kmain691.sql similarity index 100% rename from KCLS/sql/browse/kmain691.sql rename to KCLS/sql/legacy/browse/kmain691.sql diff --git a/KCLS/sql/browse/kmain925/kmain925-remove_duplicate_auth_records b/KCLS/sql/legacy/browse/kmain925/kmain925-remove_duplicate_auth_records similarity index 100% rename from KCLS/sql/browse/kmain925/kmain925-remove_duplicate_auth_records rename to KCLS/sql/legacy/browse/kmain925/kmain925-remove_duplicate_auth_records diff --git a/KCLS/sql/browse/rollback/025.kmain936.remove_browse_entry_references.rollback.SQL b/KCLS/sql/legacy/browse/rollback/025.kmain936.remove_browse_entry_references.rollback.SQL similarity index 100% rename from KCLS/sql/browse/rollback/025.kmain936.remove_browse_entry_references.rollback.SQL rename to KCLS/sql/legacy/browse/rollback/025.kmain936.remove_browse_entry_references.rollback.SQL diff --git a/KCLS/sql/browse/rollback/kmain212.Call_Number.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain212.Call_Number.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain212.Call_Number.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain212.Call_Number.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain212.biblio.extract_metabib_field_entry.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain212.biblio.extract_metabib_field_entry.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain212.biblio.extract_metabib_field_entry.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain212.biblio.extract_metabib_field_entry.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain212.metabib.reingest_metabib_field_entries.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain212.metabib.reingest_metabib_field_entries.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain212.metabib.reingest_metabib_field_entries.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain212.metabib.reingest_metabib_field_entries.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain212.metabib.staged_browse.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain212.metabib.staged_browse.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain212.metabib.staged_browse.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain212.metabib.staged_browse.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain212.metabib_browse_function.SQL.ROLLBACK b/KCLS/sql/legacy/browse/rollback/kmain212.metabib_browse_function.SQL.ROLLBACK similarity index 100% rename from KCLS/sql/browse/rollback/kmain212.metabib_browse_function.SQL.ROLLBACK rename to KCLS/sql/legacy/browse/rollback/kmain212.metabib_browse_function.SQL.ROLLBACK diff --git a/KCLS/sql/browse/rollback/kmain538.create_and_index_truncated_sort_value.rollback.sql b/KCLS/sql/legacy/browse/rollback/kmain538.create_and_index_truncated_sort_value.rollback.sql similarity index 100% rename from KCLS/sql/browse/rollback/kmain538.create_and_index_truncated_sort_value.rollback.sql rename to KCLS/sql/legacy/browse/rollback/kmain538.create_and_index_truncated_sort_value.rollback.sql diff --git a/KCLS/sql/browse/rollback/kmain538.replace_browse_function.rollback.sql b/KCLS/sql/legacy/browse/rollback/kmain538.replace_browse_function.rollback.sql similarity index 100% rename from KCLS/sql/browse/rollback/kmain538.replace_browse_function.rollback.sql rename to KCLS/sql/legacy/browse/rollback/kmain538.replace_browse_function.rollback.sql diff --git a/KCLS/sql/browse/rollback/kmain538.replace_metabib_reingest_metabib_field_entries-rollback.sql b/KCLS/sql/legacy/browse/rollback/kmain538.replace_metabib_reingest_metabib_field_entries-rollback.sql similarity index 100% rename from KCLS/sql/browse/rollback/kmain538.replace_metabib_reingest_metabib_field_entries-rollback.sql rename to KCLS/sql/legacy/browse/rollback/kmain538.replace_metabib_reingest_metabib_field_entries-rollback.sql diff --git a/KCLS/sql/browse/rollback/kmain553.All.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain553.All.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain553.All.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain553.All.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain553.metabib.reingest_metabib_field_entries.SQL.Rollback b/KCLS/sql/legacy/browse/rollback/kmain553.metabib.reingest_metabib_field_entries.SQL.Rollback similarity index 100% rename from KCLS/sql/browse/rollback/kmain553.metabib.reingest_metabib_field_entries.SQL.Rollback rename to KCLS/sql/legacy/browse/rollback/kmain553.metabib.reingest_metabib_field_entries.SQL.Rollback diff --git a/KCLS/sql/browse/rollback/kmain553.metabib.staged_browse_function.SQL.ROLLBACK b/KCLS/sql/legacy/browse/rollback/kmain553.metabib.staged_browse_function.SQL.ROLLBACK similarity index 100% rename from KCLS/sql/browse/rollback/kmain553.metabib.staged_browse_function.SQL.ROLLBACK rename to KCLS/sql/legacy/browse/rollback/kmain553.metabib.staged_browse_function.SQL.ROLLBACK diff --git a/KCLS/sql/browse/rollback/kmain553.metabib_browse_function.SQL.ROLLBACK b/KCLS/sql/legacy/browse/rollback/kmain553.metabib_browse_function.SQL.ROLLBACK similarity index 100% rename from KCLS/sql/browse/rollback/kmain553.metabib_browse_function.SQL.ROLLBACK rename to KCLS/sql/legacy/browse/rollback/kmain553.metabib_browse_function.SQL.ROLLBACK diff --git a/KCLS/sql/export_process/rollback_scripts/001.public.export-generate-ids-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/001.public.export-generate-ids-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/001.public.export-generate-ids-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/001.public.export-generate-ids-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/002.public.export-ids-001-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/002.public.export-ids-001-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/002.public.export-ids-001-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/002.public.export-ids-001-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/003.public.export-ids-998-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/003.public.export-ids-998-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/003.public.export-ids-998-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/003.public.export-ids-998-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/004.public.export-ids-has-copy-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/004.public.export-ids-has-copy-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/004.public.export-ids-has-copy-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/004.public.export-ids-has-copy-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/005.public.export-ids-ldr-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/005.public.export-ids-ldr-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/005.public.export-ids-ldr-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/005.public.export-ids-ldr-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/006.public.export-ids-cat-date-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/006.public.export-ids-cat-date-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/006.public.export-ids-cat-date-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/006.public.export-ids-cat-date-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/007.public.export-ids-086-092-099-rollback.sql b/KCLS/sql/legacy/export_process/rollback_scripts/007.public.export-ids-086-092-099-rollback.sql similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/007.public.export-ids-086-092-099-rollback.sql rename to KCLS/sql/legacy/export_process/rollback_scripts/007.public.export-ids-086-092-099-rollback.sql diff --git a/KCLS/sql/export_process/rollback_scripts/runSh.sh b/KCLS/sql/legacy/export_process/rollback_scripts/runSh.sh similarity index 100% rename from KCLS/sql/export_process/rollback_scripts/runSh.sh rename to KCLS/sql/legacy/export_process/rollback_scripts/runSh.sh diff --git a/KCLS/sql/export_process/runSh.sh b/KCLS/sql/legacy/export_process/runSh.sh similarity index 100% rename from KCLS/sql/export_process/runSh.sh rename to KCLS/sql/legacy/export_process/runSh.sh diff --git a/KCLS/sql/jbas-149/0869.schema.pre-calculate-prox-adjustment.sql b/KCLS/sql/legacy/jbas-149/0869.schema.pre-calculate-prox-adjustment.sql similarity index 100% rename from KCLS/sql/jbas-149/0869.schema.pre-calculate-prox-adjustment.sql rename to KCLS/sql/legacy/jbas-149/0869.schema.pre-calculate-prox-adjustment.sql diff --git a/KCLS/sql/jbas-149/XXXX.schema.clear_hold_copy_map.sql b/KCLS/sql/legacy/jbas-149/XXXX.schema.clear_hold_copy_map.sql similarity index 100% rename from KCLS/sql/jbas-149/XXXX.schema.clear_hold_copy_map.sql rename to KCLS/sql/legacy/jbas-149/XXXX.schema.clear_hold_copy_map.sql diff --git a/KCLS/sql/jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql b/KCLS/sql/legacy/jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql similarity index 100% rename from KCLS/sql/jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql rename to KCLS/sql/legacy/jbas-149/jbas-149-and-jbas-228-combined-upgrade.sql diff --git a/KCLS/sql/jbas-149/jbas-149-and-jbas-228-combined-upgrade.undo.sql b/KCLS/sql/legacy/jbas-149/jbas-149-and-jbas-228-combined-upgrade.undo.sql similarity index 100% rename from KCLS/sql/jbas-149/jbas-149-and-jbas-228-combined-upgrade.undo.sql rename to KCLS/sql/legacy/jbas-149/jbas-149-and-jbas-228-combined-upgrade.undo.sql diff --git a/KCLS/sql/jbas-228/XXXX.schema.fund_debit_invoice_links.sql b/KCLS/sql/legacy/jbas-228/XXXX.schema.fund_debit_invoice_links.sql similarity index 100% rename from KCLS/sql/jbas-228/XXXX.schema.fund_debit_invoice_links.sql rename to KCLS/sql/legacy/jbas-228/XXXX.schema.fund_debit_invoice_links.sql diff --git a/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql b/KCLS/sql/legacy/jbas-408/jbas-408-copy-map-delete-fulfill.sql similarity index 100% rename from KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql rename to KCLS/sql/legacy/jbas-408/jbas-408-copy-map-delete-fulfill.sql diff --git a/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql b/KCLS/sql/legacy/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql similarity index 100% rename from KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql rename to KCLS/sql/legacy/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql diff --git a/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/legacy/jbas-495/01.2.4.1-2.5.7-upgrade.sql similarity index 100% rename from KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql rename to KCLS/sql/legacy/jbas-495/01.2.4.1-2.5.7-upgrade.sql diff --git a/KCLS/sql/jbas-495/02.collection-hq-items-2.5.sql b/KCLS/sql/legacy/jbas-495/02.collection-hq-items-2.5.sql similarity index 100% rename from KCLS/sql/jbas-495/02.collection-hq-items-2.5.sql rename to KCLS/sql/legacy/jbas-495/02.collection-hq-items-2.5.sql diff --git a/KCLS/sql/jbas-495/03.mods-for-2.5.sql b/KCLS/sql/legacy/jbas-495/03.mods-for-2.5.sql similarity index 100% rename from KCLS/sql/jbas-495/03.mods-for-2.5.sql rename to KCLS/sql/legacy/jbas-495/03.mods-for-2.5.sql diff --git a/KCLS/sql/jbas-495/04.KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/legacy/jbas-495/04.KMAIN-1765-reingest-causing-false-browse-headings.sql similarity index 100% rename from KCLS/sql/jbas-495/04.KMAIN-1765-reingest-causing-false-browse-headings.sql rename to KCLS/sql/legacy/jbas-495/04.KMAIN-1765-reingest-causing-false-browse-headings.sql diff --git a/KCLS/sql/kmain-1060/authority-indexing-ingest-or-delete.sql b/KCLS/sql/legacy/kmain-1060/authority-indexing-ingest-or-delete.sql similarity index 100% rename from KCLS/sql/kmain-1060/authority-indexing-ingest-or-delete.sql rename to KCLS/sql/legacy/kmain-1060/authority-indexing-ingest-or-delete.sql diff --git a/KCLS/sql/kmain-1060/authority-simple-heading-set.sql b/KCLS/sql/legacy/kmain-1060/authority-simple-heading-set.sql similarity index 100% rename from KCLS/sql/kmain-1060/authority-simple-heading-set.sql rename to KCLS/sql/legacy/kmain-1060/authority-simple-heading-set.sql diff --git a/KCLS/sql/kmain-1060/metabib-reingest-metabib-field-entries.sql b/KCLS/sql/legacy/kmain-1060/metabib-reingest-metabib-field-entries.sql similarity index 100% rename from KCLS/sql/kmain-1060/metabib-reingest-metabib-field-entries.sql rename to KCLS/sql/legacy/kmain-1060/metabib-reingest-metabib-field-entries.sql diff --git a/KCLS/sql/kmain-1060/rollback_scripts/authority-indexing-ingest-or-delete-rollback.sql b/KCLS/sql/legacy/kmain-1060/rollback_scripts/authority-indexing-ingest-or-delete-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1060/rollback_scripts/authority-indexing-ingest-or-delete-rollback.sql rename to KCLS/sql/legacy/kmain-1060/rollback_scripts/authority-indexing-ingest-or-delete-rollback.sql diff --git a/KCLS/sql/kmain-1060/rollback_scripts/authority-simple-heading-set-rollback.sql b/KCLS/sql/legacy/kmain-1060/rollback_scripts/authority-simple-heading-set-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1060/rollback_scripts/authority-simple-heading-set-rollback.sql rename to KCLS/sql/legacy/kmain-1060/rollback_scripts/authority-simple-heading-set-rollback.sql diff --git a/KCLS/sql/kmain-1060/rollback_scripts/metabib-reingest-metabib-field-entries-rollback.sql b/KCLS/sql/legacy/kmain-1060/rollback_scripts/metabib-reingest-metabib-field-entries-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1060/rollback_scripts/metabib-reingest-metabib-field-entries-rollback.sql rename to KCLS/sql/legacy/kmain-1060/rollback_scripts/metabib-reingest-metabib-field-entries-rollback.sql diff --git a/KCLS/sql/kmain-1074/kmain-1074-indexing_ingest_or_delete.sql b/KCLS/sql/legacy/kmain-1074/kmain-1074-indexing_ingest_or_delete.sql similarity index 100% rename from KCLS/sql/kmain-1074/kmain-1074-indexing_ingest_or_delete.sql rename to KCLS/sql/legacy/kmain-1074/kmain-1074-indexing_ingest_or_delete.sql diff --git a/KCLS/sql/kmain-1074/kmain-1074-rollback.sql b/KCLS/sql/legacy/kmain-1074/kmain-1074-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1074/kmain-1074-rollback.sql rename to KCLS/sql/legacy/kmain-1074/kmain-1074-rollback.sql diff --git a/KCLS/sql/kmain-1102/kmain-1102-authority-reingest-rollback.sql b/KCLS/sql/legacy/kmain-1102/kmain-1102-authority-reingest-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1102/kmain-1102-authority-reingest-rollback.sql rename to KCLS/sql/legacy/kmain-1102/kmain-1102-authority-reingest-rollback.sql diff --git a/KCLS/sql/kmain-1102/kmain-1102-authority-reingest.sql b/KCLS/sql/legacy/kmain-1102/kmain-1102-authority-reingest.sql similarity index 100% rename from KCLS/sql/kmain-1102/kmain-1102-authority-reingest.sql rename to KCLS/sql/legacy/kmain-1102/kmain-1102-authority-reingest.sql diff --git a/KCLS/sql/kmain-1102/kmain-1102-metabib-reingest-rollback.sql b/KCLS/sql/legacy/kmain-1102/kmain-1102-metabib-reingest-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1102/kmain-1102-metabib-reingest-rollback.sql rename to KCLS/sql/legacy/kmain-1102/kmain-1102-metabib-reingest-rollback.sql diff --git a/KCLS/sql/kmain-1102/kmain-1102-metabib-reingest.sql b/KCLS/sql/legacy/kmain-1102/kmain-1102-metabib-reingest.sql similarity index 100% rename from KCLS/sql/kmain-1102/kmain-1102-metabib-reingest.sql rename to KCLS/sql/legacy/kmain-1102/kmain-1102-metabib-reingest.sql diff --git a/KCLS/sql/kmain-1128/authority-get_5xx_heading.sql b/KCLS/sql/legacy/kmain-1128/authority-get_5xx_heading.sql similarity index 100% rename from KCLS/sql/kmain-1128/authority-get_5xx_heading.sql rename to KCLS/sql/legacy/kmain-1128/authority-get_5xx_heading.sql diff --git a/KCLS/sql/kmain-1128/create_and_populate-authority-display_5xx_headings.sql b/KCLS/sql/legacy/kmain-1128/create_and_populate-authority-display_5xx_headings.sql similarity index 100% rename from KCLS/sql/kmain-1128/create_and_populate-authority-display_5xx_headings.sql rename to KCLS/sql/legacy/kmain-1128/create_and_populate-authority-display_5xx_headings.sql diff --git a/KCLS/sql/kmain-1128/metabib-get_browse_author_entry_marc_record.sql b/KCLS/sql/legacy/kmain-1128/metabib-get_browse_author_entry_marc_record.sql similarity index 100% rename from KCLS/sql/kmain-1128/metabib-get_browse_author_entry_marc_record.sql rename to KCLS/sql/legacy/kmain-1128/metabib-get_browse_author_entry_marc_record.sql diff --git a/KCLS/sql/kmain-1128/metabib-get_browse_entry_marc_record.sql b/KCLS/sql/legacy/kmain-1128/metabib-get_browse_entry_marc_record.sql similarity index 100% rename from KCLS/sql/kmain-1128/metabib-get_browse_entry_marc_record.sql rename to KCLS/sql/legacy/kmain-1128/metabib-get_browse_entry_marc_record.sql diff --git a/KCLS/sql/kmain-1128/metabib-get_browse_series_entry_marc_record.sql b/KCLS/sql/legacy/kmain-1128/metabib-get_browse_series_entry_marc_record.sql similarity index 100% rename from KCLS/sql/kmain-1128/metabib-get_browse_series_entry_marc_record.sql rename to KCLS/sql/legacy/kmain-1128/metabib-get_browse_series_entry_marc_record.sql diff --git a/KCLS/sql/kmain-1128/metabib-get_browse_subject_entry_marc_record.sql b/KCLS/sql/legacy/kmain-1128/metabib-get_browse_subject_entry_marc_record.sql similarity index 100% rename from KCLS/sql/kmain-1128/metabib-get_browse_subject_entry_marc_record.sql rename to KCLS/sql/legacy/kmain-1128/metabib-get_browse_subject_entry_marc_record.sql diff --git a/KCLS/sql/kmain-1128/rollback_scripts/authority-get_5xx_heading-rollback.sql b/KCLS/sql/legacy/kmain-1128/rollback_scripts/authority-get_5xx_heading-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1128/rollback_scripts/authority-get_5xx_heading-rollback.sql rename to KCLS/sql/legacy/kmain-1128/rollback_scripts/authority-get_5xx_heading-rollback.sql diff --git a/KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_author_entry_marc_record-rollback.sql b/KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_author_entry_marc_record-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_author_entry_marc_record-rollback.sql rename to KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_author_entry_marc_record-rollback.sql diff --git a/KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_entry_marc_record-rollback.sql b/KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_entry_marc_record-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_entry_marc_record-rollback.sql rename to KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_entry_marc_record-rollback.sql diff --git a/KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_series_entry_marc_record-rollback.sql b/KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_series_entry_marc_record-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_series_entry_marc_record-rollback.sql rename to KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_series_entry_marc_record-rollback.sql diff --git a/KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_subject_entry_marc_record-rollback.sql b/KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_subject_entry_marc_record-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1128/rollback_scripts/metabib-get_browse_subject_entry_marc_record-rollback.sql rename to KCLS/sql/legacy/kmain-1128/rollback_scripts/metabib-get_browse_subject_entry_marc_record-rollback.sql diff --git a/KCLS/sql/kmain-1199/kmain-1199-rollback.sql b/KCLS/sql/legacy/kmain-1199/kmain-1199-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1199/kmain-1199-rollback.sql rename to KCLS/sql/legacy/kmain-1199/kmain-1199-rollback.sql diff --git a/KCLS/sql/kmain-1199/kmain-1199.sql b/KCLS/sql/legacy/kmain-1199/kmain-1199.sql similarity index 100% rename from KCLS/sql/kmain-1199/kmain-1199.sql rename to KCLS/sql/legacy/kmain-1199/kmain-1199.sql diff --git a/KCLS/sql/kmain-1204/update-authority-control-set-bib-field-metabib-field-map-rollback.sql b/KCLS/sql/legacy/kmain-1204/update-authority-control-set-bib-field-metabib-field-map-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1204/update-authority-control-set-bib-field-metabib-field-map-rollback.sql rename to KCLS/sql/legacy/kmain-1204/update-authority-control-set-bib-field-metabib-field-map-rollback.sql diff --git a/KCLS/sql/kmain-1204/update-authority-control-set-bib-field-metabib-field-map.sql b/KCLS/sql/legacy/kmain-1204/update-authority-control-set-bib-field-metabib-field-map.sql similarity index 100% rename from KCLS/sql/kmain-1204/update-authority-control-set-bib-field-metabib-field-map.sql rename to KCLS/sql/legacy/kmain-1204/update-authority-control-set-bib-field-metabib-field-map.sql diff --git a/KCLS/sql/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry-rollback.sql b/KCLS/sql/legacy/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry-rollback.sql rename to KCLS/sql/legacy/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry-rollback.sql diff --git a/KCLS/sql/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry.sql b/KCLS/sql/legacy/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry.sql similarity index 100% rename from KCLS/sql/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry.sql rename to KCLS/sql/legacy/kmain-1264/kmain-1264-add-export-and-import-biblio-record-entry.sql diff --git a/KCLS/sql/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches-rollback.sql b/KCLS/sql/legacy/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches-rollback.sql rename to KCLS/sql/legacy/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches-rollback.sql diff --git a/KCLS/sql/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches.sql b/KCLS/sql/legacy/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches.sql similarity index 100% rename from KCLS/sql/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches.sql rename to KCLS/sql/legacy/kmain-1271/kmain-1271-case-sensitive-browse-call-number-searches.sql diff --git a/KCLS/sql/kmain-1312/create_metabib_bib_export_data.sql b/KCLS/sql/legacy/kmain-1312/create_metabib_bib_export_data.sql similarity index 100% rename from KCLS/sql/kmain-1312/create_metabib_bib_export_data.sql rename to KCLS/sql/legacy/kmain-1312/create_metabib_bib_export_data.sql diff --git a/KCLS/sql/kmain-1312/create_metabib_bib_export_data_rollback.sql b/KCLS/sql/legacy/kmain-1312/create_metabib_bib_export_data_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1312/create_metabib_bib_export_data_rollback.sql rename to KCLS/sql/legacy/kmain-1312/create_metabib_bib_export_data_rollback.sql diff --git a/KCLS/sql/kmain-1312/metabib_set_export_date.sql b/KCLS/sql/legacy/kmain-1312/metabib_set_export_date.sql similarity index 100% rename from KCLS/sql/kmain-1312/metabib_set_export_date.sql rename to KCLS/sql/legacy/kmain-1312/metabib_set_export_date.sql diff --git a/KCLS/sql/kmain-1312/metabib_set_export_date_rollback.sql b/KCLS/sql/legacy/kmain-1312/metabib_set_export_date_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1312/metabib_set_export_date_rollback.sql rename to KCLS/sql/legacy/kmain-1312/metabib_set_export_date_rollback.sql diff --git a/KCLS/sql/kmain-1314/kmain-1314-rollback.sql b/KCLS/sql/legacy/kmain-1314/kmain-1314-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1314/kmain-1314-rollback.sql rename to KCLS/sql/legacy/kmain-1314/kmain-1314-rollback.sql diff --git a/KCLS/sql/kmain-1314/kmain-1314.sql b/KCLS/sql/legacy/kmain-1314/kmain-1314.sql similarity index 100% rename from KCLS/sql/kmain-1314/kmain-1314.sql rename to KCLS/sql/legacy/kmain-1314/kmain-1314.sql diff --git a/KCLS/sql/kmain-1324/metabib-bib-export-data-rollback.sql b/KCLS/sql/legacy/kmain-1324/metabib-bib-export-data-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1324/metabib-bib-export-data-rollback.sql rename to KCLS/sql/legacy/kmain-1324/metabib-bib-export-data-rollback.sql diff --git a/KCLS/sql/kmain-1324/metabib-bib-export-data.sql b/KCLS/sql/legacy/kmain-1324/metabib-bib-export-data.sql similarity index 100% rename from KCLS/sql/kmain-1324/metabib-bib-export-data.sql rename to KCLS/sql/legacy/kmain-1324/metabib-bib-export-data.sql diff --git a/KCLS/sql/kmain-1324/metabib-set-import-date-rollback.sql b/KCLS/sql/legacy/kmain-1324/metabib-set-import-date-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1324/metabib-set-import-date-rollback.sql rename to KCLS/sql/legacy/kmain-1324/metabib-set-import-date-rollback.sql diff --git a/KCLS/sql/kmain-1324/metabib-set-import-date.sql b/KCLS/sql/legacy/kmain-1324/metabib-set-import-date.sql similarity index 100% rename from KCLS/sql/kmain-1324/metabib-set-import-date.sql rename to KCLS/sql/legacy/kmain-1324/metabib-set-import-date.sql diff --git a/KCLS/sql/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql b/KCLS/sql/legacy/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sql/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql rename to KCLS/sql/legacy/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268.sql diff --git a/KCLS/sql/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268_rollback.sql b/KCLS/sql/legacy/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268_rollback.sql rename to KCLS/sql/legacy/kmain-1448/KMAIN_1448_Bug_from_KMAIN_268_rollback.sql diff --git a/KCLS/sql/kmain-1521/authority_heading_changed.sql b/KCLS/sql/legacy/kmain-1521/authority_heading_changed.sql similarity index 100% rename from KCLS/sql/kmain-1521/authority_heading_changed.sql rename to KCLS/sql/legacy/kmain-1521/authority_heading_changed.sql diff --git a/KCLS/sql/kmain-1521/authority_heading_changed_rollback.sql b/KCLS/sql/legacy/kmain-1521/authority_heading_changed_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1521/authority_heading_changed_rollback.sql rename to KCLS/sql/legacy/kmain-1521/authority_heading_changed_rollback.sql diff --git a/KCLS/sql/kmain-1521/authority_indexing_ingest_or_delete.sql b/KCLS/sql/legacy/kmain-1521/authority_indexing_ingest_or_delete.sql similarity index 100% rename from KCLS/sql/kmain-1521/authority_indexing_ingest_or_delete.sql rename to KCLS/sql/legacy/kmain-1521/authority_indexing_ingest_or_delete.sql diff --git a/KCLS/sql/kmain-1521/authority_indexing_ingest_or_delete_rollback.sql b/KCLS/sql/legacy/kmain-1521/authority_indexing_ingest_or_delete_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1521/authority_indexing_ingest_or_delete_rollback.sql rename to KCLS/sql/legacy/kmain-1521/authority_indexing_ingest_or_delete_rollback.sql diff --git a/KCLS/sql/kmain-1528/kmain-1528-rollback.sql b/KCLS/sql/legacy/kmain-1528/kmain-1528-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1528/kmain-1528-rollback.sql rename to KCLS/sql/legacy/kmain-1528/kmain-1528-rollback.sql diff --git a/KCLS/sql/kmain-1528/kmain-1528.sql b/KCLS/sql/legacy/kmain-1528/kmain-1528.sql similarity index 100% rename from KCLS/sql/kmain-1528/kmain-1528.sql rename to KCLS/sql/legacy/kmain-1528/kmain-1528.sql diff --git a/KCLS/sql/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql b/KCLS/sql/legacy/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sql/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql rename to KCLS/sql/legacy/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268.sql diff --git a/KCLS/sql/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268_rollback.sql b/KCLS/sql/legacy/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268_rollback.sql similarity index 100% rename from KCLS/sql/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268_rollback.sql rename to KCLS/sql/legacy/kmain-1729/KMAIN_1729_Bug_from_KMAIN_268_rollback.sql diff --git a/KCLS/sql/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings-rollback.sql b/KCLS/sql/legacy/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings-rollback.sql similarity index 100% rename from KCLS/sql/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings-rollback.sql rename to KCLS/sql/legacy/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings-rollback.sql diff --git a/KCLS/sql/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/legacy/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings.sql similarity index 100% rename from KCLS/sql/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings.sql rename to KCLS/sql/legacy/kmain-1765/KMAIN-1765-reingest-causing-false-browse-headings.sql diff --git a/KCLS/sql/kmain-223/kmain-223-auth-match.sql b/KCLS/sql/legacy/kmain-223/kmain-223-auth-match.sql similarity index 100% rename from KCLS/sql/kmain-223/kmain-223-auth-match.sql rename to KCLS/sql/legacy/kmain-223/kmain-223-auth-match.sql diff --git a/KCLS/sql/kmain-223/kmain-223-rollback.sql b/KCLS/sql/legacy/kmain-223/kmain-223-rollback.sql similarity index 100% rename from KCLS/sql/kmain-223/kmain-223-rollback.sql rename to KCLS/sql/legacy/kmain-223/kmain-223-rollback.sql diff --git a/KCLS/sql/kmain-268/kmain-268-rollback.sql b/KCLS/sql/legacy/kmain-268/kmain-268-rollback.sql similarity index 100% rename from KCLS/sql/kmain-268/kmain-268-rollback.sql rename to KCLS/sql/legacy/kmain-268/kmain-268-rollback.sql diff --git a/KCLS/sql/kmain-268/kmain-268.sql b/KCLS/sql/legacy/kmain-268/kmain-268.sql similarity index 100% rename from KCLS/sql/kmain-268/kmain-268.sql rename to KCLS/sql/legacy/kmain-268/kmain-268.sql diff --git a/KCLS/sql/kmain-310/kclsupgrad34.rollback.sql b/KCLS/sql/legacy/kmain-310/kclsupgrad34.rollback.sql similarity index 100% rename from KCLS/sql/kmain-310/kclsupgrad34.rollback.sql rename to KCLS/sql/legacy/kmain-310/kclsupgrad34.rollback.sql diff --git a/KCLS/sql/kmain-310/kclsupgrad34.sql b/KCLS/sql/legacy/kmain-310/kclsupgrad34.sql similarity index 100% rename from KCLS/sql/kmain-310/kclsupgrad34.sql rename to KCLS/sql/legacy/kmain-310/kclsupgrad34.sql diff --git a/KCLS/sql/kmain-385-standard-default-messages.sql b/KCLS/sql/legacy/kmain-385-standard-default-messages.sql similarity index 100% rename from KCLS/sql/kmain-385-standard-default-messages.sql rename to KCLS/sql/legacy/kmain-385-standard-default-messages.sql diff --git a/KCLS/sql/kmain-392/kmain392.sql b/KCLS/sql/legacy/kmain-392/kmain392.sql similarity index 100% rename from KCLS/sql/kmain-392/kmain392.sql rename to KCLS/sql/legacy/kmain-392/kmain392.sql diff --git a/KCLS/sql/kmain-695/kmain-695-rollback.sql b/KCLS/sql/legacy/kmain-695/kmain-695-rollback.sql similarity index 100% rename from KCLS/sql/kmain-695/kmain-695-rollback.sql rename to KCLS/sql/legacy/kmain-695/kmain-695-rollback.sql diff --git a/KCLS/sql/kmain-695/kmain-695.sql b/KCLS/sql/legacy/kmain-695/kmain-695.sql similarity index 100% rename from KCLS/sql/kmain-695/kmain-695.sql rename to KCLS/sql/legacy/kmain-695/kmain-695.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-author-authority-refs-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-author-authority-refs-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-author-authority-refs-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-author-authority-refs-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-author-bib-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-author-bib-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-author-bib-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-author-bib-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-series-authority-refs-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-series-authority-refs-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-series-authority-refs-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-series-authority-refs-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-series-bib-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-series-bib-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-series-bib-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-series-bib-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-subject-authority-refs-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-subject-authority-refs-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-subject-authority-refs-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-subject-authority-refs-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-subject-bib-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-subject-bib-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-subject-bib-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-subject-bib-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-text.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-text.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-text.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-text.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-title-authority-refs-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-title-authority-refs-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-title-authority-refs-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-title-authority-refs-pivot.sql diff --git a/KCLS/sql/kmain-762/metabib-browse-title-bib-pivot.sql b/KCLS/sql/legacy/kmain-762/metabib-browse-title-bib-pivot.sql similarity index 100% rename from KCLS/sql/kmain-762/metabib-browse-title-bib-pivot.sql rename to KCLS/sql/legacy/kmain-762/metabib-browse-title-bib-pivot.sql diff --git a/KCLS/sql/kmain-762/public-replace-ampersand.sql b/KCLS/sql/legacy/kmain-762/public-replace-ampersand.sql similarity index 100% rename from KCLS/sql/kmain-762/public-replace-ampersand.sql rename to KCLS/sql/legacy/kmain-762/public-replace-ampersand.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-author-authority-refs-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-author-authority-refs-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-author-authority-refs-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-author-authority-refs-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-author-bib-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-author-bib-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-author-bib-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-author-bib-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-series-authority-refs-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-series-authority-refs-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-series-authority-refs-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-series-authority-refs-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-series-bib-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-series-bib-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-series-bib-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-series-bib-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-subject-authority-refs-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-subject-authority-refs-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-subject-authority-refs-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-subject-authority-refs-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-subject-bib-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-subject-bib-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-subject-bib-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-subject-bib-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-text-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-text-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-text-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-text-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-title-authority-refs-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-title-authority-refs-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-title-authority-refs-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-title-authority-refs-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/metabib-browse-title-bib-pivot-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-title-bib-pivot-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/metabib-browse-title-bib-pivot-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/metabib-browse-title-bib-pivot-rollback.sql diff --git a/KCLS/sql/kmain-762/rollback_scripts/public-replace-ampersand-rollback.sql b/KCLS/sql/legacy/kmain-762/rollback_scripts/public-replace-ampersand-rollback.sql similarity index 100% rename from KCLS/sql/kmain-762/rollback_scripts/public-replace-ampersand-rollback.sql rename to KCLS/sql/legacy/kmain-762/rollback_scripts/public-replace-ampersand-rollback.sql diff --git a/KCLS/sql/kmain-81-upgrad-98_usr_activity_types.sql b/KCLS/sql/legacy/kmain-81-upgrad-98_usr_activity_types.sql similarity index 100% rename from KCLS/sql/kmain-81-upgrad-98_usr_activity_types.sql rename to KCLS/sql/legacy/kmain-81-upgrad-98_usr_activity_types.sql diff --git a/KCLS/sql/kmain-81-upgrad-98_usr_activity_types_rollback.sql b/KCLS/sql/legacy/kmain-81-upgrad-98_usr_activity_types_rollback.sql similarity index 100% rename from KCLS/sql/kmain-81-upgrad-98_usr_activity_types_rollback.sql rename to KCLS/sql/legacy/kmain-81-upgrad-98_usr_activity_types_rollback.sql diff --git a/KCLS/sql/kmain-903/kmain-903-rollback.sql b/KCLS/sql/legacy/kmain-903/kmain-903-rollback.sql similarity index 100% rename from KCLS/sql/kmain-903/kmain-903-rollback.sql rename to KCLS/sql/legacy/kmain-903/kmain-903-rollback.sql diff --git a/KCLS/sql/kmain-903/kmain-903.sql b/KCLS/sql/legacy/kmain-903/kmain-903.sql similarity index 100% rename from KCLS/sql/kmain-903/kmain-903.sql rename to KCLS/sql/legacy/kmain-903/kmain-903.sql diff --git a/KCLS/sql/kmain-972/public.export-generate-ids.sql b/KCLS/sql/legacy/kmain-972/public.export-generate-ids.sql similarity index 100% rename from KCLS/sql/kmain-972/public.export-generate-ids.sql rename to KCLS/sql/legacy/kmain-972/public.export-generate-ids.sql diff --git a/KCLS/sql/kmain-972/rollback_scripts/public.export-generate-ids-params-rollback.sql b/KCLS/sql/legacy/kmain-972/rollback_scripts/public.export-generate-ids-params-rollback.sql similarity index 100% rename from KCLS/sql/kmain-972/rollback_scripts/public.export-generate-ids-params-rollback.sql rename to KCLS/sql/legacy/kmain-972/rollback_scripts/public.export-generate-ids-params-rollback.sql diff --git a/KCLS/sql/kmain-976/kmain-976-constraints-rollback.sql b/KCLS/sql/legacy/kmain-976/kmain-976-constraints-rollback.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-constraints-rollback.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-constraints-rollback.sql diff --git a/KCLS/sql/kmain-976/kmain-976-constraints.sql b/KCLS/sql/legacy/kmain-976/kmain-976-constraints.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-constraints.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-constraints.sql diff --git a/KCLS/sql/kmain-976/kmain-976-indexing_ingest_or_delete-rollback.sql b/KCLS/sql/legacy/kmain-976/kmain-976-indexing_ingest_or_delete-rollback.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-indexing_ingest_or_delete-rollback.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-indexing_ingest_or_delete-rollback.sql diff --git a/KCLS/sql/kmain-976/kmain-976-indexing_ingest_or_delete.sql b/KCLS/sql/legacy/kmain-976/kmain-976-indexing_ingest_or_delete.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-indexing_ingest_or_delete.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-indexing_ingest_or_delete.sql diff --git a/KCLS/sql/kmain-976/kmain-976-reingest_metabib_field_entries-rollback.sql b/KCLS/sql/legacy/kmain-976/kmain-976-reingest_metabib_field_entries-rollback.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-reingest_metabib_field_entries-rollback.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-reingest_metabib_field_entries-rollback.sql diff --git a/KCLS/sql/kmain-976/kmain-976-reingest_metabib_field_entries.sql b/KCLS/sql/legacy/kmain-976/kmain-976-reingest_metabib_field_entries.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-reingest_metabib_field_entries.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-reingest_metabib_field_entries.sql diff --git a/KCLS/sql/kmain-976/kmain-976-upgrade-prep.sql b/KCLS/sql/legacy/kmain-976/kmain-976-upgrade-prep.sql similarity index 100% rename from KCLS/sql/kmain-976/kmain-976-upgrade-prep.sql rename to KCLS/sql/legacy/kmain-976/kmain-976-upgrade-prep.sql diff --git a/KCLS/sql/kmain221/0815.schema.config-metabib-interauthority.sql b/KCLS/sql/legacy/kmain221/0815.schema.config-metabib-interauthority.sql similarity index 100% rename from KCLS/sql/kmain221/0815.schema.config-metabib-interauthority.sql rename to KCLS/sql/legacy/kmain221/0815.schema.config-metabib-interauthority.sql diff --git a/KCLS/sql/kmain221/0816.schema.bib-auth-browse.sql b/KCLS/sql/legacy/kmain221/0816.schema.bib-auth-browse.sql similarity index 100% rename from KCLS/sql/kmain221/0816.schema.bib-auth-browse.sql rename to KCLS/sql/legacy/kmain221/0816.schema.bib-auth-browse.sql diff --git a/KCLS/sql/kmain221/0821.function.browse-normalize-timing.sql b/KCLS/sql/legacy/kmain221/0821.function.browse-normalize-timing.sql similarity index 100% rename from KCLS/sql/kmain221/0821.function.browse-normalize-timing.sql rename to KCLS/sql/legacy/kmain221/0821.function.browse-normalize-timing.sql diff --git a/KCLS/sql/kmain221/0837.schema.browse-auth-linking.plus-joiner.sql b/KCLS/sql/legacy/kmain221/0837.schema.browse-auth-linking.plus-joiner.sql similarity index 100% rename from KCLS/sql/kmain221/0837.schema.browse-auth-linking.plus-joiner.sql rename to KCLS/sql/legacy/kmain221/0837.schema.browse-auth-linking.plus-joiner.sql diff --git a/KCLS/sql/kmain221/0839.data.alternative-title-indexing.sql b/KCLS/sql/legacy/kmain221/0839.data.alternative-title-indexing.sql similarity index 100% rename from KCLS/sql/kmain221/0839.data.alternative-title-indexing.sql rename to KCLS/sql/legacy/kmain221/0839.data.alternative-title-indexing.sql diff --git a/KCLS/sql/kmain221/0844.data.better_mods_for_browse_etc.sql b/KCLS/sql/legacy/kmain221/0844.data.better_mods_for_browse_etc.sql similarity index 100% rename from KCLS/sql/kmain221/0844.data.better_mods_for_browse_etc.sql rename to KCLS/sql/legacy/kmain221/0844.data.better_mods_for_browse_etc.sql diff --git a/KCLS/sql/kmain221/0845.schema.browse_pivots_stable.sql b/KCLS/sql/legacy/kmain221/0845.schema.browse_pivots_stable.sql similarity index 100% rename from KCLS/sql/kmain221/0845.schema.browse_pivots_stable.sql rename to KCLS/sql/legacy/kmain221/0845.schema.browse_pivots_stable.sql diff --git a/KCLS/sql/kmain221/0846.function.vand-add_field.sql b/KCLS/sql/legacy/kmain221/0846.function.vand-add_field.sql similarity index 100% rename from KCLS/sql/kmain221/0846.function.vand-add_field.sql rename to KCLS/sql/legacy/kmain221/0846.function.vand-add_field.sql diff --git a/KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql b/KCLS/sql/legacy/kmain228/add_cataloging_date_column_to_bre.sql similarity index 100% rename from KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql rename to KCLS/sql/legacy/kmain228/add_cataloging_date_column_to_bre.sql diff --git a/KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql b/KCLS/sql/legacy/kmain228/rollback-add_cataloging_date_column_to_bre.sql similarity index 100% rename from KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql rename to KCLS/sql/legacy/kmain228/rollback-add_cataloging_date_column_to_bre.sql diff --git a/KCLS/sql/kmig-147.sql b/KCLS/sql/legacy/kmig-147.sql similarity index 100% rename from KCLS/sql/kmig-147.sql rename to KCLS/sql/legacy/kmig-147.sql diff --git a/KCLS/sql/kmig-187.sql b/KCLS/sql/legacy/kmig-187.sql similarity index 100% rename from KCLS/sql/kmig-187.sql rename to KCLS/sql/legacy/kmig-187.sql diff --git a/KCLS/sql/kmig57-default_search_location_trigger.sql b/KCLS/sql/legacy/kmig57-default_search_location_trigger.sql similarity index 100% rename from KCLS/sql/kmig57-default_search_location_trigger.sql rename to KCLS/sql/legacy/kmig57-default_search_location_trigger.sql diff --git a/KCLS/sql/sample-data/deploy/no_op_initialization.sql b/KCLS/sql/sample-data/deploy/no_op_initialization.sql new file mode 100644 index 0000000000..e15544ecf2 --- /dev/null +++ b/KCLS/sql/sample-data/deploy/no_op_initialization.sql @@ -0,0 +1,8 @@ +-- Deploy kcls-evergreen-data:no_op_initialization to pg +-- requires: kcls-evergreen:KMAIN-1765-reingest-causing-false-browse-headings + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/KCLS/sql/dev-data/kcls-dev-aous.sql b/KCLS/sql/sample-data/exports/kcls-dev-aous.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-aous.sql rename to KCLS/sql/sample-data/exports/kcls-dev-aous.sql diff --git a/KCLS/sql/dev-data/kcls-dev-auths.sql b/KCLS/sql/sample-data/exports/kcls-dev-auths.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-auths.sql rename to KCLS/sql/sample-data/exports/kcls-dev-auths.sql diff --git a/KCLS/sql/dev-data/kcls-dev-cns.sql b/KCLS/sql/sample-data/exports/kcls-dev-cns.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-cns.sql rename to KCLS/sql/sample-data/exports/kcls-dev-cns.sql diff --git a/KCLS/sql/dev-data/kcls-dev-copies.sql b/KCLS/sql/sample-data/exports/kcls-dev-copies.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-copies.sql rename to KCLS/sql/sample-data/exports/kcls-dev-copies.sql diff --git a/KCLS/sql/dev-data/kcls-dev-db-export.sql b/KCLS/sql/sample-data/exports/kcls-dev-db-export.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-db-export.sql rename to KCLS/sql/sample-data/exports/kcls-dev-db-export.sql diff --git a/KCLS/sql/dev-data/kcls-dev-db-extras.sql b/KCLS/sql/sample-data/exports/kcls-dev-db-extras.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-db-extras.sql rename to KCLS/sql/sample-data/exports/kcls-dev-db-extras.sql diff --git a/KCLS/sql/dev-data/kcls-dev-recs.sql b/KCLS/sql/sample-data/exports/kcls-dev-recs.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-recs.sql rename to KCLS/sql/sample-data/exports/kcls-dev-recs.sql diff --git a/KCLS/sql/dev-data/kcls-dev-users.sql b/KCLS/sql/sample-data/exports/kcls-dev-users.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-users.sql rename to KCLS/sql/sample-data/exports/kcls-dev-users.sql diff --git a/KCLS/sql/dev-data/kcls-dev-xacts.sql b/KCLS/sql/sample-data/exports/kcls-dev-xacts.sql similarity index 100% rename from KCLS/sql/dev-data/kcls-dev-xacts.sql rename to KCLS/sql/sample-data/exports/kcls-dev-xacts.sql diff --git a/KCLS/sql/sample-data/revert/no_op_initialization.sql b/KCLS/sql/sample-data/revert/no_op_initialization.sql new file mode 100644 index 0000000000..31d9b3fdfb --- /dev/null +++ b/KCLS/sql/sample-data/revert/no_op_initialization.sql @@ -0,0 +1,7 @@ +-- Revert kcls-evergreen-data:no_op_initialization from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/KCLS/sqitch/sqitch.conf b/KCLS/sql/sample-data/sqitch.conf similarity index 100% rename from KCLS/sqitch/sqitch.conf rename to KCLS/sql/sample-data/sqitch.conf diff --git a/KCLS/sql/sample-data/sqitch.plan b/KCLS/sql/sample-data/sqitch.plan new file mode 100644 index 0000000000..291d288938 --- /dev/null +++ b/KCLS/sql/sample-data/sqitch.plan @@ -0,0 +1,5 @@ +%syntax-version=1.0.0 +%project=kcls-evergreen-data + + +no_op_initialization [kcls-evergreen:KMAIN-1765-reingest-causing-false-browse-headings] 2015-08-13T16:51:28Z Bill Erickson # Start with a no-op target so other can depend on it diff --git a/KCLS/sql/dev-data/create-dev-db.sh b/KCLS/sql/sample-data/tools/create-dev-db.sh similarity index 100% rename from KCLS/sql/dev-data/create-dev-db.sh rename to KCLS/sql/sample-data/tools/create-dev-db.sh diff --git a/KCLS/sql/dev-data/tools/export-dev-data.sh b/KCLS/sql/sample-data/tools/export-dev-data.sh similarity index 100% rename from KCLS/sql/dev-data/tools/export-dev-data.sh rename to KCLS/sql/sample-data/tools/export-dev-data.sh diff --git a/KCLS/sql/dev-data/tools/export-tables.txt b/KCLS/sql/sample-data/tools/export-tables.txt similarity index 100% rename from KCLS/sql/dev-data/tools/export-tables.txt rename to KCLS/sql/sample-data/tools/export-tables.txt diff --git a/KCLS/sql/dev-data/tools/kcls-dev-rec-ids.txt b/KCLS/sql/sample-data/tools/kcls-dev-rec-ids.txt similarity index 100% rename from KCLS/sql/dev-data/tools/kcls-dev-rec-ids.txt rename to KCLS/sql/sample-data/tools/kcls-dev-rec-ids.txt diff --git a/KCLS/sql/sample-data/verify/no_op_initialization.sql b/KCLS/sql/sample-data/verify/no_op_initialization.sql new file mode 100644 index 0000000000..02ba21d61d --- /dev/null +++ b/KCLS/sql/sample-data/verify/no_op_initialization.sql @@ -0,0 +1,7 @@ +-- Verify kcls-evergreen-data:no_op_initialization on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/KCLS/sqitch/deploy/01.2.4.1-2.5.7-deps.sql b/KCLS/sql/schema/deploy/01.2.4.1-2.5.7-deps.sql similarity index 100% rename from KCLS/sqitch/deploy/01.2.4.1-2.5.7-deps.sql rename to KCLS/sql/schema/deploy/01.2.4.1-2.5.7-deps.sql diff --git a/KCLS/sqitch/deploy/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/schema/deploy/01.2.4.1-2.5.7-upgrade.sql similarity index 100% rename from KCLS/sqitch/deploy/01.2.4.1-2.5.7-upgrade.sql rename to KCLS/sql/schema/deploy/01.2.4.1-2.5.7-upgrade.sql diff --git a/KCLS/sqitch/deploy/02.collection-hq-items-2.5.sql b/KCLS/sql/schema/deploy/02.collection-hq-items-2.5.sql similarity index 100% rename from KCLS/sqitch/deploy/02.collection-hq-items-2.5.sql rename to KCLS/sql/schema/deploy/02.collection-hq-items-2.5.sql diff --git a/KCLS/sqitch/deploy/KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/schema/deploy/KMAIN-1765-reingest-causing-false-browse-headings.sql similarity index 100% rename from KCLS/sqitch/deploy/KMAIN-1765-reingest-causing-false-browse-headings.sql rename to KCLS/sql/schema/deploy/KMAIN-1765-reingest-causing-false-browse-headings.sql diff --git a/KCLS/sqitch/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/deploy/KMAIN_1448_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/deploy/KMAIN_1729_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/deploy/kcls-2.4-base-prod.sql b/KCLS/sql/schema/deploy/kcls-2.4-base-prod.sql similarity index 100% rename from KCLS/sqitch/deploy/kcls-2.4-base-prod.sql rename to KCLS/sql/schema/deploy/kcls-2.4-base-prod.sql diff --git a/KCLS/sqitch/revert/01.2.4.1-2.5.7-deps.sql b/KCLS/sql/schema/revert/01.2.4.1-2.5.7-deps.sql similarity index 100% rename from KCLS/sqitch/revert/01.2.4.1-2.5.7-deps.sql rename to KCLS/sql/schema/revert/01.2.4.1-2.5.7-deps.sql diff --git a/KCLS/sqitch/revert/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/schema/revert/01.2.4.1-2.5.7-upgrade.sql similarity index 100% rename from KCLS/sqitch/revert/01.2.4.1-2.5.7-upgrade.sql rename to KCLS/sql/schema/revert/01.2.4.1-2.5.7-upgrade.sql diff --git a/KCLS/sqitch/revert/02.collection-hq-items-2.5.sql b/KCLS/sql/schema/revert/02.collection-hq-items-2.5.sql similarity index 100% rename from KCLS/sqitch/revert/02.collection-hq-items-2.5.sql rename to KCLS/sql/schema/revert/02.collection-hq-items-2.5.sql diff --git a/KCLS/sqitch/revert/KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/schema/revert/KMAIN-1765-reingest-causing-false-browse-headings.sql similarity index 100% rename from KCLS/sqitch/revert/KMAIN-1765-reingest-causing-false-browse-headings.sql rename to KCLS/sql/schema/revert/KMAIN-1765-reingest-causing-false-browse-headings.sql diff --git a/KCLS/sqitch/revert/KMAIN_1448_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/revert/KMAIN_1448_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/revert/KMAIN_1448_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/revert/KMAIN_1448_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/revert/KMAIN_1729_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/revert/KMAIN_1729_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/revert/KMAIN_1729_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/revert/KMAIN_1729_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/revert/kcls-2.4-base-prod.sql b/KCLS/sql/schema/revert/kcls-2.4-base-prod.sql similarity index 100% rename from KCLS/sqitch/revert/kcls-2.4-base-prod.sql rename to KCLS/sql/schema/revert/kcls-2.4-base-prod.sql diff --git a/KCLS/sql/schema/sqitch.conf b/KCLS/sql/schema/sqitch.conf new file mode 100644 index 0000000000..35f49d7fef --- /dev/null +++ b/KCLS/sql/schema/sqitch.conf @@ -0,0 +1,16 @@ +[core] + engine = pg + # plan_file = sqitch.plan + # top_dir = . + # deploy_dir = deploy + # revert_dir = revert + # verify_dir = verify + # extension = sql +[target "evergreen"] + uri = db:pg:evergreen +[engine "pg"] + target = evergreen +[deploy] + verify = true +[rebase] + verify = true diff --git a/KCLS/sqitch/sqitch.plan b/KCLS/sql/schema/sqitch.plan similarity index 100% rename from KCLS/sqitch/sqitch.plan rename to KCLS/sql/schema/sqitch.plan diff --git a/KCLS/sqitch/verify/01.2.4.1-2.5.7-deps.sql b/KCLS/sql/schema/verify/01.2.4.1-2.5.7-deps.sql similarity index 100% rename from KCLS/sqitch/verify/01.2.4.1-2.5.7-deps.sql rename to KCLS/sql/schema/verify/01.2.4.1-2.5.7-deps.sql diff --git a/KCLS/sqitch/verify/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql similarity index 100% rename from KCLS/sqitch/verify/01.2.4.1-2.5.7-upgrade.sql rename to KCLS/sql/schema/verify/01.2.4.1-2.5.7-upgrade.sql diff --git a/KCLS/sqitch/verify/02.collection-hq-items-2.5.sql b/KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql similarity index 100% rename from KCLS/sqitch/verify/02.collection-hq-items-2.5.sql rename to KCLS/sql/schema/verify/02.collection-hq-items-2.5.sql diff --git a/KCLS/sqitch/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql b/KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql similarity index 100% rename from KCLS/sqitch/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql rename to KCLS/sql/schema/verify/KMAIN-1765-reingest-causing-false-browse-headings.sql diff --git a/KCLS/sqitch/verify/KMAIN_1448_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/verify/KMAIN_1448_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/verify/KMAIN_1448_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/verify/KMAIN_1729_Bug_from_KMAIN_268.sql b/KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql similarity index 100% rename from KCLS/sqitch/verify/KMAIN_1729_Bug_from_KMAIN_268.sql rename to KCLS/sql/schema/verify/KMAIN_1729_Bug_from_KMAIN_268.sql diff --git a/KCLS/sqitch/verify/kcls-2.4-base-prod.sql b/KCLS/sql/schema/verify/kcls-2.4-base-prod.sql similarity index 100% rename from KCLS/sqitch/verify/kcls-2.4-base-prod.sql rename to KCLS/sql/schema/verify/kcls-2.4-base-prod.sql -- 2.11.0