CREATE TABLE Inventory
(
    hmy INT PRIMARY KEY,
    sName VARCHAR(100) NOT NULL,
    iQuantity INT NOT NULL,
    dPrice DECIMAL(10, 2) NOT NULL,
    sDescription VARCHAR(255),
    sPhotoURL VARCHAR(255)
);