{"action":"created","issue":{"url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/20","repository_url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog","labels_url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/20/comments","events_url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/20/events","html_url":"https://github.com/ioncache/DBIx-Class-AuditLog/issues/20","id":23721821,"number":20,"title":"deploy script generates incorrect audit_log_view ","user":{"login":"pietmolenaar","id":990528,"avatar_url":"https://avatars.githubusercontent.com/u/990528?v=3","gravatar_id":"","url":"https://api.github.com/users/pietmolenaar","html_url":"https://github.com/pietmolenaar","followers_url":"https://api.github.com/users/pietmolenaar/followers","following_url":"https://api.github.com/users/pietmolenaar/following{/other_user}","gists_url":"https://api.github.com/users/pietmolenaar/gists{/gist_id}","starred_url":"https://api.github.com/users/pietmolenaar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pietmolenaar/subscriptions","organizations_url":"https://api.github.com/users/pietmolenaar/orgs","repos_url":"https://api.github.com/users/pietmolenaar/repos","events_url":"https://api.github.com/users/pietmolenaar/events{/privacy}","received_events_url":"https://api.github.com/users/pietmolenaar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2013-12-04T15:20:29Z","updated_at":"2016-03-04T15:42:58Z","closed_at":null,"body":"\r\nWhen running the deployment script column values are apparently shifted: the view below was produced. This was win7 mysql 5.5.\r\n\r\n/*View: audit_log_view*/\r\n------------------------\r\n\r\n/*Column Information*/\r\n----------------------\r\n\r\nField         Type          Collation          Null    Key     Default              Extra   Privileges                       Comment  \r\n------------  ------------  -----------------  ------  ------  -------------------  ------  -------------------------------  ---------\r\nchange_id     int(11)       (NULL)             NO              0                            select,insert,update,references           \r\nchangeset_id  varchar(255)  latin1_swedish_ci  YES             (NULL)                       select,insert,update,references           \r\nold_value     varchar(255)  latin1_swedish_ci  YES             (NULL)                       select,insert,update,references           \r\nnew_value     varchar(10)   latin1_swedish_ci  NO              (NULL)                       select,insert,update,references           \r\naction_type   varchar(255)  latin1_swedish_ci  NO              (NULL)                       select,insert,update,references           \r\naudited_row   int(11)       (NULL)             NO              0                            select,insert,update,references           \r\ntable_name    varchar(255)  latin1_swedish_ci  YES             (NULL)                       select,insert,update,references           \r\nfield_name    timestamp     (NULL)             NO              0000-00-00 00:00:00          select,insert,update,references           \r\ndescription   varchar(40)   latin1_swedish_ci  NO              (NULL)                       select,insert,update,references           \r\ncreated_on    varchar(40)   latin1_swedish_ci  NO              (NULL)                       select,insert,update,references           \r\nuser_name     varchar(100)  latin1_swedish_ci  YES             (NULL)                       select,insert,update,references           \r\n\r\n\r\n/*DDL Information*/\r\n-------------------\r\n\r\nCREATE ALGORITHM=UNDEFINED DEFINER=`ogtool_admin`@`%` SQL SECURITY DEFINER VIEW `audit_log_view` AS \r\nselect\r\n  `c`.`id`          AS `change_id`,\r\n  `c`.`old_value`   AS `changeset_id`,\r\n  `c`.`new_value`   AS `old_value`,\r\n  `a`.`action_type` AS `new_value`,\r\n  `a`.`audited_row` AS `action_type`,\r\n  `s`.`id`          AS `audited_row`,\r\n  `s`.`description` AS `table_name`,\r\n  `s`.`created_on`  AS `field_name`,\r\n  `t`.`name`        AS `description`,\r\n  `f`.`name`        AS `created_on`,\r\n  `u`.`name`        AS `user_name`\r\nfrom (((((`audit_log_action` `a`\r\n       join `audit_log_change` `c`\r\n         on ((`c`.`action_id` = `a`.`id`)))\r\n      join `audit_log_field` `f`\r\n        on ((`f`.`id` = `c`.`field_id`)))\r\n     join `audit_log_table` `t`\r\n       on ((`t`.`id` = `a`.`audited_table_id`)))\r\n    join `audit_log_changeset` `s`\r\n      on ((`s`.`id` = `a`.`changeset_id`)))\r\n   left join `audit_log_user` `u`\r\n     on ((`s`.`user_id` = `u`.`id`)))\r\n\r\n "},"comment":{"url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/comments/192327802","html_url":"https://github.com/ioncache/DBIx-Class-AuditLog/issues/20#issuecomment-192327802","issue_url":"https://api.github.com/repos/ioncache/DBIx-Class-AuditLog/issues/20","id":192327802,"user":{"login":"Getty","id":46562,"avatar_url":"https://avatars.githubusercontent.com/u/46562?v=3","gravatar_id":"","url":"https://api.github.com/users/Getty","html_url":"https://github.com/Getty","followers_url":"https://api.github.com/users/Getty/followers","following_url":"https://api.github.com/users/Getty/following{/other_user}","gists_url":"https://api.github.com/users/Getty/gists{/gist_id}","starred_url":"https://api.github.com/users/Getty/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Getty/subscriptions","organizations_url":"https://api.github.com/users/Getty/orgs","repos_url":"https://api.github.com/users/Getty/repos","events_url":"https://api.github.com/users/Getty/events{/privacy}","received_events_url":"https://api.github.com/users/Getty/received_events","type":"User","site_admin":false},"created_at":"2016-03-04T15:42:58Z","updated_at":"2016-03-04T15:42:58Z","body":"Fixed in this pull request: https://github.com/ioncache/DBIx-Class-AuditLog/pull/26"}}