{"id":131488,"date":"2020-11-11T04:09:05","date_gmt":"2020-11-11T04:09:05","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/foreign-keys-pro\/"},"modified":"2025-01-03T18:30:51","modified_gmt":"2025-01-03T18:30:51","slug":"foreign-keys-pro","status":"publish","type":"plugin","link":"https:\/\/cs.wordpress.org\/plugins\/foreign-keys-pro\/","author":17967069,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.1","stable_tag":"trunk","tested":"6.7.5","requires":"4.7","requires_php":"7.2","requires_plugins":null,"header_name":"Foreign Keys Pro","header_author":"Hubbard Labs","header_description":"A plugin to setup Foreign Keys in the WordPress Database.","assets_banners_color":"","last_updated":"2025-01-03 18:30:51","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/hubbardlabs.com","header_plugin_uri":"https:\/\/github.com\/bhubbard\/foreign-keys-pro","header_author_uri":"https:\/\/brandonhubbard.com","rating":0,"author_block_rating":0,"active_installs":0,"downloads":917,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":[],"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"Example Screenshot","2":"This is the second screen shot"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[192893,1627],"plugin_category":[59],"plugin_contributors":[80608,192894],"plugin_business_model":[],"class_list":["post-131488","plugin","type-plugin","status-publish","hentry","plugin_tags-foreign-keys","plugin_tags-mysql","plugin_category-utilities-and-tools","plugin_contributors-bhubbard","plugin_contributors-hubbardlabs","plugin_committers-bhubbard","plugin_committers-hubbardlabs"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/foreign-keys-pro.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p>A WordPress plugin to simply create MySQL foreign keys.<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload plugin to the <code>\/wp-content\/plugins\/<\/code> directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id='what%20are%20mysql%20foreign%20keys%3F'><h3>What are MySQL Foreign Keys?<\/h3><\/dt>\n<dd><p>A foreign key is a column or group of columns in a table that links to a column or group of columns in another table. The foreign key places constraints on data in the related tables, which allows MySQL to maintain referential integrity.\nReference: <a href=\"https:\/\/www.mysqltutorial.org\/mysql-foreign-key\/\">MySQL Tutorial<\/a><\/p><\/dd>\n<dt id='do%20foreign%20keys%20have%20an%20impact%20on%20performance%3F'><h3>Do Foreign Keys have an impact on performance?<\/h3><\/dt>\n<dd><p>This realistically can vary site to site based on many factors. It is always best to test in a development environment, but here is a <a href=\"https:\/\/www.scarydba.com\/2015\/09\/09\/yes-foreign-keys-help-performance\/\">good article<\/a> on how it might help performance.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>This version is the first release.<\/li>\n<\/ul>","raw_excerpt":"A WordPress plugin to simply create MySQL foreign keys.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/131488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=131488"}],"author":[{"embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/hubbardlabs"}],"wp:attachment":[{"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=131488"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=131488"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=131488"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=131488"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=131488"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/cs.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=131488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}