{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/10098","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10098/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10098/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10098/events","html_url":"https://github.com/joomla/joomla-cms/pull/10098","id":151139848,"number":10098,"title":"Address Inconsistency in Database schema","user":{"login":"photodude","id":10253980,"avatar_url":"https://avatars.githubusercontent.com/u/10253980?v=3","gravatar_id":"","url":"https://api.github.com/users/photodude","html_url":"https://github.com/photodude","followers_url":"https://api.github.com/users/photodude/followers","following_url":"https://api.github.com/users/photodude/following{/other_user}","gists_url":"https://api.github.com/users/photodude/gists{/gist_id}","starred_url":"https://api.github.com/users/photodude/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/photodude/subscriptions","organizations_url":"https://api.github.com/users/photodude/orgs","repos_url":"https://api.github.com/users/photodude/repos","events_url":"https://api.github.com/users/photodude/events{/privacy}","received_events_url":"https://api.github.com/users/photodude/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/PR-staging","name":"PR-staging","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2016-04-26T13:47:49Z","updated_at":"2016-05-17T04:02:04Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/10098","html_url":"https://github.com/joomla/joomla-cms/pull/10098","diff_url":"https://github.com/joomla/joomla-cms/pull/10098.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/10098.patch"},"body":"Partial Pull Request for Issue #10077 .\r\n\r\n#### Summary of Changes\r\n- Addresses places where the column schema should have be marked unsigned\r\n- Fixes Inconsistencies in access column (FK to access id)\r\n\r\n#### Testing Instructions\r\nI believe this can be merged by code review\r\n\r\n#### PR todo list\r\n- [x] will need to add update manifest files for the changes\r\n- [x] make consistency changes in the non-MySQL schemas as well"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/219613921","html_url":"https://github.com/joomla/joomla-cms/pull/10098#issuecomment-219613921","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/10098","id":219613921,"user":{"login":"photodude","id":10253980,"avatar_url":"https://avatars.githubusercontent.com/u/10253980?v=3","gravatar_id":"","url":"https://api.github.com/users/photodude","html_url":"https://github.com/photodude","followers_url":"https://api.github.com/users/photodude/followers","following_url":"https://api.github.com/users/photodude/following{/other_user}","gists_url":"https://api.github.com/users/photodude/gists{/gist_id}","starred_url":"https://api.github.com/users/photodude/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/photodude/subscriptions","organizations_url":"https://api.github.com/users/photodude/orgs","repos_url":"https://api.github.com/users/photodude/repos","events_url":"https://api.github.com/users/photodude/events{/privacy}","received_events_url":"https://api.github.com/users/photodude/received_events","type":"User","site_admin":false},"created_at":"2016-05-17T04:02:04Z","updated_at":"2016-05-17T04:02:04Z","body":"@alikon I have attempted to improve the consistency of the postgres database table columns. Your help in checking those changes would be appreciated."}}