File indexing completed on 2024-12-22 04:40:24
0001 -- SPDX-FileCopyrightText: 2022 Jonah Brüchert <jbb@kaidan.im> 0002 -- 0003 -- SPDX-License-Identifier: GPL-2.0-or-later 0004 0005 CREATE TABLE IF NOT EXISTS bookmarks (url TEXT UNIQUE, title TEXT, icon TEXT, lastVisited INT); 0006 CREATE TABLE IF NOT EXISTS history (url TEXT UNIQUE, title TEXT, icon TEXT, lastVisited INT); 0007 CREATE TABLE IF NOT EXISTS icons (url TEXT UNIQUE, icon BLOB); 0008 CREATE UNIQUE INDEX IF NOT EXISTS idx_bookmarks_url ON bookmarks(url); 0009 CREATE UNIQUE INDEX IF NOT EXISTS idx_history_url ON history(url); 0010 CREATE UNIQUE INDEX IF NOT EXISTS idx_icons_url ON icons(url);