FM / cpanel-pdns

/usr/share/doc/cpanel-pdns

Name	Size	Mode	Actions
3.4.0_to_4.0.0_schema.sqlite3.sql	5468	0644	edit dl rm
3.4.0_to_4.1.0_schema.mysql.sql	833	0644	edit dl rm
4.0.0_to_4.2.0_schema.sqlite3.sql	1702	0644	edit dl rm
4.1.0_to_4.2.0_schema.mysql.sql	116	0644	edit dl rm
4.2.0_to_4.3.0_schema.mysql.sql	71	0644	edit dl rm
4.2.0_to_4.3.0_schema.sqlite3.sql	606	0644	edit dl rm
4.3.0_to_4.3.1_schema.sqlite3.sql	508	0644	edit dl rm
4.3.0_to_4.7.0_schema.mysql.sql	220	0644	edit dl rm
4.3.1_to_4.7.0_schema.sqlite3.sql	272	0644	edit dl rm
COPYING	18091	0644	edit dl rm
dnssec-3.x_to_3.4.0_schema.mysql.sql	1583	0644	edit dl rm
dnssec-3.x_to_3.4.0_schema.sqlite3.sql	3541	0644	edit dl rm
enable-foreign-keys.mysql.sql	1110	0644	edit dl rm
nodnssec-3.x_to_3.4.0_schema.mysql.sql	2047	0644	edit dl rm
nodnssec-3.x_to_3.4.0_schema.sqlite3.sql	2336	0644	edit dl rm
README	5687	0644	edit dl rm
schema.mysql.sql	3139	0644	edit dl rm
schema.sqlite3.sql	3193	0644	edit dl rm

Edit: /usr/share/doc/cpanel-pdns/4.0.0_to_4.2.0_schema.sqlite3.sql (1702B)

.bail on

BEGIN TRANSACTION;
    CREATE TEMPORARY TABLE records_backup (
      id                    INTEGER PRIMARY KEY,
      domain_id             INTEGER DEFAULT NULL,
      name                  VARCHAR(255) DEFAULT NULL,
      type                  VARCHAR(10) DEFAULT NULL,
      content               VARCHAR(65535) DEFAULT NULL,
      ttl                   INTEGER DEFAULT NULL,
      prio                  INTEGER DEFAULT NULL,
      disabled              BOOLEAN DEFAULT 0,
      ordername             VARCHAR(255),
      auth                  BOOL DEFAULT 1
    );

INSERT INTO records_backup SELECT id,domain_id,name,type,content,ttl,prio,disabled,ordername,auth FROM records;
    DROP TABLE records;

CREATE TABLE records (
      id                    INTEGER PRIMARY KEY,
      domain_id             INTEGER DEFAULT NULL,
      name                  VARCHAR(255) DEFAULT NULL,
      type                  VARCHAR(10) DEFAULT NULL,
      content               VARCHAR(65535) DEFAULT NULL,
      ttl                   INTEGER DEFAULT NULL,
      prio                  INTEGER DEFAULT NULL,
      disabled              BOOLEAN DEFAULT 0,
      ordername             VARCHAR(255),
      auth                  BOOL DEFAULT 1,
      FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE
    );

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 INDEX orderindex ON records(ordername);

INSERT INTO records SELECT id,domain_id,name,type,content,ttl,prio,disabled,ordername,auth FROM records_backup;
    DROP TABLE records_backup;
COMMIT;

cmd: