SQLite format 3@ D3AN D-3 6=-V ##stablefieldModelsfieldModels CREATE 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), CHECK (required IN (0, 1)), CHECK ("unique" IN (0, 1)), CHECK (numeric IN (0, 1)), FOREIGN KEY("modelId") REFERENCES models (id) )4 '''tablemodelsDeletedmodelsDeleted CREATE TABLE "modelsDeleted" ( "modelId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("modelId") REFERENCES models (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 {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) )]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) )`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) )JktablesourcessourcesCREATE 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) )r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" ( "key" TEXT NOT NULL, value TEXT, PRIMARY KEY ("key") )/Cindexsqlite_autoindex_deckVars  u ' mediaLocationpageSize4096 sortIndex0c;hexCache{"1951086896537943171": "1b13a731f2103c83", "7786236886587030660": "6c0e4531f2103c84", "-8267244207407612797": "8d44d931f2103c83", "-7990290422510371709": "911cc931f2103c83", "480782564480531587": "6ac1531f2103c83"}' CcssCache.fm911cc931f2103c83 {font-family:"Arial";font-size:20px;white-space:pre-wrap;} .fm6ac1531f2103c83 {font-family:"Arial";font-size:20px;white-space:pre-wrap;} #cmq1b13a731f2103c83 {text-align:center;} #cmq6c0e4531f2103c84 {text-align:center;} #cma1b13a731f2103c83 {text-align:center;} #cma6c0e4531f2103c84 {text-align:center;} .cmb1b13a731f2103c83 {background:#FFFFFF;} .cmb6c0e4531f2103c84 {background:#FFFFFF;}  !revSpacing0.1 )latexPost\end{document}> qlatexPre\documentclass[12pt]{article} \special{papersize=3in,5in} \usepackage[utf8]{inputenc} \usepackage{amssymb,amsmath} \pagestyle{empty} \setlength{\parindent}{0in} \begin{document}  mediaURL!newSpacing60# revInactive# newInactive  revActive  newActive perDay1!leechFails16)suspendLeeches1   wiYJ<*'mediaLocation pageSize) suspendLeeches sortIndex!revSpacing #revInactive revActive perDay!newSpacing#newInactive newActive mediaURL !leechFails latexPre latexPost hexCache cssCache   /ћȠ  AӔ7AӔ[JӀBasicBasic?< " !2011-08-23" !2011-08-22"!2011-08-22    #ӏȠ  D1Ȣ ID1el dibujoartAӔ@@AӔ\ȡ' D171¿Qué estudias? What do you study?AӔxX@@AӔxXWȡ' {yOW1?l1Las asignaturasSchool subjectsAӔ@@AӔKӏȦ' si1g1la historiahistoryAӔY@@AӔYہL֊Ȥ' uiRc1X1el español SpanishAӔԽ^_@@AӔԽ^_IﲓȦj' se+1[Z1la música musicAӔV@@AӔVVȢ' w{`1D1No estudio...I don't study...AӔ @@AӔ Kóȥ' siR511el inglés EnglishAӔ %5@@AӔ %5LۓȦ>' }av+1!1la informática ICTAӔj@@AӔjR̴Ȩ' {om?;1 1la tecnología technologyAӔV@@AӔVށ^ϓȣ( w 趱1s1No estudia...He/She doesn't study...AӔAx@@AӔAxK沇ȥ' ugS1|+1el francés FrenchAӔve@@AӔveH弓ȧ' w_11la religión REAӔY;@@AӔY;OȨO' ed,;1R1las matemáticas mathsAӔ@@AӔMМȢ' qo11Estudio...I study...AӔo@@AӔoցPȨ' ymZ11la geografía geographyAӔE@@AӔERӏȤ(  _131la educación física PEAӔ{@@AӔ{NӏȢ' kw a11EstudiaHe/She studiesAӔ@@1Ȥ!   P I [W ) D%g\W1k$9%indexix_factsDeleted_factIdfactsDeleted(CREATE INDEX ix_f /##eviewrevCardsNewrevCardsNewCREATE VIEW revCardsNew as select * from cards where type = 1 and isDue = 1 order by priority desc, interval.##oviewrevCardsOldrevCardsOldCREATE VIEW revCardsOld as select * from cards where type = 1 and isDue = 1 order by priority desc, interval desc-##gviewfailedCardsfailedCardsCREATE VIEW failedCards as select * from cards where type = 0 and isDue = 1 order by type, isDue, combinedDueH,#gindexix_tags_tagtags0CREATE UNIQUE INDEX ix_tags_tag on tags (tag)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)\*'indexix_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)x)-9indexix_cards_dueAsc2cards-CREATE INDEX ix_cards_dueAsc2 on cards (type, priority desc, due, factId, combinedDue)(9Yindexix_cards_intervalDesc2cards,CREATE INDEX ix_cards_intervalDesc2 on cards (type, priority desc, interval desc, factId, combinedDue)Z'1uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)d&3indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId).%%tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" ( "factId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("factId") REFERENCES facts (id) )8KtablefieldsfieldsCREATE 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("fieldModelId") REFERENCES "fieldModels" (id), FOREIGN KEY("factId") REFERENCES facts (id) )0%%#tablemediaDeletedmediaDeletedCREATE TABLE "mediaDeleted" ( "mediaId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("mediaId") REFERENCES cards (id) ).%%tablecardsDeletedcardsDeletedCREATE TABLE "ca.%%tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" ( "factId" INTEGER NOT NULL, "deletedTime" FLOAT NOT NULL, FOREIGN KEY("factId") REFERENCES facts (id) )8KtablefieldsfieldsCREATE 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("fieldModelId") REFERENCES "fieldModels" (id), FOREIGN KEY("factId") REFERENCES facts (id) )0%%#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) ) 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)n7indexix_cards_typeCombinedcardsCREATE INDEX ix_cards_typeCombined on cards (type, combinedDue, factId)d9indexix_cards_relativeDelaycardsCREATE INDEX ix_cards_relativeDelay on cards (relativeDelay)T/qindexix_cards_modifiedcardsCREATE INDEX ix_cards_modified on cards (modified)T/qindexix_facts_modifiedfactsCREATE INDEX ix_facts_modified on facts (modified)T/qindexix_cards_prioritycardsCREATE INDEX ix_cards_priority on cards (priority)T+uindexix_cards_factorcardsCREATE INDEX ix_cards_factor on cards (type, factor)N+iindexix_cards_factIdcards CREATE INDEX ix_cards_factId on cards (factId)S-qindexix_stats_typeDaystats!CREATE INDEX ix_stats_typeDay on stats (type, day)R-mindexix_fields_factIdfields"CREATE INDEX ix_fields_factId on fields (factId) ( Nb8T% | S %  Z 5  N  u G u NړȤ Rc1X1  1[>11-  11-y1  y191  91 Ǖ1  Ǖ1 "1tO  "1tOq1  q171   71 1X  1X1D  1D  hK, eR% n O ) #fieldModels2'modelsDeleted0-fieldsix_fields_factId12 2$9fieldsix_fields_fieldModelId12 6+fieldsix_fields_value12 1'reviewHistory0 models1-statsix_stats_typeDay2 1 1%3cardTagsix_cardTags_tagCard12 6 1"1cardTagsix_cardTags_cardId12 2 media0!cardModels2 sources0+CdeckVarssqlite_autoindex_deckVars_114 1%mediaDeleted0/factsix_facts_modified6 1 decks1 %factsDeleted0% 7cardsix_cards_typeCombined6 6 1 1" 9cardsix_cards_relativeDelay6 6 /cardsix_cards_modified6 1/cardsix_cards_priority6 6+cardsix_cards_factor6 6 6+cardsix_cards_factId6 1*9#cardsix_cards_intervalDesc26 6 6 6 1 1$-#cardsix_cards_dueAsc26 6 6 1 1 1'cardsix_cards_sort6 1%cardsDeleted0#tagsix_tags_tag5 1  eF'mN/ AӔd,;1R̫"1tOAӔ6q;1-w1RAӔVm?;1 11-AӔEZ171 AӔY;1Ǖ1AӔV+1[ZI1jAӔjv+1!1[>AӔY1gP1!AӔNg1xy1KAӔ %5R51&1AӔveS1|+91AӔԽ^_Rc1XKXS1|AӔ{131XAӔj1n012!AӔAx趱1sy1AӔ `1D?1sAӔ a11DAӔo1ᯠq1AӔxXD17_31AӔOW1?lW1 ~qdWJ=0#  xy1K w1R n012! _31 W1 P1! KXS1| I1j ?1s &1 1[> 11- y1 91 Ǖ1 "1tO q1 71 1X 1D p`p8$LtAӔ[J̫"1tOAӔ[Jw1RAӔ[J11-AӔ[J̛71 AӔ[JǕ1AӔ[JI1jAӔ[J1[>AӔ[JP1!AӔ[Jxy1KAӔ[J&1AӔ[J91AӔ[JKXS1|AӔ[J̏1XAӔ[Jn012!AӔ[J?1sAӔ[Jy1AӔ[J̋1DAӔ[J̠q1AӔ[J_31AӔ[JW1 p`8t$LpAӔ[Jäd,;1RAӔ[Jäq;1-AӔ[Jäm?;1 AӔ[JäZ1AӔ[Jä1AӔ[Jä+1[ZAӔ[Jäv+1!AӔ[Jä1gAӔ[Jäg1AӔ[JäR51AӔ[JäS1|+AӔ[JäRc1XAӔ[Jä13AӔ[Jäj1AӔ[Jä`1DAӔ[Jä趱1sAӔ[Jä a1AӔ[Jä1AӔ[JäD17AӔ[JäOW1?l ~qdWJ=0#  xy1K w1R n012! _31 W1 P1! KXS1| I1j ?1s &1 1[> 11- y1 91 Ǖ1 "1tO q1 71 1X 1D H|fP:$t^H@xy1K@w1R@n012!@_31@W1@P1!@KXS1|@I1j@?1s@&1@1[>@11-@y1@91@Ǖ1@"1tO@q1@71 @1X@1D pt`L8$pm?;1 11-d,;1R̫"1tO`1D?1sRc1XKXS1|R51&1OW1?lW1j1n012!Z171 S1|+911gP1!v+1!1[> a11D1Ǖ1g1xy1K趱1sy1+1[ZI1jq;1-w1R1ᯠq1131XD17_31  !2011-08-23 !2011-08-22! 2011-08-22 ( t`L8$p\H4  l X D 0   m?;1 1 m?;1 '1 d,;1Rr1Rd,;1R1R`1D K1D`1Dcq1DRc1X1XRc1X8G1XR51#1R51?1OW1?l /1?oOW1?ld+1?pj1BO1j1B,1Z1[1Z1չ1S1|+wد1|+S1|+1|+1gk1g1g 1gv+1!w1!v+1!1! a1}1 a1}%11۽111g1:m1g1_1趱1s7A1s趱1s ba1s+1[Z?1[Z+1[ZE1[Zq;1-dU1-q;1-_O1-1?w11ᯜ113)131313D17d17D17G17 ( t`L8$p\H4  l X D 0   1<1X1<_O1-1  1[>11-  11-y1  y191  91 Ǖ1  Ǖ1 "1tO  "1tO q1  q171   71 1X  1X1D   1D ( reXK>1$ {naTG:-  xy1K( xy1K' w1R& w1R% n012!$ n012!# _31" _31! W1 W1 P1! P1! KXS1| KXS1| I1j I1j ?1s ?1s &1 &1 1[> 1[> 11- 11- y1 y1 91 91 Ǖ1 Ǖ1 "1tO "1tO q1 q1 71  71  1X 1X 1D  1D  XxV4hF$ z X!m?;1 AӔV11-!d,;1RAӔ"1tO!`1DAӔ ?1s!Rc1XAӔԽ^_KXS1|!R51AӔ %5&1!OW1?lAӔW1!j1AӔn012!!Z1AӔE71 !S1|+AӔve91!1gAӔYP1!!v+1!AӔj1[>! a1AӔ͋1D!1AӔY;Ǖ1!g1AӔNxy1K!趱1sAӔAxy1!+1[ZAӔVI1j!q;1-AӔ6w1R!1AӔo֠q1!13AӔ{1X!D17AӔxX_31  X.\2 ` 6 )AӔd,;1RAӔ"1tO)AӔ6q;1-AӔ6w1R)AӔVm?;1 AӔV11-)AӔEZ1AӔE71 )AӔY;1AӔY;Ǖ1)AӔV+1[ZAӔVI1j)AӔjv+1!AӔj1[>)AӔY1gAӔYP1!)AӔNg1AӔNxy1K)AӔ %5R51AӔ %5&1)AӔveS1|+AӔve91)AӔԽ^_Rc1XAӔԽ^_KXS1|)AӔ{13AӔ{1X)AӔj1AӔn012!)AӔAx趱1sAӔAxy1)AӔ `1DAӔ ?1s)AӔ a1AӔ͋1D)AӔo1AӔo֠q1)AӔxXD17AӔxX_31)AӔOW1?lAӔW1  CN > { 8 q 0 D¿Qué estudias? _31@wNo estudio...?1s@wNo estudia...y1Dlas matemáticas "1tO@wlas ciencias w1RB{Las asignaturasW1B{la tecnología 11-@wla religión Ǖ1>sla música I1jC}la informática 1[>>sla historiaP1!Ayla geografía 71 J la educación física 1X=qEstudio...q1:kEstudia1D<oel teatroxy1K>sel inglés &1?uel francés 91?uel español KXS1|<oel dibujon012!  -PriorityVeryHigh%PriorityHigh#PriorityLow Forward Basic 'J o  +Nw?]vEȤ!' oaj11el dibujoartAӔ@@AӔ\ȡ' D171¿Qué estudias? What do you study?AӔxX@@AӔxXWȡ' {yOW1?l1Las asignaturasSchool subjectsAӔ@@AӔKӏȦ' si1g1la historiahistoryAӔY@@AӔYہL֊Ȥ' uiRc1X1el español SpanishAӔԽ^_@@AӔԽ^_IﲓȦj' se+1[Z1la música musicAӔV@@AӔVVȢ' w{`1D1No estudio...I don't study...AӔ @@AӔ Kóȥ' siR511el inglés EnglishAӔ %5@@AӔ %5LۓȦ>' }av+1!1la informática ICTAӔj@@AӔjR̴Ȩ' {om?;1 1la tecnología technologyAӔV@@AӔVށ^ϓȣ( w 趱1s1No estudia...He/She doesn't study...AӔAx@@AӔAxK沇ȥ' ugS1|+1el francés FrenchAӔve@@AӔveH弓ȧ' w_11la religión REAӔY;@@AӔY;OȨO' ed,;1R1las matemáticas mathsAӔ@@AӔMМȢ' qo11Estudio...I study...AӔo@@AӔoցPȨ' ymZ11la geografía geographyAӔE@@AӔERӏȤ(  _131la educación física PEAӔ{@@AӔ{NӏȢ' kw a11EstudiaHe/She studiesAӔ@@AӔ V(VGȥK' oeg11el teatrodramaAӔN@@AӔNہMȨҲ' wiq;1-1las ciencias scienceAӔ6@@AӔ6 [} 1   S @  uoJ v[ 3##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as select * from cards where type = 2 and isDue = 1 order by priority desc, due desc2##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as select * from cards where type = 2 and isDue = 1 order by priority desc, due1))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as select * from cards where type = 1 and isDue = 1 order by priority desc, factId, ordinale9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)O +iindexix_fields_valuefields$CREATE INDEX ix_fields_value on fields (value)a!7indexix_media_originalPathmedia%CREATE INDEX ix_media_originalPath on media (originalPath)k"9%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)(9Yindexix_cards_intervalDesc2cards,CREATE INDEX ix_cards_intervalDesc2 on cards (type, priority desc, interval desc, factId, combinedDue)x)-9indexix_cards_dueAsc2cards-CREATE INDEX ix_cards_dueAsc2 on cards (type, priority desc, due, factId, combinedDue)\*'indexix_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)H,#gindexix_tags_tagtags0CREATE UNIQUE INDEX ix_tags_tag on tags (tag)0##[viewrevCardsDuerevCardsDueCREATE VIEW revCardsDue as select * from cards where type = 1 and isDue = 1 order by priority desc, due /##eviewrevCardsNewrevCardsNewCREATE VIEW revCardsNew as select * from cards where type = 1 and isDue = 1 order by priority desc, interval.##oviewrevCardsOldrevCardsOldCREATE VIEW revCardsOld as select * from cards where type = 1 and isDue = 1 order by priority desc, interval desc-##gviewfailedCardsfailedCardsCREATE VIEW failedCards as select * from cards where type = 0 and isDue = 1 order by type, isDue, combinedDue