CREATE TABLE follows (
    id INT AUTO_INCREMENT PRIMARY KEY,
    
    author VARCHAR(255),                    -- Owner of the account being followed
    username VARCHAR(255),                  -- Person who followed
    
    aFBNF VARCHAR(255),                     -- authorFollowerBeforeNewFollowing
    aFoBNF VARCHAR(255),                    -- authorFollowingsBeforeNewFollowing
    aFANF VARCHAR(255),                     -- authorFollowerAfterNewFollowing
    aFoANF VARCHAR(255),                    -- authorFollowingsAfterNewFollowing
    
    uFBNF VARCHAR(255),                     -- userFollowersBeforeNewFollowing
    uFoBNF VARCHAR(255),                    -- userFollowingsBeforeNewFollowing
    uFANF VARCHAR(255),                     -- userFollowersAfterNewFollowing
    uFoANF VARCHAR(255),                    -- userFollowingsAfterNewFollowing

    fulldate VARCHAR(255),                  -- Full date in readable format
    useragent VARCHAR(255),                 -- Device/browser user agent
    timestamp VARCHAR(255),                 -- Unix or formatted timestamp
    
    status VARCHAR(50) DEFAULT 'pending',   -- Can be 'pending', 'success', 'cancelled', or 'unknown'
    txid VARCHAR(255)                       -- Transaction ID or tracking ID
);