1 files changed, 17 insertions, 0 deletions
diff --git a/crates/atuin-scripts/migrations/20250326160051_create_scripts.up.sql b/crates/atuin-scripts/migrations/20250326160051_create_scripts.up.sql
new file mode 100644
index 00000000..1b2f3688
--- /dev/null
+++ b/crates/atuin-scripts/migrations/20250326160051_create_scripts.up.sql
@@ -0,0 +1,17 @@
+-- Add up migration script here
+CREATE TABLE scripts (
+    id TEXT PRIMARY KEY,
+    name TEXT NOT NULL,
+    description TEXT NOT NULL,
+    shebang TEXT NOT NULL,
+    script TEXT NOT NULL,
+    inserted_at INTEGER NOT NULL DEFAULT (strftime('%s', 'now'))
+);
+
+CREATE TABLE script_tags (
+    id INTEGER PRIMARY KEY,
+    script_id TEXT NOT NULL,
+    tag TEXT NOT NULL
+);
+
+CREATE UNIQUE INDEX idx_script_tags ON script_tags (script_id, tag);
+\ No newline at end of file