Page 410 - MDP2022-2

-- CreateTable
CREATE TABLE `Queue` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`authorId` INTEGER NOT NULL,

PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `Queue` ADD CONSTRAINT `Queue_authorId_fkey` FOREIGN KEY (`authorId`)
REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- CreateIndex
CREATE UNIQUE INDEX `User_userId_key` ON `User`(`userId`);

-- DropForeignKey
ALTER TABLE `queue` DROP FOREIGN KEY `Queue_authorId_fkey`;

-- AlterTable
ALTER TABLE `queue` DROP COLUMN `authorId`,
ADD COLUMN `usedId` INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE `Queue` ADD CONSTRAINT `Queue_usedId_fkey` FOREIGN KEY (`usedId`)
REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AlterTable
ALTER TABLE `queue` ADD COLUMN `createdAt` DATETIME(3) NOT NULL DEFAULT
CURRENT_TIMESTAMP(3),
ADD COLUMN `reservationTime` DATETIME(3) NOT NULL;

-- DropForeignKey
ALTER TABLE `queue` DROP FOREIGN KEY `Queue_usedId_fkey`;

-- AlterTable
ALTER TABLE `queue` DROP COLUMN `usedId`,
ADD COLUMN `name` VARCHAR(191) NOT NULL;

-- AlterTable
ALTER TABLE `user` ADD COLUMN `nickname` VARCHAR(191) NOT NULL;

prisma/schema.prisma
generator client {
provider = "prisma-client-js"a