✏️ 正在编辑: enable-foreign-keys.mysql.sql
路径:
/usr/share/doc/cpanel-pdns/enable-foreign-keys.mysql.sql
提示:
您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。
/* Using this SQL causes Mysql to create foreign keys on your database. This will make sure that no records, comments or keys exists for domains that you already removed. This is not enabled by default, because we're not sure what the consequences are from a performance point of view. If you do have feedback, please let us know how this affects your setup. Please note that it's not possible to apply this, before you cleaned up your database, as the foreign keys do not exist. */ ALTER TABLE records ADD CONSTRAINT `records_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE comments ADD CONSTRAINT `comments_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE domainmetadata ADD CONSTRAINT `domainmetadata_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE cryptokeys ADD CONSTRAINT `cryptokeys_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
💾 保存文件
← 返回文件管理器