/*
  Warnings:

  - You are about to drop the column `item_type_id` on the `TransactionItem` table. All the data in the column will be lost.
  - You are about to drop the column `pricing_detail_id` on the `TransactionItem` table. All the data in the column will be lost.
  - You are about to drop the column `pricing_header_id` on the `TransactionItem` table. All the data in the column will be lost.
  - Added the required column `modifiedBy` to the `Transaction` table without a default value. This is not possible if the table is not empty.
  - Added the required column `modified_at` to the `Transaction` table without a default value. This is not possible if the table is not empty.
  - Added the required column `itemPrice` to the `TransactionItem` table without a default value. This is not possible if the table is not empty.
  - Added the required column `itemPriceAt` to the `TransactionItem` table without a default value. This is not possible if the table is not empty.
  - Added the required column `itemType` to the `TransactionItem` table without a default value. This is not possible if the table is not empty.
  - Added the required column `modified_at` to the `TransactionItem` table without a default value. This is not possible if the table is not empty.

*/
-- DropForeignKey
ALTER TABLE "TransactionItem" DROP CONSTRAINT "TransactionItem_item_type_id_fkey";

-- DropForeignKey
ALTER TABLE "TransactionItem" DROP CONSTRAINT "TransactionItem_pricing_detail_id_fkey";

-- DropForeignKey
ALTER TABLE "TransactionItem" DROP CONSTRAINT "TransactionItem_pricing_header_id_fkey";

-- AlterTable
ALTER TABLE "Transaction" ADD COLUMN     "modifiedBy" TEXT NOT NULL,
ADD COLUMN     "modified_at" TIMESTAMP(3) NOT NULL;

-- AlterTable
ALTER TABLE "TransactionItem" DROP COLUMN "item_type_id",
DROP COLUMN "pricing_detail_id",
DROP COLUMN "pricing_header_id",
ADD COLUMN     "itemPrice" DECIMAL(18,3) NOT NULL,
ADD COLUMN     "itemPriceAt" TIMESTAMP(3) NOT NULL,
ADD COLUMN     "itemType" TEXT NOT NULL,
ADD COLUMN     "modified_at" TIMESTAMP(3) NOT NULL;
