ventrec/timestampr

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

1.0.5 2017-05-16 12:41 UTC

Requires

• php: >=5.6.0
• symfony/console: >=2.0.0
• vlucas/phpdotenv: ^2.4

MIT

• Runar Jørgensen

• mysql
• timestamp

README

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