From 9192e6c7747fd2d3f6a6c5c07d886a0982b53f11 Mon Sep 17 00:00:00 2001
From: polwex <polwex@sortug.com>
Date: Wed, 21 May 2025 15:28:03 +0700
Subject: good tandem good tandem of ideas and implementation

---
 src/lib/db/schema.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'src/lib/db/schema.sql')

diff --git a/src/lib/db/schema.sql b/src/lib/db/schema.sql
index 8d1b288..4506619 100644
--- a/src/lib/db/schema.sql
+++ b/src/lib/db/schema.sql
@@ -57,6 +57,14 @@ CREATE INDEX IF NOT EXISTS idx_words_pos ON senses(pos);
 CREATE INDEX IF NOT EXISTS idx_senses_parent ON senses(parent_id);
 
 
+CREATE TABLE IF NOT EXISTS bookmarks(
+    word_id INTEGER PRIMARY KEY,
+    notes   TEXT,
+    created INTEGER NOT NULL,
+    FOREIGN KEY (word_id) REFERENCES expressions(id)
+);
+CREATE INDEX IF NOT EXISTS idx_bookmarks ON bookmarks(word_id);
+
 
 -- Categories table (for noun and verb categories)
 CREATE TABLE IF NOT EXISTS categories (
-- 
cgit v1.2.3

