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