Set default Database Storage Engine when creating tables with plugins?

It is possible with MySQL, and it doesn’t seem to create any problem with wordpress’s dbDelta()

Here is the line you need to change

$charset_collate = $wpdb->get_charset_collate() . ' engine = innoDB';

You simply have to add engine = innoDB at the end of the SQL query and the correct engine will be used by MySQL

Related Posts:

  1. WordPress Scheduled Event Request Blocking
  2. Accessing the database from a plugin outside of action hooks
  3. Update results, Before deleting the related category [closed]
  4. Store a default value for a transient on plugin activation
  5. Execute long and heavy processes
  6. wpdb prepare insert table doesn’t work
  7. Building a REST API for your web app exposes primary keys of DB records?
  8. How do I make this Metabox show current DB value?
  9. select a single val though a table in wordpress
  10. wp_update_post gives 500 internal error
  11. code that I can run, or a plug in to show what sql tables something pulls information from
  12. How to edit the default database of WordPress [closed]
  13. Create custom table for wordpress custom registration flow
  14. Should I use spl_autoload_register() in my plugin?
  15. How do I make an HTML table from a database table?
  16. How can I save a multiple select array with the settings API for a plug-in options page?
  17. Using register_activation_hook in classes
  18. Is there a way for a plugin to add an attribute to the tag of a theme?
  19. Gutenberg Blocks doesn’t render correctly when using do_blocks
  20. Does WordPress cache get_user_meta() results?
  21. Why WordPress uses 4 tables to manage terms
  22. My shortcode is showing up twice
  23. Database “Migration” for Plugins?
  24. No wp-config.php file on local install of wordpress – site still displays
  25. How to find the output of contact form 7 shortcode? [closed]
  26. Issue with foreach on duplicate meta_key’s
  27. Does wp-cron runs all tasks scheduled at same time together or one after other?
  28. Making Quote Plugin more efficient
  29. Different database query in function.php using mysqli
  30. How do I use the Simple HTML DOM Parser in plugin when other plugin already uses it?
  31. Will simple function names in a class structure conflict with other plugins?
  32. Instantiate class to be available to all plugin functions
  33. How to test nonce with AJAX – Plugin development
  34. How can i upload images in an admin page?
  35. Retrieve $_POST data submitted from external URL in WordPress(NOT API)
  36. Reprinting tags with all attributes
  37. How WordPress reacts to a lack of memory of the server [closed]
  38. database sent to a JSON file
  39. Adding function to Genesis genesis_header [closed]
  40. how to update and display an option without reloading the page
  41. How to obtain the current website URL in my theme?
  42. Filtering a Database Query
  43. Plugin Generate Unexpected output during activation
  44. Issue running db create table query from static method
  45. Undefined method class::construct() when creating a plugin
  46. Blob file download problem
  47. Hook called before text widget save
  48. How can I find the cause of a 500 server error?
  49. I can’t update my data through $wpdb
  50. Can’t successfully check if post with title exist in database
  51. Delete database record using plugin from admin panel
  52. Using admin-post.php for admin form but it directs me to admin-post.php white screen
  53. Hooks for post saving make a post-new.php to load latest post’s data
  54. Adding Additional Variables on Menus Page
  55. Add row to custom database Table and delete all rows older than 1 day
  56. Using flickr api in custom wordpress plugin
  57. Toolbar Hidden in a Virtual Page
  58. PHP: $_SESSION destroyed after page reload for my custom session
  59. How to correctly escape an echo
  60. Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing
  61. Payment field disappears on custom Paypal plugin
  62. Adding image upload in tag section – WordPress plugin development
  63. How to Remove Theme Style CSS inside Custom Plugin?
  64. Please help! I have a problem with getting wordpress databas
  65. Creating plugin with front-end pages
  66. How to Send Pingbacks for all Posts in WordPress?
  67. I am having errors with checkout on wordpress
  68. Error establishing a database connection (configuration)
  69. How can I update the price when someone enters postcode or zip code in woocommerce checkout page?
  70. 400 bad request admin-ajax file upload
  71. get Woocommerce product format json for WP_Query
  72. Update user meta when an external link in admin notice is clicked
  73. Is there an option to execute javascript file only on plugin activation
  74. How do I remove an action hook inside a class that is called by another class?
  75. The plugin generated 225 characters of unexpected output during activation
  76. Ajax in a class instantiated via shortcode
  77. Parsing webhook from Shopify in WordPress
  78. How do I fetch a data from an external database into my wordpress homepage
  79. Shortcode Works for Logged in Users but Not Working for Guest
  80. Submit to itself don’t work
  81. WordPress / PhpStorm / XDebug and plugin_dir_path issues
  82. direct query to post_meta table
  83. Send data from plugin to external database
  84. special characters not supporting in wordpress
  85. How to set max users to 17.000
  86. Unserializeing multiple column values that are stored in one database results variable
  87. Best way to define a database with product codes and back-end support?
  88. See output of a sql query while plugin installation in wordpress
  89. Why this plugin is not working?
  90. Permission error on plugin save
  91. Querying multiple meta_keys in WordPress SQL query
  92. Trying to post information from a remote database to wordpress page
  93. How to execute add_action() function from custom plugin to Crontrol plugin or do_action()?
  94. PHP Call to External Database
  95. base64_encode conflict with convert_smilies in wordpress
  96. Properly process a custom WP REST API request (Authenticate, Authorize + Validate)?
  97. Login user into magento using wordpress account
  98. save array of objects with update_option
  99. Customize create table SQL statement in any WordPress plugin
  100. Can’t insert into a database wordpress