How do you add a new table in your sqlite database with sqlx?

[LeafWarrior]

Hi guys, I've been trying to add a new table in my existing database and a foreign key referencing the new table in my existing table but tauri is not letting me.

Here is my code.
Frontend: Javascript.
Backend: Rust
Database: sqlx sqlite

async fn setup_db(app: &App) -> Db {
    let mut path = app.path().app_data_dir().expect("failed to get data_dir");

    match std::fs::create_dir_all(path.clone()) {
        Ok(_) => {}
        Err(err) => {
            panic!("error creating directory {}", err);
        }
    };
 
    path.push("db.sqlite");

    Sqlite::create_database(
        format!(
            "sqlite:{}",
            path.to_str().expect("path should be something")
        )
        .as_str(),
    )
    .await
    .expect("failed to create database");
 
    let db = SqlitePoolOptions::new()
        .connect(path.to_str().unwrap())
        .await
        .unwrap();
 
    sqlx::migrate!("./migrations").run(&db).await.unwrap();
 
    db
}

Here's my migration code. customer table already exist previously and had a bunch of records. The only new column in customer is idenid. Both iden and item are the new tables.

CREATE TABLE IF NOT EXISTS iden (
    idenid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    idendesc TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS customer (
    cid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    name TEXT NOT NULL,
    address VARCHAR(100),
    phonenumber VARCHAR(35),
    FOREIGN KEY (idenid) REFERENCES iden(idenid) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS item (
    itemid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    item TEXT NOT NULL,
    description VARCHAR(500),
    price INTEGER,
    FOREIGN KEY (idenid) REFERENCES iden(idenid) ON DELETE CASCADE
);

I'm getting this error when I run my application.

thread 'main' panicked at src\lib.rs:161:51:
called `Result::unwrap()` on an `Err` value: VersionMismatch(20250124042550)
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
[0212/140512.743:ERROR:window_impl.cc(121)] Failed to unregister class Chrome_WidgetWin_0. Error = 1412

[FabianLars]

Did you try reaching out to the sqlx community? There's nothing tauri specific about your question so i assume they can help you better than us.

[LeafWarrior]

ok, I can do that. But how do you normally add a new table after the database has been created and have data in tauri though?

[FabianLars]

idk, which is why i redirected you🤷 did you search for VersionMismatch in the sqlx repo? There are a few discussions about it with some suggestions being as simple as running cargo clean before trying again.

[LeafWarrior]

yeah I did but thanks. I'll try your suggestions.