SQLite format 3 @ 2 2 N - 2=- 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 (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" 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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars {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)
);''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_1rev
/̉K
AӔYLAӔYLBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt g ChexCache{"5034442956279706444": "45ddef31f304f34c", "-4479211145424211125": "c1d6a531f304f34b", "-6206864970055617717": "a9dcc931f304f34b", "-1875070631594888372": "e5fa6931f304f34c", "-3344191889140812981": "d1970b31f304f34b"}(
EcssCache.fmc1d6a531f304f34b {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fmd1970b31f304f34b {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqe5fa6931f304f34c {text-align:center;}
#cmq45ddef31f304f34c {text-align:center;}
#cmae5fa6931f304f34c {text-align:center;}
#cma45ddef31f304f34c {text-align:center;}
.cmbe5fa6931f304f34c {background:#FFFFFF;}
.cmb45ddef31f304f34c {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
$̉K
1KFrontArial1#ӏ̉K
1KBackArial1
" " ẻL
1KForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFẻ͓L
1KReverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFF
1 1* : K
V
;''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)
)` 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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars 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 (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
!!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)
)
: x-L
A [
: Ď`
U 1KAӔlAӔlmHago mis deberes. I do my homework.4ۮ̎
5 1KAӔAӔQlos lunes on MondaysBԓ̉
Q 1KAӔ[AӔ[En mi tiempo libre In my free timecӏ̊
1KAӔ_AӔ_V?¿Qué haces en tu tiempo libre? What do you do in your free time??ؓ̋
K 1KAӔgɰAӔg?Voy de compras. I go shopping.@ד̐;
M 1KAӔvAӔwlos fines de semana at weekends?̏
K 1KAӔ`4AӔa5+una vez por semana once a weekAӏ̎
O 1KAӔ?AӔ@r¿Con qué frecuencia? How often?Cdz̏
S 1KAӔAӔ5dos veces a la semana twice a weekĎˏ
U 1KAӔqAӔq!2Escucho música. I listen to music.Pѓ̋0
m 1KAӔjJ
AӔjSalgo con mis amigos. I go out with my friends.Pӏ̍
m 1KAӔ|'&-AӔ|'Juego con mi ordenador. I play with my computer.Mٓ̋
g 1KAӔe3vAӔe"Voy a la piscina. I go to the swimming pool.:乲ӏ̎
A 1KAӔAӔatodos los días every dayĎL
U 1KAӔoS$ AӔoSMonto en bicicleta. I ride my bike.Eݲ̍
W 1KAӔx`AӔxaXNavego por internet. I surf the net.AԳ̊/
O 1KAӔb:AӔb\Voy al cine. I go to the cinema.Ȟُ
] 1KAӔuTGAӔu`Veo la televisión. I watch television.,ӏ̐
% 1KAӔ٭TAӔ# nunca never
Y Y $%
M -%#
AӔY2GAӔA1K13fb86b97eb08b1dad046a80873e7b09AӔ x,? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 y
"9ag~ ǩD)
9V10E1LAӔjJ
AӔjSalgo con mis amigos. I go out with my friends.AӔjJ
@ @ AӔjJ
Z̐(
sb1 ;E1LAӔvAӔw3flos fines de semana at weekendsAӔv@ @ AӔv߁^ӏ̌(
< {1KE1LAӔqAӔqP<Escucho música. I listen to music.AӔq@ @ AӔqo̎)
W1E1LAӔ|'&-AӔ|'Juego con mi ordenador.
I play with my computer.AӔ|'&-@ @ AӔ|'&-M쓏̏'
oqyms1|E1LAӔAӔlos luneson MondaysAӔ@ @ AӔ^ӏ̌t(
{g1&LE1LAӔoS$ AӔoSCMonto en bicicleta. I ride my bike.AӔoS$ @ @ AӔoS$ Sӏ̎'
}o1TE1LAӔAӔڏtodos los días every dayAӔ@ @ AӔ^̌1(
~91 `E1LAӔlAӔlIbHago mis deberes. I do my homework.AӔl@ @ AӔlƁY̏(
sbP1E1LAӔ`4AӔaduna vez por semana once a weekAӔ`4@ @ AӔ`4h̋)
R1E1LAӔe3vAӔeVoy a la piscina. I go to the swimming pool.AӔe3v@ @ AӔe3v]ԛ̐ (
uS2;1E1LAӔAӔedos veces a la semana twice a weekAӔ@ @ AӔc݂ٳ̍k)
='1pE1LAӔuTGAӔuVeo la televisión. I watch television.AӔuTG@ @ AӔuTGXח̋'
}yt:1E1LAӔgɰAӔgnrVoy de compras. I go shopping.AӔgɰ@ @ AӔgɰE峏̐'
ig1AE1LAӔ٭TAӔR?nunca neverAӔ٭T@ @ AӔ٭T\րﳏ̊(
{wʡ1E1LAӔ[AӔ[En mi tiempo libreIn my free timeAӔ[@ @ AӔ[ʁ[̋(
wr1[/E1LAӔb:AӔbVoy al cine. I go to the cinema.AӔb:@ @ AӔb:_̊̍(
{G1E1LAӔx`AӔxaNavego por internet. I surf the net.AӔx`@ @ 0̌D
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)
& h9u@
B
M R )
m
7
w A %đӏ̌L +g1&L֥1KI ride my bike.*̌ 5='1pї 1KVeo la televisión. /ϖ̋1 ?9V10֥1KI go out with my friends.,̏ 9S2;1ї 1Kdos veces a la semana )̌ 3='1p֥1KI watch television. ̎ !Wr1֥1KHow often?'ܳ̌` /~91 `֥1KI do my homework.(̉ 1wʡ1ї 1KEn mi tiempo libre,̋1 99V10ї 1KSalgo con mis amigos. (̌` 1~91 `ї 1KHago mis deberes. ݓ̐ 1A֥1Knever ӏ̎ !yms1|֥1Kon Mondays1֑ӏ̍ CW1ї 1KJuego con mi ordenador.
̎ 1T֥1Kevery day)ա̏ 3bP1ї 1Kuna vez por semana %̍ +G1֥1KI surf the net.(̋ 1R1ї 1KVoy a la piscina. )ӏ̊/ 3r1[/֥1KI go to the cinema.*̌L 5g1&Lї 1KMonto en bicicleta. :ӏ̊ Uu1ї 1K¿Qué haces en tu tiempo libre?
!ӏ̐; #b1 ;֥1Kat weekends ̐ 1Aї 1Knunca *ٰӏ̐; 5b1 ;ї 1Klos fines de semana #/ 'r1[/ї 1KVoy al cine. 7ӏ̊ Ou1֥1KWhat do you do in your free time?0̋ AR1֥1KI go to the swimming pool.$鿳̋ )t:1֥1KI go shopping."ӳ̏ %S2;1֥1Ktwice a week 츕̎ yms1|ї 1Klos lunes+ӏ̍ 7G1ї 1KNavego por internet. 'ӏ̌ˏ /< {1Kї 1KEscucho música. .ؓ̍ =W1֥1KI play with my computer.&ӏ̎ -1Tї 1Ktodos los días !Θ̏ #bP1֥1Konce a week%Ȣ̉ +wʡ1֥1KIn my free time,ȡ̎ 9Wr1ї 1K¿Con qué frecuencia?&Ģ̋ -t:1ї 1KVoy de compras. (ӏ̌ː 1< {1K֥1KI listen to music.
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
&
|l[K:* tdSC2"
& +1f% +1f$ ] 1A# ] 1A" P1 ! P1 ׳1 ׳1 Ga1 Ga1 (1| (1| z1S z1S XA_1 XA_1 )1 )1
1k
1k [1p [1p 1 1Kt 1 1Kt "1&1
"1&1 ^W1 D ^W1 D
_1 _1 1 1 G1 G1 n[1[ n[1[ {1 {1
}l`L?0$ # fieldModels0' modelsDeleted0 fields0+ CdeckVarssqlite_autoindex_deckVars_112 1
stats0
cardTags0 models0 ' reviewHistory0
media0 ! cardModels0 sources0% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
eF'mN/
AӔ٭T1A+1f AӔvb1 ;] 1A AӔS2;1P1 AӔ`4bP1׳1 AӔyms1|Ga1 AӔ1T(1| AӔ?Wr1z1S AӔ|'&-W1XA_1 AӔx`ݺG1)1 AӔuTG='1pĺ
1k AӔq< {1K[1p AӔoS$ g1&L1 1Kt AӔl~91 `"1&1 AӔjJ
9V10^W1 D AӔgɰt:1ڮ_1 AӔe3vR11 AӔb:r1[/G1 AӔ_u1n[1[ AӔ[wʡ1Ѭ{1
~qdWJ=0# z1S n[1[ ^W1 D ] 1A [1p XA_1 Ga1 1 1Kt (1| "1&1 ׳1 1 P1
1k _1 +1f {1 G1 )1
t`L8$ AӔR?+1fAӔw3f] 1AAӔeP1 AӔad׳1AӔGa1AӔڏ(1|AӔ@^z1SAӔ|'XA_1AӔxa)1AӔu
1kAӔqP<[1pAӔoSC1 1KtAӔlIb"1&1AӔj^W1 DAӔgnr_1AӔe1AӔbG1AӔ_n[1[AӔ[{1
t`L8$ AӔ# 1AAӔwb1 ;AӔ5S2;1AӔa5+bP1AӔQyms1|AӔa1TAӔ@rWr1AӔ|'W1AӔxaXɺG1AӔu`='1pAӔq!2< {1KAӔoSg1&LAӔlm~91 `AӔj9V10AӔg?t:1AӔe"R1AӔb\͵r1[/AӔ_V?u1AӔ[wʡ1
~qdWJ=0# z1S n[1[ ^W1 D ] 1A [1p XA_1 Ga1 1 1Kt (1| "1&1 ׳1 1 P1
1k _1 +1f {1 G1 )1
^ |fP:$t^ @ z1S@ n[1[@ ^W1 D@ ] 1A@ [1p@ XA_1@ Ga1@ 1 1Kt@ (1|@ "1&1@ ׳1@ 1@ P1 @
1k@ _1@ +1f@ {1@ G1@ )1
t`L8$ ~91 `"1&1yms1|Ga1wʡ1Ѭ{1u1n[1[t:1ڮ_1b1 ;] 1AbP1׳1Wr1z1SS2;1P1 < {1K[1p9V10^W1 DW1XA_1R111T(1|g1&L1 1KtG1)1r1[/G1='1pĺ
1k1A+1f
!2011-08-23 !2011-08-22! 2011-08-22
&
t`L8$p\H4
l
X
D
0
~91 `g61 `~91 ``.1 `yms1|Hc
1|yms1|1|wʡ1a1wʡ1ѐ1u1'e1u1/1t:11t:1ڈK1b1 ;'1 ;b1 ;e1 ;bP1=U 1bP1͜b1Wr1i11Wr1;1S2;1r1S2;1M1< {1KWe1K< {1K
1K9V10y<119V10a/11W1EX1W11R1:s 1R111T>'1T1TZ1Tg1&L1&Lg1&L+1&LG1'1T֥1K
v
]
A
n X A %
/U¿Qué haces en tu tiempo libre?
'e1!9¿Con qué frecuencia?;1 3una vez por semana =U 1%twice a weekM1-todos los días Z1T#once a weekb1!on MondaysHc
1|nunca /1AneverVn1A los lunes1| 5los fines de semana e1 ; every day>'1T!9dos veces a la semana r1#at weekends'1 ;,OWhat do you do in your free time?/1-Voy de compras. K1'Voy al cine. 8u1[/ 1Voy a la piscina. :s 1 5Veo la televisión. ySk1p!9Salgo con mis amigos. a/11 7Navego por internet. 91 5Monto en bicicleta. +1&L&CJuego con mi ordenador.
EX1+In my free time1 3I watch television.m#w1p+I surf the net./ {l]N?0!
z1Sn[1[^W1 D ] 1A$[1pXA_1Ga1 1 1Kt(1| "1&1׳1 1P1 "
1k_1
+1f&{1G1)1z1Sn[1[^W1 D ] 1A#[1pXA_1Ga1 1 1Kt(1|"1&1
׳1 1P1 !
1k_1 +1f%
{1G1)1
& reXK>1$
{naTG:- z1S z1S n[1[ n[1[ ^W1 D ^W1 D ] 1A$ ] 1A# [1p [1p XA_1 XA_1 Ga1 Ga1 1 1Kt 1 1Kt (1| (1| "1&1 "1&1
׳1 ׳1 1 1 P1 " P1 !
1k
1k _1
_1 +1f& +1f% {1 {1 G1 G1 )1 )1
z xV4hF$
z !~91 `AӔl"1&1!yms1|AӔGa1!wʡ1AӔ[ʬ{1!u1AӔ_n[1[!t:1AӔgɰ_1!b1 ;AӔv] 1A!bP1AӔ`4׳1!Wr1AӔ?z1S!S2;1AӔP1 !< {1KAӔq[1p!9V10AӔjJ
^W1 D!W1AӔ|'&-XA_1!R1AӔe3v1!1TAӔ(1|!g1&LAӔoS$ 1 1Kt!G1AӔx`ݘ)1!r1[/AӔb:G1!='1pAӔuTG
1k!1AAӔ٭T+1f
X.\2
`
6
)AӔ٭T1AAӔ٭T+1f)AӔvb1 ;AӔv] 1A)AӔS2;1AӔP1 )AӔ`4bP1AӔ`4׳1)AӔyms1|AӔGa1)AӔ1TAӔ(1|)AӔ?Wr1AӔ?z1S)AӔ|'&-W1AӔ|'&-XA_1)AӔx`ݺG1AӔx`ݘ)1)AӔuTG='1pAӔuTG
1k)AӔq< {1KAӔq[1p)AӔoS$ g1&LAӔoS$ 1 1Kt)AӔl~91 `AӔl"1&1)AӔjJ
9V10AӔjJ
^W1 D)AӔgɰt:1AӔgɰ_1)AӔe3vR1AӔe3v1)AӔb:r1[/AӔb:G1)AӔ_u1AӔ_n[1[)AӔ[wʡ1AӔ[ʬ{1
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
0
I y
"9ag~ ǩD)
9V10E1LAӔjJ
AӔjSalgo con mis amigos. I go out with my friends.AӔjJ
@ @ AӔjJ
Z̐(
sb1 ;E1LAӔvAӔw3flos fines de semana at weekendsAӔv@ @ AӔv߁^ӏ̌(
< {1KE1LAӔqAӔqP<Escucho música. I listen to music.AӔq@ @ AӔqo̎)
W1E1LAӔ|'&-AӔ|'Juego con mi ordenador.
I play with my computer.AӔ|'&-@ @ AӔ|'&-M쓏̏'
oqyms1|E1LAӔAӔlos luneson MondaysAӔ@ @ AӔ^ӏ̌t(
{g1&LE1LAӔoS$ AӔoSCMonto en bicicleta. I ride my bike.AӔoS$ @ @ AӔoS$ Sӏ̎'
}o1TE1LAӔAӔڏtodos los días every dayAӔ@ @ AӔ^̌1(
~91 `E1LAӔlAӔlIbHago mis deberes. I do my homework.AӔl@ @ AӔlƁY̏(
sbP1E1LAӔ`4AӔaduna vez por semana once a weekAӔ`4@ @ AӔ`4h̋)
R1E1LAӔe3vAӔeVoy a la piscina. I go to the swimming pool.AӔe3v@ @ AӔe3v]ԛ̐ (
uS2;1E1LAӔAӔedos veces a la semana twice a weekAӔ@ @ AӔc݂ٳ̍k)
='1pE1LAӔuTGAӔuVeo la televisión. I watch television.AӔuTG@ @ AӔuTGXח̋'
}yt:1E1LAӔgɰAӔgnrVoy de compras. I go shopping.AӔgɰ@ @ AӔgɰE峏̐'
ig1AE1LAӔ٭TAӔR?nunca neverAӔ٭T@ @ AӔ٭T\րﳏ̊(
{wʡ1E1LAӔ[AӔ[En mi tiempo libreIn my free timeAӔ[@ @ AӔ[ʁ[̋(
wr1[/E1LAӔb:AӔbVoy al cine. I go to the cinema.AӔb:@ @ AӔb:_̊̍(
{G1E1LAӔx`AӔxaNavego por internet. I surf the net.AӔx`@ @ AӔx`
[̎(
qWr1E1LAӔ?AӔ@^¿Con qué frecuencia?How often?AӔ?@ @ AӔ?̊)
% u1E1LAӔ_AӔ_¿Qué haces en tu tiempo libre?
What do you do in your free time?AӔ_@ @ AӔ_
; \
=
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