Skip to content

Instantly share code, notes, and snippets.

@UsamaAshraf
Created January 9, 2017 10:09
Show Gist options
  • Save UsamaAshraf/43599f3dde6338d17dbf2a27b2d0c499 to your computer and use it in GitHub Desktop.
Save UsamaAshraf/43599f3dde6338d17dbf2a27b2d0c499 to your computer and use it in GitHub Desktop.
public function up()
{
Schema::table('jobs', function (Blueprint $table) {
$table->dropIndex('jobs_queue_reserved_reserved_at_index');
$table->dropColumn('reserved');
$table->index(['queue', 'reserved_at']);
});
Schema::table('failed_jobs', function (Blueprint $table) {
$table->longText('exception')->after('payload');
});
}
public function down()
{
Schema::table('jobs', function (Blueprint $table) {
$table->tinyInteger('reserved')->unsigned();
$table->index(['queue', 'reserved', 'reserved_at']);
$table->dropIndex('jobs_queue_reserved_at_index');
});
Schema::table('failed_jobs', function (Blueprint $table) {
$table->dropColumn('exception');
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment