1 PRAGMA foreign_keys = ON;
5 CREATE TABLE schema_info (
6 version INT PRIMARY KEY not null,
10 gname TEXT PRIMARY KEY not null,
11 certificate TEXT not null,
12 file_hash TEXT not null,
13 subject_hash TEXT not null,
14 common_name TEXT not null,
16 is_root_app_enabled INT not null);
19 gname TEXT PRIMARY KEY not null,
20 common_name TEXT not null,
21 private_key_gname TEXT,
22 associated_gname TEXT,
25 is_root_app_enabled INT not null);
28 gname TEXT PRIMARY KEY not null,
29 common_name TEXT not null,
30 private_key_gname TEXT,
31 associated_gname TEXT,
34 is_root_app_enabled INT not null);
37 gname TEXT PRIMARY KEY not null,
38 common_name TEXT not null,
39 private_key_gname TEXT,
40 associated_gname TEXT,
43 is_root_app_enabled INT not null);
45 CREATE TABLE disabled_certs (
46 gname TEXT PRIMARY KEY not null,
47 certificate TEXT not null);