Creating migrations in Supabase - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new migration with Supabase CLI.

Supabase

supabase [1] new add_users_table

Drag options to blanks, or click blank then click option'

Astart

Bmigration

Cmigrate

Dmigrations

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'migrate' instead of 'migration'.

Using plural 'migrations'.

The correct command to create a new migration is supabase migration new.

2fill in blank

medium

Complete the code to apply all pending migrations to the database.

Supabase

supabase [1] up

Drag options to blanks, or click blank then click option'

Amigrations

Bmigration

Cdeploy

Dmigrate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'migrations' plural instead of singular.

Using 'deploy' which is not a valid command here.

The command to apply migrations is supabase migrate up.

3fill in blank

hard

Fix the error in the command to rollback the last migration.

Supabase

supabase migration [1]

Drag options to blanks, or click blank then click option'

Adown

Brollback

Cundo

Drevert

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'undo' which is not a valid command.

Using 'rollback' or 'revert' which are not recognized.

The correct command to rollback the last migration is supabase migrate down.

4fill in blank

hard

Fill both blanks to create a migration file with a descriptive name and apply it.

Supabase

supabase [1] new [2] && supabase migration up

Drag options to blanks, or click blank then click option'

Amigration

Bmigrations

Cadd_orders_table

Dupdate_schema

Attempts:

3 left

💡 Hint

Common Mistakes

Using plural 'migrations' in the first blank.

Using a generic name instead of descriptive migration name.

Use supabase migration new add_orders_table to create the migration file, then apply it.

5fill in blank

hard

Fill all three blanks to create a migration, apply it, and check the migration status.

Supabase

supabase [1] new [2] && supabase migration [3]

Drag options to blanks, or click blank then click option'

Amigration

Badd_products_table

Cstatus

Dup

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'migrations' instead of 'migration' in the first blank.

Using 'up' instead of 'status' to check migrations.

Create the migration with migration new add_products_table, then check status with migration status.