CREATE TABLE call_status (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id VARCHAR(50),
    user_name VARCHAR(100),
    customer_account_id VARCHAR(50),
    contact_id VARCHAR(50),
    employee_name VARCHAR(100),
    duration VARCHAR(20),
    created_at DATETIME,
    connected_at VARCHAR(20),
    ended_at DATETIME,
    source_number VARCHAR(30),
    destination_number VARCHAR(30),
    recording_file TEXT,
    call_status VARCHAR(50),
  customer_personality VARCHAR(50);
    call_validity VARCHAR(20),
    call_reason VARCHAR(100),
    call_remark TEXT,
    created_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

ALTER TABLE call_status
ADD COLUMN account_name VARCHAR(255) AFTER customer_account_id,
ADD COLUMN contact_first_name VARCHAR(255) AFTER contact_id;