1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
create table domainmetadata (
id INTEGER PRIMARY KEY,
domain VARCHAR(255) COLLATE NOCASE,
kind VARCHAR(32) COLLATE NOCASE,
content TEXT
);
create index domainmetanameindex on domainmetadata(domain);
create table cryptokeys (
id INTEGER PRIMARY KEY,
domain VARCHAR(255) COLLATE NOCASE,
flags INT NOT NULL,
active BOOL,
published BOOL DEFAULT 1,
content TEXT
);
create index domainnameindex on cryptokeys(domain);
create table tsigkeys (
id INTEGER PRIMARY KEY,
name VARCHAR(255) COLLATE NOCASE,
algorithm VARCHAR(50) COLLATE NOCASE,
secret VARCHAR(255)
);
create unique index namealgoindex on tsigkeys(name, algorithm);
|
