calendar/packages/prisma/migrations/20240209223121_adds_user_password/migration.sql

/*
Warnings:

- You are about to drop the column `password` on the `users` table. All the data in the column will be lost.

 */
-- CreateTable
CREATE TABLE
  "UserPassword" (
    "hash" TEXT NOT NULL,
    "userId" INTEGER NOT NULL
  );

-- CreateIndex
CREATE UNIQUE INDEX "UserPassword_userId_key" ON "UserPassword" ("userId");

-- AddForeignKey
ALTER TABLE "UserPassword" ADD CONSTRAINT "UserPassword_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- Inserts current user password into new table
INSERT INTO
  "UserPassword" ("hash", "userId")
SELECT
  u."password",
  u.id
FROM
  users u
WHERE
  u."password" IS NOT NULL;

-- TODO for next migration.
-- ALTER TABLE "users" DROP COLUMN "password";