| 1 |
2c96b4a5
|
David Friesecký
|
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 |
b5114e4e
|
David Friesecký
|
|
| 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"
|