SQLite format 3 @ = 2 2 N = - 2 6=- 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 (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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars
j u Yt d =hexCache{"2112391849401837084": "1d50b931f206e61c", "1543917949562578460": "156d1931f206e61c", "-5574696361635944931": "b2a2b331f206e61d", "5198294378057491996": "48240d31f206e61c", "-284772197568420323": "fc0c4931f206e61d"}(
EcssCache.fm156d1931f206e61c {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm1d50b931f206e61c {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqb2a2b331f206e61d {text-align:center;}
#cmqfc0c4931f206e61d {text-align:center;}
#cmab2a2b331f206e61d {text-align:center;}
#cmafc0c4931f206e61d {text-align:center;}
.cmbb2a2b331f206e61d {background:#FFFFFF;}
.cmbfc0c4931f206e61d {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
/ӏȍ
AӔAӔBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
#ԗȍ
H$
1 BackArial1$ۣȍ
H$
1 FrontArial1
" " eȍ
H$
1 Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe٨ֳȍ
H$
1 Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFF
1 1
V
r 7tabledeckVarsdeckVarsCREATE 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
##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 (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
yu !!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)
)
~? m'
P r 5 F
V
t * PȘƁ
m H$
1 AӔq4AӔqNo hay rotuladores. There are no felt-tip pens.@ȏ
M H$
1 AӔ)ŇAӔ)3No tengo … I don’t have …6ӏȕ
9 H$
1 AӔZpIAӔZpla ventana the windowLȑL
e H$
1 AӔ95HAӔ9No hay … There isn’t/There aren’t …BӏȖ
Q H$
1 AӔb8nYAӔb8Klos rotuladores the felt-tip pensHӏȘ
] H$
1 AӔo :?AӔo Hay unas sillas. There are some chairs.:ȓ׆
A H$
1 AӔL5VAӔL6Kel ordenador the computerP鳏ȎK
m H$
1 AӔ I AӔ ¿Cómo se escribe … ? How do you spell … ?5ԓȏ
7 H$
1 AӔ&"UAӔ&#Tengo … I have …XӏȐ
} H$
1 AӔ3?AӔ3 ¿Qué hay en la clase? What is there in the classroom?DȔp
U H$
1 AӔOuAӔO"[el proyector the overhead projector3哏ȕ
3 H$
1 AӔVAӔV la puerta the door8겳Ȑl
= H$
1 AӔ0 AӔ0 Necesito … I need …?Ȓm
K H$
1 AӔC0AӔCel profesor the teacher (male)IȐ
_ H$
1 AӔ-48eAӔ-4¿No tienes … ? Don’t you have … ?9ߢȑQ
? H$
1 AӔ6YqAӔ6Hay … There is/are …@묰ȓ
M H$
1 AӔG!p?AӔG!el equipo de música the stereo@Ȏ
M H$
1 AӔ#)AӔ#*$Se escribe … You spell it …<Ȓ!
E H$
1 AӔ@F AӔ@G/el alumno the pupil (male)Iӏȗ
_ H$
1 AӔkYAӔkHay unos alumnos. There are some pupils.6ȗ
9 H$
1 AӔh,AӔh-3las sillas the chairs5Ȕ
7 H$
1 AӔS)AӔS*a|la pizarra the board5ˬȖ
7 H$
1 AӔejAӔeku las mesas the tables9ӏȍ
? H$
1 AӔwAӔxSEn clase In the classroom5ӏȖ7
7 H$
1 AӔ_k?AӔ_kclos libros the books
Y Y $%
M -%#
AӔ\>AӔqk#AH$
1 a38441b77588df6b953fd73529a18531AӔT la pizarra the boardAӔS)@ @ AӔS)힁R瓏Ȏ0'
m} 1 I1 AӔwAӔx[En claseIn the classroomAӔw@ @ AӔwׁLȕǫ'
qm&)1
I1 AӔVAӔVOla puerta the doorAӔV@ @ AӔVkȎ)
8#K1-K I1 AӔ I AӔ ¿Cómo se escribe … ? How do you spell … ?AӔ I @ @ AӔ I Oȳȗۺ'
sq1 I1 AӔh,AӔh-Dlas sillas the chairsAӔh,@ @ AӔh,Zμȓl(
qֱ1 I1 AӔG!p?AӔG"el equipo de música the stereoAӔG!p?@ @ AӔG!p?Yȏm'
{}#1n I1 AӔ#)AӔ#*SXSe escribe … You spell it …AӔ#)@ @ AӔ#)Rȑ0'
m}}1Q I1 AӔ6YqAӔ6Hay … There is/are …AӔ6Yq@ @ AӔ6Yqk벌Ș )
{1 F I1 AӔq4AӔq4No hay rotuladores. There are no felt-tip pens.AӔq4@ @ AӔq4ʁOֳȖ '
sqh51
I1 AӔZpIAӔZpla ventana the windowAӔZpI@ @ AӔZpIf˗Ȓ(
s Pğ1L I1 AӔ95HAӔ9No hay … There isn’t/There aren’t …AӔ95H@ @ AӔ95HN܁ճȏ'
qq31 I1 AӔ&"UAӔ&#ETengo … I have …AӔ&"U@ @ AӔ&"UQ米Ȑ'
wq1Bl I1 AӔ0 AӔ0 9*Necesito … I need …AӔ0 @ @ AӔ0 ݁[ӻȖ'
}D]1 S I1 AӔb8nYAӔb9los rotuladores the felt-tip pensAӔb8nY@ @ AӔb8nYNȗ'
qqy1 ~ I1 AӔejAӔek las mesas the tablesAӔej@ @ AӔejbӏȘe(
C-1 I1 AӔo :?AӔo Hay unas sillas. There are some chairs.AӔo :?@ @ AӔo :?dijȐQ)
s1 I1 AӔ-48eAӔ-4¿No tienes … ? Don’t you have … ?AӔ-48e@ @ 0ȕp
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 k>|F
_
) a 7 x H
U
g 5 {R"pF "ȓ׆ %>1 ׆ P1 the computer"ӏȒm %h/1 lmm1 el profesor !Ȗ7 #A1 7m1 los libros ȏ !31m1 Tengo … (Ȑ 1s1 m1 ¿No tienes … ? ȑQ }1Qm1 Hay … !ȕ #h51
m1 la ventana #Ȕp ')71
'pm1 el proyector &Ȏ -#1n P1 You spell it … ۳Ȕ
o1
\
P1 the board/ӏȎL ?8#K1-Km1 ¿Cómo se escribe … ? ӏȕ &)1
P1 the door%ӏȎ +#1nm1 Se escribe … ȗ !1 P1 the chairs(ӏȒm 1h/1 lm P1 the teacher (male)1ӏȘƂ C{1 F P1 There are no felt-tip pens. ȏ !31 P1 I have … ӏȖ7 A1 7 P1 the books!Ȕ
#o1
\
m1 la pizarra +ӏȓ 7ֱ1 m1 el equipo de música '铏Ȗ /D]1 S P1 the felt-tip pens,Ȑ 9s1 P1 Don’t you have … ?(ȗ 1E1 m1 Hay unos alumnos. &ӏȖ -D]1 S m1 los rotuladores 逳Ȗ !y1 ~ P1 the tables&ӏȍ - 1 P1 In the classroom!ӏȗ #1 m1 las sillas !铏Ȓ! #1
!m1 el alumno Ȗ !y1 ~m1 las mesas 5ӏȐ K-1o P1 What is there in the classroom? ׅȐm !1Bl P1 I need … Ɠȕ !&)1
m1 la puerta 6ɓȑL MPğ1L P1 There isn’t/There aren’t … ȕ !h51
P1 the window*疘ȘƁ 5{1 Fm1 No hay rotuladores. ,巡ӏȘ 9C-1 P1 There are some chairs.#ӏȓ׆ '>1 ׆m1 el ordenador 'ӏȘ /C-1 m1 Hay unas sillas. 蓏ȍ 1m1 En clase,〆Ȕp 9)71
'p P1 the overhead projector!ԈӏȑL #Pğ1Lm1 No hay … ,ܾȗ 9E1 P1 There are some pupils. ѳȓ !ֱ1 P1 the stereo(ȏ 1l8c1 P1 I don’t have …&Ȓ! -1
! P1 the pupil (male),՟ⓏȎL 98#K1-K P1 How do you spell … ?#ӏȏ 'l8c1m1 No tengo … #ȀӏȐm '1Blm1 Necesito … .ݫȐ =-1om1 ¿Qué hay en la clase? &ȑQ -}1Q P1 There is/are …
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
2 |l[K:* tdSC2"
}
l
\
K
;
*
2 a1 t 1 a1 t 0 1 Fe/ 1 Fe. X1 - X1 , C1 ۺ+ C1 ۺ* 1 ) 1 ( 1 ~' 1 ~& yk1 R% yk1 R$ ҳ1 # ҳ1 " ;ə1
ǫ! ;ə1
ǫ ?/1
p ?/1
p y
1
[ y
1
[ @ 1
& @ 1
& 91 l 91 l Ol1 Ol1 qD1 lR qD1 lR ,1
,1
10 10 a'16 a'16 1o
1o #1BQ #1BQ
M71 M71 1 1 1m 1m $1n $1n <{91-0 <{91-0
^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'mN/
u
V
7
AӔq4{1 Fa1 t AӔo :?C-1 1 Fe AӔkYE1 X1 AӔh,1 C1 ۺ AӔejy1 ~Α1 AӔb8nYD]1 S 1 ~ AӔ_k?A1 7yk1 R AӔZpIh51
ƻҳ1 AӔV&)1
;ə1
ǫ AӔS)o1
\
?/1
p AӔOu)71
'py
1
[ AӔL5V>1 ׆@ 1
& AӔG!p?ֱ1 91 l AӔC0h/1 lmOl1 AӔ@F 1
!qD1 lR AӔ95HPğ1L,1
AӔ6Yq}1Q10 AӔ3?-1oa'16 AӔ0 1Bl1o AӔ-48es1 ̀#1BQ AӔ)Ňl8c1M71 AӔ&"U311 AӔ#)#1n 1m AӔ I 8#K1-K$1n AӔwד 1<{91-0
~qdWJ=0# yk1 R y
1
[ qD1 lR a'16 X1 Ol1 M71 @ 1
& ?/1
p <{91-0 ;ə1
ǫ $1n C1 ۺ 91 l 1m 10 a1 t ҳ1 ,1
1 1o 1 ~ 1 1 Fe #1BQ
t`L8$p\H4 AӔq4a1 t AӔo 1 FeAӔkX1 AӔh-D C1 ۺAӔek 1 AӔb91 ~AӔ_kyk1 RAӔZpԻҳ1 AӔVO;ə1
ǫAӔS*?/1
pAӔOQey
1
[AӔL6{)@ 1
&AӔG" 91 lAӔCcOl1 AӔ@G^qD1 lRAӔ9ǹ,1
AӔ610AӔ3K^a'16AӔ0 9*1oAӔ-4䀶#1BQAӔ)-M71 AӔ&#Eȸ1AӔ#*SX 1mAӔ $1nAӔx[<{91-0
t`L8$p\H4 AӔq{1 FAӔo C-1 AӔkE1 AӔh-31 AӔeku y1 ~AӔb8KD]1 S AӔ_kcA1 7AӔZph51
AӔV &)1
AӔS*a|o1
\
AӔO"[)71
'pAӔL6K>1 ׆AӔG!ֱ1 AӔCh/1 lmAӔ@G/1
!AӔ9Pğ1LAӔ6}1QAӔ3 -1oAӔ0 1BlAӔ-4s1 AӔ)3l8c1AӔAӔ#*$#1nAӔ 8#K1-KAӔxS 1
~qdWJ=0# yk1 R y
1
[ qD1 lR a'16 X1 Ol1 M71 @ 1
& ?/1
p <{91-0 ;ə1
ǫ $1n C1 ۺ 91 l 1m 10 a1 t ҳ1 ,1
1 1o 1 ~ 1 1 Fe #1BQ
|fP:$t^H2
@ yk1 R@ y
1
[@ qD1 lR@ a'16@ X1 @ Ol1 @ M71 @ @ 1
&@ ?/1
p@ <{91-0@ ;ə1
ǫ@ $1n@ C1 ۺ@ 91 l@ 1m@ 10@ a1 t @ ҳ1 @ ,1
@ 1@ 1o@ 1 ~@ 1 @ 1 Fe@ #1BQ
t`L8$p\H4 {1 Fa1 t l8c1M71 h51
ƻҳ1 Pğ1L,1
D]1 S 1 ~C-1 1 Fe>1 ׆@ 1
&8#K1-K$1n311-1oa'16)71
'py
1
[&)1
;ə1
ǫ1Bl1oh/1 lmOl1 s1 ̀#1BQ}1Q10ֱ1 91 l#1n 1m1
!qD1 lRE1 X1 1 C1 ۺo1
\
?/1
py1 ~Α1 1<{91-0A1 7yk1 R
!2011-08-23 !2011-08-22! 2011-08-22
2 t`L8$p\H4
l
X
D
0
| h T @ , {1 F31 F{1 FX1 Fl8c1#1l8c1E1h51
Wk1
h51
?1
Pğ1LI1LPğ1LPE1LD]1 S I1 S D]1 S 1 S C-1
1 C-1 1 >1 ׆ 1 ׆>1 ׆51 ׆8#K1-KI1-L8#K1-K1-L31vq131'1-1o1o-1ouY1o)71
'pSA1
'p)71
'p 31
'p&)1
?1
&)1
r11
1Bl\)1Bm1Bl 1Bmh/1 lmy1 lmh/1 lm31 lms1 ek1 s1 L1 }1Q]#1Q}1Q)1Qֱ1 51 ֱ1 1 #1nKy1n#1n91n1
!_I1
!1
!,1
!E1 `1 E1 ָ?1 1 851 1 Q1 o1
\
J1
\
o1
\
e1
\
y1 ~1 ~y1 ~1 ~ 11 1A1A1 7v_1 7A1 7%1 7
2 t`L8$p\H4
l
X
D
0
| h T @ , P1 1 ׆ P1 Ky1n P1 J1
\
P1 ?1
P1 851 P1 31 lm P1 31 F P1 '1 P1 %1 7 P1 I1 S P1 L1 P1 1 ~ P1 1 P1 1o P1 \)1Bm P1 I1L P1 ?1
P1
1 P1 31
'p P1 ?1 P1 1 P1 #1 P1 ,1
! P1 1-L P1 )1Qm1 y1 lmm1 v_1 7m1 vq1m1 ek1 m1 ]#1Qm1 Wk1
m1 SA1
'pm1 I1-Lm1 91nm1 e1
\
m1 51 m1 `1 m1 1 S m1 Q1 m1 _I1
!m1 1 ~m1 r11
m1 X1 Fm1 51 ׆m1 1 m1 A1m1 PE1Lm1 E1m1 1Bmm1 uY1o
2
{Y;%oY2
{
_
H
'
l U 9 $ r \ F (
#=¿Qué hay en la clase? uY1o 1¿No tienes … ? ek1 $?¿Cómo se escribe … ? I1-L!the window?1
1the teacher (male)31 lm!the tables1 ~!the stereo1 -the pupil (male),1
!!9the overhead projector 31
'p /the felt-tip pensI1 S the door?1
%the computer 1 ׆!the chairs851 the books%1 7 the boardJ1
\
-los rotuladores 1 S #los libros v_1 7#las sillas Q1 !las mesas 1 ~#la ventana Wk1
!la puerta r11
#la pizarra e1
\
'el proyector SA1
'p%el profesor y1 lm'el ordenador 51 ׆ 7el equipo de música 51 #el alumno _I1
!-You spell it …Ky1n*KWhat is there in the classroom?1o+MThere isn’t/There aren’t …I1L-There is/are …)1Q!9There are some pupils.?1 !9There are some chairs.
1 &CThere are no felt-tip pens.31 F!Tengo … vq1+Se escribe … 91n'No tengo … E1#No hay … PE1L 5No hay rotuladores. X1 F'Necesito … 1Bm-In the classroom1!I need …\)1Bm!I have …'1 1I don’t have …#1!9How do you spell … ?1-L Hay … ]#1Q 1Hay unos alumnos. `1 /Hay unas sillas. 1 En claseA1!9Don’t you have … ?L1
2
yj[L=. {l]N?0!
|
m
^
O
@
1
"
yk1 R&y
1
[ qD1 lRa'16X1 .Ol1 M71
@ 1
& ?/1
p <{91-0;ə1
ǫ"$1n C1 ۺ, 91 l 1m10a1 t 2ҳ1 $,1
11o1 ~(1 *1 Fe0#1BQ yk1 R%y
1
[ qD1 lRa'16X1 -Ol1 M71 @ 1
&?/1
p
<{91-0;ə1
ǫ!$1n C1 ۺ+ 91 l 1m10a1 t 1ҳ1 #,1
11o
1 ~'1 )1 Fe/#1BQ
2
w ~qdWJ=0# znaTG:-
w yk1 R& yk1 R% y
1
[ y
1
[ qD1 lR qD1 lR a'16 a'16 X1 . X1 - Ol1 Ol1 M71
M71 @ 1
& @ 1
& ?/1
p ?/1
p <{91-0 <{91-0 ;ə1
ǫ" ;ə1
ǫ! $1n $1n C1 ۺ, C1 ۺ+ 91 l 91 l 1m 1m 10 10 a1 t 2 a1 t 1 ҳ1 $ ҳ1 # ,1
,1
1 1 1o 1o
1 ~( 1 ~' 1 * 1 ) 1 Fe0 1 Fe/ #1BQ #1BQ
xV4hF$
z
X
6
!{1 FAӔq4a1 t !l8c1AӔ)ŇM71 !h51
AӔZpIҳ1 !Pğ1LAӔ95H,1
!D]1 S AӔb8nY1 ~!C-1 AӔo :?1 Fe!>1 ׆AӔL5V@ 1
&!8#K1-KAӔ I $1n!31AӔ&"U1!-1oAӔ3?a'16!)71
'pAӔOuy
1
[!&)1
AӔV;ə1
ǫ!1BlAӔ0 ݱ1o!h/1 lmAӔC0Ol1 !s1 AӔ-48e#1BQ!}1QAӔ6Yq10!ֱ1 AӔG!p? 91 l!#1nAӔ#) 1m!1
!AӔ@F qD1 lR!E1 AӔkYX1 !1 AӔh, C1 ۺ!o1
\
AӔS)?/1
p!y1 ~AӔej1 ! 1AӔw<{91-0!A1 7AӔ_k?yk1 R
X.\2
`
6
d : )AӔq4{1 FAӔq4a1 t )AӔo :?C-1 AӔo :?1 Fe)AӔkYE1 AӔkYX1 )AӔh,1 AӔh, C1 ۺ)AӔejy1 ~AӔej1 )AӔb8nYD]1 S AӔb8nY1 ~)AӔ_k?A1 7AӔ_k?yk1 R)AӔZpIh51
AӔZpIҳ1 )AӔV&)1
AӔV;ə1
ǫ)AӔS)o1
\
AӔS)?/1
p)AӔOu)71
'pAӔOuy
1
[)AӔL5V>1 ׆AӔL5V@ 1
&)AӔG!p?ֱ1 AӔG!p? 91 l)AӔC0h/1 lmAӔC0Ol1 )AӔ@F 1
!AӔ@F qD1 lR)AӔ95HPğ1LAӔ95H,1
)AӔ6Yq}1QAӔ6Yq10)AӔ3?-1oAӔ3?a'16)AӔ0 1BlAӔ0 ݱ1o)AӔ-48es1 AӔ-48e#1BQ)AӔ)Ňl8c1AӔ)ŇM71 )AӔ&"U31AӔ&"U1)AӔ#)#1nAӔ#) 1m)AӔ I 8#K1-KAӔ I $1n)AӔwד 1AӔw<{91-0
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
$
K e
.Ioy Nȕp'
soo1
\
I1 AӔS)AӔS*la pizarra the boardAӔS)@ @ AӔS)힁R瓏Ȏ0'
m} 1 I1 AӔwAӔx[En claseIn the classroomAӔw@ @ AӔwׁLȕǫ'
qm&)1
I1 AӔVAӔVOla puerta the doorAӔV@ @ AӔVkȎ)
8#K1-K I1 AӔ I AӔ ¿Cómo se escribe … ? How do you spell … ?AӔ I @ @ AӔ I Oȳȗۺ'
sq1 I1 AӔh,AӔh-Dlas sillas the chairsAӔh,@ @ AӔh,Zμȓl(
qֱ1 I1 AӔG!p?AӔG"el equipo de música the stereoAӔG!p?@ @ AӔG!p?Yȏm'
{}#1n I1 AӔ#)AӔ#*SXSe escribe … You spell it …AӔ#)@ @ AӔ#)Rȑ0'
m}}1Q I1 AӔ6YqAӔ6Hay … There is/are …AӔ6Yq@ @ AӔ6Yqk벌Ș )
{1 F I1 AӔq4AӔq4No hay rotuladores. There are no felt-tip pens.AӔq4@ @ AӔq4ʁOֳȖ '
sqh51
I1 AӔZpIAӔZpla ventana the windowAӔZpI@ @ AӔZpIf˗Ȓ(
s Pğ1L I1 AӔ95HAӔ9No hay … There isn’t/There aren’t …AӔ95H@ @ AӔ95HN܁ճȏ'
qq31 I1 AӔ&"UAӔ&#ETengo … I have …AӔ&"U@ @ AӔ&"UQ米Ȑ'
wq1Bl I1 AӔ0 AӔ0 9*Necesito … I need …AӔ0 @ @ AӔ0 ݁[ӻȖ'
}D]1 S I1 AӔb8nYAӔb9los rotuladores the felt-tip pensAӔb8nY@ @ AӔb8nYNȗ'
qqy1 ~ I1 AӔejAӔek las mesas the tablesAӔej@ @ AӔejbӏȘe(
C-1 I1 AӔo :?AӔo Hay unas sillas. There are some chairs.AӔo :?@ @ AӔo :?dijȐQ)
s1 I1 AӔ-48eAӔ-4¿No tienes … ? Don’t you have … ?AӔ-48e@ @ AӔ-48e
"=
Y j l
NﭳȖ'
soA1 7 I1 AӔ_k?AӔ_klos libros the booksAӔ_k?@ @ AӔ_k?^Ȕ(
w )71
'p I1 AӔOuAӔOQeel proyector the overhead projectorAӔOu@ @ AӔOuUѓȒR'
s}1
! I1 AӔ@F AӔ@G^el alumno the pupil (male)AӔ@F @ @ AӔ@F sӏȑ6)
-1o I1 AӔ3?AӔ3K^¿Qué hay en la clase? What is there in the classroom?AӔ3?@ @ AӔ3?d߳Ș )
E1 I1 AӔkYAӔkHay unos alumnos. There are some pupils.AӔkY@ @ AӔkYYۑȓ(
uh/1 lm I1 AӔC0AӔCcel profesor the teacher (male)AӔC0@ @ AӔC0ZӏȐ(
wl8c1 I1 AӔ)ŇAӔ)-No tengo … I don’t have …AӔ)Ň@ @ AӔ)ŇہSȔ'
wu>1 ׆ I1 AӔL5VAӔL6{)el ordenador the computerAӔL5V@ @ AӔL5V
; \
=
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