dbDelta support for FOREIGN KEY

Do I really have to live with that until dbDelta supports FOREIGN KEY?

Quite frankly, yes. But that’s the beauty of open source – anyone is welcome to post a patch!

However, expanding it to cover other aspects of schema design would almost certainly incur unwanted complexity & heighten the possibility of failure – something the core team will strongly consider beforehand.

I would take @xav0989’s advice – use dbDelta for it’s intention (basic table implementation, column additions & adjustments), and handle the additional features with $wpdb.

Related Posts:

  1. cant insert data in a custom table in phpmyadmin
  2. Undefined function mysql_connect()
  3. Fatal error: Call to undefined function mysql_connect()
  4. MySQL “Or” Condition
  5. Transaction when using WP functions rather than vanilla SQL?
  6. How to make WordPress plugin check for database changes and then do something?
  7. Delete post revisions on post publish
  8. Jquery ajax to custom php file: returning blank data
  9. Add value to usermeta without removing previous values?
  10. error importing localhost export file to server
  11. How can I call a row of user specific data from a custom table added to the WP Database
  12. How to merge local and live databases?
  13. Successful or Error Message after running mysql code in functions.php
  14. Performance issues with large website [closed]
  15. Create a quick start wordpress installation [closed]
  16. theme options echoing multiple times
  17. PHP/MySQL issues when running WP on EC2 cloud [closed]
  18. WordPress 3 – how are passwords stored and how do I compare to them?
  19. WordPress get pagination on wpdb get_results
  20. How to create another version of my site based on the same database
  21. how to echo all tables that start with a prefix
  22. Looking for most performant way to execute several similar WP queries within shortcodes
  23. How to select WooCommerce products by post_meta and order them
  24. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  25. Stumped on migration
  26. PHP code inside shortcodes
  27. Show MySQL errors that occur when I excute $wpdb->insert()
  28. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  29. Remove one value in dismissed_wp_pointers?
  30. WordPress Site Running Extremely Slow on Dedicated Server
  31. Accessing data from a non-WP database/table within a page content
  32. Get updated query results on page after insert in database
  33. WordPress not reflecting changed of the database
  34. How can I fix WordPress installation errors?
  35. How can I save unique user data on my site? [closed]
  36. Ordering users by custom user meta
  37. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  38. Hacked WordPress website /Homepage redirect [closed]
  39. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  40. Refresh table data with Ajax
  41. Database query works fine outside WordPress
  42. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  43. Using custom tables for old posts
  44. Help with a $wpdb MySQL Query
  45. How i can obtain all the post meta for a specific post as an array?
  46. Multiple meta_key in one global $wpdb;
  47. WordPress member notification
  48. Can’t Query Custom Table Using $wpdb Method
  49. Moving wordpress site from localhost to live server using GoDaddy cPanel
  50. How does WP work in conjunction with a web server?
  51. $wpdb returns duplicate posts
  52. Update postmeta after theme switch
  53. Location of core code for database connection and get_header
  54. Should I use WordPress to skin a database website?
  55. Creating Database Table vs. Adding MetaData to Post & User
  56. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  57. WordPress Custom SQL Table with UserID Filter for results
  58. Most commented posts by time period (last 12h, last 24h and etc)
  59. Hide posts if user is added to it WP_query
  60. How to unserialize data from MySQL
  61. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  62. WordPress WP_Query without query GET parameters
  63. Known Issues in WordPress When Upgrading PHP to ver 7
  64. How to use AJAX in WordPress in MYSQL query?
  65. Get the id of the row from database on click of a button [closed]
  66. WPDB secure custom form
  67. Query the links Database
  68. SQL error with custom query
  69. Modify WooCommerce used to get all orders in dashboard
  70. Passing in MySQL prepare statement parameter separately throwing error
  71. Database SQL query error
  72. Display Results of SQL Query on WP site
  73. Weird fonts showing which are coming from database
  74. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  75. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  76. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  77. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  78. WordPress Bad Request Error 400
  79. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  80. How to display MySQL table data which is stored as an array?
  81. Store GA Client ID in User DB
  82. What is the correct way to search 3 custom fields only in WordPress?
  83. How to import woocommerce custom fields data into another site?
  84. autocomplete in wordpress using ajax with json-data
  85. Need help with format of nested array in MySQL
  86. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  87. Query doesn’t display text data with apostrophes
  88. I want show only data for today
  89. Site doesnt work once PHP changed to 7.1
  90. SQL Query Search page
  91. can’t delete a row from post_meta table
  92. MySQL queries in WordPress
  93. Splash pages on a high traffic site
  94. Let users register weight each day and save it in DB
  95. How to pass username into form that sends data to database
  96. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  97. How to set variable to specific field when querying
  98. How to get a database field value from a WordPress table? [closed]
  99. Error resetting database index using ALTER TABLE in $wpdb->query
  100. Can’t insert into a database wordpress

Leave a Comment