Ramsons (R2 2024) Required manual migrations
- Pavlo Smahin
- Julian Ladisch
Owned by Pavlo Smahin
Module | Instructions | Comments | Contact person, |
|---|---|---|---|
mod-entities-links | Manually executed script for each tenant SET search_path TO <tenantId>_mod_entities_links;
-- Find deleted records in authority table; index avoids two full table scans
CREATE INDEX IF NOT EXISTS authority_deleted_idx ON authority(deleted) WHERE deleted;
-- Move to archive
INSERT INTO authority_archive SELECT * FROM authority WHERE deleted = true ON CONFLICT DO NOTHING;
-- Delete deleted
DELETE FROM authority WHERE deleted = true;
-- Drop index
DROP INDEX authority_deleted_idx; | Due to migration issues in previous releases, there may be cases where deleted authority records are not transferred to the authority archive. While this doesn't significantly impact functionality, moving them to the correct location would enhance consistency. |
Â