Skip to content

Instantly share code, notes, and snippets.

@andidp
Created August 9, 2016 02:47
Show Gist options
  • Save andidp/7eb1102954188bbe3554343c5b83e238 to your computer and use it in GitHub Desktop.
Save andidp/7eb1102954188bbe3554343c5b83e238 to your computer and use it in GitHub Desktop.
laravel migration file for creating questions and answers tables
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateQuestionsAndAnswersTables extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('questions', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->mediumText('body');
$table->timestamps();
});
Schema::create('answers', function (Blueprint $table) {
$table->increments('id');
$table->integer('question_id')->unsigned()->default(0);
$table->foreign('question_id')->references('id')->on('questions')->onDelete('cascade');
$table->string('title');
$table->text('body');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('questions');
Schema::drop('answers');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment