2 PRAGMA foreign_keys = ON;
8 certificate TEXT not null,
9 file_hash TEXT not null,
10 subject_hash TEXT not null,
11 common_name TEXT not null,
13 is_root_app_enabled INT not null);
16 gname TEXT PRIMARY KEY not null,
17 common_name TEXT not null,
18 private_key_gname TEXT,
19 associated_gname TEXT,
22 is_root_app_enabled INT not null);
25 gname TEXT PRIMARY KEY not null,
26 common_name TEXT not null,
27 private_key_gname TEXT,
28 associated_gname TEXT,
31 is_root_app_enabled INT not null);
34 gname TEXT PRIMARY KEY not null,
35 common_name TEXT not null,
36 private_key_gname TEXT,
37 associated_gname TEXT,
40 is_root_app_enabled INT not null);
42 CREATE TABLE disabled_certs (
43 gname TEXT PRIMARY KEY not null,
44 certificate TEXT not null);