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 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
);

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 table supermasters (
  ip			VARCHAR(25) NOT NULL,
  nameserver		VARCHAR(255) NOT NULL,
  account		VARCHAR(40) DEFAULT NULL
);