]>
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, | |
2af952b4 | 15 | published BOOL DEFAULT 1, |
49ab4a48 | 16 | content TEXT |
b0e315d9 | 17 | ); |
c9ba2a49 | 18 | |
b0e315d9 | 19 | create index domainnameindex on cryptokeys(domain); |
c9ba2a49 BH |
20 | |
21 | create table tsigkeys ( | |
49ab4a48 PD |
22 | id INTEGER PRIMARY KEY, |
23 | name VARCHAR(255) COLLATE NOCASE, | |
24 | algorithm VARCHAR(50) COLLATE NOCASE, | |
25 | secret VARCHAR(255) | |
c9ba2a49 BH |
26 | ); |
27 | ||
28 | create unique index namealgoindex on tsigkeys(name, algorithm); |