From 9192e6c7747fd2d3f6a6c5c07d886a0982b53f11 Mon Sep 17 00:00:00 2001 From: polwex 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