<?php
/**
 * Install database table for batch request items.
 *
 * @package AIContentByParallax
 */

namespace AIContentByParallax\Database;

defined( 'ABSPATH' ) || exit;

/**
 * Create the batch request items table.
 */
class BatchRequestItemsTableInstaller {

	/**
	 * Install or upgrade the batch request items table.
	 *
	 * @return void
	 */
	public static function install() {
		global $wpdb;
		$table_name      = $wpdb->prefix . 'ai_content_by_parallax_batch_request_items';
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE $table_name (
			id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
			batch_request_id BIGINT UNSIGNED NOT NULL,
			product_id BIGINT UNSIGNED NOT NULL,
			fields_requested TEXT NOT NULL,
			status VARCHAR(50) DEFAULT 'pending',
			result LONGTEXT DEFAULT NULL,
			created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
			updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			PRIMARY KEY (id),
			KEY batch_request_id (batch_request_id),
			KEY product_id (product_id),
			KEY status (status)
		) $charset_collate;";

		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		dbDelta( $sql );
	}
}