{"action":"created","comment":{"url":"https://api.github.com/repos/edx/edx-documentation/pulls/comments/64227846","id":64227846,"diff_hunk":"@@ -1139,6 +1139,8 @@ self-reported language preferences. Learners can select only one value.\n | code            | varchar(16) | NO   | MUL | NULL    |                |\n +-----------------+-------------+------+-----+---------+----------------+\n \n+.. ^^Olga, by default the language dropdown on the profile page is not filled and is blank. is there a code for that setting, or is the last line of this table incorrect and the code field can be Null?","path":"en_us/data/source/internal_data_formats/sql_schema.rst","position":114,"original_position":114,"commit_id":"40522a4f39dba3e07cfc836e3cc44bede4d6085a","original_commit_id":"40522a4f39dba3e07cfc836e3cc44bede4d6085a","user":{"login":"stroilova","id":3066223,"avatar_url":"https://avatars.githubusercontent.com/u/3066223?v=3","gravatar_id":"","url":"https://api.github.com/users/stroilova","html_url":"https://github.com/stroilova","followers_url":"https://api.github.com/users/stroilova/followers","following_url":"https://api.github.com/users/stroilova/following{/other_user}","gists_url":"https://api.github.com/users/stroilova/gists{/gist_id}","starred_url":"https://api.github.com/users/stroilova/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stroilova/subscriptions","organizations_url":"https://api.github.com/users/stroilova/orgs","repos_url":"https://api.github.com/users/stroilova/repos","events_url":"https://api.github.com/users/stroilova/events{/privacy}","received_events_url":"https://api.github.com/users/stroilova/received_events","type":"User","site_admin":false},"body":"@lamagnifica I'm not seeing either blanks or NULLS in the student_languageproficiency table. \r\n\r\nPerhaps if no language preference is selected, the student just does not get a row in the table?\r\nWe'd need to confirm with the Dev team to be sure.\r\n\r\n@nasthagiri  (or someone else from TNL) - does that sound right? Thanks.","created_at":"2016-05-23T14:04:39Z","updated_at":"2016-05-23T14:04:39Z","html_url":"https://github.com/edx/edx-documentation/pull/1038#discussion_r64227846","pull_request_url":"https://api.github.com/repos/edx/edx-documentation/pulls/1038","_links":{"self":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/comments/64227846"},"html":{"href":"https://github.com/edx/edx-documentation/pull/1038#discussion_r64227846"},"pull_request":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/1038"}}},"pull_request":{"url":"https://api.github.com/repos/edx/edx-documentation/pulls/1038","id":70949414,"html_url":"https://github.com/edx/edx-documentation/pull/1038","diff_url":"https://github.com/edx/edx-documentation/pull/1038.diff","patch_url":"https://github.com/edx/edx-documentation/pull/1038.patch","issue_url":"https://api.github.com/repos/edx/edx-documentation/issues/1038","number":1038,"state":"open","locked":false,"title":"Adds three tables to the package list","user":{"login":"lamagnifica","id":6392274,"avatar_url":"https://avatars.githubusercontent.com/u/6392274?v=3","gravatar_id":"","url":"https://api.github.com/users/lamagnifica","html_url":"https://github.com/lamagnifica","followers_url":"https://api.github.com/users/lamagnifica/followers","following_url":"https://api.github.com/users/lamagnifica/following{/other_user}","gists_url":"https://api.github.com/users/lamagnifica/gists{/gist_id}","starred_url":"https://api.github.com/users/lamagnifica/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lamagnifica/subscriptions","organizations_url":"https://api.github.com/users/lamagnifica/orgs","repos_url":"https://api.github.com/users/lamagnifica/repos","events_url":"https://api.github.com/users/lamagnifica/events{/privacy}","received_events_url":"https://api.github.com/users/lamagnifica/received_events","type":"User","site_admin":false},"body":"\r\n## [DOC-2964](https://openedx.atlassian.net/browse/DOC-2964)\r\n\r\nThe list of files included in the compressed data package got stale over time. This PR updates the list in package.rst. Then, I got carried away and cleaned up some inconsistent date formatting in the sql_schema.rst file.\r\n\r\n### Reviewers\r\n\r\nPossible roles follow. PR submitter checks the boxes after each reviewer finishes and gives :+1:. \r\n\r\n- [ ] Subject matter expert: @stroilova \r\n- [ ] Doc team review (sanity check): @srpearce or @pdesjardins  \r\n\r\n### Testing\r\n\r\n- [x] Ran ./run_tests.sh without warnings or errors\r\n\r\n### Post-review\r\n\r\n- [ ] Squash commits","created_at":"2016-05-21T13:23:07Z","updated_at":"2016-05-23T14:04:39Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2b2126e03144dfc39aff59d6a48e40c46ecad89c","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/edx/edx-documentation/pulls/1038/commits","review_comments_url":"https://api.github.com/repos/edx/edx-documentation/pulls/1038/comments","review_comment_url":"https://api.github.com/repos/edx/edx-documentation/pulls/comments{/number}","comments_url":"https://api.github.com/repos/edx/edx-documentation/issues/1038/comments","statuses_url":"https://api.github.com/repos/edx/edx-documentation/statuses/40522a4f39dba3e07cfc836e3cc44bede4d6085a","head":{"label":"edx:ahodges/DOC-2964","ref":"ahodges/DOC-2964","sha":"40522a4f39dba3e07cfc836e3cc44bede4d6085a","user":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"repo":{"id":23839256,"name":"edx-documentation","full_name":"edx/edx-documentation","owner":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/edx/edx-documentation","description":"For published versions of the edX documentation, visit:","fork":false,"url":"https://api.github.com/repos/edx/edx-documentation","forks_url":"https://api.github.com/repos/edx/edx-documentation/forks","keys_url":"https://api.github.com/repos/edx/edx-documentation/keys{/key_id}","collaborators_url":"https://api.github.com/repos/edx/edx-documentation/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/edx/edx-documentation/teams","hooks_url":"https://api.github.com/repos/edx/edx-documentation/hooks","issue_events_url":"https://api.github.com/repos/edx/edx-documentation/issues/events{/number}","events_url":"https://api.github.com/repos/edx/edx-documentation/events","assignees_url":"https://api.github.com/repos/edx/edx-documentation/assignees{/user}","branches_url":"https://api.github.com/repos/edx/edx-documentation/branches{/branch}","tags_url":"https://api.github.com/repos/edx/edx-documentation/tags","blobs_url":"https://api.github.com/repos/edx/edx-documentation/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/edx/edx-documentation/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/edx/edx-documentation/git/refs{/sha}","trees_url":"https://api.github.com/repos/edx/edx-documentation/git/trees{/sha}","statuses_url":"https://api.github.com/repos/edx/edx-documentation/statuses/{sha}","languages_url":"https://api.github.com/repos/edx/edx-documentation/languages","stargazers_url":"https://api.github.com/repos/edx/edx-documentation/stargazers","contributors_url":"https://api.github.com/repos/edx/edx-documentation/contributors","subscribers_url":"https://api.github.com/repos/edx/edx-documentation/subscribers","subscription_url":"https://api.github.com/repos/edx/edx-documentation/subscription","commits_url":"https://api.github.com/repos/edx/edx-documentation/commits{/sha}","git_commits_url":"https://api.github.com/repos/edx/edx-documentation/git/commits{/sha}","comments_url":"https://api.github.com/repos/edx/edx-documentation/comments{/number}","issue_comment_url":"https://api.github.com/repos/edx/edx-documentation/issues/comments{/number}","contents_url":"https://api.github.com/repos/edx/edx-documentation/contents/{+path}","compare_url":"https://api.github.com/repos/edx/edx-documentation/compare/{base}...{head}","merges_url":"https://api.github.com/repos/edx/edx-documentation/merges","archive_url":"https://api.github.com/repos/edx/edx-documentation/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/edx/edx-documentation/downloads","issues_url":"https://api.github.com/repos/edx/edx-documentation/issues{/number}","pulls_url":"https://api.github.com/repos/edx/edx-documentation/pulls{/number}","milestones_url":"https://api.github.com/repos/edx/edx-documentation/milestones{/number}","notifications_url":"https://api.github.com/repos/edx/edx-documentation/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/edx/edx-documentation/labels{/name}","releases_url":"https://api.github.com/repos/edx/edx-documentation/releases{/id}","deployments_url":"https://api.github.com/repos/edx/edx-documentation/deployments","created_at":"2014-09-09T15:29:04Z","updated_at":"2016-05-20T16:06:43Z","pushed_at":"2016-05-23T14:01:55Z","git_url":"git://github.com/edx/edx-documentation.git","ssh_url":"git@github.com:edx/edx-documentation.git","clone_url":"https://github.com/edx/edx-documentation.git","svn_url":"https://github.com/edx/edx-documentation","homepage":" http://docs.edx.org","size":103508,"stargazers_count":39,"watchers_count":39,"language":"Makefile","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":133,"mirror_url":null,"open_issues_count":22,"forks":133,"open_issues":22,"watchers":39,"default_branch":"master"}},"base":{"label":"edx:master","ref":"master","sha":"39a937e77c427663b767a310ef2515ff6d43966c","user":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"repo":{"id":23839256,"name":"edx-documentation","full_name":"edx/edx-documentation","owner":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/edx/edx-documentation","description":"For published versions of the edX documentation, visit:","fork":false,"url":"https://api.github.com/repos/edx/edx-documentation","forks_url":"https://api.github.com/repos/edx/edx-documentation/forks","keys_url":"https://api.github.com/repos/edx/edx-documentation/keys{/key_id}","collaborators_url":"https://api.github.com/repos/edx/edx-documentation/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/edx/edx-documentation/teams","hooks_url":"https://api.github.com/repos/edx/edx-documentation/hooks","issue_events_url":"https://api.github.com/repos/edx/edx-documentation/issues/events{/number}","events_url":"https://api.github.com/repos/edx/edx-documentation/events","assignees_url":"https://api.github.com/repos/edx/edx-documentation/assignees{/user}","branches_url":"https://api.github.com/repos/edx/edx-documentation/branches{/branch}","tags_url":"https://api.github.com/repos/edx/edx-documentation/tags","blobs_url":"https://api.github.com/repos/edx/edx-documentation/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/edx/edx-documentation/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/edx/edx-documentation/git/refs{/sha}","trees_url":"https://api.github.com/repos/edx/edx-documentation/git/trees{/sha}","statuses_url":"https://api.github.com/repos/edx/edx-documentation/statuses/{sha}","languages_url":"https://api.github.com/repos/edx/edx-documentation/languages","stargazers_url":"https://api.github.com/repos/edx/edx-documentation/stargazers","contributors_url":"https://api.github.com/repos/edx/edx-documentation/contributors","subscribers_url":"https://api.github.com/repos/edx/edx-documentation/subscribers","subscription_url":"https://api.github.com/repos/edx/edx-documentation/subscription","commits_url":"https://api.github.com/repos/edx/edx-documentation/commits{/sha}","git_commits_url":"https://api.github.com/repos/edx/edx-documentation/git/commits{/sha}","comments_url":"https://api.github.com/repos/edx/edx-documentation/comments{/number}","issue_comment_url":"https://api.github.com/repos/edx/edx-documentation/issues/comments{/number}","contents_url":"https://api.github.com/repos/edx/edx-documentation/contents/{+path}","compare_url":"https://api.github.com/repos/edx/edx-documentation/compare/{base}...{head}","merges_url":"https://api.github.com/repos/edx/edx-documentation/merges","archive_url":"https://api.github.com/repos/edx/edx-documentation/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/edx/edx-documentation/downloads","issues_url":"https://api.github.com/repos/edx/edx-documentation/issues{/number}","pulls_url":"https://api.github.com/repos/edx/edx-documentation/pulls{/number}","milestones_url":"https://api.github.com/repos/edx/edx-documentation/milestones{/number}","notifications_url":"https://api.github.com/repos/edx/edx-documentation/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/edx/edx-documentation/labels{/name}","releases_url":"https://api.github.com/repos/edx/edx-documentation/releases{/id}","deployments_url":"https://api.github.com/repos/edx/edx-documentation/deployments","created_at":"2014-09-09T15:29:04Z","updated_at":"2016-05-20T16:06:43Z","pushed_at":"2016-05-23T14:01:55Z","git_url":"git://github.com/edx/edx-documentation.git","ssh_url":"git@github.com:edx/edx-documentation.git","clone_url":"https://github.com/edx/edx-documentation.git","svn_url":"https://github.com/edx/edx-documentation","homepage":" http://docs.edx.org","size":103508,"stargazers_count":39,"watchers_count":39,"language":"Makefile","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":133,"mirror_url":null,"open_issues_count":22,"forks":133,"open_issues":22,"watchers":39,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/1038"},"html":{"href":"https://github.com/edx/edx-documentation/pull/1038"},"issue":{"href":"https://api.github.com/repos/edx/edx-documentation/issues/1038"},"comments":{"href":"https://api.github.com/repos/edx/edx-documentation/issues/1038/comments"},"review_comments":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/1038/comments"},"review_comment":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/edx/edx-documentation/pulls/1038/commits"},"statuses":{"href":"https://api.github.com/repos/edx/edx-documentation/statuses/40522a4f39dba3e07cfc836e3cc44bede4d6085a"}}}}
{"actor":{"display_login":"stroilova"}}