-- AlterTable
ALTER TABLE `rooms` MODIFY `categoryId` VARCHAR(191) NOT NULL;

-- CreateIndex
CREATE INDEX `rooms_categoryId_isActive_idx` ON `rooms`(`categoryId`, `isActive`);

-- AddForeignKey
ALTER TABLE `rooms` ADD CONSTRAINT `rooms_categoryId_fkey` FOREIGN KEY (`categoryId`) REFERENCES `room_categories`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
