sqlite: cannot reference table due to type mismatch

### What happens?

Hi everyone,
I attach an sqlite in-memory database

I create two tables, the second one references the first one

I get this error

Binder Error: Failed to create foreign key: incompatible types between column "id" ("BIGINT") and column "t1_id" ("INTEGER")

### To Reproduce

INSTALL sqlite;
LOAD sqlite;
ATTACH ':memory:' AS db2 (TYPE SQLITE);

use db2;

create table t1 (
id integer primary key,
name varchar
);

create table t2(
id integer primary key,
t1_id integer references t1(id)
);

### OS:

macos

### SQLite Version:

3.46.0

### DuckDB Version:

v0.10.3

### DuckDB Client:

cli

### Affiliation:

no affiliation

### Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

- [X] I agree