aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/migrations/005_add_guid_index.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/db/migrations/005_add_guid_index.sql')
-rw-r--r--backend/db/migrations/005_add_guid_index.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/backend/db/migrations/005_add_guid_index.sql b/backend/db/migrations/005_add_guid_index.sql
new file mode 100644
index 0000000..a653d79
--- /dev/null
+++ b/backend/db/migrations/005_add_guid_index.sql
@@ -0,0 +1,2 @@
+-- Add index on guid for deduplication queries
+CREATE INDEX IF NOT EXISTS idx_articles_guid ON articles(guid);