Revize 0217ab3d

Re #8305 - Edited ERA model and script for generate database
- password column migrated from Certificate table to PrivateKey table

SQLite_database.sql

@@ -1 +1 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 13.5 		*/
-/*  Created On : 26-b?e-2021 13:33:05 				*/
+/*  Created On : 27-b?e-2021 17:17:14 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -37 +37 @@
 CREATE TABLE 'PrivateKey'
 (
 	'private_key_id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'private_key' TEXT NOT NULL
+	'private_key' TEXT NOT NULL,
+	'password' TEXT NULL
 )
 ;
 
@@ -47 +48 @@
 	'common_name' TEXT NOT NULL,
 	'valid_from' TEXT NOT NULL,
 	'valid_to' TEXT NOT NULL,
-	'password' TEXT NULL,
 	'pem_data' TEXT NOT NULL,
 	'type_id' INTEGER NULL,
-	'usage_id' INTEGER NULL,
 	'private_key_id' INTEGER NULL,
+	'usage_id' INTEGER NULL,
 	CONSTRAINT 'FK_Certificate_Type' FOREIGN KEY ('type_id') REFERENCES 'CertificateType' ('certificate_type_id') ON DELETE No Action ON UPDATE No Action,
 	CONSTRAINT 'FK_Certificate_Usage' FOREIGN KEY ('usage_id') REFERENCES 'CertificateUsage' ('certificate_usage_id') ON DELETE No Action ON UPDATE No Action,
 	CONSTRAINT 'FK_Parent_Certificate' FOREIGN KEY ('certificate_id') REFERENCES 'Certificate' ('certificate_id') ON DELETE No Action ON UPDATE No Action,