/*
  Warnings:

  - You are about to drop the column `depth_cm` on the `tbl_product` table. All the data in the column will be lost.
  - You are about to drop the column `height_cm` on the `tbl_product` table. All the data in the column will be lost.
  - You are about to drop the column `product_size_per_unit` on the `tbl_product` table. All the data in the column will be lost.
  - You are about to drop the column `width_cm` on the `tbl_product` table. All the data in the column will be lost.

*/
-- AlterTable
ALTER TABLE "tbl_product" DROP COLUMN "depth_cm",
DROP COLUMN "height_cm",
DROP COLUMN "product_size_per_unit",
DROP COLUMN "width_cm",
ADD COLUMN     "case_size_quantity" VARCHAR(256),
ADD COLUMN     "depth" DECIMAL(13,2),
ADD COLUMN     "depth_type" DECIMAL(13,2),
ADD COLUMN     "height" DECIMAL(13,2),
ADD COLUMN     "height_type" DECIMAL(13,2),
ADD COLUMN     "ounce_weight" DECIMAL(13,2),
ADD COLUMN     "shipping_time_id" BIGINT,
ADD COLUMN     "width" DECIMAL(13,2),
ADD COLUMN     "width_type" DECIMAL(13,2);

-- AddForeignKey
ALTER TABLE "tbl_product" ADD CONSTRAINT "tbl_product_shipping_time_id_fkey" FOREIGN KEY ("shipping_time_id") REFERENCES "tbl_dropdown_list"("id") ON DELETE SET NULL ON UPDATE CASCADE;
