CREATE TABLE `leads` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `Status` ENUM('new', 'sale', 'lost') DEFAULT 'new',
    `postback-status` VARCHAR(50),
    `userip` VARCHAR(45),
    `firstname` VARCHAR(100),
    `lastname` VARCHAR(100),
    `email` VARCHAR(255),
    `phone` VARCHAR(50),
    `Countrycode` VARCHAR(10),
    `ClickID` VARCHAR(100),
    `ad` VARCHAR(100),
    `term` VARCHAR(100),
    `campaign` VARCHAR(100),
    `medium` VARCHAR(100),
    `lg` VARCHAR(10),
    `C1` VARCHAR(100),
    `C2` VARCHAR(100),
    `C3` VARCHAR(100),
    `C4` VARCHAR(100),
    `C5` VARCHAR(100),
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE leads ADD COLUMN vendor_current_status VARCHAR(255) DEFAULT NULL; 