php - Laravel 迁移错误

Question

这个问题已经有答案了:

Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause? (9 个回答)

已关闭 7 年前。

创建了新的 Laravel 5.2.8 项目。

当我想要进行预定义迁移时，出现错误:

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURREN
T_TIMESTAMP in DEFAULT or ON UPDATE clause (SQL: create table `users` (`id` int unsigned not null auto_increment pr
imary key, `name` varchar(255) not null, `email` varchar(255) not null, `password` varchar(60) not null, `remember_
token` varchar(100) null, `created_at` timestamp default CURRENT_TIMESTAMP not null, `updated_at` timestamp default
CURRENT_TIMESTAMP not null) default character set utf8 collate utf8_unicode_ci)



[PDOException]
SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURREN
T_TIMESTAMP in DEFAULT or ON UPDATE clause

迁移:

Schema::create('users', function (Blueprint $table) {
   $table->increments('id');
   $table->string('name');
   $table->string('email')->unique();
   $table->string('password', 60);
   $table->rememberToken();
   $table->timestamps();
});

如何解决这个问题？

Answer 1

错误准确地告诉你出了什么问题。查看您的CREATE TABLE语句；您不能有两列带有 timestamp 且默认为 CURRENT_TIMESTAMP

SQL:

create table `users` (`id` int unsigned not null auto_increment pr
imary key, 
`name` varchar(255) not null, 
`email` varchar(255) not null, 
`password` varchar(60) not null, 
`remember_
token` varchar(100) null, 
`created_at` timestamp default CURRENT_TIMESTAMP not null, <-- here
`updated_at` timestamp default CURRENT_TIMESTAMP not null) <-- here
default character set utf8 collate utf8_unicode_ci;