CODEWITHSUNDEEP
phplaraveldatabase-migrationlaravel-migrations
Istiaque Ahmed
Istiaque Ahmed

Reputation: 6498

Laravel migration - how to change the `id` field to be primary and auto-incrementing later

My table 'sales_order_details' has the id field as integer 'int(10)' with a default value 0. I need to change it to be a primary auto-increment key in migration.

I tried in the following way :

 public function up()
    {
        Schema::table('sales_order_details', function (Blueprint $table){

         $table->integer('id')->default(NULL)->change();
         $table->increments('id')->change();

       });
    }

  public function down()
    {
        Schema::table('sales_order_details', function (Blueprint $table){
        $table->dropPrimary('id')->change();

       });
    }

I get the following errors:

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key (SQL: ALTER TABLE sales_order_details CHANGE id id INT UNSIGNED AUTO_INCREM ENT NOT NULL)

[Doctrine\DBAL\Driver\PDOException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key

How to make the migration properly ? I am using version 5.4

Upvotes: 3

Views: 5914

Answers (1)

Yashvantsinh Zala
Yashvantsinh Zala

Reputation: 531

You can try like this

  public function up()
    {
        DB::statement("ALTER TABLE sales_order_details MODIFY id INT NOT NULL PRIMARY KEY AUTO_INCREMENT");            
    }

  public function down()
    {
        DB::statement("ALTER TABLE sales_order_details MODIFY id INT NOT NULL");
        DB::statement("ALTER TABLE sales_order_details DROP PRIMARY KEY");
        DB::statement("ALTER TABLE sales_order_details MODIFY id INT NULL");
    }

This is the one of the way you can achieve your goal, i hope this is helpful for you

Upvotes: 5

Related Questions