get_charset_collate(); $table = $wpdb->prefix . 'fluentform_order_items'; if ($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) { $sql = "CREATE TABLE $table ( `id` int(11) NOT NULL AUTO_INCREMENT, `form_id` int(11) NOT NULL, `submission_id` int(11) NOT NULL, `type` varchar(255) DEFAULT 'single', `parent_holder` varchar(255), `billing_interval` varchar(255), `item_name` varchar(255), `quantity` int(11) DEFAULT 1, `item_price` BIGINT UNSIGNED, `line_total` BIGINT UNSIGNED, `created_at` timestamp NULL, `updated_at` timestamp NULL, PRIMARY KEY (`id`) ) $charsetCollate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } else { self::maybeAlterColumns(); } } public static function maybeAlterColumns() { global $wpdb; $table = $wpdb->prefix . 'fluentform_order_items'; // find the data types of each column $results = $wpdb->get_results("DESCRIBE $table"); $items = []; foreach ($results as $result) { $items[$result->Field] = $result->Type; } $isBigInItemPrice = strpos($items['item_price'], 'bigint') !== false;; $isBigInitPrice = strpos($items['line_total'], 'bigint') !== false;; // if not big int convert to big int if (!$isBigInItemPrice) { $wpdb->query("ALTER TABLE $table MODIFY item_price BIGINT UNSIGNED"); } if (!$isBigInitPrice) { $wpdb->query("ALTER TABLE $table MODIFY line_total BIGINT UNSIGNED"); } } }