3 files changed, 19 insertions, 1 deletions
diff --git a/ui/backend/src/main.rs b/ui/backend/src/main.rs
index 147bf413..cff9558a 100644
--- a/ui/backend/src/main.rs
+++ b/ui/backend/src/main.rs
@@ -284,12 +284,16 @@ fn main() {
             dotfiles::vars::delete_var,
             dotfiles::vars::set_var,
         ])
-        .plugin(tauri_plugin_sql::Builder::default().build())
+        .plugin(tauri_plugin_sql::Builder::default().add_migrations("sqlite:runbooks.db", run::migrations::migrations()).build())
         .plugin(tauri_plugin_http::init())
         .plugin(tauri_plugin_single_instance::init(|app, args, cwd| {
             let _ = show_window(app);
+
         }))
         .manage(state::AtuinState::default())
+        .setup(|app|{
+            Ok(())
+        })
         .run(tauri::generate_context!())
         .expect("error while running tauri application");
 }
diff --git a/ui/backend/src/run/migrations.rs b/ui/backend/src/run/migrations.rs
new file mode 100644
index 00000000..3516e62a
--- /dev/null
+++ b/ui/backend/src/run/migrations.rs
@@ -0,0 +1,13 @@
+use lazy_static::lazy_static;
+use tauri_plugin_sql::{Builder, Migration, MigrationKind};
+
+pub fn migrations() -> Vec<Migration> {
+    vec![
+        Migration {
+            version: 1,
+            description: "create_initial_tables",
+            sql: "CREATE TABLE runbooks(id string PRIMARY KEY, name TEXT, content TEXT, created bigint, updated bigint);",
+            kind: MigrationKind::Up,
+        }
+    ]
+}
diff --git a/ui/backend/src/run/mod.rs b/ui/backend/src/run/mod.rs
index 5ece0912..a7a28497 100644
--- a/ui/backend/src/run/mod.rs
+++ b/ui/backend/src/run/mod.rs
@@ -1 +1,2 @@
+pub mod migrations;
 pub mod pty;