Laravel - Cockroach DB - Auto increment is generating UUID

Question

I am creating new migration With Laravel 5.8 and cockroachDB. I am trying with increments to generate auto increment column in laravel migration. But it is generating UUID instead of sequence. Can any one having idea please help me on this. please check my migration.

Schema::create('billing_organisations_test1', function (Blueprint $table) {
            $table->increments('id');     //bigIncrements also not working
            $table->string('name');
            $table->timestamps(6);
            $table->softDeletes('deleted_at', 6)->default(null);
        });

Laravel migration is generating the below query . How to set id column default value as auto increment.

CREATE TABLE billing_organisations_test1 (  
id INT8 NOT NULL DEFAULT unique_rowid(),
    name VARCHAR(255) NOT NULL,
    created_at TIMESTAMP NULL,
    updated_at TIMESTAMP NULL,
    deleted_at TIMESTAMP NULL,
    CONSTRAINT "primary" PRIMARY KEY (id ASC),
    FAMILY "primary" (id, name, created_at, updated_at, deleted_at)
)

Why did you add the 6 character limit to timestamps and softDelets? — konstantinkoslow, Nov 08 '19 at 02:30

score 1 · Answer 1 · answered Dec 15 '20 at 22:09

1

You need to set the serial_normalization setting to sql_sequence. Just be aware that this can decrease performance. Does the app really require incrementing IDs?

See: https://www.cockroachlabs.com/docs/stable/serial.html#modes-of-operation

answered Dec 15 '20 at 22:09

rafiss

553
3
14

score 0 · Answer 2 · edited Nov 08 '19 at 06:49

0

Try this one below your code.

DB::statement("ALTER TABLE table_name AUTO_INCREMENT = 0;");

edited Nov 08 '19 at 06:49

SuperStar518

2,814
2
20
35

answered Nov 08 '19 at 02:15

Hayato

56
7

Laravel - Cockroach DB - Auto increment is generating UUID

2 Answers2