Schema::create('table', function($table) { $table->increments('id'); }); // Specify a Connection Schema::connection('foo')->create('table', function($table){}); Schema::rename($from, $to); Schema::drop('table'); Schema::dropIfExists('table'); Schema::hasTable('table'); Schema::hasColumn('table', 'column'); // Update an existing table Schema::table('table', function($table){}); $table->renameColumn('from', 'to'); $table->dropColumn(string|array); $table->engine = 'InnoDB'; // Only work on MySQL $table->string('name')->after('email'); Indexes $table->string('column')->unique(); $table->primary('column'); // Creates a dual primary key $table->primary(array('first', 'last')); $table->unique('column'); $table->unique('column', 'key_name'); // Creates a dual unique index $table->unique(array('first', 'last')); $table->unique(array('first', 'last'), 'key_name'); $table->index('column'); $table->index('column', 'key_name'); // Creates a dual index $table->index(array('first', 'last')); $table->index(array('first', 'last'), 'key_name'); $table->dropPrimary('table_column_primary'); $table->dropUnique('table_column_unique'); $table->dropIndex('table_column_index'); Foreign Keys $table->foreign('user_id')->references('id')->on('users'); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->dropForeign('posts_user_id_foreign'); Column Types $table->increments('id'); $table->bigIncrements('id'); $table->string('email'); $table->string('name', 100); $table->integer('votes'); $table->bigInteger('votes'); $table->smallInteger('votes'); $table->float('amount'); $table->double('column', 15, 8); $table->decimal('amount', 5, 2); $table->boolean('confirmed'); $table->date('created_at'); $table->dateTime('created_at'); $table->time('sunrise'); $table->timestamp('added_on'); $table->timestamps(); $table->softDeletes(); $table->text('description'); $table->binary('data'); $table->enum('choices', array('foo', 'bar')); $table->morphs('parent'); // Adds INTEGER parent_id and STRING parent_type ->nullable() ->default($value) ->unsigned()