Revize ec4924a5
Přidáno uživatelem Michal Seják před téměř 4 roky(ů)
SQLite_database.sql | ||
---|---|---|
10 | 10 |
CREATE TABLE IF NOT EXISTS 'Certificates' |
11 | 11 |
( |
12 | 12 |
'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
13 |
'valid_from' TEXT NOT NULL,
|
|
14 |
'valid_to' TEXT NOT NULL,
|
|
13 |
'valid_from' INTEGER NOT NULL,
|
|
14 |
'valid_to' INTEGER NOT NULL,
|
|
15 | 15 |
'pem_data' TEXT NOT NULL, |
16 | 16 |
'common_name' TEXT NOT NULL, |
17 | 17 |
'country_code' TEXT NULL, |
... | ... | |
20 | 20 |
'organization' TEXT NULL, |
21 | 21 |
'organizational_unit' TEXT NULL, |
22 | 22 |
'email_address' TEXT NULL, |
23 |
'revocation_date' TEXT NULL,
|
|
23 |
'revocation_date' INTEGER NULL,
|
|
24 | 24 |
'revocation_reason' TEXT NULL, |
25 |
'deletion_date' TEXT NULL,
|
|
25 |
'deletion_date' INTEGER NULL,
|
|
26 | 26 |
'certificate_type_id' INTEGER NOT NULL, |
27 | 27 |
'parent_certificate_id' INTEGER NOT NULL, |
28 | 28 |
'private_key_id' INTEGER NOT NULL, |
Také k dispozici: Unified diff
Re #8652 - Fixed format & merge conflict.