1CREATE TABLE denormalized_view_recent_commit (
2  upstream_target_id SMALLINT NOT NULL,
3  downstream_target_id SMALLINT NOT NULL,
4  row_index INT NOT NULL,
5  commit_ CHAR(40) NOT NULL,
6  downstream_project VARCHAR(255) NOT NULL,
7  author VARCHAR(255) NOT NULL,
8  subject TEXT 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, row_index),
14  INDEX idx_url_branch (upstream_url, upstream_branch, downstream_url, downstream_branch)
15);
16