{"action":"created","issue":{"url":"https://api.github.com/repos/simplethings/EntityAudit/issues/132","labels_url":"https://api.github.com/repos/simplethings/EntityAudit/issues/132/labels{/name}","comments_url":"https://api.github.com/repos/simplethings/EntityAudit/issues/132/comments","events_url":"https://api.github.com/repos/simplethings/EntityAudit/issues/132/events","html_url":"https://github.com/simplethings/EntityAudit/issues/132","id":78012953,"number":132,"title":"revtype in revisions-table instead of in the audit-table?","user":{"login":"ch33f","id":6468902,"avatar_url":"https://avatars.githubusercontent.com/u/6468902?v=3","gravatar_id":"","url":"https://api.github.com/users/ch33f","html_url":"https://github.com/ch33f","followers_url":"https://api.github.com/users/ch33f/followers","following_url":"https://api.github.com/users/ch33f/following{/other_user}","gists_url":"https://api.github.com/users/ch33f/gists{/gist_id}","starred_url":"https://api.github.com/users/ch33f/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ch33f/subscriptions","organizations_url":"https://api.github.com/users/ch33f/orgs","repos_url":"https://api.github.com/users/ch33f/repos","events_url":"https://api.github.com/users/ch33f/events{/privacy}","received_events_url":"https://api.github.com/users/ch33f/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-19T09:33:26Z","updated_at":"2015-08-21T18:14:42Z","closed_at":null,"body":"Just an Idea...\r\nWouldn't it be better to store the revtype (UPD/INS/DEL) in the revisions table instead of the audit table?\r\n\r\nSince revid -> revtype it would make more sence looking at it in a relational way (normalization?).\r\n\r\nIn my latest project I would like to provide a table of all revisions including the revtype but ideally without retrieving the whole revision. Saving the revtype in the revisions table would spare me some nasty workarounds/hacks for that.\r\n\r\nI know it would be quite a change for the API but in my oppinion it would be worth it. What do you think?"},"comment":{"url":"https://api.github.com/repos/simplethings/EntityAudit/issues/comments/133518970","html_url":"https://github.com/simplethings/EntityAudit/issues/132#issuecomment-133518970","issue_url":"https://api.github.com/repos/simplethings/EntityAudit/issues/132","id":133518970,"user":{"login":"StrikeForceZero","id":983413,"avatar_url":"https://avatars.githubusercontent.com/u/983413?v=3","gravatar_id":"","url":"https://api.github.com/users/StrikeForceZero","html_url":"https://github.com/StrikeForceZero","followers_url":"https://api.github.com/users/StrikeForceZero/followers","following_url":"https://api.github.com/users/StrikeForceZero/following{/other_user}","gists_url":"https://api.github.com/users/StrikeForceZero/gists{/gist_id}","starred_url":"https://api.github.com/users/StrikeForceZero/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StrikeForceZero/subscriptions","organizations_url":"https://api.github.com/users/StrikeForceZero/orgs","repos_url":"https://api.github.com/users/StrikeForceZero/repos","events_url":"https://api.github.com/users/StrikeForceZero/events{/privacy}","received_events_url":"https://api.github.com/users/StrikeForceZero/received_events","type":"User","site_admin":false},"created_at":"2015-08-21T18:14:42Z","updated_at":"2015-08-21T18:14:42Z","body":"I've implemented this in a [fork of the project](https://github.com/StrikeForceZero/EntityAudit/commit/5171463a38e8d75824e56e4cb1fd28587eb7ddd3). \r\n\r\n(fair warning that the other previous [commit](https://github.com/StrikeForceZero/EntityAudit/commit/fc1b9fda7bc729c9cd4f03370e2232972aa2d86b) in my fork: ArrayDiff has a different signature and could be a breaking api change)"}}