GRANT ALL PRIVILEGES ON serverconf.* TO serverconfuser@localhost IDENTIFIED BY 'serverconfpass';

USE serverconf;

CREATE TABLE `domain` (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(50) NOT NULL
) ENGINE = InnoDB;

CREATE TABLE `domainDNS` (
	domain_id INT UNSIGNED NOT NULL PRIMARY KEY,
	master    VARCHAR(20) DEFAULT NULL,
	last_check INT DEFAULT NULL,
	`type`    VARCHAR(6) NOT NULL,
	notified_serial INT DEFAULT NULL,
	account         VARCHAR(40) DEFAULT NULL,
	FOREIGN KEY (domain_id) REFERENCES domain(id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `record` (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	domain_id INT UNSIGNED NOT NULL,
	name            VARCHAR(255) DEFAULT NULL,
	`type`            VARCHAR(6) DEFAULT NULL,
	content         VARCHAR(255) DEFAULT NULL,
	ttl             INT DEFAULT 86400,
	prio            INT DEFAULT NULL,
	change_date     INT DEFAULT NULL,
	KEY `rec_name_index` (`name`),
	KEY `nametype_index` (`name`,`type`),
	KEY `domain_id` (`domain_id`),
	FOREIGN KEY (domain_id) REFERENCES domain(id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

create table supermaster (
	ip VARCHAR(25) NOT NULL,
	nameserver VARCHAR(255) NOT NULL,
	account VARCHAR(40) DEFAULT NULL
) ENGINE=InnoDB;