<?php
if (!defined('ABSPATH')) {
	exit;
}

class Odoo_CRM_DB
{

	public static function create_table()
	{
		global $wpdb;

		$new_table_name = $wpdb->prefix . 'odoo_crm_logs';
		$old_table_name = $wpdb->prefix . 'odoo_failed_leads';
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE {$wpdb->prefix}odoo_crm_logs (
			id mediumint(9) NOT NULL AUTO_INCREMENT,
			time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
			email varchar(100) NOT NULL,
			payload text NOT NULL,
			response_msg text NOT NULL,
			status varchar(20) DEFAULT 'pending' NOT NULL,
			retry_count int(11) DEFAULT 0 NOT NULL,
			PRIMARY KEY  (id)
		) $charset_collate;";

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

		// Migrate data if old table exists
		if ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}odoo_failed_leads'") == $old_table_name) {
			$wpdb->query("
				INSERT INTO {$wpdb->prefix}odoo_crm_logs (time, email, payload, response_msg, status)
				SELECT time, email, payload, error_msg, status
				FROM {$wpdb->prefix}odoo_failed_leads
			");
			$wpdb->query("DROP TABLE {$wpdb->prefix}odoo_failed_leads");
		}
	}
}