Merge pull request #1082 from fosslight/develop

Bug fix in migration script
fosslight · Sep 27, 2024 · b51a326 · b51a326
2 parents 97fa29c + 8e24290
commit b51a326
Showing 1 changed file with 3 additions and 3 deletions.
diff --git a/migration/migration/scripts/20240725150921_update_v2.0.0.sql b/migration/migration/scripts/20240725150921_update_v2.0.0.sql
@@ -284,11 +284,11 @@ UPDATE T2_CODE_DTL SET CD_DTL_EXP='SELECT RTN.OSS_ID, RTN.OSS_NAME, RTN.OSS_VERS
 ALTER TABLE `OSS_VERSION` ADD UNIQUE INDEX `OSS_COMMON_ID_OSS_VERSION` (`OSS_COMMON_ID`, `OSS_VERSION`);
 
 -- MODIFY CONSTRAINT
-ALTER TABLE `OSS_LICENSE_DECLARED` DROP CONSTRAINT `OSS_LICENSE_DECLARED_ibfk_2`;
-ALTER TABLE `OSS_LICENSE_DECLARED` ADD CONSTRAINT `OSS_LICENSE_DECLARED_ibfk_2` FOREIGN KEY (`OSS_ID`) REFERENCES `OSS_VERSION` (`OSS_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+ALTER TABLE `OSS_LICENSE_DECLARED` DROP CONSTRAINT `fk_OSS_LICENSE_OSS_MASTER1`;
+ALTER TABLE `OSS_LICENSE_DECLARED` ADD CONSTRAINT `fk_OSS_LICENSE_OSS_MASTER1` FOREIGN KEY (`OSS_ID`) REFERENCES `OSS_VERSION` (`OSS_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 ALTER TABLE `OSS_LICENSE_DETECTED` DROP CONSTRAINT `fk_OSS_LICENSE_DETECTED_OSS_ID`;
 ALTER TABLE `OSS_LICENSE_DETECTED` ADD CONSTRAINT `fk_OSS_LICENSE_DETECTED_OSS_ID` FOREIGN KEY (`OSS_ID`) REFERENCES `OSS_VERSION` (`OSS_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
 ALTER TABLE `PROJECT_MASTER`
     ADD `VULNERABILITY_RESOLUTION` varchar(50) DEFAULT NULL,
-    ADD `CVSS_SCORE_MAX` varchar(20) DEFAULT NULL;
+    ADD `CVSS_SCORE_MAX` varchar(20) DEFAULT NULL;