SQLite format 3@  ._  m bc7=tablebookmarksbookmarksCREATE TABLE bookmarks ( id INTEGER not null primary key, URL VARCHAR not null unique, metadata VARCHAR not null default '', tags VARCHAR not null default '', desc VARCHAR not null default '', flags INTEGER not null default 0, last_update_ts DATETIME not null default CURRENT_TIMESTAMP , embedding BLOB, content_hash BLOB) %Ytriggerbookmarks_aubookmarksCREATE TRIGGER bookmarks_au AFTER UPDATE ON bookmarks BEGIN INSERT INTO bookmarks_fts (bookmarks_fts, rowid, URL, metadata, tags, "desc") VALUES ('delete', old.id, old.URL, old.metadata, old.tags, old.desc); INSERT INTO bookmarks_fts (rowid, URL, metadata, tags, "desc") VALUES (new.id, new.URL, new.metadata, new.tags, new.desc); ENDm %!triggerbookmarks_aibookmarksCREATE TRIGGER bookmarks_ai AFTER INSERT ON bookmarks BEGIN INSERT INTO bookmarks_fts (rowid, URL, metadata, tags, "desc") VALUES (new.id, new.URL, new.metadata, new.tags, new.desc); END %Striggerbookmarks_adbookmarksCREATE TRIGGER bookmarks_ad AFTER DELETE ON bookmarks BEGIN INSERT INTO bookmarks_fts (bookmarks_fts, rowid, URL, metadata, tags, "desc") VALUES ('delete', old.id, old.URL, old.metadata, old.tags, old.desc); ENDx 55tablebookmarks_fts_configbookmarks_fts_config CREATE TABLE 'bookmarks_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID| 77tablebookmarks_fts_docsizebookmarks_fts_docsizeCREATE TABLE 'bookmarks_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB) //Ctablebookmarks_fts_idxbookmarks_fts_idxCREATE TABLE 'bookmarks_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDv11tablebookmarks_fts_databookmarks_fts_dataCREATE TABLE 'bookmarks_fts_data'(id INTEGER PRIMARY KEY, block BLOB)''gtablebookmarks_ftsbookmarks_ftsCREATE VIRTUAL TABLE bookmarks_fts using fts5 ( id, URL, metadata, tags, "desc", flags UNINDEXED, last_update_ts UNINDEXED, content= 'bookmarks', content_rowid= 'id', tokenize= "porter unicode61" ))CtriggerUpdateLastTimebookmarksCREATE TRIGGER [UpdateLastTime] AFTER UPDATE ON bookmarks FOR EACH ROW WHEN NEW.last_update_ts <= OLD.last_update_ts BEGIN update bookmarks set last_update_ts=CURRENT_TIMESTAMP where id = OLD.id; ENDwtablebookmarksbookmarksCREATE TABLE bookmarks ( id INTEGER not null primary key, URL VARCHAR not null unique, metadata VARCHAR not null default '', tags VARCHAR not null default '', desc VARCHAR not null default '', flags INTEGER not null default 0, last_update_ts DATETIME not null default CURRENT_TIMESTAMP )1Eindexsqlite_autoindex_bookmarks_1bookmarksXAA;table__diesel_schema_migrations__diesel_schema_migrationsCREATE TABLE __diesel_schema_migrations ( version VARCHAR(50) PRIMARY KEY NOT NULL, run_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP )SgAindexsqlite_autoindex___diesel_schema_migrations_1__diesel_schema_migrations $)3202312172004092023-12-23 13:12:53$)3202212291104552023-12-23 09:27:06 )20231217200409) 20221229110455 h 9' 3,https://www.google.comGoogle,ccc,yyy,Example Entry2023-12-23 13:12:54Wy$o^Ap¼[<S< :;'\M-;Ē;٪<م;p~?<<3ϻ[;=<$;L=Q;Sk;Ո8|GՌ<<{jpo<<3O< ǼN9vm!BD6oo<ݾ"=Dj7:8;2=$3;<; F:໿;"8N_<)Q:м<7aO<-<̌r:<ӻ\;P9G!W 70)"   ||              version=HU<ƶ^># <ǰ5=˺/bq =֠ ;g*uu;-W<W¼`<_2<;M(?vغ <;Lsм@]4:;pq2AWew;GP>l$;_=;—<^<;n;5ɮ:?7V<] <%;;R; 5BaO;t9<;f켫d<;t*Eüم=O<^"\-<8=U}F<&5<Q< ZL:':e<$笻R;݉;<*D\4HP;e&;@Nˡ »U};̹0U<יv:Ö4;<<8R4;X./vKH`[<_<Zü,DǼkhL<eP<$5<\H;ۻՈg"7v_yE=\-W9<'bu*%u;l60 -H:L;$3< 6ڻ@K<5ec;|KZۼ<;(G<%&ɼO2鹺D;;g\);9ߺ hr;6g"=\<,`<@';m])D֝r;N<+P<BaE5<;f4Hw$A/7R ;;*}# 7 h 9' 3,https://www.google.comGoogle,ccc,yyy,Example Entry2023-12-23 13:13:07Wy$o^Ap¼[<S< :;'\M-;Ē;٪<م;p~?<<3ϻ[;=<$;L=Q;Sk;Ո8|GՌ<<{jpo<<3O< ǼN9vm!BD6oo<ݾ"=Dj7:8;2=$3;<; F:໿;"8N_<)Q:м<7aO<-<̌r:<ӻ\;P9G!W2[ϬkT<'X<k&co;aA;}B*;<9<~-<~< |5"aw45:>&;$| =S!(<"<>LX˻:ea[u<<:Y:N0Yһk1j#@_ļ$sļQEؼVLvʦz&)< <ӣ:$F;<8\'0:᥼og=kU<38<<ߦH*To:۰==0:7Ȫ븼)><Ӱ<;j?:u5i ;F<6<%P<ʃ<;= <<%<:q<< ;GT؈<8W7u0?8L<1slN"mҼ3^ф@4P5b - uuqAt=) 3shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.mdshell open vim,,2023-12-23 09:27:06X y 3$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptxpptx,,2023-12-23 09:27:06*  3$HOME/devdev,,2023-12-23 09:27:060) 3/Users/Q187392home,,2023-12-23 09:27:06.-  3http://none/none,,2023-12-23 09:27:06W1'33http://11111/11111bla blub3,aaa,bbb,ccc,nice description a42023-12-23 09:27:06W1'33http://asdf2/asdf2bla blub2,aaa,bbb,ccc,nice description a32023-12-23 09:27:06R-33http://asdf/asdfbla blub,aaa,bbb,nice description a22023-12-23 09:27:06 1G13,http://aaaaa/bbbbbTEST: entry for bookmark bbbb,aaa,bbb,nice description a2023-12-23 13:13:07HO\ѻ<[%O|=%לUɼj;d<;<LO%ߦȼځ<<\0 = W<ŋ!A;4 QOH:%U8Չdw<{<#m+;L̹(:(/4}SM<8;-iY;i;׵WM6<<)e껯0@;$iHJ9_<<<*؞c3T~^2 =I<kM(,;]<-lWk</GIg*Ӽ-e2K;V/,<@?12fͺH ;<1<<٭:f<弒<%ۼ*T?<>;d;G;:sg캝 <"ţ~W<{6 U><4X;W<ǂ< ;=u,:R <;_#@}6|ʼ<:/4f%:o<͐ <;*DH<;{4Ta <=xM<&V鋼;`.=<`7<[`躰z;;JL9WSNrIż9><xi#<=ΪC H<;[;/KhɃ~r C=) 3shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.mdshell open vim,,2023-12-23 09:27:06X y 3$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptxpptx,,2023-12-23 09:27:06*  3$HOME/devdev,,2023-12-23 09:27:060) 3/Users/Q187392home,,2023-12-23 09:27:06.-  3http://none/none,,2023-12-23 09:27:06Y1'33http://11111/11111bla blub3,aaa,bbb,ccc,nice description a42023-12-23 09:27:06q 1'33,http://asdf2/asdf2bla blub2,aaa,bbb,ccc,nice description a32023-12-23 13:13:071࠼GFd"ۼz<9ov̫W˼v4<<àN<:;V#f%jP:s=,=Y</;ﷻ̼̑-;v<<& 7;v< <޺9_W\j@Z;@m!<^9?12b<<:/4<˱:;[Un[ؤ9oF3!,;t:Q;7=;< =oΚ;Ԏ﷼<_%欼|<`h<i;<Yk_9H;;>-T A:ap#<;0Uͻ ;T<'{ܺz}6Y(?<;8<1y.;:޼TvU;чE:U/j<{' )<1)/ol<'<ѹF;Fi%./j;D`5謻/=z <]Ր6<@Fb<'{;ggлQf:@FbA[ )=<;k8<GYS;+;&;8_;o"Zmջ,#6tQ=H !>:Wu@l%ܼ;%A< @Y9|W{y)T<`6NA <<;g;i{<(~2(~< pLH yZT!;E =T;wO<";;Wy,?AlUN,K <z1<橼<X;x << {4< H<#+9_hl׻E0Ø<*M<:@?fe<6W_Rh<_;e=p_]M0u_6;;ɷ{!h;O]: =,;c֕<:!z> ˣ;Q<żۮ<9=PJһ_aջ3;,|< Ѽ%_;;K;sk<.<<_sD.:~A,}yn+=ɷ$r)D.: ; {D< ;,: J;F]ͬpr|<͛<2<&i!ƻw ٻK(h;]\<ِ: Ǿpwm5< ;᲼ <{5n<;v=<S;: <-fEH< ;WY:l=z1={y=0f'=(]z .;B<{=2< PiȻ] : AeUy5< l-<<68S|~<Ĉ<` 亲u; -R+;Q <)IPNN/><ٙX'ܻH=;I< =f;=c;sF;R[`=1<-/<7j<ͼ<E;@<<[9 ;`<U"Kv8 ]@=B'H<` _<v켆eq<; X<5Ѽ':Eehz= ɞ< 庼{2K&Q r͉?l:3˼'<PuGw<&4J;ver/;j<iR) H<.3:&=I0":=<4K<ɛż!7:=sS::Dk;%5;导dBa<6CR;tV"fu;*w:m.;W*S:`4<l2;fӻ&G'9:|Æm<{Lf<Ѧ; 6.^rǼ}`<8!#yu:<<)k!;> ;9.4;<^rG';D;;yw 6<1ǻNY9i<\74JO>=ȡ 6 K";ż;/:cLVռmH:_;/<`@5=k;}ӯb: 8x<;)<:;Yt;=%x;oVT;SZ꼦U:[eٝ=OiY=N?D}'u3;<;vb"xw;8%P>YPȳ;Yt-=G}<<:2 :VRbX9g.ܵкLg*o¿.cf"VHzNl̠W+l;Uޕ¼fɼ4W+;~G:ϚtP<))=e{<;grۻ;LѪ||Z;<%;IS =) 3shell::vim +/"## SqlAlchemy" $HOME/dev/s/public/bkmr/bkmr/tests/resources/sample_docu.mdshell open vim,,2023-12-23 09:27:06r y 3,$HOME/dev/s/public/bkmr/bkmr/tests/resources/bkmr.pptxpptx,,2023-12-23 13:13:07fC0$oY\;1<>{ǻ\T7,; <`~&W<Ǽ%SռR3OӼLm=T8;mnF:P3<*kw 4nU=j߼8;vbs T3<_V<$;_4<!9SMƄ;)51YH@IޕB= eb6w|d<En;F<;<ޕ¼<>=nM%-˻i;x.;?\߫<,dJ:yzɻBZ8\Ҕ),a=3eyۓ)<?q'@3C9+)J:8d<{. Q;v4a<K<ù,& +=";'IHPJuݮ:j8;:Yp<<$h =>tˣW<;.=(=<-,4m<];<Å= j#;<`*<#ɇG靻),6[~c<5ޙ$<2=Bļ},<绔j}^?_M#; ,s\Ҽ;aQλ۪0;vLa;F CGT< <%X;ZG<(9=Ԡ0<+&4<4o!=S:KHԺF s;z<_z$;Y<} y;m;mr9Zõ[g<꼫⥺F?q<&}<m;󌻝DF(:~<[L<@CG<{;-=_Ɔ)" O ␻C