/
usr
/
share
/
doc
/
cpanel-pdns
/
/usr/share/doc/cpanel-pdns
mkdir
upload
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/3.4.0_to_4.1.0_schema.mysql.sql
(833B)
ALTER TABLE domains MODIFY account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL; ALTER TABLE domains CHARACTER SET 'latin1'; ALTER TABLE records MODIFY id BIGINT AUTO_INCREMENT; ALTER TABLE records CHARACTER SET 'latin1'; CREATE INDEX ordername ON records (ordername); DROP INDEX recordorder ON records; ALTER TABLE supermasters MODIFY account VARCHAR(40) CHARACTER SET 'utf8' NOT NULL; ALTER TABLE supermasters CHARACTER SET 'latin1'; ALTER TABLE comments MODIFY account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL; ALTER TABLE comments MODIFY comment TEXT CHARACTER SET 'utf8' NOT NULL; ALTER TABLE comments CHARACTER SET 'latin1'; DROP INDEX comments_domain_id_idx ON comments; ALTER TABLE domainmetadata CHARACTER SET 'latin1'; ALTER TABLE cryptokeys CHARACTER SET 'latin1'; ALTER TABLE tsigkeys CHARACTER SET 'latin1';
Save
cmd:
run