执行数据库迁移报错,多个主键的问题?
Schema::create('member_personality_grade', function (Blueprint $table) {
$table->integer('member_id')->unsigned();
$table->integer('personality_id')->unsigned();
$table->decimal('grade',3,1)->default(0.0)->comment('得分');
$table->tinyInteger('weight')->default(0);
$table->char('order_number',36)->default('')->comment('订单号');
$table->primary(['member_id','personality_id','order_number']);
});
SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'member_personality_grade_member_id_personality_id_order_number_primary' is too long (SQL:
alter table member_personality_grade
add primary key member_personality_grade_member_id_personality_id_order_number_primary
(member_id
, personality_id
, order_number
))
推荐文章: