/timestampr

Updates timestamp columns in your database that violates the new nullable requirement in newer mysql versions

Primary LanguagePHPMIT LicenseMIT

Timestampr

Timestampr is a tool that updates timestamp columns in your mysql database that is not nullable. The tool was made in order to update the database in a laravel project, hence the .env file requirement.

Installation

composer global require ventrec/timestampr

How to use it

Navigate to the root of your project folder where your .env file is located. The tool reads database parameters from the file (DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE) which is used to connect to the database. If needed, you can provide an optional parameter for the port.

Run the command.

timestampr

Run the tool with mysql port as a parameter.

timestampr 33060

License

MIT