Revize 1036d66a

Re: #8471 - Modified database
- password can be null
- FKs in CertificateUsages can not be null

SQLite_database.sql

@@ -1 +1 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 13.5 		*/
-/*  Created On : 01-dub-2021 9:21:01 				*/
+/*  Created On : 01-dub-2021 15:16:53 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -18 +18 @@
 DROP TABLE IF EXISTS 'Certificates'
 ;
 
-DROP TABLE IF EXISTS 'CertificatesUsages'
+DROP TABLE IF EXISTS 'CertificateUsages'
 ;
 
 /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */
@@ -27 +27 @@
 (
 	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'private_key' TEXT NOT NULL,
-	'password' TEXT NOT NULL
+	'password' TEXT NULL
 )
 ;
 
@@ -61 +61 @@
 )
 ;
 
-CREATE TABLE 'CertificatesUsages'
+CREATE TABLE 'CertificateUsages'
 (
 	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'certificate_id' INTEGER NULL,
-	'usage_type_id' INTEGER NULL,
+	'certificate_id' INTEGER NOT NULL,
+	'usage_type_id' INTEGER NOT NULL,
 	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
 )