| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/3628/task/3630/root/usr/bin/ |
Upload File : |
ELF 4 4 ( 4 44 4 44 0 0
00 H HHD D Ptd( ( ( L L Qtd /lib/ld-linux.so.2 GNU GNU ."&ߛvPfr/P Q p Q T Y |( CEK8 qX fUa f z # X x ? T 7 2 k q J D > ] d . n ; R C F ? h z * & d 4 = = < < < W < L p O z OF ' OQ ORzp O^ N Ow \ OI ZD `Y ZD 0, ZD , [D 8[D* D[D 0ב [D ֑ [D 0- [D ۑ [D . <\D ̑ <x < =< `Y p 5 t 0, , B , * 0- . 8 * / / /
/ 0 00 40
80 ϒ ϒ ϒ В * В * T t x A $ =( , < <p < ȏ u <0u =hu `Y u 0, u , 0u 4 @u * |u 0- u * T Oy Oy Oy Oy Oy p Oy p ii
ii
$ ii
. ii
8 ti B 0 <U <W =R 1 1 1 1 1 1 $1 (1 ,1 01
41 81
<1 @1 D1 H1 L1 P1 T1 X1 \1 `1 d1 h1 l1 p1 t1 x1 |1 1 1 1! 1" 1# 1$ 1% 1& 1' 1( 1) 1* 1+ 1, 1- 1. 1/ 10 11 12 13 14 15 16 17 18 19 1: 1; 1< 1= 1> 2? 2@ 2A 2B 2C 2D 2E 2F 2G $2H (2I ,2J 02K 42L 82M <2N @2O D2P US [Ä t c X[51%1 % 1h %1h %1h %1h % 1h % 1h( %$1h0 %(1h8 p%,1h@ `%01hH P%41hP @%81hX 0%<1h` %@1hh %D1hp %H1hx %L1h %P1h %T1h %X1h %\1h %`1h %d1h %h1h p%l1h `%p1h P%t1h @%x1h 0%|1h %1h %1h %1h %1h %1h %1h %1h %1h %1h( %1h0 %1h8 p%1h@ `%1hH P%1hP @%1hX 0%1h` %1hh %1hp %1hx %1h %1h %1h %1h %1h %1h %1h %1h p%1h `%1h P%1h @%1h 0%1h % 2h %2h %2h % 2h %2h %2h %2h % 2h % 2h( %$2h0 %(2h8 p%,2h@ `%02hH P%42hP @%82hX 0%<2h` %@2hh %D2hp 1^PTRhh QVh`?USd$== u@ 0=-0X9s t& =0=9r=d$[]Ð& Ud$0t t $0ÐUEPE H1]Í UE]@Í ' U1]É' Ud$UEUPU U@ ' U1ɉWV1Sd$E u|f]I]ta\uInt`ttkrtvrЉwTzЉwItTzЉwITf0 d$[^_]Ð
n ^
N& ' USÍd$t7UUDA u//tR-uS{-uM[u%t& d$ []Ät[ut& <
tt& [<
tڄuȀ{*t d$1[]CtSt& Rt<*u</u럍& Ud$E$1Ív ' USÍd$ $l d$[]
USd$]C$:C$/C $$ $,d$1[]Ív UWV1SӍd$ԉE: t@8 u)ށ?UE tE8 t@8 u+E%?EEɍ|tt118 @9uUM܉|$$EMtEtNU
t,1@9t
8 Ru@
9Ru
B Ed$,[^_]ÐEEt$\$$BED8 Ed$,[^_]Í& ' Ud$؉L$$]u}É։ 3u |$4$BD$T$ $"]u}]Ðt& tu $]u}]Ð|$4$D$ $D$ D$]u}]Ív |$4$\\$ $]u}]Ív Ud$MUɋE uR 1Ív tIR 1Ít& R11fUd$(=D$ D$D$E$Ív UWVSd$ċ]S EU{C t$d E Ct$d C$d D$ C$~ UBpD$ C$jD$t$$ &ƅtxUD$ |$ D$t$B $zE܉4$E܅7d$<[^_]Ív UB@$D$뗍v d$<C[^_] 뽐D$ C$D$ C$Ut$D$B@$_tUED$ D$ D$t$B $E܉4$E܅E1C0&v ' Ud$ȉ]]u};C CsC D$ t$ D$D$ G $#t]u}]f]u]}] UWVESd$]D$ ED$ED$ D$$E fED$ $eEԋED$ $/NjE D$|$$D$ƋCD$$SẺ4$vE̅uwEԉ|$D$$PƉD$ED$ D$ D$ $4$'E$d;E$EЍd$L[^_]Ít& EЋEЍd$L[^_]É' Ud$$ M t) @ @ @ @ U 1҉Í& UWV2Sd$}~:2 U1z t& D$<$CD[utY$ ø t/ C C E C sF D$E$+Ud$ [^_]Ðt& Ud$D$ ]]u $D$ D$ D$ $]Eu] ' Ud$D$ E]u}$}:ƅtR$G$UU\$T$ D$$'m]u]}]& $FD$$6]u}]Í& UWVSd$ԋ]u$Nj$ÍD $ "P~+ t& 9t
?"Ru"9ߍRu"B D$4$ED$ D$qEEd$,[^_].& ' UWVSd$}E] E$PE$E [E ]E E E UUԃ}U~SE+EԉE v $E$g;ED$U؋ET$$tv[9] ]9]}'DEĉD$ẺU$!U E̋ẺT$EЋU؉T$$*uԋE9E~:]7& \$2E؋$z1E ŰE\$T$D$ $ỦUd$L[^_]UUd$L[^_]1UWVSd$D$
D$ $ Et V8ۋ Ru9u,V:u V:uE Ed$,[^_]Ð.9uF:/uF:0uF:1t& UWVSd$a$teXt^; ؾ tf@8 u)%?p4$vt \$t$$~d$ [^_]Ív 1ۍd$ [^_]Ív $2t뎍 UVSÍEd$ЋuD$ D$ D$L$$u~Utw$ldu_t t$ D$D$ $ED$ $$D$ D$7D$ $E$
dtE$]d$0[^]Ðt& Ud$} ]u}Et ]u}]Ðt& UԿ<uԋXPEL8 j
u$ u u_u^! EԉT$ D$D$$UÉD$ D$ D$ B $z $r1)v MT$ D$7D$ A $FE & t]u}1]Ð1ɺ1E " U1ɺuD$ ED$D$ \$$Ɖ $gM\1ɺ1uù" 1Udt¹' R1ɺؾ =ËE$duYދED$ $1ɺڹ" ËE$d 1ɺ%1ËE$ $7 t& MD$wD$ A $E f D$D$ F Ủ$zF Uv 1ɺ:
v g1ɺ(" U UMЉÉB $ً t $]11ɺZËF $ ĐUWVSÍd$D$$" f7t`\
+ Dp@uJ D$6t$ D$ $P7u\$$" d$ [^_]Ðt& \$4$lg& \$$\ P\$$\ @;v \$$\ (\$$t v \$$\ \$$n v \$$\ \$$r v USÍd$܋ td$$[]Ð \$$$= $?t3$=tq$* D$ $d$$[]Ð$=D$ D$ D$`D$ D$ D$ D$<$1$D$ D$ <D$D$ $|$ $=뺉' UWVSӍd$ԉE@ t$MA 84WE 1ɄtF1BIRt24wu<_t<'E uBIRuԍ UDQ$MA u11҅u`3t;ߍKt& ΄ۍIt >'Ru'RۍIuMt8'z8 d$,[^_]Ð 'f 땐t& <_E
E <D$HD$ $$ $t& UWVSӍd$E܉Mԅҋ@ EY E܋M܃ 1҉M@ E} tv @8 u+U? tN1 u@U v @ 4 u :Mu߃}tUĉ9ҋ}uɐE$" D$tFs}! |$$vt <"u|$$" ύ& U$" T$}ԅt(M܋E܃ D$D$ D$ A $d$L[^_]Ðt& M؉\$ D$D$ $i뢋E܋UT D$D$ D$ $@vt& ' Ud$$=0= tEMt& Í Ud$D$ D$ D$ХT$]u}Ë $j t]u}]Ít& ? d tt& @8 u)%?d$t|$ D$XD$$ EU\$ T$D$ D$Х$ƋU$]u}]fUWVSd$]u{ C$CPSu
{ }g D$D$ C $} ' T E U؉]܋MD$D$ A $UEM܋ D]؋I M < 1& t& @<<t_ D$ E\$D$D$ $< &l ED$D$ $\3eU܋R UMD$D$ $EE9E ]D$D$ C $sd$L1[^_]ËCPSun{ th} ~GS 1UҋC D_ED$D$ D$ C $
9} D$VD$ C $uo} ~IT { U1MC vDU|$ D$D$ C $9u D$VD$ C $xd$L1[^_]ËCPSuV{ tP} ~/E 1E҉D1;}J9} D$VD$ C $
M} b} 1}ߋ]1;uv9u 1UF} E ~I]1 D1ɉЀ: tt& @8 u)с?9ˍL;} ulj]]CPS~D$VD$ C $;} T 1UuMDED$D$L$ D$oD$ C UЉ$9} UeCPSn } U T E1Uc D8 & R: u)? E EE E1ɉE8 t @8 u+M?9Mуcm Kt>39}VDD$D$T$T$ D$yD$ C $9} { tg} ~a} 1fc
9V3D$DT$D$T$ D$yD$ C v$^9u U} E T UE1Y E;u3VL$DDžDUD$T$L$ D$yD$ C v$9u bc
{uEt1E܀} tt& @8 u)ׁ?9d1ɀ} V@8 u)с??CPSuW{ tQ} ~KU K MU1;}VEED$D$ D$)D$ C $9} ƋE} u} T S EU11{ D$VD$ C $v9u +MD$DED$ D$ C $s9}ED$D$ D$ C $M롍v 1<Et& UD$D$ $ DUC D$D$ D$ C $} E ]ԃ}UME,EEEE܉E܋ + -U؉ U.8EUDG NFDwt@Dwu. E e UԋE܉\$D$ D$)D$ B $EE9E ]D$D$ C $V&fT4f E
2M܉M8} MԄҋq 1ɍ& 'P@u D$D$ 4$*ft11<'tq;<'t@u\$ D$D$ 4$D$D$ 4$v \$|$ D$D$ 4$\;D$D$ 4$[b1M܋I MKsM\$ D$D$ 4$JIp@<- <+ DGvDGuD$D$ C $AUԋM܉L$ D$D$ B $ME <UԉD$ D$D$ B $@DO@Dwu)v/D$D$ C $B} ~,1D$D$ D$ C $9} D$D$ C $ Ud$ȉuu ]]thCu
tt]u1]Ív suK urEED$ D$ ED$C$b]u1]Í SuCED$ <D$ D$ $Adt& ED$ D$ D$ D$$]u1]Ív UWVS1ۍd$ԉE$d Ed taE4 D$E)؉4$D$mt> tot& F[vu|
t3Cc9EE<$D dED$ud$,[^_]Ít& [ <$[\$Ǎd$,[^_]Åuc 뢅t Љ<$1뮐t& UW VS$e E1Dž rt& u { [; u+?~ bH du ex g h/ i
l D$NÉD$$ 1Dž E8\$D$ t$$2 D$ D$ & 1~ t& XˉDJ vuۉK" '~ tOҋ3DV ORDF IτuዅV48ۉt39teT ɍR9tN
ɉuꋅ48"u냉 [ 붃 D$}NÉD$$ D$NÉ$D$V D$NÉ4$D$)N D$ 3D$<D$ $L1Me3
4 $| [^_]Ã N9
$D$&E St$ D$D$$@ D$d 4$stÉ4$et/$D$ <D$
D$ $A$1 N9u t| =1ƅƅDžb ds D$NÉ4$D$Tu~tu G12
N9 D$9NÉD$$n e D$NÉD$$u
D$NÉ$D$z
*
h Bl ǂh Bp B4t d Ɖ1Dž B Dž Dž Dž Dž Dž: Dž D$D$D$"D$ $TZD$ D$
<D$ $$w1&ml n
D$"NÉ<$D$ D$ D$T D$D$$ 1ƅ 1ƅ Dž FD$>D$ B $A D$ D$ D$ D$R$% t& t(= F $ [;(= | D$ D$ D$ D$$QD$D$ A $1?\$ D$<D$ $h$ D$NÉ<$D$r tg Z D$dNÉ$D$- \t (=D$ D$8D$D$ D$$(= t/D$ <D$
D$ $?$1 19
<t 1Ҁ? t@8 u)?9L[ƃ.AA1gҹ Dž T: w Ӎ[; u)Ӂ?sF
N9J $D$NÉD$& N9 Dž 9( Dž Dž@D$$@ $1h C $ v T$ D$ifDž
Dž w D$ZNÉ<$D$ D$
D$ $|D0[c9 D$ NÉ<$D$u
D$NÉ4$D$d|Dž B (=Dž Dž D$D$D$
D$ $(= f D$NÉ $D$[; u) ?D$j4$NÉD$2 D$4$NÉD$ D$p4$NÉD$t' D$4$NÉD$ 1F J D$rNÉ $D$vudt[>D$
D$ $D$$1+D$ T$ D$zNÉ4$D$ut,=1D$lD$ G $G
h Q4 1 G G @4 @8
@< @@ @D @H
@L @P
1*1C $1D$ D$D$D$ D$$D$ D$ D$`D$ D$ D$ D$$D$ D$ D$D$D$ D$D$$YD$ PD$D$ D$ D$ D$ D$$\$ D$<D$$Dž D$ D$ D$ D$` $yD$ t$ D$ $ft$ D$D$< $kBt$ D$hD$ $G D$ D$ D$ D$( $D$ D$ D$ D$ $觿t$ D$|D$ $Dž D$ t$ D$D$$G^Dž D$ t$ D$D$@ $ %o D$NÉD$$ B ; =t$ֿD$ $ =A D$D$$ [1jp D$NÉ4$D$2WED$ D$$=ڽD$ D$$=诽1P FÉ O\9ډ 1ލ 9o@9|`É93NЋ<>T$D$k$ DD$D$ ̼;~D$V$ 誼h $D$_C toD$D$ $ D$蕿1quh D$NÉ<$D$pD$D$ <D$ $茻 =C 13rx s@ D$NÉ<$D$
Dž B Nj1Dž Dž u ] vۋ<0 uD$ $ D$+ $ƾ Dž D$ Dž DžD$Dž D$ $
D$NÉ<$D$贽u
D$>NÉD$$~Cz D$ ED$GD$D$ B $膹h D$ ED$GD$D$ A $M D$ ED$G\$D$ G $GD$ D$GD$ D$G $D$ "D$RD$ G $ŸG T D$VD$ G $蚸 R: u)D$ ?D$GD$ DD$B $JD$ D$RD$ A $! C :D$VD$ C $D$ ZD$RD$ C $1ʷ'D$ D$`D$ [F $蠷dtD4uыD$VD$ F $r1!D$ D$ D$D$$ غ1D$\$ D$D$|
$蝷 D$NÉD$$vu
D$NÉ$D$@eXk $D$蠺1D$ D$t$$U D$d $tuxtI$d <ϋD$S$tl $y1X $:<D$D$ $}7 $e&vvŋD$D$ <D$ $+1$tD$ D$
(=D$T$ D$D$p $Y(= nD$ Dž Dž DžDž D$D$ <$8$襷D$ D$
Ȁ8 to@D$d4$NÉD$芷 G vAˉl t Aǁh p ߹d +%? $&\$诵É? t=D$^4$NÉD$ݶ @ 1D$ D$t$ \$$賶Ɖ $ٳ $=$$D$ D$
<D$ $裲$腴1DD$,
<D$ $q D$NÉ4$D$ w B $8Ƌ$)߁?w$D$9L$ D$<$b@8 u)ع %?,B?@IR9|)D D$ D$|$ \$$*lj $谲F D$S $b} $O D$ D$ D$ D$l${Dž = 31<
t V 9 1ۋ[D$D$ D$ \$$藲9Ћ$赲$ׯË$gE$=$rGD$ <D$
D$ $Ưh D$x4$NӉT$W D$4$N|$5th D$4$NÉD$ F t11C D$@ $ D$菲1A D$D$L <<
A:B t[ L$D$ $;u؍v 9~؉뵋{<$豯$$%D$ D$ D$ \$$詮1$=$UD$ <D$
D$ $ԭ$趯 r4$~1]D$V\$ <T$t$L$\$ D$T
D$ $Or4$蜮& UWV1S1ۍ$ Dž e E1Dž Dž Dž ! a = # =2 A $ $̭t
> =u=$A 8 ~ 0=t 0= Q > ;. t& 苭ߋ
& DB u/ $<g 1Ҁ; tt& @8 u)ځ? 4$ DD$芫Ƌ <8
\$$BD$# щ+ "1?;t @9
<;u4$y B '=,= |D$ L$D$t$ $
,=Dž' UD$ D$T$$d 购| D$ D$E$ D$G|$٪Dž| 4$1 1& B $? $ ~<t& t 4$赪 $譪Ue3 5 $ [^_]Ív \$D$ $ p v t1Ʌ G<o,GB t* <>; D 4$G f; ҋDQ tP{ҍ@DQ uِt& I9 u)ف?A$Ƌ AD$\$4$ & $踫{v G8<t$ D$D$ $w| =2MD$L$$d ͪ4$ L$B@+L=$<+H=ۅ$$8+D= ۅ$$ɋ4\$+@=ۅ$$D$ۅ$$ \$2D$@=$ 蝧 $踩D$ MD$L$$ 虦e=D$D$ <D$ $$ B
<D$D$ $$ t& UWVS$E e $L 1҉D$<D$@ \$D=D$ D$ $>D$T fD$d| D$\ D$D$=$ D$
D$=$ Ϩ$ 2D$ $ ED$8 L$<Q:- D$4 Cֿ! tC, uT$<@T$4@9D$8~(\$<:-u ֿ u@9D$89E L$<@9E$H \$<D$0 =D$ D$P$H $蛥 T$41 \$4D$S $1t 2. ڍD$D $諥4$3}~uT$<BD$8, 8-tZfRR9U~ML$<8-uAx-XEع ދ|$8tп] R9UD$T t& |$0 \$0;. D$DƼD$@T$0D$D$DD$ D$DD$T$$誣: 11ҍD$D蕽$=t$tT $L e3
K $T [^_]ÿc uD$T v i uD$T v o uD$T v w | ! | }
D$\ :& DŽ$H D$0 }D$@D$ D$<D$ $蛡$ ϥ& $=$ۤD$ <D$ D$ $Zyt& D$D1պT$4$t ; f tt& @8 u)%?p$D$4z L$44$L$\$ D$2t $,t$4v D$4D$?D$$ D$T fD$d, D$\ 524 [D$D$D$ 賠莳Z > tt& @8 u)%?Xډ$ $t$ D$D$蒣<$Z1ҍD$D$d 衢<$號<$!4$L$<R\$dD$ D$D$T$,\$$ T$,L$<R$ D$ D$D$뼸 D$4 <D$D& t u. = JD$H =1ҍD$DD$ $T$,T$, D$ $T$,ԢT$,u:2 =D$dD$ <D$ $gD$ $T$,~T$,u32 "D$D$ $ 1x7D$ $3 D$ $ =\$D$ <D$D$ $ 贝<D$ D$ $藝T$Dg$ 軡膠=D$D$ =D$D$ <D$ $:D$ D$uU]Ít& ' UWVSO < 7 )t$1ED$E D$E$ 9rރ [^_]Ë $ÐUSd$ 0t 0[Ћud$[]ÐUS [H< Y[ SELECT name FROM sqlite_temp_master WHERE type=%Q SELECT name FROM %Q.sqlite_master WHERE type=%Q DELETE FROM temp.fkey WHERE from_tbl = %Q AND fkid = %d INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','%q','%q',0,'%q'); Unable to open database "%s": %s
--------------------------------------------------------------------------------------------- SELECT name, type, sql FROM sqlite_master WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence' SELECT name, type, sql FROM sqlite_master WHERE name=='sqlite_sequence' SELECT sql FROM sqlite_master WHERE sql NOT NULL AND type IN ('index','trigger','view') SELECT name, type, sql FROM sqlite_master WHERE tbl_name LIKE shellstatic() AND type=='table' AND sql NOT NULL SELECT sql FROM sqlite_master WHERE sql NOT NULL AND type IN ('index','trigger','view') AND tbl_name LIKE shellstatic() CREATE VIRTUAL TABLE temp.v_fkey USING schema(foreign_key_list);CREATE VIRTUAL TABLE temp.v_col USING schema(table_info);CREATE VIRTUAL TABLE temp.v_idxlist USING schema(index_list);CREATE VIRTUAL TABLE temp.v_idxinfo USING schema(index_info);CREATE VIRTUAL TABLE temp.v_triggers USING schema(trigger_list);CREATE TABLE temp.fkey AS SELECT from_tbl, to_tbl, fkid, from_col, to_col, on_update, on_delete FROM temp.v_fkey WHERE database = 'main'; SELECT fkid, from_tbl FROM temp.fkey WHERE to_col IS NOT NULL AND NOT EXISTS (SELECT 1 FROM temp.v_col WHERE tablename=to_tbl AND name==to_col) foreign key columns do not exist SELECT fkid, from_tbl FROM temp.fkey WHERE to_col IS NULL GROUP BY fkid, from_tbl HAVING count(*) > 1 implicit mapping to composite primary key SELECT fkid, from_tbl FROM temp.fkey WHERE to_col IS NULL AND NOT EXISTS (SELECT 1 FROM temp.v_col WHERE pk AND tablename = temp.fkey.to_tbl) implicit mapping to non-existant primary key UPDATE temp.fkey SET to_col = (SELECT name FROM temp.v_col WHERE pk AND tablename=temp.fkey.to_tbl) WHERE to_col IS NULL; CREATE TABLE temp.idx2 AS SELECT il.tablename AS tablename,ii.indexname AS indexname,ii.name AS col FROM temp.v_idxlist AS il, temp.v_idxinfo AS ii WHERE il.isunique AND il.database='main' AND ii.indexname = il.name;INSERT INTO temp.idx2 SELECT tablename, 'pk', name FROM temp.v_col WHERE pk;CREATE TABLE temp.idx AS SELECT tablename, indexname, sj(dq(col),',') AS cols FROM (SELECT * FROM temp.idx2 ORDER BY col) GROUP BY tablename, indexname;CREATE TABLE temp.fkey2 AS SELECT fkid, from_tbl, to_tbl, sj(dq(to_col),',') AS cols FROM (SELECT * FROM temp.fkey ORDER BY to_col) GROUP BY fkid, from_tbl;CREATE TABLE temp.triggers AS SELECT triggername FROM temp.v_triggers WHERE database='main' AND triggername LIKE 'genfkey%'; SELECT fkid, from_tbl FROM temp.fkey2 WHERE NOT EXISTS (SELECT 1 FROM temp.idx WHERE tablename=to_tbl AND fkey2.cols==idx.cols) SELECT 'DROP TRIGGER main.' || dq(triggername) || ';' FROM triggers SELECT multireplace('-- Triggers for foreign key mapping:
--
-- /from_readable/ REFERENCES /to_readable/
-- on delete /on_delete/
-- on update /on_update/
--
CREATE TRIGGER /name/_insert_referencing BEFORE INSERT ON /tbl/ WHEN
/key_notnull/ AND NOT EXISTS (SELECT 1 FROM /ref/ WHERE /cond1/)
BEGIN
SELECT RAISE(ABORT, ''constraint failed'');
END;
CREATE TRIGGER /name/_update_referencing BEFORE
UPDATE OF /rkey_list/ ON /tbl/ WHEN
/key_notnull/ AND
NOT EXISTS (SELECT 1 FROM /ref/ WHERE /cond1/)
BEGIN
SELECT RAISE(ABORT, ''constraint failed'');
END;
CREATE TRIGGER /name/_delete_referenced BEFORE DELETE ON /ref/ WHEN
EXISTS (SELECT 1 FROM /tbl/ WHERE /cond2/)
BEGIN
/delete_action/
END;
CREATE TRIGGER /name/_update_referenced AFTER
UPDATE OF /fkey_list/ ON /ref/ WHEN
EXISTS (SELECT 1 FROM /tbl/ WHERE /cond2/)
BEGIN
/update_action/
END;
', '/from_readable/', from_tbl || '(' || sj(from_col, ', ') || ')', '/to_readable/', to_tbl || '(' || sj(to_col, ', ') || ')', '/on_delete/', on_delete, '/on_update/', on_update, '/name/', 'genfkey' || min(rowid), '/tbl/', dq(from_tbl), '/ref/', dq(to_tbl), '/key_notnull/', sj('new.' || dq(from_col) || ' IS NOT NULL', ' AND '), '/fkey_list/', sj(to_col, ', '), '/rkey_list/', sj(from_col, ', '), '/cond1/', sj(multireplace('new./from/ == /to/', '/from/', dq(from_col), '/to/', dq(to_col)), ' AND '), '/cond2/', sj(multireplace('old./to/ == /from/', '/from/', dq(from_col), '/to/', dq(to_col)), ' AND '), '/update_action/', CASE on_update WHEN 'SET NULL' THEN multireplace('UPDATE /tbl/ SET /setlist/ WHERE /where/;' , '/setlist/', sj(from_col||' = NULL',', '), '/tbl/', dq(from_tbl), '/where/', sj(from_col||' = old.'||dq(to_col),' AND '))WHEN 'CASCADE' THEN multireplace('UPDATE /tbl/ SET /setlist/ WHERE /where/;' , '/setlist/', sj(dq(from_col)||' = new.'||dq(to_col),', '), '/tbl/', dq(from_tbl), '/where/', sj(dq(from_col)||' = old.'||dq(to_col),' AND '))ELSE 'SELECT RAISE(ABORT, ''constraint failed'');'END , '/delete_action/', CASE on_delete WHEN 'SET NULL' THEN multireplace('UPDATE /tbl/ SET /setlist/ WHERE /where/;' , '/setlist/', sj(from_col||' = NULL',', '), '/tbl/', dq(from_tbl), '/where/', sj(from_col||' = old.'||dq(to_col),' AND '))WHEN 'CASCADE' THEN multireplace('DELETE FROM /tbl/ WHERE /where/;' , '/tbl/', dq(from_tbl), '/where/', sj(dq(from_col)||' = old.'||dq(to_col),' AND '))ELSE 'SELECT RAISE(ABORT, ''constraint failed'');'END ) FROM temp.fkey GROUP BY from_tbl, fkid non-null separator required for import
%s line %d: expected %d columns of data but found %d
SELECT name FROM sqlite_master WHERE type='index' AND tbl_name LIKE shellstatic() UNION ALL SELECT name FROM sqlite_temp_master WHERE type='index' AND tbl_name LIKE shellstatic() ORDER BY 1 mode should be one of: column csv html insert line list tabs tcl
CREATE TABLE sqlite_master (
type text,
name text,
tbl_name text,
rootpage integer,
sql text
) CREATE TEMP TABLE sqlite_temp_master (
type text,
name text,
tbl_name text,
rootpage integer,
sql text
) SELECT sql FROM (SELECT sql sql, type type, tbl_name tbl_name, name name FROM sqlite_master UNION ALL SELECT sql, type, tbl_name, name FROM sqlite_temp_master) WHERE tbl_name LIKE shellstatic() AND type!='meta' AND sql NOTNULL ORDER BY substr(type,2,1), name SELECT sql FROM (SELECT sql sql, type type, tbl_name tbl_name, name name FROM sqlite_master UNION ALL SELECT sql, type, tbl_name, name FROM sqlite_temp_master) WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%'ORDER BY substr(type,2,1), name SELECT name FROM sqlite_master WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%'UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') ORDER BY 1 SELECT name FROM sqlite_master WHERE type IN ('table','view') AND name LIKE '%'||shellstatic()||'%' UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') AND name LIKE '%'||shellstatic()||'%' ORDER BY 1 unknown command or invalid arguments: "%s". Enter ".help" for help
%s: cannot locate your home directory!
Usage: %s [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
Use -help for a list of options.
SQLite version %s
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
CREATE TABLE x(database,tablename,cid,name,type,not_null,dflt_value,pk) PRAGMA %Q.foreign_key_list(%Q) CREATE TABLE x(database,from_tbl,fkid,seq,to_tbl,from_col,to_col,on_update,on_delete,match) CREATE TABLE x(database,tablename,seq,name,isunique) CREATE TABLE x(database,indexname,seqno,cid,name) CREATE TABLE x(database,triggername,dummy) SELECT 0, 'main' Error in table %s: %s %s%s%s yes HOME %s;
sqlite_sequence DELETE FROM sqlite_sequence;
sqlite_stat1 ANALYZE sqlite_master;
sqlite_ CREATE VIRTUAL TABLE PRAGMA writable_schema=ON;
table PRAGMA table_info( ); SELECT 'INSERT INTO ' || || ' VALUES(' || quote( ) || ',' || ) || ')' FROM \%03o shellstatic Out of memory!
%s ORDER BY rowid DESC %*s = %s
%-*.*s%s <TR> <TH>%s</TH> </TR>
<TD> </TD>
%.*s < & INSERT INTO %s VALUES( , %sNULL '%s' %.*s'' );
sql backup main Error: cannot open %s
Error: %s
databases PRAGMA database_list; dump BEGIN TRANSACTION;
PRAGMA writable_schema=ON PRAGMA writable_schema=OFF;
PRAGMA writable_schema=OFF COMMIT;
exit explain genfkey --no-drop --ignore-errors --exec dq multireplace sj schema foreign key is not unique headers import SELECT * FROM '%q' INSERT INTO '%q' VALUES(? rb cannot open file: %s
BEGIN ROLLBACK COMMIT indices load mode lines columns tcl tabs insert output stdout wb can't write to "%s"
prompt quit read can't open "%s"
restore source database is busy
sqlite_master sqlite_temp_master show off %9.9s: %s
%9.9s: width %d tables %s%-*s timeout timer :memory: out of memory
%s: out of memory!
CPU Time: user %f sys %f
SQL error near line %d: SQL error: %s %s
Incomplete SQL: %s
sqlite> ...> -separator -nullvalue -init %s/.sqliterc -- Loading resources from %s
-html -list -line -column -csv -header -noheader -echo -bail -version -interactive -batch --help OPTIONS include:
%s %s: unknown option: %s
SQL error: %s
%s/.sqlite_history error closing database: %s
table_info PRAGMA %Q.table_info(%Q) foreign_key_list index_list PRAGMA %Q.index_list(%Q) index_info index PRAGMA %Q.index_info(%Q) trigger_list trigger SELECT 1 semi lX϶϶4ȱòX -init filename read/process named file
-echo print commands before execution
-[no]header turn headers on or off
-bail stop after hitting an error
-interactive force interactive I/O
-batch force batch I/O
-column set output mode to 'column'
-csv set output mode to 'csv'
-html set output mode to HTML
-line set output mode to 'line'
-list set output mode to 'list'
-separator 'x' set output field separator (|)
-nullvalue 'text' set text string for NULL values
-version show SQLite version
jpd^x ư>;H ( 8xd Xx xx x x y XzH xzh z z | |@ 8}p h} X (H xh ( 8 $ ` H 84 d ( ؐ X P 8 zR | v AB
V < v AB
D \ v AD
A | v# AB
^ , v AD
DS
AAA B 0 |w AB
CL
A A y
A A x AB
R x! AB
CYA D x= AB
HpA 8 h 0x AB
DC
AAA B fAAA P y AB
V@
AF ]
AB s
AD c
A , yN AB
a
D S
E M ( y- AB
i < H y AB
J
AAA D h
AAA E 8 { AB
JHW
AC N
A 8 {7 AB
M
AAA E KAAA |I AB
E , } AB
GK
AAA F $ P }S AB
RFr
A4 x } AB
^R
AL g
A( 8~ AB
JAAA 8 ~ AB
Jw
AAA E KAAA , AB
DXd
AAA B < H AB
G_
AAA D I
AAA D $ AB
DAA 8 AB
VP
AF
AB , ] AB
CD
AAA F 0 , AB
CO
A B ]
A B , P | AB
E
AAA B , X AB
EG
AAA F $ ؉* AB
[
J A 4 AB
g`
AE
A< 0 AB
J
AAA A
AAA A @ P x AB
JI]
AD @
AG k
A < $ AB
E
AAA E _
AAA A 0 ė% AB
Fs
AAA A 0 \ AB
DC
AAA D L < AB
ru "u "u "
AAB
AA AB
A ( Z AB
NEAAA libsqlite3.so.0 __gmon_start__ _Jv_RegisterClasses sqlite3_prepare sqlite3_backup_step sqlite3_result_double sqlite3_result_int64 sqlite3_column_int64 sqlite3_backup_finish sqlite3_column_type sqlite3_free_table sqlite3_load_extension sqlite3_open sqlite3_column_count sqlite3_realloc sqlite3_result_null sqlite3_exec sqlite3_declare_vtab sqlite3_result_text sqlite3_interrupt sqlite3_errmsg sqlite3_busy_timeout sqlite3_sleep sqlite3_value_text sqlite3_column_double sqlite3_complete sqlite3_enable_load_extension sqlite3_libversion sqlite3_column_int sqlite3_snprintf sqlite3_malloc sqlite3_aggregate_context sqlite3_create_module sqlite3_close _fini sqlite3_reset sqlite3_mprintf sqlite3_get_table sqlite3_create_function sqlite3_step sqlite3_errcode sqlite3_free sqlite3_bind_text sqlite3_finalize sqlite3_result_error_nomem sqlite3_backup_init sqlite3_value_bytes sqlite3_column_text libreadline.so.6 write_history read_history readline stifle_history add_history libdl.so.2 libpthread.so.0 libc.so.6 _IO_stdin_used fflush __printf_chk exit _IO_putc fopen strncmp getpwuid strncpy signal __stack_chk_fail stdin strtol isatty fgets memset __fprintf_chk stdout fputc getrusage memcpy fclose getenv __ctype_b_loc stderr getuid __ctype_tolower_loc access strcmp __libc_start_main _edata __bss_start _end GLIBC_2.4 GLIBC_2.1 GLIBC_2.3 GLIBC_2.0 GLIBC_2.3.4 libtinfo.so.5 /lib/ld-linux.so.2 z p
o L' ԁ
N 1 x ؍ oxo ooto o o0 0 =`>=O<E?p@ == `)| = =Ж F PV| P 8Ah z `=F?P<q<O< ? w| p 0* `=Pu<`e { < _ =B? =Б<` pk # Љ=P=z=pS>A> E 0< @= i P<@Џ<0 =={ A@<` p=@AP <@ `<`= _| ?> (3L ]hh .backup ?DB? FILE Backup DB (default "main") to FILE
.bail ON|OFF Stop after hitting an error. Default OFF
.databases List names and files of attached databases
.dump ?TABLE? ... Dump the database in an SQL text format
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.explain ON|OFF Turn output mode suitable for EXPLAIN on or off.
.genfkey ?OPTIONS? Options are:
--no-drop: Do not drop old fkey triggers.
--ignore-errors: Ignore tables with fkey errors
--exec: Execute generated SQL immediately
See file tool/genfkey.README in the source
distribution for further information.
.header(s) ON|OFF Turn display of headers on or off
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indices TABLE Show names of all indices on TABLE
.load FILE ?ENTRY? Load an extension library
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator string
tabs Tab-separated values
tcl TCL list elements
.nullvalue STRING Print STRING in place of NULL values
.output FILENAME Send output to FILENAME
.output stdout Send output to the screen
.prompt MAIN CONTINUE Replace the standard prompts
.quit Exit this program
.read FILENAME Execute SQL in FILENAME
.restore ?DB? FILE Restore content of DB (default "main") from FILE
.schema ?TABLE? Show the CREATE statements
.separator STRING Change separator used by output mode and .import
.show Show the current values for various settings
.tables ?PATTERN? List names of tables matching a LIKE pattern
.timeout MS Try opening locked tables for MS milliseconds
.timer ON|OFF Turn the CPU timer measurement on or off
.width NUM NUM ... Set column widths for "column" mode
PИ` ` sqlite3.debug :ELF 4 ؽ 4 ( 4 44 4 44 L L 0 0
00 H HHD D Ptd( ( ( L L Qtd 44 HH ! hh $ 4 o H > ԁ F tt N N o [ o xx
` j ؍
s
x | pp 0 w _ t t H) ( ( L t t 0 0 0 0 0 1 H `2` p
<м м .shstrtab .interp .note.ABI-tag .note.gnu.build-id .gnu.hash .dynsym .dynstr .gnu.version .gnu.version_r .rel.dyn .rel.plt .init .text .fini .rodata .eh_frame_hdr .eh_frame .ctors .dtors .jcr .dynamic .got .got.plt .data .bss .gnu_debuglink .dynbss .gnu.liblist .gnu.conflict .gnu.prelink_undo 44 HH ! hh $ 4 o H > ԁ o tt 0 N o [ o xx
` j ؍
s
x
| pp 0 w _ t t H) ( ( L t t F L'L o 0 0 0 0 0 1 H `2` p
< $ = l '