Laravel Migration System for database tables

Question

Due to Laravel migration system, we can create database tables by running the following command lines.

php artisan migrate:make create_users_table

class CreateUserTable extends Migration {
  public function up() {
    Schema::create('users', function($table)
    {
      $table->increments('id');
      $table->string('email')->unique();
      $table->string('name');
      $table->timestamps();
   });
 }

 public function down() {
   Schema::drop('users');
   }
 }

php artisan migrate

If I work with relational database and have two tables, A and B. Table A is related to table B by a foreign key. Is it possible to create such database tables with Laravel Migration System? Or do I need to configure the relationship in phpmyadmin manually?

In addition to the two answers below, I'd also add that it's perfectly acceptable to use DB::statement() in the migrations for complex SQL. — Kryten
– Kryten, Commented Jul 9, 2014 at 13:33

Vijayaragavendran · Accepted Answer · 2014-07-09 12:43:01Z

1

yes its possible to create forgien keys in laravel migration

$table->foreign('fk_id')->references('primary_key')->on('fk_table')->onDelete('cascade');

answered Jul 9, 2014 at 12:43

Vijayaragavendran

7011 gold badge10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt The Ninja · Accepted Answer · 2014-07-09 12:43:54Z

1

You can set foreign keys etc using the schema see here.

Example...

$table->foreign('user_id')
      ->references('id')->on('users')
      ->onDelete('cascade');

Also if you are creating tables I would advise using this site to help build your schema, much easier to visualise and work with.

answered Jul 9, 2014 at 12:43

Matt The Ninja

2,7315 gold badges33 silver badges62 bronze badges

Collectives™ on Stack Overflow

Laravel Migration System for database tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related