-- Create Accounts table
CREATE TABLE IF NOT EXISTS Accounts (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    institution VARCHAR(100) NOT NULL,
    account_number VARCHAR(50) NOT NULL UNIQUE,
    account_name VARCHAR(100) NOT NULL,
    account_type ENUM('Checking', 'Saving', 'Credit') NOT NULL,
    notes TEXT
);
