// function up default public function up() { Schema::create('tests', function (Blueprint $table) { $table->id(); $table->timestamps(); }); } // function down default public function down() { Schema::dropIfExists('tests'); } // column uuid $table->uuid('id'); // column string $table->string('caption'); // column boolean $table->boolean('do'); // column datetime $table->dateTime('date'); // column jsonb $table->jsonb('config'); // column integer $table->integer('point'); // column text $table->text('desc'); // column is primary $table->uuid('id')->primary(); // column is index $table->string('type')->index(); // column is nullable $table->text('description')->nullable(); // column is unsigned $table->integer('order')->unsigned(); // colimn is default value $table->boolean('publish_score')->default(false); // drop column $table->dropColumn('alt_absence_config'); // example while add new column on table public function up() { Schema::table('deeds', function (Blueprint $table) { $table->dropColumn('deed_rule_id'); $table->boolean('do')->nullable()->change(); $table->uuid('deedable_id')->index(); $table->string('deedable_type')->index(); }); } public function down() { Schema::table('deeds', function (Blueprint $table) { $table->uuid('deed_rule_id')->index(); $table->boolean('do')->nullable(false)->change(); $table->dropColumn('deedable_id'); $table->dropColumn('deedable_type'); }); } // end example
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter