SQLite format 3@   . ;  [- 3triggerfile_update_triggerfileCREATE TRIGGER file_update_trigger AFTER UPDATE ON file FOR EACH ROW WHEN NEW.refcount = 0 BEGIN DELETE FROM file WHERE id = OLD.id; ENDY A#Ytriggerobject_data_delete_triggerobject_dataCREATE TRIGGER object_data_delete_trigger AFTER DELETE ON object_data FOR EACH ROW WHEN OLD.file_ids IS NOT NULL BEGIN SELECT update_refcount(OLD.file_ids, NULL); END A#9triggerobject_data_update_triggerobject_dataCREATE TRIGGER object_data_update_trigger AFTER UPDATE OF file_ids ON object_data FOR EACH ROW WHEN OLD.file_ids IS NOT NULL OR NEW.file_ids IS NOT NULL BEGIN SELECT update_refcount(OLD.file_ids, NEW.file_ids); ENDY A#Ytriggerobject_data_insert_triggerobject_dataCREATE TRIGGER object_data_insert_trigger AFTER INSERT ON object_data FOR EACH ROW WHEN NEW.file_ids IS NOT NULL BEGIN SELECT update_refcount(NULL, NEW.file_ids); ENDZ tablefilefile CREATE TABLE file (id INTEGER PRIMARY KEY, refcount INTEGER NOT NULL)XU/9indexunique_index_data_value_locale_indexunique_index_data CREATE INDEX unique_index_data_value_locale_index ON unique_index_data (index_id, value_locale, object_data_key, value) WHERE value_locale IS NOT NULL//_tableunique_index_dataunique_index_data CREATE TABLE unique_index_data( index_id INTEGER NOT NULL, value BLOB NOT NULL, object_store_id INTEGER NOT NULL, object_data_key BLOB NOT NULL, value_locale BLOB, PRIMARY KEY (index_id, value), FOREIGN KEY (index_id) REFERENCES object_store_index(id) , FOREIGN KEY (object_store_id, object_data_key) REFERENCES object_data(object_store_id, key) ) WITHOUT ROWID<G!indexindex_data_value_locale_indexindex_dataCREATE INDEX index_data_value_locale_index ON index_data (index_id, value_locale, object_data_key, value) WHERE value_locale IS NOT NULL!!stableindex_dataindex_dataCREATE TABLE index_data( index_id INTEGER NOT NULL, value BLOB NOT NULL, object_data_key BLOB NOT NULL, object_store_id INTEGER NOT NULL, value_locale BLOB, PRIMARY KEY (index_id, value, object_data_key), FOREIGN KEY (index_id) REFERENCES object_store_index(id) , FOREIGN KEY (object_store_id, object_data_key) REFERENCES object_data(object_store_id, key) ) WITHOUT ROWID'##tableobject_dataobject_dataCREATE TABLE object_data( object_store_id INTEGER NOT NULL, key BLOB NOT NULL, index_data_values BLOB DEFAULT NULL, file_ids TEXT, data BLOB NOT NULL, PRIMARY KEY (object_store_id, key), FOREIGN KEY (object_store_id) REFERENCES object_store(id) ) WITHOUT ROWID]11etableobject_store_indexobject_store_indexCREATE TABLE object_store_index( id INTEGER PRIMARY KEY, object_store_id INTEGER NOT NULL, name TEXT NOT NULL, key_path TEXT NOT NULL, unique_index INTEGER NOT NULL, multientry INTEGER NOT NULL, locale TEXT, is_auto_locale BOOLEAN NOT NULL, FOREIGN KEY (object_store_id) REFERENCES object_store(id) )%%% tableobject_storeobject_storeCREATE TABLE object_store( id INTEGER PRIMARY KEY, auto_increment INTEGER NOT NULL DEFAULT 0, name TEXT NOT NULL, key_path TEXT)tabledatabasedatabaseCREATE TABLE database( name TEXT PRIMARY KEY, origin TEXT NOT NULL, version INTEGER NOT NULL DEFAULT 0, last_vacuum_time INTEGER NOT NULL DEFAULT 0, last_analyze_time INTEGER NOT NULL DEFAULT 0, last_vacuum_size INTEGER NOT NULL DEFAULT 0) WITHOUT ROWID )#% snippets_dbabout:newtabaT  snippets       < n _ 2Hj/ :00bqqEbub/e/ :00bqqEbub/efgbvmuCspxtfs< F&0bqqEbub/tfmfdufeTfbsdiFohjofsearchEngineIdentifier google e*sG P .P-=(N(yahoo&  FH0bqqEbub/tfmfdufeTfbsdiFohjofsearchEngineIdentifier google e*sG P .P-=(N(yahoo& (N( bing ' (N(,amazondotcom 0 0N0 ddg N twitt!!N@$-wikipedia u,* 000bqqEbub/gybddpvou<3 B00bqqEbub/pocpbsejohGjojtife<1 >00bqqEbub/ufmfnfuszFobcmfe<( ,00bqqEbub/wfstjpo<5 F00bqqEbub/qspgjmfSftfuXffltBhp<7 J00bqqEbub/qspgjmfDsfbufeXffltBhp<, 400bqqEbub/jojujbmj{fe<, *:0hfpMbtuVqebufe,X vB) "<0hfpDpvouszDRO' :0cmpdlMjtu,f00tojqqfut.dbdife.wfstjpo< f0tojqqfutXO<style  0 <00tojqqfut.dbdife.wfstjpo<! 00tojqqfut<- 600tojqqfut.mbtu.vqebuf<xEvB/ :00bqqEbub/efgbvmuCspxtfs<5 4@0bqqEbub/tojqqfutVSMhttps://snippets.cdn.mozilla.net/5/Firefox/58.0.2/20180206200532/WINNT_x86_64-msvc/en-US/release/Windows_NT%206.1/default/default/00tojqqfut.dbdife.wfstjpo<P00tojqqfut<.00tojqqfut.mbtu.vqebuf<-vB      FfE6Fa%gn%armsXc%r2Xjueify}x!I>:f> vJA>.H V.: .bloeAn(-b%*an:tN absol66RDp%*5B.-*-82>h>$6N"6xI.N.ag0url("daJ:i"@/svg+xml;Tse64,PHN2ZyB4bWxucz0eHHR0cDovL3dy53MhvcmcvMjAwMC9zd(iIHdpZP(oPSIxNgaGV 2h0B H8lld0JveDhpIDE2Hj48cGF0aCB%Wxs`Jjb2E ZXx(LWZpbG%PIGQ9Ik05LjQCA%08DMuNTMxL(YTEgMSC00P6Ew4Y Pg QDY5 MDU1pA2p2U4% z z .WEx ! A(S40MTQ:RMO0.X!x.`SA2pt0R6Ii8+P2+"̀aoecx6reaa-2DF-R >VZ rtran ,.FNo  l V(.^lrd !J6 c ^FoffJ $NNF! ̖p:h@ FHP 2> A!f<t T  cr*t: af !ce (/javas:  // GE!aB  2017 2-26 9:02:.35 98XIncAd :   T J54V3D ABOUTHOME_SNIPPETS = JSON.ere(N[{\u 22e.a. 3CE" 2D:.f 3D 5C  !,>  !a"xw* :nf!0*dApm%L n>nhQ4]^ fgJFAVAs$nns2^ 1! v >>r43E $.Cp "f0a 2 * NV6(>.23͞&3B ~p}:*D8>faB^ ]jfF f<&6,!(6eR@&fR"9!F a<4V~y cA!tfN !#7cV vFVsec"f& #v!V|lf tNx!l   fY).h5)"16y^ΜpjL>f.4>pP $fR"A`jBfdN  .>R V6 > 2V2fV .( r% lz!HftFFE9.tp r& 6\1tAB !a.l>x9gj66!670V8>>^>x!nr1<^h>.d aa.0f^^R&0a1 rff72Ha|. v>pFpam^Fb., fH,F v6&"ARp vwp&f6Pi*z^6a5FD9H6^(&LfP>V6N"* !,$ ެ>^JTfb. #C16^f8FBvNvNA&!p d!t X^$fP v$a*f5E Fxvxfv,vִ\hlybAc #!^x:N$6^6t #,f>(v>   peZfr &| !z& 2$$a@6N&4f>!66ji6Z%. d.Z^ L".hAB> @ >fbqfP!"skEX` ("Dn".^ """"""""""""6"( q*.b" $%/B| F"1vvF&0vV6>F*8L'^ j(&^\ :> f:Vl>P\FF$.!( vzB>4  $Vpڶ.>*v("!( .n! &d > 2`|fb~(FN&p$nh vLsrcH JD9)WwgJ*8Vyc2lvbjJ*(w"(8BlbmNvZG#Zz(dXRm)Pz4KR(HEtLSBHZW5l+*b3I(EFkz*@JlIElsbHV2+4HJhdG9y*Iw)Eu*)N+@V4*0d*Q PnLUIC4g8FZnN*")Dr*R*)Qn++)Cf P 0tPgo3Zn+FXB+j ++W"Z+xEW%XzE,H0x5z+odB,wO)v,3L^%:*m%,8y !@3",I>-G1%x(nM6eGx%L/m,p A6Ly9,3Pd+u%J%h5OTk .P-gXjB$C TEXMH-oJ-H2-X%A@@!,2B+ <c3R5%8UpPmVuYWJsZS1iNrZ3R-dEkOmEdy",pNjgg 7m(2.w6xBhY2 xnByZ-NMhAI-a0z.0e-aj.5E nRHQvY%z@CSE dDB7Z.aH.jRkeO30x.HexZTm(Gc+CgkE!8j%|B5EaB,B3aW/a.) !G 0i L0 CTxwYPoj.NsNUB/DA X&.1Ny4:-DQy Zo/djeN-0O1Vj$.R -1.4ePT(NS03YyLt42.DIu`)XYsB.\.JbZ.)J6HhjVT-`GgxjlW1ZI-1 *!R%T%0M%T0 !4X/Sw g-p0Hkl @