<p>In <a href="https://github.com/dbsrgits/sql-translator/pull/70#discussion_r39672522">lib/SQL/Translator/Parser/SQLite.pm</a>:</p>
<pre style='color:#555'>&gt; @@ -425,7 +425,7 @@ table_constraint : PRIMARY_KEY parens_field_list conflict_clause(?)
&gt;          }
&gt;      }
&gt;      |
&gt; -    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?)
&gt; +    FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?) deferrable(?) deferred(?)
</pre>
<p>Unlike PostgreSQL, the <code>INITIALLY (DEFERRED|IMMEDIATE)</code> clause in SQLite is part of the <code>(NOT)? DEFERRABLE</code> clause. See <a href="https://sqlite.org/syntax/foreign-key-clause.html">https://sqlite.org/syntax/foreign-key-clause.html</a>.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeApmDl1YgBDEqqD7y1nyNCBP4wIuRks5oybaXgaJpZM4F-Z3L.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522"></link>
  <meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>