<p>Since SQLite doesn't support altering existing columns, sql-translator achieves this by creating a new table with the correct schema and copying the data over.  It first copies the data into a temporary table, though.  If the table includes a foreign key constraint it cannot be satisfied because the temporary table is in a different SQLite schema.  Should sql-translator create the new table in the main database so that foreign keys work or do applications need to disable (or just not enable to begin with) foreign key constraints for sql translator?</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/95">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAqkpSAvQnDYHU97D4auuzYkb-7zeks5sc2nUgaJpZM4PFRMi">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeApylyp4KGKNUMWMqWt7vzGmBVBnwks5sc2nUgaJpZM4PFRMi.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/issues/95"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"SQLite diff producer creates broken foreign key constraints (#95)"}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/95"}}}</script>