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ӔrAӔzBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt e ?hexCache{"-1974475278846466651": "e4994131f290e5a5", "710868566740624805": "9dd8331f290e5a5", "-8191949651129080411": "8e505931f290e5a5", "-2249900742581099098": "e0c6bf31f290e5a6", "-4390258455721482843": "c312ab31f290e5a5"}%
?cssCache.fmc312ab31f290e5a5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fme4994131f290e5a5 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqe0c6bf31f290e5a6 {text-align:center;}
#cmq9dd8331f290e5a5 {text-align:center;}
#cmae0c6bf31f290e5a6 {text-align:center;}
#cma9dd8331f290e5a5 {text-align:center;}
.cmbe0c6bf31f290e5a6 {background:#FFFFFF;}
.cmb9dd8331f290e5a5 {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
#ʡ
PY1BackArial1$ճʡ
PY1FrontArial1
" " eʡ
PY1Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFeʡ
PY1Reverse%(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)
)
~?-
< g %
6ӏʤ/
9 PY1AӔ
5AӔ}Fun pasillo a corridor^ӏʢY
PY1AӔAӔ6 ¿Qué hay en tu casa/piso? What is there in your house/flat?Lӏʢ
e PY1AӔAӔ¿Qué hay abajo? What is there downstairs?>ʵʤ
I PY1AӔ AӔ ]un cuarto de baño a bathroom8ӏʥ9
= PY1AӔ+AӔun dormitorio a bedroom6ʣA
9 PY1AӔ7JAӔ8 -Hay … There’s …K±ʢ
c PY1AӔVAӔWc¿Qué hay arriba? What is there upstairs?6ɓʦt
9 PY1AӔpAӔ
tuna terraza a terraceQӏʦ
o PY1AӔ5+AӔeel dormitorio de mis padres my parents’ bedroomIӏʣ
_ PY1AӔAӔ0M¿Qué hay fuera? What is there outside?9⓳ʣ
? PY1AӔoNAӔoun comedor a dining roomR쥦ʧ9
q PY1AӔ/xAӔ/fel dormitorio de mi hermano my brother’s bedroom3뫦ʦt
3 PY1AӔTAӔUp
un garaje a garage4듏ʦ
5 PY1AӔiPAӔjsqun jardín a garden1ӏʤk
/ PY1AӔ_AӔ*un aseo a toilet5듏ʥu
7 PY1AӔ *KAӔ +>!una cocina a kitchen6ۮʡ
9 PY1AӔzAӔ{LLas habitaciones Rooms8ӏʥ
= PY1AӔ AӔ Gun salón a living room
Y Y $%
M -%#
AӔӘAӔ/!APY126ba1eea50c8dbaf9baf1a319292bc1bAӔݴ? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 w
$ Ci p͗ʧ )
1r
݃1AӔ5+AӔel dormitorio de mis padres
my parents’ bedroomAӔ5+@ @ AӔ5+gꏳʢ)
<.1E ݃1AӔAӔI¿Qué hay abajo? What is there downstairs?AӔ@ @ AӔJʤ'
mm-1*k ݃1AӔ_AӔ[un aseo a toiletAӔ_@ @ AӔ_Oʣ'
mwY1A ݃1AӔ7JAӔ8;Hay … There’s …AӔ7J@ @ AӔ7JOʦ'
uoBI1Ot ݃1AӔpAӔ<6una terraza a terraceAӔp@ @ AӔpOʢ?'
}gs1 ݃1AӔzAӔ{VLas habitacionesRoomsAӔz@ @ AӔz|̳ʢź)
P1Y ݃1AӔAӔe¿Qué hay en tu casa/piso?
What is there in your house/flat?AӔ@ @ AӔQսʦY'
yo}19 ݃1AӔ+AӔϯun dormitorio a bedroomAӔ+@ @ AӔ+Rʤ'
sw创1 ݃1AӔoNAӔoun comedor a dining roomAӔoN@ @ AӔoNqʪ4)
ؕ319 ݃1AӔ/xAӔ/el dormitorio de mi hermano
my brother’s bedroomAӔ/x@ @ AӔ/xdΓʣ&)
n1 ݃1AӔAӔ_g¿Qué hay fuera? What is there outside?AӔ@ @ AӔMʦY'
smӳY1. ݃1AӔiPAӔjun jardín a gardenAӔiP@ @ AӔiPLأʦ'
qm֭31t ݃1AӔTAӔUun garaje a garageAӔT@ @ AӔTNصʥ '
so7Y1u ݃1AӔ *KAӔ +nuna cocina a kitchenAӔ *K@ @ AӔ *Kf؝ӏʣ)
1o ݃1AӔVAӔW¿Qué hay arriba? What is there upstairs?AӔV@ @ AӔVXЗʤP(
q))1 ݃1AӔ AӔ ~un cuarto de baño a bathroomAӔ @ @ AӔ QճʥZ'
qwR1 ݃1AӔ AӔ }un salón a living roomAӔ @ @ 0͗ʧ
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)
$ Z oF M
c
$ s @ V #
t
O
Z +Ɠʦ
71r
A1my parents’ bedroom ʤk -1*kA1a toilet 곏ʥ9 }19A1a bedroom$ʥ9 )}191un dormitorio 7ӏʢZ OP1YA1What is there in your house/flat?ӏʡ s1A1Rooms!ӏʦ #ӳY1.1un jardín ʦt BI1OtA1a terrace!ʣ #创11un comedor &ӎʡ -s11Las habitaciones)ʢ 3 1o1¿Qué hay arriba? !ӏʤ/ #_1K/1un pasillo (ʣ 1n11¿Qué hay fuera? #ʣB 'Y1AA1There’s …,ʣ 9n1A1What is there outside? ӏʤ !))1A1a bathroom)ʤ 3))11un cuarto de baño Փʦu ֭31tA1a garage!ӏʥu #7Y1u1una cocina ,ʧ9 9ؕ319A1my brother’s bedroom ʣA Y1A1Hay … 5ʦ
K1r
1el dormitorio de mis padres
ʥ !R11un salón ټʦu !֭31t1un garaje #ʥ 'R1A1a living room-ʢ ; 1oA1What is there upstairs?(ӏʢ 1<.1E1¿Qué hay abajo? 5فӏʧ9 Kؕ3191el dormitorio de mi hermano
/ဓʢ ?<.1EA1What is there downstairs?"хʦt %BI1Ot1una terraza #ʣ '创1A1a dining room ɦʤk -1*k1un aseo Ȓӏʥu 7Y1uA1a kitchen ƙʤ0 !_1K/A1a corridor5ƋӏʢZ KP1Y1¿Qué hay en tu casa/piso?
Äʦ ӳY1.A1a garden
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
$
|l[K:* tdSC2"
$ 14# 14" O41 ! O41 >1q >1q s1OY s1OY a 1. a 1. 7U1Y 7U1Y Q1 Q1 1Z 1Z d31k d31k Gs1K Gs1K ^1*P ^1*P %1
%1 D)1 D)1
q1& q1& w1 w1 G{1o G{1o ;c1E ;c1E =_1? =_1?
}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Ӕ/xؕ31914 AӔ5+1r
O41 AӔpBI1Ot>1q AӔiPӳY1.s1OY AӔT֭31ta 1. AӔ+}197U1Y AӔ *K7Y1uQ1 AӔ R11Z AӔ
5_1K/d31k AӔ_-1*kGs1K AӔ ))1^1*P AӔoN创1%1 AӔ7JY1AD)1 AӔn1q1& AӔV 1ow1 AӔ<.1EG{1o AӔP1Y;c1E AӔzs1=_1?
~qdWJ=0# d31k O41 G{1o Gs1K D)1 >1q =_1? ;c1E 7U1Y %1 14 q1& s1OY a 1. Q1 w1 ^1*P 1Z
t`L8$ AӔ/14AӔO41 AӔ<6>1qAӔjs1OYAӔUa 1.AӔϯ7U1YAӔ +nQ1 AӔ }Е1ZAӔd31kAӔ[Gs1KAӔ ~^1*PAӔo%1AӔ8;D)1AӔ_gq1&AӔWw1AӔIG{1oAӔe;c1EAӔ{V=_1?
t`L8$ AӔ/fؕ319AӔe1r
AӔ
tBI1OtAӔjsqӳY1.AӔUp
֭31tAӔ}19AӔ +>!7Y1uAӔ GR1AӔ}F_1K/AӔ*-1*kAӔ ]))1AӔo创1AӔ8 -Y1AAӔ0Mn1AӔWc 1oAӔ<.1EAӔ6 P1YAӔ{Ls1
~qdWJ=0# d31k O41 G{1o Gs1K D)1 >1q =_1? ;c1E 7U1Y %1 14 q1& s1OY a 1. Q1 w1 ^1*P 1Z
t |fP:$t @ d31k@ O41 @ G{1o@ Gs1K@ D)1@ >1q@ =_1?@ ;c1E@ 7U1Y@ %1@ 14@ q1&@ s1OY@ a 1.@ Q1 @ w1@ ^1*P@ 1Z
t`L8$ _1K/d31kP1Y;c1E<.1EG{1o))1^1*P}197U1YY1AD)1 1ow1BI1Ot>1q1r
O41 n1q1&创1%1ؕ31914֭31ta 1.ӳY1.s1OY-1*kGs1K7Y1uQ1 s1=_1?R11Z
!2011-08-23 !2011-08-22! 2011-08-22
$
0 t`L8$p\H4
l
X
D
0 _1K/M1K/_1K/g1K0P1YO:1ZP1Y-1Z<.1EԽ͵1E<.1Eԥ1E))1 OU1))11}19jGS19}19f19Y1A /1BY1A1A 1or1o 1o>/1oBI1Ot2j1OtBI1Ot1Ot1r
|f11r
1r
v1r
n11n1 k1创1*W1创11ؕ319o19ؕ319d
19֭31t1u֭31te1uӳY1.Dm1.ӳY1.g1.-1*knz1*k-1*kg1*k7Y1uZ1u7Y1uI1us1F1s1'Lw1R11R1n1
$
0 t`L8$p\H4
l
X
D
0 A1|f11r
A1nz1*kA1jGS19A1O:1ZA1F1A12j1OtA1 /1BA1 k1A1 OU1A11uA1o19A1n1A1>/1oA1奥1EA1奕1A1奐I1uA1奌g1K0A1奆g1.1f191Dm1.1*W11'Lw11r1o1M1K/11111Z1u11A1v1r
111e1u1好͵1E1奻d
191奢1Ot1奒g1*k1奌-1Z
$ * T2x_J6
r
S
9
#
s H * 1¿Qué hay fuera? 1*K¿Qué hay en tu casa/piso?
-1Z 3¿Qué hay arriba? r1o 1¿Qué hay abajo? ͵1E%una terraza 1Ot#una cocina Z1u!un salón 1#un pasillo M1K/#un jardín Dm1.!un garaje e1u)un dormitorio f19 3un cuarto de baño 1#un comedor *W1 un aseo g1*k 7my parents’ bedroom|f11r
!9my brother’s bedroomo19*Kel dormitorio de mis padres
v1r
*Kel dormitorio de mi hermano
d
19 a toiletnz1*k a terrace2j1Ot'a living roomn1 a kitchenI1u a gardeng1. a garage1u'a dining room1!a corridorg1K0 a bedroomjGS19!a bathroom OU1";What is there upstairs?>/1o!9What is there outside? k1,OWhat is there in your house/flat?O:1Z$?What is there downstairs?1E'There’s … /1BRoomsF1-Las habitaciones'Lw1 Hay … 1A
$
yj[M>/ {l]N?0!
d31kO41 "G{1oGs1KD)1 >1q =_1?;c1E7U1Y%114$q1&
s1OY a 1. Q1 w1^1*P1Zd31kO41 !G{1oGs1KD)1 >1q
=_1?;c1E7U1Y%1
14#q1& s1OY a 1.Q1 w1^1*P1Z
$- ~qdWJ=0# {naTG:- d31k d31k O41 " O41 ! G{1o G{1o Gs1K Gs1K D)1 D)1 >1q >1q =_1? =_1? ;c1E ;c1E 7U1Y 7U1Y %1 %1
14$ 14# q1&
q1& s1OY s1OY a 1. a 1. Q1 Q1 w1 w1 ^1*P ^1*P 1Z 1Z
xV4hF$
!_1K/AӔ
5d31k!P1YAӔ;c1E!<.1EAӔG{1o!))1AӔ ^1*P!}19AӔ+7U1Y!Y1AAӔ7JD)1! 1oAӔVw1!BI1OtAӔp>1q!1r
AӔ5+O41 !n1AӔq1&!创1AӔoN%1!ؕ319AӔ/x14!֭31tAӔTεa 1.!ӳY1.AӔiPs1OY!-1*kAӔ_Gs1K!7Y1uAӔ *KQ1 !s1AӔz=_1?!R1AӔ ꕖ1Z
X.\2
`
6
)AӔ/xؕ319AӔ/x14)AӔ5+1r
AӔ5+O41 )AӔpBI1OtAӔp>1q)AӔiPӳY1.AӔiPs1OY)AӔT֭31tAӔTεa 1.)AӔ+}19AӔ+7U1Y)AӔ *K7Y1uAӔ *KQ1 )AӔ R1AӔ ꕖ1Z)AӔ
5_1K/AӔ
5d31k)AӔ_-1*kAӔ_Gs1K)AӔ ))1AӔ ^1*P)AӔoN创1AӔoN%1)AӔ7JY1AAӔ7JD)1)AӔn1AӔq1&)AӔV 1oAӔVw1)AӔ<.1EAӔG{1o)AӔP1YAӔ;c1E)AӔzs1AӔz=_1?
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
$A
P w
$ Ci p͗ʧ )
1r
݃1AӔ5+AӔel dormitorio de mis padres
my parents’ bedroomAӔ5+@ @ AӔ5+gꏳʢ)
<.1E ݃1AӔAӔI¿Qué hay abajo? What is there downstairs?AӔ@ @ AӔJʤ'
mm-1*k ݃1AӔ_AӔ[un aseo a toiletAӔ_@ @ AӔ_Oʣ'
mwY1A ݃1AӔ7JAӔ8;Hay … There’s …AӔ7J@ @ AӔ7JOʦ'
uoBI1Ot ݃1AӔpAӔ<6una terraza a terraceAӔp@ @ AӔpOʢ?'
}gs1 ݃1AӔzAӔ{VLas habitacionesRoomsAӔz@ @ AӔz|̳ʢź)
P1Y ݃1AӔAӔe¿Qué hay en tu casa/piso?
What is there in your house/flat?AӔ@ @ AӔQսʦY'
yo}19 ݃1AӔ+AӔϯun dormitorio a bedroomAӔ+@ @ AӔ+Rʤ'
sw创1 ݃1AӔoNAӔoun comedor a dining roomAӔoN@ @ AӔoNqʪ4)
ؕ319 ݃1AӔ/xAӔ/el dormitorio de mi hermano
my brother’s bedroomAӔ/x@ @ AӔ/xdΓʣ&)
n1 ݃1AӔAӔ_g¿Qué hay fuera? What is there outside?AӔ@ @ AӔMʦY'
smӳY1. ݃1AӔiPAӔjun jardín a gardenAӔiP@ @ AӔiPLأʦ'
qm֭31t ݃1AӔTAӔUun garaje a garageAӔT@ @ AӔTNصʥ '
so7Y1u ݃1AӔ *KAӔ +nuna cocina a kitchenAӔ *K@ @ AӔ *Kf؝ӏʣ)
1o ݃1AӔVAӔW¿Qué hay arriba? What is there upstairs?AӔV@ @ AӔVXЗʤP(
q))1 ݃1AӔ AӔ ~un cuarto de baño a bathroomAӔ @ @ AӔ QճʥZ'
qwR1 ݃1AӔ AӔ }un salón a living roomAӔ @ @ AӔ
& & OƳʥk'
sq_1K/ ݃1AӔ
5AӔun pasillo a corridorAӔ
5@ @ AӔ
5
; \
=
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