title: How to create a date column not nullable?
body: <p>I'm using sqlite. I need to create a <code>date</code> column <code>not nullable</code>. I try it, but not working.</p>
  
  <pre><code>return knex.schema.table("my_table", (table) =&gt; {
    table.date("important_day").notNullable().defaultTo(knex.fn.now());
  });
  </code></pre>
  
  <p>With this code, I received this error message:</p>
  
  <blockquote>
    <p>Unhandled rejection Error: <code>SQLITE_ERROR</code>: Cannot add a column with non-constant default.
    Knex:warning - migrations failed with error: alter table <code>minisermao</code> add column <code>diaminisermao</code> date not null default <code>CURRENT_TIMESTAMP - SQLITE_ERROR</code>: Cannot add a column with non-constant default</p>
  </blockquote>
  
  <p>How to fix it?</p>