X-Git-Url: https://git.xangelo.ca/?p=rss-reader.git;a=blobdiff_plain;f=sql%2Fseed.ts;h=185f8da63c1add540faef9c844f3c6368fafb2ff;hp=bf0118c53df3f699f01a0820a8e3b6743f9c6342;hb=9e52ff0ed2055660909d76b620308e5d1a3b8e9c;hpb=200808f1fc03c8669968a77074bc6051d3bf663b 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(); + } /*