4 files changed, 23 insertions, 0 deletions
diff --git a/crates/atuin-scripts/migrations/20250326160051_create_scripts.down.sql b/crates/atuin-scripts/migrations/20250326160051_create_scripts.down.sql
new file mode 100644
index 00000000..b2c5a363
--- /dev/null
+++ b/crates/atuin-scripts/migrations/20250326160051_create_scripts.down.sql
@@ -0,0 +1,2 @@
+DROP TABLE scripts;
+DROP TABLE script_tags;
+\ No newline at end of file
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
diff --git a/crates/atuin-scripts/migrations/20250402170430_unique_names.down.sql b/crates/atuin-scripts/migrations/20250402170430_unique_names.down.sql
new file mode 100644
index 00000000..269b8cd9
--- /dev/null
+++ b/crates/atuin-scripts/migrations/20250402170430_unique_names.down.sql
@@ -0,0 +1,2 @@
+-- Add down migration script here
+alter table scripts drop index name_uniq_idx;
+\ No newline at end of file
diff --git a/crates/atuin-scripts/migrations/20250402170430_unique_names.up.sql b/crates/atuin-scripts/migrations/20250402170430_unique_names.up.sql
new file mode 100644
index 00000000..d2cdd02f
--- /dev/null
+++ b/crates/atuin-scripts/migrations/20250402170430_unique_names.up.sql
@@ -0,0 +1,2 @@
+-- Add up migration script here
+create unique index name_uniq_idx ON scripts(name);
+\ No newline at end of file