{"action":"created","issue":{"url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/47","labels_url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/47/labels{/name}","comments_url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/47/comments","events_url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/47/events","html_url":"https://github.com/GroundApps/ShoppingList_Backend/issues/47","id":108148457,"number":47,"title":"Unified database layout.","user":{"login":"jklmnn","id":7999005,"avatar_url":"https://avatars.githubusercontent.com/u/7999005?v=3","gravatar_id":"","url":"https://api.github.com/users/jklmnn","html_url":"https://github.com/jklmnn","followers_url":"https://api.github.com/users/jklmnn/followers","following_url":"https://api.github.com/users/jklmnn/following{/other_user}","gists_url":"https://api.github.com/users/jklmnn/gists{/gist_id}","starred_url":"https://api.github.com/users/jklmnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jklmnn/subscriptions","organizations_url":"https://api.github.com/users/jklmnn/orgs","repos_url":"https://api.github.com/users/jklmnn/repos","events_url":"https://api.github.com/users/jklmnn/events{/privacy}","received_events_url":"https://api.github.com/users/jklmnn/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/labels/design%20flaw","name":"design flaw","color":"fbca04"},{"url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/labels/help%20wanted","name":"help wanted","color":"159818"}],"state":"open","locked":false,"assignee":{"login":"jklmnn","id":7999005,"avatar_url":"https://avatars.githubusercontent.com/u/7999005?v=3","gravatar_id":"","url":"https://api.github.com/users/jklmnn","html_url":"https://github.com/jklmnn","followers_url":"https://api.github.com/users/jklmnn/followers","following_url":"https://api.github.com/users/jklmnn/following{/other_user}","gists_url":"https://api.github.com/users/jklmnn/gists{/gist_id}","starred_url":"https://api.github.com/users/jklmnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jklmnn/subscriptions","organizations_url":"https://api.github.com/users/jklmnn/orgs","repos_url":"https://api.github.com/users/jklmnn/repos","events_url":"https://api.github.com/users/jklmnn/events{/privacy}","received_events_url":"https://api.github.com/users/jklmnn/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/milestones/5","html_url":"https://github.com/GroundApps/ShoppingList_Backend/milestones/Version%201.1","labels_url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/milestones/5/labels","id":1320238,"number":5,"title":"Version 1.1","description":"Version 1.1 of the ShoppingList backend.","creator":{"login":"jklmnn","id":7999005,"avatar_url":"https://avatars.githubusercontent.com/u/7999005?v=3","gravatar_id":"","url":"https://api.github.com/users/jklmnn","html_url":"https://github.com/jklmnn","followers_url":"https://api.github.com/users/jklmnn/followers","following_url":"https://api.github.com/users/jklmnn/following{/other_user}","gists_url":"https://api.github.com/users/jklmnn/gists{/gist_id}","starred_url":"https://api.github.com/users/jklmnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jklmnn/subscriptions","organizations_url":"https://api.github.com/users/jklmnn/orgs","repos_url":"https://api.github.com/users/jklmnn/repos","events_url":"https://api.github.com/users/jklmnn/events{/privacy}","received_events_url":"https://api.github.com/users/jklmnn/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":0,"state":"open","created_at":"2015-09-23T12:20:25Z","updated_at":"2015-09-24T15:03:31Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2015-09-24T14:58:38Z","updated_at":"2015-09-25T11:42:12Z","closed_at":null,"body":"While trying to create a pdo abstraction (see #38 ) I noticed that the MySQL and the SQLite databases have different table layouts. That makes it difficult to create an abstraction and would cause much more code that could be avoided.\r\nI would suggest using a unified table layout.\r\nI would use:  \r\nSTRING item PRIMARY INDEX NOT NULL; INT count NOT NULL; BOOL checked NOT NULL;"},"comment":{"url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/comments/143192973","html_url":"https://github.com/GroundApps/ShoppingList_Backend/issues/47#issuecomment-143192973","issue_url":"https://api.github.com/repos/GroundApps/ShoppingList_Backend/issues/47","id":143192973,"user":{"login":"jklmnn","id":7999005,"avatar_url":"https://avatars.githubusercontent.com/u/7999005?v=3","gravatar_id":"","url":"https://api.github.com/users/jklmnn","html_url":"https://github.com/jklmnn","followers_url":"https://api.github.com/users/jklmnn/followers","following_url":"https://api.github.com/users/jklmnn/following{/other_user}","gists_url":"https://api.github.com/users/jklmnn/gists{/gist_id}","starred_url":"https://api.github.com/users/jklmnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jklmnn/subscriptions","organizations_url":"https://api.github.com/users/jklmnn/orgs","repos_url":"https://api.github.com/users/jklmnn/repos","events_url":"https://api.github.com/users/jklmnn/events{/privacy}","received_events_url":"https://api.github.com/users/jklmnn/received_events","type":"User","site_admin":false},"created_at":"2015-09-25T11:42:12Z","updated_at":"2015-09-25T11:42:12Z","body":"I have completed the pdo db connector, so I will close this."}}