<?php
class Cat_Lead_DB {

    public static function install() {
        global $wpdb;
        $table_name = $wpdb->prefix . 'cat_lead';

         // Check if the table exists to prevent ALTER TABLE errors
         if (self::table_exists($table_name)) {
            return; // Do nothing if the table already exists
        }
        
        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE $table_name (
            id INT(11) NOT NULL AUTO_INCREMENT,
            request_id VARCHAR(11) NOT NULL,
            request_type VARCHAR(25),
            current_request_status VARCHAR(25),
            branch VARCHAR(25),
            created_date TIMESTAMP,
            released_date TIMESTAMP,
            first_received_date TIMESTAMP,
            first_received_by VARCHAR(255),
            closed_date TIMESTAMP,
            closed_by VARCHAR(255),
            disposition TEXT,
            cart_info TEXT,
            rental_start_date DATE,
            rental_end_date DATE,
            utm_source VARCHAR(25),
            utm_medium VARCHAR(25),
            utm_term VARCHAR(25),
            utm_content VARCHAR(25),
            utm_campaign VARCHAR(25),
            referring_url VARCHAR(25),
            first_name VARCHAR(255),
            last_name VARCHAR(255),
            email_id VARCHAR(255),          
            phone VARCHAR(20),
            company_name VARCHAR(150),
            job_site_address TEXT,
            job_site_city VARCHAR(25),
            job_site_state VARCHAR(25),
            job_site_postcode VARCHAR(20),
            job_site_county VARCHAR(25),
            delivery_status VARCHAR(25),
            subscription_status VARCHAR(25),
            zift_id VARCHAR(25),
            DLMA_dealer_code VARCHAR(25),
            google_Geocode VARCHAR(100),
            dealer_Email VARCHAR(255),
            Interface VARCHAR(25),
            National_Account_Number VARCHAR(25),
            Time_Zone VARCHAR(25),  
            last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            PRIMARY KEY (id)
        ) $charset_collate;";

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

    private static function table_exists($table_name) {
        global $wpdb;
        return $wpdb->get_var("SHOW TABLES LIKE '$table_name'") === $table_name;
    }
}