[Journaux] Traces détaillées des modifications de métadonnées

data/maarchRM/sql/pgsql/demo.sql

@@ -220,7 +220,7 @@ INSERT INTO "lifeCycle"."eventFormat" ("type","format","message","notification")
 ('recordsManagement/accessRuleModification', 'resId hashAlgorithm hash address accessRuleStartDate accessRuleDuration previousAccessRuleStartDate previousAccessRuleDuration originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId dataChanges', 'Modification de la règle de communicabilité de l''archive %6$s', false),
 ('recordsManagement/addRelationship', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber relatedArchiveId originatorArchiveId', 'Relation ajoutée avec l''archive %6$s', false),
 ('recordsManagement/archivalProfileModification', 'archivalProfileReference', 'Modification du profil %6$s.', false),
-('recordsManagement/completenessCheck', 'lastCheckedResId lastCheckedResCreated repositoryReference resourcesToCheck checkedResources failed timeout timeoutError', 'Contrôle d''exhaustivité des ressources', false)
+('recordsManagement/completenessCheck', 'lastCheckedResId lastCheckedResCreated repositoryReference resourcesToCheck checkedResources failed timeout timeoutError', 'Contrôle d''exhaustivité des ressources', false),
 ('recordsManagement/consultation', 'resId hash hashAlgorith address size originatorArchiveId', 'Consultation de la ressource %9$s', false),
 ('recordsManagement/conversion', 'resId hashAlgorithm hash address convertedResId convertedHashAlgorithm convertedHash convertedAddress software docId size originatorArchiveId', 'Conversion du document %18$s', false),
 ('recordsManagement/deleteRelationship', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber relatedArchiveId originatorArchiveId', 'Relation avec l''archive %6$s supprimée', false),
@@ -291,7 +291,7 @@ INSERT INTO "organization"."organization" ("orgId","orgName","otherOrgName","dis
 INSERT INTO "organization"."archivalProfileAccess" ("orgId","archivalProfileReference","originatorAccess","serviceLevelReference","userAccess") VALUES
 ('DAF', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}, "VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}'),
 ('DAF', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
-('DCIAL', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}')
+('DCIAL', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}'),
 ('DCIAL', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
 ('DIP', 'DOSIP', true, NULL, NULL),
 ('DOCSOC', 'FICI', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
@@ -308,7 +308,7 @@ INSERT INTO "organization"."archivalProfileAccess" ("orgId","archivalProfileRefe
 ('RH', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
 ('SALES', 'FACVEN', true, NULL, NULL),
 ('TENDER', 'COUNM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
-('TENDER', 'PM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
+('TENDER', 'PM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}')
 ;
 
 INSERT INTO "organization"."servicePosition" ("serviceAccountId","orgId") VALUES
@@ -544,7 +544,7 @@ INSERT INTO "recordsManagement"."serviceLevel" ("serviceLevelId","reference","di
 ('ServiceLevel_002', 'serviceLevel_002', 'archives', NULL, true, 2, 50)
 ;
 
-INSERT INTO "digitalResource".format (puid,name,"version",mimetypes,extensions,status) VALUES
+INSERT INTO "digitalResource"."format" ("puid","name","version","mimetypes","extensions","status") VALUES
 ('fmt/11','Portable Network Graphics','1.0','image/png','png',2),
 ('fmt/12','Portable Network Graphics','1.1','image/png','png',2),
 ('fmt/13','Portable Network Graphics','1.2','image/png','png',2),