From 8478a598db2ff99cc4699cf4d3872ea720ff159c Mon Sep 17 00:00:00 2001
From: CosmicHorror <LovecraftianHorror@pm.me>
Date: Sat, 10 Sep 2022 05:21:05 -0500
Subject: Add index for interactive search (#493)

---
 atuin-client/migrations/20220806155627_interactive_search_index.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 atuin-client/migrations/20220806155627_interactive_search_index.sql

(limited to 'atuin-client/migrations/20220806155627_interactive_search_index.sql')

diff --git a/atuin-client/migrations/20220806155627_interactive_search_index.sql b/atuin-client/migrations/20220806155627_interactive_search_index.sql
new file mode 100644
index 00000000..b5770e62
--- /dev/null
+++ b/atuin-client/migrations/20220806155627_interactive_search_index.sql
@@ -0,0 +1,6 @@
+-- Interactive search filters by command then by the max(timestamp) for that
+-- command. Create an index that covers those
+create index if not exists idx_history_command_timestamp on history(
+	command,
+	timestamp
+);
-- 
cgit v1.3.1

