- install mysql locally and username root password ' '
space - start mysql server
npm install -g yarnyarnNODE_ENV=dev yarn migrate// to run migrations locallyyarn dev
after running server
- add file to
some_schema.jsto/database/schemas/with db change - run `NODE_ENV=dev knex migrate:make migration_name' from root of the folder
- this will generated timestamped version of file in migrations
- now go to migrations and in respective functions
upanddowncall theupanddownfrom schemas.