/*
  Warnings:

  - You are about to drop the column `numberOfOccupants` on the `User_Building_Commodity_Utitlity` table. All the data in the column will be lost.
  - You are about to drop the column `user_building_commodity_utility_id` on the `User_Building_Details` table. All the data in the column will be lost.
  - Added the required column `noOfOccupants` to the `User_Building_Details` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `User_Building_Commodity_Utitlity` DROP COLUMN `numberOfOccupants`;

-- AlterTable
ALTER TABLE `User_Building_Details` DROP COLUMN `user_building_commodity_utility_id`,
    ADD COLUMN `noOfOccupants` VARCHAR(191) NOT NULL;