REDROOM

Navigation

Breadcrumbs

Create

Preview: enable-foreign-keys.mysql.sql Size: 1.08 KB

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

Name	Size	Perms	Modified	Actions
3.4.0_to_4.0.0_schema.sqlite3.sql	5.34 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
3.4.0_to_4.1.0_schema.mysql.sql	833 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.0.0_to_4.2.0_schema.sqlite3.sql	1.66 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.1.0_to_4.2.0_schema.mysql.sql	116 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.2.0_to_4.3.0_schema.mysql.sql	71 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.2.0_to_4.3.0_schema.sqlite3.sql	606 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.3.0_to_4.3.1_schema.sqlite3.sql	508 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.3.0_to_4.7.0_schema.mysql.sql	220 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
4.3.1_to_4.7.0_schema.sqlite3.sql	272 B	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
COPYING	17.67 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
dnssec-3.x_to_3.4.0_schema.mysql.sql	1.55 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
dnssec-3.x_to_3.4.0_schema.sqlite3.sql	3.46 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
enable-foreign-keys.mysql.sql	1.08 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
nodnssec-3.x_to_3.4.0_schema.mysql.sql	2.00 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
nodnssec-3.x_to_3.4.0_schema.sqlite3.sql	2.28 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
README	5.55 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
schema.mysql.sql	3.07 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive
schema.sqlite3.sql	3.12 KB	lrw-r--r--	2025-05-07 09:29:27	Edit Download recursive recursive

Directory Contents