One Hat Cyber Team
Your IP :
216.73.216.50
Server IP :
157.15.65.100
Server :
Linux 157-15-65-100.cprapid.com 5.14.0-362.24.2.el9_3.x86_64 #1 SMP PREEMPT_DYNAMIC Sat Mar 30 14:11:54 EDT 2024 x86_64
Server Software :
Apache
PHP Version :
8.2.28
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
usr
/
share
/
doc
/
cpanel-pdns
/
View File Name :
dnssec-3.x_to_3.4.0_schema.mysql.sql
/* 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);