Skip to content
Snippets Groups Projects

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

Merged [Journaux] Traces détaillées des modifications de métadonnées
feat/25325_archive_update_metadata_detailled_event into develop
Merged Jerome Boucher requested to merge feat/25325_archive_update_metadata_detailled_event into develop
Compare
and
Show latest version
1 file
+ 4
− 4
Compare changes
  • Side-by-side
  • Inline
data/maarchRM/sql/pgsql/demo.sql
+ 73
− 61
@@ -49,8 +49,7 @@ INSERT INTO "auth"."role" ("roleId","roleName","description","securityLevel","en
('CORRESPONDANT_ARCHIVES', 'Correspondant d''archives', 'Groupe des archivistes, records managers et référents d''archives', 'user', true),
('PRODUCTEUR', 'Producteur', 'Groupe des producteurs, versants', 'user', true),
('RESPONSABLE_ACTIVITE', 'Responsable d''activité', 'Groupe des responsables de service et des activités', 'user', true),
('UTILISATEUR', 'Utilisateur', 'Groupe des utilisateurs, consultation et navigation', 'user', true)
;
('UTILISATEUR', 'Utilisateur', 'Groupe des utilisateurs, consultation et navigation', 'user', true);
INSERT INTO "auth"."privilege" ("roleId","userStory") VALUES
('ADMIN_FONCTIONNEL', 'adminFunc/adminAuthorization'),
@@ -194,6 +193,17 @@ INSERT INTO "digitalResource"."conversionRule" ("conversionRuleId","puid","conve
;
INSERT INTO "lifeCycle"."eventFormat" ("type","format","message","notification") VALUES
('auth/addPrivilegeToRole', 'roleId roleName privilegeUserStory privilegeAddedByAccountName', 'Ajout d''un privilège à un rôle', false),
('auth/removePrivilegeToRole', 'roleId roleName privilegeUserStory privilegeRemovedByAccountName', 'Retrait d''un privilège à un rôle', false),
('auth/userAddRole', 'userId accountName roleId roleName roleAddedByAccountName', 'Ajout d''un rôle à un utilisateur', false),
('auth/userCreation', 'userId accountName createdByAccountName dataChanges', 'Création d''un utilisateur', false),
('auth/userDisabled', 'userId accountName disabledByAccountName', 'Désactivation d''un utilisateur', false),
('auth/userEnabled', 'userId accountName enabledByAccountName', 'Activation d''un utilisateur', false),
('auth/userLock', 'userId accountName lockByAccountName', 'Verrouillage d''un utilisateur', false),
('auth/userModification', 'userId accountName modifiedByAccountName dataChanges', 'Modification d''un utilisateur', false),
('auth/userPasswordModification', 'userId accountName previousHash currentHash', 'Modification du mot de passe d''un utilisateur', false),
('auth/userRemoveRole', 'userId accountName roleId roleName roleRemovedByAccountName', 'Retrait d''un rôle à un utilisateur', false),
('auth/userUnlock', 'userId accountName unlockByAccountName', 'Déverrouillage d''un utilisateur', false),
('digitalResource/integrityCheck', 'repositoryReference addressesToCheck checkedAddresses failed', 'Contrôle d''intégrité des ressources présentes dans %6$s', false),
('medona/acceptance', 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference', 'Message %14$s de type %9$s accepté par %13$s (%12$s)', false),
('medona/acknowledgement', 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference code info', 'Acquittement du message %14$s : %16$s (%15$s)', false),
@@ -204,12 +214,15 @@ INSERT INTO "lifeCycle"."eventFormat" ("type","format","message","notification")
('medona/retry', 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference', 'Message %14$s de type %9$s réinitialisé par %13$s (%12$s)', false),
('medona/sending', 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference code info', 'Envoi du message %14$s de type %9$s de %11$s (%10$s) à %13$s (%12$s)', false),
('medona/validation', 'type senderOrgRegNumber senderOrgName recipientOrgRegNumber recipientOrgName reference code info', 'Validation du message %14$s : %16$s (%15$s)', false),
('organization/addUserPosition', 'userId accountName orgId orgName userPositionAddedByAccountName', 'Ajout d''un utilisateur dans une organisation', false),
('organization/counting', 'orgName ownerOrgId', 'Compter le nombre d''objets numériques dans l''activité %6$s', false),
('organization/journal', 'orgName ownerOrgId', 'Lecture du journal de l''organisation %6$s', false),
('organization/listing', 'orgName ownerOrgId', 'Lister les identifiants d''objets numériques de l''activité %6$s', false),
('recordsManagement/accessRuleModification', 'resId hashAlgorithm hash address accessRuleStartDate accessRuleDuration previousAccessRuleStartDate previousAccessRuleDuration originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Modification de la règle de communicabilité de l''archive %6$s', false),
('organization/removeUserPosition', 'userId accountName orgId orgName userPositionRemovedByAccountName', 'Retrait d''un utilisateur d''une organisation', false),
('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/archivalProfileModification', 'archivalProfileReference dataChanges archivalProfileModifiedByAccountName', 'Modification du profil %6$s.', 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),
@@ -223,15 +236,14 @@ INSERT INTO "lifeCycle"."eventFormat" ("type","format","message","notification")
('recordsManagement/freeze', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Gel de l''archive %6$s', false),
('recordsManagement/hashMigration', 'resId hashAlgorithm hash address convertedHashAlgorithm convertedHash', 'Migration cryptographique', false),
('recordsManagement/integrityCheck', 'resId hash hashAlgorithm address requesterOrgRegNumber info originatorArchiveId', 'Validation d''intégrité', false),
('recordsManagement/metadataModification', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Modification des métadonnées de l''archive %6$s', false),
('recordsManagement/metadataModification', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId dataChanges', 'Modification des métadonnées de l''archive %6$s', false),
('recordsManagement/periodicIntegrityCheck', 'startDatetime endDatetime nbArchivesToCheck nbArchivesInSample archivesChecked originatorArchiveId', 'Validation périodique de l''intégrité', false),
('recordsManagement/profileCreation', 'archivalProfileReference', 'Création du profil %6$s', false),
('recordsManagement/profileDestruction', 'archivalProfileReference', 'Destruction du profil %6$s', false),
('recordsManagement/resourceDestruction', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Destruction de la ressource %9$s', false),
('recordsManagement/restitution', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber size originatorArchiveId', 'Restitution de l''archive %6$s', false),
('recordsManagement/retentionRuleModification', 'resId hashAlgorithm hash address retentionStartDate retentionDuration finalDisposition previousStartDate previousDuration previousFinalDisposition originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Modification de la règle de conservation de l''archive %6$s', false),
('recordsManagement/unfreeze', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Dégel de l''archive %6$s', false),
('recordsManagement/completenessCheck', 'lastCheckedResId lastCheckedResCreated repositoryReference resourcesToCheck checkedResources failed timeout timeoutError', 'Contrôle d''exhaustivité des ressources', false);
('recordsManagement/retentionRuleModification', 'resId hashAlgorithm hash address retentionStartDate retentionDuration finalDisposition previousStartDate previousDuration previousFinalDisposition originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId dataChanges', 'Modification de la règle de conservation de l''archive %6$s', false),
('recordsManagement/unfreeze', 'resId hashAlgorithm hash address originatorOrgRegNumber archiverOrgRegNumber originatorArchiveId', 'Dégel de l''archive %6$s', false);
INSERT INTO "organization"."orgType" ("code","name") VALUES ('Collectivite', 'Collectivité'),
('Direction', 'Direction d''une entreprise ou d''une collectivité'),
@@ -281,25 +293,25 @@ 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', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DIP', 'DOSIP', true, NULL, NULL),
('DOCSOC', 'FICI', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DOCSOC', 'FICCR', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DOCSOC', 'LETC', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DSG', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}, "VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}'),
('DSI', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}, "VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}'),
('DSI', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('FOUR', 'FACACH', true, NULL, '{"history": {}, "subProfile": {}, "processingStatuses": {"NEW": {"actions": {"qualify": {}, "cancelQualify": {}}}, "APPROVED": {"actions": {"pay": {}, "updateMetadata": {}}}, "REJECTED": {"actions": {"cancelQualify": {}, "sendValidation": {}, "updateMetadata": {}, "sendToApprobation": {}}}, "MISQUALIFIED": {"actions": {"qualify": {}}}}}'),
('FOUR', 'FACJU', true, NULL, NULL),
('SALES', 'FACVEN', true, NULL, NULL),
('DSG', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}, "VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}'),
('GIC', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('MARK', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}}}'),
('PAIE', 'BULPAI', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DAF', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DCIAL', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('RH', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DSI', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('GIC', 'NOTSER', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('TENDER', 'PM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('SALES', 'FACVEN', true, NULL, NULL),
('TENDER', 'COUNM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DOCSOC', 'FICCR', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DOCSOC', 'LETC', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('DOCSOC', 'FICI', true, NULL, '{"subProfile": {}, "processingStatuses": {}}'),
('MARK', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"QUALIFIED": {"actions": {"reject": {}, "redirect": {}, "validate": {}}}}}'),
('DCIAL', 'FACACH', false, NULL, '{"subProfile": {}, "processingStatuses": {"VALIDATED": {"actions": {"reject": {}, "approve": {}}}}}')
('TENDER', 'PM', true, NULL, '{"subProfile": {}, "processingStatuses": {}}')
;
INSERT INTO "organization"."servicePosition" ("serviceAccountId","orgId") VALUES
@@ -515,19 +527,19 @@ INSERT INTO "recordsManagement"."archiveDescription" ("archivalProfileId","field
('81', 'org', true, 3, false, NULL, false)
;
INSERT INTO "recordsManagement"."descriptionField" ("name","label","type","default","minLength","maxLength","minValue","maxValue","enumeration","facets","pattern","isArray") VALUES
('customer', 'Client', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('documentId', 'Identifiant de document', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('dueDate', 'Date d''échéance', 'date', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('empid', 'Matricule', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('fullname', 'Nom complet', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('netPayable', 'Net à payer', 'number', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('orderNumber', 'Numéro de commande', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('org', 'Organisation', 'name', NULL, NULL, NULL, NULL, NULL, '["ACME Paris","ACME Dakar","ACME Cotonou"]', NULL, NULL, false),
('salesPerson', 'Vendeur', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('service', 'Service Concerné', 'name', NULL, NULL, NULL, NULL, NULL, '["MARK","DSG","DSI","DAF"]', NULL, NULL, false),
('supplier', 'Fournisseur', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false),
('taxIdentifier', 'N° TVA Intraco.', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false)
INSERT INTO "recordsManagement"."descriptionField" ("name","label","type","default","minLength","maxLength","minValue","maxValue","enumeration","facets","pattern","isArray","sensitiveData") VALUES
('customer', 'Client', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('documentId', 'Identifiant de document', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false ,false),
('dueDate', 'Date d''échéance', 'date', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('empid', 'Matricule', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('fullname', 'Nom complet', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('netPayable', 'Net à payer', 'number', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('orderNumber', 'Numéro de commande', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('org', 'Organisation', 'name', NULL, NULL, NULL, NULL, NULL, '["ACME Paris","ACME Dakar","ACME Cotonou"]', NULL, NULL, false, false),
('salesPerson', 'Vendeur', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('service', 'Service Concerné', 'name', NULL, NULL, NULL, NULL, NULL, '["MARK","DSG","DSI","DAF"]', NULL, NULL, false, false),
('supplier', 'Fournisseur', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false),
('taxIdentifier', 'N° TVA Intraco.', 'name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false)
;
INSERT INTO "recordsManagement"."serviceLevel" ("serviceLevelId","reference","digitalResourceClusterId","control","default","samplingFrequency","samplingRate") VALUES
@@ -535,48 +547,48 @@ 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
('fmt/276','Acrobat PDF 1.7 - Portable Document Format','1.7','application/pdf','pdf',2),
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),
('fmt/18','Acrobat PDF 1.4 - Portable Document Format','1.4','application/pdf','pdf',2),
('fmt/19','Acrobat PDF 1.5 - Portable Document Format','1.5','application/pdf','pdf',2),
('fmt/20','Acrobat PDF 1.6 - Portable Document Format','1.6','application/pdf','pdf',2),
('fmt/42','JPEG File Interchange Format','1.00','image/jpeg','jpe jpeg jpg',2),
('fmt/43','JPEG File Interchange Format','1.01','image/jpeg','jpe jpeg jpg',2),
('fmt/44','JPEG File Interchange Format','1.02','image/jpeg','jpe jpeg jpg',2),
('fmt/95','Acrobat PDF/A - Portable Document Format','1a','application/pdf','pdf',2),
('fmt/101','Extensible Markup Language','1.0','application/xml text/xml','xml',2),
('fmt/136','OpenDocument Text','1.0','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/137','OpenDocument Spreadsheet','1.0','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/138','OpenDocument Presentation','1.0','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/151','JPX (JPEG 2000 part 2)','','image/jpx','jpf jpx',4),
('fmt/214','Microsoft Excel for Windows','2007 onwards','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','xlsx',1),
('fmt/276','Acrobat PDF 1.7 - Portable Document Format','1.7','application/pdf','pdf',2),
('fmt/278','Internet Message Format','','message/rfc822','eml',0),
('fmt/290','OpenDocument Text','1.1','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/291','OpenDocument Text','1.2','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/292','OpenDocument Presentation','1.1','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/293','OpenDocument Presentation','1.2','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/294','OpenDocument Spreadsheet','1.1','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/295','OpenDocument Spreadsheet','1.2','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/353','Tagged Image File Format','','image/tiff','tif tiff',2),
('fmt/354','Acrobat PDF/A - Portable Document Format','1b','application/pdf','pdf',2),
('fmt/412','Microsoft Word for Windows','2007 onwards','application/vnd.openxmlformats-officedocument.wordprocessingml.document','docx wbk',1),
('fmt/463','JPM (JPEG 2000 part 6)','','image/jpm','jpm',4),
('fmt/476','Acrobat PDF/A - Portable Document Format','2a','application/pdf','pdf',0),
('fmt/477','Acrobat PDF/A - Portable Document Format','2b','application/pdf','pdf',0),
('fmt/478','Acrobat PDF/A - Portable Document Format','2u','application/pdf','pdf',0),
('fmt/479','Acrobat PDF/A - Portable Document Format','3a','application/pdf','pdf',4),
('fmt/480','Acrobat PDF/A - Portable Document Format','3b','application/pdf','pdf',4),
('fmt/481','Acrobat PDF/A - Portable Document Format','3u','application/pdf','pdf',4),
('fmt/136','OpenDocument Text','1.0','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/290','OpenDocument Text','1.1','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/291','OpenDocument Text','1.2','application/vnd.oasis.opendocument.text','odt ott',2),
('fmt/137','OpenDocument Spreadsheet','1.0','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/294','OpenDocument Spreadsheet','1.1','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/295','OpenDocument Spreadsheet','1.2','application/vnd.oasis.opendocument.spreadsheet','ods ots',2),
('fmt/138','OpenDocument Presentation','1.0','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/292','OpenDocument Presentation','1.1','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/293','OpenDocument Presentation','1.2','application/vnd.oasis.opendocument.presentation','odp otp',2),
('fmt/412','Microsoft Word for Windows','2007 onwards','application/vnd.openxmlformats-officedocument.wordprocessingml.document','docx wbk',1),
('fmt/214','Microsoft Excel for Windows','2007 onwards','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','xlsx',1),
('fmt/483','ePub format','','application/epub+zip','epub',1),
('fmt/484','7Zip format','',NULL,'7z',2),
('fmt/629','Microsoft PowerPoint Show','2007','application/vnd.openxmlformats-officedocument.presentationml.slideshow','ppsx',1),
('fmt/950','MIME Email','1.0','message/rfc822','eml',0),
('x-fmt/111','Plain Text File','','text/plain','txt',3),
('fmt/483','ePub format','','application/epub+zip','epub',1),
('fmt/101','Extensible Markup Language','1.0','application/xml text/xml','xml',2),
('x-fmt/263','ZIP Format','','application/zip','zip',2),
('fmt/484','7Zip format','',NULL,'7z',2),
('fmt/353','Tagged Image File Format','','image/tiff','tif tiff',2),
('x-fmt/387','Exchangeable Image File Format (Uncompressed)','2.2','image/tiff','tif tiff',2),
('x-fmt/388','Exchangeable Image File Format (Uncompressed)','2.1','image/tiff','tif tiff',2),
('x-fmt/399','Exchangeable Image File Format (Uncompressed)','2.0','image/tiff','tif tiff',2),
('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),
('x-fmt/392','JP2 (JPEG 2000 part 1)','','image/jp2','jp2',4),
('fmt/151','JPX (JPEG 2000 part 2)','','image/jpx','jpf jpx',4),
('fmt/463','JPM (JPEG 2000 part 6)','','image/jpm','jpm',4),
('fmt/42','JPEG File Interchange Format','1.00','image/jpeg','jpe jpeg jpg',2),
('fmt/43','JPEG File Interchange Format','1.01','image/jpeg','jpe jpeg jpg',2),
('fmt/44','JPEG File Interchange Format','1.02','image/jpeg','jpe jpeg jpg',2),
('fmt/278','Internet Message Format','','message/rfc822','eml',0),
('fmt/950','MIME Email','1.0','message/rfc822','eml',0);
('x-fmt/399','Exchangeable Image File Format (Uncompressed)','2.0','image/tiff','tif tiff',2);