Revize 993ee5a1

Re #8471 - Edited constants

src/constants.py

@@ -8 +8 @@
 SSL_ID = 2
 SIGNATURE_ID = 3
 AUTHENTICATION_ID = 4
+DICT_USAGES = {CA_ID: False, SSL_ID: False, SIGNATURE_ID: False, AUTHENTICATION_ID: False}
+
 
 # DB names of tables
-TAB_CERTIFICATE = "Certificate"
-TAB_PRIVATE_KEY = "PrivateKey"
+TAB_CERTIFICATES = "Certificates"
+TAB_PRIVATE_KEYS = "PrivateKeys"
+TAB_CERTIFICATE_USAGES = "CertificateUsages"
 
 # DB column names
 COL_ID = "id"
 
-# DB column names of Certificate table
+# DB column names of Certificates table
 COL_COMMON_NAME = "common_name"
 COL_VALID_FROM = "valid_from"
 COL_VALID_TO = "valid_to"
 COL_PEM_DATA = "pem_data"
-COL_TYPE_ID = "type_id"
 COL_PRIVATE_KEY_ID = "private_key_id"
-COL_USAGE_ID = "usage_id"
+COL_TYPE_ID = "certificate_type_id"
 
-# DB column names of PrivateKey table
+# DB column names of PrivateKeys table
 COL_PRIVATE_KEY = "private_key"
 COL_PASSWORD = "password"
+
+# DB column names of PrivateKey table
+COL_CERTIFICATE_ID = "certificate_id"
+COL_USAGE_TYPE_ID = "usage_type_id"