/*
  Warnings:

  - You are about to drop the column `userId` on the `kml_record` table. All the data in the column will be lost.
  - Added the required column `userID` to the `kml_record` table without a default value. This is not possible if the table is not empty.

*/
-- DropForeignKey
ALTER TABLE "kml_record" DROP CONSTRAINT "kml_record_userId_fkey";

-- AlterTable
ALTER TABLE "kml_record" DROP COLUMN "userId",
ADD COLUMN     "userID" INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE "kml_record" ADD CONSTRAINT "kml_record_userID_fkey" FOREIGN KEY ("userID") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
