]>
git.ipfire.org Git - thirdparty/pdns.git/blob - pdns/bind-dnssec.schema.sqlite3.sql
1 create table domainmetadata (
2 id INTEGER PRIMARY KEY,
3 domain VARCHAR(255) COLLATE NOCASE
,
4 kind
VARCHAR(32) COLLATE NOCASE
,
8 create index domainmetanameindex
on domainmetadata(domain);
10 create table cryptokeys (
11 id INTEGER PRIMARY KEY,
12 domain VARCHAR(255) COLLATE NOCASE
,
18 create index domainnameindex
on cryptokeys(domain);
20 create table tsigkeys (
21 id INTEGER PRIMARY KEY,
22 name VARCHAR(255) COLLATE NOCASE
,
23 algorithm
VARCHAR(50) COLLATE NOCASE
,
27 create unique index namealgoindex
on tsigkeys(name, algorithm
);