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ӔE'AӔE8BasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt e ?hexCache{"4933193328513521601": "44763931f26017c1", "-6876522526963394623": "a091af31f26017c1", "3119742412543498178": "2b4b8d31f26017c2", "9135755468291971009": "7ec8b931f26017c1", "-6778177808928598079": "a1ef1331f26017c1"}(
EcssCache.fma091af31f26017c1 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fma1ef1331f26017c1 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq2b4b8d31f26017c2 {text-align:center;}
#cmq44763931f26017c1 {text-align:center;}
#cma2b4b8d31f26017c2 {text-align:center;}
#cma44763931f26017c1 {text-align:center;}
.cmb2b4b8d31f26017c2 {background:#FFFFFF;}
.cmb44763931f26017c1 {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`BackArial1$Ф
~ȹ1`FrontArial1
" " eǓ
~ȹ1`Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFeӏ
~ȹ1`Reverse%(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)
)
\ q*^"
- S \ 5ӏÊ*
7 ~ȹ1`AӔcAӔߵuna manzana an apple5ӏĽ
7 ~ȹ1`AӔ]FAӔ^b9Bebo … I drink …0u
- ~ȹ1`AӔ%AӔ&fComo... I eat...5坓·
7 ~ȹ1`AӔ7AӔ7|(un plátano a bananaC΅
S ~ȹ1`AӔ$AӔ
un zumo de naranja an orange juiceAďO
O ~ȹ1`AӔzAӔz¿Qué bebes? What do you drink?8B
= ~ȹ1`AӔ ~AӔ Guna limonada a lemonade[|
~ȹ1`AӔ[VAӔ\-¿Qué comes en el recreo? What do you eat at lunch break?@V
M ~ȹ1`AӔ~ qAӔ~unos patatas fritas some crisps<ӏ
E ~ȹ1`AӔ
AӔ,^una hamburguesa a hamburger2÷
1 ~ȹ1`AӔ:AӔ;ekuna pizza a pizza;Գ
C ~ȹ1`AӔT&AӔ Bebe … He/She drinks …:ʔƢ
A ~ȹ1`AӔ$VAӔ$suna Coca-Cola a Coca-Cola9
? ~ȹ1`AӔeAӔ< Come … He/She eats …=Țő
G ~ȹ1`AӔ'AӔagua mineral a mineral water8
= ~ȹ1`AӔuAӔ un bocadillo a sandwichC
S ~ȹ1`AӔuqAӔV¿Qué comes? What are you eating?
Y Y $%
M -%#
AӔ9{AӔ%;A~ȹ1`0ba9e410f8485b0392a91e91c9a385eeAӔ4V2? XPriorityVeryHighPriorityHighPriorityLowX8@
:
a |
8_ QƢ'
wq%K1bBDv91`AӔ ~AӔ 2una limonada a lemonadeAӔ ~@ @ AӔ ~T볏őw'
oo1bkDv91`AӔT&AӔIBebe … He/She drinks …AӔT&@ @ AӔT&Vӏ'
w{h'1bDv91`AӔ'AӔDagua mineral a mineral waterAӔ'@ @ AӔ'K:'
qk5O1aDv91`AӔ:AӔ;una pizza a pizzaAӔ:@ @ AӔ:IΓ'
kmR1`uDv91`AӔ%AӔ&SComo...I eat...AӔ%@ @ AӔ%āNē'
umA1a7Dv91`AӔ7AӔ7
un plátano a bananaAӔ7@ @ AӔ7R'
o{1`
Dv91`AӔeAӔjCome … He/She eats …AӔe@ @ AӔeQӏ·'
wq1a Dv91`AӔuAӔNun bocadillo a sandwichAӔu@ @ AӔuyՓZ)
z/1``|Dv91`AӔ[VAӔ\]¿Qué comes en el recreo?
What do you eat at lunch break?AӔ[V@ @ AӔ[VUÊ'
}s1a_Dv91`AӔ
AӔ]Buna hamburguesa a hamburgerAӔ
@ @ AӔ
]终a(
yw1` Dv91`AӔuqAӔ;¿Qué comes? What are you eating?AӔuq@ @ AӔuq[ܑĽ(
y(1bODv91`AӔzAӔ{) ¿Qué bebes? What do you drink?AӔz@ @ AӔzN퓏÷'
umw=1a*Dv91`AӔcAӔuna manzana an appleAӔc@ @ AӔc܁Zͯď4(
sۉ1aVDv91`AӔ~ qAӔ~unos patatas fritas some crispsAӔ~ q@ @ AӔ~ qNӏ'
osls1b=Dv91`AӔ]FAӔ^Bebo … I drink …AӔ]F@ @ AӔ]FSɬ'
ysP1c"Dv91`AӔ$VAӔ$una Coca-Cola a Coca-ColaAӔ$V@ @ AӔ$V]ﳏ&(
{;8)1bDv91`AӔ$AӔ<>un zumo de naranja an orange juiceAӔ$@ @ AӔ$
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)
" e'rF
i
6
_ 1 [ +
L
ɇ÷ 5O1aѡ1`a pizza' /o1bk1`He/She drinks …*Åӏ 5w1` 1`What are you eating?!ڤӏV #ۉ1aV1`some crisps$ )w1` 1`¿Qué comes? ³÷ !5O1aѠ1`una pizza · A1a7ԡ1`a banana&ʅ -1a_1`una hamburguesa !Ƣ #P1c"1`a Coca-Cola#ӏ '1a 1`un bocadillo #ӏő 'h'1b1`agua mineral ݧv R1`u1`I eat...
1`
1`Come … $ӏƢ )P1c"1`una Coca-Cola Ҭ o1bk1`Bebe … "ӓÊ* %w=1a*1`una manzana $ďO )(1bO1`¿Qué bebes? Ľ ls1b=1`Bebo … !ݳ #1a_1`a hamburger)ӏ 3;8)1b1`un zumo de naranja %ő +h'1b1`a mineral water 〓 !1a 1`a sandwich!ܒӏĽ #ls1b=1`I drink … ӏB !%K1bB1`a lemonade%ؽ +;8)1b1`an orange juice"ӏ· %A1a7Ԡ1`un plátano թӏu R1`u1`Como...*ѶóV 5ۉ1aV1`unos patatas fritas (óďO 1(1bO1`What do you drink? ³Ê* w=1a*1`an apple4ӏ| I
z/1``|1`¿Qué comes en el recreo?
%
+1`
1`He/She eats …#ŠB '%K1bB1`una limonada 5ӏ| K
z/1``|1`What do you eat at lunch break?
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
"
|l[K:* tdSC2"
" 1cQ! 1cQ \g1c" \g1c" _{1b& _{1b& "E1b "E1b U[1bw U[1bw ~1bj ~1bj G1b= G1b= 5{1b4 5{1b4
[1a:
[1a: i1a i1a 1a
1a v!1a^ v!1a^
1a7 1a7 G1a G1a q1` q1` b1`Z b1`Z G1``a G1``a
}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Ӕ$VP1c"1cQ AӔ ~%K1bB\g1c" AӔ$;8)1b_{1b& AӔ'h'1b"E1b AӔT&o1bkU[1bw AӔ]Fls1b=~1bj AӔz(1bOG1b= AӔ~ qۉ1aV5{1b4 AӔ:5O1a
[1a: AӔcw=1a*i1a AӔ
1a_ 1a AӔ7A1a7v!1a^ AӔu1a 1a7 AӔe1`
G1a AӔ%R1`u q1` AӔ[V
z/1``|b1`Z AӔuqw1` G1``a
# ~qdWJ=0# \g1c" U[1bw "E1b
[1a: q1` v!1a^ G1a 1a7 b1`Z 1a G1``a G1b= i1a 5{1b4 ~1bj 1cQ _{1b&
t`L8$ AӔ$1cQAӔ 2\g1c"AӔ<>_{1b&AӔD"E1bAӔIU[1bwAӔ^ɓ~1bjAӔ{) G1b=AӔ~5{1b4AӔ;
[1a:AӔi1aAӔ]B 1aAӔ7
v!1a^AӔN1a7AӔjG1a AӔ&S q1`AӔ\]b1`ZAӔ;G1``a
t`L8$ AӔ$sP1c"AӔ G%K1bBAӔ
;8)1bAӔאh'1bAӔ o1bkAӔ^b9ls1b=AӔz(1bOAӔ~ۉ1aVAӔ;ek5O1aAӔߵw=1a*AӔ,^1a_AӔ7|(A1a7AӔ ɍ1a AӔ< 1`
AӔ&fR1`uAӔ\-
z/1``|AӔVw1`
# ~qdWJ=0# \g1c" U[1bw "E1b
[1a: q1` v!1a^ G1a 1a7 b1`Z 1a G1``a G1b= i1a 5{1b4 ~1bj 1cQ _{1b&
|fP:$ @ \g1c"@ U[1bw@ "E1b@
[1a:@ q1`@ v!1a^@ G1a @ 1a7@ b1`Z@ 1a@ G1``a@ G1b=@ i1a@ 5{1b4@ ~1bj@ 1cQ@ _{1b&
t`L8$ w=1a*i1als1b=~1bjR1`u q1`A1a7v!1a^;8)1b_{1b&(1bOG1b=%K1bB\g1c"
z/1``|b1`Zۉ1aV5{1b41a_ 1a5O1a
[1a:o1bkU[1bwP1c"1cQ1`
G1a h'1b"E1b1a 1a7w1` G1``a
!2011-08-23 !2011-08-22! 2011-08-22
"
X t`L8$p\H4
l
X w=1a*1a*w=1a*1a*ls1b=1b=ls1b=K1b=R1`u5u?1`vR1`u1`uA1a7E>1a7A1a7Աн1a7;8)1b۫E1b;8)1ba1b(1bO1bO(1bO1bO%K1bB1bB%K1bB1bB
z/1``|1``|
z/1``|1``|ۉ1aVai%1aVۉ1aV1aV1a_C(+1a_1a_1a_5O1a$?1a5O1aH1ao1bksG1bko1bk Ia1bkP1c"A1c"P1c""E1c"1`
#1`
1`
'1`
h'1b:1bh'1b1b1a @u1a 1a 1a w1` q -1` w1` K1`
"
X t`L8$p\H4
l
X 1`$?1a1`sG1bk1`q -1` 1`ai%1aV1`E>1a71`A1c"1`5u?1`v1`1a_1`1b1`1a 1`K1b=1`1bB1`a1b1`1bO1`1a*1`'1`
1`1``|1`K1` 1`H1a1`C(+1a_1`@u1a 1`:1b1`#1`
1`"E1c"1` Ia1bk1`1a*1`1bO1`1b=1`۫E1b1`н1a71`1`u1`1aV1`1``|1`1bB
" v_K+
o\F-
}
a
H
0
)¿Qué comes? K1` )I¿Qué comes en el recreo?
1``|)¿Qué bebes? 1bO 5unos patatas fritas 1aV!una pizza H1a%una manzana 1a*'una limonada 1bB-una hamburguesa C(+1a_)una Coca-Cola "E1c" 3un zumo de naranja ۫E1b%un plátano н1a7'un bocadillo @u1a #some crispsai%1aV+an orange juicea1b an apple1a*'agua mineral :1b!a sandwich1a a pizza$?1a+a mineral water1b!a lemonade1bB#a hamburger1a_ a bananaE>1a7#a Coca-ColaA1c"*KWhat do you eat at lunch break?1``| 1What do you drink?1bO 5What are you eating?q -1` I eat...5u?1`v#I drink …K1b=+He/She eats …'1`
/He/She drinks …sG1bkComo...1`u Come … #1`
Bebo … 1b= Bebe … Ia1bk
" zk\M>/ {l]N?0! \g1c" U[1bw"E1b
[1a: q1`v!1a^ G1a 1a7
b1`Z 1aG1``aG1b=i1a5{1b4~1bj1cQ"_{1b& \g1c" U[1bw"E1b
[1a: q1`v!1a^ G1a 1a7 b1`Z 1a
G1``aG1b=i1a5{1b4~1bj1cQ!_{1b&
"G ~qdXK>1$
{naTG \g1c" \g1c" U[1bw U[1bw "E1b "E1b
[1a:
[1a: q1` q1` v!1a^ v!1a^ G1a G1a 1a7
1a7 b1`Z b1`Z 1a 1a
G1``a G1``a G1b= G1b= i1a i1a 5{1b4 5{1b4 ~1bj ~1bj 1cQ" 1cQ! _{1b& _{1b&
xV4hF$
!w=1a*AӔcܭi1a!ls1b=AӔ]F~1bj!R1`uAӔ% q1`!A1a7AӔ7v!1a^!;8)1bAӔ$_{1b&!(1bOAӔzظG1b=!%K1bBAӔ ~\g1c"!
z/1``|AӔ[Vb1`Z!ۉ1aVAӔ~ q5{1b4!1a_AӔ
1a!5O1aAӔ:
[1a:!o1bkAӔT&U[1bw!P1c"AӔ$V1cQ!1`
AӔeG1a !h'1bAӔ'"E1b!1a AӔu1a7!w1` AӔuqG1``a
6 X.\2
`
6 )AӔ$VP1c"AӔ$V1cQ)AӔ ~%K1bBAӔ ~\g1c")AӔ$;8)1bAӔ$_{1b&)AӔ'h'1bAӔ'"E1b)AӔT&o1bkAӔT&U[1bw)AӔ]Fls1b=AӔ]F~1bj)AӔz(1bOAӔzظG1b=)AӔ~ qۉ1aVAӔ~ q5{1b4)AӔ:5O1aAӔ:
[1a:)AӔcw=1a*AӔcܭi1a)AӔ
1a_AӔ
1a)AӔ7A1a7AӔ7v!1a^)AӔu1a AӔu1a7)AӔe1`
AӔeG1a )AӔ%R1`uAӔ% q1`)AӔ[V
z/1``|AӔ[Vb1`Z)AӔuqw1` AӔuqG1``a
-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