PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "domains" (
	"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(255) NOT NULL,
	"type" VARCHAR(6) NOT NULL,
	"master" VARCHAR(40) NOT NULL DEFAULT '',
	"account" VARCHAR(40) NOT NULL DEFAULT '',
	"last_check" INTEGER DEFAULT NULL,
	"notified_serial" INTEGER DEFAULT NULL,
	"auto_serial" INTEGER NOT NULL DEFAULT 0,
	"status" CHAR(1) NOT NULL DEFAULT 'A',
CONSTRAINT "pdns_unq_domains_name"
	UNIQUE ("name")
);
INSERT INTO "domains" VALUES(1,'zagamma.cz','MASTER','','',NULL,19,19,'A');
INSERT INTO "domains" VALUES(2,'py.cz','MASTER','','',NULL,12,12,'A');
INSERT INTO "domains" VALUES(3,'stral.cz','SLAVE','77.93.197.118','MICHALSTRAL',1259754999,NULL,119,'A');
INSERT INTO "domains" VALUES(4,'satral.cz','SLAVE','77.93.197.118','MICHALSTRAL',1259317649,NULL,66,'A');
CREATE TABLE "records" (
	"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	"domain_id" INTEGER NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"type" VARCHAR(6) NOT NULL,
	"ttl" INTEGER DEFAULT NULL,
	"prio" INTEGER DEFAULT NULL,
	"content" VARCHAR(255) NOT NULL,
CONSTRAINT "pdns_fk_records_domainid"
	FOREIGN KEY ("domain_id")
	REFERENCES "domains" ("id")
	ON UPDATE CASCADE
	ON DELETE CASCADE
);
INSERT INTO "records" VALUES(1,1,'zagamma.cz','SOA',NULL,NULL,'hugo.zagamma.cz. vinil.zagamma.cz. 0 3600 600 86400 3600');
INSERT INTO "records" VALUES(2,1,'zagamma.cz','NS',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(3,1,'zagamma.cz','NS',NULL,NULL,'ns.stral.cz');
INSERT INTO "records" VALUES(4,1,'zagamma.cz','MX',NULL,10,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(5,1,'zagamma.cz','MX',NULL,20,'mail.stral.cz');
INSERT INTO "records" VALUES(6,1,'zagamma.cz','MX',NULL,30,'mx.zagamma.cz');
INSERT INTO "records" VALUES(7,1,'zagamma.cz','TXT',NULL,NULL,'v=spf1 mx -all');
INSERT INTO "records" VALUES(8,1,'zagamma.cz','A',NULL,NULL,'194.228.3.217');
INSERT INTO "records" VALUES(9,1,'hugo.zagamma.cz','A',NULL,NULL,'194.228.3.217');
INSERT INTO "records" VALUES(10,1,'hugo.zagamma.cz','TXT',NULL,NULL,'v=spf1 a -all');
INSERT INTO "records" VALUES(11,1,'mx.zagamma.cz','A',NULL,NULL,'194.228.3.217');
INSERT INTO "records" VALUES(12,1,'mx.zagamma.cz','TXT',NULL,NULL,'v=spf1 a -all');
INSERT INTO "records" VALUES(13,1,'www.zagamma.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(14,1,'pdns.zagamma.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(15,1,'monit.zagamma.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(16,1,'centurion.zagamma.cz','CNAME',NULL,NULL,'centurion.dontexist.net');
INSERT INTO "records" VALUES(17,2,'py.cz','SOA',NULL,NULL,'hugo.zagamma.cz. vinil.zagamma.cz. 0 3600 600 86400 3600');
INSERT INTO "records" VALUES(18,2,'py.cz','NS',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(19,2,'py.cz','NS',NULL,NULL,'ns.stral.cz');
INSERT INTO "records" VALUES(20,2,'py.cz','MX',NULL,10,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(21,2,'py.cz','MX',NULL,20,'mail.stral.cz');
INSERT INTO "records" VALUES(22,2,'py.cz','MX',NULL,30,'mx.zagamma.cz');
INSERT INTO "records" VALUES(23,2,'py.cz','TXT',NULL,NULL,'v=spf1 mx -all');
INSERT INTO "records" VALUES(24,2,'www.py.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(25,2,'howto.py.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(26,2,'tutorial30.py.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(27,2,'www.tutorial30.py.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(45,2,'py.cz','A',NULL,NULL,'194.228.3.217');
INSERT INTO "records" VALUES(46,1,'webmail.zagamma.cz','CNAME',NULL,NULL,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(115,3,'stral.cz','SOA',3600,0,'ns.stral.cz. domainmaster.stral.cz. 49 3600 3600 1209000 86400');
INSERT INTO "records" VALUES(116,3,'stral.cz','NS',3600,0,'ns.stral.cz');
INSERT INTO "records" VALUES(117,3,'stral.cz','NS',3600,0,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(118,3,'stral.cz','A',3600,0,'77.93.197.118');
INSERT INTO "records" VALUES(119,3,'stral.cz','MX',3600,10,'mail.stral.cz');
INSERT INTO "records" VALUES(120,3,'*.stral.cz','A',3600,10,'77.93.197.118');
INSERT INTO "records" VALUES(121,3,'stral.cz','TXT',3600,10,'"v=spf1 mx -all"');
INSERT INTO "records" VALUES(122,3,'mail.stral.cz','A',3600,10,'77.93.197.118');
INSERT INTO "records" VALUES(123,3,'mail.stral.cz','TXT',3600,10,'"v=spf1 a -all"');
INSERT INTO "records" VALUES(124,3,'ns.stral.cz','A',3600,10,'77.93.197.118');
INSERT INTO "records" VALUES(125,3,'www.stral.cz','A',3600,10,'77.93.197.118');
INSERT INTO "records" VALUES(126,3,'monitor.stral.cz','A',3600,10,'80.79.29.72');
INSERT INTO "records" VALUES(127,3,'mail.stral.cz','AAAA',3600,10,'2a01:430:17::32');
INSERT INTO "records" VALUES(128,3,'stral.cz','MX',3600,20,'hugo.zagamma.cz');
INSERT INTO "records" VALUES(129,3,'stral.cz','MX',3600,30,'mx.stral.cz');
INSERT INTO "records" VALUES(130,3,'mx.stral.cz','A',3600,30,'77.93.197.118');
INSERT INTO "records" VALUES(131,3,'stral.cz','AAAA',3600,30,'2a01:430:17::32');
CREATE TABLE "supermasters" (
	"ip" VARCHAR(40) NOT NULL,
	"nameserver" VARCHAR(255) NOT NULL,
	"account" VARCHAR(40) NOT NULL DEFAULT ''
);
INSERT INTO "supermasters" VALUES('77.93.197.118','ns.stral.cz','MICHALSTRAL');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('domains',4);
INSERT INTO "sqlite_sequence" VALUES('records',131);
CREATE INDEX "pdns_idx_domains_status_type" ON "domains" ("status","type");
CREATE INDEX "pdns_idx_records_name_type" ON "records" ("name","type");
CREATE INDEX "pdns_idx_records_type" ON "records" ("type");
CREATE INDEX "pdns_idx_smaster_ip_ns" ON "supermasters" ("ip","nameserver");
CREATE TRIGGER "pdns_trig_records_insert"
AFTER INSERT ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" SET "auto_serial" = "auto_serial" + 1
	WHERE "id" = NEW."domain_id";
END;
CREATE TRIGGER "pdns_trig_records_update"
AFTER UPDATE ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" SET "auto_serial" = "auto_serial" + 1
	WHERE "id" = NEW."domain_id";
END;
CREATE TRIGGER "pdns_trig_records_delete"
AFTER DELETE ON "records"
FOR EACH ROW BEGIN
	UPDATE "domains" SET "auto_serial" = "auto_serial" + 1
	WHERE "id" = OLD."domain_id";
END;
COMMIT;
