{"action":"closed","issue":{"url":"https://api.github.com/repos/Eusebius/filmotheque/issues/57","repository_url":"https://api.github.com/repos/Eusebius/filmotheque","labels_url":"https://api.github.com/repos/Eusebius/filmotheque/issues/57/labels{/name}","comments_url":"https://api.github.com/repos/Eusebius/filmotheque/issues/57/comments","events_url":"https://api.github.com/repos/Eusebius/filmotheque/issues/57/events","html_url":"https://github.com/Eusebius/filmotheque/issues/57","id":137948443,"number":57,"title":"Set up a clean procedure to update database schema","user":{"login":"Eusebius","id":4344339,"avatar_url":"https://avatars.githubusercontent.com/u/4344339?v=3","gravatar_id":"","url":"https://api.github.com/users/Eusebius","html_url":"https://github.com/Eusebius","followers_url":"https://api.github.com/users/Eusebius/followers","following_url":"https://api.github.com/users/Eusebius/following{/other_user}","gists_url":"https://api.github.com/users/Eusebius/gists{/gist_id}","starred_url":"https://api.github.com/users/Eusebius/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Eusebius/subscriptions","organizations_url":"https://api.github.com/users/Eusebius/orgs","repos_url":"https://api.github.com/users/Eusebius/repos","events_url":"https://api.github.com/users/Eusebius/events{/privacy}","received_events_url":"https://api.github.com/users/Eusebius/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Eusebius/filmotheque/labels/database","name":"database","color":"5319e7"},{"url":"https://api.github.com/repos/Eusebius/filmotheque/labels/duplicate","name":"duplicate","color":"cccccc"},{"url":"https://api.github.com/repos/Eusebius/filmotheque/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":{"login":"Eusebius","id":4344339,"avatar_url":"https://avatars.githubusercontent.com/u/4344339?v=3","gravatar_id":"","url":"https://api.github.com/users/Eusebius","html_url":"https://github.com/Eusebius","followers_url":"https://api.github.com/users/Eusebius/followers","following_url":"https://api.github.com/users/Eusebius/following{/other_user}","gists_url":"https://api.github.com/users/Eusebius/gists{/gist_id}","starred_url":"https://api.github.com/users/Eusebius/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Eusebius/subscriptions","organizations_url":"https://api.github.com/users/Eusebius/orgs","repos_url":"https://api.github.com/users/Eusebius/repos","events_url":"https://api.github.com/users/Eusebius/events{/privacy}","received_events_url":"https://api.github.com/users/Eusebius/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Eusebius/filmotheque/milestones/2","html_url":"https://github.com/Eusebius/filmotheque/milestones/1.0","labels_url":"https://api.github.com/repos/Eusebius/filmotheque/milestones/2/labels","id":468097,"number":2,"title":"1.0","description":null,"creator":{"login":"Eusebius","id":4344339,"avatar_url":"https://avatars.githubusercontent.com/u/4344339?v=3","gravatar_id":"","url":"https://api.github.com/users/Eusebius","html_url":"https://github.com/Eusebius","followers_url":"https://api.github.com/users/Eusebius/followers","following_url":"https://api.github.com/users/Eusebius/following{/other_user}","gists_url":"https://api.github.com/users/Eusebius/gists{/gist_id}","starred_url":"https://api.github.com/users/Eusebius/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Eusebius/subscriptions","organizations_url":"https://api.github.com/users/Eusebius/orgs","repos_url":"https://api.github.com/users/Eusebius/repos","events_url":"https://api.github.com/users/Eusebius/events{/privacy}","received_events_url":"https://api.github.com/users/Eusebius/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":1,"state":"open","created_at":"2013-10-29T16:30:05Z","updated_at":"2016-03-03T16:41:04Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-03-02T18:07:13Z","updated_at":"2016-03-03T16:41:04Z","closed_at":"2016-03-03T16:41:04Z","body":"view creation is problematic, delayed inserts are problematic, duplicate entries are problematic, duplicate foreign key constraints are problematic... Probably the solution is to extract content, to wipe the database, re-create the structure and repopulate."}}