-
-
Save cwsteinbach/0103c55276e85a2c4ed8 to your computer and use it in GitHub Desktop.
GithubArchive schema for ZFS compression performance tests.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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