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