for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
Schema::create('posts', function (Blueprint $table) {
$table->id('id');
$table->foreignId('category_id')->constrained('post_categories');
$table->foreignId('user_id')->constrained();
/*$table->integer('category_id')->unsigned();
$table->foreign('category_id')->references('id')->on('post_categories');*/
$table->string('title');
$table->text('intro_text');
$table->text('body');
$table->boolean('featured')->default(0);
$table->text('before_content')->nullable();
$table->text('after_content')->nullable();
$table->string('introimage')->nullable();
$table->string('introimage_alt')->nullable();
$table->datetime('publish_at')->nullable();
$table->datetime('publish_until')->nullable();
//$table->boolean('is_published')->default(false);
$table->string('slug');
$table->timestamps();
});
}
* Reverse the migrations.
public function down()
Schema::dropIfExists('posts');
davide-casiraghi /
movement_meets_life_nova
