Revize ec4924a5

Re #8652 - Fixed format & merge conflict.

SQLite_database.sql

@@ -10 +10 @@
 CREATE TABLE IF NOT EXISTS 'Certificates'
 (
 	'id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'valid_from' TEXT NOT NULL,
-	'valid_to' TEXT NOT NULL,
+	'valid_from' INTEGER NOT NULL,
+	'valid_to' INTEGER NOT NULL,
 	'pem_data' TEXT NOT NULL,
 	'common_name' TEXT NOT NULL,
 	'country_code' TEXT NULL,
@@ -20 +20 @@
 	'organization' TEXT NULL,
 	'organizational_unit' TEXT NULL,
 	'email_address' TEXT NULL,
-	'revocation_date' TEXT NULL,
+	'revocation_date' INTEGER NULL,
 	'revocation_reason' TEXT NULL,
-	'deletion_date' TEXT NULL,
+	'deletion_date' INTEGER NULL,
 	'certificate_type_id' INTEGER NOT NULL,
 	'parent_certificate_id' INTEGER NOT NULL,
 	'private_key_id' INTEGER NOT NULL,

src/constants.py

@@ -2 +2 @@
 INMEMORY_DATABASE_FILE = ":memory:"
 TEST_DATABASE_FILE = INMEMORY_DATABASE_FILE
 DB_DIR = "db"
-DATETIME_FORMAT = "%d.%m.%Y %H:%M:%S"
+DATETIME_FORMAT = "%a, %d %b %Y"
 SCHEMA_SQL_FILE = "SQLite_database.sql"
 VALUES_SQL_FILE = "SQLite_default_values.sql"