SQLite format 3@ 0/ 4/rCtabledecksdecks CREATE TABLE decks ( id INTEGER NOT NULL, created FLOAT NOT NULL, modified FLOAT NOT NULL, description TEXT NOT NULL, version INTEGER NOT NULL, "currentModelId" INTEGER, "syncName" TEXT, "lastSync" FLOAT NOT NULL, "hardIntervalMin" FLOAT NOT NULL, "hardIntervalMax" FLOAT NOT NULL, "midIntervalMin" FLOAT NOT NULL, "midIntervalMax" FLOAT NOT NULL, "easyIntervalMin" FLOAT NOT NULL, "easyIntervalMax" FLOAT NOT NULL, delay0 INTEGER NOT NULL, delay1 INTEGER NOT NULL, delay2 FLOAT NOT NULL, "collapseTime" INTEGER NOT NULL, "highPriority" TEXT NOT NULL, "medPriority" TEXT NOT NULL, "lowPriority" TEXT NOT NULL, suspended TEXT NOT NULL, "newCardOrder" INTEGER NOT NULL, "newCardSpacing" INTEGER NOT NULL, "failedCardMax" INTEGER NOT NULL, "newCardsPerDay" INTEGER NOT NULL, "sessionRepLimit" INTEGER NOT NULL, "sessionTimeLimit" INTEGER NOT NULL, "utcOffset" FLOAT NOT NULL, "cardCount" INTEGER NOT NULL, "factCount" INTEGER NOT NULL, "failedNowCount" INTEGER NOT NULL, "failedSoonCount" INTEGER NOT NULL, "revCount" INTEGER NOT NULL, "newCount" INTEGER NOT NULL, "revCardOrder" INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY("currentModelId") REFERENCES models (id) )/%%!tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" ( "factId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("factId") REFERENCES facts (id) )vKtablefactsfactsCREATE TABLE facts ( id INTEGER NOT NULL, "modelId" INTEGER NOT NULL, created FLOAT NOT NULL, modified FLOAT NOT NULL, tags TEXT NOT NULL, "spaceUntil" FLOAT NOT NULL, "lastCardId" INTEGER, PRIMARY KEY (id), FOREIGN KEY("modelId") REFERENCES models (id), CONSTRAINT "lastCardIdfk" FOREIGN KEY("lastCardId") REFERENCES cards (id) )#!tablemodelsmodelsCREATE TABLE models ( id INTEGER NOT NULL, "deckId" INTEGER, created FLOAT NOT NULL, modified FLOAT NOT NULL, tags TEXT NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, features TEXT NOT NULL, spacing FLOAT NOT NULL, "initialSpacing" FLOAT NOT NULL, source INTEGER NOT NULL, PRIMARY KEY (id), CONSTRAINT "deckIdfk" FOREIGN KEY("deckId") REFERENCES decks (id) )`tablemediamediaCREATE TABLE media ( id INTEGER NOT NULL, filename TEXT NOT NULL, size INTEGER NOT NULL, created FLOAT NOT NULL, "originalPath" TEXT NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id) );''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" ( "cardId" INTEGER NOT NULL, time FLOAT NOT NULL, "lastInterval" FLOAT NOT NULL, "nextInterval" FLOAT NOT NULL, ease INTEGER NOT NULL, delay FLOAT NOT NULL, "lastFactor" FLOAT NOT NULL, "nextFactor" FLOAT NOT NULL, reps FLOAT NOT NULL, "thinkingTime" FLOAT NOT NULL, "yesCount" FLOAT NOT NULL, "noCount" FLOAT NOT NULL, PRIMARY KEY ("cardId", time) )9M'indexsqlite_autoindex_reviewHistory_1reviewHistoryJktablesourcessourcesCREATE TABLE sources ( id INTEGER NOT NULL, name TEXT NOT NULL, created FLOAT NOT NULL, "lastSync" FLOAT NOT NULL, "syncPeriod" INTEGER NOT NULL, PRI    4:b I z 2 c  K  p 'XAi!R ;c$IG4  E,A?7@g(nytm0@fffffh@fffffh@,߾xG3  %,bA?7q@J6tL.@fffffh@fffffh@&QG2  2j,=A?7@ T 䂜nSW@fffffh@fffffh@3ƨG1  ,LA?7 @ rhr@fffffh@fffffh@"gG0  k,A?7 E@d}2/xeOP@fffffh@fffffh@=/    E,A?7 J?EEs@@fffffh@:ƨF.   j,:nA?7?1jM?}JZD@@fffffh@K'F-   ,IA?6@oG?f-@@333335@|F,   #,JA?6@ GA?9@@fffffh@*`F+   7,mA?6z@AkѺ?i@@fffffh@)_xF*   Xa,ZA?6N?^BTl?5,؎@@fffffh@&`=)    %,bA?6y?ɲ6` @@fffffh@RF(   S,bA?6@参Nl?˙˩@@fffffh@_;`F'   ,A?6[?kz?ͦnc@@fffffh@=0F&   a@Q,A?6?:rX?n>2@@fffffh@_;`=%    2j,=A?6t?ο@y@@fffffh@3P F$   yU,A?6ȝ@R1@$9E@@fffffh@\ F#   &',|A?6@1#'@g@@fffffh@'F"   ,A?6?K2 Lb@\@@fffffh@1T9XF!   ,DA?6?[1@C@@fffffh@ xQF   S,A?6x?Z\4jۭ@ @@fffffh@,7F   V_,PA?6?TX@@@fffffh@<F   f!,EA?6@a @@þH3@@333335@#hF   k,3A?6@׮vN@u@@333335@%`G  e,A?6@|hyzH@@@oG  ,"A?60?ˑH9&xQd@@@`AG  ,gA?6x?A1CsGLX^@@@ @G  @G), A?6[@f9dpE6;@@@|G  6, A?6?_OP@@@8<F   [+,XA?6l@1il:@.E@@@=    e,A?6 @w{@@@-0 F   ,p>A?6f@wdy@]@@@@=    ,"A?6r@.@@@AlF   [fU,1A?6y?{@pr@@@8F   8Q,sPA?6sx?^p@@@@4<F   ,AA?6nA@ZeGYZ@ъn@@@0F   ?, iA?6l@a^#@Rm@@@pF   g ,A?6kf@b@ؠ@ vl@@@@=    ,gA?6i@'}'@@@31(F   1Q,ZA?6d@!*C L@w@@@0 ?   +y,.A?6b@!|\@Y@@F   &O,A?6^1@‘p@h@@@4`F   S,NA?6Y(?]l@V@@@2 F   1P, A?6Ti@!Lz^@eͿ@@@C HF   :a, A?6J@Ԓz@@Eȡ@@@:H1(F   .>a, QoA?6C?bv+@@@@CpF   , \A?6:6?ג`"r@ӹH'q@@@7 =    @G), A?64A@Ĩ}@@@P =    6, A?6#l@@@@g 4 W_  Agu3 m  {  9 + O #; Q }%  eI  E,A?74%,bA?7q32j,=A?72,LA?7 1k,A?7 E0E,A?7 J/j,:nA?7.,IA?6-#,JA?6,7,mA?6z+Xa,ZA?6N*%,bA?6y)S,bA?6(,A?6['a@Q,A?6&2j,=A?6t%yU,A?6ȝ$&',|A?6#,A?6",DA?6!S,A?6x V_,PA?6,LA?6),LA?6*k,A?6Ef!,EA?6k,3A?6e,A?6,"A?60,gA?6x@G), A?6[6, A?6[+,XA?6le,A?6 ,p>A?6f,"A?6r[fU,1A?6y8Q,sPA?6sx,AA?6nA?, iA?6l g ,A?6kf ,gA?6i 1Q,ZA?6d +y,.A?6b &O,A?6^1S,NA?6Y(1P, A?6Ti:a, A?6J.>a, QoA?6C, \A?6:6@G), A?64A 6, A?6#l  0圕  A=A=BasicSimple?< ( $. J x \ N2 ` $ 6 h B  t p F F F Բ➺ , A? j=qA?7b ҷ❼ , A?A?7b ❘ , A?5?A?- O , A?hA?^ ●y , A?B-A?8 鼲Ӡ , A?ɯwA?ɣƨ  , A?bA?{ D , A? ƨA?7 Ƴ⑴E , A?A?7V ␽ , A?^A?ָR ⏦ , A?OA?Hu ̒圮 , A=(A= ԟ圭j , A=A= 圩S , A=A=y ޏ圣h , A=~,A?7MV 圠 , A=a}A? 圥 , A=䇲A=䇩 圠` , A=f(A=f 圜> , A=J+A=J$׈圞 , A=OL> 圚| , A=.+A?'%/圤 , A=HL 圗 , A==A=6 圦 , A=A=| 圛 , A=8[A=8T 圞 , A=LA?4 Ȳ土L , A=ZA=Z ˒土 , A=VA=V 圡@ , A=lA=l 圚ю , A=1A=1 圞ڼ , A=RA=R 圧/ , A=IAAJ:7L څ圕 , A=mA=e ג圗 , A=*2A?)/l 圢 , A=qA=qX*圥[ , A=qA=i ձ圢^ , A=tAA=t8 ݲ圠x , A=^QA=^J*圥\ , A=䊳A?7 圣 , A=wA=wK Û圛 , A=>XA=>P 圥d , A=XA=P a,\A?7c,[A?7 ww%  -%# A=AAJ:6+, ?O;dZ? XXPriorityVeryHighPriorityHighPriorityLowX*0(( ""eѨ圕  , Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe圕   , Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFF ^W: Y rJktablesourcessourcesCREATE TABLE sources ( id INTEGER NOT NULL, name TEXT NOT NULL, created FLOAT NOT NULL, "lastSync" FLOAT NOT NULL, "syncPeriod" INTEGER NOT NULL, PRIMARY KEY (id) );''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" ( "cardId" INTEGER NOT NULL, time FLOAT NOT NULL, "lastInterval" FLOAT NOT NULL, "nextInterval" FLOAT NOT NULL, ease INTEGER NOT NULL, delay FLOAT NOT NULL, "lastFactor" FLOAT NOT NULL, "nextFactor" FLOAT NOT NULL, reps FLOAT NOT NULL, "thinkingTime" FLOAT NOT NULL, "yesCount" FLOAT NOT NULL, "noCount" FLOAT NOT NULL, PRIMARY KEY ("cardId", time) )9M'indexsqlite_autoindex_reviewHistory_1reviewHistory`tablemediamediaCREATE TABLE media ( id INTEGER NOT NULL, filename TEXT NOT NULL, size INTEGER NOT NULL, created FLOAT NOT NULL, "originalPath" TEXT NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id) )#!tablemodelsmodelsCREATE TABLE models ( id INTEGER NOT NULL, "deckId" INTEGER, created FLOAT NOT NULL, modified FLOAT NOT NULL, tags TEXT NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, features TEXT NOT NULL, spacing FLOAT NOT NULL, "initialSpacing" FLOAT NOT NULL, source INTEGER NOT NULL, PRIMARY KEY (id), CONSTRAINT "deckIdfk" FOREIGN KEY("deckId") REFERENCES decks (id) )vKtablefactsfactsCREATE TABLE facts ( id INTEGER NOT NULL, "modelId" INTEGER NOT NULL, created FLOAT NOT NULL, modified FLOAT NOT NULL, tags TEXT NOT NULL, "spaceUntil" FLOAT NOT NULL, "lastCardId" INTEGER, PRIMARY KEY (id), FOREIGN KEY("modelId") REFERENCES models (id), CONSTRAINT "lastCardIdfk" FOREIGN KEY("lastCardId") REFERENCES cards (id) )/%%!tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" ( "factId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("factId") REFERENCES facts (id) )rCtabledecksdecks CREATE TABLE decks ( id INTEGER NOT NULL, created FLOAT NOT NULL, modified FLOAT NOT NULL, description TEXT NOT NULL, version INTEGER NOT NULL, "currentModelId" INTEGER, "syncName" TEXT, "lastSync" FLOAT NOT NULL, "hardIntervalMin" FLOAT NOT NULL, "hardIntervalMax" FLOAT NOT NULL, "midIntervalMin" FLOAT NOT NULL, "midIntervalMax" FLOAT NOT NULL, "easyIntervalMin" FLOAT NOT NULL, "easyIntervalMax" FLOAT NOT NULL, delay0 INTEGER NOT NULL, delay1 INTEGER NOT NULL, delay2 FLOAT NOT NULL, "collapseTime" INTEGER NOT NULL, "highPriority" TEXT NOT NULL, "medPriority" TEXT NOT NULL, "lowPriority" TEXT NOT NULL, suspended TEXT NOT NULL, "newCardOrder" INTEGER NOT NULL, "newCardSpacing" INTEGER NOT NULL, "failedCardMax" INTEGER NOT NULL, "newCardsPerDay" INTEGER NOT NULL, "sessionRepLimit" INTEGER NOT NULL, "sessionTimeLimit" INTEGER NOT NULL, "utcOffset" FLOAT NOT NULL, "cardCount" INTEGER NOT NULL, "factCount" INTEGER NOT NULL, "failedNowCount" INTEGER NOT NULL, "failedSoonCount" INTEGER NOT NULL, "revCount" INTEGER NOT NULL, "newCount" INTEGER NOT NULL, "revCardOrder" INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY("currentModelId") REFERENCES models (id) )  G 1 !!-tablecardModelscardModels CREATE TABLE "cardModels" ( id INTEGER NOT NULL, ordinal INTEGER NOT NULL, "modelId" INTEGER NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, active BOOLEAN NOT NULL, qformat TEXT NOT NULL, aformat TEXT NOT NULL, lformat TEXT, qedformat TEXT, aedformat1 !!-tablecardModelscardModels CREATE TABLE "cardModels" ( id INTEGER NOT NULL, ordinal INTEGER NOT NULL, "modelId" INTEGER NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, active BOOLEAN NOT NULL, qformat TEXT NOT NULL, aformat TEXT NOT NULL, lformat TEXT, qedformat TEXT, aedformat TEXT, "questionInAnswer" BOOLEAN NOT NULL, "questionFontFamily" TEXT, "questionFontSize" INTEGER, "questionFontColour" VARCHAR(7), "questionAlign" INTEGER, "answerFontFamily" TEXT, "answerFontSize" INTEGER, "answerFontColour" VARCHAR(7), "answerAlign" INTEGER, "lastFontFamily" TEXT, "lastFontSize" INTEGER, "lastFontColour" VARCHAR(7), "editQuestionFontFamily" TEXT, "editQuestionFontSize" INTEGER, "editAnswerFontFamily" TEXT, "editAnswerFontSize" INTEGER, "allowEmptyAnswer" BOOLEAN NOT NULL, "typeAnswer" TEXT NOT NULL, PRIMARY KEY (id), FOREIGN KEY("modelId") REFERENCES models (id) ) tablecardscards CREATE TABLE cards ( id INTEGER NOT NULL, "factId" INTEGER NOT NULL, "cardModelId" INTEGER NOT NULL, created FLOAT NOT NULL, modified FLOAT NOT NULL, tags TEXT NOT NULL, ordinal INTEGER NOT NULL, question TEXT NOT NULL, answer TEXT NOT NULL, priority INTEGER NOT NULL, interval FLOAT NOT NULL, "lastInterval" FLOAT NOT NULL, due FLOAT NOT NULL, "lastDue" FLOAT NOT NULL, factor FLOAT NOT NULL, "lastFactor" FLOAT NOT NULL, "firstAnswered" FLOAT NOT NULL, reps INTEGER NOT NULL, successive INTEGER NOT NULL, "averageTime" FLOAT NOT NULL, "reviewTime" FLOAT NOT NULL, "youngEase0" INTEGER NOT NULL, "youngEase1" INTEGER NOT NULL, "youngEase2" INTEGER NOT NULL, "youngEase3" INTEGER NOT NULL, "youngEase4" INTEGER NOT NULL, "matureEase0" INTEGER NOT NULL, "matureEase1" INTEGER NOT NULL, "matureEase2" INTEGER NOT NULL, "matureEase3" INTEGER NOT NULL, "matureEase4" INTEGER NOT NULL, "yesCount" INTEGER NOT NULL, "noCount" INTEGER NOT NULL, "spaceUntil" FLOAT NOT NULL, "relativeDelay" FLOAT NOT NULL, "isDue" BOOLEAN NOT NULL, type INTEGER NOT NULL, "combinedDue" INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY("factId") REFERENCES facts (id), FOREIGN KEY("cardModelId") REFERENCES "cardModels" (id) )1 %%%tablemediaDeletedmediaDeletedCREATE TABLE "mediaDeleted" ( "mediaId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("mediaId") REFERENCES cards (id) )/ %%!tablecardsDeletedcardsDeletedCREATE TABLE "cardsDeleted" ( "cardId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("cardId") REFERENCES cards (id) )5 '')tablemodelsDeletedmodelsDeletedCREATE TABLE "modelsDeleted" ( "modelId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("modelId") REFERENCES models (id) )~##CtablefieldModelsfieldModelsCREATE TABLE "fieldModels" ( id INTEGER NOT NULL, ordinal INTEGER NOT NULL, "modelId" INTEGER NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, features TEXT NOT NULL, required BOOLEAN NOT NULL, "unique" BOOLEAN NOT NULL, numeric BOOLEAN NOT NULL, "quizFontFamily" TEXT, "quizFontSize" INTEGER, "quizFontColour" VARCHAR(7), "editFontFamily" TEXT, "editFontSize" INTEGER, PRIMARY KEY (id), FOREIGN KEY("modelId") REFERENCES models (id) )1 $@Ow 4Q@圞' ec ,!, A=LA=LPapaDadA=L@@A=LX圩D' {} w,/!, A=IA=Ila petite-fillethe grandaughterA=I@@A=IK土g' ks w,Z!, A=RA=Rle marithe husbandA=R@@A=R]圫(  ~_,S!, A=A=les petits-enfantsthe grandchildrenA=@@A=ρR圥L' wu a,\!, A=䊳A=䊴un beau-pèrea stepfatherA=䊳@@A=䊳ρI圥' ok ;,d!, A=XA=Xun enfanta childA=X@@A=XÁIݚ圤' sg wx,h!, A=~,A=~,des jumeauxtwinsA=~,@@A=~,Mن圠' os V, x!, A=^QA=^Qle frèrethe brotherA=^Q@@A=^Qf؍圗)   , !, A=mA=ml'arrière grand-pèrethe great-grandfatherA=m@@A=mYצ圢>( q ,"颡!, A=qA=qle cousin, la cousinethe cousinA=q@@A=qKՄ圚\' sk , !, A=*2A=*2Grand-pèreGrandadA=*2@@A=*2ZҔ圜' } l, 𼢡!, A=>XA=>Xles grand-parentsthe grandparentsA=>X@@A=>XR圧' wu /,Q!, A=A=|le petit-filsthe grandsonA=@@A=UШ圢( m ',@!, A=lA=lla femme, l'épousethe wifeA=l@@A=lIϷ圣' mm į,p^!, A=tAA=tAla tantethe auntA=tA@@A=tAT圦' {u c,[!, A=qA=qune belle-mèrea stepmotherA=q@@A=qKĨ圥L' oo Xo,!, A=䇲A=䇲la niècethe nieceA=䇲@@A=䇲PĒ圥E' su w?,3!, A=HA=Hles enfantsthe childrenA=H.Ԁ圛-圥  ,LA?7V_,PA?7  ǟ圕 , Front圕  , Back3B{F f >  h C   T  t =  S !e$k8 u<;V+vN'~I^60圥\-a,\, un beau-père re%圧/+w,/, la petite-fille土2Y,, l'oncle圢^į,p^, la tante"圛 %Yc, , the daughter"ْ圦 %/,Q, the grandson$⑴E)S,E, un demi-frère$⑴E )S,E, a half-brother-圮 ;jna,|㝂, the great-granddaughter+圢7,", le cousin, la cousine圣h wx,h, twins!圞#1\C,., les parents圚юi, Q, la soeur'❼ /I,, the sister-in-lawʀ圥d ;,d, a child圢^ į,p^, the aunt 圚ю !i, Q, the sister ❘ !,, the father!圞 #1\C,., the parents,圕9, , l'arrière grand-père!圚|#,o, |, Grand-mère!圠x #V, x, the brother!圣h#wx,h, des jumeaux$圗), ֻ, le grand-père"圤 %w?,3, the children+Խ圕 7, , the great-grandfather:ղ●yU G,y, les beaux-parents (d'un(e) marié(e)圣[,, le fils7❼OI,, la belle-soeur (d'un(e) marié(e)ٰ圞ڼw,Z, le mari$⏦ )_,, the stepfather/圛?Yc, , la fille (de ses parents)ԯ圠xV, x, le frère6●y M G,y, the parents-in-law / the in-laws$ӪD)g,D, une demi-soeur"圥[ %c,[, a stepmother)ظ圡@3',@, la femme, l'épouse'Ӹ圗 /, , Grandad / GrandpaϿ圥 Xo,, the niece$␽ )H,=, the stepmother'圩S /~_,S, the grandchildren7ӠOy,Ӡ, la belle mère (d'un(e) marié(e)0␽AH,=, la belle-mère (remariage)#D 'g,D, a half-sister圠`> ,s`, le neveu#¿圦'/,Q, le petit-fils(圭j 1~ ,j, the great-grandson+޲圜> 73c,N>, the great-grandmother圞,, Papa&圚| -,o, |, Grandma / Granny(圩S1~_,S, les petits-enfants%圥[+c,[, une belle-mère-圮;jna,|, l'arrière-petite-fille!圤#w?,3, les enfantsʲ圣 [,, the son&í圧/ -w,/, the grandaughter꘲O,nO, la mère,򌻒圜>93c,N>, l'arrière-grand-mère!圗#, , Grand-père6MJG,bƻ, le beau-père (d'un(e) marié(e)圥d;,d, un enfant'² /JG,bƝ, the father-in-law 土L!C,L, la famille妤圠rG,Aл, Maman圥Xo,, la nièce'圛/l, , les grand-parents圡@ ',@, the wife ܴ˲土L !C,L, the family ׸圠` !> ,s`, the nephewڧ❘,, le père'ٖ➺ /,:, the sister-in-law ءP !,nO, the mother!圞ڼ #w,Z, the husband'׵Ӡ /y,Ӡ, the mother-in-lawڲ土 2Y,, the uncle+ԗ圭j7~ ,j, l'arrière-petit-fils Φ圢 !,"靂, the cousin&Δ圛 -l, 𼝂, the grandparents7΅ڲ➺O,:, le beau-frère (d'un(e) marié(e)"Ś圥\ %a,\, a stepfather%圗 +, ֝, the grandfather/‡⏦?_,, le beau-père (remariage)!圞 #,, Dad / Daddy!ɛ圠 #rG,AН, 2␽ Xt ! 2010-12-060@3+UU@A : !2010-12-064@2bM؞@x  :!2010-12-024@2t;@w`  " !2010-12-05" !2010-12-02" !2010-12-12  K |   | IH  l .  u Pusl"9%indexix_mediaDele +##eviewrevC-))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as select * from cards where type = 1 and isDue = 1 order by priority desc, factId, ordinal{tablestatsstatsCREATE TABLE stats ( id INTEGER NOT NULL, type INTEGER NOT NULL, day DATE NOT NULL, reps INTEGER NOT NULL, "averageTime" FLOAT NOT NULL, "reviewTime" FLOAT NOT NULL, "distractedTime" FLOAT NOT NULL, "distractedReps" INTEGER NOT NULL, "newEase0" INTEGER NOT NULL, "newEase1" INTEGER NOT NULL, "newEase2" INTEGER NOT NULL, "newEase3" INTEGER NOT NULL, "newEase4" INTEGER NOT NULL, "youngEase0" INTEGER NOT NULL, "youngEase1" INTEGER NOT NULL, "youngEase2" INTEGER NOT NULL, "youngEase3" INTEGER NOT NULL, "youngEase4" INTEGER NOT NULL, "matureEase0" INTEGER NOT NULL, "matureEase1" INTEGER NOT NULL, "matureEase2" INTEGER NOT NULL, "matureEase3" INTEGER NOT NULL, "matureEase4" INTEGER NOT NULL, PRIMARY KEY (id) )r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" ( "key" TEXT NOT NULL, value TEXT, PRIMARY KEY ("key") )/Cindexsqlite_autoindex_deckVars_1deckVars tabletagstagsCREATE TABLE tags ( id integer not null, tag text not null collate nocase, priority integer not null default 2, primary key(id))!tablecardTagscardTagsCREATE TABLE cardTags ( id integer not null, cardId integer not null, tagId integer not null, src integer not null, primary key(id))K%%[tablesqlite_stat1sqlite_stat1CREATE TABLE sqlite_stat1(tbl,idx,stat)u5+indexix_cards_duePrioritycardsCREATE INDEX ix:OtablefieldsfieldsCREATE TABLE fields ( id INTEGER NOT NULL, "factId" INTEGER NOT NULL, "fieldModelId" INTEGER NOT NULL, ordinal INTEGER NOT NULL, value TEXT NOT NULL, PRIMARY KEY (id), FOREIGN KEY("factId") REFERENCES facts (id), FOREIGN KEY("fieldModelId") REFERENCES "fieldModels" (id) ){tablestatsstatsCREATE TABLE stats ( id INTEGER NOT NULL, type INTEGER NOT NULL, day DATE NOT NULL, reps INTEGER NOT NULL, "averageTime" FLOAT NOT NULL, "reviewTime" FLOAT NOT NULL, "distractedTime" FLOAT NOT NULL, "distractedReps" INTEGER NOT NULL, "newEase0" INTEGER NOT NULL, "newEase1" INTEGER NOT NULL, "newEase2" INTEGER NOT NULL, "newEase3" INTEGER NOT NULL, "newEase4" INTEGER NOT NULL, "youngEase0" INTEGER NOT NULL, "youngEase1" INTEGER NOT NULL, "youngEase2" INTEGER NOT NULL, "youngEase3" INTEGER NOT NULL, "youngEase4" INTEGER NOT NULL, "matureEase0" INTEGER NOT NULL, "matureEase1" INTEGER NOT NULL, "matureEase2" INTEGER NOT NULL, "matureEase3" INTEGER NOT NULL, "matureEase4" INTEGER NOT NULL, PRIMARY KEY (id) )r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" ( "key" TEXT NOT NULL, value TEXT, PRIMARY KEY ("key") )/Cindexsqlite_autoindex_deckVars_1deckVars tabletagstagsCREATE TABLE tags ( id integer not null, tag text not null collate nocase, priority integer not null default 2, primary key(id))!tablecardTagscardTagsCREATE TABLE cardTags ( id integer not null, cardId integer not null, tagId integer not null, src integer not null, primary key(id))K%%[tablesqlite_stat1sqlite_stat1CREATE TABLE sqlite_stat1(tbl,idx,stat)u5+indexix_cards_duePrioritycardsCREATE INDEX ix_cards_duePriority on cards (type, isDue, combinedDue, priority)u5+indexix_cards_priorityDuecardsCREATE INDEX ix_cards_priorityDue on cards (type, isDue, priority, combinedDue)T+uindexix_cards_factorcardsCREATE INDEX ix_cards_factor on cards (type, factor)T+uindexix_cards_factIdcardsCREATE INDEX ix_cards_factId on cards (factId, type)S-qindexix_stats_typeDaystatsCREATE INDEX ix_stats_typeDay on stats (type, day)R-mindexix_fields_factIdfieldsCREATE INDEX ix_fields_factId on fields (factId)e9indexix_fields_fieldModelIdfields CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)O+iindexix_fields_valuefields!CREATE INDEX ix_fields_value on fields (value)     pageSize4096 sortIndex0hEhexCache{"-6728059892650019427": "a2a1212ca70af59d", "-4963816520069483107": "bb1cfb2ca70af59d", "-8140670650574768739": "8f06872ca70af59d", "-7097093378326989411": "9d820f2ca70af59d", "-2812868310930360931": "d8f6af2ca70af59d"}NcssCache#cmq8f06872ca70af59d {font-family:"Arial";font-size:20px;color:#000000;text-align:center;} #cmqa2a1212ca70af59d {font-family:"Arial";font-size:20px;color:#000000;text-align:center;} #cma8f06872ca70af59d {font-family:"Arial";font-size:20px;color:#000000;text-align:center;} #cmaa2a1212ca70af59d {font-family:"Arial";font-size:20px;color:#000000;text-align:center;} .cmb8f06872ca70af59d {background:#FFFFFF;} .cmba2a1212ca70af59d {background:#FFFFFF;} !leechFails16)suspendLeeches1  pageSize) suspendLeeches sortIndex!leechFails hexCache cssCache Reverse Forward Basic-PriorityVeryHigh%PriorityHigh# PriorityLow P |l[K:* tdSC2" } l \ K ; *  u d T C 3 "   } m \ L ; +  TE,S E,Rj,:nQ j,:nP,IO ,IN#,JM #,JL7,mK 7,mJXa,ZI Xa,ZH%,bG %,bFS,bE S,bD,C ,Ba@Q,A a@Q,@2j,=? 2j,=>yU,= yU,<&',|; &',|:,9 ,8,D7 ,D6S,5 S,BV_,P V_,P ,L ,L0),L/ ),L.k,- k,,f!,E+ f!,E*k,3) k,3([+,X' [+,X&e,% e,$,p># ,p>","! ," [fU,1 [fU,18Q,sP 8Q,sP,A ,A?, i ?, ig , g ,,g ,g1Q,Z 1Q,Z+y,. +y,.&O, &O,S,N  S,N 1P,   1P,  :a,   :a, .>a, Qo .>a, Qo, \ , \@G),  @G), 6,  6,   pP1 yY7 )5%cardsix_cards_duePriority31 31 31 1 1*5'cardsix_cards_priorityDue31 31 31 31 1 +cardsix_cards_factor31 31 31 +cardsix_cards_factId31 1 1, 7)cardsix_cards_intervalDesc31 31 31 31 31% +'cardsix_cards_dueAsc31 31 31 31 1 'cardsix_cards_sort31 1-fieldsix_fields_factId62 2%9fieldsix_fields_fieldModelId62 31+fieldsix_fields_value62 1-statsix_stats_typeDay3 2 1&3cardTagsix_cardTags_tagCard62 31 1"1cardTagsix_cardTags_cardId62 2*CdeckVarssqlite_autoindex_deckVars_16 1#tagsix_tags_tag5 1 (  S # CC s+ {; K +[ c k   [  3 s ++ AA `@G), A? jE, A@pk, A@zIo-E, A?Z?yj,:n AAI,I A@iXc#,J A@m?7,m A?`H=Xa,Z A@ԏ~%,b A@AS,b A?TeV@Y, A?_a@Q, A@Ll2j,= A@4+DߦyU, A@c/&',| A?UyK, A?^,D A?Tn+RS,N A?\S, A?\z," A@Ѭ e, A?_k[4),L AAσʲf!,E AA Ck,3 AA9h[+,X A?UM, \ AA#,p> A?`p6,  A?Y[fU,1 A?Y'8Q,sP AA N,A AAV+?, i AA#]g , A?SY,g AB }!1Q,Z AB*-+y,. AAV{&O, A?['ۑg.>a, Qo AB l1P,  AAնu(:a, \A?['ۑg.>a, QoDA?UM, \L)@G), A?`p6, (  S # CC s+ {; K +[ c k   [  3 s ++ AA `@G), A? jE, A@pk, A@zIo-E, A?Z?yj,:n AAI,I A@iXc#,J A@m?7,m A?`H=Xa,Z A@ԏ~%,b A@AS,b A?TeV@Y, A?_a@Q, A@Ll2j,= A@4+DߦyU, A@c/&',| A?UyK, A?^,D A?Tn+RS,N A?\S, A?\z," A@Ѭ Ξe, A?_k[4),L AAσʲf!,E AA Ck,3 AA9h[+,X A?UMª, \ AA#,p> A?`p6,  A?Y[fU,1 A?Y'8Q,sP AA NȲ,A AAV+?, i AA#]g , A?SY,g AB }!1Q,Z AB*-+y,. AAV{&O, A?['ۑg.>a, Qo AB l1P,  AAնu(:a, \A?['ۑg.>a, QoDA?UMª, \L)@G), A?`p6, ( e)fP$H z|    l @ e * V:t^2   @fffffhE, @fffffhj,:nn @333335,II @fffffh#,JJ @fffffh7,m @fffffhXa,ZZ @fffffh%,bb @fffffhS,b @fffffh, @fffffha@Q, @fffffh2j,= @fffffhyU, @fffffh&',| @g , @[fU,11 @[+,XX @@G),  @?, ii @:a,  @8Q,sPP @1Q,Z @1P,  @.>a, Qoo @&O, @+y,. @fffffh,DD @,gg @fffffh,@fffffh,LL @fffffhk, @333335k,3 @Ͳ,A @6,  @ͮ,p>> @, \\ @S,N @fffffhS, @," @e,@fffffhV_,P @fffffh),LL @333335f!,EE f( e) l|P:$ z @   e *t^H 2  V  ,:E, I,j,:nn ,,II ,nO#,JJ  G,y7,m y,ӠXa,ZZ JG,b%,bb g,DS,b S,E, H,=a@Q, _,2j,= jna,|yU, ~ ,j&',| ~_,S, wx,hk,3 rG,A8Q,sPP Xo,),LL > ,s`[fU,11 3c,N>&O, 1\C,.1Q,Z ,o, |.>a, Qoo w?,3f!,EE , @G),  /,QS, Yc, 1P,  ,+y,. C,L?, ii 2Y,g , ',@," i, Q:a,  w,Z,gg w,/,DD , 6,  , , \\ ,"鮘,p>>c,[V_,P į,p^e, V, x,Aa,\,LL [,[+,XX l, S,N ;,dk,  !2010-12-12 !2010-12-06 !2010-12-05 !2010-12-02! 2010-12-02 P pL8 d P$p \H4   ` t  $ p l X D 0   | h T @ ,   < ( 8 L x x x x x,:d,:,:,:I,Z!,I,8 ,,S:,,,,nO,nP,nO,nO G,y4C,y G,y<ƫ,yy,ӠE,Ӡy,Ӡ$ɻ,ӠJG,bϚ,bJG,bW,bg,D,Dg,D/MQ,DS,Ej,ES,Eq1,EH,=(,=H,=",=_,6,_,e,jna,|j%,|jna,|:,|~ ,j 9,j~ ,j_,j~_,S(,S~_,S,Swx,h`.,hwx,hE%,hrG,Aʙ#,ArG,AЁ$,AXo,+=,Xo,j,> ,s`e,s`> ,s`],s`3c,N> ,N>3c,N>1,N>1\C,.\ʥ,.1\C,.PU,.,o, |Mo, |,o, |,, |w?,3@,3w?,3a,3, BQ, , և], /,Qr,Q/,Q ,QYc, um, Yc, 5K, ,%,,,C,L,LC,L[,L2Y,~C,2Y,,',@+a,@',@,@i, Q[, Qi, QTͿ, Qw,Z7e,Zw,Zi,Zw,/~fU,/w,/ i,/, P8, , =Q, , +M, , i, ,"a,","霙S,"`(c,[,,[c,[{O,[į,p^{,p^į,p^X,p^V, xGK, xV, x5Q}, x(a,\ ,\a,\h',\[,;s,[,S,l, e, l, Sc, ;,dY(,d;,dW,d P pt 8` pL8$ ` P    p\H4   (  d l X D t 0   < L | h T @ $ ,   x x x x x, d,:, ,:, Z!,, 8 ,, S:,, ,, ,nP, ,nO, 4C,y, <ƫ,y, E,Ӡ, $ɻ,Ӡ, Ϛ,b, W,b, ,D, /MQ,D, j,E, q1,E, (,=, ",=, 6,, e,, j%,|, :,|, 9,j, _,j, ~fU,/, ~C,, {,p^, a,", \ʥ,., [, Q, P8, , Mo, |, E%,h, BQ, , ;s,, 7e,Z, 5K, , 5Q}, x, +a,@, e,s`,  ,Q, %,, ,S , {O,[, a,3, 1,N>, i, , W,d, ,L, ʙ#,A, j,, e, , ,\, um, , r,Q, `.,h, Y(,d, X,p^, TͿ, Q, PU,., GK, x, @,3, =Q, , ,,[, +M, , +=,, (,S, ,N>, ,, |, S,, i,/, ,@, [,L, ],s`, i,Z, ,, S,", Sc, , h',\, ], , ,, $,A PwuB^mZ p = F b:M2   gz P 3   w > #  # i $ k TN > +    wwwww%Aune demi-soeur (remariage)/MQ,D%Aun demi-frère (remariage)q1,Eun b/the granddaughter i,/,Ole beau-frère (d'un(e) marié(e),:,Ola belle-soeur (d'un(e) marié(e)8 ,-Grandma / Granny,, |#Mum / Mummy$,A#Dad / Daddy,the sister-in-lawd,1the brother-in-lawd,:/the sister-in-lawZ!, Vla belle-soeur8 ,!the fatherS:,le père,!the mother,nPla mère,nO+Mthe parents-in-law / the in-laws4C,y/Ules beaux-parents (d'un(e) marié(e)<ƫ,y/the mother-in-lawE,Ӡ,Ola belle mère (d'un(e) marié(e)$ɻ,Ӡ/the father-in-lawϚ,b+Mle beau-père (d'un(e) marié(e)W,b'a half-sister,D une demi-soeur/MQ,D)a half-brotherj,E un demi-frèreq1,E)the stepmother(,=%Ala belle-mère (remariage)",=)the stepfather6,$?le beau-père (remariage)e,";the great-granddaughterj%,|";l'arrière-petite-fille:,|1the great-grandson 9,j 7l'arrière-petit-fils_,j une belle-mère{O,[un enfantW,d [un beau-père ,\twins`.,hthe wife,@the uncle,the sonS,!the sisterTͿ, Q#the parentsPU,.the niece+=,!the nephew],s`#the husbandi,Z 7the great-grandmother ,N> 7the great-grandfather=Q, %the grandsonr,Q-the grandparentsSc, +the grandfather], /the grandchildren(,S*the grandaughter i,/!the family[,L%the daughterum, !the cousinS,"%the children@,3#the brotherGK, xthe auntX,p^1les petits-enfants,S#les parents\ʥ,./les grand-parentse, #les enfantsa,3'le petit-fils ,Qle neveue,s`le mari7e,Z)le grand-pèreBQ, le frère5Q}, xle fils;s, 7le cousin, la cousinea,"la tante{,p^la soeur[, Q+la petite-fille~fU,/la niècej,$?la fille (de ses parents)5K, 3la femme, l'épouse+a,@!la famille,Ll'oncle~C,!9l'arrière-grand-mère1,N>!9l'arrière grand-pèreP8, #des jumeauxE%,h}0a stepmother,,[}a stepfatherh',\a childY(,dPapa%,Mum$,AMamanʙ#,A Grand/Grandad / Grandpa+M, #Grand-pèrei, #Grand-mèreMo, |Dad,   ,L  V_,P   a,\  c,[  |P  Byk\ M>  ~ `   P{ $ l] 2N n? 30 m ^ o O Q @  1 } "   A  # _ _ _ _ _E,TE,Sj,:nRj,:nQ,IP,IO#,JN#,JM7,mL7,mKXa,ZJXa,ZI%,bH%,bGS,bFS,bE,D,Ca@Q,Ba@Q,A2j,=@2j,=?yU,>yU,=&',|<&',|;g ,[fU,1 [+,X(@G), ?, i:a, 8Q,sP1Q,Z1P, .>a, Qo&O,+y,.,D8,g,:!,L2k,.k,3*,A6, ,p>$, \S,NS,6,""e,&/V_,P4),L0f!,E,g ,[fU,1[+,X'@G), ?, i:a, 8Q,sP1Q,Z1P, .>a, Qo&O,+y,.,D7,g,9,L1k,-k,3),A  6, ,p>#, \S,N S,5,"!e,%V_,P3),L/f!,E+ P  ~qdWJ=0#  s{ f Yna  TG 2 % :-     w j ] L ? P C 6 )   E,T E,S j,:nR j,:nQ ,IP ,IO #,JN #,JM 7,mL 7,mK Xa,ZJ Xa,ZI %,bH %,bG S,bF S,bE ,D ,C a@Q,B a@Q,A 2j,=@ 2j,=? yU,> yU,= &',|< &',|; g , g , [fU,1 [fU,1 [+,X( [+,X' @G),  @G),  ?, i ?, i :a, :a, 8Q,sP 8Q,sP 1Q,Z 1Q,Z 1P, 1P, .>a, Qo .>a, Qo &O, &O, +y,. +y,. ,D8 ,D7 ,g ,g ,: ,9,L2 ,L1 k,. k,- k,3* k,3) ,A ,A 6,   6, ,p>$ ,p># , \ , \ S,N S,N S,6 S,5 ,"" ,"! e,& e,%V_,P4 V_,P3 ),L0 ),L/ f!,E, f!,E+ (  . 4g > F  6 i N qY  Q& v  ^ ^ ^ @J6%,b @ T 䂜2j,= @d}2/xk, @oG,I @参NlS,b @R1yU, @a @f!,E @|he, ?A1C,g ?^p8Q,sP @ZeGYZϲ,A @a^#?, i @b@ؠg , @‘p&O, @Ԓz:a,  ?bv+.>a, Qo ?ג`"r, \ @g(nE,ď ?1jMj,:n @ GA#,J @AkѺ7,m ?^BTl ?^BTlXa,Z ?kz,?:rX ?:rXa@Q, @1#'&',|g ? ?{[fU,1 @f9@G),  ?Z\4jۭS, ?ˑH9&,"P @!*C L1Q,Z1 @!Lz^1P,  & @!|\+y,.  ?u:),Lg ?K2 Lb, ?]lʤS,N @׮vNk,3 ?6,  @wdy,p> ?[1,D @J6%,b @1il:[+,X?[1,D @ T 䂜2j,= (  S # CC s+ {; K +[ c k   [  3 s ++ AA `@G), A? jE, A@pk, A@zIo-E, A?Z?yj,:n AAI,I A@iXc#,J A@m?7,m A?`H=Xa,Z A@ԏ~%,b A@AS,b A?TeV@Y, A?_a@Q, A@Ll2j,= A@4+DߦyU, A@c/&',| A?UyK, A?^,D A?Tn+RS,N A?\S, A?\z," A@Ѭ Ξe, A?_k[4),L AAσʲf!,E AA Ck,3 AA9h[+,X A?UMª, \ AA#,p> A?`p6,  A?Y[fU,1 A?Y'8Q,sP AA NȲ,A AAV+?, i AA#]g , A?SY,g AB }!1Q,Z AB*-+y,. AAV{&O, A?['ۑg.>a, Qo AB l1P,  AAնu(:a, \A?['ۑg.>a, QoDA?UMª, \L)@G), A?`p6,   Reverse Forward Basic-PriorityVeryHigh%PriorityHigh# PriorityLow  ܫ( w    g,D!, A? jA?7une demi-soeur (remariage)a half-sister@参NlA@A@fffffh@A?6@_;`@_;`A@Aq圥' ok     ;,d!, A=XA?7 Cun enfanta child@d}2/xA@pA?7DE@fffffh@fffffhA?6E@2M@BMA@phݚ圤' sg    wx,h!, A=~,A?7MXdes jumeauxtwins@׮vNAA C@333335@A?6@%8@%8AA Clن圠' os    V, x!, A=^QA?6n@le frèrethe brother@ZeGYZAA N@@A?6n@@|@|AA NȂ؍圗)      , !, A=mA?6l'arrière grand-pèrethe great-grandfather?A?`pA?6i@@A?6#l@80@80A?`pxצ圢>( q    ,"颡!, A=qA?6dle cousin, la cousinethe cousin@wdyAA#@@A?6d@ Ġ@ ĠAA#圚\' s    , !, A=*2A?6:4Grand-pèreGrandad / Grandpa?ג`"rA?UM@@A?6:4@71(@71(A?UMtՄ圚\' s    , !, A=*2A?6:4Grand-pèreGrandad / Grandpa?ג`"rA?UM@@A?6:4@71(@71(A?UMyҔ圜' }    l, 𼢡!, A=>XA?6Y%les grand-parentsthe grandparents?]lA?Tn+R@@A?6Y%@2@2A?Tn+Rq圧' wu    /,Q!, A=A?6vle petit-filsthe grandson?Z\4jۭA?\@fffffh@A?6v@,'@,'A?\}Ш圢( m    ',@!, A=lA?60la femme, l'épousethe wife?ˑH9&A?\zA?7p@@A?6q@5@EA?\zqϷ圣' mm     į,p^!, A=tAA?6la tantethe aunt@|hA@Ѭ A?7@@A?6 @$@4A@Ѭ ΁jĨ圥L' oo    Xo,!, A=䇲A?6)la niècethe niece?u:A?_k[4@fffffh@A?6)@'1 @'1 A?_k[4 ➺n(     I,!, A?əA?7bla belle-soeur (d'un(e) marié(e)the sister-in-law?1jMA?Z?y@fffffh@A?7@K#@K#A?Z?yoĒ圥E' su    w?,3!, A=HA?6les enfantsthe children@a @AAσʲ@333335@A?6@#h@#hAAσʲ    ( x圩D' {    w,/!, A=IAAJ:7Lla petite-fillethe granddaughter?[1A?^@fffffh@A?6@ p @ p A?^|圫(     ~_,S!, A=A?6les petits-enfantsthe grandchildren?K2 LbA?UyK@fffffh@A?6@1L0@1L0A?UyK~Ԁ圛( u    Yc, !, A=8[A?6Tila fille (de ses parents)the daughter@!Lz^AB l@@A?6Ti@C H@C HAB l닁s̒圚o' s}    ,o, |!, A=.+A?6CGrand-mèreGrandma / Granny?bv+A?['ۑg@@A?6C@Cp@CpA?['ۑg圮)     ~ ,j!, A=A?6ƾl'arrière-petit-filsthe great-grandson@1#'A@c/@fffffh@A?6ƾ@& @& A@c/圞)      3c,N>!, A=J+A?6^0l'arrière-grand-mèrethe great-grandmother@‘pAAV{@@A?6^0@4@4AAV{ s土g' ks    w,Z!, A=RA?6ule marithe husband?A1CA?SYA?6@@A?6i@,l@<lA?SYŁg圞' es    ,!, A=LA?6bPapaDad / Daddy@!|\AB*-@@A?6b@1l@1lAB*-ȁj❼I' mq    ,!, A?ȴA?6le pèrethe father@oGAAI@333335@A?6@\0@\0AAI ) %     G,y!, A?BnA?6yles beaux-parents (d'un(e) marié(e)the parents-in-law / the in-laws@AkѺA@m?( y    S,E!, A? A?7Vun demi-frère (remariage)a half-brother?kzA?TeV@Y@fffffh@A?6Y@=@=A?TeV@Y) %     G,y!, A?BnA?6yles beaux-parents (d'un(e) marié(e)the parents-in-law / the in-laws@AkѺA@m?@fffffh@A?6y@)X`@)X`A@m?圩D' {}    w,/!, A=IA?6la petite-fillethe grandaughter?[1A?^@fffffh@A?6@ p @ p A?^jIJ❘J' mq    ,nO!, A?iA?6la mèrethe mother@ GAA@iXc@fffffh@A?6@*8@*8A@iXcb(      JG,bƢ!, A?bA?7ple beau-père (d'un(e) marié(e)the father-in-law@J6A@ԏ~A?7x@fffffh@fffffhA?6y@&r@&rA@ԏ~ 4" f A  J % Ju4\0'indexix_cards_sortcards0CREATE INDEX ix_cards_sort on cards (question collate nocase) /##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as select * from cards where type = 2 and isDue = 1 order by priority desc, due desca7indexix_media_originalPathmedia"CREATE INDEX ix_media_originalPath on media (originalPath)k9%indexix_cardsDeleted_cardIdcardsDeleted#CREATE INDEX ix_cardsDeleted_cardId on cardsDeleted (cardId)r =' indexix_modelsDeleted_modelIdmodelsDeleted$CREATE INDEX ix_modelsDeleted_modelId on modelsDeleted (modelId)k!9%indexix_factsDeleted_factIdfactsDeleted%CREATE INDEX ix_factsDeleted_factId on factsDeleted (factId)l"9%indexix_mediaDeleted_factIdmediaDeleted&CREATE INDEX ix_mediaDeleted_factId on mediaDeleted (mediaId)d#3indexix_cardTags_tagCardcardTags'CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z$1uindexix_cardTags_cardIdcardTags(CREATE INDEX ix_cardTags_cardId on cardTags (cardId)~%7;indexix_cards_intervalDesccards)CREATE INDEX ix_cards_intervalDesc on cards (type, isDue, priority desc, interval desc)h&+indexix_cards_dueAsccards*CREATE INDEX ix_cards_dueAsc on cards (type, isDue, priority desc, due)['/indexix_media_filenamemedia+CREATE UNIQUE INDEX ix_media_filename on media (filename)H(#gindexix_tags_tagtags,CREATE UNIQUE INDEX ix_tags_tag on tags (tag))##gviewfailedCardsfailedCardsCREATE VIEW failedCards as select * from cards where type = 0 and isDue = 1 order by type, isDue, combinedDue*##oviewrevCardsOldrevCardsOldCREATE VIEW revCardsOld as select * from cards where type = 1 and isDue = 1 order by priority desc, interval desc +##eviewrevCardsNewrevCardsNewCREATE VIEW revCardsNew as select * from cards where type = 1 and isDue = 1 order by priority desc, interval,##[viewrevCardsDuerevCardsDueCREATE VIEW revCardsDue as select * from cards where type = 1 and isDue = 1 order by priority desc, due-))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as select * from cards where type = 1 and isDue = 1 order by priority desc, factId, ordinal.##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as select * from cards where type = 2 and isDue = 1 order by priority desc, due S( c ! dL{ X J %  &  |{7 " l ,,,Nun demi-frère (remariage),Nun beau-père (remariage),LUla belle-soeur (d'un(e) marié(e)j,:n.le beau-fUle beau-frère (d'un(e) marié(e)E,;mle père,I;mla mère#,JX%les beaux-parents (d'un(e) marié(e)7,mUla belle mère (d'un(e) marié(e)Xa,ZTle beau-père (d'un(e) marié(e)%,b i5une demi-soeurune demi-soeur (remariage)S,bNla belle-mère (remariage)a@Q,Mle beau-père (remariage)2j,=K l'arrière-petite-filleyU,:kl'oncleg ,;mle neveu[fU,1:kle fils[+,XAyle grand-père@G), =qla famille?, i;mla soeur:a, 8gMaman8Q,sP>sles parents1Q,ZMla fille (de ses parents)1P, >sGrand-mère.>a, QoIl'arrière-petit-fils&',|J l'arrière-grand-mère&O,7ePapa+y,.B{la petite-fille,D:kle mari,gFles petits-enfants,AAun beau-père,L<oun enfantk,>sdes jumeauxk,3<ole frère,AJ l'arrière grand-père6, Ile cousin, la cousine,p>>sGrand-père, \Dles grand-parentsS,N@wle petit-filsS,Gla femme, l'épouse,";mla tantee,Cune belle-mèreV_,P<ola nièce),L>sles enfantsf!,E   ⟂)      ,:!, A? jA?7ble beau-frère (d'un(e) marié(e)the brother-in-law@g(nA@zIo-A?7J@fffffh@fffffhA?7 J@4"@D"A@zIo-圯)      jna,|㢡!, A=(A?6țl'arrière-petite-fillethe great-granddaughter@R1A@4+Dߦ@fffffh@A?6ț@o@oA@4+Dߦh土' ko    2Y,!, A=VA?6kfl'onclethe uncle@b@ؠAA#]@@A?6kf@@@@AA#]Њ⑴( y    H,=!, A?!A?6la belle-mère (remariage)the stepmother?:rXA?_@fffffh@A?6@O@@O@A?_j圡1' mq    > ,s`!, A=f(A?6yle neveuthe nephew?{A?Y@@A?6y@8|(@8|(A?Yfť圣X' kk    [,!, A=wA?6jle filsthe son@1il:AA9h@@A?6j@;`@;`AA9h ●Z(     y,Ӡ!, A?ɯwA?6Mla belle mère (d'un(e) marié(e)the mother-in-law?^BTlA?`H=@fffffh@A?6M@&8@&8A?`H=z圗' y{     , ֢!, A==A?6[le grand-pèrethe grandfather@f9AA `L)@@A?64A@|@|AA `l圠i' qq    C,L!, A=ZA?6lla famillethe family@a^#AAV+@@A?6l@`A@`AAAV+j圛' mq    i, Q!, A=1A?6Jla soeurthe sister@ԒzAAնu(@@A?6J@:@@:@AAնu(h圠P' gs    rG,AТ!, A=a}A?6sxMamanMum / Mummy?^pA?Y'@@A?6sx@40@40A?Y' ␽( y     _,!, A?PuA?7le beau-père (remariage)the stepfather@ T 䂜A@LlA?7cs@fffffh@fffffhA?6t@3@CA@Llnʒ圞ڝ' ss    1\C,.!, A=OA?6dles parentsthe parents@!*C LAB }!@@A?6d@p@pAB }! (4_  _  H s ' Q { " L }  G WDqk8 u<;V+vN'~I^6%圧/+w,/, la petite-fille土2Y,, l'oncle圢^į,p^, la tante"圛 %Yc, , the daughter"ْ圦 %/,Q, the grandson$⑴E)S,E, un demi-frère$⑴E )S,E, a half-brother-圮 ;jna,|㝂, the great-granddaughter+圢7,", le cousin, la cousine圣h wx,h, twins!圞#1\C,., les parents圚юi, Q, la soeur'❼ /I,, the sister-in-lawʀ圥d ;,d, a child圢^ į,p^, the aunt 圚ю !i, Q, the sister ❘ !,, the father!圞 #1\C,., the parents,圕9, , l'arrière grand-père!圚|#,o, |, Grand-mère!圠x #V, x, the brother!圣h#wx,h, des jumeaux$圗), ֻ, le grand-père"圤 %w?,3, the children+Խ圕 7, , the great-grandfather:ղ●yU G,y, les beaux-parents (d'un(e) marié(e)圣[,, le fils7❼OI,, la belle-soeur (d'un(e) marié(e)ٰ圞ڼw,Z, le mari$⏦ )_,, the stepfather/圛?Yc, , la fille (de ses parents)ԯ圠xV, x, le frère6●y M G,y, the parents-in-law / the in-laws$ӪD)g,D, une demi-soeur"圥[ %c,[, a stepmother)ظ圡@3',@, la femme, l'épouse'Ӹ圗 /, , Grandad / GrandpaϿ圥 Xo,, the niece$␽ )H,=, the stepmother'圩9圥'í圧/ /w,/, the granddaughter!ɛ圠 #rG,AН, Mum / Mummy!圞 #,, Dad / Daddy/‡⏦?_,, le beau-père (remariage)%圗 +, ֝, the grandfather ,圥\ %a,\, a stepfather7΅ڲ➺O,:, le beau-frère (d'un(e) marié(e)&Δ圛 -l, 𼝂, the grandparents Φ圢 !,"靂, the cousin+ԗ圭j7~ ,j, l'arrière-petit-filsڲ土 2Y,, the uncle'׵Ӡ /y,Ӡ, the mother-in-law!圞ڼ #w,Z, the husband ءP !,nO, the mother o0圥\/a,\, un beau-père re(ٖ➺ 1,:, the brother-in-lawڧ❘,, le père ׸圠` !> ,s`, the nephew ܴ˲土L !C,L, the family圡@ ',@, the wife'圛/l, , les grand-parents圥Xo,, la nièce妤圠rG,Aл, Maman 土L!C,L, la famille'² /JG,bƝ, the father-in-law圥d;,d, un enfant6MJG,bƻ, le beau-père (d'un(e) marié(e)!圗#, , Grand-père,򌻒圜>93c,N>, l'arrière-grand-mère꘲O,nO, la mère(0圧/ -w,/, the grandaughterʲ圣 [,, the son!圤#w?,3, les enfants-圮;jna,|, l'arrière-petite-fille/圥[+c,[, une belle-mère(圩S1~_,S, les petits-enfants&圚| -,o, |, Grandma / Granny圞,, Papa+޲圜> 73c,N>, the great-grandmother(圭j 1~ ,j, the great-grandson#¿圦'/,Q, le petit-fils圠`> ,s`, le neveu#D 'g,D, a half-sister0␽AH,=, la belle-mère (remariage) ({  D u  B k : a  4 _  @ j =bA*V0ӪDAg,D, une demi-soeur (remariage)0⑴EAS,E, un demi-frère (remariage)7ӠOy,Ӡ, la belle mère (d'un(e) marié(e)'圩S /~_,S, the grandchildren$␽ )H,=, the stepmotherϿ圥 Xo,, the niece'Ӹ圗 /, , Grandad / Grandpa)ظ圡@3',@, la femme, l'épouseZ圥[ %c,[, a stepmother.D)g,D, une demi-soeur6●y M G,y, the parents-in-law / the in-lawsԯ圠xV, x, le frère/圛?Yc, , la fille (de ses parents)$⏦ )_,, the stepfatherٰ圞ڼw,Z, le mari7❼OI,, la belle-soeur (d'un(e) marié(e)圣[,, le fils:ղ●yU G,y, les beaux-parents (d'un(e) marié(e)+Խ圕 7, , the great-grandfather"圤 %w?,3, the children$圗), ֻ, le grand-père!圣h#wx,h, des jumeaux!圠x #V, x, the brother!圚|#,o, |, Grand-mère,圕9, , l'arrière grand-père!圞 #1\C,., the parents ❘ !,, the father 圚ю !i, Q, the sister圢^ į,p^, the auntʀ圥d ;,d, a child'❼ /I,, the sister-in-law圚юi, Q, la soeur!圞#1\C,., les parents圣h wx,h, twins+圢7,", le cousin, la cousine-圮 ;jna,|㝂, the great-granddaughter$⑴E )S,E, a half-brother.⑴E)S,E, un demi-frère"ْ圦 %/,Q, the grandson"圛 %Yc, , the daughter圢^į,p^, la tante土2Y,, l'oncle%圧/+w,/, la petite-fille