<p>Well, that shouldn't be difficult in practice.<br>
All you need to do is run the migrations on the database, (continuous integration), and fetch the table-create script from the database after the migrations have run.</p>
<p>All that's possible then is that the script is not the latest version (or that the table-create-algorithm doesn't account for some new features).<br>
And then, when you need to fix mismatching data-types, you'll just need to create a migration, up-and-down, for it, and run the table-create-algorithm on the updated integration db.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/2211#issuecomment-484378370">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLOPDPMJ2AFSDAPWG6DPRAK5JANCNFSM4HGGPRKA">mute the thread</a>.<img src="https://github.com/notifications/beacon/AAK2OLOWRV7A5WXFZWQ6FXLPRAK5JANCNFSM4HGGPRKA.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/openstreetmap-website","title":"openstreetmap/openstreetmap-website","subtitle":"GitHub repository","main_image_url":"https://github.githubassets.com/images/email/message_cards/header.png","avatar_image_url":"https://github.githubassets.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/openstreetmap-website"}},"updates":{"snippets":[{"icon":"PERSON","message":"@ststeiger in #2211: Well, that shouldn't be difficult in practice. \r\nAll you need to do is run the migrations on the database, (continuous integration), and fetch the table-create script from the database after the migrations have run. \r\n\r\nAll that's possible then is that the script is not the latest version (or that the table-create-algorithm doesn't account for some new features). \r\nAnd then, when you need to fix mismatching data-types, you'll just need to create a migration, up-and-down, for it, and run the table-create-algorithm on the updated integration db. "}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/2211#issuecomment-484378370"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/2211#issuecomment-484378370",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2211#issuecomment-484378370",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>