Fisheye: Tag f056a91e07a415f6ecbb1037bda4e199caa02607 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20210319.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20210701.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20210701.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20210701.sql (revision f056a91e07a415f6ecbb1037bda4e199caa02607) @@ -0,0 +1,27 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +--LDEV-5155 Add new rating style, rubrics + +ALTER TABLE lams_rating_criteria ADD COLUMN rating_criteria_group_id MEDIUMINT UNSIGNED AFTER rating_criteria_type_id; + +CREATE TABLE lams_rating_rubrics_columns ( + uid INT UNSIGNED AUTO_INCREMENT, + rating_criteria_group_id MEDIUMINT UNSIGNED, + rating_criteria_id BIGINT, + order_id TINYINT UNSIGNED NOT NULL, + name VARCHAR(2000), + PRIMARY KEY (uid), + UNIQUE KEY UQ_lams_rating_rubrics_columns_1 (rating_criteria_group_id, rating_criteria_id, order_id), + CONSTRAINT FK_lams_rating_rubrics_columns_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) + ON DELETE CASCADE ON UPDATE CASCADE +); + +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1;