SQLite format 3 @ 2 2 N - 2=- 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Ӕ+0AӔ+=BasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt d =hexCache{"2251352526985719781": "1f3e6931f3296fe5", "-25857000417431579": "ffa42331f3296fe5", "-7107523322876170267": "9d5d0131f3296fe5", "5674299350019829734": "4ebf2931f3296fe6", "-4558305613877514267": "c0bda531f3296fe5"}(
EcssCache.fm9d5d0131f3296fe5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm1f3e6931f3296fe5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqc0bda531f3296fe5 {text-align:center;}
#cmq4ebf2931f3296fe6 {text-align:center;}
#cmac0bda531f3296fe5 {text-align:center;}
#cma4ebf2931f3296fe6 {text-align:center;}
.cmbc0bda531f3296fe5 {background:#FFFFFF;}
.cmb4ebf2931f3296fe6 {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
$͓
#1)oFrontArial1#נ
#1)oBackArial1
" " e哏
#1)oReverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFe௴ӏ
#1)oForward%(Front)s%(Back)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)
)
I^%
O
T c
c
* 5צT
7 #1)oAӔ՟AӔՠiimportante important4dzլ
5 #1)oAӔƽWAӔƾ histórico historic/փ9
+ #1)oAӔxAӔpequeño smallRӏN
q #1)oAӔT7AӔq¿Cómo es tu pueblo? What’s your village like?Aߓڛc
O #1)oAӔ2AӔ2turística appealing to touristsO
k #1)oAӔAӔ?Es la capital de … It’s the capital of …/ټy
+ #1)oAӔ AӔrpequeña small.ب
) #1)oAӔ>&AӔ>cbonita pretty2ӏx
1 #1)oAӔo]AӔuna ciudad a city:擏ӌs
A #1)oAӔAӔ+Vivo en … I live in ….ӏ
) #1)oAӔXKAӔXYbonito pretty)ԓՍ
#1)oAӔR0AӔRafeo uglyI곏Թ
_ #1)oAӔ
AӔ1Es un poco/muy … It’s a bit/very …3!
3 #1)oAӔ7AӔ8+tranquila peacefulA⣓
O #1)oAӔ* AӔ+turístico appealing to tourists)Ч
#1)oAӔ AӔy fea uglyNӏ[
i #1)oAӔ۱LAӔ۲<¿Cómo es tu ciudad? What’s your town like?/n
+ #1)oAӔ'AӔmoderno modern6ԋӏׄV
9 #1)oAӔWAӔX industrial industrial+Ҁ퓏
# #1)oAӔEAӔgrande big3ѹֳ
3 #1)oAӔζءAӔηNtranquilo peaceful/μӏٜ
+ #1)oAӔ$ AӔ%moderna modern4Ͱؓ
5 #1)oAӔ DAӔ 2histórica historic1ӏ
/ #1)oAӔxWAӔWMi ciudad My town4ɫӏ
5 #1)oAӔ͎AӔ@un pueblo a village
Y Y $%
M -%#
AӔ
wAӔA#1)oe0a2f194f43250f85b261ddbb9c6a12fAӔϑG? XPriorityVeryHighPriorityHighPriorityLowX8@ 1
/IrHp LճڛH'
qm1,!1)oAӔ7AӔ8[tranquila peacefulAӔ7@ @ AӔ7Mӏٜ'
sm1,|1)oAӔ DAӔ bhistórica historicAӔ D@ @ AӔ DD@'
kci1+1)oAӔEAӔgrande bigAӔE@ @ AӔEJӏӌT'
ok1)s1)oAӔxWAӔaMi ciudadMy townAӔxW@ @ AӔxWBӏի'
eej1* 1)oAӔR0AӔR feo uglyAӔR0@ @ AӔR0d簯ӏe)
WS1*91)oAӔ
AӔatEs un poco/muy … It’s a bit/very …AӔ
@ @ AӔ
m矹ӏԹ)
q1)N1)oAӔT7AӔ¿Cómo es tu pueblo? What’s your village like?AӔT7@ @ AӔT7GؒӏՍ'
ki1*d1)oAӔXKAӔXbonito prettyAӔXK@ @ AӔXKLӏ'
qm1+31)oAӔζءAӔη} tranquilo peacefulAӔζء@ @ AӔζء[ݝ(
sY1-c1)oAӔ2AӔ2turística appealing to touristsAӔ2@ @ AӔ2Hדֳy'
ogt)1+91)oAӔxAӔ epequeño smallAӔx@ @ AӔxՁ[ׄ;(
sɉ1+^1)oAӔ* AӔ+=turístico appealing to touristsAӔ* @ @ AӔ* MϡӏS'
smz;1* 1)oAӔƽWAӔƾ:Xhistórico historicAӔƽW@ @ AӔƽWHڽӏټ^'
mi}1,1)oAӔ$ AӔ%Emoderna modernAӔ$ @ @ AӔ$ B͟'
ee1,P1)oAӔ AӔfea uglyAӔ @ @ AӔ H۶ӏփ '
mi1*n1)oAӔ'AӔdmoderno modernAӔ'@ @ AӔ'ЁN֡ӏ'
so|ȃ1+T1)oAӔ՟AӔՠHimportante importantAӔ՟@ @ AӔ՟iڄب)
1+[1)oAӔ۱LAӔ۲k¿Cómo es tu ciudad?What’s your town like?AӔ۱L@ @ 0ճڛH
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)
2 Z3
b:
h
>
~ I } R *
W
$ ] 2 X ,N 9q1)N >i1)o¿Cómo es tu pueblo? ! !1,! >i1)otranquila o 1*n >i1)omoderno .[ =1+[]1)oWhat’s your town like?+볏 7ɉ1+^]1)oappealing to tourists! #1,| >i1)ohistórica ټy 6QS1,y]1)osmall ܓլ z;1* ]1)ohistoric#ӌt ' 11)s]1)oI live in …!ӏڛc #Y1-c >i1)oturística ! #ɉ1+^ >i1)oturístico ғփ9 t)1+9]1)osmall ӓ 1,|]1)ohistoric ӏٜ }1,]1)omodern 1)]1)oa village)Թ 3WS1*9 >i1)oEs un poco/muy … $ )1) >i1)oun pueblo
+ӏ[ 71+[ >i1)o¿Cómo es tu ciudad?1N Cq1)N]1)oWhat’s your village like?+ɝڛc 7Y1-c]1)oappealing to tourists ٜؓ }1, >i1)omoderna !ׄV #/1+V >i1)oindustrial ϓצT |ȃ1+T]1)oimportantШ 1,P]1)ouglyܳЧ 1,P >i1)ofea &廳ӌs - 11)s >i1)oVivo en …
!퓏լ #z;1* >i1)ohistórico +Њӏ 7>׃1-I >i1)oEs la capital de … i1+ >i1)ogrande ޯӏx &M1)x]1)oa city ӏب 31,(֝]1)opretty փ9 t)1+9 >i1)opequeño ओՍ! j1* ]1)ougly ׄV !/1+V]1)oindustrial ǔӏֳ 1+3]1)opeacefulӏՍ! j1* >i1)ofeo 账ֳ !1+3 >i1)otranquilo 䧋 1)s]1)oMy town+Թ 7WS1*9]1)oIt’s a bit/very … ޢ! 1,!]1)opeaceful i1+]1)obig ֵټy 6QS1,y >i1)opequeña /Ө ?>׃1-I]1)oIt’s the capital of … Ӡӏo 1*n]1)omodern 1*d]1)opretty ب 31,( >i1)obonita !ΐx #&M1)x >i1)ouna ciudad ˏӏ 1*d >i1)obonito ӏ 1)s >i1)oMi ciudad!ӏצT #|ȃ1+T >i1)oimportante
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
2 |l[K:* tdSC2"
}
l
\
K
;
*
2 o1- 1 o1- 0 w1-I/ w1-I. 1-H- 1-H, ;Q1,+ ;Q1,* i1,^) i1,^( 1,' 1,& }y1,|% }y1,|$ eY1,P# eY1,P" h'1,(! h'1,( O1+@ O1+@ Y
1+ Y
1+ fE1+: fE1+: 1+; 1+; 1+] 1+] z1+3y z1+3y m1+ m1+ 1*S 1*S ܽ
1* ܽ
1* `1*
`1* }1*de }1*de
}1*9 }1*9 !E1)3 !E1)3 91)] 91)] @AY1) @AY1) %1)T %1)T
}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/
u
V
7
AӔ>׃1-Io1- AӔ2Y1-cw1-I AӔ71,! 1-H AӔ 6QS1,y;Q1, AӔ$ }1,i1,^ AӔ D1,|1, AӔ 1,P}y1,| AӔ>&31,(eY1,P AӔ۱L1+[h'1,( AӔEi1+O1+@ AӔ՟|ȃ1+TY
1+ AӔW/1+VfE1+: AӔ* ɉ1+^1+; AӔζء1+31+] AӔxt)1+9z1+3y AӔ'Щ1*nm1+ AӔƽWz;1* 1*S AӔR0j1* ܽ
1* AӔXK1*d`1* AӔ
WS1*9}1*de AӔT7q1)N}1*9 AӔo]&M1)x!E1)3 AӔ͎1)91)] AӔ 11)s@AY1) AӔxW1)s%1)T
~qdWJ=0# o1- fE1+: eY1,P @AY1) ;Q1, 91)] !E1)3 1-H 1, O1+@ %1)T ܽ
1* }1*de }1*9 `1* 1+] w1-I z1+3y 1+; 1*S i1,^ }y1,| m1+ Y
1+ h'1,(
t`L8$p\H4 AӔy[o1- AӔ2w1-IAӔ8[ 1-HAӔ瞡+;Q1,AӔ%Ei1,^AӔ b1,AӔƚ}y1,|AӔ>eY1,PAӔ۲kh'1,(AӔO1+@AӔՠHY
1+AӔX:fE1+:AӔ+=ޡ1+;AӔη} 1+]AӔ ez1+3yAӔdm1+ AӔƾ:X1*SAӔR ܽ
1*AӔX`1*AӔat}1*deAӔ}1*9AӔ!E1)3AӔp.91)]AӔY@AY1)AӔa%1)T
t`L8$p\H4 AӔ?>׃1-IAӔ2Y1-cAӔ8+1,!AӔr6QS1,yAӔ%}1,AӔ 21,|AӔy 1,PAӔ>c31,(AӔ۲<1+[AӔi1+AӔՠi|ȃ1+TAӔX /1+VAӔ+ɉ1+^AӔηN1+3AӔt)1+9AӔة1*nAӔƾ z;1* AӔRaj1* AӔXY1*dAӔ1WS1*9AӔqq1)NAӔ&M1)xAӔ@Ē1)AӔ+ 11)sAӔW1)s
~qdWJ=0# o1- fE1+: eY1,P @AY1) ;Q1, 91)] !E1)3 1-H 1, O1+@ %1)T ܽ
1* }1*de }1*9 `1* 1+] w1-I z1+3y 1+; 1*S i1,^ }y1,| m1+ Y
1+ h'1,(
|fP:$t^H2
@ o1- @ fE1+:@ eY1,P@ @AY1)@ ;Q1,@ 91)]@ !E1)3@ 1-H@ 1,@ O1+@@ %1)T@ ܽ
1*@ }1*de@ }1*9@ `1*@ 1+]@ w1-I@ z1+3y@ 1+;@ 1*S@ i1,^@ }y1,|@ m1+ @ Y
1+@ h'1,(
t`L8$p\H4 |ȃ1+TY
1+z;1* 1*St)1+9z1+3yq1)N}1*9Y1-cw1-I>׃1-Io1- 6QS1,y;Q1,31,(eY1,P&M1)x!E1)3 11)s@AY1)1*d`1*j1* ܽ
1*WS1*9}1*de1,! 1-Hɉ1+^1+;1,P}y1,|1+[h'1,(1*nm1+ /1+VfE1+:i1+O1+@1+31+]}1,i1,^1,|1,1)s%1)T1)91)]
!2011-08-23 !2011-08-22! 2011-08-22
2 t`L8$p\H4
l
X
D
0
| h T @ , |ȃ1+T y1+T|ȃ1+T?u1+Tz;1* K~1* z;1* {i1* t)1+9=R1+9t)1+9N1+9q1)Nu8k1)Nq1)N." 1)NY1-cD1-cY1-c$1-c>׃1-I@U1-I>׃1-I릠s1-I6QS1,yN1,y6QS1,yԛ1,y31,(1,(31,(֣؏1,(&M1)xy}1)x&M1)x@1)x 11)sI1)t 11)s1)s1*df1*d1*d=}1*dj1* !1*!j1* 1*!WS1*96Pc1*9WS1*91*91,!sj1,!1,!1,!ɉ1+^a'[1+^ɉ1+^@t 1+^1,P
1,P1,P1,P1+[i!1+[1+[/#1+[1*nq1*o1*nM1*o/1+V
ݟ1+V/1+V1+Vi1+1+i1+ 1+1+3 1+31+331+3}1,:Q1,}1,1,1,|R1,|1,|:v1,|1)sȜY1)s1)se1)s1)91)1)21)
2 t`L8$p\H4
l
X
D
0
| h T @ , >i1)ou8k1)N >i1)osj1,! >i1)oq1*o >i1)oR1,| >i1)oD1-c >i1)o@t 1+^ >i1)o6Pc1*9 >i1)o21) >i1)o/#1+[ >i1)o1, >i1)o
ݟ1+V >i1)o1,P >i1)o1)s >i1)o{i1* >i1)o@U1-I >i1)o1+ >i1)oN1+9 >i1)o1*! >i1)o31+3 >i1)oԛ1,y >i1)o؏1,( >i1)o@1)x >i1)o=}1*d >i1)o勜e1)s >i1)o?u1+T]1)oi!1+[]1)oa'[1+^]1)oN1,y]1)oK~1* ]1)oI1)t]1)o=R1+9]1)o:v1,|]1)o:Q1,]1)o91)]1)o." 1)N]1)o$1-c]1)o y1+T]1)o
1,P]1)oy}1)x]1)o1,(]1)o!1*!]1)o1+V]1)o 1+3]1)oȜY1)s]1)o1*9]1)o弊1,!]1)o巤 1+]1)o妠s1-I]1)o妃M1*o]1)of1*d
2 aL9 iZG4$
i
R
@
.
n X B + !9¿Cómo es tu pueblo? u8k1)N 7¿Cómo es tu ciudad?/#1+[#una ciudad @1)x)un pueblo
21)ugly
1,Pugly!1*!#turístico @t 1+^#turística D1-c!tranquilo 31+3!tranquila sj1,!smallN1,ysmall=R1+9pretty1,(prettyf1*d pequeño N1+9 pequeña ԛ1,y peaceful 1+3 peaceful1,! moderno q1*o moderna 1,modern:Q1,modernM1*o#industrial
ݟ1+V!industrial1+V#importante ?u1+T important y1+T#histórico {i1* #histórica R1,| historicK~1* historic:v1,|grande 1+feo 1*!fea 1,Pbonito =}1*dbonita ؏1,(big 1+ 7appealing to touristsa'[1+^ 7appealing to tourists$1-c a village91)a cityy}1)x&CWhat’s your village like?." 1)N#=What’s your town like?i!1+[-Vivo en …
1)sMy townȜY1)s Mi ciudade1)s$?It’s the capital of …s1-I 7It’s a bit/very …1*9'I live in …I1)t 3Es un poco/muy … 6Pc1*9 7Es la capital de … @U1-I
2
yj[L=. {l]N?0!
|
m
^
O
@
1
"
o1- 2fE1+: eY1,P$@AY1);Q1,,91)]!E1)3 1-H.1,(O1+@ %1)Tܽ
1*}1*de }1*9
`1*1+]w1-I0z1+3y1+;1*Si1,^*}y1,|&m1+ Y
1+ h'1,("o1- 1fE1+:eY1,P#@AY1);Q1,+91)]!E1)3 1-H-1,'O1+@
%1)Tܽ
1*}1*de }1*9 `1*
1+]w1-I/z1+3y1+;1*Si1,^)}y1,|%m1+ Y
1+ h'1,(!
2
w ~qdWJ=0# {naTG:-
w o1- 2 o1- 1 fE1+: fE1+: eY1,P$ eY1,P# @AY1) @AY1) ;Q1,, ;Q1,+ 91)] 91)] !E1)3 !E1)3 1-H. 1-H- 1,( 1,' O1+@ O1+@ %1)T %1)T ܽ
1* ܽ
1* }1*de }1*de }1*9
}1*9 `1* `1*
1+] 1+] w1-I0 w1-I/ z1+3y z1+3y 1+; 1+; 1*S 1*S i1,^* i1,^) }y1,|& }y1,|% m1+ m1+ Y
1+ Y
1+ h'1,(" h'1,(!
xV4hF$
z
X
6
!|ȃ1+TAӔ՟Y
1+!z;1* AӔƽW1*S!t)1+9AӔxչz1+3y!q1)NAӔT7}1*9!Y1-cAӔ2w1-I!>׃1-IAӔo1- !6QS1,yAӔ ;Q1,!31,(AӔ>&eY1,P!&M1)xAӔo]!E1)3! 11)sAӔ@AY1)!1*dAӔXK`1*!j1* AӔR0ܽ
1*!WS1*9AӔ
}1*de!1,!AӔ7 1-H!ɉ1+^AӔ* 1+;!1,PAӔ }y1,|!1+[AӔ۱Lh'1,(!1*nAӔ'Ћm1+ !/1+VAӔWfE1+:!i1+AӔEO1+@!1+3AӔζء1+]!}1,AӔ$ i1,^!1,|AӔ D1,!1)sAӔxW%1)T!1)AӔ͎91)]
X.\2
`
6
d : )AӔ>׃1-IAӔo1- )AӔ2Y1-cAӔ2w1-I)AӔ71,!AӔ7 1-H)AӔ 6QS1,yAӔ ;Q1,)AӔ$ }1,AӔ$ i1,^)AӔ D1,|AӔ D1,)AӔ 1,PAӔ }y1,|)AӔ>&31,(AӔ>&eY1,P)AӔ۱L1+[AӔ۱Lh'1,()AӔEi1+AӔEO1+@)AӔ՟|ȃ1+TAӔ՟Y
1+)AӔW/1+VAӔWfE1+:)AӔ* ɉ1+^AӔ* 1+;)AӔζء1+3AӔζء1+])AӔxt)1+9AӔxչz1+3y)AӔ'Щ1*nAӔ'Ћm1+ )AӔƽWz;1* AӔƽW1*S)AӔR0j1* AӔR0ܽ
1*)AӔXK1*dAӔXK`1*)AӔ
WS1*9AӔ
}1*de)AӔT7q1)NAӔT7}1*9)AӔo]&M1)xAӔo]!E1)3)AӔ͎1)AӔ͎91)])AӔ 11)sAӔ@AY1))AӔxW1)sAӔxW%1)T
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
3
`
/IrHp LճڛH'
qm1,!1)oAӔ7AӔ8[tranquila peacefulAӔ7@ @ AӔ7Mӏٜ'
sm1,|1)oAӔ DAӔ bhistórica historicAӔ D@ @ AӔ DD@'
kci1+1)oAӔEAӔgrande bigAӔE@ @ AӔEJӏӌT'
ok1)s1)oAӔxWAӔaMi ciudadMy townAӔxW@ @ AӔxWBӏի'
eej1* 1)oAӔR0AӔR feo uglyAӔR0@ @ AӔR0d簯ӏe)
WS1*91)oAӔ
AӔatEs un poco/muy … It’s a bit/very …AӔ
@ @ AӔ
m矹ӏԹ)
q1)N1)oAӔT7AӔ¿Cómo es tu pueblo? What’s your village like?AӔT7@ @ AӔT7GؒӏՍ'
ki1*d1)oAӔXKAӔXbonito prettyAӔXK@ @ AӔXKLӏ'
qm1+31)oAӔζءAӔη} tranquilo peacefulAӔζء@ @ AӔζء[ݝ(
sY1-c1)oAӔ2AӔ2turística appealing to touristsAӔ2@ @ AӔ2Hדֳy'
ogt)1+91)oAӔxAӔ epequeño smallAӔx@ @ AӔxՁ[ׄ;(
sɉ1+^1)oAӔ* AӔ+=turístico appealing to touristsAӔ* @ @ AӔ* MϡӏS'
smz;1* 1)oAӔƽWAӔƾ:Xhistórico historicAӔƽW@ @ AӔƽWHڽӏټ^'
mi}1,1)oAӔ$ AӔ%Emoderna modernAӔ$ @ @ AӔ$ B͟'
ee1,P1)oAӔ AӔfea uglyAӔ @ @ AӔ H۶ӏփ '
mi1*n1)oAӔ'AӔdmoderno modernAӔ'@ @ AӔ'ЁN֡ӏ'
so|ȃ1+T1)oAӔ՟AӔՠHimportante importantAӔ՟@ @ AӔ՟iڄب)
1+[1)oAӔ۱LAӔ۲k¿Cómo es tu ciudad?What’s your town like?AӔ۱L@ @ AӔ۱L
*N
{
jĶӏ )
>׃1-I1)oAӔAӔy[Es la capital de … It’s the capital of …AӔ@ @ AӔOӏצ:'
sq/1+V1)oAӔWAӔX:industrial industrialAӔW@ @ AӔWG˓Ќ'
ki31,(1)oAӔ>&AӔ>bonita prettyAӔ>&@ @ AӔ>&W'
}w 11)s1)oAӔAӔYVivo en …
I live in …AӔ@ @ AӔH抓'
og6QS1,y1)oAӔ AӔ瞡+pequeña smallAӔ @ @ AӔ Q֓]'
yo1)1)oAӔ͎AӔp.un pueblo
a villageAӔ͎@ @ AӔ͎KѢӏ3'
si&M1)x1)oAӔo]AӔuna ciudad a cityAӔo]@ @ AӔo]
; \
=
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