|
1
|
DATABASE_FILE = r"C:\sqlite\db\pythonsqlite.db"
|
|
2
|
|
|
3
|
ROOT_CA_ID = 1
|
|
4
|
INTERMEDIATE_CA_ID = 2
|
|
5
|
CERTIFICATE_ID = 3
|
|
6
|
|
|
7
|
CA_ID = 1
|
|
8
|
SSL_ID = 2
|
|
9
|
SIGNATURE_ID = 3
|
|
10
|
AUTHENTICATION_ID = 4
|
|
11
|
|
|
12
|
# DB names of tables
|
|
13
|
TAB_CERTIFICATE = "Certificate"
|
|
14
|
TAB_PRIVATE_KEY = "PrivateKey"
|
|
15
|
|
|
16
|
# DB column names
|
|
17
|
COL_ID = "id"
|
|
18
|
|
|
19
|
# DB column names of Certificate table
|
|
20
|
COL_COMMON_NAME = "common_name"
|
|
21
|
COL_VALID_FROM = "valid_from"
|
|
22
|
COL_VALID_TO = "valid_to"
|
|
23
|
COL_PEM_DATA = "pem_data"
|
|
24
|
COL_TYPE_ID = "type_id"
|
|
25
|
COL_PRIVATE_KEY_ID = "private_key_id"
|
|
26
|
COL_USAGE_ID = "usage_id"
|
|
27
|
|
|
28
|
# DB column names of PrivateKey table
|
|
29
|
COL_PRIVATE_KEY = "private_key"
|
|
30
|
COL_PASSWORD = "password"
|