{"action":"created","comment":{"url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/comments/42198541","id":42198541,"diff_hunk":"@@ -0,0 +1,66 @@\n+class CreateDiscussionsAndForums < ActiveRecord::Migration\n+  def change\n+    create_table :course_discussion_topics do |t|\n+      t.actable\n+    end\n+\n+    create_table :course_discussion_posts do |t|\n+      t.integer :parent_id\n+      t.belongs_to :topic, null: false, foreign_key: { references: :course_discussion_topics }\n+      t.string :title, null: false\n+      t.text :text\n+\n+      t.userstamps null: false, foreign_key: { references: :users }\n+      t.timestamps null: false\n+    end\n+\n+    create_table :course_discussion_topic_subscriptions do |t|\n+      t.references :topic, null: false, foreign_key: { references: :course_discussion_topics }\n+      t.references :user, null: false, foreign_key: true\n+    end\n+\n+    add_index :course_discussion_topic_subscriptions, [:topic_id, :user_id],\n+              unique: true, name: :index_topic_subscriptions_on_topic_id_and_user_id\n+\n+    create_table :course_forums do |t|\n+      t.references :course, null: false\n+      t.string :name, null: false\n+      t.string :slug\n+      t.text :description\n+\n+      t.userstamps null: false, foreign_key: { references: :users }\n+      t.timestamps null: false\n+    end\n+\n+    add_index :course_forums, [:course_id, :name], unique: true\n+    add_index :course_forums, :slug, unique: true\n+\n+    create_table :course_forum_topics do |t|\n+      t.belongs_to :forum, null: false, foreign_key: { references: :course_forums }\n+      t.string :title, null: false\n+      t.string :slug","path":"db/migrate/20150918094007_create_discussions_and_forums.rb","position":41,"original_position":41,"commit_id":"52439031b739e7ca96b99772c6fe54a27ca4b2f3","original_commit_id":"52439031b739e7ca96b99772c6fe54a27ca4b2f3","user":{"login":"lowjoel","id":2505070,"avatar_url":"https://avatars.githubusercontent.com/u/2505070?v=3","gravatar_id":"","url":"https://api.github.com/users/lowjoel","html_url":"https://github.com/lowjoel","followers_url":"https://api.github.com/users/lowjoel/followers","following_url":"https://api.github.com/users/lowjoel/following{/other_user}","gists_url":"https://api.github.com/users/lowjoel/gists{/gist_id}","starred_url":"https://api.github.com/users/lowjoel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lowjoel/subscriptions","organizations_url":"https://api.github.com/users/lowjoel/orgs","repos_url":"https://api.github.com/users/lowjoel/repos","events_url":"https://api.github.com/users/lowjoel/events{/privacy}","received_events_url":"https://api.github.com/users/lowjoel/received_events","type":"User","site_admin":false},"body":"index: :unique then remove the explicit index after create_table.","created_at":"2015-10-16T00:35:22Z","updated_at":"2015-10-16T00:35:22Z","html_url":"https://github.com/Coursemology/coursemology2/pull/497#discussion_r42198541","pull_request_url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497","_links":{"self":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/comments/42198541"},"html":{"href":"https://github.com/Coursemology/coursemology2/pull/497#discussion_r42198541"},"pull_request":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497"}}},"pull_request":{"url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497","id":45739645,"html_url":"https://github.com/Coursemology/coursemology2/pull/497","diff_url":"https://github.com/Coursemology/coursemology2/pull/497.diff","patch_url":"https://github.com/Coursemology/coursemology2/pull/497.patch","issue_url":"https://api.github.com/repos/Coursemology/coursemology2/issues/497","number":497,"state":"open","locked":false,"title":"Discussion and Forum related models","user":{"login":"xzhflying","id":8858295,"avatar_url":"https://avatars.githubusercontent.com/u/8858295?v=3","gravatar_id":"","url":"https://api.github.com/users/xzhflying","html_url":"https://github.com/xzhflying","followers_url":"https://api.github.com/users/xzhflying/followers","following_url":"https://api.github.com/users/xzhflying/following{/other_user}","gists_url":"https://api.github.com/users/xzhflying/gists{/gist_id}","starred_url":"https://api.github.com/users/xzhflying/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xzhflying/subscriptions","organizations_url":"https://api.github.com/users/xzhflying/orgs","repos_url":"https://api.github.com/users/xzhflying/repos","events_url":"https://api.github.com/users/xzhflying/events{/privacy}","received_events_url":"https://api.github.com/users/xzhflying/received_events","type":"User","site_admin":false},"body":"Discussion\r\n---\r\n* Add Post model for comments\r\n* Add Topic model for commentable topics\r\n* Add Topic::Subscription model for the subscriptions on topics\r\n\r\nForum\r\n---\r\n* Add Forum model for course forums\r\n* Add ForumSubscription model for users' subscriptions on forums\r\n* Add ForumTopic model for forums' topics\r\n* Add ForumTopicView model for view record","created_at":"2015-09-23T02:54:13Z","updated_at":"2015-10-16T00:35:22Z","closed_at":null,"merged_at":null,"merge_commit_sha":"fb7982d0bfe0f1967a4404bff0e708b6d81a1dda","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497/commits","review_comments_url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497/comments","review_comment_url":"https://api.github.com/repos/Coursemology/coursemology2/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Coursemology/coursemology2/issues/497/comments","statuses_url":"https://api.github.com/repos/Coursemology/coursemology2/statuses/52439031b739e7ca96b99772c6fe54a27ca4b2f3","head":{"label":"xzhflying:forum_model","ref":"forum_model","sha":"52439031b739e7ca96b99772c6fe54a27ca4b2f3","user":{"login":"xzhflying","id":8858295,"avatar_url":"https://avatars.githubusercontent.com/u/8858295?v=3","gravatar_id":"","url":"https://api.github.com/users/xzhflying","html_url":"https://github.com/xzhflying","followers_url":"https://api.github.com/users/xzhflying/followers","following_url":"https://api.github.com/users/xzhflying/following{/other_user}","gists_url":"https://api.github.com/users/xzhflying/gists{/gist_id}","starred_url":"https://api.github.com/users/xzhflying/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xzhflying/subscriptions","organizations_url":"https://api.github.com/users/xzhflying/orgs","repos_url":"https://api.github.com/users/xzhflying/repos","events_url":"https://api.github.com/users/xzhflying/events{/privacy}","received_events_url":"https://api.github.com/users/xzhflying/received_events","type":"User","site_admin":false},"repo":{"id":31704878,"name":"coursemology2","full_name":"xzhflying/coursemology2","owner":{"login":"xzhflying","id":8858295,"avatar_url":"https://avatars.githubusercontent.com/u/8858295?v=3","gravatar_id":"","url":"https://api.github.com/users/xzhflying","html_url":"https://github.com/xzhflying","followers_url":"https://api.github.com/users/xzhflying/followers","following_url":"https://api.github.com/users/xzhflying/following{/other_user}","gists_url":"https://api.github.com/users/xzhflying/gists{/gist_id}","starred_url":"https://api.github.com/users/xzhflying/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xzhflying/subscriptions","organizations_url":"https://api.github.com/users/xzhflying/orgs","repos_url":"https://api.github.com/users/xzhflying/repos","events_url":"https://api.github.com/users/xzhflying/events{/privacy}","received_events_url":"https://api.github.com/users/xzhflying/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/xzhflying/coursemology2","description":"Rails 4 re-write of Coursemology","fork":true,"url":"https://api.github.com/repos/xzhflying/coursemology2","forks_url":"https://api.github.com/repos/xzhflying/coursemology2/forks","keys_url":"https://api.github.com/repos/xzhflying/coursemology2/keys{/key_id}","collaborators_url":"https://api.github.com/repos/xzhflying/coursemology2/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/xzhflying/coursemology2/teams","hooks_url":"https://api.github.com/repos/xzhflying/coursemology2/hooks","issue_events_url":"https://api.github.com/repos/xzhflying/coursemology2/issues/events{/number}","events_url":"https://api.github.com/repos/xzhflying/coursemology2/events","assignees_url":"https://api.github.com/repos/xzhflying/coursemology2/assignees{/user}","branches_url":"https://api.github.com/repos/xzhflying/coursemology2/branches{/branch}","tags_url":"https://api.github.com/repos/xzhflying/coursemology2/tags","blobs_url":"https://api.github.com/repos/xzhflying/coursemology2/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/xzhflying/coursemology2/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/xzhflying/coursemology2/git/refs{/sha}","trees_url":"https://api.github.com/repos/xzhflying/coursemology2/git/trees{/sha}","statuses_url":"https://api.github.com/repos/xzhflying/coursemology2/statuses/{sha}","languages_url":"https://api.github.com/repos/xzhflying/coursemology2/languages","stargazers_url":"https://api.github.com/repos/xzhflying/coursemology2/stargazers","contributors_url":"https://api.github.com/repos/xzhflying/coursemology2/contributors","subscribers_url":"https://api.github.com/repos/xzhflying/coursemology2/subscribers","subscription_url":"https://api.github.com/repos/xzhflying/coursemology2/subscription","commits_url":"https://api.github.com/repos/xzhflying/coursemology2/commits{/sha}","git_commits_url":"https://api.github.com/repos/xzhflying/coursemology2/git/commits{/sha}","comments_url":"https://api.github.com/repos/xzhflying/coursemology2/comments{/number}","issue_comment_url":"https://api.github.com/repos/xzhflying/coursemology2/issues/comments{/number}","contents_url":"https://api.github.com/repos/xzhflying/coursemology2/contents/{+path}","compare_url":"https://api.github.com/repos/xzhflying/coursemology2/compare/{base}...{head}","merges_url":"https://api.github.com/repos/xzhflying/coursemology2/merges","archive_url":"https://api.github.com/repos/xzhflying/coursemology2/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/xzhflying/coursemology2/downloads","issues_url":"https://api.github.com/repos/xzhflying/coursemology2/issues{/number}","pulls_url":"https://api.github.com/repos/xzhflying/coursemology2/pulls{/number}","milestones_url":"https://api.github.com/repos/xzhflying/coursemology2/milestones{/number}","notifications_url":"https://api.github.com/repos/xzhflying/coursemology2/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/xzhflying/coursemology2/labels{/name}","releases_url":"https://api.github.com/repos/xzhflying/coursemology2/releases{/id}","created_at":"2015-03-05T09:01:00Z","updated_at":"2015-03-30T12:53:21Z","pushed_at":"2015-10-15T03:04:08Z","git_url":"git://github.com/xzhflying/coursemology2.git","ssh_url":"git@github.com:xzhflying/coursemology2.git","clone_url":"https://github.com/xzhflying/coursemology2.git","svn_url":"https://github.com/xzhflying/coursemology2","homepage":null,"size":1985,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"Coursemology:master","ref":"master","sha":"f3c84b37d9867869132947d10e4d4dafc4a504bd","user":{"login":"Coursemology","id":4427741,"avatar_url":"https://avatars.githubusercontent.com/u/4427741?v=3","gravatar_id":"","url":"https://api.github.com/users/Coursemology","html_url":"https://github.com/Coursemology","followers_url":"https://api.github.com/users/Coursemology/followers","following_url":"https://api.github.com/users/Coursemology/following{/other_user}","gists_url":"https://api.github.com/users/Coursemology/gists{/gist_id}","starred_url":"https://api.github.com/users/Coursemology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Coursemology/subscriptions","organizations_url":"https://api.github.com/users/Coursemology/orgs","repos_url":"https://api.github.com/users/Coursemology/repos","events_url":"https://api.github.com/users/Coursemology/events{/privacy}","received_events_url":"https://api.github.com/users/Coursemology/received_events","type":"Organization","site_admin":false},"repo":{"id":22155032,"name":"coursemology2","full_name":"Coursemology/coursemology2","owner":{"login":"Coursemology","id":4427741,"avatar_url":"https://avatars.githubusercontent.com/u/4427741?v=3","gravatar_id":"","url":"https://api.github.com/users/Coursemology","html_url":"https://github.com/Coursemology","followers_url":"https://api.github.com/users/Coursemology/followers","following_url":"https://api.github.com/users/Coursemology/following{/other_user}","gists_url":"https://api.github.com/users/Coursemology/gists{/gist_id}","starred_url":"https://api.github.com/users/Coursemology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Coursemology/subscriptions","organizations_url":"https://api.github.com/users/Coursemology/orgs","repos_url":"https://api.github.com/users/Coursemology/repos","events_url":"https://api.github.com/users/Coursemology/events{/privacy}","received_events_url":"https://api.github.com/users/Coursemology/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Coursemology/coursemology2","description":"Rails 4 re-write of Coursemology","fork":false,"url":"https://api.github.com/repos/Coursemology/coursemology2","forks_url":"https://api.github.com/repos/Coursemology/coursemology2/forks","keys_url":"https://api.github.com/repos/Coursemology/coursemology2/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Coursemology/coursemology2/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Coursemology/coursemology2/teams","hooks_url":"https://api.github.com/repos/Coursemology/coursemology2/hooks","issue_events_url":"https://api.github.com/repos/Coursemology/coursemology2/issues/events{/number}","events_url":"https://api.github.com/repos/Coursemology/coursemology2/events","assignees_url":"https://api.github.com/repos/Coursemology/coursemology2/assignees{/user}","branches_url":"https://api.github.com/repos/Coursemology/coursemology2/branches{/branch}","tags_url":"https://api.github.com/repos/Coursemology/coursemology2/tags","blobs_url":"https://api.github.com/repos/Coursemology/coursemology2/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Coursemology/coursemology2/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Coursemology/coursemology2/git/refs{/sha}","trees_url":"https://api.github.com/repos/Coursemology/coursemology2/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Coursemology/coursemology2/statuses/{sha}","languages_url":"https://api.github.com/repos/Coursemology/coursemology2/languages","stargazers_url":"https://api.github.com/repos/Coursemology/coursemology2/stargazers","contributors_url":"https://api.github.com/repos/Coursemology/coursemology2/contributors","subscribers_url":"https://api.github.com/repos/Coursemology/coursemology2/subscribers","subscription_url":"https://api.github.com/repos/Coursemology/coursemology2/subscription","commits_url":"https://api.github.com/repos/Coursemology/coursemology2/commits{/sha}","git_commits_url":"https://api.github.com/repos/Coursemology/coursemology2/git/commits{/sha}","comments_url":"https://api.github.com/repos/Coursemology/coursemology2/comments{/number}","issue_comment_url":"https://api.github.com/repos/Coursemology/coursemology2/issues/comments{/number}","contents_url":"https://api.github.com/repos/Coursemology/coursemology2/contents/{+path}","compare_url":"https://api.github.com/repos/Coursemology/coursemology2/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Coursemology/coursemology2/merges","archive_url":"https://api.github.com/repos/Coursemology/coursemology2/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Coursemology/coursemology2/downloads","issues_url":"https://api.github.com/repos/Coursemology/coursemology2/issues{/number}","pulls_url":"https://api.github.com/repos/Coursemology/coursemology2/pulls{/number}","milestones_url":"https://api.github.com/repos/Coursemology/coursemology2/milestones{/number}","notifications_url":"https://api.github.com/repos/Coursemology/coursemology2/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Coursemology/coursemology2/labels{/name}","releases_url":"https://api.github.com/repos/Coursemology/coursemology2/releases{/id}","created_at":"2014-07-23T14:57:06Z","updated_at":"2015-07-29T08:51:36Z","pushed_at":"2015-10-16T00:30:55Z","git_url":"git://github.com/Coursemology/coursemology2.git","ssh_url":"git@github.com:Coursemology/coursemology2.git","clone_url":"https://github.com/Coursemology/coursemology2.git","svn_url":"https://github.com/Coursemology/coursemology2","homepage":null,"size":6702,"stargazers_count":13,"watchers_count":13,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":12,"mirror_url":null,"open_issues_count":44,"forks":12,"open_issues":44,"watchers":13,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497"},"html":{"href":"https://github.com/Coursemology/coursemology2/pull/497"},"issue":{"href":"https://api.github.com/repos/Coursemology/coursemology2/issues/497"},"comments":{"href":"https://api.github.com/repos/Coursemology/coursemology2/issues/497/comments"},"review_comments":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497/comments"},"review_comment":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Coursemology/coursemology2/pulls/497/commits"},"statuses":{"href":"https://api.github.com/repos/Coursemology/coursemology2/statuses/52439031b739e7ca96b99772c6fe54a27ca4b2f3"}}}}