CREATE TABLE IF NOT EXISTS Products
(
    Id INTEGER PRIMARY KEY AUTOINCREMENT,

    Brand TEXT NOT NULL,

    MainCategory TEXT NOT NULL,

    SubCategory TEXT NOT NULL,

    ProductName TEXT NOT NULL,

    ProductImage TEXT NOT NULL,

    ProductDescription TEXT NOT NULL
);
INSERT INTO Products
(
    Brand,
    MainCategory,
    SubCategory,
    ProductName,
    ProductImage,
    ProductDescription
)
VALUES
(
    'Marry Me',
    'Women',
    'Hair Care',
    'Argan Repair Shampoo',
    '/images/products/argan-shampoo.jpg',
    'Nourishing shampoo designed to repair damaged hair and improve softness.'
);