migrationV2.6_V2.7.sql 639 Bytes
Newer Older
Alexandre Morin's avatar
Alexandre Morin committed
1
2
-- Migration script for PGSQL from Maarch RM V2.6 to V2.7

3
UPDATE "lifeCycle"."eventFormat" SET format = 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference code info' WHERE type = 'medona/sending';
Cyril Vazquez's avatar
Cyril Vazquez committed
4
INSERT INTO "lifeCycle"."eventFormat" (type, format, message, notification) VALUES ('digitalResource/integrityCheck', 'repositoryReference addressesToCheck checkedAddresses failed', 'Contrôle d''intégrité des ressources présentes dans %6$s', false);
5
6

ALTER TABLE "organization"."organization" ADD COLUMN "history" text;
7
8

CREATE SEQUENCE IF NOT EXISTS "recordsManagement"."archiverArchiveIdSequence";