alter_src_rec.sql

DROP TABLE IF EXISTS folio_source_record.records_lb;

CREATE TABLE folio_source_record.records_lb AS
    SELECT __id,
	record_id::uuid AS id,
	'ACTUAL' AS state,
	parsed_record__id::uuid AS matched_id,
	external_ids_holder__instance_hrid AS external_hrid,
	external_ids_holder__instance_id::uuid AS instance_id
    FROM folio_source_record.records__t;

CREATE INDEX ON folio_source_record.records_lb (id);

CREATE INDEX ON folio_source_record.records_lb (state);

DROP TABLE IF EXISTS folio_source_record.marc_records_lb;

CREATE TABLE folio_source_record.marc_records_lb AS
    SELECT __id,
           record_id::uuid AS id,
           parsed_record__content #>> '{}' AS content
    FROM folio_source_record.records__t;

CREATE INDEX ON folio_source_record.marc_records_lb (id);

DROP TABLE IF EXISTS folio_source_record.records;
DROP TABLE IF EXISTS folio_source_record.marctab;