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
/̺
AӔIAӔVBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt d =hexCache{"1073054294008992786": "ee44131f31d1412", "8923318826701755410": "7bd5ff31f31d1412", "-1398104686487333870": "ec98ef31f31d1412", "-5717670256623938541": "b0a6c131f31d1413", "-327301307312565230": "fb753131f31d1412"}%
?cssCache.fmfb753131f31d1412 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm7bd5ff31f31d1412 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqb0a6c131f31d1413 {text-align:center;}
#cmqee44131f31d1412 {text-align:center;}
#cmab0a6c131f31d1413 {text-align:center;}
#cmaee44131f31d1412 {text-align:center;}
.cmbb0a6c131f31d1413 {background:#FFFFFF;}
.cmbee44131f31d1412 {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
#̺
1 BackArial1$ݦ̺
1 FrontArial1
" " e̺
1 Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFeة̺ؓ
1 Reverse%(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)
)
o6O
\
o " S
s
( S t= =ӏF
G 1 AӔ GAӔ H$ir de compras going shopping:̽
A 1 AӔ AӔ MMe encanta … I love …-dz¶
' 1 AӔ*L4AӔ*barato cheapO̺̓
k 1 AӔ.MAӔ/¿Qué te gusta hacer? What do you like doing?@̾
M 1 AӔ AӔ hacer atletismo doing athletics2ӏÜ
1 1 AӔ0{AӔ0 divertido amusingBӏ̾
Q 1 AӔ
AӔjugar al fútbol playing football1ӏs
/ 1 AӔ"/AӔ"0W¿Por qué? Why?Dӏ'
U 1 AӔAӔIhacer mis deberes doing my homeworkAJ
O 1 AӔ$xAӔ$Porque es … Because it’s …?
K 1 AӔ #6AӔ hacer natación going swimming?ɳ̾%
K 1 AӔDAӔir al cine going to the cinemaD
U 1 AӔ`_AӔescuchar música listening to musict̺ے
3 1 AӔ AӔA¿Qué te gusta hacer en tu tiempo libre? What do you like doing in your free time?Gӏ̿
[ 1 AӔAӔ2ver la televisión watching televisionCӏ̼
S 1 AӔZAӔ2No me gusta … I don’t like …0I
- 1 AӔ(]VAӔ(]aburrido boringV柘
y 1 AӔ˰AӔH¿Qué no te gusta hacer? What don’t you like doing?J삝̾m
a 1 AӔ נfAӔ navegar por internet surfing the internet,㞳û
% 1 AӔ3ACAӔ3Afácil easy:ᔪ̽t
A 1 AӔFAӔFmPrefiero … I prefer …8
= 1 AӔ5PmAӔ5Qginteresante interesting-ݡā/
' 1 AӔ8+AӔ8+sano healthyO쓏̿T
k 1 AӔȈYAӔ]salir con mis amigos going out with my friendsO̼
k 1 AӔ2AӔ3No me gusta nada … I don’t like … at all+Q
# 1 AӔ,ۍAӔ,bueno good/ʥ
+ 1 AӔ.<}AӔ.嶉caro expensive8̻
= 1 AӔAӔMe gusta … I like …Eֳ̼
W 1 AӔ AӔMe gusta mucho … I really like …
Y Y $%
M -%#
AӔ AӔ8_FA1 50b859c5c3804d0e856837324c804a13AӔ7? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 X r
'Rq e̾
)
1 NmA1 AӔ נfAӔ Jnavegar por internet surfing the internetAӔ נf@ @ AӔ נfKú'
qkQ1!A1 AӔ0{AӔ0/Edivertido amusingAӔ0{@ @ AӔ0{ՁQӏā'
us1!A1 AӔ5PmAӔ5Q_interesante interestingAӔ5Pm@ @ AӔ5PmU³̼r'
q{1 A1 AӔAӔR*Me gusta …
I like …AӔ@ @ AӔVӏ'
yy|E1 `FA1 AӔ GAӔ HSLir de compras going shoppingAӔ G@ @ AӔ GځJބ-'
ueKW1 sA1 AӔ"/AӔ"0¿Por qué? Why?AӔ"/@ @ AӔ"/^ӏ*(
, 1 4A1 AӔ`_AӔescuchar música listening to musicAӔ`_@ @ AӔ`_j̽w)
/1 qA1 AӔ2AӔ37No me gusta nada … I don’t like … at allAӔ2@ @ AӔ2Sݳ̾'
wuQS1 tA1 AӔFAӔG-Prefiero … I prefer …AӔF@ @ AӔF_ӏ̼|(
1 A1 AӔ AӔDMe gusta mucho … I really like …AӔ @ @ AӔ I泎¶'
oi1 IA1 AӔ(]VAӔ(]aburrido boringAӔ(]V@ @ AӔ(]VFΞĴ,'
gk1"/A1 AӔ8+AӔ8sano healthyAӔ8+@ @ AӔ8+[ߣ̾'
}M1 A1 AӔ
AӔFjugar al fútbol playing footballAӔ
@ @ AӔ
[۫-(
y6 1 JA1 AӔ$xAӔ$$JPorque es … Because it’s …AӔ$x@ @ AӔ$xSٜӏ̽'
{qz1 A1 AӔ AӔ }xMe encanta … I love …AӔ @ @ AӔ uؤó̻)
!1 A1 AӔ˰AӔw¿Qué no te gusta hacer?
What don’t you like doing?AӔ˰@ @ AӔ˰Yճ̿9(
s1K1 y%A1 AӔDAӔ,ir al cine going to the cinemaAӔD@ @ 0̾
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)
:E iEmD
_
.
} L " X
\
( V ${K$ o?f?zE +̿T 7Ka1 Tu11 salir con mis amigos 'ӏ' /6_m1 '{1 doing my homework2̻ E !1 {1 What don’t you like doing?$F )|E1 `Fu11 ir de compras ۓÜ !Q1!u11 divertido Ü Q1!{1 amusing(ԃ 1, 1 4{1 listening to musicݰӏ q1!}u11 caro ¶ t;1!6u11 barato $ؠJ )6 1 Ju11 Porque es … #דּ̽t 'QS1 tu11 Prefiero … & -2ě1 u11 hacer natación !֓ӏ̾% #1K1 y%u11 ir al cine '̼ /1 {1 I really like …+̾m 71 Nmu11 navegar por internet בû ˌ1!{1 easy ӏû ˌ1!u11 fácil &̾ -M1 {1 playing footballR W1!XQ{1 goodӏ¶ t;1!6{1 cheap I 1 Iu11 aburrido -ɳ̺ ;oa1 {1 What do you like doing?(ӏ' 16_m1 'u11 hacer mis deberes ӏ̻ !{1 {1 I like …&̼ -;1 4u11 No me gusta … ?̺ۓ _#?1 [{1 What do you like doing in your free time?%Ó̽ +z1 u11 Me encanta … *̾n 51 Nm{1 surfing the internet&řӏ̾ -V1 'u11 hacer atletismo (ӏ̼ 1;1 4{1 I don’t like …$F )|E1 `F{1 going shopping)ӏ̿ 3"1 u11 ver la televisión /ӏ̿U ?Ka1 T{1 going out with my friends+г̼ 7/1 qu11 No me gusta nada … )̼ 31 u11 Me gusta mucho … %ӏ̾ +V1 '{1 doing athletics)̾& 31K1 y%{1 going to the cinema ̽ !z1 {1 I love …'ϳ̾ /M1 u11 jugar al fútbol R W1!XQu11 bueno (J 16 1 J{1 Because it’s …)̿ 3"1 {1 watching television ꙔI 1 I{1 boring'姵̻ /{1 u11 Me gusta …
3仁̻ G !1 u11 ¿Qué no te gusta hacer?
"Ó̽t %QS1 t{1 I prefer …߳ā0 1"/u11 sano "ӏ %1!u11 interesante ! #1!{1 interesting ךӏ q1!}{1 expensive$Տӏ )2ě1 {1 going swimmingCԬӏ̺ۓ g#?1 [u11 ¿Qué te gusta hacer en tu tiempo libre?
"ɓs %KW1 su11 ¿Por qué? ' /, 1 4u11 escuchar música Ȼs KW1 s{1 Why?/Ųӏ̼ ?/1 q{1 I don’t like … at all Éā0 1"/{1 healthy-̺ ;oa1 u11 ¿Qué te gusta hacer?
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
: C |l[K:* tdSC2"
}
l
\
K
;
*
u d T C : 81"4,9 81"4,8 1"7 1"6 dw=1!5 dw=1!4 1!3 1!2 :u1!1 :u1!0 ZG1!|/ ZG1!|. R1!X5- R1!X5, s1!6+ s1!6* 1 -) 1 -( x'1 -' x'1 -& E1 W% E1 W$ E1 # E1 " ]1 `*! ]1 `* *#1 4 *#1 4 /q1 /q1 3W1 3W1 ګ1 9 ګ1 9 w1 y
w1 y
k
1 NQ k
1 NQ }1 ' }1 ' v1 v1 qu1 qu1 ߆1 w
߆1 w R͕1 q R͕1 q
51 4| 51 4| 1 r 1 r 1 1 n91 n91 (1 [w (1 [w
}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/
u
V
7
} AӔ8+1"/81"4, AӔ5Pm1!1" AӔ3ACˌ1!dw=1! AӔ0{Q1!1! AӔ.<}q1!}:u1! AӔ,ۍW1!XQZG1!| AӔ*L4t;1!6R1!X5 AӔ(]V1 Is1!6 AӔ$x6 1 J1 - AӔ"/KW1 sx'1 - AӔ #62ě1 E1 W AӔ G|E1 `FE1 AӔ`_, 1 4]1 `* AӔ6_m1 '*#1 4 AӔ"1 /q1 AӔȈYKa1 T3W1 AӔD1K1 y%ګ1 9 AӔ נf1 Nmw1 y
AӔ V1 'k
1 NQ AӔ
M1 }1 ' AӔFQS1 tv1 AӔ z1 qu1 AӔ2/1 q߆1 w AӔZ;1 4R͕1 q AӔ 1 51 4| AӔ{1 1 r AӔ˰ !1 1 AӔ #?1 [n91 AӔ.Moa1 (1 [w
~qdWJ=0# n91 k
1 NQ dw=1! R͕1 q R1!X5 E1 W 3W1 /q1 *#1 4 (1 [w :u1! ZG1!| w1 y
1! 1" 1 r E1 x'1 - ]1 `* ߆1 w v1 51 4| s1!6 81"4, }1 ' 1 - qu1 1 ګ1 9
t`L8$p\H4
AӔ881"4,AӔ5Q_1"AӔ3ABdw=1!AӔ0/E1!AӔ.:u1!AӔ,5aZG1!|AӔ*R1!X5AӔ(]s1!6AӔ$$J1 -AӔ"0x'1 -AӔ ɴE1 WAӔ HSLE1 AӔ]1 `*AӔx*#1 4AӔak/q1 AӔ,3W1 AӔ,Àګ1 9AӔ Jw1 y
AӔ Kbk
1 NQAӔF}1 'AӔG-v1 AӔ }xqu1 AӔ37߆1 wAӔiR͕1 qAӔD51 4|AӔR*1 rAӔwͰ1 AӔun91 AӔ/ (1 [w
t`L8$p\H4
AӔ8+1"/AӔ5Qg1!AӔ3Aˌ1!AӔ0 Q1!AӔ.嶉q1!}AӔ,W1!XQAӔ*t;1!6AӔ(]1 IAӔ$6 1 JAӔ"0WKW1 sAӔ 2ě1 AӔ H$|E1 `FAӔ, 1 4AӔI6_m1 'AӔ2"1 AӔ]Ka1 TAӔ1K1 y%AӔ 1 NmAӔ V1 'AӔM1 AӔFmQS1 tAӔ Mz1 AӔ3/1 qAӔ2;1 4AӔ1 AӔ{1 AӔH !1 AӔA#?1 [AӔ/oa1
~qdWJ=0# n91 k
1 NQ dw=1! R͕1 q R1!X5 E1 W 3W1 /q1 *#1 4 (1 [w :u1! ZG1!| w1 y
1! 1" 1 r E1 x'1 - ]1 `* ߆1 w v1 51 4| s1!6 81"4, }1 ' 1 - qu1 1 ګ1 9
|fP:$t^H2
@ n91 @ k
1 NQ@ dw=1!@ R͕1 q@ R1!X5@ E1 W@ 3W1 @ /q1 @ *#1 4@ (1 [w@ :u1!@ ZG1!|@ w1 y
@ 1!@ 1"@ 1 r@ E1 @ x'1 -@ ]1 `*@ ߆1 w@ v1 @ 51 4|@ s1!6@ 81"4,@ }1 '@ 1 -@ qu1 @ 1 @ ګ1 9
t`L8$p\H4
|E1 `FE1 z1 qu1 t;1!6R1!X5oa1 (1 [wV1 'k
1 NQQ1!1!M1 }1 'KW1 sx'1 -6_m1 '*#1 46 1 J1 -2ě1 E1 W1K1 y%ګ1 9, 1 4]1 `*#?1 [n91 "1 /q1 ;1 4R͕1 q1 Is1!6 !1 1 1 Nmw1 y
ˌ1!dw=1!QS1 tv1 1!1"1"/81"4,Ka1 T3W1 /1 q߆1 wW1!XQZG1!|q1!}:u1!{1 1 r1 51 4|
!2011-08-23 !2011-08-22! 2011-08-22
: x t`L8$p\H4
l
X
D
0
| h T @ , x |E1 `FuS1 `F|E1 `F S1 `Fz1 1 z1 荻1 t;1!6c1!6t;1!6?R1!6oa1 ;:K1 oa1 1 V1 '1 'V1 'K1 'Q1!tn1!Q1!l1!M1 Lo1 M1 {1 KW1 sL1 sKW1 s 1 s6_m1 '~<51 '6_m1 '2U1 '6 1 JYa1 J6 1 JZ1 J2ě1 VQ1 2ě1 ?1 1K1 y%UX1 y%1K1 y%?1 y&, 1 4iP 1 4, 1 4ȑs1 4#?1 [1 [#?1 [m1 ["1 j1 "1 ן1 ;1 4 g1 4;1 4
-1 41 I>_1 I1 Id1 I !1 w1 !1 1 1 NmR(1 Nm1 Nm+1 Nnˌ1!M\1!ˌ1!Lu1!QS1 tWc1 tQS1 tZ1 t1!e1!1!g1!1"/1"01"/%G1"0Ka1 T~1 TKa1 Tu1 U/1 qj1 q/1 qيM1 qW1!XQB?1!XRW1!XQ?1!XRq1!}gu1!}q1!}iM1!}{1 '1 {1 ʝ1 1 RI1 1 1
: x t`L8$p\H4
l
X
D
0
| h T @ , x {1 ~<51 '{1 w1 {1 l1!{1 iP 1 4{1 RI1 {1 M\1!{1 Lo1 {1 B?1!XR{1 ?R1!6{1 ;:K1 {1 '1 {1 1 [{1 +1 Nn{1
-1 4{1 S1 `F{1 u1 U{1 K1 '{1 ?1 y&{1 荻1 {1 Z1 J{1 ן1 {1 d1 I{1 Z1 t{1 g1!{1 iM1!}{1 ?1 {1 1 s{1 M1 q{1 %G1"0u11 ~1 Tu11 uS1 `Fu11 tn1!u11 gu1!}u11 c1!6u11 Ya1 Ju11 Wc1 tu11 VQ1 u11 UX1 y%u11 R(1 Nmu11 Lu1!u11 >_1 Iu11 2U1 'u11 g1 4u11 1 u11 1 'u11 j1 u11 j1 qu11 1 u11 {1 u11 ?1!XRu11 ʝ1 u11 1 u11 1"0u11 e1!u11 m1 [u11 L1 su11 s1 4u11 1
: s[>#wB
w
f
P
5
j K ; r U 7
j
R
) ";¿Qué te gusta hacer? 1 8g¿Qué te gusta hacer en tu tiempo libre?
m1 [(G¿Qué no te gusta hacer?
1 %¿Por qué? L1 s 3watching televisionן1 3ver la televisión j1 5surfing the internet+1 Nnsano 1"0 7salir con mis amigos ~1 T-playing footballLo1 7navegar por internet R(1 Nm 1listening to musiciP 1 4 /jugar al fútbol {1 )ir de compras uS1 `F#ir al cine UX1 y%#interestingg1!%interesante e1!healthy%G1"0-hacer natación VQ1 1hacer mis deberes 2U1 '-hacer atletismo 1 'goodB?1!XR 3going to the cinema?1 y&)going swimming?1 )going shopping S1 `F$?going out with my friendsu1 Ufácil Lu1! expensiveiM1!} /escuchar música s1 4easyM\1! /doing my homework~<51 '+doing athleticsK1 '!divertido tn1!cheap?R1!6caro gu1!}bueno ?1!XRboringd1 Ibarato c1!6amusingl1! aburrido >_1 IWhy? 1 s'EWhat don’t you like doing?w1 ";What do you like doing?;:K1 4_What do you like doing in your free time?1 ['Prefiero … Wc1 t)Porque es … Ya1 J-No me gusta … g1 4 7No me gusta nada … j1 q /Me gusta …
ʝ1 3Me gusta mucho … 1 +Me encanta … 1 /I really like …RI1 %I prefer …Z1 t!I love …荻1 !I like …'1 $?I don’t like … at allM1 q 1I don’t like …
-1 4 1Because it’s …Z1 J
: yj[L=. {l]N?0!
|
m
^
O
@
1
"
n91 k
1 NQdw=1!6R͕1 q R1!X5.E1 W&3W1 /q1 *#1 4 (1 [w:u1!2ZG1!|0w1 y
1!41"81 rE1 $x'1 -(]1 `*"߆1 wv1 51 4|
s1!6,81"4,:}1 '1 -*qu1 1 ګ1 9n91 k
1 NQdw=1!5R͕1 q R1!X5-E1 W%3W1 /q1 *#1 4
(1 [w:u1!1ZG1!|/w1 y
1!31"71 rE1 #x'1 -']1 `*!߆1 w
v1 51 4| s1!6+81"4,9}1 '1 -)qu1 1 ګ1 9
:
~qdWJ=0# zm`SF9,
w
j
]
P
C
6
)
n91 n91 k
1 NQ k
1 NQ dw=1!6 dw=1!5 R͕1 q R͕1 q R1!X5. R1!X5- E1 W& E1 W% 3W1 3W1 /q1 /q1 *#1 4 *#1 4 (1 [w (1 [w :u1!2 :u1!1 ZG1!|0 ZG1!|/ w1 y
w1 y
1!4 1!3 1"8 1"7 1 r 1 r E1 $ E1 # x'1 -( x'1 -' ]1 `*" ]1 `*! ߆1 w ߆1 w
v1 v1 51 4|
51 4| s1!6, s1!6+ 81"4,: 81"4,9 }1 ' }1 ' 1 -* 1 -) qu1 qu1 1 1 ګ1 9 ګ1 9
& xV4hF$
z
X
6
j H & !|E1 `FAӔ GE1 !z1 AӔ qu1 !t;1!6AӔ*L4R1!X5!oa1 AӔ.M(1 [w!V1 'AӔ k
1 NQ!Q1!AӔ0{1!!M1 AӔ
}1 '!KW1 sAӔ"/x'1 -!6_m1 'AӔ*#1 4!6 1 JAӔ$x1 -!2ě1 AӔ #6E1 W!1K1 y%AӔDګ1 9!, 1 4AӔ`_]1 `*!#?1 [AӔ n91 !"1 AӔ/q1 !;1 4AӔZR͕1 q!1 IAӔ(]Vs1!6! !1 AӔ˰1 !1 NmAӔ נfw1 y
!ˌ1!AӔ3ACdw=1!!QS1 tAӔFv1 !1!AӔ5Pm1"!1"/AӔ8+81"4,!Ka1 TAӔȈY3W1 !/1 qAӔ2߆1 w!W1!XQAӔ,ۍZG1!|!q1!}AӔ.<}:u1!!{1 AӔ1 r!1 AӔ 51 4|
> X.\2
`
6
d : h > )AӔ8+1"/AӔ8+81"4,)AӔ5Pm1!AӔ5Pm1")AӔ3ACˌ1!AӔ3ACdw=1!)AӔ0{Q1!AӔ0{1!)AӔ.<}q1!}AӔ.<}:u1!)AӔ,ۍW1!XQAӔ,ۍZG1!|)AӔ*L4t;1!6AӔ*L4R1!X5)AӔ(]V1 IAӔ(]Vs1!6)AӔ$x6 1 JAӔ$x1 -)AӔ"/KW1 sAӔ"/x'1 -)AӔ #62ě1 AӔ #6E1 W)AӔ G|E1 `FAӔ GE1 )AӔ`_, 1 4AӔ`_]1 `*)AӔ6_m1 'AӔ*#1 4)AӔ"1 AӔ/q1 )AӔȈYKa1 TAӔȈY3W1 )AӔD1K1 y%AӔDګ1 9)AӔ נf1 NmAӔ נfw1 y
)AӔ V1 'AӔ k
1 NQ)AӔ
M1 AӔ
}1 ')AӔFQS1 tAӔFv1 )AӔ z1 AӔ qu1 )AӔ2/1 qAӔ2߆1 w)AӔZ;1 4AӔZR͕1 q)AӔ 1 AӔ 51 4|)AӔ{1 AӔ1 r)AӔ˰ !1 AӔ˰1 )AӔ #?1 [AӔ n91 )AӔ.Moa1 AӔ.M(1 [w
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
> X r
'Rq e̾
)
1 NmA1 AӔ נfAӔ Jnavegar por internet surfing the internetAӔ נf@ @ AӔ נfKú'
qkQ1!A1 AӔ0{AӔ0/Edivertido amusingAӔ0{@ @ AӔ0{ՁQӏā'
us1!A1 AӔ5PmAӔ5Q_interesante interestingAӔ5Pm@ @ AӔ5PmU³̼r'
q{1 A1 AӔAӔR*Me gusta …
I like …AӔ@ @ AӔVӏ'
yy|E1 `FA1 AӔ GAӔ HSLir de compras going shoppingAӔ G@ @ AӔ GځJބ-'
ueKW1 sA1 AӔ"/AӔ"0¿Por qué? Why?AӔ"/@ @ AӔ"/^ӏ*(
, 1 4A1 AӔ`_AӔescuchar música listening to musicAӔ`_@ @ AӔ`_j̽w)
/1 qA1 AӔ2AӔ37No me gusta nada … I don’t like … at allAӔ2@ @ AӔ2Sݳ̾'
wuQS1 tA1 AӔFAӔG-Prefiero … I prefer …AӔF@ @ AӔF_ӏ̼|(
1 A1 AӔ AӔDMe gusta mucho … I really like …AӔ @ @ AӔ I泎¶'
oi1 IA1 AӔ(]VAӔ(]aburrido boringAӔ(]V@ @ AӔ(]VFΞĴ,'
gk1"/A1 AӔ8+AӔ8sano healthyAӔ8+@ @ AӔ8+[ߣ̾'
}M1 A1 AӔ
AӔFjugar al fútbol playing footballAӔ
@ @ AӔ
[۫-(
y6 1 JA1 AӔ$xAӔ$$JPorque es … Because it’s …AӔ$x@ @ AӔ$xSٜӏ̽'
{qz1 A1 AӔ AӔ }xMe encanta … I love …AӔ @ @ AӔ uؤó̻)
!1 A1 AӔ˰AӔw¿Qué no te gusta hacer?
What don’t you like doing?AӔ˰@ @ AӔ˰Yճ̿9(
s1K1 y%A1 AӔDAӔ,ir al cine going to the cinemaAӔD@ @ AӔD
1 1^
i
2N1 ӏ̻)
7/#?1 [A1 AӔ AӔu¿Qué te gusta hacer en tu tiempo libre?
What do you like doing in your free time?AӔ @ @ AӔ Y÷̾Q'
}{V1 'A1 AӔ AӔ Kbhacer atletismo doing athleticsAӔ @ @ AӔ Eӏ'
keˌ1!A1 AӔ3ACAӔ3ABfácil easyAӔ3AC@ @ AӔ3ACف]ӏ̼(
};1 4A1 AӔZAӔiNo me gusta … I don’t like …AӔZ@ @ AӔZF5'
kgt;1!6A1 AӔ*L4AӔ*barato cheapAӔ*L4@ @ AӔ*L4XW'
}y2ě1 A1 AӔ #6AӔ ɴhacer natación going swimmingAӔ #6@ @ AӔ #6j̿)
Ka1 TA1 AӔȈYAӔ,salir con mis amigos going out with my friendsAӔȈY@ @ AӔȈYb )
"1 A1 AӔAӔakver la televisión watching televisionAӔ@ @ AӔ^(
6_m1 'A1 AӔAӔxhacer mis deberes doing my homeworkAӔ@ @ AӔj̺w)
oa1 A1 AӔ.MAӔ/ ¿Qué te gusta hacer? What do you like doing?AӔ.M@ @ AӔ.MHӏÜ'
goq1!}A1 AӔ.<}AӔ.caro expensiveAӔ.<}@ @ AӔ.<}D'
ieW1!XQA1 AӔ,ۍAӔ,5abueno goodAӔ,ۍ@ @ 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