Revision control

1
SQLite format 3€@ 1*"-æ↩ü<GÖ,Í~Ú|õ~«~|||ÄzÛ{×x1zœwVtƒws¬pšsmo¿não|m˜n¨l8k0jbij'h
2
hÁg?eÔgd¨edcsb÷cHa)b¶`_°`n^ã^6]\à\C[º[6X²VäSPO:MÈK™J½I‚Gփ)<[[…-viewview_awesomebar_bookmarks_with_faviconsview_awesomebar_bookmarks_with_faviconsCREATE VIEW view_awesomebar_bookmarks_with_favicons AS SELECT b.guid AS guid, b.url AS url, b.title AS title, b.description AS description, b.visitDate AS visitDate, f.id AS iconID, f.url AS iconURL, f.date AS iconDate, f.type AS iconType, f.width AS iconWidth FROM view_awesomebar_bookmarks b LEFT JOIN favicons f ON f.id = b.faviconID‚8;??„viewview_awesomebar_bookmarksview_awesomebar_bookmarksCREATE VIEW view_awesomebar_bookmarks AS SELECT b.guid AS guid, b.url AS url, b.title AS title, b.description AS description, b.faviconID AS faviconID, h.visitDate AS visitDate FROM view_all_bookmarks b LEFT JOIN view_history_visits h ON b.url = h.urlY:33‚]viewview_history_visitsview_history_visitsCREATE VIEW view_history_visits AS SELECT h.url AS url, MAX(v.date) AS visitDate, h.domain_id AS domain_id FROM history h JOIN visits v ON v.siteID = h.id GROUP BY h.id„,911ˆviewview_all_bookmarksview_all_bookmarksCREATE VIEW view_all_bookmarks AS SELECT guid, bmkUri AS url, title, description, faviconID FROM bookmarksMirror WHERE type = 1 AND is_overridden IS 0 AND is_deleted IS 0 UNION ALL SELECT guid, bmkUri AS url, title, description, faviconID FROM bookmarksLocal WHERE type = 1 AND is_deleted IS 0 UNION ALL SELECT guid, bmkUri AS url, title, description, -1 AS faviconID FROM bookmarksBuffer bb WHERE bb.type = 1 AND bb.is_deleted IS 0 AND NOT EXISTS (SELECT 1 FROM pending_deletions AS pd WHERE pd.id = bb.guid)‚o8[[„9viewview_bookmarksBufferStructure_on_mirrorview_bookmarksBufferStructure_on_mirrorCREATE VIEW view_bookmarksBufferStructure_on_mirror AS SELECT parent, child, idx, 1 AS is_overridden FROM bookmarksBufferStructure UNION ALL SELECT parent, child, idx, 0 AS is_overridden FROM bookmarksMirrorStructure LEFT JOIN bookmarksBuffer ON parent = guid WHERE guid IS NULLˆ7ggŽiviewview_bookmarksBuffer_with_deletions_on_mirrorview_bookmarksBuffer_with_deletions_on_mirrorCREATE VIEW view_bookmarksBuffer_with_deletions_on_mirror AS SELECT -1 AS id, mirror.guid AS guid, mirror.type AS type, mirror.date_added AS date_added, mirror.is_deleted AS is_deleted, mirror.parentid AS parentid, mirror.parentName AS parentName, mirror.feedUri AS feedUri, mirror.siteUri AS siteUri, mirror.pos AS pos, mirror.title AS title, mirror.description AS description, mirror.bmkUri AS bmkUri, mirror.keyword AS keyword, mirror.folderName AS folderName, null AS faviconID, 0 AS is_overridden FROM bookmarksMirror mirror LEFT JOIN bookmarksBuffer buffer ON mirror.guid = buffer.guid WHERE buffer.guid IS NULL UNION ALL SELECT -1 AS id, guid, type, date_added, is_deleted, parentid, parentName, feedUri, siteUri, pos, title, description, bmkUri, keyword, folderName, null AS faviconID, 1 AS is_overridden FROM bookmarksBuffer WHERE is_deleted IS 0 AND NOT EXISTS (SELECT 1 FROM pending_deletions deletions WHERE deletions.id = guid)‡6II!viewview_bookmarksBuffer_on_mirrorview_bookmarksBuffer_on_mirrorCREATE VIEW view_bookmarksBuffer_on_mirror AS SELECT -1 AS id, mirror.guid AS guid, mirror.type AS type, mirror.date_added AS date_added, mirror.is_deleted AS is_deleted, mirror.parentid AS parentid, mirror.parentName AS parentName, mirror.feedUri AS feedUri, mirror.siteUri AS siteUri, mirror.pos AS pos, mirror.title AS title, mirror.description AS description, mirror.bmkUri AS bmkUri, mirror.keyword AS keyword, mirror.folderName AS folderName, null AS faviconID, 0 AS is_overridden FROM bookmarksMirror mirror LEFT JOIN bookmarksBuffer buffer ON mirror.guid = buffer.guid WHERE buffer.guid IS NULL UNION ALL SELECT -1 AS id, guid, type, date_added, is_deleted, parentid, parentName, feedUri, siteUri, pos, title, description, bmkUri, keyword, folderName, null AS faviconID, 1 AS is_overridden FROM bookmarksBuffer WHERE is_deleted IS 0ƒK5YY…uviewview_bookmarksLocalStructure_on_mirrorview_bookmarksLocalStructure_on_mirrorCREATE VIEW view_bookmarksLocalStructure_on_mirror AS SELECT parent, child, idx, 1 AS is_overridden FROM bookmarksLocalStructure WHERE ((SELECT is_deleted FROM bookmarksLocal WHERE guid = parent) IS NOT 1) UNION ALL SELECT parent, child, idx, 0 AS is_overridden FROM bookmarksMirrorStructure WHERE ((SELECT is_overridden FROM bookmarksMirror WHERE guid = parent) IS NOT 1)…4GG‰viewview_bookmarksLocal_on_mirrorview_bookmarksLocal_on_mirrorCREATE VIEW view_bookmarksLocal_on_mirror AS SELECT -1 AS id, guid, type, date_added, is_deleted, parentid, parentName, feedUri, siteUri, pos, title, description, bmkUri, folderName, faviconID, NULL AS local_modified, server_modified, 0 AS is_overridden FROM bookmarksMirror WHERE is_overridden IS NOT 1 UNION ALL SELECT -1 AS id, guid, type, date_added, is_deleted, parentid, parentName, feedUri, siteUri, pos, title, description, bmkUri, folderName, faviconID, local_modified, NULL AS server_modified, 1 AS is_overridden FROM bookmarksLocal WHERE is_deleted IS NOT 13K+indexidx_visits_siteID_is_local_datevisits1CREATE INDEX idx_visits_siteID_is_local_date ON visits (siteID, is_local, date)2??indexidx_history_should_uploadhistory0CREATE INDEX idx_history_should_upload ON history (should_upload) WHERE should_upload = 11Q=3indexidx_bookmarksMirrorStructure_childbookmarksMirrorStructure/CREATE INDEX idx_bookmarksMirrorStructure_child ON bookmarksMirrorStructure (child)*0[=Iindexidx_bookmarksMirrorStructure_parent_idxbookmarksMirrorStructure.CREATE INDEX idx_bookmarksMirrorStructure_parent_idx ON bookmarksMirrorStructure (parent, idx)&/Y;Eindexidx_bookmarksLocalStructure_parent_idxbookmarksLocalStructure-CREATE INDEX idx_bookmarksLocalStructure_parent_idx ON bookmarksLocalStructure (parent, idx)*.[=Iindexidx_bookmarksBufferStructure_parent_idxbookmarksBufferStructure,CREATE INDEX idx_bookmarksBufferStructure_parent_idx ON bookmarksBufferStructure (parent, idx)J-‚wtabletabstabs+CREATE TABLE tabs (id INTEGER PRIMARY KEY AUTOINCREMENT, client_guid TEXT REFERENCES clients(guid) ON DELETE CASCADE, url TEXT NOT NULL, title TEXT, history TEXT, last_used INTEGER);+‚Mtableclientsclients)CREATE TABLE clients (guid TEXT PRIMARY KEY, name TEXT NOT NULL, modified INTEGER NOT NULL, type TEXT, formfactor TEXT, os TEXT, version TEXT, fxaDeviceId TEXT)-,Aindexsqlite_autoindex_clients_1clients* *etablecommandscommands(CREATE TABLE commands (id INTEGER PRIMARY KEY AUTOINCREMENT, client_guid TEXT NOT NULL, value TEXT NOT NULL)ƒ
3
(--…Gtablecached_top_sitescached_top_sites&CREATE TABLE cached_top_sites (historyID INTEGER, url TEXT NOT NULL, title TEXT NOT NULL, guid TEXT NOT NULL UNIQUE, domain_id INTEGER, domain TEXT NO NULL, localVisitDate REAL, remoteVisitDate REAL, localVisitCount INTEGER, remoteVisitCount INTEGER, iconID INTEGER, iconURL TEXT, iconDate REAL, iconType INTEGER, iconWidth INTEGER, frecencies REAL)?)S-indexsqlite_autoindex_cached_top_sites_1cached_top_sites'O&tablequeuequeue$CREATE TABLE queue (url TEXT NOT NULL UNIQUE, title TEXT))'=indexsqlite_autoindex_queue_1queue%%['=indexidx_page_metadata_cache_key_uniqueindexpage_metadata#CREATE UNIQUE INDEX idx_page_metadata_cache_key_uniqueindex ON page_metadata (cache_key)$Y'9indexidx_page_metadata_site_url_uniqueindexpage_metadata"CREATE UNIQUE INDEX idx_page_metadata_site_url_uniqueindex ON page_metadata (site_url)V"??‚;tableactivity_stream_blocklistactivity_stream_blocklist CREATE TABLE activity_stream_blocklist (id INTEGER PRIMARY KEY AUTOINCREMENT, url TEXT NOT NULL UNIQUE, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )Q#e?indexsqlite_autoindex_activity_stream_blocklist_1activity_stream_blocklist!‚+ ))„tableremote_devicesremote_devicesCREATE TABLE remote_devices (id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT UNIQUE NOT NULL, name TEXT NOT NULL, type TEXT NOT NULL, is_current_device INTEGER NOT NULL, date_created INTEGER NOT NULL, date_modified INTEGER NOT NULL, last_access_time INTEGER);!O)indexsqlite_autoindex_remote_devices_1remote_devicesH!!‚[tablehighlightshighlightsCREATE TABLE highlights (historyID INTEGER PRIMARY KEY,cache_key LONGVARCHAR,url TEXT,title TEXT,guid TEXT,visitCount INTEGER,visitDate DATETIME,is_bookmarked INTEGER)4--‚tablepinned_top_sitespinned_top_sitesCREATE TABLE pinned_top_sites (historyID INTEGER, url TEXT NOT NULL UNIQUE, title TEXT, guid TEXT, pinDate REAL, domain TEXT NOT NULL )?S-indexsqlite_autoindex_pinned_top_sites_1pinned_top_sites‚"''„tablepage_metadatapage_metadataCREATE TABLE page_metadata (id INTEGER PRIMARY KEY, cache_key LONGVARCHAR UNIQUE, site_url TEXT, media_url LONGVARCHAR, title TEXT, type VARCHAR(32), description TEXT, provider_name TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, expired_at LONG)9M'indexsqlite_autoindex_page_metadata_1page_metadataK//‚Iviewview_icon_for_urlview_icon_for_urlCREATE VIEW view_icon_for_url AS SELECT history.url AS url, icons.iconID AS iconID FROM history, view_favicons_widest AS icons WHERE history.id = icons.siteID‚;;ƒ%viewview_history_id_faviconview_history_id_faviconCREATE VIEW view_history_id_favicon AS SELECT history.id AS id, iconID, iconURL, iconDate, iconType, iconWidth FROM history LEFT OUTER JOIN view_favicons_widest ON history.id = view_favicons_widest.siteID‚]55„aviewview_favicons_widestview_favicons_widestCREATE VIEW view_favicons_widest AS SELECT favicon_sites.siteID AS siteID, favicons.id AS iconID, favicons.url AS iconURL, favicons.date AS iconDate, favicons.type AS iconType, MAX(favicons.width) AS iconWidth FROM favicon_sites, favicons WHERE favicon_sites.faviconID = favicons.id GROUP BY siteID‚↩''ƒYtablefavicon_sitesfavicon_sitesCREATE TABLE favicon_sites (id INTEGER PRIMARY KEY AUTOINCREMENT, siteID INTEGER NOT NULL REFERENCES history(id) ON DELETE CASCADE, faviconID INTEGER NOT NULL REFERENCES favicons(id) ON DELETE CASCADE, UNIQUE (siteID, faviconID) )9M'indexsqlite_autoindex_favicon_sites_1favicon_sites//[tablepending_deletionspending_deletionsCREATE TABLE pending_deletions (id TEXT PRIMARY KEY REFERENCES bookmarksBuffer(guid) ON DELETE CASCADE)AU/indexsqlite_autoindex_pending_deletions_1pending_deletionsX==‚CtablebookmarksMirrorStructurebookmarksMirrorStructureCREATE TABLE bookmarksMirrorStructure ( parent TEXT NOT NULL REFERENCES bookmarksMirror(guid) ON DELETE CASCADE, child TEXT NOT NULL, idx INTEGER NOT NULL)…P++ŠWtablebookmarksMirrorbookmarksMirrorCREATE TABLE bookmarksMirror ( id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT NOT NULL UNIQUE, type TINYINT NOT NULL, date_added INTEGER, is_deleted TINYINT NOT NULL DEFAULT 0, parentid TEXT, parentName TEXT, feedUri TEXT, siteUri TEXT, pos INT, title TEXT, description TEXT, bmkUri TEXT, tags TEXT, keyword TEXT, folderName TEXT, queryId TEXT, server_modified INTEGER NOT NULL, hasDupe TINYINT NOT NULL DEFAULT 0, is_overridden TINYINT NOT NULL DEFAULT 0, faviconID INTEGER REFERENCES favicons(id) ON DELETE SET NULL, CONSTRAINT parentidOrDeleted CHECK (parentid IS NOT NULL OR is_deleted = 1), CONSTRAINT parentNameOrDeleted CHECK (parentName IS NOT NULL OR is_deleted = 1))=Q+indexsqlite_autoindex_bookmarksMirror_1bookmarksMirrorT;;‚?tablebookmarksLocalStructurebookmarksLocalStructureCREATE TABLE bookmarksLocalStructure ( parent TEXT NOT NULL REFERENCES bookmarksLocal(guid) ON DELETE CASCADE, child TEXT NOT NULL, idx INTEGER NOT NULL)…))‰atablebookmarksLocalbookmarksLocalCREATE TABLE bookmarksLocal ( id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT NOT NULL UNIQUE, type TINYINT NOT NULL, date_added INTEGER, is_deleted TINYINT NOT NULL DEFAULT 0, parentid TEXT, parentName TEXT, feedUri TEXT, siteUri TEXT, pos INT, title TEXT, description TEXT, bmkUri TEXT, tags TEXT, keyword TEXT, folderName TEXT, queryId TEXT, local_modified INTEGER, sync_status TINYINT NOT NULL, faviconID INTEGER REFERENCES favicons(id) ON DELETE SET NULL, CONSTRAINT parentidOrDeleted CHECK (parentid IS NOT NULL OR is_deleted = 1), CONSTRAINT parentNameOrDeleted CHECK (parentName IS NOT NULL OR is_deleted = 1));O)indexsqlite_autoindex_bookmarksLocal_1bookmarksLocalX↩==‚CtablebookmarksBufferStructurebookmarksBufferStructureCREATE TABLE bookmarksBufferStructure ( parent TEXT NOT NULL REFERENCES bookmarksBuffer(guid) ON DELETE CASCADE, child TEXT NOT NULL, idx INTEGER NOT NULL)„h ++‰tablebookmarksBufferbookmarksBuffer CREATE TABLE bookmarksBuffer ( id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT NOT NULL UNIQUE, type TINYINT NOT NULL, date_added INTEGER, is_deleted TINYINT NOT NULL DEFAULT 0, parentid TEXT, parentName TEXT, feedUri TEXT, siteUri TEXT, pos INT, title TEXT, description TEXT, bmkUri TEXT, tags TEXT, keyword TEXT, folderName TEXT, queryId TEXT, server_modified INTEGER NOT NULL, hasDupe TINYINT NOT NULL DEFAULT 0, CONSTRAINT parentidOrDeleted CHECK (parentid IS NOT NULL OR is_deleted = 1), CONSTRAINT parentNameOrDeleted CHECK (parentName IS NOT NULL OR is_deleted = 1))= Q+indexsqlite_autoindex_bookmarksBuffer_1bookmarksBuffer↩y ƒMtablevisitsvisits
4
CREATE TABLE visits (id INTEGER PRIMARY KEY AUTOINCREMENT, siteID INTEGER NOT NULL REFERENCES history(id) ON DELETE CASCADE, date REAL NOT NULL, type INTEGER NOT NULL, is_local TINYINT NOT NULL, UNIQUE (siteID, date, type) )+
5
?indexsqlite_autoindex_visits_1visits =‚MtablefaviconsfaviconsCREATE TABLE favicons (id INTEGER PRIMARY KEY AUTOINCREMENT, url TEXT NOT NULL UNIQUE, width INTEGER, height INTEGER, type INTEGER NOT NULL, date REAL NOT NULL)/Cindexsqlite_autoindex_favicons_1favicons ƒ…_tablehistoryhistoryCREATE TABLE history (id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT NOT NULL UNIQUE, url TEXT UNIQUE, title TEXT NOT NULL, server_modified INTEGER, local_modified INTEGER, is_deleted TINYINT NOT NULL, should_upload TINYINT NOT NULL, domain_id INTEGER REFERENCES domains(id) ON DELETE CASCADE, CONSTRAINT urlOrDeleted CHECK (url IS NOT NULL OR is_deleted = 1))-Aindexsqlite_autoindex_history_2history-Aindexsqlite_autoindex_history_1historyP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚tabledomainsdomainsCREATE TABLE domains (id INTEGER PRIMARY KEY AUTOINCREMENT, domain TEXT NOT NULL UNIQUE, showOnTopSites TINYINT NOT NULL DEFAULT 1)-Aindexsqlite_autoindex_domains_1domains↩ÀïÞÏÀ↩ slack.com↩ apple.com# mozilla.org# example.com
6
ÅÓñáÅ↩slack.com↩apple.com#mozilla.org# example.com↩™ìեߙǴ'favicon_sites²
7
visits domains'favicon_sites faviconstabs
8
history)bookmarksLocal↩~ÆÁY~ÆW
9
%EI duNSweEU6Ielhttps://slack.com/intl/es-esDonde tu trabajo fluye | Slackbað↩8
11
%Ic HcnyDNfJUGarhttps://www.mozilla.org/en-US/Internet for people, not profit — Mozillabaïà|=
12
%3) JbOefAqvjdI7http://example.com/Example Domainbaïʊ
13
½ßðν%duNSweEU6Iel%alVj2j5OKEjj%HcnyDNfJUGar% JbOefAqvjdI7
15
hÞhŽ%Ohttps://www.apple.com/favicon.icoO!https://www.mozilla.org/media/img/favicon/favicon-196x196.c80e6abe0767.png!I http://example.com/favicon.ico↩ fðàϾ¬›‰xf  hN‘ºÍ„ hN‘´
16
‰ hN‘R™À hN‘6ñà hN‘åD hN‘E  hN¯)¤  hN®äs  hNùuO
17
pòãÓò¢‘phN‘ºÍ„  hN‘´
18
‰hN‘R™À hN‘6ñàhN‘åD hN‘E hN¯)¤  hN®äs↩  hNùuO↩€
19
€↩€↩~ÏÆI ~Ï;%%↩↩unfiled_____baï–Úroot________baï–Ú;%%↩↩toolbar_____baï–Úroot________baï–Ú;%%↩↩menu________baï–Úroot________baï–Ú;%%↩↩mobile______baï–Úroot________baï–Ú;%%↩↩root________baï–Úroot________baï–Ú
20
­Ïàð¾­%unfiled_____%toolbar_____%menu________% mobile______%root________↩†âÄ¥†%%root________mobile______%%root________unfiled_____%% root________toolbar_____%%root________menu________↩€
21
€↩€↩€
22
€↩êúòê
23
ëûóë ↩{QŸ~D|à{Qƒ ↩EE9ƒ3https://slack.com/intl/es-eshttps://slack.com/intl/es-eshttps://a.slack-edge.com/436da/marketing/img/meta/slack_hash_128.pngDonde tu trabajo fluyewebsiteSlack es el lugar donde el trabajo fluye. Es donde se reúnen las personas que necesitas, la información que compartes y las herramientas que utilizas, con el objetivo de llevar a cabo tus proyectos.Slack2018-03-26 10:52:25bqc#?‚a↩99-‚i3https://www.apple.com/https://www.apple.com/https://www.apple.com/ac/structured-data/images/open_graph_logo.png?201709101434ApplewebsiteDiscover the innovative world of Apple and shop everything iPhone, iPad, Apple Watch, Mac, and Apple TV, plus explore accessories, entertainment, and expert device support.Apple2018-03-26 10:52:18bqck‚X↩IIK‚3https://www.mozilla.org/en-US/https://www.mozilla.org/en-US/https://www.mozilla.org/media/img/mozorg/mozilla-256.4720741d4108.jpgInternet for people, not profitwebsiteDid you know? Mozilla — the maker of Firefox — fights to keep the Internet a global public resource, open and accessible to all.Mozilla2018-03-26 10:52:13bqbõ_ 33)3http://example.com/http://example.com/Example Domainexample2018-03-26 10:52:07bqbޕ
25
€↩€↩€
26
€↩€