We are using a MySQL partitioned db (same schema for each db) and need to audit data by company. (so we have extra company id key in every entity) Some companies have their data on a certain server, others on another. So i guess that to accomplish auditing we need a composite revision id: [companyId, revId] in the "revinfo" table and also in the audit tables themselves. We want to know entity changes for each company. We also must be able to copy all data of one company to another server including the audit data. "CompanyId" is unique over all servers. For now this seems impossible.
Is this possible with the current version of envers?
|