1CREATE TABLE denormalized_view_top_committer (
2  upstream_target_id SMALLINT NOT NULL,
3  downstream_target_id SMALLINT NOT NULL,
4  surrogate_id INT NOT NULL,
5  committer VARCHAR(255) NOT NULL,
6  commits INT NOT NULL,
7  line_changes INT NOT NULL,
8  tech_area VARCHAR(255) NOT NULL,
9  upstream_url VARCHAR(255) NOT NULL,
10  upstream_branch VARCHAR(255) NOT NULL,
11  downstream_url VARCHAR(255) NOT NULL,
12  downstream_branch VARCHAR(255) NOT NULL,
13  PRIMARY KEY(upstream_target_id, downstream_target_id, surrogate_id),
14  INDEX idx_url_branch_commits (upstream_url, upstream_branch, downstream_url, downstream_branch, commits),
15  INDEX idx_url_branch_lines (upstream_url, upstream_branch, downstream_url, downstream_branch, line_changes)
16);
17