SQLite format 3 @ ! 0 2 N ! - 0 6=- V
##stablefieldModelsfieldModelsCREATE TABLE "fieldModels" (
id INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
required BOOLEAN NOT NULL,
"unique" BOOLEAN NOT NULL,
numeric BOOLEAN NOT NULL,
"quizFontFamily" TEXT,
"quizFontSize" INTEGER,
"quizFontColour" VARCHAR(7),
"editFontFamily" TEXT,
"editFontSize" INTEGER,
PRIMARY KEY (id),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistory {tablestatsstatsCREATE TABLE stats (
id INTEGER NOT NULL,
type INTEGER NOT NULL,
day DATE NOT NULL,
reps INTEGER NOT NULL,
"averageTime" FLOAT NOT NULL,
"reviewTime" FLOAT NOT NULL,
"distractedTime" FLOAT NOT NULL,
"distractedReps" INTEGER NOT NULL,
"newEase0" INTEGER NOT NULL,
"newEase1" INTEGER NOT NULL,
"newEase2" INTEGER NOT NULL,
"newEase3" INTEGER NOT NULL,
"newEase4" INTEGER NOT NULL,
"youngEase0" INTEGER NOT NULL,
"youngEase1" INTEGER NOT NULL,
"youngEase2" INTEGER NOT NULL,
"youngEase3" INTEGER NOT NULL,
"youngEase4" INTEGER NOT NULL,
"matureEase0" INTEGER NOT NULL,
"matureEase1" INTEGER NOT NULL,
"matureEase2" INTEGER NOT NULL,
"matureEase3" INTEGER NOT NULL,
"matureEase4" INTEGER NOT NULL,
PRIMARY KEY (id)
)]tablemodelsmodelsCREATE TABLE models (
id INTEGER NOT NULL,
"deckId" INTEGER,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
spacing FLOAT NOT NULL,
"initialSpacing" FLOAT NOT NULL,
source INTEGER NOT NULL,
PRIMARY KEY (id)
)`tablemediamediaCREATE TABLE media (
id INTEGER NOT NULL,
filename TEXT NOT NULL,
size INTEGER NOT NULL,
created FLOAT NOT NULL,
"originalPath" TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id)
)JktablesourcessourcesCREATE TABLE sources (
id INTEGER NOT NULL,
name TEXT NOT NULL,
created FLOAT NOT NULL,
"lastSync" FLOAT NOT NULL,
"syncPeriod" INTEGER NOT NULL,
PRIMARY KEY (id)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars
u '
mediaLocationpageSize4096b9hexCache{"5249069825203997237": "48d87131fc818a35", "7509557979771931189": "68374f31fc818a35", "3313676472643848757": "2dfc8b31fc818a35", "-1571570237797463499": "ea30a931fc818a35", "337252316765850165": "4ae2931fc818a35"}(
EcssCache.fmea30a931fc818a35 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm68374f31fc818a35 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq2dfc8b31fc818a35 {text-align:center;}
#cmq48d87131fc818a35 {text-align:center;}
#cma2dfc8b31fc818a35 {text-align:center;}
#cma48d87131fc818a35 {text-align:center;}
.cmb2dfc8b31fc818a35 {background:#FFFFFF;}
.cmb48d87131fc818a35 {background:#FFFFFF;}
!revSpacing0.1)latexPost\end{document}>
qlatexPre\documentclass[12pt]{article}
\special{papersize=3in,5in}
\usepackage[utf8]{inputenc}
\usepackage{amssymb,amsmath}
\pagestyle{empty}
\setlength{\parindent}{0in}
\begin{document}
mediaURL!newSpacing60#
revInactive#
newInactive
revActive
newActive
perDay1!leechFails16)suspendLeeches1
+wiYJ8 'mediaLocationpageSize) suspendLeeches!revSpacing#revInactive
revActive
perDay!newSpacing#newInactive
newActivemediaURL !leechFailslatexPre
latexPosthexCachecssCache
/œ5
AӕGOkAӕGOkBasicBasic?<
" !2011-08-24" !2011-08-24
#5
)15BackArial1$5
)15FrontArial1
" " e5
)15Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFe5
)15Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFF
1 1
V
r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVarsJktablesourcessourcesCREATE 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)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistory 4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)V
##stablefieldModelsfieldModelsCREATE TABLE "fieldModels" (
id INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
required BOOLEAN NOT NULL,
"unique" BOOLEAN NOT NULL,
numeric BOOLEAN NOT NULL,
"quizFontFamily" TEXT,
"quizFontSize" INTEGER,
"quizFontColour" VARCHAR(7),
"editFontFamily" TEXT,
"editFontSize" INTEGER,
PRIMARY KEY (id),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
yu !!tablecardModelscardModelsCREATE 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)
)
. NC
x
. @V
M )15AӕGAӕGqmvoy al instituto I go to school6
9 )15AӕG!
gAӕG!me visto I get dressed9
? )15AӕG*SAӕG+desayuno I have breakfast>ӏ
I )15AӕG#wAӕG#me peino I comb/brush my hair2ӏ;
1 )15AӕGg1AӕGgme ducho I shower7ӏ)
; )15AӕGӱAӕGӲ1me despierto I wake up4
5 )15AӕGՂAӕGՃZme levanto I get upFޛӏ+
Y )15AӕGhAӕGDJPor la mañana ... In the morning ...\
)15AӕG AӕGh¿Qué haces por la mañana? What do you do in the morning?BҤ
Q )15AӕGDAӕGˀMi rutina diaria My daily routine
Y Y $%
M -%#
AӕG>AӕG(A)153b411237e7c9c750e31728d9cdafa5afAӕGz$? XPriorityVeryHighPriorityHighPriorityLowX8@
" &:
b
" [ӏ˰'
}I1-15AӕGDAӕGˀMi rutina diaria My daily routineAӕGD@ @ AӕGDPϳ˺'
wo'11)-15AӕGӱAӕGӲbme despierto I wake upAӕGӱ@ @ AӕGӱz)
1-15AӕG AӕG}¿Qué haces por la mañana?
What do you do in the morning?AӕG @ @ AӕG Yԟ'
yc71V-15AӕGAӕGvoy al instituto I go to schoolAӕG@ @ AӕGR;'
m}fy1-15AӕG*SAӕG+6desayunoI have breakfastAӕG*S@ @ AӕG*SK'
omR1h;-15AӕGg1AӕGgme ducho I showerAӕGg1@ @ AӕGg1XƔl(
oX|1-15AӕG#wAӕG$%me peino I comb/brush my hairAӕG#w@ @ AӕG#wMӏ'
sm1K-15AӕGՂAӕGՃme levanto I get upAӕGՂ@ @ AӕGՂa)
x1+-15AӕGhAӕGrPor la mañana ... In the morning ...AӕGh@ @ AӕGhOܳ'
mwi[1-15AӕG!
gAӕG!me vistoI get dressedAӕG!
g@ @ AӕG!
g
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'1uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)d&3indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId).%%tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" (
"factId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("factId") REFERENCES facts (id)
)8KtablefieldsfieldsCREATE TABLE fields (
id INTEGER NOT NULL,
"factId" INTEGER NOT NULL,
"fieldModelId" INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY("fieldModelId") REFERENCES "fieldModels" (id),
FOREIGN KEY("factId") REFERENCES facts (id)
)0%%#tablemediaDeletedmediaDeletedCREATE TABLE "mediaDeleted" (
"mediaId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
.%%tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" (
"factId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("factId") REFERENCES facts (id)
)8KtablefieldsfieldsCREATE TABLE fields (
id INTEGER NOT NULL,
"factId" INTEGER NOT NULL,
"fieldModelId" INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY("fieldModelId") REFERENCES "fieldModels" (id),
FOREIGN KEY("factId") REFERENCES facts (id)
)0%%#tablemediaDeletedmediaDeletedCREATE TABLE "mediaDeleted" (
"mediaId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("mediaId") REFERENCES cards (id)
).%%tablecardsDeletedcardsDeletedCREATE TABLE "cardsDeleted" (
"cardId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("cardId") REFERENCES cards (id)
)
tabletagstagsCREATE TABLE tags (
id integer not null,
tag text not null collate nocase,
priority integer not null default 2,
primary key(id))!tablecardTagscardTagsCREATE TABLE cardTags (
id integer not null,
cardId integer not null,
tagId integer not null,
src integer not null,
primary key(id))K%%[tablesqlite_stat1sqlite_stat1CREATE TABLE sqlite_stat1(tbl,idx,stat)n7indexix_cards_typeCombinedcardsCREATE INDEX ix_cards_typeCombined on cards
(type, combinedDue, factId)d9indexix_cards_relativeDelaycardsCREATE INDEX ix_cards_relativeDelay on cards
(relativeDelay)T/qindexix_cards_modifiedcardsCREATE INDEX ix_cards_modified on cards
(modified)T/qindexix_facts_modifiedfactsCREATE INDEX ix_facts_modified on facts
(modified)T/qindexix_cards_prioritycardsCREATE INDEX ix_cards_priority on cards
(priority)T+uindexix_cards_factorcardsCREATE INDEX ix_cards_factor on cards
(type, factor)N+iindexix_cards_factIdcards CREATE INDEX ix_cards_factId on cards (factId)S-qindexix_stats_typeDaystats!CREATE INDEX ix_stats_typeDay on stats (type, day)R-mindexix_fields_factIdfields"CREATE INDEX ix_fields_factId on fields (factId)e9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)
Y pCT$
u
D
Y Ϻӏ X|1015me peino 4ӏ I1h7O15What do you do in the morning?ӏ* '11)h7O15I wake up)賏+ 3x1+015Por la mañana ... ҡӏ; R1h;h7O15I shower'V /c71V015voy al instituto ; R1h;015me ducho & -fy1h7O15I have breakfast˓ fy1015desayuno$ӏV )c71Vh7O15I go to school&鴦 -I1h7O15My daily routine#* ''11)015me despierto *ࢤӏ 5X|1h7O15I comb/brush my hair(ӏ+ 1x1+h7O15In the morning ...'ܕǓ /I1015Mi rutina diaria ! #1K015me levanto # 'i[1h7O15I get dressed6 M1015¿Qué haces por la mañana?
Î i[1015me visto 1Kh7O15I get up
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
|l[K:* P1K P1K 5S1; 5S1; 1 1 1l
1l li1 li1
21h 21h %{1K %{1K +11 +11 1 1 zTe1˰ zTe1˰
^P?3$ # fieldModels0' modelsDeleted0 fields0' reviewHistory0 models0
stats0
cardTags0
media0
! cardModels0 sources0+CdeckVarssqlite_autoindex_deckVars_112 1% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
eF' AӕGc71VP1KAӕG*Sfy15S1;AӕG!
gi[11AӕG#wX|11lAӕGg1R1h;li1AӕGՂ1K21hAӕGӱ'11)%{1KAӕGhx1+ +11AӕG 11AӕGDI1zTe1˰
~ ~ zTe1˰%{1K1P1K5S1;li11l21h +111
8 t`L8 AӕGP1KAӕG+65S1;AӕG!1AӕG$%1lAӕGgli1AӕGՃ21hAӕGӲb%{1KAӕGr +11AӕG}1AӕGˀzTe1˰
8 t`L8 AӕGqmc71VAӕG+fy1AӕG!i[1AӕG#X|1AӕGgR1h;AӕGՃZ1KAӕGӲ1'11)AӕGDJx1+AӕGh1AӕGˀϤI1
~ ~ zTe1˰%{1K1P1K5S1;li11l21h +111
$ |fP:$ @ zTe1˰@ %{1K@ 1@ P1K@ 5S1;@ li1@ 1l@ 21h@ +11@ 1
8 t`L8 c71VP1Ki[11fy15S1;X|11lR1h;li1'11)%{1K1K21hx1+ +1111I1zTe1˰
!2011-08-24! 2011-08-24
p t`L8$p c71Vi1Vc71V1Vi[1^1i[181fy1U1fy1Y1X|1{=1X|1%1R1h;I
1h;R1h;;1h;'11)%511*'11)11*1Kկ^1K1KՀJo1Kx1+C1+x1+w1+1;11ʇq1I111I1V91
p t`L8$p h7O15;1h7O15%511*h7O15I
1h;h7O15U1h7O151Vh7O1511h7O15%1h7O15w1+h7O15^1h7O15Jo1K015{=1015C1+015i1V015;1h;015Y101511*015V91015^1K015q101581
}iT6r[F2
+M¿Qué haces por la mañana?
q1/voy al instituto i1Vme visto81me peino {=1#me levanto ^1Kme ducho ;1h;'me despierto 11*desayunoY1)IWhat do you do in the morning?;13Por la mañana ... C1+-My daily routine11/Mi rutina diaria V911In the morning ...w1+I wake up%511*I showerI
1h;-I have breakfastU1)I go to school1VI get upJo1K'I get dressed^15I comb/brush my hair%1
yk\M>/ zTe1˰%{1K1P1K5S1;li11l21h
+111
zTe1˰%{1K1P1K5S1;li11l
21h +111
~qdWJ=0#
zTe1˰ zTe1˰%{1K%{1K11P1KP1K5S1;5S1;li1li11l1l
21h
21h +11 +1111
xV4 !c71VAӕGP1K!i[1AӕG!
g1!fy1AӕG*S5S1;!X|1AӕG#w1l!R1h;AӕGg1li1!'11)AӕGӱ%{1K!1KAӕGՂ21h!x1+AӕGh +11!1AӕG 1!I1AӕGDzTe1˰
\ X.\ )AӕGc71VAӕGP1K)AӕG*Sfy1AӕG*S5S1;)AӕG!
gi[1AӕG!
g1)AӕG#wX|1AӕG#w1l)AӕGg1R1h;AӕGg1li1)AӕGՂ1KAӕGՂ21h)AӕGӱ'11)AӕGӱ%{1K)AӕGhx1+AӕGh +11)AӕG 1AӕG 1)AӕGDI1AӕGDzTe1˰
-PriorityVeryHigh# PriorityLow%PriorityHighForward Basic
; \
=
mx
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&3indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z'1uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)(9Yindexix_cards_intervalDesc2cards,CREATE INDEX ix_cards_intervalDesc2 on cards (type, priority desc, interval desc, factId, combinedDue)x)-9indexix_cards_dueAsc2cards-CREATE INDEX ix_cards_dueAsc2 on cards (type, priority desc, due, factId, combinedDue)[*/indexix_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, due0))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinal