Skip to content

Instantly share code, notes, and snippets.

@JeffreyWay
Last active April 28, 2016 06:19
Show Gist options
  • Save JeffreyWay/6143691 to your computer and use it in GitHub Desktop.
Save JeffreyWay/6143691 to your computer and use it in GitHub Desktop.
What else would you want on a typical pivot table...say for posts and tags.
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
class PivotPostTagTable extends Migration {
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('post_tag', function(Blueprint $table) {
$table->integer('post_id')->unsigned()->index();
$table->integer('tag_id')->unsigned()->index();
$table->foreign('post_id')->references('id')->on('post')->onDelete('cascade');
$table->foreign('tag_id')->references('id')->on('tag')->onDelete('cascade');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('post_tag');
}
}
@AloysA
Copy link

AloysA commented Aug 3, 2013

Could you make the foreign key constraints optional (default on is fine).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment