updated product table

[maskedman227]

we need to add more information in the card table so that the product page can have an in depth description.

[maskedman227]

current products table database scematic:

CREATE TABLE Products (
ID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(255) NOT NULL,
Price DECIMAL(10,2) NOT NULL,
Description TEXT,
Quantity INT DEFAULT 0,
Image_Path VARCHAR(255),
Created_At DATETIME,
Modified_At DATETIME,
Status TINYINT DEFAULT 1,
Discount DECIMAL(10,2),
Discount_ID INT,
Sticker_ID INT,
Featured TINYINT DEFAULT 0,
CONSTRAINT fk_products_discount
FOREIGN KEY (Discount_ID)
REFERENCES Discount(ID)
ON DELETE SET NULL
ON UPDATE CASCADE,
CONSTRAINT fk_products_sticker
FOREIGN KEY (Sticker_ID)
REFERENCES Stickers(ID)
ON DELETE SET NULL
ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

we need to add an indepth description, a video link and spesification