Notice {member_tenant_id}, {central_tenant_id} placeholders in insert/select queries.
1. Copy authority table from central tenant to newly created member tenant
...
| Code Block |
|---|
|
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); |
...
Additions from Quesnelia (R1 2024) release:
3. Copy authority_source_file table from central tenant to newly created member tenant
| Code Block |
|---|
|
insert into {member_tenant_id}_mod_entities_links.authority_source_file(
SELECT id, name, type, base_url, 'CONSORTIUM', created_date, updated_date, created_by_user_id, updated_by_user_id, sequence_name, selectable, hrid_start_number
FROM {central_tenant_id}_mod_entities_links.authority_source_file)
ON CONFLICT (id)
DO UPDATE SET source = 'CONSORTIUM' |
4. Copy authority_source_file_code table from central tenant to newly created member tenant
| Code Block |
|---|
|
insert into {member_tenant_id} |
...
_mod_entities_links.authority_source_file_code(
SELECT id, authority_source_file_id, code
FROM {central_tenant_id}_mod_entities_links.authority_source_file_code)
ON CONFLICT (id)
DO NOTHING |