SQLite format 3 @ / 2 N - G 6=g
!!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)
)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)
)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)
)]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)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars `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
u pageSize4096fAhexCache{"-2761101068847873514": "d9ae9934f25f0216", "-5075551055083797994": "b9900534f25f0216", "-7641569301754871274": "95f3b134f25f0216", "1768976997542724118": "188cab34f25f0216", "7948799693643776534": "6e4fcf34f25f0216"};
kcssCache.fmb9900534f25f0216 {font-family:"SBL Hebrew";font-size:44px;color:#000000;white-space:pre-wrap;}
.fm6e4fcf34f25f0216 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqd9ae9934f25f0216 {text-align:center;}
#cmq188cab34f25f0216 {text-align:center;}
#cmad9ae9934f25f0216 {text-align:center;}
#cma188cab34f25f0216 {text-align:center;}
.cmbd9ae9934f25f0216 {background:#FFFFFF;}
.cmb188cab34f25f0216 {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 pageSize) suspendLeeches!revSpacing#revInactive
revActive
perDay!newSpacing#newInactive
newActivemediaURL !leechFailslatexPre
latexPosthexCachecssCache
/ɾ
Aȣ7LAȧ+BasicBasic?<
" !2012-01-18" !2012-01-18
" " eɾ
4_Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeӓɾ
4_Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFF
#ɾ
4_BackArial17ӧɾ
!4_FrontSBL Hebrew,#000000preserve
k kNS 1
*
`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)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars]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)
)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)
){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)
)
!!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)
)
f f
O b: 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 ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id),
CHECK (required IN (0, 1))
)&+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)
)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)
)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),
FOREIGN KEY("factId") REFERENCES facts (id),
CHECK ("isDue" IN (0, 1))
).%%tablefactsDeletedfactsDeletedCREATE TABLE "factsDeleted" (
"factId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("factId") REFERENCES facts (id)
)
> k|
_
n#> Dɾ
U 4_AȤBAȤ/outside (m) חוּץ, חוּצוֹת5ɾ
7 4_AȤ=AȤ/fall (qal) נָפַלNɾ
i 4_AȤ?yAȤ/הִפִּיל cause to fall, knock down (hif)Aœɾ
O 4_AȤFAȤ/רֵעַ, רֵעִים friend (m)Aӧɾ
O 4_AȤ5AȤ/go out, go forth (qal) יָצַאAӧɾ
O 4_AȤ8AȤ/יָרַד go down, descend (qal)Qɾ
o 4_AȤ4AȤ/הוֹלִיד cause to have a child, beget (hif)Jӧɾ
a 4_AȤAAȤ/נָצַל save, rescue, snatch away (hif)Oɾ
k 4_AȤ7JAȤ/הוֹצִיא cause to go out, bring out (hif)fɾ
4_AȤDbAȤ/(written) scroll, book (m) סֵפֶר, סְפָרִים, סֵפֶר־Eӧɾ
W 4_AȤ2aAȤ/give birth to, beget (qal) יָלַד>ɾ
I 4_AȤ<3AȤ/tell, declare (hif) נָגַדNɉӧɾ
i 4_AȤ0AȤ/הוֹדִיעַ cause to know, announce (hif)5ӧɾ
7 4_AȤ/AȤ/know (qal) יָדַעLďɾ
e 4_AȤ:AȤ/cause to go down, lower (hif) הוֹרִיד
}%
-%#
Aȣ=qAȧ+A4_? XPriorityVeryHighPriorityHighPriorityLowX
r8
zP"
c
3
Qv4
m
C
5ٓɾ K%-4_nO4_save, rescue, snatch away (hif) ӧɾ !u4_4_יָלַד,ɾ 9>M4_nO4_go down, descend (qal) ɾ !4_4_יָדַע3ɾ G&4_nO4_cause to know, announce (hif) ɾ !H)4_nO4_friend (m)8ɾ Q8!4_nO4_cause to have a child, beget (hif)5ΐɾ KL4_nO4_cause to fall, knock down (hif)$ɾ )<4_4_הוֹרִיד,ɾ 9H)4_4_רֵעַ, רֵעִים.Տɾ =X~4_4_חוּץ, חוּצוֹת6ɾ M_4_nO4_cause to go out, bring out (hif) 锳ɾ !4_nO4_know (qal)@⳧ɾ ag4_4_סֵפֶר, סְפָרִים, סֵפֶר־$ࢳɾ )L4_4_הִפִּיל&șɾ -&4_4_הוֹדִיעַ ݧӧɾ !>M4_4_יָרַד3ኳɾ G<4_nO4_cause to go down, lower (hif) ӧɾ !4_4_נָגַד$ӧɾ )8!4_4_הוֹלִיד$ɾ )_4_4_הוֹצִיא ɳɾ !F^4_4_יָצַא,ӧɾ 9F^4_nO4_go out, go forth (qal) ߄ӧɾ !M4_4_נָפַל)؎ӧɾ 34_nO4_tell, declare (hif)!͊ɾ #X~4_nO4_outside (m)0˓ɾ Ag4_nO4_(written) scroll, book (m) ҳɾ !M4_nO4_fall (qal) 곧ɾ !%-4_4_נָצַל0窳ɾ Au4_nO4_give birth to, beget (qal)
+
#
J[P
\ y+ [̓ӧɾ(
q >M4_ٮ4_AȤ8AȤ5?יָרַדgo down, descend (qal)AȤ8@ @ AȤ8hɾ(
yL4_ٮ4_AȤ?yAȤ5?הִפִּילcause to fall, knock down (hif)AȤ?y@ @ AȤ?yNʣɾ'
qq4_ٮ4_AȤ/AȤ5?יָדַעknow (qal)AȤ/@ @ AȤ/[ɾ(
qH)4_ٮ4_AȤFAȤ5?רֵעַ, רֵעִיםfriend (m)AȤF@ @ AȤF[ɾ(
q F^4_ٮ4_AȤ5AȤ5?יָצַאgo out, go forth (qal)AȤ5@ @ AȤ5^ɾ(
sX~4_ٮ4_AȤBAȤ5?חוּץ, חוּצוֹתoutside (m)AȤB@ @ AȤBfӧɾ(
y<4_ٮ4_AȤ:AȤ5?הוֹרִידcause to go down, lower (hif)AȤ:@ @ AȤ:k̠ɾ(
y!8!4_ٮ4_AȤ4AȤ5?הוֹלִידcause to have a child, beget (hif)AȤ4@ @ AȤ4Xߒɾ(
q4_ٮ4_AȤ<3AȤ5?נָגַדtell, declare (hif)AȤ<3@ @ AȤ<3iފɾ(
y_4_ٮ4_AȤ7JAȤ5?הוֹצִיאcause to go out, bring out (hif)AȤ7J@ @ AȤ7J ٩͓ɾ)
1g4_ٮ4_AȤDbAȤ5?סֵפֶר, סְפָרִים, סֵפֶר־(written) scroll, book (m)AȤDb@ @ AȤDbdɾ(
q%-4_ٮ4_AȤAAȤ5?נָצַלsave, rescue, snatch away (hif)AȤA@ @ AȤANӧɾ'
qqM4_ٮ4_AȤ=AȤ5?נָפַלfall (qal)AȤ=@ @ AȤ=ց_͙ӧɾ(
qu4_ٮ4_AȤ2aAȤ5?יָלַדgive birth to, beget (qal)AȤ2a@ @ AȤ2ahʤɾ(
}&4_ٮ4_AȤ0AȤ5?הוֹדִיעַcause to know, announce (hif)AȤ0@ @ AȤ0
" X Ehje qA "
R
]
*
Ep k$9%indexix_factsDeleted_factIdf1##[viewacqCardsOldacqCards0%%#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)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&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, ordinal1##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due
2##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
|l[K:* tdSC2" y44_ y44_ xI4_ xI4_ k)4_ k)4_ =74_ =74_ 7+4_ 7+4_ б4_ б4_
U4_
U4_ 14_ 14_ I4_
I4_ +4_ +4_
i4_ i4_ Ƨ4_ Ƨ4_ 4_ 4_ f4_ f4_ )#4_ )#4_
yL>/# ! cardModels0
media0' modelsDeleted0 fields0' reviewHistory0
models0
stats0
cardTags0
sources0+ CdeckVarssqlite_autoindex_deckVars_112 1% mediaDeleted0# fieldModels0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
/ eF'mN/ AȤFH)4_=74_AȤDbg4_i4_AȤBX~4_б4_AȤA%-4_Ƨ4_AȤ?yL4_xI4_AȤ=M4_4_AȤ<34_I4_AȤ:<4_
U4_AȤ8>M4_y44_AȤ7J_4_+4_AȤ5F^4_7+4_AȤ48!4_14_AȤ2au4_f4_AȤ0&4_)#4_AȤ/4_k)4_
= ~qdWJ= y44_xI4_k)4_=74_7+4_б4_
U4_14_I4_+4_i4_Ƨ4_4_f4_)#4_
t`L8$ AȤ5?y44_AȤ5?xI4_AȤ5?k)4_AȤ5?=74_AȤ5?7+4_AȤ5?б4_AȤ5?
U4_AȤ5?14_AȤ5?I4_AȤ5?+4_AȤ5?i4_AȤ5?Ƨ4_AȤ5?4_AȤ5?f4_AȤ5?)#4_
t`L8$ AȤ/X~4_AȤ/M4_AȤ/L4_AȤ/H)4_AȤ/F^4_AȤ/>M4_AȤ/8!4_AȤ/%-4_AȤ/_4_AȤ/g4_AȤ/u4_AȤ/4_AȤ/&4_AȤ/4_AȤ/<4_
= ~qdWJ= y44_xI4_k)4_=74_7+4_б4_
U4_14_I4_+4_i4_Ƨ4_4_f4_)#4_
|fP:$ @ y44_@ xI4_@ k)4_@ =74_@ 7+4_@ б4_@
U4_@ 14_@ I4_@ +4_@ i4_@ Ƨ4_@ 4_@ f4_@ )#4_
t`L8$ X~4_б4_M4_4_L4_xI4_H)4_=74_F^4_7+4_>M4_y44_8!4_14_%-4_Ƨ4__4_+4_g4_i4_u4_f4_4_I4_&4_)#4_4_k)4_<4_
U4_
!2012-01-18! 2012-01-18
t`L8$p\H4
X~4_GT4_X~4_+4_M4_|%4_M4_z4_L4_Y84_L4_/4_H)4_]c4_H)4_H>_4_F^4_JK4_F^4_Ο4_>M4_uk4_>M4_ u=4_8!4_Z4_8!4_蔅4_%-4_}4_%-4_KS4__4_E4__4_g4_g4_634_g4_L'4_u4_wǥ4_u4_S4_4_