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