Revision control
Copy as Markdown
SQLite format 3 @ B ) -æ û +û$ù`ÌÛ/ð M å
n
ÖRçâ↩Ñ=÷ `viewcombinedcombinedCREATE VIEW combined AS SELECT bookmark_id, history_id, 0 AS _id, url, title, visits, display, date, favicon_id FROM ( SELECT bookmarks._id AS bookmark_id, bookmarks.url AS url, bookmarks.title AS title, CASE bookmarks.parent WHEN -2 THEN 1 ELSE 0 END AS display, -1 AS history_id, -1 AS visits, -1 AS date, bookmarks.favicon_id AS favicon_id FROM bookmarks WHERE bookmarks.type = 1 AND bookmarks.parent <> -3 AND bookmarks.deleted = 0 AND bookmarks.url NOT IN (SELECT url FROM history) UNION ALL SELECT CASE bookmarks.deleted WHEN 0 W--ctableandroid_metadataandroid_metadataCREATE TABLE android_metadata (locale TEXT){
EtablebookmarksbookmarksCREATE TABLE bookmarks(_id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT,url TEXT,type INTEGER NOT NULL DEFAULT 1,parent INTEGER,position INTEGER NOT NULL,keyword TEXT,description TEXT,tags TEXT,favicon_id INTEGER,created INTEGER,modified INTEGER,guid TEXT NOT NULL,deleted INTEGER NOT NULL DEFAULT 0, FOREIGN KEY (parent) REFERENCES bookmarks(_id))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Z3qindexbookmarks_url_indexbookmarksCREATE INDEX bookmarks_url_index ON bookmarks(url)wEindexbookmarks_type_deleted_indexbookmarksCREATE INDEX bookmarks_type_deleted_index ON bookmarks(type, deleted)e5indexbookmarks_guid_indexbookmarksCREATE UNIQUE INDEX bookmarks_guid_index ON bookmarks(guid)j=indexbookmarks_modified_indexbookmarks CREATE INDEX bookmarks_modified_index ON bookmarks(modified)otablehistoryhistory
CREATE TABLE history(_id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT,url TEXT NOT NULL,visits INTEGER NOT NULL DEFAULT 0,favicon_id INTEGER,date INTEGER,created INTEGER,modified INTEGER,guid TEXT NOT NULL,deleted INTEGER NOT NULL DEFAULT 0)R /iindexhistory_url_indexhistoryCREATE INDEX history_url_index ON history(url)\
1{indexhistory_guid_indexhistoryCREATE UNIQUE INDEX history_guid_index ON history(guid)a9}indexhistory_modified_indexhistory↩CREATE INDEX history_modified_index ON history(modified)[7sindexhistory_visited_indexhistoryCREATE INDEX history_visited_index ON history(date)↩}tablefaviconsfaviconsCREATE TABLE favicons (_id INTEGER PRIMARY KEY AUTOINCREMENT,url TEXT UNIQUE,data BLOB,created INTEGER,modified INTEGER)/C indexsqlite_autoindex_favicons_1faviconsV1mindexfavicons_url_indexfaviconsCREATE INDEX favicons_url_index ON favicons(url)f;indexfavicons_modified_indexfaviconsCREATE INDEX favicons_modified_index ON favicons(modified)z!!?tablethumbnailsthumbnailsCREATE TABLE thumbnails (_id INTEGER PRIMARY KEY AUTOINCREMENT,url TEXT UNIQUE,data BLOB)3G! indexsqlite_autoindex_thumbnails_1thumbnails^5!uindexthumbnails_url_indexthumbnailsCREATE INDEX thumbnails_url_index ON thumbnails(url)x;;viewbookmarks_with_faviconsbookmarks_with_faviconsCREATE VIEW bookmarks_with_favicons AS SELECT bookmarks.*, favicons.data AS favicon, favicons.url AS favicon_url FROM bookmarks LEFT OUTER JOIN favicons ON bookmarks.favicon_id = favicons._idl77{viewhistory_with_faviconshistory_with_faviconsCREATE VIEW history_with_favicons AS SELECT history.*, favicons.data AS favicon, favicons.url AS favicon_url FROM history LEFT OUTER JOIN favicons ON history.favicon_id = favicons._id0%%#tablereading_listreading_listCREATE TABLE reading_list(_id INTEGER PRIMARY KEY AUTOINCREMENT, url TEXT NOT NULL, title TEXT, excerpt TEXT, read TINYINT DEFAULT 0, deleted TINYINT DEFAULT 0, guid TEXT UNIQUE NOT NULL, modified INTEGER NOT NULL, created INTEGER NOT NULL, length INTEGER DEFAULT 0 )7K% indexsqlite_autoindex_reading_list_1reading_listZ-%qindexreading_list_urlreading_listCREATE INDEX reading_list_url ON reading_list(url)e/%indexreading_list_guidreading_listCREATE UNIQUE INDEX reading_list_guid ON reading_list( * ) ! " # $ % & / . ) B 1 = 9 6 5 8 3 > ; 4 ? @ A B 1 E G H ↩ ÷ ÷ en_US↩ð ¦ y«ÝªuEè(~↩Ê↩_↩↩¦ e EA %Malleable Systems Collectivehttps://malleable.systems/ qv¹hqv¹dkfBDXyk9KJwio 9_ %Life in life - YouTubehttps://m.youtube.com/watch?v=xP5-iIeKXE8 qv,ÓqvðÈyoGGvmpvc6sYp K_ %Firefox: Customize with add-onshttps://addons.mozilla.org/en-US/android/qv
³qv
³uh7jRn2FqWl4 -m %FirefW
#G %Hacker Newshttps://news.ycombinator.com/ qvºqv¸gX1znIKIQouCi -m %Firefox: Supporthttp://support.mozilla.org/en-US/products/mobileqv
´qv
´K1HwRp9f92RC\ 3M %Firefox Marketplacehttps://marketplace.firefox.com/qv
³qv
³5OekK73wf8NaO C' %Firefox: About your browserabout:firefoxqv
§qv
§CpJFDmtc79FI(ÿÿÿÿÿÿÿÿý Pinnedqv
£qv
£pinned3ÿÿÿÿÿÿÿÿþ % #Reading Listqv
£qv
£readinglist5 1 Unsorted Bookmarksqv
¢qv
¢unfiled$ Tagsqv
¢qv
¢tags. ) Bookmarks Menuqv
¢qv
¢menu3 / Bookmarks Toolbarqv
¡qv
¡toolbar1 - Mobile Bookmarksqv
¡qv¹dmobile! ↩ qv
qv
places↩ µ ñãҵ historhistory↩!thumbnails% reading_listfavicons↩bookmarks