如何在 Laravel 4 中使用 BIGINT 作为自增主键

我正在尝试模仿 wordpress 的主键大小 这是 BIGINT(20) 但似乎 laravel 没有本机功能来执行此操作.. 我看到了 laravel 论坛中的页面 并得到这样的代码:

$table->bigInteger('id')->primary();

但是当我在 artisan migrate 期间尝试将外键附加到该 id 时，会抛出一个 MYSQL 错误:

<块引用><块引用>

[例外]SQLSTATE[HY000]:一般错误:1005 无法创建表 'db.#sql-1730_15' (errno: 150) (SQL: alter table users 添加约束 users_role_id_foreign 外键 (role_id) 引用 roles (id))(绑定:数组())

这样做的正确方法是什么，或者我在哪里弄错了?

谢谢！

解决方案

您很可能忘记将您的 role_id 外键的类型也设置为 BIGINT(20).这实际上不是 Laravel 的问题，而是 MySQL 的问题.

<小时>

顺便说一句，Laravel 确实有一个原生函数可以做到这一点:

$this->bigIncrements('id');

这会使其无符号、自动递增和主键.

I am trying to mimic wordpress' primary key size which is BIGINT(20) but it seems that laravel doesn't have a native function to do this.. I saw a page in the laravel forums and got a code like this:

$table->bigInteger('id')->primary();

but when i try to attach a foreign key to that id during artisan migrate, there is a MYSQL error that is thrown:

[Exception] SQLSTATE[HY000]: General error: 1005 Can't create table 'db.#sql- 1730_15' (errno: 150) (SQL: alter table users add constraint users_role_id_foreign foreign key (role_id) references roles (id)) (Bindings: array ( ))

What is the proper way to do this or where do i get this thing wrong?

thanks!

解决方案

You most likely forgot to also set the type of your role_id foreign key as BIGINT(20) as well. This isn't really a Laravel issue, but rather MySQL's.

---

By the way, Laravel does have a native function to do this:

$this->bigIncrements('id');

This takes care of making it unsigned, auto increment and primary key.