1CREATE TABLE denormalized_view_changes_over_time (
2  upstream_target_id SMALLINT NOT NULL,
3  downstream_target_id SMALLINT NOT NULL,
4  datastudio_datetime CHAR(10) NOT NULL,
5  modified_projects INT NOT NULL,
6  line_changes INT NOT NULL,
7  files_changed INT NOT NULL,
8  upstream_url VARCHAR(255) NOT NULL,
9  upstream_branch VARCHAR(255) NOT NULL,
10  downstream_url VARCHAR(255) NOT NULL,
11  downstream_branch VARCHAR(255) NOT NULL,
12  PRIMARY KEY(upstream_target_id, downstream_target_id, datastudio_datetime),
13  INDEX idx_url_branch (upstream_url, upstream_branch, downstream_url, downstream_branch)
14);
15