Revize 6425fa36
Přidáno uživatelem David Friesecký před téměř 4 roky(ů)
| src/db/init_queries.py | ||
|---|---|---|
| 1 | 1 |
SCHEMA_SQL = """ |
| 2 | 2 |
/* ---------------------------------------------------- */ |
| 3 | 3 |
/* Generated by Enterprise Architect Version 13.5 */ |
| 4 |
/* Created On : 01-dub-2021 15:16:53 */
|
|
| 4 |
/* Created On : 27-dub-2021 11:31:54 */
|
|
| 5 | 5 |
/* DBMS : SQLite */ |
| 6 | 6 |
/* ---------------------------------------------------- */ |
| 7 | 7 |
|
| 8 | 8 |
/* Drop Tables */ |
| 9 | 9 |
|
| 10 |
DROP TABLE IF EXISTS 'PrivateKeys'
|
|
| 10 |
DROP TABLE IF EXISTS 'Certificates'
|
|
| 11 | 11 |
; |
| 12 | 12 |
|
| 13 | 13 |
DROP TABLE IF EXISTS 'CertificateTypes' |
| 14 | 14 |
; |
| 15 | 15 |
|
| 16 |
DROP TABLE IF EXISTS 'UsageTypes' |
|
| 17 |
; |
|
| 18 |
|
|
| 19 |
DROP TABLE IF EXISTS 'Certificates' |
|
| 20 |
; |
|
| 21 |
|
|
| 22 | 16 |
DROP TABLE IF EXISTS 'CertificateUsages' |
| 23 | 17 |
; |
| 24 | 18 |
|
| 25 |
/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ |
|
| 26 |
|
|
| 27 |
CREATE TABLE 'PrivateKeys' |
|
| 28 |
( |
|
| 29 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 30 |
'private_key' TEXT NOT NULL, |
|
| 31 |
'password' TEXT NULL |
|
| 32 |
) |
|
| 19 |
DROP TABLE IF EXISTS 'PrivateKeys' |
|
| 33 | 20 |
; |
| 34 | 21 |
|
| 35 |
CREATE TABLE 'CertificateTypes' |
|
| 36 |
( |
|
| 37 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 38 |
'certificate_type' TEXT NOT NULL |
|
| 39 |
) |
|
| 22 |
DROP TABLE IF EXISTS 'UsageTypes' |
|
| 40 | 23 |
; |
| 41 | 24 |
|
| 42 |
CREATE TABLE 'UsageTypes' |
|
| 43 |
( |
|
| 44 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 45 |
'usage_type' TEXT NOT NULL |
|
| 46 |
) |
|
| 47 |
; |
|
| 25 |
/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ |
|
| 48 | 26 |
|
| 49 | 27 |
CREATE TABLE 'Certificates' |
| 50 | 28 |
( |
| ... | ... | |
| 55 | 33 |
'pem_data' TEXT NOT NULL, |
| 56 | 34 |
'revocation_date' TEXT NULL, |
| 57 | 35 |
'revocation_reason' TEXT NULL, |
| 36 |
'deletion_date' TEXT NULL, |
|
| 58 | 37 |
'private_key_id' INTEGER NOT NULL, |
| 59 | 38 |
'certificate_type_id' INTEGER NOT NULL, |
| 60 | 39 |
'parent_certificate_id' INTEGER NOT NULL, |
| ... | ... | |
| 64 | 43 |
) |
| 65 | 44 |
; |
| 66 | 45 |
|
| 46 |
CREATE TABLE 'CertificateTypes' |
|
| 47 |
( |
|
| 48 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 49 |
'certificate_type' TEXT NOT NULL |
|
| 50 |
) |
|
| 51 |
; |
|
| 52 |
|
|
| 67 | 53 |
CREATE TABLE 'CertificateUsages' |
| 68 | 54 |
( |
| 69 | 55 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
| ... | ... | |
| 74 | 60 |
) |
| 75 | 61 |
; |
| 76 | 62 |
|
| 63 |
CREATE TABLE 'PrivateKeys' |
|
| 64 |
( |
|
| 65 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 66 |
'private_key' TEXT NOT NULL, |
|
| 67 |
'password' TEXT NULL |
|
| 68 |
) |
|
| 69 |
; |
|
| 70 |
|
|
| 71 |
CREATE TABLE 'UsageTypes' |
|
| 72 |
( |
|
| 73 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
|
| 74 |
'usage_type' TEXT NOT NULL |
|
| 75 |
) |
|
| 76 |
; |
|
| 77 |
|
|
| 77 | 78 |
""" |
| 78 | 79 |
|
| 79 | 80 |
DEFAULT_VALUES_SQL = """ |
Také k dispozici: Unified diff
Re #8670 - Modified deletion for historical storage of certificates