Download the PHP package axn/laravel-pk-int-to-bigint without Composer
On this page you can find all versions of the php package axn/laravel-pk-int-to-bigint. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download axn/laravel-pk-int-to-bigint
More information about axn/laravel-pk-int-to-bigint
Files in axn/laravel-pk-int-to-bigint
Package laravel-pk-int-to-bigint
Short Description Convert DB primary keys and related foreign keys type from INT to BIGINT in a Laravel project
License MIT
Homepage https://github.com/AXN-Informatique/laravel-pk-int-to-bigint
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-pk-int-to-bigint
Laravel convert primary keys INT to BIGINT
This package convert DB primary keys and related foreign keys type from INT to BIGINT in a Laravel project.
This is especially useful for old projects that need to be updated.
Indeed, since Laravel 5.8 the ID columns are by default of type BIGINT. If you install new packages that use this new "standard" you will have trouble creating the foreign keys.
As a result, this package will be of great help to you to modernize an old application.
Version Compatibility
- Version 4.x: Laravel 12+ / PHP 8.4+ (uses native Laravel schema methods)
- Version 3.x: Laravel 11 / PHP 8.2+ (uses native Laravel schema methods) ⚠️ Not compatible with Laravel 12
- Version 2.x: Laravel 8-10 / PHP 8.1+ (uses Doctrine DBAL)
How it works
It proceeds in 4 steps:
- Introspection: Scans the database and verifies the integrity of foreign keys (if an integrity is not respected it stops and indicates it to you)
- Drop constraints: Temporarily drops all foreign key constraints on each table
- Convert columns: Converts INT to BIGINT on primary and foreign key columns on each table (preserving nullable, default values, and auto-increment settings)
- Restore constraints: Restores all foreign key constraints on each table with their original ON DELETE/ON UPDATE actions
Installation
Install the package with Composer:
For Laravel 11 (version 3.x):
For Laravel 8-10 (version 2.x):
Usage
⚠️ Important: First create a dump of your database in case there is a problem.
Option 1: Run manually
If you want to run the command directly:
You can specify a specific database/schema:
Option 2: With migration
Publish the migration:
So you can incorporate it into your deployment workflow with:
What gets converted
The package will convert:
- All primary key columns of type INT, TINYINT, SMALLINT, MEDIUMINT to BIGINT
- All foreign key columns of type INT, TINYINT, SMALLINT, MEDIUMINT to BIGINT
- Preserves all column attributes (nullable, default values, auto-increment)
- Preserves all foreign key constraints (ON DELETE, ON UPDATE actions)
