Revize 47e0e828
Přidáno uživatelem David Friesecký před téměř 4 roky(ů)
| SQLite_database.sql | ||
|---|---|---|
| 1 | 1 |
/* ---------------------------------------------------- */ |
| 2 | 2 |
/* Generated by Enterprise Architect Version 13.5 */ |
| 3 |
/* Created On : 31-b?e-2021 10:24:41 */
|
|
| 3 |
/* Created On : 31-b?e-2021 13:28:01 */
|
|
| 4 | 4 |
/* DBMS : SQLite */ |
| 5 | 5 |
/* ---------------------------------------------------- */ |
| 6 | 6 |
|
| ... | ... | |
| 54 | 54 |
'pem_data' TEXT NOT NULL, |
| 55 | 55 |
'private_key_id' INTEGER NOT NULL, |
| 56 | 56 |
'certificate_type_id' INTEGER NOT NULL, |
| 57 |
'parent_certificate_id' INTEGER NOT NULL, |
|
| 58 |
CONSTRAINT 'FK_Certificates' FOREIGN KEY ('parent_certificate_id') REFERENCES 'Certificates' ('id') ON DELETE No Action ON UPDATE No Action,
|
|
| 57 | 59 |
CONSTRAINT 'FK_CertificateTypes' FOREIGN KEY ('certificate_type_id') REFERENCES 'CertificateTypes' ('id') ON DELETE No Action ON UPDATE No Action,
|
| 58 | 60 |
CONSTRAINT 'FK_PrivateKeys' FOREIGN KEY ('private_key_id') REFERENCES 'PrivateKeys' ('id') ON DELETE No Action ON UPDATE No Action
|
| 59 | 61 |
) |
Také k dispozici: Unified diff
Re #8471 - Added FK of parent certificate