How to create multiple primary key with auto_increment include in laravel migrations?

Question

I've just new with Laravel. I have a problem when doing migrations. My Schema is just like this

public function up()
{
    Schema::create('journal', function($table){
        $table->increments('id');
        $table->timestamp('journal_date');
        $table->string('no_ref',25);
        $table->string('acc_id', 10);
        $table->string('description', 100);
        $table->integer('debet')->default(0);
        $table->integer('kredit')->default(0);
        $table->primary(array('journal_date', 'no_ref', 'acc_id'));
    });
}

Then when running PHP artisan migrate I get an an error

[Illuminate\Database\QueryException]                                                                                                                                                            
SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key 
defined (SQL: alter table `journal` add primary key 
journal_journal_date_no_ref_acc_id_primary(`journal_date`,   
`no_ref`, `acc_id`))

I did some advice to drop primary but this will drop auto increment too. I just don't know how to figure it out.

No no no, its different. This case is not about foreign key but multiple primary key, which is include auto_increment — Santo Doni Romadhoni
– Santo Doni Romadhoni, Commented May 29, 2014 at 9:14

Santo Doni Romadhoni · Accepted Answer · 2014-05-30 10:25:15Z

3

Finally, I found the answer. I've just used DB::statement like this

                DB::statement('ALTER TABLE  `journal` DROP PRIMARY KEY , ADD PRIMARY KEY (  `id` ,  `journal_date` ,  `no_ref` ,  `acc_id` ) ;');

And my problem solved.

answered May 30, 2014 at 10:25

Santo Doni Romadhoni

811 silver badge8 bronze badges

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

Comments

Alleks · Accepted Answer · 2018-10-18 07:22:52Z

1

The auto-increment field must be a key (for example, MySQL will not even allow you to define an auto_increment column if it is not a key). That's probably why you're not able to simply drop the key.Define a second key for the field before dropping. ($table->increments('id')->unique();).

    public function up() {
    Schema::create('journal', function($table) {
        $table->increments('id')->unique();
        $table->timestamp('journal_date');
        $table->string('no_ref', 25);
        $table->string('acc_id', 10);
        $table->string('description', 100);
        $table->integer('debet')->default(0);
        $table->integer('kredit')->default(0);

    });
    Schema::table('journal', function($table) {
        $table->dropPrimary('id');
        $table->primary(['journal_date', 'no_ref', 'acc_id']);
    });
}

edited Oct 18, 2018 at 7:22

answered Oct 17, 2018 at 21:20

Alleks

112 bronze badges

1 Comment

Marcello B. Over a year ago

Welcome to StackOverflow. Can you please provide a description on how your code works? That way people who stumble across your answer understand what it is doing and how it is doing it? Please read this article to get a better understand of what an answer is. Please also go through the site tour

Balasubramani Samiyappan · Accepted Answer · 2017-02-07 04:47:34Z

0

I found this solution, Please follow up. The small changes in create the primary key.

public function up()
{
//
    Schema::create('journal', function($table){
        $table->unsignedInteger('id');
        $table->timestamp('journal_date');
        $table->string('no_ref',25);
        $table->string('acc_id', 10);
        $table->string('description', 100);
        $table->integer('debet')->default(0);
        $table->integer('kredit')->default(0);
        $table->primary(array('id', 'journal_date', 'no_ref', 'acc_id'));
    });
}

answered Feb 7, 2017 at 4:47

Balasubramani Samiyappan

10812 bronze badges

Collectives™ on Stack Overflow

How to create multiple primary key with auto_increment include in laravel migrations?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related