{"action":"created","issue":{"url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/125","repository_url":"https://api.github.com/repos/tuub/kitodo-mediaserver","labels_url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/125/labels{/name}","comments_url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/125/comments","events_url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/125/events","html_url":"https://github.com/tuub/kitodo-mediaserver/issues/125","id":342258194,"node_id":"MDU6SXNzdWUzNDIyNTgxOTQ=","number":125,"title":"Hibernate init creates MyISAM, join table missing","user":{"login":"pbroman","id":24228367,"node_id":"MDQ6VXNlcjI0MjI4MzY3","avatar_url":"https://avatars3.githubusercontent.com/u/24228367?v=4","gravatar_id":"","url":"https://api.github.com/users/pbroman","html_url":"https://github.com/pbroman","followers_url":"https://api.github.com/users/pbroman/followers","following_url":"https://api.github.com/users/pbroman/following{/other_user}","gists_url":"https://api.github.com/users/pbroman/gists{/gist_id}","starred_url":"https://api.github.com/users/pbroman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pbroman/subscriptions","organizations_url":"https://api.github.com/users/pbroman/orgs","repos_url":"https://api.github.com/users/pbroman/repos","events_url":"https://api.github.com/users/pbroman/events{/privacy}","received_events_url":"https://api.github.com/users/pbroman/received_events","type":"User","site_admin":false},"labels":[{"id":969170811,"node_id":"MDU6TGFiZWw5NjkxNzA4MTE=","url":"https://api.github.com/repos/tuub/kitodo-mediaserver/labels/CLI","name":"CLI","color":"1d76db","default":false},{"id":882453350,"node_id":"MDU6TGFiZWw4ODI0NTMzNTA=","url":"https://api.github.com/repos/tuub/kitodo-mediaserver/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"open","locked":false,"assignee":{"login":"ponchofiesta","id":12248938,"node_id":"MDQ6VXNlcjEyMjQ4OTM4","avatar_url":"https://avatars2.githubusercontent.com/u/12248938?v=4","gravatar_id":"","url":"https://api.github.com/users/ponchofiesta","html_url":"https://github.com/ponchofiesta","followers_url":"https://api.github.com/users/ponchofiesta/followers","following_url":"https://api.github.com/users/ponchofiesta/following{/other_user}","gists_url":"https://api.github.com/users/ponchofiesta/gists{/gist_id}","starred_url":"https://api.github.com/users/ponchofiesta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ponchofiesta/subscriptions","organizations_url":"https://api.github.com/users/ponchofiesta/orgs","repos_url":"https://api.github.com/users/ponchofiesta/repos","events_url":"https://api.github.com/users/ponchofiesta/events{/privacy}","received_events_url":"https://api.github.com/users/ponchofiesta/received_events","type":"User","site_admin":false},"assignees":[{"login":"ponchofiesta","id":12248938,"node_id":"MDQ6VXNlcjEyMjQ4OTM4","avatar_url":"https://avatars2.githubusercontent.com/u/12248938?v=4","gravatar_id":"","url":"https://api.github.com/users/ponchofiesta","html_url":"https://github.com/ponchofiesta","followers_url":"https://api.github.com/users/ponchofiesta/followers","following_url":"https://api.github.com/users/ponchofiesta/following{/other_user}","gists_url":"https://api.github.com/users/ponchofiesta/gists{/gist_id}","starred_url":"https://api.github.com/users/ponchofiesta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ponchofiesta/subscriptions","organizations_url":"https://api.github.com/users/ponchofiesta/orgs","repos_url":"https://api.github.com/users/ponchofiesta/repos","events_url":"https://api.github.com/users/ponchofiesta/events{/privacy}","received_events_url":"https://api.github.com/users/ponchofiesta/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-07-18T09:55:32Z","updated_at":"2018-07-18T11:54:27Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"If you create the database in MySQL using the cli with initDb you get MyISAM tables. Since these cannot handle foreign keys, there are no foreign key defined in the database, which of course may lead to inconsistencies.\r\nMoreover, the join table between work and collection (see #121) is not created by initdb."},"comment":{"url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/comments/405904924","html_url":"https://github.com/tuub/kitodo-mediaserver/issues/125#issuecomment-405904924","issue_url":"https://api.github.com/repos/tuub/kitodo-mediaserver/issues/125","id":405904924,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNTkwNDkyNA==","user":{"login":"ponchofiesta","id":12248938,"node_id":"MDQ6VXNlcjEyMjQ4OTM4","avatar_url":"https://avatars2.githubusercontent.com/u/12248938?v=4","gravatar_id":"","url":"https://api.github.com/users/ponchofiesta","html_url":"https://github.com/ponchofiesta","followers_url":"https://api.github.com/users/ponchofiesta/followers","following_url":"https://api.github.com/users/ponchofiesta/following{/other_user}","gists_url":"https://api.github.com/users/ponchofiesta/gists{/gist_id}","starred_url":"https://api.github.com/users/ponchofiesta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ponchofiesta/subscriptions","organizations_url":"https://api.github.com/users/ponchofiesta/orgs","repos_url":"https://api.github.com/users/ponchofiesta/repos","events_url":"https://api.github.com/users/ponchofiesta/events{/privacy}","received_events_url":"https://api.github.com/users/ponchofiesta/received_events","type":"User","site_admin":false},"created_at":"2018-07-18T11:54:27Z","updated_at":"2018-07-18T11:54:27Z","author_association":"CONTRIBUTOR","body":"Yes, I assume, this is for backward compatibility. We can set the Hibernate dialect to MySQL57Dialect (or something like that) in local.yml to use InnoDB storage engine by default. But this depends on the database system used."}}
{"actor":{"display_login":"ponchofiesta"}}