CREATE TABLE my_Products(
prodID INTEGER PRIMARY KEY AUTO_INCREMENT,
category VARCHAR(40),
description VARCHAR(250),
inventory INTEGER,
price DECIMAL(5,2),
imageFilePath VARCHAR(200)
);
INSERT INTO my_Products (category, description, inventory, price, imageFilePath) VALUES
("datasets", "2023 Sanitized CFL Dataset", 10, 22.50, "images/products/prodata.png"),
("datasets", "2023 Sanitized AUS Dataset", 10, 9.99, "images/products/usportsdata.png"),
("datasets", "2023 Sanitized RSEQ Dataset", 10, 9.99, "images/products/usportsdata.png"),
("datasets", "2023 Sanitized OUA Dataset", 10, 9.99, "images/products/usportsdata.png"),
("datasets", "2023 Sanitized CW Dataset", 2, 9.99, "images/products/usportsdata.png"),
("datasets", "2023 Sanitized USports Dataset (All Leagues)", 10, 9.99, "images/products/usportsdata.png"),
("miscellaneous", "Maroon CFCharts T-Shirt", 12, 14.00, "images/products/tshirtmaroon.png"),
("miscellaneous", "CFCharts Coffee Mug", 6, 12.99, "images/products/mugmaroon.png"),
("books", "2024 English Guidebook (Pre-Order)", 50, 40.00, "images/products/englishbook.png"),
("books", "2024 French Guidebook (Pre-Order)", 20, 39.99, "images/products/frenchbook.png");

