{"action":"created","issue":{"url":"https://api.github.com/repos/DoSomething/gladiator/issues/9","repository_url":"https://api.github.com/repos/DoSomething/gladiator","labels_url":"https://api.github.com/repos/DoSomething/gladiator/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/DoSomething/gladiator/issues/9/comments","events_url":"https://api.github.com/repos/DoSomething/gladiator/issues/9/events","html_url":"https://github.com/DoSomething/gladiator/pull/9","id":134357835,"number":9,"title":"Adding/updating migrations for the database structure.","user":{"login":"weerd","id":105849,"avatar_url":"https://avatars.githubusercontent.com/u/105849?v=3","gravatar_id":"","url":"https://api.github.com/users/weerd","html_url":"https://github.com/weerd","followers_url":"https://api.github.com/users/weerd/followers","following_url":"https://api.github.com/users/weerd/following{/other_user}","gists_url":"https://api.github.com/users/weerd/gists{/gist_id}","starred_url":"https://api.github.com/users/weerd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/weerd/subscriptions","organizations_url":"https://api.github.com/users/weerd/orgs","repos_url":"https://api.github.com/users/weerd/repos","events_url":"https://api.github.com/users/weerd/events{/privacy}","received_events_url":"https://api.github.com/users/weerd/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"angaither","id":645205,"avatar_url":"https://avatars.githubusercontent.com/u/645205?v=3","gravatar_id":"","url":"https://api.github.com/users/angaither","html_url":"https://github.com/angaither","followers_url":"https://api.github.com/users/angaither/followers","following_url":"https://api.github.com/users/angaither/following{/other_user}","gists_url":"https://api.github.com/users/angaither/gists{/gist_id}","starred_url":"https://api.github.com/users/angaither/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angaither/subscriptions","organizations_url":"https://api.github.com/users/angaither/orgs","repos_url":"https://api.github.com/users/angaither/repos","events_url":"https://api.github.com/users/angaither/events{/privacy}","received_events_url":"https://api.github.com/users/angaither/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-02-17T18:18:30Z","updated_at":"2016-02-17T18:31:01Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/DoSomething/gladiator/pulls/9","html_url":"https://github.com/DoSomething/gladiator/pull/9","diff_url":"https://github.com/DoSomething/gladiator/pull/9.diff","patch_url":"https://github.com/DoSomething/gladiator/pull/9.patch"},"body":"Fixes #2\r\n\r\n#### What's this PR do?\r\nThis PR updates/add migrations to setup the database structure that we discussed as a team.\r\n\r\n#### Where should the reviewer start?\r\nCheck out the migrations in the **/database** directory.\r\n\r\n#### How should this be manually tested?\r\nPull down the branch and run `php artisan migrate` and make sure you don't get any errors! If you already had the old migrations setup, make sure to `php artisan migrate:reset` or clear out your database before pulling down the branch!\r\n\r\n#### What are the relevant tickets?\r\n#2 \r\n\r\n#### Questions:\r\nAre there any additional fields that should be treated as `->index()` for lookups, etc? (specifically looking at you @angaither :wink: )\r\n\r\nAlso, apart from the `northstar_id` in the `users` table, should we also have one for `phoenix_id`?\r\n\r\n---\r\n@angaither @sbsmith86 \r\n\r\ncc: @DFurnes @deadlybutter "},"comment":{"url":"https://api.github.com/repos/DoSomething/gladiator/issues/comments/185339403","html_url":"https://github.com/DoSomething/gladiator/pull/9#issuecomment-185339403","issue_url":"https://api.github.com/repos/DoSomething/gladiator/issues/9","id":185339403,"user":{"login":"DFurnes","id":583202,"avatar_url":"https://avatars.githubusercontent.com/u/583202?v=3","gravatar_id":"","url":"https://api.github.com/users/DFurnes","html_url":"https://github.com/DFurnes","followers_url":"https://api.github.com/users/DFurnes/followers","following_url":"https://api.github.com/users/DFurnes/following{/other_user}","gists_url":"https://api.github.com/users/DFurnes/gists{/gist_id}","starred_url":"https://api.github.com/users/DFurnes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DFurnes/subscriptions","organizations_url":"https://api.github.com/users/DFurnes/orgs","repos_url":"https://api.github.com/users/DFurnes/repos","events_url":"https://api.github.com/users/DFurnes/events{/privacy}","received_events_url":"https://api.github.com/users/DFurnes/received_events","type":"User","site_admin":false},"created_at":"2016-02-17T18:31:01Z","updated_at":"2016-02-17T18:31:01Z","body":"Noting an IRL conversation – we should have a pivot table for the `WaitingRoom ↔ User` many-to-many relationship too!"}}