/*
  Warnings:

  - Made the column `mobile` on table `candidate` required. This step will fail if there are existing NULL values in that column.

*/
-- AlterTable
ALTER TABLE "candidate" ADD COLUMN     "user_id" TEXT,
ALTER COLUMN "mobile" SET NOT NULL,
ALTER COLUMN "address" DROP NOT NULL,
ALTER COLUMN "gender" DROP NOT NULL,
ALTER COLUMN "designation" DROP NOT NULL,
ALTER COLUMN "client_ip" DROP NOT NULL,
ALTER COLUMN "is_handicapped" DROP NOT NULL;

-- AddForeignKey
ALTER TABLE "candidate" ADD FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE CASCADE;
