From 9e52ff0ed2055660909d76b620308e5d1a3b8e9c Mon Sep 17 00:00:00 2001 From: xangelo Date: Wed, 13 Apr 2022 14:25:00 -0400 Subject: [PATCH] unique constraint on feed/account --- sql/seed.ts | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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(); + } /* -- 2.25.1