Revize bb5c266f

Re #8471 - Modified scripts and database
- relation between Certificates and CertificateUsages tables on delete 'no action' >> 'cascade'

SQLite_database.sql

@@ -1 +1 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 13.5 		*/
-/*  Created On : 31-b?e-2021 13:28:01 				*/
+/*  Created On : 01-dub-2021 9:21:01 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -66 +66 @@
 	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'certificate_id' INTEGER NULL,
 	'usage_type_id' INTEGER NULL,
-	CONSTRAINT 'FK_Certificates' FOREIGN KEY ('certificate_id') REFERENCES 'Certificates' ('id') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_Certificates' FOREIGN KEY ('certificate_id') REFERENCES 'Certificates' ('id') ON DELETE Cascade ON UPDATE No Action,
 	CONSTRAINT 'FK_UsageTypes' FOREIGN KEY ('usage_type_id') REFERENCES 'UsageTypes' ('id') ON DELETE No Action ON UPDATE No Action
 )
 ;