FM / cpanel-pdns

/usr/share/doc/cpanel-pdns

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/enable-foreign-keys.mysql.sql (1110B)

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;

/* 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;