1
2CREATE TABLE project_differential (
3  upstream_target_id SMALLINT NOT NULL,
4  downstream_target_id SMALLINT NOT NULL,
5  timestamp BIGINT NOT NULL,
6  uuid BINARY(16) NOT NULL,
7  row_index INT NOT NULL,
8  downstream_project VARCHAR(255) NOT NULL,
9  upstream_project VARCHAR(255) NOT NULL,
10  /* Ideally the status field is represented as an int; leaving as string for now for simplified DataStudio usage */
11  status TINYINT NOT NULL,
12  files_changed INT NOT NULL,
13  line_insertions INT NOT NULL,
14  line_deletions INT NOT NULL,
15  line_changes INT NOT NULL,
16  commits_not_upstreamed INT NOT NULL,
17  PRIMARY KEY (upstream_target_id, downstream_target_id, timestamp, uuid, row_index)
18);
19