From: xangelo <git@xangelo.ca>
Date: Wed, 13 Apr 2022 18:25:00 +0000 (-0400)
Subject: unique constraint on feed/account
X-Git-Url: https://git.xangelo.ca/?p=rss-reader.git;a=commitdiff_plain;h=9e52ff0ed2055660909d76b620308e5d1a3b8e9c

unique constraint on feed/account
---

diff --git a/sql/seed.ts b/sql/seed.ts
index bf0118c..185f8da 100644
--- a/sql/seed.ts
+++ b/sql/seed.ts
@@ -33,7 +33,6 @@ writer.prepare(`
                )
                `).run();
 
-writer.prepare(`create index idx_account_feed on feedlist (account_id, link)`).run();
 
 
 writer.prepare(`
@@ -49,6 +48,8 @@ writer.prepare(`
                )
                `).run();
 
+writer.prepare(`create unique index idx_account_feed on feedlist (account_id, link)`).run();
+
 }
 
 /*