/*
  Warnings:

  - Added the required column `room_activity_id` to the `Rooms` table without a default value. This is not possible if the table is not empty.
  - Added the required column `charging_hours` to the `User_Building_EV_Charger_Model` table without a default value. This is not possible if the table is not empty.
  - Added the required column `no_of_ev_chargers` to the `User_Building_EV_Charger_Model` table without a default value. This is not possible if the table is not empty.
  - Added the required column `power_rating` to the `User_Building_EV_Charger_Model` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `Rooms` ADD COLUMN `room_activity_id` VARCHAR(191) NOT NULL;

-- AlterTable
ALTER TABLE `User_Building_EV_Charger_Model` ADD COLUMN `charging_hours` VARCHAR(191) NOT NULL,
    ADD COLUMN `no_of_ev_chargers` VARCHAR(191) NOT NULL,
    ADD COLUMN `power_rating` VARCHAR(191) NOT NULL;

-- AddForeignKey
ALTER TABLE `Rooms` ADD CONSTRAINT `Rooms_room_activity_id_fkey` FOREIGN KEY (`room_activity_id`) REFERENCES `Room_Activities_Information`(`room_activity_info_id`) ON DELETE RESTRICT ON UPDATE CASCADE;
