<p><a href="https://raw.githubusercontent.com/openstreetmap/openstreetmap-website/master/db/structure.sql" rel="nofollow">https://raw.githubusercontent.com/openstreetmap/openstreetmap-website/master/db/structure.sql</a></p>
<blockquote>
<p>Error 1750<br>
The column "users.id" doesn't have the same data-type as "client_applications.user_id"-Spalte im<br>
The constraint or index couldn't be created. See above error.</p>
</blockquote>
<p>users.id is bigint, but the references to users.id are int.<br>
This is wrong !<br>
Same thing with note_comments.</p>
<pre><code>ALTER TABLE client_applications ADD CONSTRAINT client_applications_user_id_fkey FOREIGN KEY ("user_id") REFERENCES users(id);
ALTER TABLE issue_comments ADD CONSTRAINT issue_comments_user_id_fkey FOREIGN KEY ("user_id") REFERENCES users(id);
ALTER TABLE issues ADD CONSTRAINT issues_reported_user_id_fkey FOREIGN KEY (reported_user_id) REFERENCES users(id);
ALTER TABLE issues ADD CONSTRAINT issues_resolved_by_fkey FOREIGN KEY (resolved_by) REFERENCES users(id);
ALTER TABLE issues ADD CONSTRAINT issues_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES users(id);
ALTER TABLE oauth_tokens ADD CONSTRAINT oauth_tokens_user_id_fkey FOREIGN KEY ("user_id") REFERENCES users(id);
ALTER TABLE reports ADD CONSTRAINT reports_user_id_fkey FOREIGN KEY ("user_id") REFERENCES users(id);

ALTER TABLE note_comments ADD CONSTRAINT note_comments_note_id_fkey FOREIGN KEY (note_id) REFERENCES notes(id);
</code></pre>

<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">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABWnLVPLWmZBaZD7bhH1j86z3mI9gLqwks5vhYVvgaJpZM4cxnxU">mute the thread</a>.<img src="https://github.com/notifications/beacon/ABWnLXFr3zYU3iBfOK7vdNbLZ4Kc-Qauks5vhYVvgaJpZM4cxnxU.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":"DESCRIPTION","message":"The database-schema is faulty (#2211)"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/2211"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/2211",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2211",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>