CREATE TABLE admin (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    password VARCHAR(255)
);

INSERT INTO admin (username, password)
VALUES ('fm.admin', MD5('123'));

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
);