| Server IP : 181.215.205.78 / Your IP : 216.73.216.146 Web Server : LiteSpeed System : Linux srv028146260 5.15.0-176-generic #186-Ubuntu SMP Fri Mar 13 11:01:42 UTC 2026 x86_64 User : situs1068 ( 1161) PHP Version : 8.0.30 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/pdns-backend-mysql/schema/ |
Upload File : |
/* Uncomment next 3 lines for versions <= 3.1 */ /* DROP INDEX rec_name_index ON records; */ /* DROP INDEX orderindex ON records; */ /* CREATE INDEX recordorder ON records (domain_id, ordername); */ ALTER TABLE records ADD disabled TINYINT(1) DEFAULT 0 AFTER change_date; ALTER TABLE records MODIFY content VARCHAR(64000) DEFAULT NULL; ALTER TABLE records MODIFY ordername VARCHAR(255) BINARY DEFAULT NULL; ALTER TABLE records MODIFY auth TINYINT(1) DEFAULT 1; ALTER TABLE records MODIFY type VARCHAR(10); ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); ALTER TABLE supermasters MODIFY account VARCHAR(40) NOT NULL; ALTER TABLE domainmetadata MODIFY kind VARCHAR(32); ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50); ALTER TABLE domainmetadata ENGINE=InnoDB; ALTER TABLE cryptokeys ENGINE=InnoDB; ALTER TABLE tsigkeys ENGINE=InnoDB; DROP INDEX domainmetaidindex ON domainmetadata; CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); 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) NOT NULL, comment VARCHAR(64000) NOT NULL, PRIMARY KEY(id) ) Engine=InnoDB; CREATE INDEX comments_domain_id_idx ON comments (domain_id); CREATE INDEX comments_name_type_idx ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);