This repository was created with the following steps:
mkdir ...
cd ...
npm init -y
npm install prisma @prisma/client
npx prisma init --datasource-provider sqlite
- Create file
prisma/migrations/init/migration.sql
- Manually input this content into file:
CREATE TABLE IF NOT EXISTS "USER" ( "id" INTEGER, "email" TEXT UNIQUE, PRIMARY KEY("id") );
- Run this initial migration with
npx prisma migrate deploy
to create the SQLite database with this content