Download the PHP package sausin/laravel-set-autoincrement without Composer
On this page you can find all versions of the php package sausin/laravel-set-autoincrement. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sausin/laravel-set-autoincrement
More information about sausin/laravel-set-autoincrement
Files in sausin/laravel-set-autoincrement
Package laravel-set-autoincrement
Short Description Package to help with update of auto increment for database tables in laravel
License MIT
Informations about the package laravel-set-autoincrement
Laravel package to set custom Auto Increment in database
Wanted to easily set the starting ID for your models? This package makes it easy as a breeze! It's also possible to change auto increment on existing databases (i.e. new entries will start from the specified number).
Installation
Run the below command in your Laravel project root.
This will install the latest version of the package for you. The service provider will automatically register and make available the features of the package (which work automatically).
Configuration
The default configuration will set the package such that except a few tables, the AUTO_INCREMENT
counter will be set at 100001
(one hundred thousand and one).
To change the starting value and the tables affected by it, the configuration can be published using
and then the option which corresponds to Sausin\DBSetAutoIncrement\AutoIncrementServiceProvider
needs to be selected. This will add a config named auto-increment.php
in your project's config folder.
Change the values as desired.
Usage
Default Behavior
It will run every time migrations are finished running, whether for the first time or incremental. All tables where the AUTO_INCREMENT
value is higher than the value in the config will be left alone. Changes will be made in all the rest.
If, however, automatic updation behaviour is not desired, the action
key in the config file can be changed to manual
and the package will not take automatic action.
Command line
Using the below command
the auto increment value can be changed manually. Multiple tables are accepted as input.
Supported SQL Drivers
Currently mysql
and sqlite
are supported. Plan to have support for more drivers in future.
All versions of laravel-set-autoincrement with dependencies
doctrine/dbal Version ^2.10
illuminate/support Version ^5.8|^6.0|^7.0|^8.0
illuminate/contracts Version ^5.8|^6.0|^7.0|^8.0
illuminate/database Version ^5.8|^6.0|^7.0|^8.0
illuminate/queue Version ^5.8|^6.0|^7.0|^8.0
illuminate/events Version ^5.8|^6.0|^7.0|^8.0