/githubarchive_ddl.sql
secret
| CREATE TABLE IF NOT EXISTS githubarchive ( | |
| repository_url TEXT, | |
| repository_has_downloads BOOLEAN, | |
| repository_created_at TEXT, | |
| repository_has_issues BOOLEAN, | |
| repository_description TEXT, | |
| repository_forks INTEGER, | |
| repository_fork TEXT, | |
| repository_has_wiki BOOLEAN, | |
| repository_homepage TEXT, | |
| repository_size INTEGER, | |
| repository_private TEXT, | |
| repository_name TEXT, | |
| repository_owner TEXT, | |
| repository_open_issues INTEGER, | |
| repository_watchers INTEGER, | |
| repository_pushed_at TEXT, | |
| repository_language TEXT, | |
| repository_organization TEXT, | |
| repository_integrate_branch TEXT, | |
| repository_master_branch TEXT, | |
| actor_attributes_gravatar_id TEXT, | |
| actor_attributes_type TEXT, | |
| actor_attributes_login TEXT, | |
| actor_attributes_name TEXT, | |
| actor_attributes_company TEXT, | |
| actor_attributes_location TEXT, | |
| actor_attributes_blog TEXT, | |
| actor_attributes_email TEXT, | |
| created_at TEXT, | |
| public BOOLEAN, | |
| actor TEXT, | |
| payload_head TEXT, | |
| payload_size INTEGER, | |
| payload_ref TEXT, | |
| payload_master_branch TEXT, | |
| payload_ref_type TEXT, | |
| payload_description TEXT, | |
| payload_number INTEGER, | |
| payload_pull_request_head_label TEXT, | |
| payload_pull_request_head_repo_name TEXT, | |
| payload_pull_request_head_repo_master_branch TEXT, | |
| payload_pull_request_head_repo_size INTEGER, | |
| payload_pull_request_head_repo_created_at TEXT, | |
| payload_pull_request_head_repo_has_wiki TEXT, | |
| payload_pull_request_head_repo_clone_url TEXT, | |
| payload_pull_request_head_repo_private TEXT, | |
| payload_pull_request_head_repo_updated_at TEXT, | |
| payload_pull_request_head_repo_watchers INTEGER, | |
| payload_pull_request_head_repo_language TEXT, | |
| payload_pull_request_head_repo_ssh_url TEXT, | |
| payload_pull_request_head_repo_fork BOOLEAN, | |
| payload_pull_request_head_repo_url TEXT, | |
| payload_pull_request_head_repo_git_url TEXT, | |
| payload_pull_request_head_repo_id INTEGER, | |
| payload_pull_request_head_repo_pushed_at TEXT, | |
| payload_pull_request_head_repo_svn_url TEXT, | |
| payload_pull_request_head_repo_open_issues INTEGER, | |
| payload_pull_request_head_repo_mirror_url TEXT, | |
| payload_pull_request_head_repo_has_downloads BOOLEAN, | |
| payload_pull_request_head_repo_homepage TEXT, | |
| payload_pull_request_head_repo_has_issues TEXT, | |
| payload_pull_request_head_repo_forks INTEGER, | |
| payload_pull_request_head_repo_description TEXT, | |
| payload_pull_request_head_repo_html_url TEXT, | |
| payload_pull_request_head_repo_owner_avatar_url TEXT, | |
| payload_pull_request_head_repo_owner_gravatar_id TEXT, | |
| payload_pull_request_head_repo_owner_url TEXT, | |
| payload_pull_request_head_repo_owner_id INTEGER, | |
| payload_pull_request_head_repo_owner_login TEXT, | |
| payload_pull_request_head_sha TEXT, | |
| payload_pull_request_head_ref TEXT, | |
| payload_pull_request_head_user_avatar_url TEXT, | |
| payload_pull_request_head_user_gravatar_id TEXT, | |
| payload_pull_request_head_user_url TEXT, | |
| payload_pull_request_head_user_id INTEGER, | |
| payload_pull_request_head_user_login TEXT, | |
| payload_pull_request_issue_url TEXT, | |
| payload_pull_request_number INTEGER, | |
| payload_pull_request_changed_files INTEGER, | |
| payload_pull_request_merged_by TEXT, | |
| payload_pull_request_merged_by_gravatar_id TEXT, | |
| payload_pull_request_merged_by_avatar_url TEXT, | |
| payload_pull_request_merged_by_url TEXT, | |
| payload_pull_request_merged_by_id INTEGER, | |
| payload_pull_request_merged_by_login TEXT, | |
| payload_pull_request_created_at TEXT, | |
| payload_pull_request_merged TEXT, | |
| payload_pull_request_comments INTEGER, | |
| payload_pull_request_body TEXT, | |
| payload_pull_request_title TEXT, | |
| payload_pull_request_additions INTEGER, | |
| payload_pull_request_diff_url TEXT, | |
| payload_pull_request_updated_at TEXT, | |
| payload_pull_request__links_html_href TEXT, | |
| payload_pull_request__links_self_href TEXT, | |
| payload_pull_request__links_comments_href TEXT, | |
| payload_pull_request__links_review_comments_href TEXT, | |
| payload_pull_request_url TEXT, | |
| payload_pull_request_id INTEGER, | |
| payload_pull_request_patch_url TEXT, | |
| payload_pull_request_mergeable TEXT, | |
| payload_pull_request_merged_at TEXT, | |
| payload_pull_request_closed_at TEXT, | |
| payload_pull_request_commits INTEGER, | |
| payload_pull_request_user_avatar_url TEXT, | |
| payload_pull_request_user_gravatar_id TEXT, | |
| payload_pull_request_user_url TEXT, | |
| payload_pull_request_user_id INTEGER, | |
| payload_pull_request_user_login TEXT, | |
| payload_pull_request_html_url TEXT, | |
| payload_pull_request_deletions INTEGER, | |
| payload_pull_request_review_comments INTEGER, | |
| payload_pull_request_state TEXT, | |
| payload_pull_request_base_label TEXT, | |
| payload_pull_request_base_repo_name TEXT, | |
| payload_pull_request_base_repo_master_branch TEXT, | |
| payload_pull_request_base_repo_size INTEGER, | |
| payload_pull_request_base_repo_created_at TEXT, | |
| payload_pull_request_base_repo_has_wiki TEXT, | |
| payload_pull_request_base_repo_clone_url TEXT, | |
| payload_pull_request_base_repo_private TEXT, | |
| payload_pull_request_base_repo_updated_at TEXT, | |
| payload_pull_request_base_repo_watchers INTEGER, | |
| payload_pull_request_base_repo_language TEXT, | |
| payload_pull_request_base_repo_ssh_url TEXT, | |
| payload_pull_request_base_repo_fork TEXT, | |
| payload_pull_request_base_repo_url TEXT, | |
| payload_pull_request_base_repo_git_url TEXT, | |
| payload_pull_request_base_repo_id INTEGER, | |
| payload_pull_request_base_repo_pushed_at TEXT, | |
| payload_pull_request_base_repo_svn_url TEXT, | |
| payload_pull_request_base_repo_open_issues INTEGER, | |
| payload_pull_request_base_repo_mirror_url TEXT, | |
| payload_pull_request_base_repo_has_downloads BOOLEAN, | |
| payload_pull_request_base_repo_homepage TEXT, | |
| payload_pull_request_base_repo_has_issues TEXT, | |
| payload_pull_request_base_repo_forks INTEGER, | |
| payload_pull_request_base_repo_description TEXT, | |
| payload_pull_request_base_repo_html_url TEXT, | |
| payload_pull_request_base_repo_owner_avatar_url TEXT, | |
| payload_pull_request_base_repo_owner_gravatar_id TEXT, | |
| payload_pull_request_base_repo_owner_url TEXT, | |
| payload_pull_request_base_repo_owner_id INTEGER, | |
| payload_pull_request_base_repo_owner_login TEXT, | |
| payload_pull_request_base_sha TEXT, | |
| payload_pull_request_base_ref TEXT, | |
| payload_pull_request_base_user_avatar_url TEXT, | |
| payload_pull_request_base_user_gravatar_id TEXT, | |
| payload_pull_request_base_user_url TEXT, | |
| payload_pull_request_base_user_id INTEGER, | |
| payload_pull_request_base_user_login TEXT, | |
| payload_action TEXT, | |
| payload_issue INTEGER, | |
| payload_issue_id INTEGER, | |
| payload_comment_id INTEGER, | |
| payload_name TEXT, | |
| payload_url TEXT, | |
| payload_id INTEGER, | |
| payload_desc TEXT, | |
| payload_member_avatar_url TEXT, | |
| payload_member_gravatar_id TEXT, | |
| payload_member_url TEXT, | |
| payload_member_id INTEGER, | |
| payload_member_login TEXT, | |
| payload_commit TEXT, | |
| payload_target_gravatar_id TEXT, | |
| payload_target_followers INTEGER, | |
| payload_target_id INTEGER, | |
| payload_target_repos INTEGER, | |
| payload_target_login TEXT, | |
| payload_comment_commit_id TEXT, | |
| payload_comment_updated_at TEXT, | |
| payload_comment_created_at TEXT, | |
| payload_comment_path TEXT, | |
| payload_comment_user_id INTEGER, | |
| payload_comment_user_avatar_url TEXT, | |
| payload_comment_user_url TEXT, | |
| payload_comment_user_login TEXT, | |
| payload_comment_user_gravatar_id TEXT, | |
| payload_comment_position INTEGER, | |
| payload_comment_url TEXT, | |
| payload_comment_body TEXT, | |
| payload_comment_original_commit_id TEXT, | |
| payload_comment_original_position INTEGER, | |
| payload_after TEXT, | |
| payload_before TEXT, | |
| payload_commit_id TEXT, | |
| payload_commit_email TEXT, | |
| payload_commit_msg TEXT, | |
| payload_commit_name TEXT, | |
| payload_commit_flag TEXT, | |
| payload_page_sha TEXT, | |
| payload_page_title TEXT, | |
| payload_page_action TEXT, | |
| payload_page_page_name TEXT, | |
| payload_page_summary TEXT, | |
| payload_page_html_url TEXT, | |
| url TEXT, | |
| type TEXT | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment