SQLite format 3 @ 1 N 4 JktablesourcessourcesCREATE TABLE sources (
id INTEGER NOT NULL,
name TEXT NOT NULL,
created FLOAT NOT NULL,
"lastSync" FLOAT NOT NULL,
"syncPeriod" INTEGER NOT NULL,
PRIMARY KEY (id)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlit )+ "
: :3 S ;''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOA;''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistoryJktablesourcessourcesCREATE TABLE sources (
id INTEGER NOT NULL,
name TEXT NOT NULL,
created FLOAT NOT NULL,
"lastSync" FLOAT NOT NULL,
"syncPeriod" INTEGER NOT NULL,
PRIMARY KEY (id)
)
=ҋ %%
A҅,M~oAt@Hebrew VocabHebrew Vocab?<
`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)
)
{D " !2011-06-16" !2011-06-155 !2011-06-10@%qw5@iw ; !2009-05-27l@"&.Ba@< A} $" !2011-06-17" !2011-06-09
{ { r{tablestatsstats CREATE TABLE stats (
i{tablestatsstats CREATE 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)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
) } ;krevActivenouns-1 nouns-2 nouns-3 verbs-1 verbs-2 verbs-3;knewActivenouns-1 nouns-2 nouns-3 verbs-1 verbs-2 verbs-3sortIndex10pageSize4096
hexCache{}
cssCache!revSpacing0.1 $)latexPost\end{document} $ql)latexPost\end{document}"9latexPre\documentclass[12pt]{article}
\special{papersize=3in,5in}
\usepackage[utf8]{inputenc}
\usepackage{amssymb,amsmath}
\pagestyle{empty}
\begin{document}
mediaURL!newSpacing60.0#revInactiveSuspended#newInactiveSuspended
perDay1!leechFails16)suspe
E8sR+d
#mobileScale )suspendLeeches
sortIndexpageSizehexCachecssCache'mediaLocation!revSpacing
latexPostlatexPremediaURL!newSpacing#revInactive#newInactive
revActive
newActive
perDay!leechFails
Q Q 9 G V
#/C indexsqlite_autoindex_deckVars_1deckVars4 '''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)
)!!tablecardModelscardModelsCREATE TABLE "cardModels" (
id INTEGER NOT NULL,
ordinal INTEGER NO
T 0ߌ
!`:FrequencyArial#0000001+ۡٿ
!`:RootArial#00000011
!`:BackCardo#000000preserve2Ĉ
!`:FrontCardo0#000000preserve
V V -쒋
ce
!`:Reverse{{{Back}}}{{{Front}}}Arial#000000Arial#000000Arial#FFFFFFhѯҋ
!`:Forward{{Front}}{{Back}}Ezra SIL0#000000Arial#000000Arial#ffffff T 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)
) ~qdWJ=0# zm`SF9,wj]PC6) , youngJ ҋ ޱҋ 벋 붲 [ ҋ^ ҋ ҋ[ ҋ } | {[ z㒋\ x wײ v^ t՞\ s沋 r\ q o n^ m겋 l㼒^ jҋ h沋 g^ fҋ[ e cҋ bҋ a믜ҋ\ `锩 _璋[ ] \̑ [ Zَҋ Yɒ\ Xߞ V钋\ Tߎ4 Sݑ[ R撋 Qӽ^ P٫ Oا M־^ Lճ Kҋ\ Iҫҋ Hэҋ\ G Fζ D Cҋ Bʧҋ[ A¸ >[ = <į^ ;⺒
- ) 5ItablecardscardsCREATE TABLE cards (
id INTEGER NOT NULL,
"factId" INTEGER NOT NULL,
"cardModel&+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 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,
x x %
-%#
Ap=>=6A|kXA!`:A~ܮ8? XVeryHighPriorityHighPriorityLowPriorityX_ 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)
) 5~qdWJ=0# zm`SF9,vi\OB5( !撋 ْ ߲ҋ ߠҋ ݶ ْ ܦ
ҋ ۹ҋ
ҋ Ʋ 岋
ٰƇL Ǚ וҋ ҋ ֳҋ ֘ վ粋 ձшe Փ ڒ ԝْ Ӹܒ Ȳ ҋ ˘ џ У ҋ ȑ ϒ ρ
ͪ ͌ ܶ ̞в ಋ ˕풋 ҋ 璋 Ȯز Ƕ͒ ҋ Ƨߒ ˒ 䁲 ͲI Ă ù
ҋ ҁ
'ҋ &ݶ 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)
)
h .%%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)) '~qdWJ=0# zm`SF9,vi\OB5( b ` ]Œ \眲 X쑉ҋ V붬ҋ R⒋ P O騸ٰ LIJ Hג E B ?棦 ;嶡 : 6䖧ҋ 4Ýҋ 1ҋo / .m +ᖻ )貋! '˙! $겋 ҋ ܰ ҋ ڭ پ첋
ؠ㲋
i 鲋 ָm ! Յҋ ԫٲ ̒ ҍƒm ˇҋ р Иҋ LJҋ ҋ 咋" ͽ Ӳm Ͳ ҋ ɤ Ȱҋ ѥ ǁŲϣ Ɗ ҋ ҋ ę Ċ 儒 o k j
q eWI;- #PriorityLow # LowPriority verbs-6 verbs-5 verbs-4 verbs-3 verbs-2 verbs-1 settext
preps nouns-5
nouns-4 nouns-3 nouns-2
nouns-1
Vocab -VeryHigh -VeryHighPriority %HighPriority Hebrew Forward Suspended -PriorityVeryHigh %PriorityHigh K@ ~xrlf`ZTNHB<60*$ |vpjd^XRLF@5 3!v|
4 3!v|
3 3!v|
2 7!{\g1 7!{\g 0 7!{\g/ 7!{\g. 7!{\g- !{uP, !{uP + !{uP* !{uP) [!v|( [!v| ' [!v|& [!v|% /$ / # /" /! !!v| !!v| !!v| )!v|
)!v|
C |[ y' us s? o kW i# go d; ` ]S [ Wk T7 R OO I Gg E3 @ >K < :c 5/ 2{ /G * '_ $+ !w C [ ' s ?
W # o ; S k 7 O g 3 ߈K ڈ هc և/ ӆ{ ІG ̆ ʅ_ Dž+ Äw C [ ' s ? W # n 7
{ {E` w
##eviewrevCardsNewr !tablecardTagscardTagsCREATE TABLE cardTags (
id integer not null,
cardId integer not null,
tagId integer not null,
src integer not null,
primary key(id))##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))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinal
g g XZ T/qindexix_facts_modifiedfacts$CREATE INDE##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due
##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due descn7indexix_cards_typeCombinedcards!CREATE INDEX ix_cards_typeCombined on cards
(type, combinedDue, factId)d9indexix_cards_relativeDelaycards"CREATE 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) * rD! g9 . O \tQ @A҆ tFP 1!{\f^K!{\g A҆#y`to!v|&u!v| A҆#y/c!v|P!v| A҆#!v|!v| A҆ t.xK^!{\f^!{\g 'A҆ tJM!{\f^CX-!{\g A҆#4E