Setting Default Value for Primary Key in Laravel Migration for sqlite

Question

I've created the database migration below. What I'd like to do is create an accounts table with an id as a primary key. However, I don't want the key to autoincrement starting at 1. Rather, I'd like it to autoincrement starting at 800500.

Is there a way to set the default value of a primary key like this?

I'm currently using Laravel v4.2.11 and sqlite v3.8.3.

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateAccountsTable extends Migration {

/**
 * Run the migrations.
 *
 * @return void
 */
public function up()
{
    Schema::create('accounts', function(Blueprint $table)
    {
        $table->increments('id')->unsigned()->default(800500);
        $table->string('name', 100);
        $table->timestamps();
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::drop('accounts');
}

}

Community · Accepted Answer · 2017-05-23 11:57:56Z

1

The default method in the schema builder

Declare(s) a default value for a column

If you need the increment to start at a given value take a look at this answer. You'd add the query to the migration:

public function up()
{       
    Schema::create('accounts', function(Blueprint $table)
    {
        $table->increments('id');
        $table->string('name', 100);
        $table->timestamps();
    });
    DB::statement("UPDATE SQLITE_SEQUENCE SET seq = 800500 WHERE name = 'accounts'");
}

There is no 'laravel' way to do this.

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Nov 26, 2014 at 22:08

edpaez

1,5831 gold badge12 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Graham Kennedy Over a year ago

Thanks for the quick reply, @edpaez. Unfortunately that didn't do it. When I ran the seed file after running the migration as you've set out, it still returns an ID of 1 for my first record. I should have known better that default is the default for a column and not a initial value. D'oh.

Collectives™ on Stack Overflow

Setting Default Value for Primary Key in Laravel Migration for sqlite

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related