文件操作 - 3.4.0_to_4.1.0_schema.mysql.sql
返回文件管理
返回主菜单
删除本文件
文件: /usr/share/doc/cpanel-pdns/3.4.0_to_4.1.0_schema.mysql.sql
编辑文件内容
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';
修改文件时间
将文件时间修改为当前时间的前一年
删除文件