1#@!#!123s

: / proc / self / root / usr / share / doc / cpanel-pdns-4.9.2 /

Filename : 3.4.0_to_4.1.0_schema.mysql.sql

back

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';