text: CREATE TABLE domains (
                           id                    INT AUTO_INCREMENT,
                           name                  VARCHAR(255) NOT NULL,
                           master                VARCHAR(128) DEFAULT NULL,
                           last_check            INT DEFAULT NULL,
                           type                  VARCHAR(6) NOT NULL,
                           notified_serial       INT DEFAULT NULL,
                           account               VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
                           PRIMARY KEY (id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE UNIQUE INDEX name_index ON domains(name);
  
  
  CREATE TABLE records (
                           id                    BIGINT AUTO_INCREMENT,
                           domain_id             INT DEFAULT NULL,
                           name                  VARCHAR(255) DEFAULT NULL,
                           type                  VARCHAR(10) DEFAULT NULL,
                           content               VARCHAR(64000) DEFAULT NULL,
                           ttl                   INT DEFAULT NULL,
                           prio                  INT DEFAULT NULL,
                           change_date           INT DEFAULT NULL,
                           disabled              TINYINT(1) DEFAULT 0,
                           ordername             VARCHAR(255) BINARY DEFAULT NULL,
                           auth                  TINYINT(1) DEFAULT 1,
                           PRIMARY KEY (id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE INDEX nametype_index ON records(name,type);
  CREATE INDEX domain_id ON records(domain_id);
  CREATE INDEX ordername ON records (ordername);
  
  
  CREATE TABLE supermasters (
                                ip                    VARCHAR(64) NOT NULL,
                                nameserver            VARCHAR(255) NOT NULL,
                                account               VARCHAR(40) CHARACTER SET 'utf8' NOT NULL,
                                PRIMARY KEY (ip, nameserver)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  
  CREATE TABLE comments (
                            id                    INT AUTO_INCREMENT,
                            domain_id             INT NOT NULL,
                            name                  VARCHAR(255) NOT NULL,
                            type                  VARCHAR(10) NOT NULL,
                            modified_at           INT NOT NULL,
                            account               VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
                            comment               TEXT CHARACTER SET 'utf8' NOT NULL,
                            PRIMARY KEY (id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE INDEX comments_name_type_idx ON comments (name, type);
  CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);
  
  
  CREATE TABLE domainmetadata (
                                  id                    INT AUTO_INCREMENT,
                                  domain_id             INT NOT NULL,
                                  kind                  VARCHAR(32),
                                  content               TEXT,
                                  PRIMARY KEY (id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
  
  
  CREATE TABLE cryptokeys (
                              id                    INT AUTO_INCREMENT,
                              domain_id             INT NOT NULL,
                              flags                 INT NOT NULL,
                              active                BOOL,
                              content               TEXT,
                              PRIMARY KEY(id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE INDEX domainidindex ON cryptokeys(domain_id);
  
  
  CREATE TABLE tsigkeys (
                            id                    INT AUTO_INCREMENT,
                            name                  VARCHAR(255),
                            algorithm             VARCHAR(50),
                            secret                VARCHAR(255),
                            PRIMARY KEY (id)
  ) Engine=InnoDB CHARACTER SET 'latin1';
  
  CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);