If the code creating new tables uses dbDelta()
(it should), you can filter the query (see wp-admin/includes/upgrade.php
):
add_filter( 'dbdelta_create_queries', function( Array $queries )
{
foreach ( $queries as $table => $query )
{
if ( FALSE !== stripos( $query, 'CREATE TABLE' ) )
{
// change the query here
}
}
return $queries;
});
Related Posts:
- How to properly insert data into custom table via plugin
- How does WordPress handle MySQL row lock errors?
- Bad Request (Invalid Hostname) on working server, database problem
- Changing BIGINT to INT
- greatest() function returns undefined property
- How to write one comment and publish on every post using database or plugin?
- How to determine what is generating large amount of database queries?
- Help With MySQL to WPDB Query Conversion
- How can I perform high-level database merging for WordPress within continues delivery?
- WordPress Backend HA (Automatic failover)
- Automatic switch to backup database on fail
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- Multiple instance of data in plugin custom database table on plugin activation
- Better ads plugin has 500.000 entries in wp_postmeta
- after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
- dbDelta not adding additional columns in plugin database update
- Always get creating a new table with foreign key
- How to do database for download stats?
- DB Query not working in Plugin
- External wpdb connections in different plugins on single page
- WordPress plugin: efficient way to store large data
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
- Integrating Custom Database with WordPress
- How to display results from a data table with an encrypted user id?
- add_action for publish_post doesn’t work
- What database state changes happen after a post is manually “updated” with no changes?
- Cant create table on plugin activation
- Performing CRUD operations on front end in wordpress
- WordPress UPDATE queries on MySQL database stuck
- Store GravityForm data in phpmyadmin (mysql)
- Moving a few select DB tables to a new WP instance
- WordPress database problem wp_posts, primary key
- HyperDB failover Delay
- Write mysql credentials in plugin
- How can I delete the options from DB when the plugin is deleted?
- Does WordPress use the InnoDB engine for MySQL by default?
- How to run Two WordPress blogs with different themes and with single database and same content
- Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
- Custom database or Custom Post Types?
- How can I list only sites that use a particular theme or plugin?
- How to update widget_text in the wp_options table
- Get the last post ID
- How to count number of records found in a database table?
- prefix table and plugins
- Large database causes slow load
- clean wp_options table unused rows
- Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
- Make id column as AUTO INCREMENT on plugin activation
- How to get number of Affected rows from wordpress dbDelta() function
- MySql database help for a plugin
- How to remove Database Table in WordPress via Function file?
- Bulk edit existing shortcode within custom field
- How to access data in wordpress database externally using php
- How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
- custom user tables supported in SharDB plugin?
- Creating mySQL procedure with $wpdb
- DROP TABLE with uninstall hook not working
- how to oauth1 Wp plug-in revoke/reset.?
- WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
- Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
- WordPress Integration with Google Groups
- wp_editor content in plugin options page
- WP-DownloadManager – Query most download per week/month etc
- Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
- How do i edit the plugin files in DataBase via phpMyAdmin?
- WordPress as a data-store?
- How to insert and call new data in wordpress website database through a plugin
- Issue running db create table query from static method
- Problem of encoding characters (apostrophes) in my posts publications
- Separate database for a wordpress plugin
- What is the WordPress approach to custom data?
- How retreive saved data from gravity forms in my template?
- speed up pagination for huge database
- Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
- WordPress plugin boilerplate table create
- How to relate 3 wordpress components with each other (Create database relationships)
- Creating a search form and displaying results
- How can I store data from custom fields to custom tables?
- How to access the WordPress DB from a plugin file
- Bulk Edit Media Library alt, caption, image names
- dbDelta not CREATING TABLE
- How wordpress handle urls present in db for external wp-content directory
- Using Filters to modify contect – DB query results alwats appear fist
- Delete user meta based on key value that is an array
- Is it a good practice to use wordpress database to store pages contents which loading to page dynamically?
- Where do the section input fields values are stored in database
- How to save information related to post in database?
- RSS Feed has no Items (Possible Plugins Conflict)
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- wpdb get_var is not returning any result (verified mysql query returns only one value)
- Creating fields in the database
- Allow users to enter and edit data in one-to-many configuration
- Updating WordPress [closed]
- how to search through plugin in wordpress cimy-user-extra-fields?
- Get all the related data from WordPress DB
- Trying to insert a row from a Plugin
- Fragmented Static Conversion of WordPress Pages
- Getting 504 Gateway Timeout Error on AWS Server! [closed]
- WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
- plugin doesn’t retrieve data from database