ifms-pti/server/prisma/migrations/20231030143815_use_date_time/migration.sql

22 lines
1.1 KiB
MySQL
Raw Permalink Normal View History

2023-10-30 16:38:56 +00:00
/*
Warnings:
- The `badPasswordTime` column on the `User` table would be dropped and recreated. This will lead to data loss if there is data in the column.
- The `extensionAttribute7` column on the `User` table would be dropped and recreated. This will lead to data loss if there is data in the column.
- The `lastLogon` column on the `User` table would be dropped and recreated. This will lead to data loss if there is data in the column.
- The `lastLogonTimestamp` column on the `User` table would be dropped and recreated. This will lead to data loss if there is data in the column.
- The `lockoutTime` column on the `User` table would be dropped and recreated. This will lead to data loss if there is data in the column.
*/
-- AlterTable
ALTER TABLE "User" DROP COLUMN "badPasswordTime",
ADD COLUMN "badPasswordTime" TIMESTAMP(3),
DROP COLUMN "extensionAttribute7",
ADD COLUMN "extensionAttribute7" TIMESTAMP(3),
DROP COLUMN "lastLogon",
ADD COLUMN "lastLogon" TIMESTAMP(3),
DROP COLUMN "lastLogonTimestamp",
ADD COLUMN "lastLogonTimestamp" TIMESTAMP(3),
DROP COLUMN "lockoutTime",
ADD COLUMN "lockoutTime" TIMESTAMP(3);