Skip to end of banner
Go to start of banner

Adding a new member tenant to consortium. mod-entities-links scope

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

1. Copy authority table from central tenant to newly created member tenant

insert into {member_tenant_id}_mod_entities_links.authority(
	SELECT id, natural_id, source_file_id, 'CONSORTIUM-' || source, heading, heading_type, _version, subject_heading_code, sft_headings, saft_headings, identifiers, notes, deleted, created_date, updated_date, created_by_user_id, updated_by_user_id
	FROM {central_tenant_id}_mod_entities_links.authority);


2. Copy authority_data_stat table from central tenant to newly created member tenant

insert into {member_tenant_id}_mod_entities_links.authority_data_stat(
	SELECT id, authority_id, action::text::{member_tenant_id}_mod_entities_links.authoritydatastataction, authority_natural_id_old, authority_natural_id_new, heading_old, heading_new, heading_type_old, heading_type_new, authority_source_file_old, authority_source_file_new, lb_total, lb_updated, lb_failed, status::text::{member_tenant_id}_mod_entities_links.authoritydatastatstatus, fail_cause, started_by_user_id, started_at, completed_at, updated_at
	FROM {central_tenant_id}_mod_entities_links.authority_data_stat);

Notice 2 {member_tenant_id} placeholders in select

  • No labels