S SmartDocs
Chuỗi bài: Ricky sql 15 dòng · Cập nhật 2026-02-03

migration.sql

Ricky/StrongPassword/backend/prisma/migrations/20241201000000_init/migration.sql

-- CreateTable
CREATE TABLE "records" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "username" TEXT NOT NULL,
    "email" TEXT NOT NULL,
    "password" TEXT NOT NULL,
    "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" DATETIME NOT NULL
);

-- CreateIndex
CREATE UNIQUE INDEX "records_username_key" ON "records"("username");

-- CreateIndex
CREATE UNIQUE INDEX "records_email_key" ON "records"("email");

Bài viết liên quan