knex/test/integration/migrate/null_timestamp_default/01_create.js

exports.up = function(knex, Promise) {
  return knex.schema.createTable('null_date', function(t) {
    t.increments('id').primary();
    t.string('dummy');
    t.timestamp('deleted_at')
      .nullable()
      .defaultTo(null);
  });
};

exports.down = (knex) => {
  return knex.schema.dropTable('null_date');
};
Support nullable timestamps on MySQL (#3100) * Add test to recreate the issue * Improve test, add some documentation * Improve test * Add explicit nullable flag to column * Set nullability explicitly on MySQL to deal with timestamp edge case * Use same assertion for everything 2019-03-30 14:58:56 +01:00			`exports.up = function(knex, Promise) {`
Docker based test dbs (#3157) * Fixed some of the tests failing with various dialect combinations * Setup all test databases to run in docker * Fixed test suite and updated travis to use docker * Fixed some tests in master and disabled oracle tests while setting everything else to work again * Changed docker to use latest postgresql alpine image * Re-enabled all oracledb tests * Install oracle client libs to oracle server and copy them to travis to make node oracledb package to work * Disabled random failing oracle tests and added test to show that oracle update in transaction does not seem to work ACID * Update package.json * Update package.json * Fixed linting issues * Fixed waiting for postgres to use the same DB image that database is using. * Removed installing oracledb driver in travis if not needed .travis.yml * Cleaned up package.json more * Created static name for oracledb container to allow copying files out of it on different docker versions * Removed webpack from deps 2019-05-13 12:21:36 +03:00			`return knex.schema.createTable('null_date', function(t) {`
			`t.increments('id').primary();`
			`t.string('dummy');`
			`t.timestamp('deleted_at')`
			`.nullable()`
			`.defaultTo(null);`
			`});`
Support nullable timestamps on MySQL (#3100) * Add test to recreate the issue * Improve test, add some documentation * Improve test * Add explicit nullable flag to column * Set nullability explicitly on MySQL to deal with timestamp edge case * Use same assertion for everything 2019-03-30 14:58:56 +01:00			`};`

			`exports.down = (knex) => {`
			`return knex.schema.dropTable('null_date');`
			`};`