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);