From 39a926cd521806aedc298ddd671d1a118794fcec Mon Sep 17 00:00:00 2001
From: Leonardo Bishop <me@leonardobishop.net>
Date: Wed, 17 Sep 2025 18:13:30 +0100
Subject: Add endpoints for web extension

---
 pkg/database/migrations/0003_unique_url.sql  | 3 +++
 pkg/database/migrations/0004_unread_kind.sql | 5 +++++
 2 files changed, 8 insertions(+)
 create mode 100644 pkg/database/migrations/0003_unique_url.sql
 create mode 100644 pkg/database/migrations/0004_unread_kind.sql

(limited to 'pkg/database/migrations')

diff --git a/pkg/database/migrations/0003_unique_url.sql b/pkg/database/migrations/0003_unique_url.sql
new file mode 100644
index 0000000..8be3293
--- /dev/null
+++ b/pkg/database/migrations/0003_unique_url.sql
@@ -0,0 +1,3 @@
+-- +goose Up
+
+CREATE UNIQUE INDEX ux_entries_url ON entries(url);
diff --git a/pkg/database/migrations/0004_unread_kind.sql b/pkg/database/migrations/0004_unread_kind.sql
new file mode 100644
index 0000000..e583050
--- /dev/null
+++ b/pkg/database/migrations/0004_unread_kind.sql
@@ -0,0 +1,5 @@
+-- +goose Up
+
+INSERT INTO kinds (name, emoji)
+VALUES
+  ("unread", "📚");
-- 
cgit v1.2.3-70-g09d2