1CREATE TABLE IF NOT EXISTS `records` ( 2 `id` INTEGER PRIMARY KEY AUTOINCREMENT, 3 `zone` CHAR(255) NOT NULL, 4 `ttl` INT NOT NULL DEFAULT '86400', 5 `type` CHAR(255) NOT NULL, 6 `host` CHAR(255) NOT NULL DEFAULT '@', 7 `mx_priority` INT DEFAULT NULL, 8 `data` text, 9 `primary_ns` CHAR(255) DEFAULT NULL, 10 `resp_contact` CHAR(255) DEFAULT NULL, 11 `serial` bigint DEFAULT NULL, 12 `refresh` INT DEFAULT NULL, 13 `retry` INT DEFAULT NULL, 14 `expire` INT DEFAULT NULL, 15 `minimum` INT DEFAULT NULL 16); 17 18CREATE INDEX IF NOT EXISTS record_type on records (type); 19CREATE INDEX IF NOT EXISTS record_host on records (host); 20CREATE INDEX IF NOT EXISTS record_zone on records (zone); 21 22CREATE TABLE IF NOT EXISTS `xfr` ( 23 `zone` CHAR(255) NOT NULL, 24 `client` CHAR(255) NOT NULL 25); 26 27CREATE INDEX IF NOT EXISTS xfr_zone on xfr (zone); 28CREATE INDEX IF NOT EXISTS xfr_client on xfr (client); 29