SQLite format 3 @ % 0 2 N % - 0=- 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 (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" 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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars {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)
);''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_1rev
/ӏ
AӔiʴAӔiBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt e ?hexCache{"2537845674754003189": "23383d31f27950f5", "8669434994767778037": "78500531f27950f5", "-2496158361855635210": "dd5bdd31f27950f6", "-8801263810871996170": "85dba131f27950f6", "-352807778064445195": "fb1a9331f27950f5"}(
EcssCache.fmfb1a9331f27950f5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm23383d31f27950f5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq85dba131f27950f6 {text-align:center;}
#cmqdd5bdd31f27950f6 {text-align:center;}
#cma85dba131f27950f6 {text-align:center;}
#cmadd5bdd31f27950f6 {text-align:center;}
.cmb85dba131f27950f6 {background:#FFFFFF;}
.cmbdd5bdd31f27950f6 {background:#FFFFFF;}
pageSize4096
hexCa'
mediaLocation !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
+wiYJ8 'mediaLocation pageSize) suspendLeeches!revSpacing #revInactive
revActive
perDay!newSpacing#newInactive
newActive mediaURL !leechFails latexPre
latexPost hexCache cssCache
$·ӏ
xP1yPFrontArial1#ҳ
xP1yPBackArial1
" " eӏ
xP1yPForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe
xP1yPReverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFF
1 1* : K
V
;''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,
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)
)]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)
){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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars 4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)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 (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
!!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),
CHECK ("questionInAnswer" IN (0, 1)),
CHECK ("allowEmptyAnswer" IN (0, 1)),
CHECK (active IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)& +tablefactsfactsCREATE TABLE facts (
id INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
"spaceUntil" TEXT NOT NULL,
"lastCardId" INTEGER,
PRIMARY KEY (id),
FOREIGN KEY("modelId") REFERENCES models (id)
)q
AtabledecksdecksCREATE 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)
)5ItablecardscardsCREATE 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("cardModelId") REFERENCES "cardModels" (id),
CHECK ("isDue" IN (0, 1)),
FOREIGN KEY("factId") REFERENCES facts (id)
)
<W
P
O +ܓʊ
# xP1yPAӔ2/AӔ2Gales Wales1ӏʊ
/ xP1yPAӔ*AӔ*Escocia Scotland3ʋȏ
3 xP1yPAӔ7#kAӔ7$-Inglaterra England2ʌ
1 xP1yPAӔ>*!hAӔ>*Portugal Portugal>ӏʈګ
I xP1yPAӔ&hAӔ&i"Viven en … They live in …6
9 xP1yPAӔAӔVLos países Countries@ӏʈ
M xP1yPAӔ hAӔ ?Vive en … He/She lives in ….ʇ
) xP1yPAӔoqiAӔo0vivir to liveC߳ʆ
S xP1yPAӔdoAӔ¿Dónde vives? Where do you live?.㷳ʋ
) xP1yPAӔ5AӔ5hGrecia Greece/ʊ
+ xP1yPAӔ/
AӔ/0Francia France0ʋݪ
- xP1yPAӔ9-AӔ9IIrlanda Ireland-㓇ʌ
' xP1yPAӔ<QAӔ<ƨItalia Italy1ʉ?
/ xP1yPAӔ(^xAӔ(ҳAlemania Germany:ٓӏʇ
A xP1yPAӔ.!AӔ.kVivo en … I live in ….Ͽʊy
) xP1yPAӔ-nAӔ-rEspaña Spain>ßʈ}
I xP1yPAӔ ^AӔ _qGVivimos en … We live in …
Y Y $%
M -%#
AӔizrAӔ>+O{AxP1yPa66078b45cebee0f7ae6c525ba7af8ebAӔ ߙ? XPriorityVeryHighPriorityHighPriorityLowX8@
.Y
6 T )W Zӏʈb(
u=~E1 [1yPAӔ hAӔ naVive en … He/She lives in …AӔ h@ @ AӔ hDʋ'
gg}1g[1yPAӔ2/AӔ2MGalesWalesAӔ2/@ @ AӔ2/Gʋu'
ki 1[1yPAӔ5AӔ5ʖGrecia GreeceAӔ5@ @ AӔ5Wʈڍ'
{y 17}[1yPAӔ ^AӔ _Vivimos en … We live in …AӔ ^@ @ AӔ ^Ɓ]ʇ(
} V1z[1yPAӔdoAӔ¿Dónde vives? Where do you live?AӔdo@ @ AӔdoSӏʈr'
uwd1 [1yPAӔ.!AӔ.yVivo en … I live in …AӔ.!@ @ AӔ.!Oʆk'
uoBg1yT[1yPAӔAӔ_Los países CountriesAӔ@ @ AӔLʋݏ'
skI1ȏ[1yPAӔ7#kAӔ7$\Inglaterra EnglandAӔ7#k@ @ AӔ7#kGӏʊ'
mg=1 y[1yPAӔ-nAӔ-España SpainAӔ-n@ @ AӔ-nWӏʉ$'
w}C1Z[1yPAӔ&hAӔ&iHViven en … They live in …AӔ&h@ @ AӔ&hIݓʌ'
mks1ݪ[1yPAӔ9-AӔ9NIrlanda IrelandAӔ9-@ @ AӔ9-F³ʌ'
kgL?1[1yPAӔ<QAӔ<Italia ItalyAӔ<Q@ @ AӔ<QHʊ'
mi
b1@ [1yPAӔ/
AӔ/Francia FranceAӔ/
@ @ AӔ/
ÁJޞʊ_'
mm`}1 [1yPAӔ*AӔ*IfEscocia ScotlandAӔ*@ @ AӔ*K֓ʌS'
omD@1)[1yPAӔ>*!hAӔ>*TPortugal PortugalAӔ>*!h@ @ AӔ>*!hJсʉ'
ok1?[1yPAӔ(^xAӔ(Alemania GermanyAӔ(^x@ @ AӔ(^xGåʇ'
ik21[1yPAӔoqiAӔp"vivir to liveAӔoqi@ @ AӔoqi
J
8
% r
H
JE
D%g\$ t k$9%indexix_fact/##[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, combinedDueH+#gindexix_tags_tagtags/CREATE UNIQUE INDEX ix_tags_tag on tags (tag)[*/indexix_media_filenamemedia.CREATE UNIQUE INDEX ix_media_filename on media (filename)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'1 uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)d&3 indexix_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,
.%% 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_modifiedcards CREATE INDEX ix_cards_modified on cards
(modified)T/qindexix_facts_modifiedfacts CREATE INDEX ix_facts_modified on facts
(modified)T/qindexix_cards_prioritycards CREATE INDEX ix_cards_priority on cards
(priority)T+uindexix_cards_factorcards CREATE 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)e 9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)
"
{ `3b<
b
:
l : t N )
{ ʉ@ 1?1yPGermany" %Bg1yT#8=1yPLos países ʊ `}1 #8=1yPEscocia )ʈ 3=~E1 1yPHe/She lives in …ʌ L?11yPItaly ӏʇ 21#8=1yPvivir ʊ
b1@ 1yPFranceʊ }1g1yPWales ʋȏ I1ȏ1yPEngland"ӏʈ %=~E1 #8=1yPVive en … ʊ `}1 1yPScotland(سʆ 1 V1z1yPWhere do you live? ӏ Bg1yT1yPCountries ʳʋ 1#8=1yPGrecia $ʈ~ ) 17}1yPWe live in … ʌ D@1)1yPPortugal ʊy =1 y#8=1yPEspaña ӏʋݪ s1ݪ#8=1yPIrlanda &柔+ -C1Z1yPThey live in … ӏʉ? 1?#8=1yPAlemania ʌ L?1#8=1yPItalia "ʇ %d1 #8=1yPVivo en … %ӏʈ~ + 17}#8=1yPVivimos en … Úʋ 11yPGreece ʌ D@1)#8=1yPPortugal ʊ
b1@ #8=1yPFrancia !ӏʋȏ #I1ȏ#8=1yPInglaterra ߈ʊ }1g#8=1yPGales&ݶӏʆ - V1z#8=1yP¿Dónde vives? #̳ʇ 'd1 1yPI live in …#糏ʈګ 'C1Z#8=1yPViven en … ̋ʇ 211yPto live хʋݪ s1ݪ1yPIrelandÈʊz =1 y1yPSpain
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
"
|l[K:* tdSC2"
" v1KS! v1KS N1) N1) 1 1 .1ݏ .1ݏ Th11u Th11u f1 f1 [W1g [W1g -e1@ -e1@ z 1 _ z 1 _ _1 _1 }1$
}1$ S1Z S1Z
n_u17b n_u17b ;1 r ;1 r
+1
+1 L)1 L)1 5q1zk 5q1zk
}l`L?0$ # fieldModels0' modelsDeleted0 fields0+ CdeckVarssqlite_autoindex_deckVars_112 1
stats0
cardTags0 models0 ' reviewHistory0
media0 ! cardModels0 sources0% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
eF'mN/
AӔ>*!hD@1)ϭv1KS AӔ<QL?1N1) AӔ9-s1ݪ1 AӔ7#kI1ȏ.1ݏ AӔ5 1Th11u AӔ2/}1gf1 AӔ/
b1@ [W1g AӔ-n=1 y-e1@ AӔ*`}1 z 1 _ AӔ(^x1?_1 AӔ&hC1Z}1$ AӔ ^Ɖ 17}S1Z AӔ h=~E1 n_u17b AӔ.!d1 ;1 r AӔoqi21
+1 AӔdo V1zL)1 AӔBg1yT5q1zk
# ~qdWJ=0# n_u17b f1 Th11u S1Z L)1 ;1 r 5q1zk .1ݏ -e1@ }1$ 1 N1) [W1g z 1 _ v1KS _1
+1
t`L8$ AӔ>*Tv1KSAӔ<N1)AӔ9N1AӔ7$\.1ݏAӔ5ʖTh11uAӔ2Mf1AӔ/[W1gAӔ--e1@AӔ*Ifz 1 _AӔ(_1AӔ&iH}1$AӔ _S1ZAӔ nan_u17bAӔ.y;1 rAӔp"
+1AӔL)1AӔ_5q1zk
t`L8$ AӔ>*D@1)AӔ<ƨL?1AӔ9Is1ݪAӔ7$-I1ȏAӔ5h 1AӔ2}1gAӔ/0
b1@ AӔ-r=1 yAӔ*`}1 AӔ(ҳ1?AӔ&i"C1ZAӔ _qG 17}AӔ ?=~E1 AӔ.kd1 AӔo021AӔ V1zAӔVBg1yT
# ~qdWJ=0# n_u17b f1 Th11u S1Z L)1 ;1 r 5q1zk .1ݏ -e1@ }1$ 1 N1) [W1g z 1 _ v1KS _1
+1
|fP:$ @ n_u17b@ f1@ Th11u@ S1Z@ L)1@ ;1 r@ 5q1zk@ .1ݏ@ -e1@@ }1$@ 1@ N1)@ [W1g@ z 1 _@ v1KS@ _1@
+1
t`L8$ }1gf1`}1 z 1 _I1ȏ.1ݏD@1)ϭv1KSC1Z}1$Bg1yT5q1zk=~E1 n_u17b21
+1 V1zL)1 1Th11u
b1@ [W1gs1ݪ1L?1N1)1?_1d1 ;1 r=1 y-e1@ 17}S1Z
!2011-08-23 !2011-08-22! 2011-08-22
"
X t`L8$p\H4
l
X }1gW[1g}1g 1g`}1 g1 `}1 S1 1 1
b1@ X'1@
b1@ 1@ s1ݪ1ݪs1ݪ1ݪL?1_1L?1p11?{ 1@1?b1?d1 &1 d1 Zc1 =1 y1 y=1 y#1 z 17} #17~ 17}17~
"
X t`L8$p\H4
l
X #8=1yPmя1yT#8=1yPg1 #8=1yP[1#8=1yP?1 #8=1yP >S1#8=1yP1 y#8=1yP1ݪ#8=1yPb1?#8=1yPp1#8=1yP&1 #8=1yP17~#8=1yP q1)#8=1yP1@ #8=1yPo1ȏ#8=1yP 1g#8=1yP]1z#8=1yPO;1Z1yP{ 1@1yPa1 1yP_11yPX'1@ 1yPW[1g1yPQ1ȏ1yP,
zfQ=,
c
P
>
" -¿Dónde vives? ]1zvivir [1to live0Y1 1Where do you live?5.1z)We live in … #17~WalesW[1g%Vivo en … &1 +Vivimos en … 17~'Viven en … O;1Z%Vive en … ?1 -They live in … 1ZSpain#1 z ScotlandS1Germany{ 1@Gales 1g Francia 1@ FranceX'1@ España 1 y Escocia g1 EnglandQ1ȏ Countries(PU1yT Alemania b1?
" yj\M>/ {l]N?0! n_u17b
f1Th11uS1Z L)1;1 r5q1zk.1ݏ -e1@}1$1 N1) [W1gz 1 _v1KS"_1
+1n_u17b f1Th11uS1Z L)1;1 r
5q1zk.1ݏ-e1@}1$
1 N1) [W1gz 1 _v1KS!_1
+1
"G ~qdWJ=0# {naTG n_u17b
n_u17b f1 f1 Th11u Th11u S1Z S1Z L)1 L)1 ;1 r ;1 r 5q1zk 5q1zk .1ݏ .1ݏ -e1@ -e1@ }1$ }1$
1 1 N1) N1) [W1g [W1g z 1 _ z 1 _ v1KS" v1KS! _1 _1
+1
+1
xV4hF$
!}1gAӔ2/f1!`}1 AӔ*z 1 _!I1ȏAӔ7#k.1ݏ!D@1)AӔ>*!hv1KS!C1ZAӔ&h}1$!Bg1yTAӔ5q1zk!=~E1 AӔ hn_u17b!21AӔoqi
+1! V1zAӔdoL)1! 1AӔ5Th11u!
b1@ AӔ/
[W1g!s1ݪAӔ9-1!L?1AӔ<QN1)!1?AӔ(^x_1!d1 AӔ.!;1 r!=1 yAӔ-n-e1@! 17}AӔ ^S1Z
6 X.\2
`
6 )AӔ>*!hD@1)AӔ>*!hv1KS)AӔ<QL?1AӔ<QN1))AӔ9-s1ݪAӔ9-1)AӔ7#kI1ȏAӔ7#k.1ݏ)AӔ5 1AӔ5Th11u)AӔ2/}1gAӔ2/f1)AӔ/
b1@ AӔ/
[W1g)AӔ-n=1 yAӔ-n-e1@)AӔ*`}1 AӔ*z 1 _)AӔ(^x1?AӔ(^x_1)AӔ&hC1ZAӔ&h}1$)AӔ ^Ɖ 17}AӔ ^S1Z)AӔ h=~E1 AӔ hn_u17b)AӔ.!d1 AӔ.!;1 r)AӔoqi21AӔoqi
+1)AӔdo V1zAӔdoL)1)AӔBg1yTAӔ5q1zk
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
; \
=
m x
E`
2##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc1##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, dueO +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&3 indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z'1 uindexix_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_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 0))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinal