{"action":"created","issue":{"url":"https://api.github.com/repos/zotonic/zotonic/issues/1206","repository_url":"https://api.github.com/repos/zotonic/zotonic","labels_url":"https://api.github.com/repos/zotonic/zotonic/issues/1206/labels{/name}","comments_url":"https://api.github.com/repos/zotonic/zotonic/issues/1206/comments","events_url":"https://api.github.com/repos/zotonic/zotonic/issues/1206/events","html_url":"https://github.com/zotonic/zotonic/issues/1206","id":138143068,"number":1206,"title":"How to update custom pivot database table with new columns","user":{"login":"loetie","id":5628172,"avatar_url":"https://avatars.githubusercontent.com/u/5628172?v=3","gravatar_id":"","url":"https://api.github.com/users/loetie","html_url":"https://github.com/loetie","followers_url":"https://api.github.com/users/loetie/followers","following_url":"https://api.github.com/users/loetie/following{/other_user}","gists_url":"https://api.github.com/users/loetie/gists{/gist_id}","starred_url":"https://api.github.com/users/loetie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/loetie/subscriptions","organizations_url":"https://api.github.com/users/loetie/orgs","repos_url":"https://api.github.com/users/loetie/repos","events_url":"https://api.github.com/users/loetie/events{/privacy}","received_events_url":"https://api.github.com/users/loetie/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"ddeboer","id":89267,"avatar_url":"https://avatars.githubusercontent.com/u/89267?v=3","gravatar_id":"","url":"https://api.github.com/users/ddeboer","html_url":"https://github.com/ddeboer","followers_url":"https://api.github.com/users/ddeboer/followers","following_url":"https://api.github.com/users/ddeboer/following{/other_user}","gists_url":"https://api.github.com/users/ddeboer/gists{/gist_id}","starred_url":"https://api.github.com/users/ddeboer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddeboer/subscriptions","organizations_url":"https://api.github.com/users/ddeboer/orgs","repos_url":"https://api.github.com/users/ddeboer/repos","events_url":"https://api.github.com/users/ddeboer/events{/privacy}","received_events_url":"https://api.github.com/users/ddeboer/received_events","type":"User","site_admin":false},"assignees":[{"login":"ddeboer","id":89267,"avatar_url":"https://avatars.githubusercontent.com/u/89267?v=3","gravatar_id":"","url":"https://api.github.com/users/ddeboer","html_url":"https://github.com/ddeboer","followers_url":"https://api.github.com/users/ddeboer/followers","following_url":"https://api.github.com/users/ddeboer/following{/other_user}","gists_url":"https://api.github.com/users/ddeboer/gists{/gist_id}","starred_url":"https://api.github.com/users/ddeboer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddeboer/subscriptions","organizations_url":"https://api.github.com/users/ddeboer/orgs","repos_url":"https://api.github.com/users/ddeboer/repos","events_url":"https://api.github.com/users/ddeboer/events{/privacy}","received_events_url":"https://api.github.com/users/ddeboer/received_events","type":"User","site_admin":false}],"milestone":null,"comments":9,"created_at":"2016-03-03T10:47:40Z","updated_at":"2016-08-31T12:37:43Z","closed_at":null,"body":"Currently the documentation shows how to add a custom pivot, which is great!\r\nhttps://github.com/zotonic/zotonic/blob/master/doc/cookbook/custom-pivot.rst\r\n\r\nHowever it does not show how to update the database table when you add new columns to the custom pivot table. We tried to build the site and then restarting the site or server, but that does not seem to do the trick.\r\n\r\nWe had to remove the table from the database within postgress and then run the init command to get the new structure in place.\r\n\r\nMaybe it would be a good idea to:\r\nA - Add it to the documentation\r\nB - Make it easier to update the database schema when adding new columns to the pivot table."},"comment":{"url":"https://api.github.com/repos/zotonic/zotonic/issues/comments/243750525","html_url":"https://github.com/zotonic/zotonic/issues/1206#issuecomment-243750525","issue_url":"https://api.github.com/repos/zotonic/zotonic/issues/1206","id":243750525,"user":{"login":"ddeboer","id":89267,"avatar_url":"https://avatars.githubusercontent.com/u/89267?v=3","gravatar_id":"","url":"https://api.github.com/users/ddeboer","html_url":"https://github.com/ddeboer","followers_url":"https://api.github.com/users/ddeboer/followers","following_url":"https://api.github.com/users/ddeboer/following{/other_user}","gists_url":"https://api.github.com/users/ddeboer/gists{/gist_id}","starred_url":"https://api.github.com/users/ddeboer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddeboer/subscriptions","organizations_url":"https://api.github.com/users/ddeboer/orgs","repos_url":"https://api.github.com/users/ddeboer/repos","events_url":"https://api.github.com/users/ddeboer/events{/privacy}","received_events_url":"https://api.github.com/users/ddeboer/received_events","type":"User","site_admin":false},"created_at":"2016-08-31T12:37:43Z","updated_at":"2016-08-31T12:37:43Z","body":"You mean Zotonic’s built in pivots (as opposed to custom pivots defined by developers)?"}}
{"actor":{"display_login":"ddeboer"}}