From 756b66b31fd02215fc2d8a30ae263a3bf08a90a6 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 12 Jul 2025 23:58:57 +0900
Subject: feat(backend,frontend): add feature to unsubscribe feed

---
 backend/db/schema.sql | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'backend/db/schema.sql')

diff --git a/backend/db/schema.sql b/backend/db/schema.sql
index 5c2bf48..eb40dea 100644
--- a/backend/db/schema.sql
+++ b/backend/db/schema.sql
@@ -1,9 +1,10 @@
 -- Feeds
 CREATE TABLE IF NOT EXISTS feeds (
-    id         INTEGER PRIMARY KEY AUTOINCREMENT,
-    url        TEXT NOT NULL,
-    title      TEXT NOT NULL,
-    fetched_at TEXT NOT NULL
+    id            INTEGER PRIMARY KEY AUTOINCREMENT,
+    url           TEXT NOT NULL,
+    title         TEXT NOT NULL,
+    fetched_at    TEXT NOT NULL,
+    is_subscribed INTEGER NOT NULL DEFAULT 1
 );
 
 -- Articles
-- 
cgit v1.2.3-70-g09d2

