

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    category VARCHAR(50),
    name VARCHAR(100),
    last4 VARCHAR(10),
    amount DECIMAL(10,2),
    tdate DATE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);