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