-- DropIndex
DROP INDEX `purchases_lot_no_key` ON `purchases`;

-- AlterTable
ALTER TABLE `purchases` ADD COLUMN `status` ENUM('ACTIVE', 'DEPLETED', 'CLOSED') NOT NULL DEFAULT 'ACTIVE';

-- CreateIndex
CREATE INDEX `purchases_lot_no_vegetable_id_idx` ON `purchases`(`lot_no`, `vegetable_id`);