SQLite format 3 @ 4 3 3 N 4 - 3 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
u '
mediaLocation pageSize4096
sortIndex0c ;hexCache{"-4053500034381521456": "c7bf1331f1a7ddd0", "842429531035262416": "bb0e931f1a7ddd0", "6992358705000340943": "6109d931f1a7ddcf", "4411534434749636048": "3d38eb31f1a7ddd0", "-5901829658207855153": "ae187d31f1a7ddcf"}%
?cssCache.fmae187d31f1a7ddcf {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm3d38eb31f1a7ddd0 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqc7bf1331f1a7ddd0 {text-align:center;}
#cmqbb0e931f1a7ddd0 {text-align:center;}
#cmac7bf1331f1a7ddd0 {text-align:center;}
#cmabb0e931f1a7ddd0 {text-align:center;}
.cmbc7bf1331f1a7ddd0 {background:#FFFFFF;}
.cmbbb0e931f1a7ddd0 {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
wiYJ<* 'mediaLocation pageSize) suspendLeeches
sortIndex!revSpacing #revInactive
revActive
perDay!newSpacing#newInactive
newActive mediaURL !leechFails latexPre
latexPost hexCache cssCache
/»
AӔ1AӔFBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
#Ν
a 1BackArial1$׆ӏ
a 1FrontArial1
" " e읓
a 1Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeⳏ
a 1Forward%(Front)s%(Back)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)
)
Z(_)
Y
S " N
}
J
+ٲV
# a 1AӔR AӔRtreinta 30.T
) a 1AӔHFAӔHveinticinco 25)ֺߣ
a 1AӔ=%nPAӔ=%veinte 20)ѿ`
a 1AӔ AӔ 'kcuatro 4'
a 1AӔ,gcAӔ,h*xdoce 12.ӏ֓
) a 1AӔ;\JAӔ;] diecinueve 19&
a 1AӔuAӔdos 2.
) a 1AӔC
dAӔC
~5veintitrés 23(͊ӏH
a 1AӔ-bAӔ-cotrece 13.ӏئI
) a 1AӔJ-NQAӔJ-veintiséis 26.ӏ
) a 1AӔL÷AӔL*|veintisiete 27(
a 1AӔ QAӔ)diez 10'ӏ
a 1AӔAӔseis 6(㳏d
a 1AӔi^AӔ#7
Wnueve 9'ӏ
a 1AӔ AӔ Pcero 0-N
' a 1AӔ6vBAӔ6w[dieceiocho 18)՜N
a 1AӔ0#͎AӔ0$?quince 15/
+ a 1AӔD AӔD ?veinticuatro 24'ќ:
a 1AӔVOAӔV+tres 3-
' a 1AӔNAӔN
veintiocho 28.ӏٌ\
) a 1AӔQ AӔQ
Pveintinueve 29&ӏ
a 1AӔ WKAӔ uno 1,ӏ
% a 1AӔ>AӔ>aveintiuno 21*سՅG
! a 1AӔ.UAӔ.džcatorce 14(ӏӊ9
a 1AӔ+5eAӔ+~once 11'ũӏҩ
a 1AӔkrAӔ$4Ңocho 8(ӏL
a 1AӔAӔ
cinco 5(쳏ҐD
a 1AӔ( AӔ(6siete 7-湓ח
' a 1AӔA@AӔA@veintidós 22.Ӫ擏հK
) a 1AӔ2AӔ2qLdieciséis 16-Ƴ
' a 1AӔ4AӔ4Jdiecisiete 17
Y Y $%
M -%#
AӔAӔ\c^Aa 13ae4d33acd40e0d0eab01b3d743bf825AӔz!? XPriorityVeryHighPriorityHighPriorityLowX8@ 2
V J~Dy Gʳ'
sa@qI1ǿ1AӔC
dAӔ\nveintitrés23A g@@ @ A g@@ӏҐ)'
g_*=1
ǿ1AӔAӔ\nseis 6AH=@ @ AH=BӮ0'
k_le1`ǿ1AӔ AӔ\ncuatro 4A5 >@ @ A5 >Gئ.'
sao1Tǿ1AӔHFAӔ\nveinticinco25A 5@ @ A 5@ϖڽ'
g_ 1ǿ1AӔ AӔ\ncero 0A@ c@ @ A@ cEחi'
oa1{ǿ1AӔ>AӔ\nveintiuno21AscD ^@ @ AscD ^AՅ,'
ga14U1vHǿ1AӔ-bAӔ\ntrece13A8@ @ A8Gs'
sa/]1G ǿ1AӔL÷AӔ\nveintisiete27AWX@ @ AWXBj'
iamY1_ǿ1AӔ=%nPAӔ\nveinte20A ;z@ @ A ;zBʳհ0'
ia1Nǿ1AӔ0#͎AӔ\nquince15AB*z28@ @ AB*z28C먉ӏ՜4'
kar1Gǿ1AӔ.UAӔ\ncatorce14A]x>@ @ A]x>Gٲ;'
saU1\ǿ1AӔQ AӔ\nveintinueve29A#@ @ A#?ќ '
e_V1yǿ1AӔuAӔ\ndos 2AK,o@ @ AK,oFڣҳٌ@'
qa1oǿ1AӔNAӔ\nveintiocho28A-q @ @ A-q Dӏ'
maq1Vǿ1AӔR AӔ\ntreinta 30A̔P_@ @ A̔P_@ԑѳI'
g_M1)ǿ1AӔkrAӔ\nocho 8A-k @ @ A-k Gɐ~'
sa11Kǿ1AӔ2AӔ\ndieciséis 16A%̏@ @ A%̏Fų֓'
qa#1Nǿ1AӔ6vBAӔ\ndieceiocho18A|f9@ @ A|f9GΈ߈'
sa['1 ǿ1AӔ;\JAӔ\ndiecinueve 19A)@ @ 1ʳ
P
I
[W
)
D%g\W1 k$9%indexix_factsDeleted_factIdfactsDeleted(CREATE INDEX ix_f
/##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_tagtags0CREATE UNIQUE INDEX ix_tags_tag on tags (tag)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)\*'indexix_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)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,
FOREIGN KEY("mediaId") REFERENCES cards (id)
).%% tablecardsDeletedcardsDeletedCREATE TABLE "ca.%% 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)
> mK jI#
l
B
a < k @
a
?
j F !h> jA \1h=8112 1{}1veintiuno"ѓ %|?1Ȯ}1veinticuatroȤѿa le1`=814 1=810H 14U1vH=8113ӏO #1N=8118ٲW q1V=8130 !1o}1veintiocho֓ќ:
\1:}1tres V1y=812!ɳT #o1T}1veinticincoѤ֓ ['1 =8119 ߣ mY1_}1veinte
*=1
}1seis ߓ \1h}1doce瓏d $S1Ad=819!ܶӏٌ\ #U1\}1veintinueveҩ M1)=818ՙ >31=8117 1Zخ}1uno ȔئI 0Xe1&I=8126 @qI1=8123ˀ 1߮}1cero !ئI #0Xe1&I}1veintiséisӏӊ9 -19}1once *=1
=816ӏߣ mY1_=8120 ՅG r1G}1catorce!ۖ #/]1G }1veintisiete /]1G =8127֓ 1Z=811 곏՜N 1N}1quince泏ח 1=8122ӏ +W1\ή}1diez ќ:
\1:=813ҩ M1)}1ocho ӏ !>31}1diecisiete ѿ` le1`}1cuatro !ᢒӏ֓ #['1 }1diecinueve ߤӓT o1T=8125ⓏL ͼ1L=815Ⓩ +W1\=8110 ֳח !1}1veintidósݫٌ\ U1\=8129 ܘӏL ͼ1L}1cinco ۊ՜N 1N=8115٥ғՅG r1G=8114!صհK #11K}1dieciséis d $S1Ad}1nueve ҐD c1D=817 ҐD c1D}1siete ؋ 1o=8128̓擏ӊ9 -19=8111 ȫٲV q1V}1treinta ӏ V1yޮ}1dos !ǣ #@qI1}1veintitrésÕ 1{=8121ņ |?1=8124H 14U1vH}1treceհK 11K=8116 ӏO !#1N}1dieceiocho
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
> |l[K:* tdSC2"
}
l
\
K
;
*
u d T C 3 " > 1= 1< ×1;; ×1;: 1@9 1@8 `1os7 `1os6 ^1G5 ^1G4 1&.3 1&.2 %1:1 %1:0 S1/ S1. 5)1- 5)1, Q1i+ Q1i* WO1{j) WO1{j( 8G1_' 8G1_& q1% q1$ ;13# ;13" C_1~! C_1~ >S10 >S10 ֠M14 ֠M14 ]G1, ]G1, R 1u R 1u |;1h` |;1h` J1 J1 Q=1\ Q=1\ F1AI F1AI 1) 1) 1)
1) 81 81
Mq10 Mq10 #1F #1F 1 1 a71y a71y <1Z <1Z
`B }qQ>
z
m
Y
:
# fieldModels2 ' modelsDeleted0 -fieldsix_fields_factId22 2%9fieldsix_fields_fieldModelId22 11 +fieldsix_fields_value22 2' reviewHistory0 models1 -statsix_stats_typeDay2 1 1& 3cardTagsix_cardTags_tagCard22 11 1" 1cardTagsix_cardTags_cardId22 2
media0! cardModels2 sources0+ CdeckVarssqlite_autoindex_deckVars_114 1% mediaDeleted0 /factsix_facts_modified11 1
decks1 % factsDeleted0' 7 cardsix_cards_typeCombined11 11 1 1$
9cardsix_cards_relativeDelay11 11 /cardsix_cards_modified11 1 /cardsix_cards_priority11 11 + cardsix_cards_factor11 11 11 +cardsix_cards_factId11 1.9+cardsix_cards_intervalDesc211 11 11 11 1 1'-)cardsix_cards_dueAsc211 11 11 1 1 1'cardsix_cards_sort11 1% cardsDeleted0#tagsix_tags_tag5 1
? eF'mN/
u
V
7
} ^ ? AB;
\1:#1F A@ c 1<1Z A 5o1T1&. A ;zmY1_WO1{j AҔS5\1hR 1u AV(&b-15)1 AElO1Za71y A%̏嶺11KC_1~ A7c1D 1) A#U1\×1; A} >31;13 A-k M1)F1AI A̔P_q1V1 A]x>r1G֠M14 A˲q $S1AdQ=1\ A-q 1o1@ A814U1vH]G1, AB*z281N>S10 ATɐͼ1L81 A5 >le1`Mq10 AscD ^1{Q1i A.|?1%1: A g@@qI1 S1 A)['1 8G1_ A
w+W1\J1 AH=*=1
1) AK,oV1y1 Au'0Xe1&I^1G AE[-19|;1h` AWX/]1G `1os A|f9#1Nq1
m ~qdWJ=0# zm #1F |;1h` a71y ^1G R 1u Q=1\ J1 ;13 81 5)1 %1: 1) S1 1) Mq10 1&. <1Z Q1i ]G1, `1os WO1{j >S10 ֠M14 ×1; 1 1@ 1 F1AI C_1~ q1 8G1_
t`L8$p\H4
AӔ\n#1FAӔ\n|;1h`AӔ\na71yAӔ\n^1GAӔ\nR 1uAӔ\nQ=1\AӔ\nJ1 AӔ\n;13AӔ\n81AӔ\n5)1AӔ\n%1:AӔ\n 1)AӔ\n S1AӔ\n 1)AӔ\nMq10AӔ\n1&.AӔ\n<1ZAӔ\nQ1iAӔ\n]G1,AӔ\n`1osAӔ\nWO1{jAӔ\n>S10AӔ\n֠M14AӔ\n×1;AӔ\n1 AӔ\n1@AӔ\n1AӔ\nF1AIAӔ\nC_1~AӔ\nq1AӔ\n8G1_
t`L8$p\H4
AӔRq1VAӔQ
PU1\AӔN
1oAӔL*|/]1G AӔJ-0Xe1&IAӔHo1TAӔD ?|?1AӔC
~5@qI1AӔA@1AӔ>a1{AӔ=%mY1_AӔ;] ['1 AӔ6w[#1NAӔ4Jӏ>31AӔ2qL11KAӔ0$?1NAӔ.džr1GAӔ-co14U1vHAӔ,h*x\1hAӔ+~-19AӔ)+W1\AӔ$4ҢM1)AӔ#7
W$S1AdAӔ(6c1DAӔ*=1
AӔ
ͼ1LAӔ 'kle1`AӔV+
\1:AӔV1yAӔ 1ZAӔ P 1
m ~qdWJ=0# zm #1F |;1h` a71y ^1G R 1u Q=1\ J1 ;13 81 5)1 %1: 1) S1 1) Mq10 1&. <1Z Q1i ]G1, `1os WO1{j >S10 ֠M14 ×1; 1 1@ 1 F1AI C_1~ q1 8G1_
V |fP:$t^H2
l
V @ #1F@ |;1h`@ a71y@ ^1G@ R 1u@ Q=1\@ J1 @ ;13@ 81@ 5)1@ %1:@ 1)@ S1@ 1)@ Mq10@ 1&.@ <1Z@ Q1i@ ]G1,@ `1os@ WO1{j@ >S10@ ֠M14@ ×1;@ 1 @ 1@@ 1@ F1AI@ C_1~@ q1@ 8G1_
t`L8$p\H4
q1V1o1T1&.mY1_WO1{jle1`Mq10\1hR 1u['1 8G1_V1y1 @qI1 S114U1vH]G1,0Xe1&I^1G/]1G `1os+W1\J1 *=1
1)$S1AdQ=1\ 1<1Z#1Nq11N>S10|?1%1:
\1:#1F1o1@U1\×1;1Za71y1{Q1ir1G֠M14-19|;1h`M1)F1AIͼ1L81c1D 1)15)111KC_1~>31;13
!2011-08-23 !2011-08-22! 2011-08-22
> ( t`L8$p\H4
l
X
D
0
| h T @ , x d P < ( q1Vdc1Wq1V1Vo1T4K1To1T1TmY1_,+1_mY1_ɍ1_le1`k!!1ale1`1`\1h}71h\1h&1h['1 /E'1 ['1 1 V1y41yV1yޏٝ1y@qI171@qI1114U1vHg1vH14U1vH@1vH0Xe1&I 1&I0Xe1&I/1&I/]1G l1G /]1G u1G +W1\%1\+W1\μ1\*=1
(1
*=1
1$S1Ad%K91Ad$S1AdRg1Ad 1h 1 1,1#1Ng1O#1N 1O1N3S1N1N)1N|?1l1|?1Ȋ1
\1:Er1:
\1:^1:1ob11o1o`_1oU1\q1\U1\1\1ZN1Z1Zz1Z1{o 1{1{ 1{r1G廱1Gr1G1G-1919-19119M1)1)M1)ϡ1)ͼ1L[1Lͼ1La1Lc1DK1Dc1D1D1311111K1K11K1K>31'1ՙ>31ŕ1
> ( t`L8$p\H4
l
X
D
0
| h T @ , x d P < ( =81}71h=81k!!1a=81h 1=81g1vH=81g1O=81dc1W=8141y=81/E'1 =81%K91Ad=811)=81'1ՙ=81 1&I=8171=811=81ɍ1_=81u1G =81z1Z=8131=81^1:=81о1T=81н[1L=81м1\=81к1\=81ж)1N=81в1G=81ЩK1D=81П`_1o=81К119=81Ћ 1{=81Њ1=81Ё1K}1o 1{}1l1}1b11o}1Er1:}14K1T}1,+1_}1(1
}1&1h}1q1\}1N1Z}1,1}1/1&I}119}1廱1G}1l1G }13S1N}1%1\}1ϡ1)}1ŕ1}11`}11 }1ϻ1}1ϸa1L}1ϰ1K}1ϭRg1Ad}1ϧ1D}1ϐ1V}1Ϗٝ1y}1ώ1}1ς@1vH}1ρ 1O
> vhZM?1#reXE4"
r
a
P
>
-
~ g Q : # veintiunoo 1{#veintitrés1#veintiséis/1&I#veintisietel1G !veintiochob11o#veintinueveq1\!veintidós1%veinticuatrol1#veinticinco4K1Tveinte,+1_uno N1Ztres Er1: treinta 1Vtrece@1vHsiete 1Dseis (1
quince3S1Nonce 19ocho ϡ1)nueve Rg1Addos ٝ1ydoce&1hdiez %1\#dieciséis 1K!diecisieteŕ1#diecinueve 1 !dieceiocho 1Ocuatro 1`cinco a1Lcero ,1catorce廱1G 9%K91Ad 81) 7K1D 61 5[1L 4k!!1a
30dc1W 3^1:
291\
28`_1o
27u1G
26 1&I
251T
241
2371
2231
21 1{
20ɍ1_ 241y
19/E'1
18g1O
17'1ՙ
161K
15)1N
141G
13g1vH
12}71h
11119
101\ 1z1Z 0h 1
> _ yj[L=. {l]N?0!
|
m
^
O
@
1
"
} n _ #1F|;1h`a71y^1G6R 1uQ=1\J1 ;13$81 5)1.%1:2 1) S10 1)Mq10
1&.4<1ZQ1i,]G1, `1os8WO1{j*>S10 ֠M14 ×1;<1 1@:1>F1AIC_1~"q1&8G1_(#1F|;1h`a71y^1G5R 1uQ=1\J1 ;13#81 5)1-%1:1 1) S1/ 1)
Mq10 1&.3
<1ZQ1i+]G1,`1os7WO1{j)>S10 ֠M14 ×1;;1 1@91=F1AIC_1~!q1%8G1_'
> ~qdWJ=0# {naTG:-
w
j
]
P
C
6
)
#1F #1F |;1h` |;1h` a71y a71y ^1G6 ^1G5 R 1u R 1u Q=1\ Q=1\ J1 J1 ;13$ ;13# 81 81 5)1. 5)1- %1:2 %1:1 1) 1) S10 S1/ 1) 1)
Mq10
Mq10 1&.4 1&.3 <1Z <1Z Q1i, Q1i+ ]G1, ]G1, `1os8 `1os7 WO1{j* WO1{j) >S10 >S10 ֠M14 ֠M14 ×1;< ×1;; 1 1 1@: 1@9 1> 1= F1AI F1AI C_1~" C_1~! q1& q1% 8G1_( 8G1_'
xV4hF$
z
X
6
j H & !q1VA̔P_1!o1TA 51&.!mY1_A ;zWO1{j!le1`A5 >Mq10!\1hAҔS5R 1u!['1 A)8G1_!V1yAK,o1 !@qI1A g@ S1!14U1vHA8]G1,!0Xe1&IAu'^1G!/]1G AWX`1os!+W1\A
wJ1 !*=1
AH= 1)!$S1AdA˲q Q=1\! 1A@ c<1Z!#1NA|f9q1!1NAB*z28>S10!|?1A.%1:!
\1:AB;#1F!1oA-q 1@!U1\A#×1;!1ZAElOa71y!1{AscD ^Q1i!r1GA]x>֠M14!-19AE[|;1h`!M1)A-k F1AI!ͼ1LATɐ81!c1DA7 1)!1AV(&b-5)1!11KA%̏C_1~!>31A} ;13
X.\2
`
6
d : h >
)AB;
\1:AB;#1F)A@ c 1A@ c<1Z)A 5o1TA 51&.)A ;zmY1_A ;zWO1{j)AҔS5\1hAҔS5R 1u)AV(&b-1AV(&b-5)1)AElO1ZAElOa71y)A%̏嶺11KA%̏C_1~)A7c1DA7 1))A#U1\A#×1;)A} >31A} ;13)A-k M1)A-k F1AI)A̔P_q1VA̔P_1)A]x>r1GA]x>֠M14)A˲q $S1AdA˲q Q=1\)A-q 1oA-q 1@)A814U1vHA8]G1,)AB*z281NAB*z28>S10)ATɐͼ1LATɐ81)A5 >le1`A5 >Mq10)AscD ^1{AscD ^Q1i)A.|?1A.%1:)A g@@qI1A g@ S1)A)['1 A)8G1_)A
w+W1\A
wJ1 )AH=*=1
AH= 1))AK,oV1yAK,o1 )Au'0Xe1&IAu'^1G)AE[-19AE[|;1h`)AWX/]1G AWX`1os)A|f9#1NA|f9q1
R\
t
:
U m 5
|
> C <oveintiunoQ1i>sveintitrés S1>sveintiséis^1G>sveintisiete`1os=qveintiocho1@>sveintinueve×1;=qveintidós5)1?uveinticuatro%1:>sveinticinco1&.9iveinteWO1{j7euno a71y8gtres #1F;mtreinta 18gtrece]G1,9isiete 1)8gseis 1)9iquince>S108gonce |;1h`8gocho F1AI9inueve Q=1\7edos 1 7edoceR 1u8gdiez J1 >sdieciséis C_1~=qdiecisiete;13>sdiecinueve 8G1_=qdieceiochoq1:kcuatro Mq109icinco 818gcero <1Z:kcatorce֠M14
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
.]
V J~Dy Gʳ'
sa@qI1ǿ1AӔC
dAӔ\nveintitrés23A g@@ @ A g@@ӏҐ)'
g_*=1
ǿ1AӔAӔ\nseis 6AH=@ @ AH=BӮ0'
k_le1`ǿ1AӔ AӔ\ncuatro 4A5 >@ @ A5 >Gئ.'
sao1Tǿ1AӔHFAӔ\nveinticinco25A 5@ @ A 5@ϖڽ'
g_ 1ǿ1AӔ AӔ\ncero 0A@ c@ @ A@ cEחi'
oa1{ǿ1AӔ>AӔ\nveintiuno21AscD ^@ @ AscD ^AՅ,'
ga14U1vHǿ1AӔ-bAӔ\ntrece13A8@ @ A8Gs'
sa/]1G ǿ1AӔL÷AӔ\nveintisiete27AWX@ @ AWXBj'
iamY1_ǿ1AӔ=%nPAӔ\nveinte20A ;z@ @ A ;zBʳհ0'
ia1Nǿ1AӔ0#͎AӔ\nquince15AB*z28@ @ AB*z28C먉ӏ՜4'
kar1Gǿ1AӔ.UAӔ\ncatorce14A]x>@ @ A]x>Gٲ;'
saU1\ǿ1AӔQ AӔ\nveintinueve29A#@ @ A#?ќ '
e_V1yǿ1AӔuAӔ\ndos 2AK,o@ @ AK,oFڣҳٌ@'
qa1oǿ1AӔNAӔ\nveintiocho28A-q @ @ A-q Dӏ'
maq1Vǿ1AӔR AӔ\ntreinta 30A̔P_@ @ A̔P_@ԑѳI'
g_M1)ǿ1AӔkrAӔ\nocho 8A-k @ @ A-k Gɐ~'
sa11Kǿ1AӔ2AӔ\ndieciséis 16A%̏@ @ A%̏Fų֓'
qa#1Nǿ1AӔ6vBAӔ\ndieceiocho18A|f9@ @ A|f9GΈ߈'
sa['1 ǿ1AӔ;\JAӔ\ndiecinueve 19A)@ @ A)
] 4a
'
[ (] @ӏѿF'
g_
\1:ǿ1AӔVOAӔ\ntres 3AB;@ @ AB;A`'
ga-19ǿ1AӔ+5eAӔ\nonce 11AE[@ @ AE[?'
e_1Zǿ1AӔ WKAӔ\nuno 1AElO@ @ AElOG'
sa0Xe1&Iǿ1AӔJ-NQAӔ\nveintiséis26Au'@ @ Au'@'
ea\1hǿ1AӔ,gcAӔ\ndoce12AҔS5@ @ AҔS5Aӏܳ'
i_$S1Adǿ1AӔi^AӔ\nnueve 9A˲q @ @ A˲q ƁAӊ '
ga+W1\ǿ1AӔ QAӔ\ndiez 10A
w@ @ A
wF샓3'
qa>31ǿ1AӔ4AӔ\ndiecisiete17A} @ @ A} A'
i_ͼ1Lǿ1AӔAӔ\ncinco 5ATɐ@ @ ATɐFœ'
qa1ǿ1AӔA@AӔ\nveintidós22AV(&b-@ @ AV(&b-Hӏ:'
ua|?1ǿ1AӔD AӔ\nveinticuatro24A.@ @ A.Aᓏҩ'
i_c1Dǿ1AӔ( AӔ\nsiete 7A7@ @ A7
[ } 1
S @
u
Puv[
3##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc2##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due 1))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinale 9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)O +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_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)H,#gindexix_tags_tagtags0CREATE 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, interval0##[viewrevCardsDuerevCardsDueCREATE VIEW revCardsDue as
select * from cards
where type = 1 and isDue = 1
order by priority desc, due