Revize 0cccf2a8
Přidáno uživatelem David Friesecký před asi 4 roky(ů)
| SQLite_database.sql | ||
|---|---|---|
| 1 | 1 |
/* ---------------------------------------------------- */ |
| 2 | 2 |
/* Generated by Enterprise Architect Version 13.5 */ |
| 3 |
/* Created On : 01-dub-2021 15:16:53 */
|
|
| 3 |
/* Created On : 11-dub-2021 0:19:51 */
|
|
| 4 | 4 |
/* DBMS : SQLite */ |
| 5 | 5 |
/* ---------------------------------------------------- */ |
| 6 | 6 |
|
| ... | ... | |
| 52 | 52 |
'valid_from' TEXT NOT NULL, |
| 53 | 53 |
'valid_to' TEXT NOT NULL, |
| 54 | 54 |
'pem_data' TEXT NOT NULL, |
| 55 |
'revocation_date' TEXT NULL, |
|
| 56 |
'revocation_reason' TEXT NULL, |
|
| 55 | 57 |
'private_key_id' INTEGER NOT NULL, |
| 56 | 58 |
'certificate_type_id' INTEGER NOT NULL, |
| 57 | 59 |
'parent_certificate_id' INTEGER NOT NULL, |
Také k dispozici: Unified diff
Re #8578 - Edited database
- added new columns in Certificates table (revocation_date, revocation_reason)
- both can be null and have string (text) type
- generated new SQL query