CREATE TABLE product (
    id int unsigned NOT NULL auto_increment,
    name varchar(255) NOT NULL,
    vendor varchar(255) NOT NULL,
    vendorPhone varchar(20) NOT NULL,
    quantity mediumint NOT NULL,
    lastPurchased datetime,
    createdAt datetime DEFAULT NOW(),
    updatedAt datetime ON UPDATE NOW(),
    PRIMARY KEY (id)
);
