1 files changed, 36 insertions, 24 deletions
diff --git a/dns/powerdns-devel/files/pdns_sqlite.sql b/dns/powerdns-devel/files/pdns_sqlite.sql
index f0f831fb2977..a7f8be90470a 100644
--- a/dns/powerdns-devel/files/pdns_sqlite.sql
+++ b/dns/powerdns-devel/files/pdns_sqlite.sql
@@ -1,33 +1,45 @@
-create table domains (
-  id			INTEGER PRIMARY KEY,
-  name			VARCHAR(255) NOT NULL,
-  master		VARCHAR(20) DEFAULT NULL,
-  last_check		INTEGER DEFAULT NULL,
-  type			VARCHAR(6) NOT NULL,
-  notified_serial	INTEGER DEFAULT NULL,
-  account		VARCHAR(40) DEFAULT NULL
+CREATE TABLE domains (
+	id INT AUTOINCREMENT,
+	name VARCHAR(255) NOT NULL,
+	type VARCHAR(6) NOT NULL,
+	master VARCHAR(40) DEFAULT NULL,
+	account VARCHAR(40) DEFAULT NULL,
+	notified_serial INT DEFAULT NULL,
+	last_check INT DEFAULT NULL,
+CONSTRAINT pk_id
+	PRIMARY KEY (id),
+CONSTRAINT unq_name
+	UNIQUE (name)
 );
 
-CREATE UNIQUE INDEX name_index ON domains(name);
 
 CREATE TABLE records (
-  id			INTEGER PRIMARY KEY,
-  domain_id		INTEGER DEFAULT NULL,
-  name			VARCHAR(255) DEFAULT NULL,
-  type			VARCHAR(6) DEFAULT NULL,
-  content		VARCHAR(255) DEFAULT NULL,
-  ttl			INTEGER DEFAULT NULL,
-  prio			INTEGER DEFAULT NULL,
-  change_date		INTEGER DEFAULT NULL
+	id INT AUTOINCREMENT,
+	domain_id INT DEFAULT NULL,
+	name VARCHAR(255) DEFAULT NULL,
+	type VARCHAR(6) DEFAULT NULL,
+	ttl INT DEFAULT NULL,
+	prio INT DEFAULT NULL,
+	content VARCHAR(255) DEFAULT NULL,
+	change_date INT DEFAULT NULL,
+CONSTRAINT pk_id
+	PRIMARY KEY (id),
+CONSTRAINT fk_domainid
+	FOREIGN KEY (domain_id)
+	REFERENCES domains(id)
+	ON UPDATE CASCADE
+	ON DELETE CASCADE
 );
 
-CREATE INDEX rec_name_index ON records(name);
-CREATE INDEX nametype_index ON records(name,type);
-CREATE INDEX domain_id ON records(domain_id);
+CREATE INDEX idx_rdomainid ON records(domain_id);
+CREATE INDEX idx_rname ON records(name);
+CREATE INDEX idx_rname_rtype ON records(name,type);
 
-create table supermasters (
-  ip			VARCHAR(25) NOT NULL,
-  nameserver		VARCHAR(255) NOT NULL,
-  account		VARCHAR(40) DEFAULT NULL
+
+CREATE TABLE supermasters (
+	ip VARCHAR(40) NOT NULL,
+	nameserver VARCHAR(255) NOT NULL,
+	account VARCHAR(40) DEFAULT NULL
 );
 
+CREATE INDEX idx_smip_smns ON supermasters(ip,nameserver);