1.mpesadb (db name)
//table example
2. CREATE TABLE mpesa_client1 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    mpesa_receipt VARCHAR(50) NOT NULL UNIQUE,
    checkoutRequestID VARCHAR(50) NOT NULL UNIQUE,
    phone VARCHAR(20) NOT NULL,
    amount DECIMAL(10,2) NOT NULL,
    trans_time DATETIME NOT NULL,
    invoice VARCHAR(50),
    status VARCHAR(50) DEFAULT 'Pending',
    sync_status TINYINT(1) DEFAULT 0,
    synced_at DATETIME NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);