Legacy Prisma Migrate

1. Create the User table to store user information (name, email, ...)

CREATE TABLE "User" (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255) NOT NULL
);

2. Create two new tables Post and Profile with foreign keys to User

CREATE TABLE "Profile" (
    id SERIAL PRIMARY KEY,
    bio TEXT NOT NULL,
    "user" integer NOT NULL UNIQUE,
    FOREIGN KEY ("user") REFERENCES "User"(id)
);
CREATE TABLE "Post" (
    id SERIAL PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    author integer NOT NULL,
    FOREIGN KEY (author) REFERENCES "User"(id)
);

3. Add a new column with a default value to the Post table

ALTER TABLE "Post"
ADD COLUMN published BOOLEAN DEFAULT false;

1. Create the User table to store user information (name, email, ...)

Add the model to your Prisma schema:

model User {
  id    Int     @id @default(autoincrement())
  name  String?
  email String  @unique
}

Now run the two commands mentioned above:

$prisma migrate save --experimental
$prisma migrate up --experimental

2. Create two new tables Post and Profile with foreign keys to User

Add two models with relation fields to your Prisma schema:

model User {
  id      Int      @id @default(autoincrement())
  name    String?
  email   String   @unique
  posts   Post[]
  profile Profile?
}

model Profile {
  id     Int    @id @default(autoincrement())
  bio    String
  user   User   @relation(fields: [userId], references: [id])
  userId Int
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  author   User   @relation(fields: [authorId], references: [id])
  authorId Int
}

Notice that in addition to the annotated relation fields and its relation scalar field (which represent the foreign keys), you must also specify the Prisma-level relation fields on the other side of the relation.

Now run the two commands mentioned above:

$prisma migrate save --experimental
$prisma migrate up --experimental

3. Add a new column with default value to the Post table

Add a field to the Post model:

model User {
  id      Int      @id @default(autoincrement())
  name    String?
  email   String   @unique
  posts   Post[]
  profile Profile?
}

model Profile {
  id     Int    @id @default(autoincrement())
  bio    String
  user   User   @relation(fields: [userId], references: [id])
  userId Int
}

model Post {
  id        Int     @id @default(autoincrement())
  title     String
  published Boolean @default(false)
  authorId  Int
  author    User    @relation(fields: [authorId], references: [id])
}

Now run the two commands mentioned above:

$prisma migrate save --experimental
$prisma migrate up --experimental

Create a new migration

$prisma migrate save --experimental

The command will prompt you for a name for the migration since one was not provided on the command line. After creating the migration, the contents of the generated schema.prisma file are displayed.

Create a migration with a specific name

$prisma migrate save --name "First migration" --experimental

Create the database if it does not already exist

$prisma migrate save --create-db --experimental

Preview the migration that would be created by running the migrate save command

$prisma migrate save --preview --experimental

Migrate the database up to the latest available migration

$prisma migrate up --experimental

Apply the next two migrations to the database

$prisma migrate up 2 --experimental

Apply all migrations necessary up to and including a migration by name

$prisma migrate up "First migration" --experimental

Apply all migrations necessary up to and including a migration by timestamp

$prisma migrate up 20200223181448 --experimental

Create the database if it does not already exist before applying the migrations

$prisma migrate up --create-db --experimental

Preview the migration that would be applied by running the migrate up command

$prisma migrate up --preview --experimental

Migrate the database backwards by a single migration

$prisma migrate down --experimental

Migrate the database backwards by two migrations

$prisma migrate down 2 --experimental

Migrate backwards through all migrations up to and including a migration by name

$prisma migrate down "First migration" --experimental

Migrate backwards through all migrations up to and including a migration by timestamp

$prisma migrate down 20200223181448 --experimental

Preview the migration that would be applied by running the migrate down command

$prisma migrate down --preview --experimental