pdns/pdns.table

   1 create table domains (
   2   id                INTEGER PRIMARY KEY,
   3   name              VARCHAR(255) NOT NULL COLLATE NOCASE,
   4   master            VARCHAR(128) DEFAULT NULL,
   5   last_check        INTEGER DEFAULT NULL,
   6   type              VARCHAR(6) NOT NULL,
   7   notified_serial   INTEGER DEFAULT NULL,
   8   account           VARCHAR(40) DEFAULT NULL
   9 );
  10
  11 CREATE UNIQUE INDEX name_index ON domains(name);
  12
  13 CREATE TABLE records (
  14   id              INTEGER PRIMARY KEY,
  15   domain_id       INTEGER DEFAULT NULL,
  16   name            VARCHAR(255) DEFAULT NULL,
  17   type            VARCHAR(10) DEFAULT NULL,
  18   content         VARCHAR(65535) DEFAULT NULL,
  19   ttl             INTEGER DEFAULT NULL,
  20   prio            INTEGER DEFAULT NULL,
  21   change_date     INTEGER DEFAULT NULL,
  22   ordername       VARCHAR(255),
  23   auth            BOOL
  24 );
  25
  26 CREATE INDEX rec_name_index ON records(name);
  27 CREATE INDEX nametype_index ON records(name,type);
  28 CREATE INDEX domain_id ON records(domain_id);
  29 CREATE INDEX orderindex ON records(ordername);
  30
  31 create table supermasters (
  32   ip          VARCHAR(25) NOT NULL,
  33   nameserver  VARCHAR(255) NOT NULL COLLATE NOCASE,
  34   account     VARCHAR(40) DEFAULT NULL
  35 );
  36
  37 create table domainmetadata (
  38  id              INTEGER PRIMARY KEY,
  39  domain_id       INT NOT NULL,
  40  kind            VARCHAR(16) COLLATE NOCASE,
  41  content        TEXT
  42 );
  43
  44 create index domainmetaidindex on domainmetadata(domain_id);
  45
  46 create table cryptokeys (
  47  id             INTEGER PRIMARY KEY,
  48  domain_id      INT NOT NULL,
  49  flags          INT NOT NULL,
  50  active         BOOL,
  51  content        TEXT
  52 );
  53
  54 create index domainidindex on cryptokeys(domain_id);
  55
  56 create table tsigkeys (
  57  id             INTEGER PRIMARY KEY,
  58  name           VARCHAR(255) COLLATE NOCASE,
  59  algorithm      VARCHAR(50) COLLATE NOCASE,
  60  secret         VARCHAR(255)
  61 );
  62
  63 create unique index namealgoindex on tsigkeys(name, algorithm);