table_name()} ( `id` int NOT NULL AUTO_INCREMENT, `title` longtext, `key` longtext, `created_at` TIMESTAMP, `updated_at` DATETIME, `views` int(11), `subs` int(11), `form_title` longtext, `default_label_pos` varchar(15), `show_title` bit, `clear_complete` bit, `hide_complete` bit, `logged_in` bit, `seq_num` int, 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 form_title column exists... if ( $this->column_exists( 'form_title' ) ) { // Update our existing columns. $query = "ALTER TABLE {$this->table_name()} MODIFY `form_title` longtext {$this->charset_collate()}, MODIFY `default_label_pos` varchar(15) {$this->charset_collate()};"; } // Otherwise... (The form_title column does not exist.) else { // Create the new columns. $query = "ALTER TABLE {$this->table_name()} ADD `form_title` longtext {$this->charset_collate()}, ADD `default_label_pos` varchar(15) {$this->charset_collate()}, ADD `show_title` bit, ADD `clear_complete` bit, ADD `hide_complete` bit, ADD `logged_in` bit, ADD `seq_num` int;"; } $wpdb->query( $query ); } }