dey 036(<h@ sdex 035sD/n%(da؇<pxV4l+ p),8G#\`MdB0*8n";WqTkS e  !!!!!!(!0!@!V!e!s!!!!!!!!!""8"["g"""""0$~%~*+-4:>@ACDFFGI*JyJJ KDKMKWKfKpKwKKKKKKKKKKL?LcLnLLLLLM%M+M4MJMrMuM}MMMMMMMMMMN&NDN_NbNfNuNzN~NNNNO%OAOMOgOtOOOOOOOOOOOOOPPPPP#P,P3P d@Gj $p({4o7<@AK PvSUadse fhTj:llZmBo6qDrr8t,v,xyzu.B\{Ќ7Vԍ'LO^pv{؎"=Xvُ3OiC}O-gѓ"c˔Ey ZÖ)dؗJ̘ %,COckrƙڙ $8KgšȚҚ՚ٚݚ6Rn›כ 4:Ny+Kʝם4EaÞȞ͞Ӟڞ2?jԡ;NQUZaejou{ͣ !*.27@FKPVbiqzѤFiե*Ml¦?dڧ$Gkɨ"Lxԩ*@c|9^̫4aì8Y~:n(YЯ!X Bp߱D|߲ 4bGBgɵ&A]u۶ $;Se÷׷$Jmݸ%9SnعHӺ-AVkл +O_pռ 7Xz߽;S_nþѾ߾ -@R\izֿ5p4D.Km5Nc!Jm6Sr1\ 0i47@2 3G^'{,W4Ze3L`vz (@KYet .B\m .;Q_n+27CWr}$)8^ P5v0?HVB5p,j `Dp6g)@Yu6]p !0ERZgv/<Lo%+2Pe~;Xam}-049=BHMW]dimptx|#8Me $,5QnuzPYcp ,8DP\ht )6@g/:DLYkw +EPVew} ,8?BSh}%.7EMVo !*Af"4>JVco6Xi{*CTl} T2k 0pN%^-g#7Mby 5HYn"2:L\s -7=FXc :_w*BQg}*7DV]ci{   * : A J U ] g q v }           0 ? G Q [ ^ e k s |              ) 3 : F R ^ r               : X ` j             - 9 I Z m }                )4@Oy#4>Neu3EO\iz)H_~6?Kar !*;I\p %;E]q %5@P`ky6@Laiw|7du "AXiv 'DVj{ k{ $.<HVap!.;Ql;FOYak1=IQ`ix $)2:O]t~   % / 9 C N ^ l v             !!!%!0!7!?!I!k!r!y!!!!!!!!!" """-"4"?"E"O"T"]"k"""""""""""""# ## #'#,#5#A#P#[#o#~###########$$$#$4$A$F$L$a$w$$$$$$$$$$$$%%%#%.%6%?%I%[%a%k%x%%%%%%%%%%%%%4&D&l&&&&&&&&&&&&&' '''%'-'2'?'H'R'^'f'p'z'''''''''(('(9(D(P(T(^(n((((((((((((()))')/)6)F)R)Y)k)r)}))))))))))))))* **N*f**** +4+o++++++,,,*,5,;,O,U,Z,d,r,,,,,,,,,,,,---%-,-3-B-G-P-\-f-n-w------------.... ...8.B.K.X.^.c.m.x.~...........////B/g///////////00(000I0R0[0o00000000000111$1-171D1P1]1e1m1r1|1111111111111222!2)232;2I2X2g2r222222222222233!3)343A3F3P3X3a3q333333333344*4=4O4a4l444444444444 5555676C6R6]6i6}6666666666777737A7L7T7_7c7i7v77777777777777 888+848;8E8S8[8`8j8r8w888888888899$929:9E9S9]9c9o9u9}9999999999 ::;;<<<6<D<I<O<]<h<o<|<<<<<<<<<<<<= ==&=0=7=?=l=u==========>>#>q>>>?"?=?N?c????????@!@/@:@C@u@@@@AA8ATApAAAAAAB4BPBlBBBBBB9CUCxCCCCCD D@FIAtFAFFFHAAGKIL A: =@AAP\9A(AD99A99AAA9yQSTU0V<VWDXYP^\ZhbpZxZbdebZbZZ\`bddhd[^bZtbZ [<d(ZDb4Z<dDbPZXb`ZhZpZxZZZZ_bZZ[]^adbbbbcZZZLb y\Z\bZbb$,4D<DPdd\9=AApG(AxAA99=AABGh.&/&0&01&2&3&4&5&6&GrGGHHHHHHHHHHHHHHHHHHHHHRJL\ K{KKKK>KKLLLsLxLzL{L%|L%LLJLKMMMMMON]NPPwQRRRRRRRRRRRRRR5R6R7R8R@RaRRRRRRRRRRRRpRqRrRT\ SSSS@SASoSuST\ TTTTTTUUUUUUXXXXXXXXXX XNXOXXXX?XXXXXXXXXXXX%X&X'X(X)X*X+X,X-X.X/X0X1X2X3X4X5X6X7X8X9X:X=X>XfXvX&wX qX#~XY Y&YYYYNY:Y;Y<YYYAYY qY"vY#~ZZZ[[[[[N[[[[j[n[o[s[t[u[x[ q[#~[\\\\\\\\\\\\\\\"}]]N]]]]]]]]]]]]] ]!]"]#]$]%]&])]]]]]]]]g]k] q]#~]^^^^^W^X^Y^Z^^^^^^^^ ^ ^ ^ ^ ^^^^^^^^^^^^^^^^^^^ ^!^"^#^s^^y_________ _N_O______'_(_*_?____________&_'_(_)_*_,_-_._/_0_1_2_4_5_6_7_8_9_:_;_<_=_>_h_ q_#~___``&``N`:`;`<`&=`_`````` q`#~`acdf&ffffNff:f;f<f&=frfsftfffffff qf#~fgh\ g g hNh&=hIhh&hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhihlhmh qh#~hhhisjjjj jjjjjVj^jj?j@jBjCjDjuj#~jjj~{'&       Z   Jy  Y -Ltgvhimmm {v 3vl{CA6 {_n_8p9p:p;p7<@o>q?r=<cm 0{v mBu} CD/j/q})}<E-Znst C2 {""/"$""-" "1 "1+"Oy"M" "! ##T#T$$$$$ ${$Iy$$ $ &{&&&&\1&[ '/2(j)*]+m-]1-44?4H7,88e8`9{v :{:{:{::a:{:::(:F:I;b;==c>"??@@@X@A{`AA{v B x C C  C  D"D"D#D"DDD" D" EGGCGlGpG rG}GGGG)GG}GEGHH H H H H H H H H H H H H H H! H" H# H$ H% H& H' JJJKKK{v Kg K  LLLeLfLXLXLLLLWLWL{LdLCLL8 L> L MM{v NN(N(N(N.N0N NNNh6N/7NNNNNN N{v OOpDPPPoRPKPQRSTUVV WWXXXXXXBXXXXXX X XXXXXXXaXRdXPkXsXRtX5xXNyXLzXNzXR|XRXRXRXFXQXNXRXRX/XXXXPXXRXXXXXXXZ X)X,XJX{RXXXX XJyX X X X X! X X YYYY5xYYZ Y YJyY ZZZ3vZ\wZVZZ ZZ ZZZAZZ Z ZZZZ&ZZZ+ Z' Z [[[[ [[5x[[Z [[ [Jy[ [ \\\B\\w\V\k\l\\ \\ \\A\ \ \\\U\&\| \' ]]]B]I]I]]]]]]E]5x]]]Z ]] ]^]^]Jy] ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^ ^ ^ ^i^T^T^ ^ ^^^V^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ____B____5_G;_a_Pk_s_Rt_5x_Ny_Nz_R|_S_R_R_S_N_R_R_/_R____P__S_____Z _)_,_}6_}7_{R_Se___ _Jy_ _ _! ```$``5x```Z `(`` `Jy` abcdeffff5xffZ ff fJyf gghhh2hIhIhJhchhhEfh5xhKhhZ hh hJyh hH iii4iii'igi ijjjjj%jj5xj(jjZ jBj jJyjjj kkk{l stttt t uu/u(vv/v xxxxxx.x{^x{x=x dzzzz/z%|}}/n "q r {v 334}v s t (p/5v u v **T3(p {v {"> !Xo`| / 9 }J ~J {u }  {v "`{v (7 {{v x] $ y]Wzmywx]Q {v y]WzmQ {Q?( /%P j{w.G+HsICJ CK@C.LC,ZMKDޥNKTOw`PxrQR tS IT YUv-kVPEX VzY #ۡZ|w[ D\Z,]!] 4\˪G^#6_ 9tH` fŮQaq-mbq<cqHsdqWyeqff $rg<ׯh Li#lj |cwɞҞߞ!(!4@K_p̟$0<HW_i KUpO!5F  t 9>89#D88!qUid8M #4<52< * M9 <Fq  T(( K:  7i , , *  )3 8V 8P5<,F F 82 &8 ,@$:F 9, (  ( ,@(:F 9 (  ',0'j 9 ((, ( DVkQfIL <!,F 0 TL8YL<!^L1<2,F A  mL1<2,F A  |L1<2,F A  L1<2,F A  L1<2,F A  L1<2,F A 9 (L <!,F 0 9(LL"A#q MM"q M2q Mq L q L q L !#q MMq  L"A#q T Mq M"M2q Mq M q  M!#q Mq Mq Mq !M!#q MMq -Mq 5M  #q p0i&0#b'Mb%Mb&Mi$Mp0N Kq  K N b$ N"p b' "Jp0  N$&N-N6N?NHN QN(ZN aNgNmN sNyN(N q 00N!$9#"p7 !0F!$ 'N# $8 ! Y    (  $ ' N  NB@\&@B B(NF@@JQ#s3Sq C Ms3Sq C M"s3Sq C M2s 3Sq C MBs(3Sq C Mq  N NRr@BbC 1=Rr> pr@<b r9 NH- 0Y !5!F 9( 2S 8.+0S ; 5s q (7t 06s q  5S q ( 2S 8 5 q ( 2S 8 5 q  (N 2S 8u 5S q ((q (( &O q zD-Oq 3O`Pr@BT bOr@B2T q@2 9O @Pr@B2 ?OMx@ 9Sx@ 8(NxA   Pp@2 Op@2 TxB Qp@2 R p@2 (1=(q@2 q@2  q@2 = Pq@2 ):O0r> Sr0: r9O2@r> Nr = Or = Sr = Tr = P  r@<2 r9O0NPr> O  r@<2 r9Pr> NQNr0AA r0;@ r9O r> Sr = r9O r> Nr = r9O r> Mr0: r9 O&q   0I Cq 0I( @("O@r> Rr@<e Q  r@<2 r9O r> Tr@<C r9 P  L"p B"r? r p T r 8}r L 2 8 A 8<"@pr@Be 0C ; L   v06Q  ;T ;  S  ;T( ; L  5Q  ;T ; r? r    ;T( ;B  8"=p B $((d(,.@P q  i:PPT"p 5!E   7@~7@((2@)2@<2@>2@@2@,2@;2@:2@\2@"2@[2@]2@ 3(  P q 9q "p!g5rF  @ u ;:F"pp [ ;  ;  ;   F  ;t!h5 ;t(06u p {  5u p { F"p ;  ;  8  ;   ((G)qQq !3Ab:F   !  8A1("Q'Q-Q3Q;Q@QEQ+"9p - 0K40D/ 0Kr q @E2 JWQ7&"p Ci#pMMMiu#MMMMA/MQMaMqMM M ^M M M MMMMM5 MG MH M{ M Mb MkMi#MMRMMAMQ< MaI Mq MM M _M b M kM 'Mi#MM MkMAMMQOMa MqMiz@#MMMMibu!b!b!bz!#i #Mb MMMA\MQ)Ma-Mq*MM  M MM OMi{#MMM! MA# MQ$Ma Mq_Mib{!b!#is"pi"pi"piy#PMi|#@iwQq ib\@ 0Ab@r@ 0!b^@ 0Qb]@ 0!b_@ 0ab` @ 0!bb @ 0!b@ 0qbB@ 0!b@ 0!b@ 0!bR@ 0!b @ 0!b@ 0!bLb@ 0!b @ 0!b @ 0!b @ 0!bk@ 0!bm@ 0!b@ 0!b@ 0!bK @ 0!b@ 0qPqOQp  "p(Q9p K p V 9]"$pz  EG "p ;C  ;  q 2  Qw"pd ;T @ ;  w$ "vA ; ;  w$ w% w& "$pz"$pz"$vz d oa qU  d oa wL qL wL Pq X q X Qq X "bpp Gpr #pr "byQp Qr q $^ }   q $       } b    q $^     }       "$vz#MMMwM @2 "$pz"v;  ; ;           RIw% ARq0& "$pz"$vz"$vz tq q qU  t q q wL qL qL q XV Qq X Qq X "bpp Gpr #pr "byQp Qr Qq $ }   q $       } b    Qq $    }       "$vz#MM$MwM C@2 "$pz"v;  ; ;          S(q 80q 8 ("p ; 1 ; ;0  (S!B#!!B5 F 2 8 GM(FM(S!2#!!25 F B 8M(FM(Tt "p ; ;  q  " p  ; ;  ;  q g #  M  7 8 &rX 8  r T rP  @  1 = q  q a (( vT> qd$  "pd ;T  ;4  q $H  q@  @P T q0T(4T"p ;e 07  ;e 07  q T"p ;e  ;  q Tt$  9 @1 ="p ;e 07  @@e1=l "p ;e 07  @@e1 =$"p ;T 07   q@1R@@ C1=)"pd ;T 07  q $L  q@  @P TC8 1=q0 1 = q  q a@l @@eTA$ "p ;0 07  0; 8rX 8r T rP1;v*  U$  &#fMb M   7 8 \rY 8Sr T] r T] 1=9$"p e07 1=9"g p eP07 (Q ; 07(Q ; P07(rP 86Q ; lq $e ASq@2  @as@2 e q0T8#Q ;  q@1El@Tl q0^Uq@1Ce <@$e 8q0^T(U 5#WM M%M    7 8}rX 8rr Te r U (r U rP89 y 81qT02 <"v8;  ;  w@2 1=q e wa( ((V  "p ; 6  q g >#M M.M7 8`rX 8Vr T r U. "r U. rP.28+  8#q_0 <  "p8 ;  ;.  q   @ 1=q  q a((( W;9"pq 00bq % Z## "p ;T  6  q C( W # MM7  8 rY 8 * r U r U 8  8 8  ;9 "  p  ; (rP 8 m" p  q 0 ;" p _ ;  ;  "p ;!  ;  q % bQ# <  " p 7 ; 6  q  ( `XM"r p Tr r 8;r % P 9p D 18 q 2 r T("pb ;v  ;  q e(X,z"p8 !5! F ;S 3($ =$ v c 3 $ v Bc"p ;F   ;v 8 ;v  "p ;F + ;v  8 "p ;F \ ;v  ;  8 "p ;F C ;v  ;  $  0;F "p ;F  ;v  ( XAp 2 p EX p 5 #UMq Q "p ;v  ;  q e$  0;  ':>1Y!b"p5!8 ;0E070( RY1$  bw0; gYEq "p ;A  ;  q $ "$pzqN  l $  g  q Aa(;Yuq q 1; "pd ;v  ;  q $m "p ;v  ;  q $m q \! q@# T"p{ ;  ;W  q v$  bw0;V  `q v(jYw 1<  q T("p ;T @ ;  $  #f b M    7 8 rX 8r TL rP "pd ;T @07  Aq $ "p ;T @ ;  Aq $ q \ q@#2 T"p{ ;e P ;  q T$  bw@R0; );  [Z"$pz"$vzB T Q wL bQbp0W bQrp0W } b  q $  b     } b   Qq $ b    "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W   o     $  bwPb0; ) Zw%% "$pz" $vz B T  Q &Qq $  &Qq $ wL% wL "bp WGr W$Rp0W $Rp0W }     '   } b   '  !"#$vz##Q %#UM!M#Qbs@2 ""$vz"p ;e P" ;  ;e  Q (  $$  bwPb0;  Q[%#VMb M"$pz"$vzB T Q } b  q $      } b    Qq $ i  "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W       $  bwPb0;  ["$pz"$vzB T Q bQbp0W bQrp0W } b  q $  b  n   } b   Qq $ b n   "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W   o     "p ;v ` ;  q e$  bwPb0;  \"p ;2  6R  B$  0; $\ " p   ; =  q p 2 p E p F !#!5I(E q  r  M" p   ; E 07  q " p   ; F  ;  q (p G " p   ; ;y  q " p   ; ;i  q " zp   ;  8 ;   ;  \ ;   ;  / ;  ;  $  # M 0;$ 9  q rR 98rPr p@R|h$  # M 0;$    '! \wh IQq $ "p[ ;e P ;  ;e  Qq $ "$pz"$vz TQ "pE ;e P ;  ;e  ;e   T Q wL } b       } b  m  "$vzQ %#UMMQ c@2 $  bwPb0; \1$  bw0;  ]$ l cV7 ] w 9A  9A  9 A  8#GM $  b|  7 rR 9w" p K0 K$  @"C "p ;e P ;  ;e P07  q T(w r0T8 rP w w 8 8 O8 \F)s(F(rX 8r QL r TL (w r0T8 rP ( 8 rP '5j ](r #Tr r 8r  L(7eq^!b"p5!8 30E070( $^!R"p5!8; 30F ;0( E^ p 2 p E p F !#!5I(E q  r  M" p   ; E 07  q " p   ; F  ;  q (p G " p   ; ;y  q " p   ; ;i  q $  # M 0;$ rR 9rPr p@S|h$  # M 0;$    ') ^w%% "$pz" $vz qU  T  Q &Qq $ &Qq $ wL% wL $Rp0W $Rp0W "bp WGr W#r W}     '   } b   '  !"#$vz##Q %#UM!M#Qbs@2 ""$vz"p ;e P" ;  ;e  Q (  $$  bwPb0; A_9bs (I_9b(Q_9(Y_9b(a_:b{!Pb!T"p5 b{F R(5A bF R( 51bs  M( _b u!b !b !b z!"p5'b b uF r b b uF r b yb uF r b uF r (5cb b F r b F r (5sb b F r b F r (5#b yb zF r b zF r (r r 8 r b M C( _y"p* ;T  ;  ;T  ;  q C"Cp 2q \q T 020 20 2 b q 02s$  @"C&s 8q Cs   % b0C `c"Cp 2q q T 020 2 0 2 7j  q 02q 02$  l @"C' 8q C   % b 0C?` 98(U`C[`A9!R#!!R5 6F 2 8 M(F 2 8M(F 2 8M(FM(( `3!q#2e M"p ;T  6 7 ;T  M5 FM(`&!P#!"p ;2  6b 7 ;2  MqPE!`"p,: h 0K`(q 80q 8 ("p ; ? ; ;0  ( ` 9 S "p ;v  ;  ;  "p ;v  ;F  q i0;J 8@rY 87r S` 9&"q p c("p] ;v  ;  ;  ( ;c  6&(rP8  q aj"p ;v  ;  q i@jq  Da:qS$  "pj ;C  ;c  q $8  qW  YK@' C q C(0 uaR1;q0^G"p ;2  ;  q &#3q  M@'0 ="p ;2  6  q &(a"p ;2  ;r  q %9q0^F"p ;2  ;r  ;2  ;2  ;2  ;2  "p ;2  ;  q %@&@ ="p ;2  6  q %(a$  b ,"p ' r P q  %r P  q v* =% b0 8q     "p ;e 075  ;e 07  q P( r P  q p^+; (  "p ;e 075  q P(p@, (l @ e (  "p ;e  :  q P)f  r  bAb Ib"p 'Sb  q $3Zb.-$  ,b`.  ,""pJ ; p. :  p v'-/012pT62 - % barr0\ .a  &8& &a  8  /0 1 27 (-/012pT!2 !P!b0; (. r v . (r  - / 0 1 2v9 (. r v -/ 0 1 2v: )o. r v -/ 0 1 2v8 )T. r v -/ 0 1 2v8 )9. 'r v -/ 0 1 2vA ).a  #f.a  8-#p0@ )(. r v //w/ ,"pc ; p, 6  q v-,p ? ) "p ; . r  --p- ;  q v)"p ;v . r  ..`. ;  w0 8#w  M     1 27 )X"p` ; 1 ;v `0 ;  h( &#kM M Y 0 127 )9290918/ "p v'"p| ;v A.q   ;v | ;v  %'J~#wM'q v ({'#wM q M q v G#wM(M( b M 8 f M q v "&#fM%M%P"b0; )i.a  .a  w 8pa2z"ph ;v ` 6  w 9"p` ; 6 ;v ` ;  w0 8>w2 8[lq   '3vPM  / 17 )  a  8((.("p ;v ` ;  ;v `0 ;  h( 2(M   17 )-/012pTJ2 )-/012pT=2 ). q *"pj ;v w*  ;v  -/bs2pT>2 )w q v)k-/012pT>2 )[-/012pT<2 )K-/012pTB2 );F)1`)  8)= #oMM&M6MFMV" Mf# Mv$M M M M M"p ;v `) ;  ;v `) ; ~ ;v `) ; } ;v  -$  l c7 )-/012pT32 ).a  $-$p 4 )r Ajz8N* (dbs$  b +N"p C'MTK1 = % b0Cs 8q Cs   2"p ;T  :$  q C( @_dZs  Pq i"p Cib@ @!b"@ @!"pib00bs s 0pb  0Pb0`pdp   vd(  b +""pH ;v  :  p e'@ 8   % 0 r e q "p ;e  ;E q 9("p2 ;v  ; ) 3v   ;e  @ ((8d0b @ +"""pH ;!  :A  p '  (d s  8 )"p b 2!""p H ;  :  p '"p(q q  qK s 9s  'r 0   9  0 (   @"pi 1=bq07  % 0W 8  " "p  ;  :  p i'e  q (e"$pzb +r""pH ;C  :  p 2' 0b  q 8E!(  V  % r0\(  0"p ;2  r B  ;#   ((H fes(  b +""pH ;T  :  p C'[Ka s 8s   % 0 r C "p ;C  ;# q 9("p2 ;T  ; ) 3T   ;C  [Ka9 ((8e#iepeg j d 89 wq eb9 'R0e 9 wq eb(  7 9b(% n  (xX 9-w"p ;v ` ; b ;v  :  q exPb(EP#"txR  Qp "p xV 9b0h  !Rc@q2  xY( w"p~ ;v ` ;  ;v ` :  q ebxP)xP ) xP'<*~ LfKi 8%!V#g"u"z p p  85(w q   x(5b  L(  x(;w2wDfR k 8"`p   #p!q@ 2" "sqp p "tp#  =-P@2(  w"v;  :  w(  j 90e 9 ww)d!5W0p  !7 w'w" p@2"p bTf2 99.% b0( w"v;  :  w(c@"2)x  w"vH;  :  w)X"?& ~b Xg"p b370 #D&f0 L A"px ;e  ; w ;e  q T(  19(!0 !0 $( Aw"p ;e  ; d ;e  q T( K~~Ug$8!c9"v"|  p Cp 0!b5! E00( ( g?8:  3F4#`!@ T!5B4H2T8 Cw"p ;e  :5  q T(T(~!gn i 8!# 5F 1p u M (wq Cv~  5E F F v L (l 8 !Ӱ98 !ð9#8 !!ԁDL L #8 !āDL 98  !5; E L  (((!Ӱ9 5  E L  (8  !5;  E L  (p0](ph0o 5P((  " p  z ; 6  q ;  q (i i !5>     dM p@M(  " p  y ; 6  s ;  q   {q  @ma (<~ ~Oh#HH"!H"!H"h'OOOOhP"p Cib@ 0!bx@ 0!ba"@ 0!b 2@ 0!b B@ 0!b R@ 0!b b@ 0! ip  i % 0@b0!i"p,: h 0K/i ! >i $  ! b  +  "v ; !6  w!l 5"F    9"v ; ;  0     8  19!8 Qq0 w 0"v ;  ;  w"v ;  ; ;  pTK2 <p@#2 )3 ;  ; ;)@   q0! 8 )   q0( ! 8'8 ;"v ;  ;  "v;  ;  wp@2pq0^H: & 8w  bp v! 8])X9 p@2(%Z1Ok|~ FjFb $  +)" Gp ' q@- = 8 q  p   r  q   q@/ ( "" p  ;   r   ;  p ' r  q "p  ;  6h  q g  q@- )} "" p  ;  r   ;  p 'q g  q@- )G r  q   q@/ ), "" p  ;  r   ;  p ' r   q_' =p ) )h6u Ojb + ( ( ( jb  "v#;  : ;  6  w+ J"v);  :  w 0 $    8  9  9"p 8q w 08  0     8  198 Qq0 w 0 @" 1 =l 8w  q0 p )9)`)i""vI;  ;  v' "v!; q :  w ("v;  :  w)-!k  q $kb"$pzb  + F"p) ;C  :  q 2  w 9$    % br0\*(  "p ;2  r C  ;  ;2   ( r 2 q   "p ;2  6   ) ("p ;C  r T  ;  q 2)Q   )K  "p ;2  r C  ;  ;2  q g2 ) r 2    "p ;2  ;   )  2 8b)Ly Xl $  b +"" p  $ ; :  h ;  p '"p  ;   r   ;  q g> _KA = 8 q  p 8p  r  q"p  ;  ;X  ( " p  ; ;Y  q (("p  ;  r   ;   q g )z r  "p ;  ;x  )Y@"clpll%8"8 8! ! 3! ! 3  " * p0 ! 5  F   8 (3D 9 [8    9 80q 29F q 0 (  -" p   ; :z  q   D 6D 5   (D 3q (D (D 398    8    9 F 0 )~  -" p  H ; :j  q  ()D 3]8    9 S8q  1 8 FF q T 0 );D 6D 5   (D 3q (D ()\'<=Edqm8 8 88!=  9   8!5r W, 8"p ;  ;  ;  (D 91r S, q ( -" p   ; 6)  r ; :y  q (D 3r U, 9  8((D 3r T, q e ( -" p   ; 6)  r ; :y  q )kKPmB 0 9 0 99 0 9  0 8 0 8b( 0 8b ( 0 9 0 9 3 0 8( 0 9l 0 9 M 0 8(x 0 8( 0 8((mB  9l  8d9  8\  8T  8L  8D  8<  843  8,  8$l  8M  8x  8   89 q  (q  (n<b9(B  8#Mb MMM @MPMG MpH MM M /M M M  MM^MMMM5 M{ MMMMMMMMMkM#&`#&v   82#&MMKMM @ MP#M#%&#'&Cv (9  8w#MMMM @MP(MMpVM)M *M M M M  M MMY M#&L#&kv )L  8#6M#5K#7KCv )+  8#6M#5K#7KCv )   8#b Mw MMRM @MPiMMp< M M M I M M M MMkMMM_M#&#&v )  8:p#MMdMM @MPMBMp#&p#&Cv )@  8%# MZMM#&#&Cv )3  8%#MMM#&#&Cv )  8#6M#5K#7KCv )l  8k#MMMM @MP! M# MpM M M M _M  M $MM#&D#&_v )XM  8H #MgMMM @#MP"MMpM[M #&; #&Jv ) x  8!#MMhM#&>#&ACv )  8%#s M MM#&##&(Cv )@)   oF5$B  8#Mb MMMMQMaG MqH MM M /M M M  MM^MMMM5 M{ MMMMMMMMMkM  8`#MMKMM MQ#M(9  8a#MMMMMQ(MaMqVM)M *M M M M  M MMY M)u  8 #0M)e  8 #0M)U  8m#b Mw MMRMMQiMaMq< M M M I M M M MMkMMM_M)  8%p#MMdMMMQMaBM)  8#P MZMM)3  8#PMMM)  8 #0M)wl  8U#MMMMMQ! Ma# MqM M M M _M  M $MM)M  81 #MgMMM#MQ"MaMqM[M)x  8#@MMhM)  8#Ps M MM)) o^* -piB  85# &8* pXp -"p ; p ;R i ;B  ;  q &  84b# &>* pXp -"p ; p ;R i ;B  ;  q &(9  85# &* pXp -"p ; p ;R i ;B  ;  q &(  86# K* pXp -"p ; p ;R i ;B  ;  q &)P  86# #K* pXp -"p ; p ;R i ;B  ;  q &)  86# &* pXp -"p ; p ;R i ;B  ;  q &)  85r# &u* pXp -"p ; p ;R i ;B  ;  q &)  852# &L* pXp -"p ; p ;R i ;B  ;  q &)b3  852# &* pXp -"p ; p ;R i ;B  ;  q &)'  86# K* pXp -"p ; p ;R i ;B  ;  q &)l  86# &* pXp -"p ; p ;R i ;B  ;  q &)M  86 # &* pXp -"p ; p ;R i ;B  ;  q &)sx  85"# &n* pXp -"p ; p ;R i ;B  ;  q &)8  852# &;* pXp -"p ; p ;R i ;B  ;  q &)) qQ#BMM!9M1MAMQ MaMqM3 M M l M MM xM M qB @ 8b  @ 8 (9 @ 8( @ 8( @ 8( @ 8R( @ 8( @ 8 (3 @ 8( @ 8(l @ 8(M @ 8 (x @ 8M)x @ 8s )l)h2q ="v0' : =;  "xp O 9F-~w=0 #&80 #L  .w(! "v ; ;   !59"va ; ; F ;  "v ; F ;  M ("pp0=r0b"t2Pp #" p [ !@q2    =!0 !0 )(  -"v};  :  w)  -"v;  :  w(5#&~g~~qz8w 0  =  93-"v;  ;  w /w0w( k 8(  #`!a@ 2" "sap p "tp#  = 0P@2(  -"v;  :  w)s  !5f0p  !7 -'w"p@2 0 F! 5"vA ;  F;  M (M"pp0  r0b!)$?~V~rr& &$ 9@D$ Aq B0A-Fq !(ri"p Cib@ 0bx@ 0!b"@ 0!b2@ 0!bB@ 0!bR@ 0!bb@ 0!br@ 0!b$@ 0!b% @ 0!b9 @ 0!bz @ 0!b; @ 0!by @ 0!b@ 0!b@ 0!b@ 0!b@ 0!b@ 0!bl @ 0!rp r(q 80q 8 ("p ; 1 ; ;0  (rB 8"p ; 6@  s,B 8#"p ; 6@ 1 ; ;P   S(sa #M VW7 9rR 9rP(rY 8#r U 8 "xp (  1 q0 ( rP'rPb82q b @ ("): 8DD VsB#M7 9"prR 9rP(rY 8#r T q 2  A#Uq 2 Mq0I( rP'rPB@ = Q #  5    L (" p - 0S  1"p ; :  q Jb8 2q b )m(!Js9q@2 tq@2 t % % % % % % %+ %, %@ % % % %A %B %C %z % % %w % % % %7 % % %b % % %6 % % % % % % %+ %, % %>t8+$""p ;!  6A  p ' (0(@( ""Wt% b 0qT 8 % b0bt"pB#M7 8(rR 9 rP rY 8r T q !  ( rP' rPB\K = o #ڴ 5,   L (  1" p  ; :  q  ("  p - 90S  1" p  ; :  q Jq b 8   2q b  )l&B9cPutb 1" p   ; :  ; 6I  q +"1" p  D ; :  ;  q B"p  ;  ;  q -    B x 8 q@ =b8 2q b = 8  q(B8p K "p  ;  6X  (9(9"p  ;   r   ;  (9"p  ;  r   ;  )e"p  ;   r   ;  )C)?9 x 8q00 )L x 8q00 )>@p )8w#w#w#w#w#v 1 b +  ( (  9#M# MVW7 8;rR 3rX 8 r U rP(1"p ;!  :  q rP( rP'1"p ; :  q (       :On$Cv b"  1"v&; " : ;  6  wB+ S1"v&; " :  w#  8   !   bB  81#  9#  9!#p " #p q 8w 088 q 02w 0@"2 1<o1"v3;  :  w)6)F)C,)@<)=L):9)5)0)+)&)H)R 1"v!;  :  w(b82wb "v : ; 07  w 8 ! w)  8" #p " x """0 @"2 1<!1"v;  :  w)Mb82wb "v : ; 07  w )e9  8" #p  3" x """0 #  Z a  a  99"v! = '  ; ; q 7  0 "xv 9Q 9K""vF;  ;  v'  1q0""vF;  ;  v'@"2 1<C1"v3;  :  w)  1"v!;  :  w)"v : ; 07  w 8X"pw p0Y #  p0 * w p0T w p0 s@"2b82wb )  8V#   6"v; 07  @2#@"2b8S2wb )E  8"v! = '  ; ; q 7  " p 0 "xv 9Q 9K""vE;  ;  v'  1q0""vE;  ;  v'@"2 1<!1"v3;  :  w)""v : ; 07  w b8H2wb ):""vI;  ;  v'"  #$+ #~~ )x  q  /x0! 9xX"$pzq0 - 3(Jg)b 1"pp ;C  :  ;C  6  q 2+ 1"p{ ;C  :  q 2"pf ;2  6  )(p@ w 8 B 2 8     % r0\+ (p@ ("p@ (2p@ (Bp@ (B  "p ;2  r C  ;   (B  "p ;2  r C  ;   "p5 ;2 p   62   )S9  )L9  "p ;2  r C  ;   )$9  "p ;2  r C  ;   )  "p ;2  r C  ;   )  "p ;2   ;2     )  "pH ;2   ;2   4 )  )  "p ;2   ;2   )aD  )Z 9 2 8c)_)[2|hmrw<d x<b 1"pL ;v  :  ;v  66  q e1"pM ;v  :  q e"p    +1"pK ;v  :  ;v  q e"p ;e   ;e  p ( q  qR b82q eb E("p ;e  r v  ;  9q  \KPb b82q eb E("p ;e  r v  ;  9q  \KPb b82q eb E)T :#:#:#:#:#[Gyi-My <pRwC4 Wy `y - " p !p !p !p !p !vy:5H \ > S O ] X G 3 5 4 9 : 2 1 l g i m h qT 8p Td c  5"pv ;!   ;!  q )o 5"pz ;!   ;!  q )T 5"pt ;!   ;!  q )9 5"px ;!   ;!  q ) 5"pw ;!   ;!  q ) 5"p{ ;!   ;!  q ) 5"py ;!   ;!  q ) 5"pu ;!   ;!  q ) 5"pk ;!   ;!  q ) 5"pm ;!   ;!  q )| 5"pl ;!   ;!  q )a 5"pq ;!   ;!  q )F 5"pr ;!   ;!  q )+ 5"pj ;!   ;!  q ) 5"pi ;!   ;!  q ) 5"p ;!   ;!  q ) 5"p ;!   ;!  q ) 5"p ;!   ;!  q ) 5"p ;!   ;!  q ) 5"p ;!   ;!  q )n 5"p ;!   ;!  q )\ 5"p ;!   ;!  q )A   %#*(/-4297><CAHFMKRPWU\Za_odtizz z5a 7 b 8 ` 6  5"p} ;!   ;!  q ( 5"po ;!   ;!  q ( 5"p~ ;!   ;!  q ( 5"pp ;!   ;!  q )z 5"p| ;!   ;!  q )_ 5"pn ;!   ;!  q )D   !@_~zF:"p ;  ;! ) ;!  ;! < ;! b ;! : ;1  ;! F ;A \ ;! : ;1 ) ;! : ;1  ;! F ;A  ;! F ;A * ;! ; ;! - ;! : ;1  ;! : ;1 M ;! : ;1 O ;! 9 ;!  ;!  zo  {  p {p {!    $  /{o5= / 0  5"ps ;!   ;!  q ( 5"pg ;!   ;!  q ( 5"ph ;!   ;!  q (  1P\{# $qK 2 1  " t{& %  ' {%  5"p ;2   ;2  q !({n {<q _ ^ < ; p T 5"p ;2   ;2  q !({Z    #b M "p ; 6  EFG7 8rX 8r S rP "p ; 6  @@ = q0  {Qp !p !p !p !p !             { {%     p !p !  |r                    p !  ,| 5|      C| L|     Y|   d| m|      {|^b-9 "^p !i-b- ' |  $#FMM   7 8\Ar Z"pxY 8J Ar T Ar U w 0N0 N * w 0NT q 0N AR@"2( 8xP'8xP9$#FMY M   7 8\Ar Z"pxY 8J Ar T Ar U w 0N0 N * w 0NT q 0N AR@"2( 8xP'8xPQQq|`98"p ;2  ;b  ;B  0; 84rY 8+r S "q0%( rP'"p| ;2  ;b  ;B  (rPl @%C%5}1;q0el #"q v M@! <"p ; 07`  ;  ; ( ;  ;  ;  ; b ;  ; b ; / ; 07`  ;  ;  ; ( ;  ; $ ; 07`  ;  "p ; 07` E ; & ;  ;  ;  ;  ;  ; 07` E ; ' ;  ;  ;  ;  ;  ; 07` E ; % ;  ;  ;  ;  ; 07` D ; $ ; 07`  ;  "p ; 07` > ;  0; 8`rR rP"p ; 07`  0; 8vrY 8)r S 2!""p ;1  6! ^ ;! 07a   erP)D rP' rP'(u-} }  k f }   j e }.     L B N W }   K A M ~, !   ~ T D .~ 7~  l g m h I~  [ P Y~Q+ "         J Z U E R @ }~  . ~3  V F (      ~   ~)    Y Q I ? ~)    Z R J @ ~  i ~   ~p ~  C *5    5 q0( 5 q0(  Y5p C     p C p C 5 q ( 5 q05 q ( 5 q ( 5q (! & *3FPN=      H \ > S X G bp !p !qT 8p !p !oJ    n o p Tp Tp Tp T 5"p ;2   ;2  q !(*+     (  d c  ( 5 q p 25 q *     5 q )    5 q p 2p 2p 2p 2 55 q 6 8n 8 8o 8 8p 8qT 8p p  8p p  8 8"pq 00 UK8@ 5"p ;T  6 o ;T  q CBUK8@ 5"p ;T  6 n ;T  q C 8O 8 25"p ;C   ;C  q 6)j 25"p ;C   ;C  q 6)Z 25q06(7B L]  383 q e95#WMM%M,%#Y Z M  M    7 9 3 q erY 8%r U^ 3"p@ ;v ` ;  q e8 ="zv  3"p ;v ` 6  q e<v3"p` ; = ;v  q e9H"Qp Y "kp v  Qb0 9"p ;v r S~ q  ;v  QctTK28G )B 30q e)8#  3"pN ;v " p0 ;v  q e"Qp Y "kp   Qb0 9"p ;v r S~ q  ;v  QctTK28 ) 30q e) _5"pj ;v  :  q e8 ) 30q e) _5"pk ;v  :  q e8r )m 30q e)c _5"pl ;v  :  q e8G )B 30q e)8 8 ' 30q v(rP3 q e) ( _( _( _)Sn s)n)x""" % ~~}{~~~~~}{~2p p p p p p p p p C 8 \8p 1p 1P8 \8p 1p 1p 1p 1p 1p 1p 1 Gb55"pO ;C  6 t ;C  6  ;C  q 5+5q 5p vp vp vp vp vp vp v v79p vH79p vH79p vH79p vH790;7 8 # r Q0rPp vH79p vH79p vH79|p vH 79lp vH!79\p vH"79Lp vH#79<p vH$79,p vH%79p vH&79 p vH'79p vH(79p vH)79p vH*49p vH+79p vH) 25 q0C) ' 25 q0C)j ' 25 q0C)U ' 25 q0C)@ ' 15Nq Cp vHrP) 25 q0CrP) ' rP' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C)v ' 25 q0C)a ' 25 q0C)L ' 25 q0C)7 ' 25 q0C)" ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) '-79p vH.79p vH/79p vH079p vH179p vH279p vH379op vH479_p vH579Op vH669p vH769p vH;79p vH) 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C) ' 25 q0C)y ' 25 q0C)d ' 25 q0C)O ' 25 q0C): ' 25 q0C)% ' 25 q0C) ' 25 q0C) '$#3CSc$4DTdQaqTd t)=GQ[eoy%5EUeu    & :0: 7:":- DB NW Xl b l v      ) > S h #-7"A2K? T i ~     * 4 > H& RD         V7&"p CiZgiP#MMMb MAkMi>`#MMMb MAkMQMi?#MMMMA/MQMaMqMM M ^M M M MMMMM5 MG MH M{ M Mi= #MMRMMAMQ< MaI Mq MM M _M 'MiE@#MMMMiK#PMi/#`MMi0b>!b=!bE!#iL"pi9"piB#PMi6#@i4bZ\@ 0AbZ@r@ 0!bZ]@ 0QbZ_@ 0abZ` @ 0!bZb @ 0!bZ@ 0qbZ] B@ 0!bZ@ 0!bZR@ 0!bZ @ 0!bZ@ 0!bZ@ 0!bZLb@ 0!bZ @ 0!bZ @ 0!bZ @ 0!bZk@ 0!bZm@ 0!bZ@ 0!bZ@ 0!bZK @ 0!bZ@ 0!q'p  "p( w "$pz"$pz d oq-  d ow$ q$ Qq 0 w0 "b9p WGr W#r WQq  }   q        } b B   Qq     "$vz#MMw% C@2 "$pz"v;  ; ;          (q 80q 8 ("p ; 1 ; ;0  (!B#!!B5 F 2 8 GM(FM( DŽ> qd$  "pd ;T  ;4  q H  q@  @P T 7q0T(4 2 8 q   A(, w( "$pz"!$vz!B T !Q v+% q e )q  %'p , )Qq  w$( w$ "b9p WGr W%Rp0/ % Rp0/ }     *   } bB  ! *  ""$$vz$$Q %#UM"M9+[$Qbs@2 #"$vz"p ;e P# ;  ;e  Q  +  %$  b4Pb0; +( M"r p Tr r 8;r % P 9p  18 q 2 r T(7"pb ;v  ;  q e( Ap  p X p  #UMq Q 7"p ;v  ;  q e$  0;  ':>1!b"p5!8 ;0E070( Rq@Tv 1$  b40; gEq "p ;A  ;  q  "$pzq&  l $  g  7q Aa(; 6q"pd ;T  ;t  q I q@( d$  b40;4  7q T(, "$pz"$vzB T Q w$ bLQbp0/ bLQrp0/ } b9  q   b     } b B  Qq  b    "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W   o     $  b4Pb0; * K w% "$pz" $vz B T  Q "p ;e P) ;  &Qq  "p ;e P) ;  &Qq  w$% w$ "b9p WGr W$Rp0/ $Rp0/ }     '   } bB   '  !"#$vz##Q %#UM!M#Qbs@2 ""$vz"p ;e P" ;  ;e  Q (  $$  b4Pb0;  %#VMb M"$pz"$vzB T Q } b9  q       } b B   Qq  i  "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W       $  b4Pb0;  9"$pz"$vzB T Q bLQbp0/ bLQrp0/ } b9  q   b  n   } b B  Qq  b n   "$vzQ %#UMMQbs@2 "$pz"p ;e P ;  ;e   W   o     7"p ;v ` ;  q e$  b4Pb0; s!q  !q  88   2 = 06/ "p  ; 3 ;2  ;2  ; G ;2  ;2  ;  ;2  q / $  n  c7 ! Јwh IQq  "p ;e P ; B ;e P ; ,8 ;e  Qq  "$pz"$vz TQ "pF ;e P ; A ;e P ; ,8| ;e  ;e   T Q w$ } b9       } bB  m  "$vzQ %#UMMQ c@2 $  b4Pb0; )>(P1$  b40;  e$ l cV7 sw  9 w 98 \8 ,8 X$#%M  $  b67 rR 98" p )0 ) $  @"! (q  r02 8 rP  (\$(rX 8r Q* r T* (q  r02 8 rP ( 8 rP '"Br,z"p8 !5! F ;S 3($ =$ v c 3 $ v Bc"p ;F   ;v 8 ;v  "p ;F * ;v  8 "p ;F \ ;v  ;  8 "p ;F C ;v  ;  $  0;F "p ;F  ;v  ( Q(r #Tr r 8r  L(7eq!b"p5!8 30E070( !R"p5!8; 30F ;0( ؊Av  r 3-#r r 8*r  w  L( 'p  Qp  P!# P!53(E w x M 7"v ; E 7  w (Ap  7"v;  ;  w7w 87"v;  ;  w#M$  0;j rR 9 rP x p@*2$  0;j rR 77"v; rR 6  w :?<, ow' "$pz""$vz"q-  T "Q +Qq  (q  +Qq  !(!q  w$' w$ &Rp0/ & Rp0/ "b9p WGr W#r W}     )   } bB  " )  #"%$vz%%Q %#UM#M%Qbs@2 $"$vz"p ;e P$ ;  ;e  Q  *  &$  b4Pb0; 9bL(9(9bK( 'sb>!b=!bE!"p5b9b >F r bBb >F r b>Fr (5Rb9b =F r b=Fr (5bbBb EF r bEFr (r r 8r bLM2(~  77"p* ;v  ;  ;v 07  q j$  #fM 0;2 8rX 8r S rP<Z1 =Tb q  0o %o %o %o$  @"v 7"p" ;v 07F  q j 8   % b0v  "Ep Tq q v 0T0 T 0 T 7  q 0Tq 0T$  l @"eI 7"p- ;v 07& e ;v  ;  q eqT 8pT)2 8   % b 0e "p ; 60  @3"p ; 60  (C 1q  pv   3!q#2e M"p ;T  6 7 ;T  M5 FM(6&!P#!"p ;2  6b 7 ;2  MqPE!Q"p,: h 0K _:qS$  "pj ;C  ;c  q 8  qW  YK@' C 7q C(0  7$   bZ ,"8p v' q p@  q0B=#% b 0v qT 8 % b0v 8  p3  c7q j(q@!  @r q0(l @b ( c7"p ;v  :6  q j( K ]qU{ "8p ' q $ 1    ,=8Qbq0  Q38Z7$  bZP8  ,""pJ ;v `8 :  p e'"p ;e P 6  Z(79:;<pT2 7 % b Qbr0\ 8Q  .8.H .Q  8=k 8Q  6w6 9"p ;e P6 ;  :Qq  :79:; <v (:q  79R;<pT2 (8 r e  :q   7 9;<v )h8 r e   7 9:;<v )M8 r e   7 9:;<v )28 &r e   7 9:;<v )8Q  *7*p ! )"p ;e 8 r v 88P8 ;  w: 8 b /;<7 )"pP ; 1 ;e P: ;  ^(b0:;<7 )A8Q  ,#fM,q e '9<9:9;89 "p e''R0; )e9<9:9;89 "p e'"pA8a   ;e  ;e  ,/  K#fM/q e 1}&#fM q Mq e "F#fM1M"'b M7f Mq e (%#UM,M,(R0; ) 7"p ;v   ;v  q e)i8Q  &8Q  $w& 8s%%Q2}"ph ;e P% 6  w$ 9"pP ; 6 ;e P$ ;  w: 8Aw< 8^q   &3eR M 9;7 )> &Q  8%(%(.("p ;e P ;  ;e P: ;  ^(<( M ;7 )79:; <v# )3/q e79:; <v. )8 q 4"pj ;e w4  ;e  79Rc<pT2 ) 7q e)79:;<pT2 )~79:; <v )n79:;<pT2 )^F3;P3  8)`"p| ;e P3 ; | ;e  -"pO ;e P3 ;  ;e  "pO ;e P3 ;  ;e  "pi ;e P ;  ;e  0"ph ;e P ;  ;e  !&#fM0`iq Mq e 24"pM ;v `2 ;  q e|F#fM!`iq M'q M7q Mq e #4"pL ;v `# ;  q eb8Q  9>E#UM2M#&:M6f MQq  )u#UM-M-&M-6M-FM-VM-fM-)R0; )"pP ; = ;e  U#UM2M#&:M6f MFMQq  )(79:;<pT2 )8Q  +7+p  ) Y0C7XhuuH$  bZ ,"8p e' Z 8< T 84l XKQ=" % b 0eqT 8 % b0e 8   r e p]59 (MVKQ ( R7"p ;v  :&  q e(q0 Z gi( ]kscSMxiwSq ikSq iq"p Ciybyx@ 0byxx"@ 0!byx]2@ 0!byxB@ 0!"piobo0@boMM0Pp  J33jq 5"p ;C  ;  ;C  0;' 8rY 8r S0 = dq CrP3iq 5ݐ x hdM"p1 h0  )T !5R1MF0 sxM@"7( d"pG ;e   ;e  q Xh"p ;  ;e  0 M0 sxM@"73"p% ;v  ;  q ebw8bw d"p$ ;e  ;  q X(2'  x h M 33"pn ; &  6  q y   8 ="ph0 3"pi ;  ;7  q y   "pb ; q  ;    3"pc ;  6 0 ;  ;g  q y8 <Lh"p ;7  ;  0 M0 xM@"* 3"p ; 07G  q y 3mq yM0 xM@"* 3"p ; 07G  q y)J  % 00 xby    +"Gp T' 1  D "p ; a ;T  ;$  ;T  x@ =bw8bw p ?x"p ;T  r d  ;E  @t (3gq Tx@w ( Ot8by @ +*3kq ""pH ;!  :A  p '  (#& x 1   8N"p  3" p  h ; & 6  q b y +b y 2>" " p  H ; :  p ' "p( 3 lq 8 & = p >b w8 b w   qK  M 9  M  ' 0  h0    x M@"  1  = 1" p  O ; ;i  ; 07I  q p ?|b w8 b w y( d" p  e ;  ;  q  (+g  q  m"$pzby  1  " + d"p) ;C  :  q 2x  bo  "pj ;2  ;  ;2   w 9 x 2 8    rR 9Bp08 9<"p ;2  ;  ;2  0; 8rY 8r S( 9  q0< r[ rP % bqr0\,)]x  "p ;2  r C  ; a ;2  ;  ;2   )L xs   by +""p$ ;T  : h ;T  p C' 1  3 "p ; a ;C  ;#  ;C  x[Ka =bw8bw p ?8 "}p C'x"p ;C  r S  ;4  TKa9 ("f49>CHPMTTq i}Tq i"p Cib@ P!bx"@ P!"pib00b0@`p  f  % 00 u\l b s$  +F"Gp C'l @a =s 8s  p Nl "p ;C  r S  ;4  @aC ( 0b @ +"""pH ;!  :A  p '  (l 8 )"p b 2!"" p  H ; :  p '"p(q q  qK $  l  @"y 1=1"p O ;  ;X  ; 078  q p Nk 8  h" p   ;  ;  q (   q $l "$pzb +"p) ;C  :  q 2Rl `b  q 9G$  V  % br0\)(l `"p ;2  r B  ;#   ( l b 8(L i~l b$  b r +g""p$ ;C  :s h ;C  p 2'l ZKQ =b 8b  p Nv8 "}p 2'l "p ;2  r B  ;#  SKQ( ("7   vb  "pTq  q  ;,0, 0  P 80 S  % "p ;T  :  wqV 8 qV  Ԕ7& Uq iVq iq i #MMMMAMQ< MaMqNM} M  M M 'Mi"pi#@Mi"p Cib @ 0Qb x@ 0Ab @ 0ab @ 0qb B@ 0!b R@ 0!b b@ 0!b r@ 0!b $@ 0!b % @ 0!b  @ 0!b 9@ 0!b :@ 0!b ~@ 0!b \ @ 0!b a @ 0!b @ 0!b @ 0!b @ 0!b ] @ 0!b ^ @ 0!b = @ 0!b 3 @ 0!b  @ 0!b  @ 0!b! 0bb  0b0b0p     8"p ; 6@  ", 8#"p ; 6@ 1 ; ;P   S(4^@1 "p ; ;p  ;@ @ ;0 Q 6 1 ; ;p  ;@ @ ;0 a 6 1 ; ;p  ;  B"p  ) 8p         q !   q   q  , q   ) 31%!q   23!q  q   (q  (q  ( f\q q  2 8 % t 8t  b0@( 1""p ;T  ;  p C'  % t 8t  b0@'+)DD 2q  "p 5  :8 p Z(  d("Gbp0vp fh  Ε`q q  "p # :96""p+ ;  ;  p v' `""p ;  ;  p v'p Z  d"Gbp0vp fi 2M2. % 0Pb 0qT 8 % b0!Rq 02 % br0\;b $  " p   ; :  ; 6I  q " p   ; ;  q ,-" Gp ' @ 8q0= 8  p b " p   ; :)  q (  r  q q a ( "" p  ;   r   ;  p ' r  q "p j ;  6x  q g  @ xq0 )k "" p  ;  r   ;  p '@ )= " p   ; :)  q )!3 @ ) " p   ; :)  q ) r  p \\ )  A{R >mR   r +; 1( r ! q A(  1( r ! \  8 ( A( !(b@  "p$ ;e P :  ;e P 6  q T ,c"p) ;e P :  q T A  "pu ;e P :  q T8  A  8  9"Ap 8 "q p0eAR08 8 w AR0b A  A  4A2J8  198 b  q q e AR0"p "p ""gPp@R2p T&A39RA  9Fq 9@ % bq #fRM  8 !rR =rX r TM q T RA0rP $  B@"2  A38"pw 0NQ  0 N* w 0NT q 0N @"O1= 8   "pO ;T @ ;  ;T @07  q p b)J)q)m)i)e)a)])Y)U3 )Q)M)I"p A  9 A  9C)@bAR0) 9 "Ap ))"p ;e   ;e  q T)  K  q $Q"$pzarq0  3l.gmb`  +I"p) ; p :  q v"pf ;v  6  m(Abp@X2 w 9 $      % barr0\(Ap0Y(VAbp@X2(fAbp@X2(Abp@X2(&Abp@X2(6Abp@X2(FAbp@X2( d"p ;v  r  ` ;  ;v   d)[ d"p ;v  r  ` ;  ;v   d)* r v q "pz ; p 6  q v d"pd ;v ` 6   d) n"p ;  r  p ;  q v) d db d) d)3 d) d) d"p ;v  r  ` ;  ;v   d)^ d9Wb)S d"p ;v  r  ` ;  ;v   d)"v] ) r v p _ )  v 8 )5$xp5*6f  "p ;v  :  ;v b  6v  q i"p ;v  ;  q i $  b +""p$ ;  : h ;  p v'q g> _KA = 8  p b3 ("p ;  r   ;g  ("p ;  r   ;g  ( r  q"pj ;v  ;V  ( "p ;v  ;V  q i)o"p ;  r   ;g  )P$>$]$]$]$]${";$]$ W qj pRwC4 p kx  9"pr0 r0 "vQ ;  ;  @0 @R0 @0 r0 @0 r0 @0   r0 @0 r0 @0 >>r0 @0 jr0 8 j@0 Wr0 8 W@0 r0 8 @0 r0 8 @b0 r0 8 @r0 : r0 8 : @0 r0 @0  r0 8  @0 r0 8q w @0r0 8 @0 )0M51   /C q A r0NA q rM @rq0TrMd( rM' $"00y" xp0 8?  ws" }p q r q  r0 w 5p@m28  qr 9= 1  / q  r0N w 5p@m2xM"xq )@p0"}p Gq r uPq  Pr0 w 2~""v(;  ;  v' v8   wsw8 O )J )G  wsq08 1 ), )) 8  '  q0xM)O xM'1Rp@m28 v( v(  "v;  ; ;  q08h )c )` 8 ' ) ( )Q ( v(  v( )? )y  )W  )8 ,OK5d( EB= *91 'G U*`'2.A~{~{~~~~~~~~~{~{כ  9 q 0@"Q 08!qp iu 88/0 !p@le(  q04  q04(~&  p k!   !-cV "p CijbV @ 0AbV "@ 0!bV 2@ 0!bV B@ 0!bV R@ 0!"p @ib0Q"p @ib0 P=p EcJjQ  E0X \02! r@B2  dP#"0p 8 B8 @2 ; ; ;!#!qP45M1M#"/M  8 rR 8rP#4(1   @"q ! p ~3 iq h! \022 r> 8  r@< Cr9( ɜpt   b +c""ps ;e  :  p T'8@ = % b0T8@ (8#U M@T (p} (q T p ~I(5>SX > b @ +(""pH ;!  :A  p '  ( (##pt  b  +8 % b  0 8"p   9   0   9   0  W 9  W 0  j 9  j 0   9   0  9   0   9   0  > 9  > 0   9   0   9   0   9  q 0   @"  1  = b q0Y  " p  1 ;  ;  m ; 07Z  q )"p) b   \K    b " p   ; ;;  ;   \K =" " p   ; ;:  ;  q ) " p   ; ;:  ;  q )8  8    p ~)vz "i p g "$pz  b + q   #325q  "#/MM     % r0\* ( ("p ;2  r C  ;   ("p ;2 pw 072   (%Jl  pt   b +""pu ;v  :  p e'8^K = % b0e8q  %#^M M^K (89 8!""pt ;v  : v ;v  p e'#f M VK\ (8  | 8 | p ~Z(5O ddddddd+e ee e(e0eL :+  &"!""""""$$$&)++LIThi"xxy"& +*L+  N WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category = 0W UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category = 0)W UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category = 0) UNION SELECT date,CASE WHEN priority = 0 THEN priority+129 ELSE priority+128 END AS prioritys, thread_id FROM sms WHERE htc_category = 0)` (SELECT date * 1000 AS date, pri AS prioritys, thread_id FROM pdu WHERE htc_category = 0G (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pduM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu AND 4 AND (m_type=132 OR m_type=130 OR m_type=128) AND htc_category = 0) AND htc_category = 0) +  AND sms. ON threads._id = WHERE 7 (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads  WHERE thread_id =  (SELECT prioritys FROM (SELECT snippet FROM (SELECT snippet_cs FROMM (SELECT DISTINCT htcthread_id FROM htcmsgs WHERE htcthread_id IS NOT NULL)  UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, thread_id FROM pdu WHERE htc_category = 0 UNION SELECT date, thread_id FROM sms WHERE htc_category = 0) WHERE thread_id =  UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id =  UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id;  UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id;  UPDATE threads SET priority = (SELECT priority FROM (SELECT date * 1000 AS date, pri AS priority, thread_id FROM pdu WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id;  UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id;  UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id;  UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id;  UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = old.thread_id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = old.thread_id) WHERE threads._id = old.thread_id;  UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; @ WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128  WHERE threads._id = priority = snippet = snippet_cs = != 3 ( ( SELECT pdu._id AS _id, addr.address AS address, pdu.read AS read, pdu.thread_id AS thread_id, pdu.date * 1000 AS date, 0 AS msg_type , pdu.sub AS sub ,pdu.sub_cs as sub_cs, -1 as sms_type, pdu.m_type as mms_type FROM addr, pdu WHERE addr.msg_id = pdu._id AND addr.address <> 'insert_address_token' AND pdu.thread_id IS NOT NULL UNION ALL SELECT sms._id AS _id, sms.address AS address, sms.read AS read, sms.thread_id as thread_id, sms.date AS date, 1 AS msg_type , sms.body as sub , NULL as sub_cs, sms.type as sms_type, -1 as mms_type FROM sms WHERE sms.address <> 'insert_address_token' AND sms.thread_id IS NOT NULL ) (SELECT pdu._id AS _id, addr.address AS address, pdu.read AS read, pdu.thread_id AS thread_id, pdu.date * 1000 AS date, 0 AS msg_type , pdu.sub AS sub ,pdu.sub_cs as sub_cs, -1 as sms_type, pdu.m_type as mms_type, pri AS priority, htcthread_id, NULL AS vvm_id, NULL AS ptime, NULL AS is_private, NULL AS is_urgent, NULL AS vvm_type, 'mms' AS transport_type FROM addr, pdu LEFT JOIN (SELECT _id AS htcthread_id, thread_id AS threads_id FROM htcthreads) ON threads_id = pdu.thread_id WHERE addr.msg_id = pdu._id AND addr.address <> 'insert_address_token' AND pdu.thread_id IS NOT NULL UNION ALL SELECT sms._id AS _id, sms.address AS address, sms.read AS read, sms.thread_id as thread_id, sms.date AS date, 1 AS msg_type , sms.body as sub , NULL as sub_cs, sms.type as sms_type, -1 as mms_type, priority, htcthread_id, NULL AS vvm_id, NULL AS ptime, NULL AS is_private, NULL AS is_urgent, NULL AS vvm_type, 'sms' AS transport_type FROM sms LEFT JOIN (SELECT _id AS htcthread_id, thread_id AS threads_id FROM htcthreads) ON threads_id = sms.thread_id WHERE sms.address <> 'insert_address_token' AND sms.thread_id IS NOT NULL UNION ALL SELECT htcmsgs._id AS _id, address, read, thread_id, date, -1 AS msg_type, NULL AS sub, NULL AS sub_cs, -1 AS sms_type, -1 AS mms_type, NULL AS priority, htcthread_id, vvm_id, ptime, htcmsgs.is_private AS is_private, htcmsgs.is_urgent AS is_urgent, type AS vvm_type, 'vvm' AS transport_type FROM htcmsgs LEFT JOIN (SELECT _id AS htcthreads_id, thread_id FROM htcthreads) ON htcthreads_id = htcmsgs.htcthread_id WHERE htcmsgs.htcthread_id IS NOT NULL )  (ct = ? OR ct = ?) + 0=0  =  >>> AND  AND ( AND (_id IN ( AND addr.type = 151 AND msg_box= AND msg_id= AS normalized_date FROM  INTEGER DEFAULT 0  INTEGER DEFAULT 0,  INTEGER DEFAULT 1,  INTEGER PRIMARY KEY, LIMIT %s LIMIT 1 OR OR (type=& OR PHONE_NUMBERS_EQUAL(addr.address, ! OR PHONE_NUMBERS_EQUAL(address, ORDER BY  ORDER BY date DESC LIMIT 1) ORDER BY date DESC LIMIT 1), TEXT DEFAULT '',  UNION  UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = old.recipient_ids)) WHERE recipient_ids = old.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = old.recipient_ids; DELETE FROM htcthreads WHERE latest_date IS NULL;  UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1); UPDATE htcthreads SET snippet = (SELECT snippet FROM (SELECT date, snippet FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date, NULL AS snippet FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1); UPDATE htcthreads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date, snippet_cs FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date, NULL AS snippet_cs FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1); UPDATE htcthreads SET priority = (SELECT priority FROM (SELECT date, priority FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date, NULL AS priority FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1);  UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = old.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; DELETE FROM htcthreads WHERE latest_date IS NULL;  UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET snippet = (SELECT snippet FROM (SELECT date, snippet FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS snippet FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date, snippet_cs FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS snippet_cs FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET priority = (SELECT priority FROM (SELECT date, priority FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS priority FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, NULL AS msg_type FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, NULL AS ptime FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, ptime FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, NULL AS is_private FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, is_private FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, NULL AS is_urgent FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids;  UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id;  UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id;  UPDATE htcthreads SET p_message_count = ((SELECT message_count FROM threads WHERE recipient_ids= new.recipient_ids) + (SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads where recipient_ids = new.recipient_ids))) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET p_unread_count = ((SELECT unread_count FROM threads WHERE recipient_ids= new.recipient_ids) + (SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids))) WHERE recipient_ids = new.recipient_ids;  UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id;  UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = old.htcthread_id) WHERE _id = old.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = old.htcthread_id) WHERE _id = old.htcthread_id;  UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = new.htcthread_id;  UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = old.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = old.htcthread_id;  UPDATE htcthreads SET p_read = CASE ( ((CASE (SELECT read FROM threads WHERE recipient_ids = new.recipient_ids) WHEN 0 THEN 1 ELSE 0 END) + (SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)))) WHEN 0 THEN 1 ELSE 0 END WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET p_unread_count = (SELECT unread_count FROM threads WHERE recipient_ids = new.recipient_ids) + (SELECT p_unread_count FROM htcthreads WHERE recipient_ids = new.recipient_ids) WHERE recipient_ids = new.recipient_ids; M UPDATE htcthreads SET thread_id = 0 WHERE recipient_ids = old.recipient_ids;S UPDATE htcthreads SET thread_id = new._id WHERE recipient_ids = new.recipient_ids;9 UPDATE pdu SET cs_synced = '0' WHERE pdu._id = old._id; 9 UPDATE sms SET cs_synced = '0' WHERE sms._id = old._id;  WHERE  WHERE ( WHERE _id =  _id IN  and and locale=' by date DESC failed for recipientIds  htc_category= htc_category= 0 not supported one record:( openFileInput FileNotFoundException e > openFileInput IOException e >" openFileInput other Exception e > rowID = ! rows in pdu table to have READ=1! rows in sms table to have READ=1 table, th backup key record failed$ th integer data failed from cursor " th key backup table record failed to  type=  with a where clause& with no data case failed write record##/addr#/part$VALUES%%'%' or body like '%%' or name like '%%Y-%m-%d/%H:%M:%S#%s UNION %s GROUP BY %s ORDER BY %s'' as suggest_intent_data' not implemented.' to be the current operator' to the current operator((' ((type=4 AND ()V([(_id = (address=.(m_type = 128 OR m_type = 132 OR m_type = 130)A(msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))(msg_box = 4 AND m_type = 128)(msg_box=4 AND m_type=128) (sms_id = (type != 3 AND type > 0) (type != 3)"(type = 4 OR type = 5 OR type = 6)(type = 4 OR type = 5)(type IN (4, 5, 6)))) AND )))) );** FROM */* *@DELIVERY *@PRIVATE *@UNKNOWN,, , ', 0)), 0))) , 1)), 1))) , _id= , address: , match=.//PART_/addr//drm//mms/part//sms/system/etc/customer01;<=>;>;)>;)V>;)[>;)[J>;Z)?@ACTION_LOG_EVENTALL_MESSAGES_COLUMNS1ALTER TABLE part ADD COLUMN seq INTEGER DEFAULT 0%ALTER TABLE part ADD COLUMN text TEXT&ALTER TABLE pdu ADD COLUMN cs_id TEXT;7ALTER TABLE pdu ADD COLUMN cs_synced INTEGER DEFAULT 0;8ALTER TABLE pdu ADD COLUMN cs_timestamp LONG DEFAULT -1;:ALTER TABLE pdu ADD COLUMN htc_category INTEGER DEFAULT 0;3ALTER TABLE pdu ADD COLUMN locked INTEGER DEFAULT 01ALTER TABLE pdu add COLUMN seen INTEGER DEFAULT 00ALTER TABLE sms ADD COLUMN callback_number TEXT;&ALTER TABLE sms ADD COLUMN cs_id TEXT;7ALTER TABLE sms ADD COLUMN cs_synced INTEGER DEFAULT 0;8ALTER TABLE sms ADD COLUMN cs_timestamp LONG DEFAULT -1;7ALTER TABLE sms ADD COLUMN error_code INTEGER DEFAULT 0:ALTER TABLE sms ADD COLUMN htc_category INTEGER DEFAULT 0;0ALTER TABLE sms ADD COLUMN index_on_sim INTEGER;3ALTER TABLE sms ADD COLUMN locked INTEGER DEFAULT 0,ALTER TABLE sms ADD COLUMN priority INTEGER;1ALTER TABLE sms add COLUMN seen INTEGER DEFAULT 0%ALTER TABLE temp_part RENAME TO part;#ALTER TABLE temp_pdu RENAME TO pdu;#ALTER TABLE temp_sms RENAME TO sms;+ALTER TABLE temp_threads RENAME TO threads;7ALTER TABLE threads ADD COLUMN error INTEGER DEFAULT 0;?ALTER TABLE threads ADD COLUMN has_attachment INTEGER DEFAULT 0EALTER TABLE threads ADD COLUMN snippet_cs INTEGER NOT NULL DEFAULT 0;?ALTER TABLE threads ADD COLUMN type INTEGER NOT NULL DEFAULT 0;AND thread_id <= 0APN_CUSTOMIZE_FILENAMEAPN_CUSTOMIZE_PATHAPP_NAMEARCHIVE_SPERATORAS matching_addresses AUTHORITYAddressAllMessagesProviderAllMessagesProvider SetBackUpOAllMessagesProvider does not support deletes, inserts, or updates for this URI.AllMessagesProvider.javaArrayListCursor.java BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = new.htcthread_id; END; BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs, priority = new.pri WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END; BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs, priority = new.pri WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; END;BEGIN UPDATE threads SET date = new.date, snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id AND new.htc_category = 0; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; END;BEGIN UPDATE threads SET date = new.date, snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END;BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; END;"BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET snippet = (SELECT snippet FROM (SELECT date, snippet FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS snippet FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date, snippet_cs FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS snippet_cs FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET priority = (SELECT priority FROM (SELECT date, priority FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, NULL AS priority FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, NULL AS msg_type FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, NULL AS ptime FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, ptime FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, NULL AS is_private FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, is_private FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, NULL AS is_urgent FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET thread_id = new._id WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET p_message_count = ((SELECT message_count FROM threads WHERE recipient_ids= new.recipient_ids) + (SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads where recipient_ids = new.recipient_ids))) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET p_unread_count = ((SELECT unread_count FROM threads WHERE recipient_ids= new.recipient_ids) + (SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids))) WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET p_read = CASE ( ((CASE (SELECT read FROM threads WHERE recipient_ids = new.recipient_ids) WHEN 0 THEN 1 ELSE 0 END) + (SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)))) WHEN 0 THEN 1 ELSE 0 END WHERE recipient_ids = new.recipient_ids;END;BEGIN UPDATE htcthreads SET thread_id = new._id WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; END; Backup Table Bad SMS SIM ID: Bad conversation htc thread id: Bad conversation htc_thread id: Bad conversation thread id: Bad htc message id: Bad htcmsg id: Bad message id: Broadcasting intent: CC2DMCANCEL_DURING_ERRORCANCEL_DURING_LISTENINGCANCEL_DURING_WORKINGCANONICAL_ADDRESSES_COLUMNS_1CANONICAL_ADDRESSES_COLUMNS_2CARRIERS_TABLECATEGORY_GENERALCATEGORY_SECURE CBProviderCBProvider.javaCHANNELCI COLUMN_APN_IDCOLUMN_INSERT_BY_EXTERNELCOLUMN_INSERT_BY_INTERNELCOMMON_COLUMNS CONNECTEDCONTENTCONTENT_FILTER_URL CONTENT_URIFCREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms (type, thread_id); CREATE TABLE ECREATE TABLE IF NOT EXISTS drm (_id INTEGER PRIMARY KEY, _data TEXT);4CREATE TABLE IF NOT EXISTS rate (sent_time INTEGER);xCREATE TABLE addr (_id INTEGER PRIMARY KEY,msg_id INTEGER,contact_id INTEGER,address TEXT,type INTEGER,charset INTEGER);JCREATE TABLE attachments (sms_id INTEGER,content_url TEXT,offset INTEGER);HCREATE TABLE canonical_addresses (_id INTEGER PRIMARY KEY,address TEXT);CREATE TABLE carriers(_id INTEGER PRIMARY KEY,name TEXT,numeric TEXT,mcc TEXT,mnc TEXT,apn TEXT,user TEXT,server TEXT,password TEXT,proxy TEXT,port TEXT,mmsproxy TEXT,mmsport TEXT,mmsprotocol TEXT,mmsc TEXT,authtype INTEGER,type TEXT,insert_by TEXT,operator TEXT,state TEXT,current INTEGER);oCREATE TABLE cbch (_id INTEGER PRIMARY KEY,title TEXT NOT NULL,channel TEXT NOT NULL,enable INTEGER DEFAULT 0);6CREATE TABLE drm (_id INTEGER PRIMARY KEY,_data TEXT);CREATE TABLE htcmsgs (_id INTEGER PRIMARY KEY, htcthread_id INTEGER DEFAULT 0, msg_type TEXT DEFAULT '', vvm_id TEXT DEFAULT '', date INTEGER DEFAULT 0, ptime INTEGER DEFAULT 0, is_private INTEGER DEFAULT 0, is_urgent INTEGER DEFAULT 0, type INTEGER DEFAULT 0, address TEXT DEFAULT '', read INTEGER DEFAULT 0);CREATE TABLE part (_id INTEGER PRIMARY KEY,mid INTEGER,seq INTEGER DEFAULT 0,ct TEXT,name TEXT,chset INTEGER,cd TEXT,fn TEXT,cid TEXT,cl TEXT,ctt_s INTEGER,ctt_t TEXT,ExtraUri TEXT,vCALs INTEGER,vCALe INTEGER,_data TEXT,text TEXT);CREATE TABLE pdu (_id INTEGER PRIMARY KEY,thread_id INTEGER,date INTEGER,msg_box INTEGER,read INTEGER DEFAULT 0,m_id TEXT,sub TEXT,sub_cs INTEGER,ct_t TEXT,ct_l TEXT,exp INTEGER,m_cls TEXT,m_type INTEGER,v INTEGER,m_size INTEGER,pri INTEGER,rr INTEGER,rpt_a INTEGER,resp_st INTEGER,st INTEGER,tr_id TEXT,retr_st INTEGER,retr_txt TEXT,retr_txt_cs INTEGER,read_status INTEGER,ct_cls INTEGER,resp_txt TEXT,d_tm INTEGER,d_rpt INTEGER,locked INTEGER DEFAULT 0,htc_category INTEGER DEFAULT 0,cs_timestamp LONG DEFAULT -1, cs_id TEXT, cs_synced INTEGER DEFAULT 0, seen INTEGER DEFAULT 0);CREATE TABLE pending_msgs (_id INTEGER PRIMARY KEY,proto_type INTEGER,msg_id INTEGER,msg_type INTEGER,err_type INTEGER,err_code INTEGER,retry_index INTEGER NOT NULL DEFAULT 0,due_time INTEGER,last_try INTEGER);PCREATE TABLE qtext (_id INTEGER PRIMARY KEY,content TEXT NOT NULL, locale TEXT);&CREATE TABLE rate (sent_time INTEGER);CREATE TABLE raw (_id INTEGER PRIMARY KEY,date INTEGER,reference_number INTEGER,count INTEGER,sequence INTEGER,destination_port INTEGER,address TEXT,pdu TEXT);CREATE TABLE sms (_id INTEGER PRIMARY KEY,thread_id INTEGER,toa INTEGER DEFAULT 0,address TEXT,person INTEGER,date INTEGER,protocol INTEGER,read INTEGER DEFAULT 0,status INTEGER DEFAULT -1,type INTEGER,reply_path_present INTEGER,subject TEXT,body TEXT,sc_toa INTEGER DEFAULT 0,report_date INTEGER,service_center TEXT,locked INTEGER DEFAULT 0,index_on_sim INTEGER DEFAULT -1,callback_number TEXT,priority INTEGER DEFAULT 0,htc_category INTEGER DEFAULT 0,cs_timestamp LONG DEFAULT -1, cs_id TEXT, cs_synced INTEGER DEFAULT 0, error_code INTEGER DEFAULT 0,seen INTEGER DEFAULT 0);ICREATE TABLE sr_pending (reference_number INTEGER,action TEXT,data TEXT);CREATE TABLE temp_part (_id INTEGER PRIMARY KEY,mid INTEGER,seq INTEGER DEFAULT 0,ct TEXT,name TEXT,chset INTEGER,cd TEXT,fn TEXT,cid TEXT,cl TEXT,ctt_s INTEGER,ctt_t TEXT,_data TEXT);CREATE TABLE temp_pdu (_id INTEGER PRIMARY KEY,thread_id INTEGER,date INTEGER,msg_box INTEGER,read INTEGER DEFAULT 0,m_id TEXT,sub TEXT,sub_cs INTEGER,ct_t TEXT,ct_l TEXT,exp INTEGER,m_cls TEXT,m_type INTEGER,v INTEGER,m_size INTEGER,pri INTEGER,rr INTEGER,rpt_a INTEGER,resp_st INTEGER,st INTEGER,tr_id TEXT,retr_st INTEGER,retr_txt TEXT,retr_txt_cs INTEGER,read_status INTEGER,ct_cls INTEGER,resp_txt TEXT,d_tm INTEGER,d_rpt INTEGER,locked INTEGER DEFAULT 0,htc_category INTEGER DEFAULT 0,cs_timestamp LONG DEFAULT -1, cs_id TEXT, cs_synced INTEGER DEFAULT 0 );CREATE TABLE temp_sms (_id INTEGER PRIMARY KEY,thread_id INTEGER,toa INTEGER DEFAULT 0,address TEXT,person INTEGER,date INTEGER,protocol INTEGER,read INTEGER DEFAULT 0,status INTEGER DEFAULT -1,type INTEGER,reply_path_present INTEGER,subject TEXT,body TEXT,sc_toa INTEGER DEFAULT 0,report_date INTEGER,service_center TEXT,locked INTEGER DEFAULT 0,index_on_sim INTEGER DEFAULT -1,callback_number TEXT,priority INTEGER DEFAULT 0,htc_category INTEGER DEFAULT 0,cs_timestamp LONG DEFAULT -1, cs_id TEXT, cs_synced INTEGER DEFAULT 0 );CREATE TABLE temp_threads (_id INTEGER PRIMARY KEY,date INTEGER DEFAULT 0,message_count INTEGER DEFAULT 0,recipient_ids TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,type INTEGER DEFAULT 0,error INTEGER DEFAULT 0);CREATE TABLE temp_threads (_id INTEGER PRIMARY KEY,date INTEGER DEFAULT 0,subject TEXT,recipient_ids TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,type INTEGER DEFAULT 0,error INTEGER DEFAULT 0);CREATE TABLE threads (_id INTEGER PRIMARY KEY,date INTEGER DEFAULT 0,message_count INTEGER DEFAULT 0,recipient_ids TEXT,recipient_address TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,unread_count INTEGER DEFAULT 0,body TEXT,name TEXT,priority INTEGER DEFAULT 0,type INTEGER DEFAULT 0,error INTEGER DEFAULT 0,has_attachment INTEGER DEFAULT 0);fCREATE TRIGGER IF NOT EXISTS drm_file_cleanup DELETE ON drm BEGIN SELECT _DELETE_FILE(old._data); END;]CREATE TRIGGER addr_cleanup DELETE ON pdu BEGIN DELETE FROM addr WHERE msg_id=old._id;END;CREATE TRIGGER cleanup_delivery_and_read_report AFTER DELETE ON pdu WHEN old.m_type=128 BEGIN DELETE FROM pdu WHERE (m_type=134 OR m_type=136) AND m_id=old.m_id; END;|CREATE TRIGGER delete_mms_pending_on_delete AFTER DELETE ON pdu BEGIN DELETE FROM pending_msgs WHERE msg_id=old._id; END;CREATE TRIGGER delete_mms_pending_on_update AFTER UPDATE ON pdu WHEN old.msg_box=4 AND new.msg_box!=4 BEGIN DELETE FROM pending_msgs WHERE msg_id=new._id; END;CREATE TRIGGER delete_obsolete_threads_pdu AFTER DELETE ON pdu BEGIN DELETE FROM threads WHERE _id = old.thread_id AND _id NOT IN (SELECT thread_id FROM sms UNION SELECT thread_id from pdu); END;CREATE TRIGGER delete_obsolete_threads_sms AFTER DELETE ON sms BEGIN DELETE FROM threads WHERE _id = old.thread_id AND _id NOT IN (SELECT thread_id FROM sms UNION SELECT thread_id from pdu); END;CREATE TRIGGER delete_obsolete_threads_when_update_pdu AFTER UPDATE OF thread_id ON pdu WHEN old.thread_id != new.thread_id BEGIN DELETE FROM threads WHERE _id = old.thread_id AND _id NOT IN (SELECT thread_id FROM sms UNION SELECT thread_id from pdu); END; CREATE TRIGGER htcmsg_update_htcthread_on_delete AFTER DELETE ON htcmsgs BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = old.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; DELETE FROM htcthreads WHERE latest_date IS NULL; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = old.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = old.htcthread_id; UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = old.htcthread_id) WHERE _id = old.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = old.htcthread_id) WHERE _id = old.htcthread_id; UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = old.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = old.htcthread_id; END; CREATE TRIGGER htcmsg_update_htcthread_on_insert AFTER INSERT ON htcmsgs BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = new.htcthread_id; END; CREATE TRIGGER htcmsg_update_htcthread_on_update AFTER UPDATE ON htcmsgs BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE _id = (SELECT thread_id FROM htcthreads WHERE _id = new.htcthread_id) UNION SELECT date FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET msg_type = (SELECT msg_type FROM (SELECT date, msg_type FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET vvm_ptime = (SELECT ptime FROM (SELECT date, ptime FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_private = (SELECT is_private FROM (SELECT date, is_private FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET is_urgent = (SELECT is_urgent FROM (SELECT date, is_urgent FROM htcmsgs WHERE htcthread_id = new.htcthread_id) ORDER BY date DESC LIMIT 1) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_message_count = ( SELECT COUNT(_id) FROM htcmsgs WHERE htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_unread_count = ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHERE _id = new.htcthread_id; UPDATE htcthreads SET p_read = CASE ( SELECT COUNT(*) FROM htcmsgs WHERE read = 0 AND htcthread_id = new.htcthread_id) WHEN 0 THEN 1 ELSE 0 END WHERE _id = new.htcthread_id; END; CREATE TRIGGER insert_mms_pending_on_insert AFTER INSERT ON pdu WHEN new.m_type=130 OR new.m_type=135 BEGIN INSERT INTO pending_msgs (proto_type, msg_id, msg_type, err_type, err_code, retry_index, due_time) VALUES (1, new._id, new.m_type,0,0,0,0);END;CREATE TRIGGER insert_mms_pending_on_update AFTER UPDATE ON pdu WHEN new.m_type=128 AND new.msg_box=4 AND old.msg_box!=4 BEGIN INSERT INTO pending_msgs (proto_type, msg_id, msg_type, err_type, err_code, retry_index, due_time) VALUES (1, new._id, new.m_type,0,0,0,0);END;CREATE TRIGGER mms_words_delete AFTER DELETE ON part BEGIN DELETE FROM words WHERE source_id = OLD._id AND table_to_use = 2; END;CREATE TRIGGER mms_words_update AFTER UPDATE ON part BEGIN UPDATE words SET index_text = NEW.text WHERE (source_id=NEW._id AND table_to_use=2); END;ZCREATE TRIGGER part_cleanup DELETE ON pdu BEGIN DELETE FROM part WHERE mid=old._id;END;CREATE TRIGGER pdu_update_thread_date_subject_on_update AFTER UPDATE OF date, sub, msg_box ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs, priority = new.pri WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END; CREATE TRIGGER pdu_update_thread_date_subject_on_update AFTER UPDATE OF date, sub, msg_box ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_date_subject_on_update AFTER UPDATE OF date, sub, msg_box ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_date_subject_on_update AFTER UPDATE OF date, sub, msg_box ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_date_subject_on_update AFTER UPDATE OF date, sub, msg_box ON pdu WHEN new.msg_box!=5 AND new.msg_box!=3 AND (new.m_type=132 OR new.m_type=130 OR new.m_type=128) BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END; CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 UNION SELECT date, body AS snippet, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; END;CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; END; CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; END; CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu UNION SELECT date, body AS snippet, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; END;CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = old.thread_id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = old.thread_id) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET priority = (SELECT priority FROM (SELECT date * 1000 AS date, pri AS priority, thread_id FROM pdu WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; END;CREATE TRIGGER pdu_update_thread_on_insert AFTER INSERT ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs, priority = new.pri WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END; CREATE TRIGGER pdu_update_thread_on_insert AFTER INSERT ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_on_insert AFTER INSERT ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_on_insert AFTER INSERT ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_on_insert AFTER INSERT ON pdu WHEN new.msg_box!=5 AND new.msg_box!=3 AND (new.m_type=132 OR new.m_type=130 OR new.m_type=128) BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.sub, snippet_cs = new.sub_cs WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_read_on_update AFTER UPDATE OF read ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_read_on_update AFTER UPDATE OF read ON pdu WHEN new.msg_box!=5 AND new.msg_box!=3 AND (new.m_type=132 OR new.m_type=130 OR new.m_type=128) BEGIN UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER pdu_update_thread_read_on_update AFTER UPDATE OF read, htc_category ON pdu WHEN new.m_type=132 OR new.m_type=130 OR new.m_type=128 BEGIN UPDATE threads SET read = CASE (SELECT COUNT(*) FROM pdu WHERE read = 0 AND thread_id = threads._id AND (m_type=132 OR m_type=130 OR m_type=128)) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_date_subject_on_update AFTER UPDATE OF date, body, msg_box ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END; CREATE TRIGGER sms_update_thread_date_subject_on_update AFTER UPDATE OF date, body, type ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_date_subject_on_update AFTER UPDATE OF date, body, type ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_date_subject_on_update AFTER UPDATE OF date, body, type ON sms BEGIN UPDATE threads SET date = new.date, snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; END; CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub AS snippet, sub_cs AS snippet_cs FROM pdu UNION SELECT date, body AS snippet, NULL AS snippet_cs FROM sms) ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; END; CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000) WHERE threads._id = old.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu UNION SELECT date, body AS snippet, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; END;CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = (SELECT body FROM SMS ORDER BY date DESC LIMIT 1) WHERE threads._id = old.thread_id; END;CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = old.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = old.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = old.thread_id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = old.thread_id) WHERE threads._id = old.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; UPDATE threads SET priority = (SELECT priority FROM (SELECT date * 1000 AS date, pri AS priority, thread_id FROM pdu WHERE (m_type=132 OR m_type=130 OR m_type=128) AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = OLD.thread_id; END;CREATE TRIGGER sms_update_thread_on_insert AFTER INSERT ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_on_insert AFTER INSERT ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_on_insert AFTER INSERT ON sms BEGIN UPDATE threads SET date = (strftime('%s','now') * 1000), snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_on_insert AFTER INSERT ON sms BEGIN UPDATE threads SET date = new.date, snippet = new.body, snippet_cs = 0 WHERE threads._id = new.thread_id; UPDATE threads SET message_count = (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND sms.type != 3 AND htc_category = 0) + (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is NULL) + (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads ON threads._id = thread_id WHERE thread_id = new.thread_id AND htc_category = 0 AND (m_type=132 OR m_type=130 OR m_type=128) AND msg_box != 3 AND pdu.m_id is not NULL) WHERE threads._id = new.thread_id; UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; UPDATE threads SET snippet = (SELECT snippet FROM (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, body AS snippet, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET snippet_cs = (SELECT snippet_cs FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; UPDATE threads SET date = (SELECT date FROM (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu WHERE m_type=132 OR m_type=130 OR m_type=128 AND htc_category=0 UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms WHERE htc_category=0) WHERE thread_id = new.thread_id ORDER BY date DESC LIMIT 1) WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_update_thread_read_on_update AFTER UPDATE OF read, htc_category ON sms BEGIN UPDATE threads SET read = CASE (SELECT COUNT(*) FROM sms WHERE read = 0 AND thread_id = threads._id AND htc_category = 0) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND htc_category = 0 AND (m_type=132 OR m_type=130) AND thread_id = threads._id) WHEN 0 THEN 1 ELSE 0 END WHERE threads._id = new.thread_id; UPDATE threads SET unread_count = (SELECT COUNT(*) FROM sms WHERE read = 0 AND type = 1 AND htc_category = 0 AND thread_id = threads._id) + (SELECT COUNT(*) FROM pdu WHERE read = 0 AND (m_type = 130 OR m_type = 132) AND msg_box = 1 AND htc_category = 0 AND thread_id = threads._id) WHERE threads._id = new.thread_id; END;CREATE TRIGGER sms_words_delete AFTER DELETE ON sms BEGIN DELETE FROM words WHERE source_id = OLD._id AND table_to_use = 1; END;CREATE TRIGGER sms_words_update AFTER UPDATE ON sms BEGIN UPDATE words SET index_text = NEW.body WHERE (source_id=NEW._id AND table_to_use=1); END;CREATE TRIGGER thread_update_htcthread_on_delete AFTER DELETE ON threads BEGIN UPDATE htcthreads SET thread_id = 0 WHERE recipient_ids = old.recipient_ids; UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = old.recipient_ids)) WHERE recipient_ids = old.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = old.recipient_ids; DELETE FROM htcthreads WHERE latest_date IS NULL; END;CREATE TRIGGER thread_update_htcthread_on_insert AFTER INSERT ON threads BEGIN UPDATE htcthreads SET thread_id = new._id WHERE recipient_ids = new.recipient_ids; UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; END;CREATE TRIGGER thread_update_htcthread_on_update AFTER UPDATE ON threads BEGIN UPDATE htcthreads SET latest_date = ( SELECT date FROM ( SELECT date FROM threads WHERE recipient_ids = new.recipient_ids UNION SELECT date FROM htcmsgs WHERE htcthread_id = (SELECT _id FROM htcthreads WHERE recipient_ids = new.recipient_ids)) WHERE recipient_ids = new.recipient_ids ORDER BY date DESC LIMIT 1) WHERE recipient_ids = new.recipient_ids; END;CREATE TRIGGER update_pdu_synced_flag AFTER UPDATE OF read, locked ON pdu BEGIN UPDATE pdu SET cs_synced = '0' WHERE pdu._id = old._id; END;CREATE TRIGGER update_sms_synced_flag AFTER UPDATE OF read, locked ON sms BEGIN UPDATE sms SET cs_synced = '0' WHERE sms._id = old._id; END;CREATE TRIGGER update_threads_error_on_delete AFTER DELETE ON pending_msgs BEGIN UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms._id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); END;CREATE TRIGGER update_threads_error_on_delete AFTER DELETE ON pending_msgs BEGIN UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu.thread_id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms.thread_id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); END;CREATE TRIGGER update_threads_error_on_delete_mms BEFORE DELETE ON pdu WHEN OLD._id IN (SELECT DISTINCT msg_id FROM pending_msgs WHERE err_type >= 10) BEGIN UPDATE threads SET error = error - 1 WHERE _id = OLD.thread_id; END;CREATE TRIGGER update_threads_error_on_delete_sms AFTER DELETE ON sms WHEN (OLD.type = 5) BEGIN UPDATE threads SET error = error - 1 WHERE _id = OLD.thread_id; END;CREATE TRIGGER update_threads_error_on_move_mms BEFORE UPDATE OF msg_box ON pdu WHEN (OLD.msg_box = 4 AND NEW.msg_box != 4) AND (OLD._id IN (SELECT DISTINCT msg_id FROM pending_msgs WHERE err_type >= 10)) BEGIN UPDATE threads SET error = error - 1 WHERE _id = OLD.thread_id; END;CREATE TRIGGER update_threads_error_on_update AFTER UPDATE OF err_type ON pending_msgs BEGIN UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms._id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); END;CREATE TRIGGER update_threads_error_on_update AFTER UPDATE OF err_type ON pending_msgs BEGIN UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu.thread_id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms.thread_id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); END;CREATE TRIGGER update_threads_error_on_update_mms AFTER UPDATE OF err_type ON pending_msgs WHEN (OLD.err_type < 10 AND NEW.err_type >= 10) OR (OLD.err_type >= 10 AND NEW.err_type < 10) BEGIN UPDATE threads SET error = CASE WHEN NEW.err_type >= 10 THEN error + 1 ELSE error - 1 END WHERE _id = (SELECT DISTINCT thread_id FROM pdu WHERE _id = NEW.msg_id); END;CREATE TRIGGER update_threads_error_on_update_sms AFTER UPDATE OF type ON sms WHEN (OLD.type != 5 AND NEW.type = 5) OR (OLD.type = 5 AND NEW.type != 5) BEGIN UPDATE threads SET error = CASE WHEN NEW.type = 5 THEN error + 1 ELSE error - 1 END WHERE _id = NEW.thread_id; END; CREATE VIEW IF NOT EXISTS threads_list AS SELECT _id, T.norm_date AS date, message_count, recipient_ids, recipient_address, T.snippet AS snippet, T.snippet_cs AS snippet_cs, CASE T.htc_category WHEN 0 THEN read ELSE 1 END AS read, unread_count, body, name, priority, type, error, has_attachment, T.transport_type AS transport_type, T.msg_box AS msg_box, T.locked AS locked, T.htc_category AS htc_category FROM threads LEFT JOIN (SELECT norm_date, snippet, snippet_cs, thread_id, transport_type, msg_box, locked, htc_category FROM (SELECT date * 1000 AS norm_date, sub AS snippet, sub_cs AS snippet_cs, thread_id, 'mms' AS transport_type, msg_box, locked, htc_category FROM pdu WHERE msg_box > 0 UNION SELECT date AS norm_date, body AS snippet, 0 AS snippet_cs, thread_id, 'sms' AS transport_type, type AS msg_box, locked, htc_category FROM sms WHERE type > 0) GROUP BY thread_id, htc_category) T ON threads._id = T.thread_idCREATE VIEW incoming_msg AS SELECT transport_type, _id, thread_id, address, body, normalized_date, sub, sub_cs, read, m_type, priority FROM (SELECT DISTINCT 'sms' AS transport_type, _id, thread_id, address, body, date AS normalized_date, NULL as sub, NULL as sub_cs, read, NULL AS m_type, priority FROM sms WHERE (type = 1 AND htc_category = 0) UNION SELECT DISTINCT 'mms' AS transport_type, _id, thread_id, (SELECT address from addr WHERE addr.msg_id = pdu._id) as address, NULL AS body, date * 1000 AS normalized_date, sub, sub_cs, read, m_type, pri AS priority FROM pdu WHERE ((m_type = 130 OR m_type = 132) AND htc_category = 0 AND msg_box > 0) ORDER BY normalized_date ASC) CREATE VIEW incoming_msg_v2 AS SELECT transport_type, _id, thread_id, address, body, normalized_date, sub, sub_cs, read, m_type, priority, htcthread_id, vvm_id, ptime, is_private, is_urgent, vvm_type FROM (SELECT DISTINCT 'sms' AS transport_type, sms._id AS _id, sms.thread_id AS thread_id, address, body, date AS normalized_date, NULL AS sub, NULL as sub_cs, read, NULL AS m_type, priority, htcthread_id, NULL AS vvm_id, NULL AS ptime, NULL AS is_private, NULL AS is_urgent, NULL AS vvm_type FROM sms LEFT JOIN (SELECT _id AS htcthread_id, thread_id AS threads_id FROM htcthreads) ON threads_id = sms.thread_id WHERE sms.type = 1 UNION SELECT DISTINCT 'mms' AS transport_type, pdu._id AS _id, pdu.thread_id AS thread_id, (SELECT address from addr WHERE addr.msg_id = pdu._id) as address, NULL AS body, date * 1000 AS normalized_date, sub, sub_cs, read, m_type, pri AS priority, htcthread_id, NULL AS vvm_id, NULL AS ptime, NULL AS is_private, NULL AS is_urgent, NULL AS vvm_type FROM pdu LEFT JOIN (SELECT _id AS htcthread_id, thread_id AS threads_id FROM htcthreads) ON threads_id = pdu.thread_id WHERE m_type = 130 OR m_type = 132 UNION SELECT DISTINCT htcmsgs.msg_type AS transport_type, htcmsgs._id AS _id, thread_id, address, NULL AS body, date AS normalized_date, NULL AS sub, NULL AS sub_cs, read, NULL AS m_type, NULL AS priority, htcthread_id, vvm_id, ptime, htcmsgs.is_private AS is_private, htcmsgs.is_urgent AS is_urgent, type AS vvm_type FROM htcmsgs LEFT JOIN (SELECT _id AS htcthreads_id, thread_id FROM htcthreads) ON htcthreads_id = htcmsgs.htcthread_id ORDER BY normalized_date ASC)zCREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, source_id INTEGER, table_to_use INTEGER);!Can't get version of APN databaseCannot delete that URL: Cannot update URL Cannot update that URL: ConnectivityBroadcastReceiverContentBaseBkUpUtil_#ContentBaseBkUpUtil_Backup table : ContentBaseBkUpUtil_get #ContentBaseBkUpUtil_get preRestore @ContentBaseBkUpUtil_stop restore for the backUp data is invalid.ContentBaseDbBackupAgent.java)Couldn't compress the archive file list: Couldn't compress the table: 2Couldn't read and uncompress archive entity data: *Couldn't read and uncompress entity data: %Couldn't read from the cursor from : #Couldn't write archive data record D DATABASE_NAMEDATABASE_VERSIONDATEDBGDEBUGDEFAULT_SORT_ORDERDIDROP TABLE IF EXISTS addr; DROP TABLE IF EXISTS attachments(DROP TABLE IF EXISTS canonical_addressesDROP TABLE IF EXISTS carriers;DROP TABLE IF EXISTS cbchDROP TABLE IF EXISTS drm;DROP TABLE IF EXISTS htcmsgsDROP TABLE IF EXISTS htcthreads$DROP TABLE IF EXISTS newSmsIndicatorDROP TABLE IF EXISTS part;DROP TABLE IF EXISTS pdu;!DROP TABLE IF EXISTS pending_msgsDROP TABLE IF EXISTS qtextDROP TABLE IF EXISTS rate;DROP TABLE IF EXISTS rawDROP TABLE IF EXISTS smsDROP TABLE IF EXISTS sms;DROP TABLE IF EXISTS sr_pendingDROP TABLE IF EXISTS thread_idsDROP TABLE IF EXISTS threadsDROP TABLE IF EXISTS threads;$DROP TRIGGER IF EXISTS addr_cleanup;8DROP TRIGGER IF EXISTS cleanup_delivery_and_read_report;3DROP TRIGGER IF EXISTS delete_mms_pending_on_delete3DROP TRIGGER IF EXISTS delete_mms_pending_on_update2DROP TRIGGER IF EXISTS delete_obsolete_threads_pdu2DROP TRIGGER IF EXISTS delete_obsolete_threads_sms>DROP TRIGGER IF EXISTS delete_obsolete_threads_when_update_pdu(DROP TRIGGER IF EXISTS drm_file_cleanup;8DROP TRIGGER IF EXISTS htcmsg_update_htcthread_on_delete8DROP TRIGGER IF EXISTS htcmsg_update_htcthread_on_insert8DROP TRIGGER IF EXISTS htcmsg_update_htcthread_on_update3DROP TRIGGER IF EXISTS insert_mms_pending_on_insert3DROP TRIGGER IF EXISTS insert_mms_pending_on_update$DROP TRIGGER IF EXISTS part_cleanup;)DROP TRIGGER IF EXISTS part_file_cleanup;?DROP TRIGGER IF EXISTS pdu_update_thread_date_subject_on_update2DROP TRIGGER IF EXISTS pdu_update_thread_on_delete2DROP TRIGGER IF EXISTS pdu_update_thread_on_insert7DROP TRIGGER IF EXISTS pdu_update_thread_read_on_update?DROP TRIGGER IF EXISTS sms_update_thread_date_subject_on_update2DROP TRIGGER IF EXISTS sms_update_thread_on_delete2DROP TRIGGER IF EXISTS sms_update_thread_on_insert7DROP TRIGGER IF EXISTS sms_update_thread_read_on_update8DROP TRIGGER IF EXISTS thread_update_htcthread_on_delete8DROP TRIGGER IF EXISTS thread_update_htcthread_on_insert8DROP TRIGGER IF EXISTS thread_update_htcthread_on_update-DROP TRIGGER IF EXISTS update_pdu_synced_flag-DROP TRIGGER IF EXISTS update_sms_synced_flag5DROP TRIGGER IF EXISTS update_threads_error_on_delete9DROP TRIGGER IF EXISTS update_threads_error_on_delete_mms9DROP TRIGGER IF EXISTS update_threads_error_on_delete_sms7DROP TRIGGER IF EXISTS update_threads_error_on_move_mms5DROP TRIGGER IF EXISTS update_threads_error_on_update9DROP TRIGGER IF EXISTS update_threads_error_on_update_mms9DROP TRIGGER IF EXISTS update_threads_error_on_update_sms DROP VIEW IF EXISTS incoming_msg#DROP VIEW IF EXISTS incoming_msg_v2 DROP VIEW IF EXISTS threads_listDatabaseHelper Delete uri=Destroying all old data.DoLogEMAIL_ADDRESS_PATTERN EMPTY_DATAEMPTY_STRING_ARRAYENABLEERROREXTRA_APP_NAMEEXTRA_CALLING_APP_NAMEEXTRA_ERROR_CODE EXTRA_EVENT EXTRA_FLUSHEXTRA_HINT_CONTEXTEXTRA_HINT_STRINGSEXTRA_N_BEST_CHOOSE_INDEXEXTRA_QUERY_UPDATED_VALUEEXTRA_START_LOCALEEXTRA_START_SWIPEEXTRA_TEXT_MODIFIED_LENGTHEXTRA_TEXT_MODIFIED_TYPEEXTRA_TIMESTAMPEmptyStringReplacerException while parsing 'ExprExtraUriFFIFLFailed setting numeric '!Failed to get valid section tableFailed to insert address: Failed to insert row into GET_ALL_MESSAGE_FROM_STATEGET_SMS_AND_MMS_FROM_STATEGLS_ACCOUNT_SAVEDGLS_ACCOUNT_TRIEDGLS_AUTHENTICATEGOOGLE_HTTP_REQUESTGOOGLE_MAIL_SWITCH GTALKSERVICEGTALK_CONNECTIONGTALK_CONN_CLOSEGTALK_HEARTBEAT_RESETGet GoogleLogTags.java)Got exception while loading APN database.:Got exception while loading APN from /system/etc/customize0Got execption while getting perferred time zone.HINT_CONTEXT_CAR_HOMEHINT_CONTEXT_LAUNCHERHINT_CONTEXT_UNKNOWNHINT_CONTEXT_VOICE_SEARCH_HELP4HTCMSG_UPDATE_HTCTHREAD_ALL_COLUMN_BY_DATE_ON_UPDATE1HTCMSG_UPDATE_HTCTHREAD_COLUMNS_BY_DATE_ON_UPDATEHTC_CONVERSATIONS_ID HTC_MSG_ALLHTC_MSG_ALL_IDHTC_MSG_COLUMNS HTC_MSG_IDHTC_MSG_ONLY_COLUMNSHTC_THREADS_ONLY_COLUMNSHtcMsgsProviderHtcMsgsProvider SetBackUp HtcMsgsProvider.insert: failed! HtcMsgsProvider.javaIID must be a Long. ID_PROJECTIONIIIIIIILIILIIJJLLIJLLILILIILIIILLILLIILLILILLLILLLLILLLLLILLLLLLIME_TEXT_ACCEPTED INPUT_ENDED)INSERT INTO temp_part SELECT * FROM part;INSERT INTO temp_pdu SELECT _id, thread_id, date, msg_box, read, m_id, sub, sub_cs, ct_t, ct_l, exp, m_cls, m_type, v, m_size, pri, rr, rpt_a, resp_st, st, tr_id, retr_st, retr_txt, retr_txt_cs, read_status, ct_cls, resp_txt, d_tm, d_rpt, locked, htc_category, -1 AS cs_timestamp, '' AS cs_id, 0 AS cs_synced FROM pdu;INSERT INTO temp_sms SELECT _id, thread_id, toa, address, person, date, protocol, read, status, type, reply_path_present, subject, body, sc_toa, report_date, service_center, locked, index_on_sim, callback_number, priority, htc_category, -1 AS cs_timestamp, '' AS cs_id, 0 AS cs_synced FROM sms;/INSERT INTO temp_threads SELECT * FROM threads;INSERT INTO temp_threads SELECT _id, date, 0 AS message_count, recipient_ids, snippet, snippet_cs, read, type, error FROM threads;IdsInitial QuickTexts for locale: 8Initial QuickTexts for locale: >>>>>>>>>>>>>>>>>>>>>>>> Insert uri=Insufficient data)Internal APNS file version doesn't match Invalid request: JJIJJJJJLLLJLJLJJLLJLLLJLLZJerryJerry1KEYBOARD_WARNING_DIALOG_CANCEL!KEYBOARD_WARNING_DIALOG_DISMISSEDKEYBOARD_WARNING_DIALOG_OKKEYBOARD_WARNING_DIALOG_SHOWNLLCLCCLDLILIILIILLLLLJLLLLILLIILIILLILLLJLLLLLLL LLLLILLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLZ LOCAL_LOGVLOG_TAGLZ-Landroid/app/backup/AbsoluteFileBackupHelper;&Landroid/app/backup/BackupAgentHelper;$Landroid/app/backup/BackupDataInput;%Landroid/app/backup/BackupDataOutput;!Landroid/app/backup/BackupHelper;"Landroid/app/backup/BackupManager;#Landroid/content/BroadcastReceiver;!Landroid/content/ContentProvider;*Landroid/content/ContentProviderOperation;'Landroid/content/ContentProviderResult;!Landroid/content/ContentResolver;Landroid/content/ContentUris;Landroid/content/ContentValues;Landroid/content/Context;Landroid/content/Intent;Landroid/content/IntentFilter;/Landroid/content/OperationApplicationException;*Landroid/content/SharedPreferences$Editor;#Landroid/content/SharedPreferences;Landroid/content/UriMatcher;#Landroid/content/res/Configuration;1Landroid/content/res/Resources$NotFoundException;Landroid/content/res/Resources;'Landroid/content/res/XmlResourceParser;!Landroid/database/AbstractCursor;"Landroid/database/ContentObserver;Landroid/database/Cursor;Landroid/database/CursorWindow; Landroid/database/DatabaseUtils;Landroid/database/SQLException;6Landroid/database/sqlite/SQLiteDatabase$CursorFactory;(Landroid/database/sqlite/SQLiteDatabase;*Landroid/database/sqlite/SQLiteOpenHelper;,Landroid/database/sqlite/SQLiteQueryBuilder;Landroid/net/NetworkInfo;Landroid/net/Uri;$Landroid/net/http/AndroidHttpClient;Landroid/os/Environment;Landroid/os/Handler;Landroid/os/Message;!Landroid/os/ParcelFileDescriptor;Landroid/os/Parcelable;Landroid/os/SystemProperties;"Landroid/provider/Contacts$Phones;%Landroid/provider/Telephony$Carriers;(Landroid/provider/Telephony$HtcMessages;'Landroid/provider/Telephony$HtcThreads;#Landroid/provider/Telephony$HtcVvm;%Landroid/provider/Telephony$Mms$Rate; Landroid/provider/Telephony$Mms;#Landroid/provider/Telephony$MmsSms; Landroid/provider/Telephony$Sms;$Landroid/provider/Telephony$Threads;Landroid/telephony/SmsManager;+Landroid/telephony/SmsMessage$MessageClass;Landroid/telephony/SmsMessage;$Landroid/telephony/TelephonyManager;Landroid/text/InputFilter;%Landroid/text/SpannableStringBuilder;Landroid/text/Spanned;Landroid/text/TextUtils;Landroid/text/format/Time;Landroid/text/util/Rfc822Token;#Landroid/text/util/Rfc822Tokenizer;Landroid/util/EventLog;Landroid/util/Log;Landroid/util/Xml;/Landroid/widget/AutoCompleteTextView$Validator;$Lcom/android/common/ArrayListCursor;"Lcom/android/common/GoogleLogTags;2Lcom/android/common/NetworkConnectivityListener$1;NLcom/android/common/NetworkConnectivityListener$ConnectivityBroadcastReceiver;6Lcom/android/common/NetworkConnectivityListener$State;0Lcom/android/common/NetworkConnectivityListener;/Lcom/android/common/OperationScheduler$Options;'Lcom/android/common/OperationScheduler;&Lcom/android/common/Rfc822InputFilter;$Lcom/android/common/Rfc822Validator;Lcom/android/common/Search;2Lcom/android/common/speech/LoggingEvents$VoiceIme;5Lcom/android/common/speech/LoggingEvents$VoiceSearch;)Lcom/android/common/speech/LoggingEvents;'Lcom/android/common/speech/Recognition;7Lcom/android/common/userhappiness/UserHappinessSignals;$Lcom/android/internal/util/XmlUtils;5Lcom/android/providers/telephony/AllMessagesProvider;,Lcom/android/providers/telephony/CBProvider;:Lcom/android/providers/telephony/ContentBaseDbBackupAgent;1Lcom/android/providers/telephony/HtcMsgsProvider;4Lcom/android/providers/telephony/MessageBackupAgent;-Lcom/android/providers/telephony/MmsProvider;6Lcom/android/providers/telephony/MmsSmsDatabaseHelper;0Lcom/android/providers/telephony/MmsSmsProvider;/Lcom/android/providers/telephony/QTextProvider;)Lcom/android/providers/telephony/R$array;(Lcom/android/providers/telephony/R$attr;,Lcom/android/providers/telephony/R$drawable;*Lcom/android/providers/telephony/R$string;#Lcom/android/providers/telephony/R;2Lcom/android/providers/telephony/SearchdbProvider;/Lcom/android/providers/telephony/SmsProvider$1;-Lcom/android/providers/telephony/SmsProvider;BLcom/android/providers/telephony/TelephonyProvider$DatabaseHelper;3Lcom/android/providers/telephony/TelephonyProvider;/Lcom/google/android/mms/pdu/EncodedStringValue;+Lcom/google/android/mms/util/SqliteWrapper;"Ldalvik/annotation/EnclosingClass;#Ldalvik/annotation/EnclosingMethod;Ldalvik/annotation/InnerClass;!Ldalvik/annotation/MemberClasses;Ldalvik/annotation/Signature;Ldalvik/annotation/Throws;Ljava/io/ByteArrayInputStream;Ljava/io/ByteArrayOutputStream;Ljava/io/DataInputStream;Ljava/io/DataOutputStream;Ljava/io/EOFException;Ljava/io/File;Ljava/io/FileDescriptor;Ljava/io/FileInputStream;Ljava/io/FileNotFoundException;Ljava/io/FileOutputStream;Ljava/io/FileReader;Ljava/io/IOException;Ljava/io/InputStream;Ljava/io/OutputStream;Ljava/io/Reader;Ljava/lang/AssertionError;Ljava/lang/Boolean;Ljava/lang/CharSequence;Ljava/lang/Class;Ljava/lang/Double;Ljava/lang/EnumLjava/lang/Enum;Ljava/lang/Exception;Ljava/lang/Float;$Ljava/lang/IllegalArgumentException;!Ljava/lang/IllegalStateException;Ljava/lang/Integer;Ljava/lang/Long;Ljava/lang/Math;Ljava/lang/Number;!Ljava/lang/NumberFormatException;Ljava/lang/Object;Ljava/lang/Runnable;Ljava/lang/RuntimeException;Ljava/lang/String;Ljava/lang/StringBuffer;Ljava/lang/StringBuilder;Ljava/lang/System;Ljava/lang/Thread;Ljava/lang/Throwable;)Ljava/lang/UnsupportedOperationException;Ljava/util/ArrayListLjava/util/ArrayList;ALjava/util/ArrayList;5Ljava/util/ArrayList;'Ljava/util/ArrayList;)Ljava/util/ArrayList;,Ljava/util/ArrayList;Ljava/util/Arrays;Ljava/util/Collection;Ljava/util/HashMapLjava/util/HashMap;Ljava/util/HashSet;Ljava/util/Iterator;*Ljava/util/Iterator;Ljava/util/ListLjava/util/List;$Ljava/util/List;Ljava/util/Locale;Ljava/util/MapLjava/util/Map;"Ljava/util/NoSuchElementException;Ljava/util/SetLjava/util/Set;!Ljava/util/Set;#Ljava/util/Set;Ljava/util/StringTokenizer;Ljava/util/TreeSet;Ljava/util/regex/Matcher;Ljava/util/regex/Pattern;Ljava/util/zip/CRC32;Ljava/util/zip/GZIPInputStream; Ljava/util/zip/GZIPOutputStream;LocaleLoggingEvents.javaLorg/xmlpull/v1/XmlPullParser;'Lorg/xmlpull/v1/XmlPullParserException; MESSAGE_COUNTMMS_ALL MMS_ALL_ID MMS_ALL_PART MMS_COLUMNSMMS_CONVERSATION_CONSTRAINTMMS_DELETED_CONSTRAINT MMS_DRAFTS MMS_DRAFTS_IDMMS_DRM_STORAGEMMS_DRM_STORAGE_IDMMS_FOLDER_CONSTRAINT MMS_INBOX MMS_INBOX_ID MMS_MSG_ADDR MMS_MSG_PARTMMS_ONLY_COLUMNS MMS_OUTBOX MMS_OUTBOX_ID MMS_PART_IDMMS_REPORT_REQUESTMMS_REPORT_STATUSMMS_SENDING_RATEMMS_SENT MMS_SENT_IDMMS_SMS_COLUMNSMMS_SMS_COLUMNS_SECURE MMS_THREADSMMS_UNDELETED_CONSTRAINTMessage not retrieved. ID: MessageBackupAgent.javaMessageBkUpAgent2MessageBkUpAgentHandle no backup archive file part9MessageBkUpAgentget the archive data backup record failed>1QTextProvider.java_checkCustomizeQuickText() <<<<1QTextProvider.java_checkCustomizeQuickText() >>>>QTextProvider.java_getType()!QTextProvider.java_insert() >>>>>7QTextProviders.java_insertCustomizationQuickText() <<<<7QTextProviders.java_insertCustomizationQuickText() >>>> QUERY_UPDATED Query uri=R.javaREADRECIPIENT_ADDRESS RECIPIENT_IDSRETRYRecognition.javaRfc822InputFilter.javaRfc822Validator.javaSSELECT SELECT %s FROM pdu,part,addr WHERE ((part.mid=pdu._id) AND (addr.msg_id=pdu._id) AND (addr.type=%d) AND (part.ct='text/plain') AND (body like ?))SELECT %s FROM pdu,part,addr,threads WHERE ((part.mid=pdu._id) AND (addr.msg_id=pdu._id) AND ( pdu.htc_category = %d) AND ((addr.type=%d AND pdu.msg_box = 1) OR (addr.type=%d AND pdu.msg_box = 2)) AND (part.ct !='application/smil') AND (part.text like ? OR addr.address LIKE ? OR threads.name LIKE ? OR pdu.sub LIKE ?) AND (thread_id=threads._id))SELECT %s FROM pdu,part,addr,words WHERE ((part.mid=pdu._id) AND (addr.msg_id=pdu._id) AND (addr.type=%d) AND (part.ct='text/plain') AND (words MATCH ?) AND (part._id = words.source_id) AND (words.table_to_use=2))'SELECT %s FROM sms WHERE (body LIKE ?) SELECT %s FROM sms,threads WHERE (address NOTNULL AND (sms.body LIKE ? OR sms.address LIKE ? OR threads.name LIKE ?) AND (thread_id=threads._id)) AND ( htc_category = %d)eSELECT %s FROM sms,words WHERE (words MATCH ? AND sms._id=words.source_id AND words.table_to_use=1) SELECT * FROM threads9SELECT COUNT(_id) FROM htcthreads WHERE recipient_ids = ?6SELECT DISTINCT _id FROM htcthreads WHERE thread_id = )SELECT DISTINCT thread_id FROM pdu WHERE )SELECT DISTINCT thread_id FROM sms WHERE RSELECT _id FROM htcthreads WHERE _id IN (SELECT DISTINCT htcthread_id FROM htcmsgsISELECT _id FROM threads WHERE _id IN (SELECT DISTINCT thread_id FROM sms /SELECT _id FROM threads WHERE recipient_ids = ?3SELECT _id FROM threads WHERE recipient_ids IN (%s)lSELECT _id, index_text, source_id, table_to_use, offsets(words) FROM words WHERE words MATCH '%s*' LIMIT 50;+SELECT count(*) FROM qtext WHERE locale = '&SELECT error FROM threads WHERE _id = -SELECT thread_id FROM htcthreads WHERE _id = 7SELECT thread_id FROM sms WHERE type=5 AND thread_id = SELECT transport_type, _id, thread_id, address, body, normalized_date, sub, sub_cs, read, m_type, COUNT() - SUM(read) AS unread_count, priority FROM incoming_msg GROUP BY thread_id ORDER BY normalized_date DESCSELECT transport_type, _id, thread_id, address, body, normalized_date, sub, sub_cs, read, m_type, COUNT() - SUM(read) AS unread_count, priority, htcthread_id, vvm_id, ptime, is_private, is_urgent, vvm_type FROM incoming_msg_v2 GROUP BY htcthread_id ORDER BY normalized_date DESC; SEPARATORSETTINGS_WARNING_DIALOG_CANCEL!SETTINGS_WARNING_DIALOG_DISMISSEDSETTINGS_WARNING_DIALOG_OKSETTINGS_WARNING_DIALOG_SHOWNSETUP_COMPLETEDSETUP_IO_ERRORSETUP_NO_DATA_NETWORKSETUP_REQUIRED_CAPTCHASETUP_RETRIES_EXHAUSTEDSETUP_SERVER_ERRORSETUP_SERVER_TIMEOUTSI SIM_COLUMNSSIM_URISMS_ALL SMS_ALL_ID SMS_ALL_SIMSMS_ATTACHMENTSMS_ATTACHMENT_ID SMS_COLUMNSSMS_CONVERSATIONSSMS_CONVERSATIONS_IDSMS_CONVERSATION_CONSTRAINTSMS_DELETED_CONSTRAINT SMS_DRAFT SMS_DRAFT_ID SMS_FAILED SMS_FAILED_ID SMS_INBOX SMS_INBOX_IDSMS_NEW_THREAD_IDSMS_ONLY_COLUMNS SMS_OUTBOX SMS_OUTBOX_IDSMS_QUERY_THREAD_ID SMS_QUEUEDSMS_RAW_MESSAGESMS_SENT SMS_SENT_IDSMS_SIM SMS_STATUS_IDSMS_STATUS_PENDINGSMS_UNDELETED_CONSTRAINTSMS_UNDELIVERED6SMS_UPDATE_THREAD_DATE_SNIPPET_COUNT_BY_DATE_ON_UPDATE.SMS_UPDATE_THREAD_DATE_SNIPPET_COUNT_ON_UPDATESMS_UPDATE_THREAD_READ_BODYSNIPPETSNIPPET_CHARSETSOURCESTARTSTR_VVM_STATEMENT SUGGESTIONSSWIPE_HINT_DISPLAYED SYNC_DETAILS SYSTEM_UPDATESYSTEM_UPDATE_USER Search.javaSearchdbProvider!SearchdbProvider.insert: failed! SearchdbProvider.javaSetting numeric ' SmsProviderSmsProvider.insert: failed! SmsProvider.javaStateStr TABLE_ADDRTABLE_ALL_MESSAGESTABLE_CANONICAL_ADDRESSES TABLE_DRMTABLE_HTCTHREADS TABLE_HTC_MSG TABLE_PART TABLE_PDUTABLE_PENDING_MSG TABLE_QTEXT TABLE_RATE TABLE_RAW TABLE_SEARCH TABLE_SMSTABLE_SR_PENDING TABLE_WORDSTAG TEXT_MODIFIED$TEXT_MODIFIED_TYPE_CHOOSE_SUGGESTION"TEXT_MODIFIED_TYPE_TYPING_DELETION#TEXT_MODIFIED_TYPE_TYPING_INSERTION/TEXT_MODIFIED_TYPE_TYPING_INSERTION_PUNCTUATIONTHREADS_COLUMNSTHREADS_ONLY_COLUMNS THREAD_QUERYTHREAD_QUERY: 1THREAD_UPDATE_HTCTHREAD_COLUMNS_BY_DATE_ON_INSERT1THREAD_UPDATE_HTCTHREAD_COLUMNS_BY_DATE_ON_UPDATETITLETYPE_INT TYPE_LONG TYPE_STRING+Table data(projecttion or sortKey) is emptyTelephonyProviderTelephonyProvider.java/TextColumn in upgradeDatabaseToVersion47() fail?The data record for the archive file list part is weird, key : 7The predefined text of this locale has been initializedThread ID must be a Long.Thread ID must be a long.(Thread id must be a long. htcthread_id: TimeMillisToken format error UNION_COLUMNSUNKNOWN UNREAD_COUNT:UPDATE temp_part SET seq='-1' WHERE ct='application/smil';UPDATE temp_part SET seq='0';UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms._id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM pdu LEFT JOIN pending_msgs ON pdu.thread_id = pending_msgs.msg_id WHERE proto_type = 1 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error = 1 WHERE _id IN (SELECT thread_id FROM sms LEFT JOIN pending_msgs ON sms.thread_id = pending_msgs.msg_id WHERE proto_type = 0 AND err_type >= 10 GROUP BY thread_id); UPDATE threads SET error=9UPDATE_HTCTHREAD_DATE_SNIPPET_SNIPPET_CS_ON_UPDATE_HTCMSG9UPDATE_HTCTHREAD_DATE_SNIPPET_SNIPPET_CS_ON_UPDATE_THREAD-UPDATE_HTCTHREAD_LATEST_DATE_ON_DELETE_HTCMSG-UPDATE_HTCTHREAD_LATEST_DATE_ON_DELETE_THREAD-UPDATE_HTCTHREAD_LATEST_DATE_ON_UPDATE_HTCMSG-UPDATE_HTCTHREAD_LATEST_DATE_ON_UPDATE_THREADUPDATE_HTCTHREAD_MSGTYPE_PTIME_PRIVATE_URGENT_ON_DELETE_HTCMSG>UPDATE_HTCTHREAD_MSGTYPE_PTIME_PRIVATE_URGENT_ON_UPDATE_HTCMSG>UPDATE_HTCTHREAD_MSGTYPE_PTIME_PRIVATE_URGENT_ON_UPDATE_THREAD&UPDATE_HTCTHREAD_READ_ON_DELETE_HTCMSG&UPDATE_HTCTHREAD_READ_ON_UPDATE_HTCMSG&UPDATE_HTCTHREAD_READ_ON_UPDATE_THREAD*UPDATE_HTCTHREAD_THREADID_ON_DELETE_THREAD*UPDATE_HTCTHREAD_THREADID_ON_UPDATE_THREAD+UPDATE_HTCTHREAD_UNREAD_COUNT_ON_NEW_THREADUPDATE_PDU_SYNCED_FLAGUPDATE_SMS_SYNCED_FLAGUPDATE_THREAD_COUNT_ON_NEWUPDATE_THREAD_COUNT_ON_OLD/UPDATE_THREAD_DATE_SNIPPET_SNIPPET_CS_ON_DELETE/UPDATE_THREAD_DATE_SNIPPET_SNIPPET_CS_ON_UPDATE UPDATE_THREAD_PRIORITY_ON_DELETE*UPDATE_THREAD_SNIPPET_SNIPPET_CS_ON_DELETE"UPDATE_UNREAD_MESSAGE_COUNT_ON_NEW"UPDATE_UNREAD_MESSAGE_COUNT_ON_OLDURI URI_ALL_MSGURI_AVAILABLE_THREAD_IDURI_CANONICAL_ADDRESSURI_CANONICAL_ADDRESSESURI_COMPLETE_CONVERSATIONSURI_CONVERSATIONSURI_CONVERSATIONS_ALL_MESSAGESURI_CONVERSATIONS_MESSAGESURI_CONVERSATIONS_RECIPIENTSURI_CONVERSATIONS_SUBJECT URI_DRAFTURI_DRAFT_LISTURI_FIRST_LOCKED_MESSAGE_ALL%URI_FIRST_LOCKED_MESSAGE_BY_THREAD_IDURI_HTC_THREAD_IDURI_LATEST_MT_MSG_PER_THREAD URI_MATCHERURI_MESSAGES_BY_PHONEURI_NOTIFICATIONSURI_OBSOLETE_THREADSURI_PENDING_MSG URI_SEARCHURI_SEARCH_SUGGESTURI_SMS_AND_MMS_MSG URI_THREAD_IDURI_UNDELIVERED_MSG URL_CURRENTURL_ID URL_MATCHER URL_PREFERAPNURL_RESTOREAPN URL_TELEPHONYUnable to create new file: Unable to create new partFile: Unknown URL Unknown URL Unknown table type: Unrecognized URI:Update operation for ' Update uri=Update values=!Upgrade database file from TC2!!! Upgrading database from version UserHappinessSignals.javaVVENDING_RECONSTRUCTVIVIIVIIJLVILVILIIVJVJILIVLVLIVLIIVLIILVLILVLILIIVLJVLJLVLLVLLIVLLLVLLLIVND_ANDROID_DIR_ALL_MESSAGESVND_ANDROID_DIR_MMSVND_ANDROID_DIR_MMS_SMSVND_ANDROID_DIR_SMSVND_ANDROID_DIR_VVMVND_ANDROID_MMSVND_ANDROID_SMSVND_ANDROID_SMSCHATVND_ANDROID_VVMVND_ANDROID_VVM_CHATVOICE_INPUT_DELIVEREDVOICE_INPUT_SETTING_DISABLEDVOICE_INPUT_SETTING_ENABLEDVVM_ALL VVM_ALL_IDVVM_ALL_VVM_IDVVM_CLIENT_AUTHORITYVVM_CLIENT_CONTENT_URIVVM_SYNCVZVoiceIme VoiceSearchWHERE (WHERE not supported=Wrong archive folder path param or no attachedment exist caseZZIZIIZLZLIZLIIZLLZLLILLLLZLLLZLLLLZLZZZ[[B[I[J([Landroid/content/ContentProviderResult; [Landroid/content/ContentValues; [Landroid/text/util/Rfc822Token;7[Lcom/android/common/NetworkConnectivityListener$State;[Ljava/lang/Object;[Ljava/lang/String;[Ljava/util/ArrayList;-[MmsSmsDb] upgradeDatabaseToVersion60 caught /[MmsSmsDb] upgradeDatabaseToVersion60: updated [OperationScheduler:[[B*[^\s@]+@[^\s@]+\.[a-zA-z][a-zA-Z][a-zA-Z]*]_ __ID __ALBAL___count_create_customization_initialized_customization_initialized'_data_id_id = _id = _id = ?f_id = ? AND _id NOT IN (SELECT thread_id FROM sms UNION SELECT thread_id FROM pdu)R_id = ? AND _id NOT IN (SELECT htcthread_id FROM htcmsgs) AND thread_id <= 0_id ASC_id IN ( _id NOT IN K_id NOT IN (SELECT DISTINCT htcthread_id FROM htcmsgs) AND thread_id <= 0X_id NOT IN (SELECT DISTINCT thread_id FROM sms UNION SELECT DISTINCT thread_id FROM pdu)_id NOT IN (SELECT DISTINCT thread_id FROM sms WHERE thread_id > 0 UNION SELECT DISTINCT thread_id FROM pdu WHERE thread_id > 0) _id,thread_id,address,body,date_id=_id=? _initialized _initialized' _projection_where absPathRoot access$000 access$002 access$100 access$102 access$202 access$302 access$402 access$502 access$600 accessFlagsacquireReferenceaction actionAllowedadd addActionaddDate addHelper addMsgBox addMsgTypeaddTypeaddURIaddraddr LEFT JOIN (SELECT P.msg_id AS msg_id, addr.address AS addr, delivery_status, dr_date, dr_id FROM addr INNER JOIN (SELECT DISTINCT P1._id AS msg_id, P2._id AS dr_id, P2.date AS dr_date, ifnull(P2.st, 0) AS delivery_status FROM pdu P1 LEFT JOIN pdu P2 ON P1.m_id=P2.m_id AND P2.m_type=134 AND P1.m_type=128) P ON addr.msg_id=P.dr_id AND addr.type=151) T1 ON T1.msg_id=addr.msg_id AND (PHONE_NUMBERS_EQUAL(T1.addr, addr.address) OR T1.addr=addr.address) LEFT JOIN (SELECT P.msg_id AS msg_id, addr.address AS addr, read_status, rr_date,rr_id FROM addr INNER JOIN (SELECT DISTINCT P1._id AS msg_id, P2._id as rr_id, P2.date AS rr_date, ifnull(P2.read_status, 0) AS read_status FROM pdu P1 LEFT JOIN pdu P2 ON P1.m_id=P2.m_id AND P2.m_type=136 AND P1.m_type=128) P ON addr.msg_id=P.rr_id AND addr.type=137) T2 ON T2.msg_id=addr.msg_id AND (PHONE_NUMBERS_EQUAL(T2.addr, addr.address) OR T2.addr=addr.address)&addr join pdu on pdu._id = addr.msg_idaddr.type=151 AND addr.msg_id=address address = ? address: addressId addressIds addressesadp_a affectedRows allmessagesallocRow%android.intent.action.CONTENT_CHANGED$android.net.conn.CONNECTIVITY_CHANGE%android.permission.WRITE_APN_SETTINGS!android.speech.extra.HINT_CONTEXT!android.speech.extra.HINT_STRINGSapl_idapnapn_idapnsapns.xmlappVersionCode app_labelapp_nameappend appendWhereapplication/smil applyBatchappname archivePatharr$array arraycopy attachments attachments/#attrauth authorityauthtype aux_apl_id availableavailable-threadIDbackoff=backoffFixedMillisbackoffIncrementalMillis bad Arg: baos beginDocumentbeginTransactionbodybody AS snippetbufferbuild allmessages query> !buildAllMessagesConversationQuerybuildConversationQuery buildQuerybuildUnionQuerybuildUnionSubQuery bulk insert: bulkInsertbytesccallback_numbercanonical-address/#canonical-addressescanonical_addressescarriercarriers carriers/#carriers/currentcarriers/preferapncarriers/restorecategory categoryExprcbchcbch/# cbchannelscdcellchangeschannel channel DESCcharAtcharsetcheckCustomizeQuickTextcheckPermission checkSummer checksumschsetcidclcl_idcl_stclearclonecloseclose fin file failcodecolCount columnIndex columnName columnNames columnNumcolumnscolumnsPresentInTable#com.android.common.speech.LOG_EVENTcom.android.mms.updateShortcut-com.htc.vvm.provider.VoiceMailContentProvidercommitcommonColumnCountcompareToIgnoreCasecompilecomplete-conversationscomposedconcatSelectionsconcatenateWhereconfFile confparser confreader confversion constraintconstructQueryForBoxconstructQueryForUndelivered contact_id containsKeycontent content > content://content://cbchannels/cbch=content://com.htc.vvm.provider.VoiceMailContentProvider/inbox content://mms-sms/conversations/content://qtextcontent://search content://smscontent://sms/sim contentType contentUri contentValues content_urlcontext conversationsconversations/#conversations/#/#conversations/#/recipientsconversations/#/subjectconversations/*conversations/obsoleteconvertSimToSmscountcrcreate"create trigger addr_cleanup fail: 6create trigger cleanup_delivery_and_read_report fail: 2create trigger delete_mms_pending_on_delete fail: 2create trigger delete_mms_pending_on_update fail: 1create trigger delete_obsolete_threads_pdu fail: 1create trigger delete_obsolete_threads_sms fail: =create trigger delete_obsolete_threads_when_update_pdu fail: 7create trigger htcmsg_update_htcthread_on_delete fail: 7create trigger htcmsg_update_htcthread_on_insert fail: 7create trigger htcmsg_update_htcthread_on_update fail: 2create trigger insert_mms_pending_on_insert fail: 2create trigger insert_mms_pending_on_update fail: "create trigger part_cleanup fail: >create trigger pdu_update_thread_date_subject_on_update fail: 1create trigger pdu_update_thread_on_delete fail: 1create trigger pdu_update_thread_on_insert fail: 6create trigger pdu_update_thread_read_on_update fail: >create trigger sms_update_thread_date_subject_on_update fail: 1create trigger sms_update_thread_on_delete fail: 1create trigger sms_update_thread_on_insert fail: 6create trigger sms_update_thread_read_on_update fail: 7create trigger thread_update_htcthread_on_delete fail: 7create trigger thread_update_htcthread_on_insert fail: 7create trigger thread_update_htcthread_on_update fail: ,create trigger update_pdu_synced_flag fail: ,create trigger update_sms_synced_flag fail: 8create trigger update_threads_error_on_delete_mms fail: 8create trigger update_threads_error_on_delete_sms fail: 6create trigger update_threads_error_on_move_mms fail: 8create trigger update_threads_error_on_update_mms fail: 8create trigger update_threads_error_on_update_sms fail: createCBTablescreateCommonTablescreateCommonTriggerscreateHtcMsgsTablescreateHtcMsgsTriggerscreateHtcThreadsTablescreateIncomingMessageViewcreateIncomingMessageViewV2 createIndicescreateMmsProjectioncreateMmsTablescreateMmsTriggers createNewFilecreateNewProjectioncreateQTextTablescreateSmsTablescreateThreadIdIndexcreateThreadsListViewcreateWordsTablescsctct = 'text/plain'ct_clsct_lct_tctt_sctt_tcurErrorcurrentcurrent IS NOT NULLcurrentPosSourcecurrentTimeMilliscurrentVersioncursorcursor == null: cursor is nullcursor.count() != 1: custom apn file not found customFilecustomFileParsercustomFileReadercvdd_indd_rptd_tmd_tm_tokdata dataChanged dataInputdataMMS dataOutputdataSMS dataTypeListdatabytedatedate * date = MAX(date) date DESCdate as suggest_intent_data_id date desc dateMultipledbdbFiledefListdefValuedelWhere delWhere: deletOneVvmMessagedeletOneVvmMessage: vvm_id> deletedelete exception delete htc thread id sql: #delete orphaned htcthreads: where= delete thread id sql: delete thread rows: delete url=!delete vvm in vvm client. count> deleteAll deleteCharAtdeleteConversationdeleteDataRowsdeleteHtcConversationdeleteHtcConversation: deleteHtcConversations deleteHtcMsgsdeleteMessageFromIccdeleteMessageFromSimdeleteMessages deleteOneMsgdeleteOneMsgById deleteOneSmsdeleteOneVvmClientMessage deletePartsdeleteTempDrmData deleteThreaddeleteVvmClientMessages deleteWhere delete_flag deletedRowsdeleted_contentsdeltadenddestdestination_portdetailsdictCompressed directiondirtyIdsdisplayAddressPdo not specify sortOrder, selection, selectionArgs, or projectionwith this querydomaindotFound doubleValuedownloadResultdraftdraft/# draftlistdraftsdrafts/#drawabledrmdrm/#drm_cdropAll dropCBTablesdropCommonTablesdropCommonTriggersdropHtcMsgsTablesdropHtcMsgsTriggersdropHtcThreadsTables dropMmsTablesdropMmsTriggersdropQTextTables dropSmsTablesdstartdue_timedurationee_desediteditorelapsedemptyemptyStrPatternenableenabled enabledState encordTargetendendTransactionendsWithenforceCallingOrSelfPermissioneofequalsequalsIgnoreCaseerr_codeerr_typeerror errorCount errorQuery error_codeescapedPhoneNumberetc/apns-conf.xml eventtypeex exceptionexecSQLexistsexpexprexternalextraSelection extraWhere extra_eventextractIntegerParameterfIn,fail to delete vvm in vvm client.... count> fail to delete vvm, vvm_id> failedfailed/#fetchMessagesFromUnifiedFolderfieldfile size is zerofileBkupfileListfilenamefilepathfillContentBySource fillWindowfilterfilterUnsupportedKeys finalAddressfinalMmsSelection finalOrderfinalSelectionfinalSelection2finalSmsSelectionfinalSortOrderfinalSun finalValues finalvaluesfinishfixfixTextflag floatValueflushfn folderNameformatfoundID freeLastRow fromWherefullPathgetgetAbsolutePath getAction getAddress getAddressIds(getAddressIds: address ID not found for getAllgetAllMessagesgetAllMessagesFromIccgetAllMessagesFromSim getAsInteger getAsLong getAsStringgetAttributeValuegetAvailableThreadIdgetBlob getBooleangetBooleanExtragetBytesgetColumnCountgetColumnIndexOrThrowgetColumnNamesgetCommaSeparatedNumbersgetCompleteConversationsgetConfigurationgetContentResolver getContentUri getContextgetConversationByIdgetConversationMessagesgetConversationMessages: getConversationsgetCount getDataSize getDatabasegetDatabasePath getDefaultgetDestinationAddressgetDirgetDisplayAddressgetDisplayMessageBodygetDisplayOriginatingAddress getDouble getDraftListgetDraftThreadgetFileDescriptorgetFilledContentValueByStringgetFirstLockedMessagegetFirstLockedMessage query: getFloatgetFormalConversationsgetHtcThreadIdgetHtcThreadId: getIndexOnIcc getInstancegetIntgetKeygetLastAttemptTimeMillisgetLastPathSegmentgetLastSuccessTimeMillisgetLong getMessagegetMessageBoxByMatchgetMessageClassgetMessagesByPhoneNumbergetMissedMessagePerThreadgetNamegetNetworkInfogetNextTimeMillisgetOrCreateThreadIdgetOtherNetworkInfogetPackageNamegetParcelableExtragetPathgetPathSegments getPhoneTypegetPreferredApnIdgetProjectionTablegetQueryParametergetQueryParametersgetReadableDatabase getReasongetRelativeRecordString getResourcesgetRootDirectorygetRowgetSectionKeyTablegetServiceCenterAddressgetSharedPreferencesgetShortgetSimpleConversationsgetSingleAddressId5getSingleAddressId: insert new canonical_address for getSingleMessageFromSimgetSmsAndMmsMessages getSortKey getSortedSetgetSpaceSeparatedNumbersgetStategetStatusOnIccgetStatusOnSim getStringgetStringArraygetStringExtra getSystem getTableData getTables getThreadId+getThreadId: recipientIds (selectionArgs) = getThreadId: why is cursorCount= getTimeBeforegetTimestampMillisgetTrimmedLengthgetTypegetUndeliveredMessagesgetValue getVersiongetWritableDatabasegetXml googlemobilegot8got exception altering table sms add column error_code: 7got exception altering table sms, pdu add column seen: got exception creating indices: $got exception creating words table: +got exception upgrade database version 50: got exception: groups.msg_count AS msg_countgziphandleNullHtcThreadsProjectionhandleNullMessageProjectionhandleNullSortOrderhandleNullThreadsProjectionhasNexthas_attachmenthave Quick Text customizationhtcMsgOnlyColumnCounthtcMsgSelection htcThreadIdhtcThreadIdString htcThreadList htcThread_idhtcThread_queryhtcThreadsOnlyColumnCounthtcWhere htc_category htc_category=htc_category= 0 htc_threadId htcmsgColumnshtcmsgColumnsPresentInTablehtcmsgProjectionhtcmsgQueryBuilderhtcmsgSelectionhtcmsgSubQueryhtcmsgs htcmsgs._id htcthreadId htcthreadId/* htcthread_idhtcthread_id = htcthread_id IN (htcthread_id must be long: htcthreadsQhtcthreads LEFT JOIN threads ON htcthreads.recipient_ids = threads.recipient_idshtcthreads._idhtcthreads.recipient_addresshtcthreads.recipient_idsii$iaeic_launcher_phoneididsids: in inTransactioninboxinbox/#incindexindexCntindexOfindex_0b index_on_sim index_text initDatabase initQText initialValues initializeAllMessagesColumnsSetsinitializeColumnSetsinnerMmsProjectioninnerProjectioninnerSmsProjectioninnerhtcmsgProjectioninsertinsert exception insert id : insert uri= insert url=insert-address-tokeninsert: invalid request: insertAddingDefaultsinsertCustomizationQuickTextinsertHtcThreadinsertHtcThread: insertOrThrow insertThread$insertThread: created new thread_id insertValue insert_byinsert_by=? OR insert_by=? inserted intDataintValueintentinternalinterpretMmsFolderSelectioninterpretSmsFolderSelection intervalAndNt invalidatedioeip isAfterLast isDirectoryisEmailisEmailAddressisEmptyisEntityDataInvalidisExistingDefaultApn isFailover isLoggableisNull isOutGoingSmsisPhone isPhoneNumberisStatusReportMessageisSupportHtcMessagesisValid isWritable is_privateis_status_report is_urgentititeratorjoinPduAndPendingMsgTables joinedColumnskelvinkeykeyListkeySetlastErrorTimeMillis lastStreamIdlastSuccessTimeMillislast_try latest_datelatest_date DESClenlen$lengthlexikonlimitlinelistlistDraftByCategorylistLenloadApnslocale locale >>locale='locked locked = 0locked/#locked=1longData longValuemBackupManager mColumnNamesmContextmCursormCustomizeApnsmDBmDomain mHandlers mInstance mIsFailover mListening mNetworkInfo mNewByRestore mOpenHelpermOtherNetworkInfomPos mProjectionmReason mReceivermRowsmStatemStorage mUseStrictPhoneNumberComparationm_clsm_cntm_idm_sizem_typemakeHtcThreadsProjectioin!makeProjectionWithDateAndThreadId makeProjectionWithNormalizedDatemapmatchmatchermatchesmaxmax=maxMoratoriumMillismb_qt mb_qt_tokmb_tmb_t_tokmccmessage messageIndexmessageIndexString message_class message_count message_idmessagesmessages/byphone/*midmid = ?mid=millisminmin=minTriggerMillis missed_msgmm_flg mm_flg_tokmm_stmmsmms-sms mmsColumns mmsConstraint mmsFoldermmsOnlyColumnCount mmsProjectionmmsProjection1mmsQuery mmsQuery1mmsQueryBuildermmsRows mmsSelection mmsSubQuerymmsWheremms_quick_textmmscmmsport mmsprotocolmmsproxy mmssms.dbmmssmsSelection mmssmsWheremncmodemoratoriumSetMillismoratoriumTimeMillis moveToFirst moveToNextmoveToPositionmsmsgBox msgBoxObjmsgIdmsg_box msg_box != 3 msg_box < 0 msg_box = 3msg_box = 3 AND msg_box > 0msg_box= msg_box=3 msg_countmsg_idmsg_id=msg_typemsg_type = 'vvm'namename ASC networkInfonewArgs newChecksumnewItem newProjection newPullParsernewState newVersionnewWherenext nextElement nextTokennfe:no databse object or no content uri mapping table happenednoConnectivity&normalized_date = MAX(normalized_date)normalized_date ASCnormalized_date DESC notificationsnotify notifyChangenownseenullnum numValuesnumbernumberOfRecipientsnumbersnumeric numeric = 'objobtainoffsetold oldChecksumoldItemoldState oldVersionoldposonBackuponCreateonPermanentError onPostBackuponPostRestorCreate onPostRestore onPreBackuponPreRestorCreate onPreRestore onReceiveonReceived() called with onRestore onSuccessonTransientError onUpgrade oneHourAgoopopenFileopenFileHelperopenOrCreateDatabase operationsoperator operator DESCoptionsorderorderBy otherNetworkoutoutboxoutbox/# outerQueryouterQueryBuilderoutputp_message_countp_readp_s_byp_s_dp_unread_count packetTypeparamparentFolderPathparse parseDate parseFloatparseInt parseLong parseOptions parseSecondsparserpartpart.midpart/#partFilepartspasswordpathpath >patternpdu;pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_idpdu group by thread_idQpdu, (SELECT _id AS address_id FROM addr WHERE PHONE_NUMBERS_EQUAL(addr.address, ;pdu, (SELECT msg_id AS address_id FROM addr WHERE (address=pdu._id pdu._id = 'pdu._id = matching_addresses.address_id9pdu._id,thread_id,addr.address,part.text as body,pdu.dateNpdu._id,thread_id,addr.address,part.text as body,pdu.date,index_text,words._idpending pending_msgsperiod=periodicIntervalMillispermanentError persistentIdperson phoneNumber plainTextpluspopulateWordsTableportposposition postCheckSun preCheckSun preferred-apn preinstallpripriorityprjTable projectionprojectionBuilder projectionInprojectionSizeproto protoName proto_type proto_type=protocolproxyptime publicversionputputBlob putBooleanputExtraputIntputLongputNull putStringqbqsqtqtextqueryquery conversations: threadID=query: invalid request: queryBuilder queryStringqueuedrr_apl_idr_chgr_chg_dl r_chg_dl_tokr_chg_idr_chg_szr_r_mod r_r_mod_txtraterawrawQuery rawQuery1readread=1readEntityDatareadIntreadLongreadNextHeaderreadOldChecksums read_statusreason recipientrecipientAddressrecipientAddress: recipientIdsrecipientIds: recipient_address#recipient_address as suggest_text_1recipient_address like '% recipient_ids recipients recipients_record recordKey recordOffsetrecvreference_numberrefinedAddressregisterHandlerregisterReceiverreleaseReferenceremoveremoveIllegalCharactersrepl_idreplacereply_path_presentreport-request/#report-status/# report_daterequeryresresetPermanentErrorresetTransientErrorresp_stresp_txtrestoreDefaultAPNrestoreTableDataresultretretValretr_stretr_txt retr_txt_cs retryAfter retry_indexreusedro.cidrowrowCountrowIDrowID >>rowIdrowsrpt_arrrunssConversationProjectionMap sIDProjection sURLMatchers_currentNullMaps_currentSetMap s_urlMatchers_vissbsc_toascanBacksearch searchString searchString1 searchSuggest searchUrisearch_categorysection sectionSizesectionTableDataseensegment selection selection1 selection2 selection: selectionArgssend sendBroadcast sendMessagesentsent/# sent_time sent_time<=seqsequenceserverserviceservice_centerservice_center_addressset setAction setAddress setDistinctsetEnabledStatesetErrorsetInputsetMoratoriumTimeHttpsetMoratoriumTimeMillissetNotificationUri setNumColumnssetPreferredApnIdsetProjectionMapsetStartPosition setTablessetTransactionSuccessfulsetTriggerTimeMillissetUpdateMMSshortcutBroadcast shortValuesimsim/#simple singleRowsizesize > sizeBytessmilTextsmssms, (SELECT thread_id AS group_thread_id, MAX(date) AS group_date, COUNT(*) AS msg_count FROM sms GROUP BY thread_id) AS groups?sms._id as _id,thread_id,address,body,date,index_text,words._idGsms.thread_id = groups.group_thread_id AND sms.date = groups.group_datesms.thread_id AS thread_id smsColumns smsConstraint smsFolder smsManagersmsOnlyColumnCount smsProjectionsmsProjection1smsQuery smsQuery1smsQueryBuildersmsRows smsSubQuerysms_idsnippetsnippet as suggest_text_2 snippet_cssortsortKeysortKeyRecordValue sortKeyValue sortOrdersource source_idspspec specialDataspecialIndex_0bsplitsplitor sqlCreatesqlEscapeString sr_pendingsrcstst_txtstartstartListening startsWithstatestateChecksumsstatusstatus/# stopListeningstoragestorestore_st store_st_txtstoredstrstreamIdstringsubsub_cssubject substringsuggestion/search_suggest_querysuggestions mmsQuery >suggestions smsQuery >swipetable tableCounttableKey tablePduExpr tableSmsExpr table_to_usetarget telephony telephony.dbtempDatatext text/plainthisthis$0threadID threadID/*threadIdthreadIdString threadType thread_id thread_id = thread_id = thread_id AS tidthread_id ASC, date DESCthread_id IN (thread_id as _id,pdu.date as date,addr.address as recipient_address,part.text as body,'mms' as msgtype,threads.name as suggest_text_1,part.text as suggest_text_2, threads._id as suggest_intent_data_id, pdu._id as suggest_intent_extra_data, 'thread_id as _id,sms.date as date,address as recipient_address,sms.body as body,'sms' as msgtype,threads.name as suggest_text_1,sms.body as suggest_text_2, threads._id as suggest_intent_data_id, sms._id as suggest_intent_extra_data, ' thread_id= thread_typethreadsthreadsOnlyColumnCount threads_listtidtime timeInMillis timestamptitle toByteArray toLowerCasetoStringtoatokenizetokenstotalstr_idtranslateRecordintoStringtransport_typetriggerTimeMillistruetypetype < 0type = 3 type = 3 AND type > 0type=type=3+type=? AND (operator=? OR operator is null)typeArytypeListtypeObj undelivered unionColumns unionQueryunionQueryBuilderunionSelections unread_countunregisterHandlerunregisterReceiverupdateupdate exception Lupdate to version 54> (sync connected service codes about sms in version 51)Lupdate to version 55> (sync connected service codes about pdu in version 51),update to version 56> re-create all triggers&update to version 60> upgrade to Froyo update url=update vvm client where: update vvm_id: updateAllHtcThreadsupdateAllHtcThreads query: updateAllThreadsupdateConversationupdateHtcThreadupdateHtcThreadIdListupdateHtcThreadIdList: updateMessagesupdateMmsShortcutBroadcast updateThread updateValues updateVvmupdated0upgrade seq in upgradeDatabaseToVersion47() fail5upgrade to version 53 > (sync secure folder function)upgradeDatabaseToVersion25upgradeDatabaseToVersion26upgradeDatabaseToVersion27upgradeDatabaseToVersion28upgradeDatabaseToVersion29upgradeDatabaseToVersion30upgradeDatabaseToVersion31upgradeDatabaseToVersion32upgradeDatabaseToVersion33upgradeDatabaseToVersion34upgradeDatabaseToVersion35upgradeDatabaseToVersion36upgradeDatabaseToVersion37upgradeDatabaseToVersion38upgradeDatabaseToVersion39upgradeDatabaseToVersion40upgradeDatabaseToVersion41upgradeDatabaseToVersion42upgradeDatabaseToVersion43upgradeDatabaseToVersion44upgradeDatabaseToVersion46?upgradeDatabaseToVersion46 in upgradeDatabaseToVersion47() failupgradeDatabaseToVersion47!upgradeDatabaseToVersion47() failupgradeDatabaseToVersion48upgradeDatabaseToVersion49upgradeDatabaseToVersion50upgradeDatabaseToVersion51upgradeDatabaseToVersion52upgradeDatabaseToVersion53upgradeDatabaseToVersion54upgradeDatabaseToVersion55upgradeDatabaseToVersion56upgradeDatabaseToVersion60upgradeTextFile2TextColumn.upgradeTextFile2TextColumn cursor is null <<<upgradeTextFile2TextColumn <<<upgradeTextFile2TextColumn >>>uriurluseruserAcceptedImeTextutf-8vvCALevCALsval$finalAddressval$finalvaluesvaluevalueOfvalueSvaluesversionvnd.android-dir/allmessagesvnd.android-dir/mmsvnd.android-dir/mms-smsvnd.android.cursor.dir/sms(vnd.android.cursor.dir/telephony-carrier$vnd.android.cursor.dir/vnd.google.cb'vnd.android.cursor.dir/vnd.google.qtext*vnd.android.cursor.dir/vnd.google.searchdb(vnd.android.cursor.dir/vnd.htc.voicemailvnd.android.cursor.item/sms vnd.android.cursor.item/sms-chat)vnd.android.cursor.item/telephony-carrier%vnd.android.cursor.item/vnd.google.cb(vnd.android.cursor.item/vnd.google.qtext+vnd.android.cursor.item/vnd.google.searchdb)vnd.android.cursor.item/vnd.htc.voicemail2vnd.android.cursor.item/vnd.htc.voicemail.vvm-chatvnd.android/mmsvoiceimevvmvvm/#vvm/syncvvmId/# vvm_countvvm_id vvm_id = vvm_id = 'vvm_id NOT IN vvm_ptimevvm_uri vvm_wherewwhatwherewhere= whereArgs whereClausewindowwithAppendedIdwithAppendedPathwithSimNotificationUriwords writableDbwrite writeC2DmwriteEntityDatawriteEntityHeader writeEventwriteGlsAccountSavedwriteGlsAccountTriedwriteGlsAuthenticatewriteGoogleHttpRequestwriteGoogleMailSwitchwriteGtalkConnClosewriteGtalkConnectionwriteGtalkHeartbeatResetwriteGtalkservicewriteIfChangedwriteInt writeLongwriteNewChecksumswriteSetupCompletedwriteSetupIoErrorwriteSetupNoDataNetworkwriteSetupRequiredCaptchawriteSetupRetriesExhaustedwriteSetupServerErrorwriteSetupServerTimeoutwriteSyncDetailswriteSystemUpdatewriteSystemUpdateUserwriteVendingReconstructx0x1|#  ;<  --"-iikKL<-o;;B,X=-Z<>A L #,ak-|Դii*+iJl;rkkk;wK'''''''' Z.Z ZZ=x,Zx<<<<<=w,Z&,=/M\/8YG<-a; Kg=i--z{, we K  -x- <<+, {.-hxZA% #c -i ^!K%g/8 <-LZK-S v;0Ll ,jK[---K M  K -%i -L - - ! -iZ  Z [   0--z j          -     -iZ Z [ !- -  z   Z k           B{Zi'   - iZZ  -x Z M<- < Z  x -    !          Ki;-Z- K<9@i--w M.i #Z v,[ --[UA   A K Z%L KZ  t     K Z%[%ZK [%y[%KZ%[ %Z  KLy Y![#%y !"[%"Z%[%Z[%y[% Z%[%Z[%y[% i #  ,M<< @K5i # [ --[UA[ --[UA ,M<< @K/i # iZ[k  LZ-g>  LKZZ|x J-1K -iZ.q=- w1 {Ai #  o x ;i;~1 . ;-;p+ j. i #K  - -)ZJ  "J-LLyaJ-  #    mLz-   K!- \  #- -,~./-~-./&!!&$....# Z *O# /iz,< -@-/.  {,.. "%-'.("."%'( i q _%.% /  /1*$z,*< 012<);D6./)/$~,i # x w-Ly^g- j>x,?,-i #rh O]hK<{x;tz/{JJ-^ $MŇyi #ii'K\ IT;[% vZYi0 #KK nZ "l,i #sh N]j<{y;($=KK K 'K<0,S. #-<= V!i!<=i u oKxxM<(.{Y@=fL@- v. JZ:k;x"j! xK#=f>3K A  . Z u - <     ;. ^ -Kg? O.9AK Z"-.AKNN 'rJ w["Z,$@ <]ZZ #-K Y=   M-ԥ  -eQ :  < i /U,   < !&    x]J  - =.y@ibY-Nl ii #7;K8.Ly]=@ i-    pq,-   i/ i-  Lwz,==z; ).Bə #   -.  b_ jyyx 'M,   KJ   ;\%i  ,;D.Yi1i # G Z  Zx - BZzZ\ Z  KJ - i # d KL/Ly\=[RAz -.b,' <{.iN {B--Ky<#-#RZ-w-h,Zyi   - <- K0$,UEKOZ"=ZN---ZOZ"P!k=<.p"-Y z MJ~\\[]zMjkM\jkM\kiz\j!k\j\\j\\klM\jQzMj -z\k\\k\\ },A@&8&**  '"" [Y~_k#S /LJ  )#~j#}#x#.x#/~#.k #.i#.i#/x#.|#.z #/i#/i#/}J7A3&&*"AJ ,aK<<= . Z u -  < F   K 3K-  -? < ] =/y "   ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\Z;u&z//t,  i Z  /i$ ';    U     i  ?   #    -K -  -y; #         '     < [ <= /y #j" );3  -% K i #  -MyaP --K --  - . - . -, ijhwi %;aJA= .^G@{J\c  )-(;,"}" - (J #/'  { L-KyiJ  . ....-.-.-.- ,ih  $ My^# "2~,"Ç  " iMMy^% "È x " M+Zyji<   iM< O #0^ My| "[#My{+ Zji<   iL#My| ~[ h\%x l j ";~     J i4i # ~ ___^Z"Z!zZ#Z#Z#Yr[zzZ wM~Jj"Z i #  ;=Myl!Myl%Myl, . [   Y Y Y<<>>>  , Y YY YYYYYYYYYYYYYYYY YiAcb|- -- ---------- - --------  Y ,bbba Y YJ- ---- - JZx Y ]Y  <  )YaY\\  , Y YYV- -- \K  0Ycb]  ^-  4Y  `\]\\?-   h $ -iL? .L <<<<=ZZZZZZZZZZZZZ Z ZZ[[[<<\ ZZZZZZZZZZZZZZZZZZZ[>Z[ Z ZZZZZZ Z ZZZZZ ZZZ Z ZZZZZZ xyG  . -xZ i= Z =l  <<<<>@><<  l<>  ,(;x<<<<<yY->V\a- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y-`M=<@@M=<@?M=<@?M=<@?M=<@?M=<@?M=<@?M=<@?M=<@?N=<@?N=<@CM=<@~Y- Y- Y- Y- Y- Y- Y- Y- Y- Y- Y-Y-{Yfh7, Bz|-J <^?3;LZ%[%KKx[KKx Z[   !=%[![% |x <[ --[UA[ --[UAZ .!y  r ;x}  @x / #L iBԥM  LZ%["%x ! K Kx ZZ#[%%y  $[%"   < <<[-t@ZZZN],jK [[-"i@N]<1     LZ-g> LKZZAi # x x;i #K  ,XK%;-iN^=C-  A.!- Y   #. |     8| 8.Җ6i'N$6&. ".  .  .  . *.*8  s,8.,'/', ,./0 1 "(< * "(,/1&$%i p%%_%.&$%&M1M14$z,4< K12<3;-  0!2 '#. -) r,))!#)-0232+|,i # %ai\-iN]SM!- _;/x7W ,xZ  -ixx =x ZKZmxrZ- K;ii #;lh /N]=b$ xknxy/{J/-]i;g$y>N]#cMZi #i!'>NlM,Ll\%i   ;VZZ i./j # ii Z -ixx>? \, Zw, i #qh/N]=f-%r  ;<x4@ K,ii # ;v h /N]=j%wz/{J0-^ $Mi #i!'>Nr\h;\%i ;cZYi" #KM h Z "j;, i #sh/N]=f-%t,Zj' ҇ y'GhhBy@?@[- [- h[R,]yԴx]ix}yeYM9 N]Zm/- N]ZK9K[ -i;-tAKK9K[i;--  x <[iՖ  ij #";n.>;/N]L-   iZ-   piwh-   --hYpM ZK- N=qJ.(.5;~-4J   - -KՖ j  %j -i<;     #{Z ᖥyk{''~,./-/-/-/-/-/-/-/-/-/-,   ;    - .#,~;s[% m ;~   i1 #~ ZZZx- CZZ{{{{ZZ-OZk  JY( - i #2P4,KL/N]=@- $ Az Q,k -`,C[   - ------ - -q ,KjZ1- z .- - [ yi ~ [Z  ~K<-A  jj@  y ~Z ~K< Z2[G  < |Z}-[x; < Z-[7 -=   <  Y-< '  Tw    ,,  V;    (    )     ,i  J/xx4,;44;xKZsj #ZZK <,  Bi #i);[-(h-[-~-P[, w2MxJ'=i #i;--`yyyyyyyyyyxji Q(6,i"/  -Z%[i $;$_i -,i # h Z!"ah  Ai #i3;Q-2h-Q/i -l~-K-T,q777q777mLo $o 7vo $@7q77qpIKJq77w7mNo  7UpMrrmTo 7zo 7{pRSq777q77q 7777q77q777kq777kq777r~q77Y7Zrr{meo 7o 7o 7o 7F pdcban:ao q777mjo  7piDD D D DD DDDDD D D D D D D DD)D*D7B7L7) !7     7177h7N 7`7  777 797747U7r 7757?+?777M$     7 7; 7 7!77 7s 77w7?7777 7 7 7/77* 77797B77-??     77797B77 717 7 *7<#75JMKHILSRQPONUTVXYWZ[ "!77?*7777787 7 77M77     $$7 7M77x7d7ddd777$77777! 7# 7l 77 7&   77 73 7 77 7 7 77771757W D7)7\7                      # $   (*        389  :;<!=^ _f gm 6<s          ܫ ط            !  М П ԫܮܲܵ !  IJ ܲ    +C ԆԉЍ ܗ ܝ Ъԭ̮دԱԲ̴صķԹԺ8+     ́؂čԗ؟   ȩ ԰ б ĸ        )  ̅̈ȏЗؤ ص Ծ    + p),8G#\`"d f  +  K *c  "+la: /system/framework/core.odex^  p*5|T/system/framework/ext.odex#Z~"bha!/system/framework/framework.odexpP]+\ &/system/framework/android.policy.odexWK^>f ڋLh /system/framework/services.odex q_NH'w%au )/system/framework/com.htc.framework.odexuv2 8~9m./system/framework/com.htc.android.pimlib.odex[P@r fq u//system/framework/com.htc.android.easopen.odexyb5xհi/4/system/framework/com.scalado.util.ScaladoUtil.odexQD:(fr\93LEPKLC$