table_name()} ( `id` int NOT NULL AUTO_INCREMENT, `label` longtext, `key` longtext, `type` longtext, `parent_id` int NOT NULL, `created_at` TIMESTAMP, `updated_at` DATETIME, `field_label` longtext, `field_key` longtext, `order` int(11), `required` bit, `default_value` longtext, `label_pos` varchar(15), `personally_identifiable` bit, UNIQUE KEY (`id`) ) {$this->charset_collate( true )};"; dbDelta( $query ); } /** * Function to run our stage two upgrades. * * @since 3.3.12 * * @updated 3.4.0 */ public function cache_collate_fields() { // If the field_label column has not already been defined... if ( ! $this->column_exists( 'field_label' ) ) { global $wpdb; // Modify our table. $query = "ALTER TABLE {$this->table_name()} ADD `field_label` longtext {$this->charset_collate()}, ADD `field_key` longtext {$this->charset_collate()}, ADD `order` int(11), ADD `required` bit, ADD `default_value` longtext {$this->charset_collate()}, ADD `label_pos` varchar(15) {$this->charset_collate()}, ADD `personally_identifiable` bit, MODIFY `type` longtext {$this->charset_collate()};"; $wpdb->query( $query ); } } }