table_name()} ( `id` int NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL, `key` longtext NOT NULL, `value` longtext, `meta_key` longtext, `meta_value` longtext, UNIQUE KEY (`id`) ) {$this->charset_collate( true )};"; dbDelta( $query ); } /** * Function to be run as part of our CacheCollateForms required update. * * @since 3.4.0 */ public function cache_collate_forms() { global $wpdb; // If the meta_key column exists... if ( $this->column_exists( 'meta_key' ) ) { // Update our existing columns. $query = "ALTER TABLE {$this->table_name()} MODIFY `meta_key` longtext {$this->charset_collate()}, MODIFY `meta_value` longtext {$this->charset_collate()};"; } // Otherwise... (The meta_key column does not exist.) else { // Create the new columns. $query = "ALTER TABLE {$this->table_name()} ADD `meta_key` longtext {$this->charset_collate()}, ADD `meta_value` longtext {$this->charset_collate()};"; } $wpdb->query( $query ); } }