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