{"action":"created","issue":{"url":"https://api.github.com/repos/SUSE/smt/issues/31","labels_url":"https://api.github.com/repos/SUSE/smt/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/SUSE/smt/issues/31/comments","events_url":"https://api.github.com/repos/SUSE/smt/issues/31/events","html_url":"https://github.com/SUSE/smt/pull/31","id":102157239,"number":31,"title":"DB engine migration","user":{"login":"aaannz","id":1260795,"avatar_url":"https://avatars.githubusercontent.com/u/1260795?v=3","gravatar_id":"","url":"https://api.github.com/users/aaannz","html_url":"https://github.com/aaannz","followers_url":"https://api.github.com/users/aaannz/followers","following_url":"https://api.github.com/users/aaannz/following{/other_user}","gists_url":"https://api.github.com/users/aaannz/gists{/gist_id}","starred_url":"https://api.github.com/users/aaannz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaannz/subscriptions","organizations_url":"https://api.github.com/users/aaannz/orgs","repos_url":"https://api.github.com/users/aaannz/repos","events_url":"https://api.github.com/users/aaannz/events{/privacy}","received_events_url":"https://api.github.com/users/aaannz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-20T14:50:34Z","updated_at":"2015-08-25T08:58:55Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/SUSE/smt/pulls/31","html_url":"https://github.com/SUSE/smt/pull/31","diff_url":"https://github.com/SUSE/smt/pull/31.diff","patch_url":"https://github.com/SUSE/smt/pull/31.patch"},"body":"- enhance smt-migration-upgrade to do DB engine migration\r\n  at the end I decided to use the simplest way (alter table $t engine InnoDB, creating temporary\r\n  tables proved to be more error prone\r\n- add notification about needed DB migration during rpm upgrade\r\n- add smt-migration-upgrade.service to be called after mysql.service and before apache2, all part\r\n  of smt.target\r\n- services are enabled during yast2 smt-server call of db/smt-db, but I don't know yet how to enable\r\n  them after upgrade when yast2 smt-server is not run.\r\n- some other fixes here and there"},"comment":{"url":"https://api.github.com/repos/SUSE/smt/issues/comments/134531316","html_url":"https://github.com/SUSE/smt/pull/31#issuecomment-134531316","issue_url":"https://api.github.com/repos/SUSE/smt/issues/31","id":134531316,"user":{"login":"mcalmer","id":1038917,"avatar_url":"https://avatars.githubusercontent.com/u/1038917?v=3","gravatar_id":"","url":"https://api.github.com/users/mcalmer","html_url":"https://github.com/mcalmer","followers_url":"https://api.github.com/users/mcalmer/followers","following_url":"https://api.github.com/users/mcalmer/following{/other_user}","gists_url":"https://api.github.com/users/mcalmer/gists{/gist_id}","starred_url":"https://api.github.com/users/mcalmer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mcalmer/subscriptions","organizations_url":"https://api.github.com/users/mcalmer/orgs","repos_url":"https://api.github.com/users/mcalmer/repos","events_url":"https://api.github.com/users/mcalmer/events{/privacy}","received_events_url":"https://api.github.com/users/mcalmer/received_events","type":"User","site_admin":false},"created_at":"2015-08-25T08:58:55Z","updated_at":"2015-08-25T08:58:55Z","body":"smt-schema-upgrade changed a lot, but it looks like that it should work.\r\nIf not I think we will find out soon.\r\n"}}