[thirdparty/pdns.git] / pdns / bind-dnssec.schema.sqlite3.sql

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