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Ӕ?csAӔ?cBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt d =hexCache{"411535322182206428": "5b61131f33243dc", "-8016060776023178277": "90c13b31f33243db", "-5418119308751256612": "b4cef931f33243dc", "3834308422379127772": "35363331f33243dc", "-4851426617748995109": "bcac4531f33243db"}%
?cssCache.fm90c13b31f33243db {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm35363331f33243dc {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqb4cef931f33243dc {text-align:center;}
#cmq5b61131f33243dc {text-align:center;}
#cmab4cef931f33243dc {text-align:center;}
#cma5b61131f33243dc {text-align:center;}
.cmbb4cef931f33243dc {background:#FFFFFF;}
.cmb5b61131f33243dc {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
#Ƴ
E12CBackArial1$Ȱ
E12CFrontArial1
" " e
E12CForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFeڳߓ
E12CReverse%(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)
)
? NG
^
; C
x
3 l ~? 5ǦO
7 E12CAӔtAӔtAel martes on Tuesday6ȯ
9 E12CAӔ]9AӔ]tal parque to the parkO
k E12CAӔAӔRa las diez de la mañana at ten in the morningK㺳a
c E12CAӔFUGAӔF¿Quieres ir … ? Do you want to go … ?:ӏ
A E12CAӔM+ZAӔM@al castillo to the castleB
Q E12CAӔbֲAӔbLba la piscina to the swimming pool-
' E12CAӔϚAӔE(Bueno. Good.;ӏd
C E12CAӔwJAӔwJel miércoles on WednesdayDӏ錆
U E12CAӔjxAӔjy7Ta la plaza de toros to the bullring0
- E12CAӔvAӔw$De acuerdo. OK.9y
? E12CAӔC(AӔCc^Invitaciones Invitations7ӏh
; E12CAӔZAӔZ7al museo to the museum1
/ E12CAӔn>AӔn¿Cuándo? When?6
9 E12CAӔQ%AӔQIal cine to the cinema2
1 E12CAӔAӔU.Está bien. Fine.=W
G E12CAӔCAӔt?¿A qué hora? At what time?MG
g E12CAӔa%AӔbBLo siento, no puedo. I’m sorry, I can’t.8ﳏd
= E12CAӔe%|AӔe%Ea la playa to the beach9ӏ;
? E12CAӔXAӔX$pal mercado to the marketFӏ
Y E12CAӔ_ccAӔ_ٶal polideportivo to the sports centre:ѡӏ߹
A E12CAӔVAӔVm&al estadio to the stadiumKь擬
c E12CAӔOv+AӔOwnal centro comercial to the shopping centre3ϊ9
3 E12CAӔqC=AӔqel lunes on Monday?h
K E12CAӔHAӔH Quiero ir … I want to go …7/
; E12CAӔ~Y/AӔ~Yrel sábado on Saturday6⯳
9 E12CAӔyHAӔyel jueves on Thursday5Ȓ
7 E12CAӔ{董AӔ{el viernes on Friday5ȅN
7 E12CAӔUAӔV(xel domingo on Sunday*쳏
! E12CAӔ$AӔ,RVale. OK.
Y Y $%
M -%#
AӔ?B$AӔb"AE12C6f79b44c551b16fb2bd9893fd6b15a82AӔ? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 _ x
5Bq X糏'
y}12h12CAӔHAӔH: Quiero ir … I want to go …AӔH@ @ AӔHP3'
ssg15/12CAӔ~Y/AӔ~Yջel sábado on SaturdayAӔ~Y/@ @ AӔ~Y/V۵'
{w 1165W12CAӔCAӔ̢¿A qué hora? At what time?AӔC@ @ AӔCLӏ4'
oo(15%912CAӔqC=AӔqel lunes on MondayAӔqC=@ @ AӔqC=Fӏ'
kgBU1612CAӔϚAӔsBueno. Good.AӔϚ@ @ AӔϚhӏy)
O17DG12CAӔa%AӔbrLo siento, no puedo. I’m sorry, I can’t.AӔa%@ @ AӔa%`ɓ躿(
J14 12CAӔ_ccAӔ_ al polideportivo to the sports centreAӔ_cc@ @ AӔ_ccN<'
so16N12CAӔUAӔVWel domingo on SundayAӔU@ @ AӔUO '
qsw!y1312CAӔ]9AӔ]al parque to the parkAӔ]9@ @ AӔ]9O߷'
qs{1512CAӔyHAӔyel jueves on ThursdayAӔyH@ @ AӔyHf湤)
1C1312CAӔOv+AӔOwal centro comercial to the shopping centreAӔOv+@ @ AӔOv+Oӑӏߜ'
mw13912CAӔQ%AӔQal cine to the cinemaAӔQ%@ @ AӔQ%\˲H(
wE14:12CAӔbֲAӔb{pa la piscina to the swimming poolAӔbֲ@ @ AӔbֲTӏ'
yuA]15}d12CAӔwJAӔwJxel miércoles on WednesdayAӔwJ@ @ AӔwJQƄӏk'
su{14id12CAӔe%|AӔe&#!a la playa to the beachAӔe%|@ @ AӔe%|jۡ)
t 16[12CAӔAӔa las diez de la mañana at ten in the morningAӔ@ @ AӔfßM)
]12xa12CAӔFUGAӔFM¿Quieres ir … ? Do you want to go … ?AӔFUG@ @ 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)
: j=
\/
y
S
( r G p =
i
2
^ 2uG b3 `1 ݸ BU1656312CGood.#ڡ '13956312Cto the cinema%錆 +4-1456312Cto the bullring#X ' 1165W56312CAt what time?! #J15 ;12Cel viernes ӏO 16N56312Con Sunday 139;12Cal cine 瓏O !y 115PO;12Cel martes %ӏW + 1165W;12C¿A qué hora? #ӏ< '}13;56312Cto the market!ֳ߹ #13_;12Cal estadio " %S12;12Cal castillo ,擬 91C1356312Cto the shopping centre!d #{14id;12Ca la playa $d )A]15}d;12Cel miércoles #| '212Gy;12CInvitaciones "ӏ %3̑16;12CDe acuerdo. !| #212Gy56312CInvitations/ӏ ?t 16[ѐ;12Ca las diez de la mañana "ѳd %A]15}d56312Con Wednesday!ӏO #16N;12Cel domingo #ӏ 'E14:ސ;12Ca la piscina ӏ BU16쥐;12CBueno. J15 56312Con Friday"Ǔd %{14id56312Cto the beach-듏a ;]12xa56312CDo you want to go … ?۳ 1656312CFine. /c17 56312COK. ӏP !y 115PO56312Con Tuesday*ݓ擬 51C13;12Cal centro comercial $߹ )13_56312Cto the stadium*柙_ 5E14:56312Cto the swimming pool 1456312CWhen? !w!y13;12Cal parque ٓ9 (15%956312Con Monday!/ #g15/;12Cel sábado *錆 54-14;12Ca la plaza de toros !謴 # 14;12C¿Cuándo? +铏G 7O17DG;12CLo siento, no puedo. +ӏ 7t 16[56312Cat ten in the morningӏ 3̑1656312COK. ӏ9 (15%9;12Cel lunes !Գ #w!y1356312Cto the park غ /c17 ;12CVale. "ط %16;12CEstá bien. $ӏh )12h;12CQuiero ir … 'ׇ /J14 ;12Cal polideportivo ! #{1556312Con Thursday#ϖ 'S1256312Cto the castle)͠a 3]12xa;12C¿Quieres ir … ? !̓鳏< #}13;;12Cal mercado h &m13h;12Cal museo 䑓 !{15;12Cel jueves &ɳӏh -12h56312CI want to go …#Ȁӏh '&m13h56312Cto the museum*ƿ 5J14 56312Cto the sports centre-ňӏG ;O17DG56312CI’m sorry, I can’t.!ĕӏ/ #g15/56312Con Saturday
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
: C |l[K:* tdSC2"
}
l
\
K
;
*
u d T C : 17ny9 17ny8 ;c17D,7 ;c17D,6
17 5
17 4 >163 >162 O 161 O 160 m16/ m16. 16[- 16[, Ÿ165<+ Ÿ165<* 163) 163( y3a15' y3a15& 15% 15$ ͕15# ͕15" D#15}H! D#15}H e15P4 e15P4 zY15% zY15% 2.14ߠ 2.14ߠ 14k 14k 14iH 14iH I14: I14: 14 14 $eW13 $eW13 )13M )13M `13
`13 G13_ G13_
139 139 [E13 [E13 g;12 g;12 |312M |312M p12xF p12xF
}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Ӕa%O17DG17ny AӔ$/c17 ;c17D, AӔϚBU16
17 AӔ16>16 AӔv3̑16O 16 AӔt 16[чm16 AӔC 1165W16[ AӔU16NŸ165< AӔ~Y/g15/163 AӔ{董J15 y3a15 AӔyH{1515 AӔwJA]15}d͕15 AӔty 115POD#15}H AӔqC=(15%9e15P4 AӔn> 14zY15% AӔjx4-142.14ߠ AӔe%|{14id14k AӔbֲE14:ޖ14iH AӔ_ccJ14 I14: AӔ]9w!y1314 AӔZ&m13h$eW13 AӔX}13;)13M AӔV䢅13_`13 AӔQ%139¦G13_ AӔOv+1C13139 AӔM+ZS12[E13 AӔH12hg;12 AӔFUG]12xa|312M AӔC(212Gyp12xF
~qdWJ=0# zY15% y3a15 p12xF [E13 O 16 D#15}H >16 ;c17D, 2.14ߠ )13M $eW13 `13 g;12 163 16[ e15P4
17 17ny I14: Ÿ165< 14 15 139 G13_ 14iH ͕15 14k m16 |312M
t`L8$p\H4
AӔbr17nyAӔ\;c17D,AӔs
17 AӔn>16AӔwSO 16AӔLJm16AӔ̢16[AӔVWŸ165<AӔ~Yջ163AӔ{Cy3a15AӔyƾ15AӔwJx͕15AӔtpaD#15}HAӔqe15P4AӔnzY15% AӔjyi42.14ߠAӔe&#!14kAӔb{p14iHAӔ_ I14:AӔ]14 AӔZgI$eW13AӔXS)13MAӔV`13 AӔQG13_AӔOwԩ139AӔMҍ[E13AӔH: g;12AӔFM|312MAӔCl@p12xF
t`L8$p\H4
AӔbBO17DGAӔ,R/c17 AӔE(BU16AӔU.16AӔw$3̑16AӔRt 16[AӔt? 1165WAӔV(x16NAӔ~Yrg15/AӔ{J15 AӔy{15AӔwJA]15}dAӔtAy 115POAӔq(15%9AӔn 14AӔjy7T4-14AӔe%E{14idAӔbLbE14:AӔ_ٶJ14 AӔ]tw!y13AӔZ7&m13hAӔX$p}13;AӔVm&13_AӔQI139AӔOwn1C13AӔM@S12AӔH 12hAӔF]12xaAӔCc^212Gy
~qdWJ=0# zY15% y3a15 p12xF [E13 O 16 D#15}H >16 ;c17D, 2.14ߠ )13M $eW13 `13 g;12 163 16[ e15P4
17 17ny I14: Ÿ165< 14 15 139 G13_ 14iH ͕15 14k m16 |312M
|fP:$t^H2
@ zY15% @ y3a15@ p12xF@ [E13@ O 16@ D#15}H@ >16@ ;c17D,@ 2.14ߠ@ )13M@ $eW13@ `13 @ g;12@ 163@ 16[@ e15P4@
17 @ 17ny@ I14:@ Ÿ165<@ 14 @ 15@ 139@ G13_@ 14iH@ ͕15@ 14k@ m16@ |312M
t`L8$p\H4
y 115POD#15}Hw!y1314 t 16[чm16]12xa|312MS12[E13E14:ޖ14iHBU16
17 A]15}d͕154-142.14ߠ3̑16O 16212Gyp12xF&m13h$eW13 14zY15% 139¦G13_16>16 1165W16[O17DG17ny{14id14k}13;)13MJ14 I14:13_`13 1C13139(15%9e15P412hg;12g15/163{1515J15 y3a1516NŸ165</c17 ;c17D,
!2011-08-23 !2011-08-22! 2011-08-22
: x t`L8$p\H4
l
X
D
0
| h T @ , x y 115PO[S915POy 115PO15PPw!y13%13w!y1313t 16[4E16[t 16[х16[]12xa Y12xa]12xa12xaS12M;w12S12X12E14:%G]14:E14: 14:BU16wu16BU16 m16A]15}dA15}dA]15}d+15}d4-14k#144-14S143̑1612G|212Gy8~ 12G|&m13h13h&m13h13h 14%14 14б14139qi 139139`>O13916
161616 1165Wi165X 1165WX'}165WO17DGɣI17DGO17DG"17DG{14idD@i14id{14id r914id}13;R13<}13;OK13<J14 14 J14 14 13_Nb13_13_13_1C13L131C1313(15%9f15%9(15%9[15%912h12h12h]12hg15/ا15/g15/Vm15/{1515{1515J15 g15 J15 15 16Nc16O16N'F-16O/c17
?17 /c17 17
: x t`L8$p\H4
l
X
D
0
| h T @ , x 56312Cwu1656312Cqi 13956312Ck#1456312Ci165X56312Cc16O56312CR13<56312CL1356312C8~ 12G|56312C+15}d56312C 15 56312C r914id56312C Y12xa56312C
1656312C
?17 56312C15PP56312C13_56312C 14:56312C%1456312Cf15%956312Cх16[56312C1656312Cܾ1356312Cܟ1556312CܞX1256312Cܒ]12h56312Cܐ13h56312C܌14 56312C܊"17DG56312C܈Vm15/;12Cg15 ;12C`>O139;12C[S915PO;12CX'}165W;12CNb13_;12CM;w12;12CD@i14id;12CA15}d;12C>12G|;12CO139 5al centro comercial 13%al castillo M;w12$?a las diez de la mañana 4E16[ 5a la plaza de toros S14#a la playa D@i14id'a la piscina %G]14:When?%14Vale. 17 )Quiero ir … 12hOK.
?17 OK.16 7Lo siento, no puedo. ɣI17DG";I’m sorry, I can’t."17DG#Invitations8~ 12G|'Invitaciones >12G|-I want to go …]12hGood.wu16Fine.
16%Está bien. 16";Do you want to go … ? Y12xa%De acuerdo. 164;c17D,82.14ߠ )13M$eW13`13 g;12163*16[.e15P4
17 617ny:I14:Ÿ165<,14 15&139
G13_ 14iH͕15$14km160|312MzY15% y3a15'
p12xF[E13O 161D#15}H!>163;c17D,72.14ߠ)13M$eW13`13
g;12163)16[-e15P4
17 517ny9I14:Ÿ165<+14 15%139 G13_ 14iH͕15#14km16/|312M
:
~qdWJ=0# zm`SF9,
v
i
\
P
C
6
)
zY15% zY15% y3a15( y3a15' p12xF p12xF [E13 [E13 O 162 O 161 D#15}H" D#15}H! >164 >163 ;c17D,8 ;c17D,7 2.14ߠ 2.14ߠ )13M )13M $eW13 $eW13 `13 `13
g;12 g;12 163* 163) 16[. 16[- e15P4 e15P4
17 6
17 5 17ny: 17ny9 I14: I14: Ÿ165<, Ÿ165<+ 14 14 15& 15% 139
139 G13_ G13_ 14iH 14iH ͕15$ ͕15# 14k 14k m160 m16/ |312M |312M
& xV4hF$
z
X
6
j H & !y 115POAӔtD#15}H!w!y13AӔ]914 !t 16[AӔm16!]12xaAӔFUG|312M!S12AӔM+Z[E13!E14:AӔbֲ14iH!BU16AӔϚ
17 !A]15}dAӔwJ͕15!4-14AӔjx2.14ߠ!3̑16AӔvO 16!212GyAӔC(p12xF!&m13hAӔZ$eW13! 14AӔn>zY15% !139AӔQ%G13_!16AӔ>16! 1165WAӔC16[!O17DGAӔa%17ny!{14idAӔe%|14k!}13;AӔX)13M!J14 AӔ_ccI14:!13_AӔV`13 !1C13AӔOv+139!(15%9AӔqC=e15P4!12hAӔHg;12!g15/AӔ~Y/163!{15AӔyH15!J15 AӔ{董y3a15!16NAӔUŸ165 X.\2
`
6
d : h > )AӔa%O17DGAӔa%17ny)AӔ$/c17 AӔ$;c17D,)AӔϚBU16AӔϚ
17 )AӔ16AӔ>16)AӔv3̑16AӔvO 16)AӔt 16[AӔm16)AӔC 1165WAӔC16[)AӔU16NAӔUŸ165<)AӔ~Y/g15/AӔ~Y/163)AӔ{董J15 AӔ{董y3a15)AӔyH{15AӔyH15)AӔwJA]15}dAӔwJ͕15)AӔty 115POAӔtD#15}H)AӔqC=(15%9AӔqC=e15P4)AӔn> 14AӔn>zY15% )AӔjx4-14AӔjx2.14ߠ)AӔe%|{14idAӔe%|14k)AӔbֲE14:AӔbֲ14iH)AӔ_ccJ14 AӔ_ccI14:)AӔ]9w!y13AӔ]914 )AӔZ&m13hAӔZ$eW13)AӔX}13;AӔX)13M)AӔV䢅13_AӔV`13 )AӔQ%139AӔQ%G13_)AӔOv+1C13AӔOv+139)AӔM+ZS12AӔM+Z[E13)AӔH12hAӔHg;12)AӔFUG]12xaAӔFUG|312M)AӔC(212GyAӔC(p12xF
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
> _ x
5Bq X糏'
y}12h12CAӔHAӔH: Quiero ir … I want to go …AӔH@ @ AӔHP3'
ssg15/12CAӔ~Y/AӔ~Yջel sábado on SaturdayAӔ~Y/@ @ AӔ~Y/V۵'
{w 1165W12CAӔCAӔ̢¿A qué hora? At what time?AӔC@ @ AӔCLӏ4'
oo(15%912CAӔqC=AӔqel lunes on MondayAӔqC=@ @ AӔqC=Fӏ'
kgBU1612CAӔϚAӔsBueno. Good.AӔϚ@ @ AӔϚhӏy)
O17DG12CAӔa%AӔbrLo siento, no puedo. I’m sorry, I can’t.AӔa%@ @ AӔa%`ɓ躿(
J14 12CAӔ_ccAӔ_ al polideportivo to the sports centreAӔ_cc@ @ AӔ_ccN<'
so16N12CAӔUAӔVWel domingo on SundayAӔU@ @ AӔUO '
qsw!y1312CAӔ]9AӔ]al parque to the parkAӔ]9@ @ AӔ]9O߷'
qs{1512CAӔyHAӔyel jueves on ThursdayAӔyH@ @ AӔyHf湤)
1C1312CAӔOv+AӔOwal centro comercial to the shopping centreAӔOv+@ @ AӔOv+Oӑӏߜ'
mw13912CAӔQ%AӔQal cine to the cinemaAӔQ%@ @ AӔQ%\˲H(
wE14:12CAӔbֲAӔb{pa la piscina to the swimming poolAӔbֲ@ @ AӔbֲTӏ'
yuA]15}d12CAӔwJAӔwJxel miércoles on WednesdayAӔwJ@ @ AӔwJQƄӏk'
su{14id12CAӔe%|AӔe&#!a la playa to the beachAӔe%|@ @ AӔe%|jۡ)
t 16[12CAӔAӔa las diez de la mañana at ten in the morningAӔ@ @ AӔfßM)
]12xa12CAӔFUGAӔFM¿Quieres ir … ? Do you want to go … ?AӔFUG@ @ AӔFUG
"G
j
0Ru J '
sg 1412CAӔn>AӔn¿Cuándo? When?AӔn>@ @ AӔn>N쓏'
soJ15 12CAӔ{董AӔ{Cel viernes on FridayAӔ{董@ @ AӔ{董RF'
ws212Gy12CAӔC(AӔCl@Invitaciones InvitationsAӔC(@ @ AӔC(Sӏ擑'
uwS1212CAӔM+ZAӔMҍal castillo to the castleAӔM+Z@ @ AӔM+ZIǝ'
uc3̑1612CAӔvAӔwSDe acuerdo. OK.AӔv@ @ AӔvNH'
qqy 115PO12CAӔtAӔtpael martes on TuesdayAӔt@ @ AӔtՁKڳ'
ug1612CAӔAӔnEstá bien. Fine.AӔ@ @ AӔǁC̳,'
ic/c17 12CAӔ$AӔ\Vale. OK.AӔ$@ @ AӔ$^ӏߠ(
{4-1412CAӔjxAӔjyi4a la plaza de toros to the bullringAӔjx@ @ AӔjxRӏM'
sw}13;12CAӔXAӔXSal mercado to the marketAӔX@ @ AӔXP'
ow&m13h12CAӔZAӔZgIal museo to the museumAӔZ@ @ AӔZS '
sy13_12CAӔVAӔVal estadio to the stadiumAӔV@ @ AӔV
; \
=
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