SQLite format 3 @ 0 2 N - 0 6=- 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 (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistory {tablestatsstatsCREATE TABLE stats (
id INTEGER NOT NULL,
type INTEGER NOT NULL,
day DATE NOT NULL,
reps INTEGER NOT NULL,
"averageTime" FLOAT NOT NULL,
"reviewTime" FLOAT NOT NULL,
"distractedTime" FLOAT NOT NULL,
"distractedReps" INTEGER NOT NULL,
"newEase0" INTEGER NOT NULL,
"newEase1" INTEGER NOT NULL,
"newEase2" INTEGER NOT NULL,
"newEase3" INTEGER NOT NULL,
"newEase4" INTEGER NOT NULL,
"youngEase0" INTEGER NOT NULL,
"youngEase1" INTEGER NOT NULL,
"youngEase2" INTEGER NOT NULL,
"youngEase3" INTEGER NOT NULL,
"youngEase4" INTEGER NOT NULL,
"matureEase0" INTEGER NOT NULL,
"matureEase1" INTEGER NOT NULL,
"matureEase2" INTEGER NOT NULL,
"matureEase3" INTEGER NOT NULL,
"matureEase4" INTEGER NOT NULL,
PRIMARY KEY (id)
)]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)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars
u '
mediaLocation pageSize4096c ;hexCache{"-7175879960534326310": "9c6a27320181e3da", "1017509165838492635": "e1eeb320181e3db", "8991607295121155035": "7cc89b320181e3db", "1503952901175895003": "14df1d320181e3db", "7742117883269997531": "6b7187320181e3db"}'
CcssCache.fme1eeb320181e3db {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm6b7187320181e3db {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq14df1d320181e3db {text-align:center;}
#cmq7cc89b320181e3db {text-align:center;}
#cma14df1d320181e3db {text-align:center;}
#cma7cc89b320181e3db {text-align:center;}
.cmb14df1d320181e3db {background:#FFFFFF;}
.cmb7cc89b320181e3db {background:#FFFFFF;}
!revSpacing0.1 )latexPost\end{document}>
qlatexPre\documentclass[12pt]{article}
\special{papersize=3in,5in}
\usepackage[utf8]{inputenc}
\usepackage{amssymb,amsmath}
\pagestyle{empty}
\setlength{\parindent}{0in}
\begin{document}
mediaURL!newSpacing60#
revInactive#
newInactive
revActive
newActive
perDay1!leechFails16)suspendLeeches1
+wiYJ8 'mediaLocation pageSize) suspendLeeches!revSpacing #revInactive
revActive
perDay!newSpacing#newInactive
newActive mediaURL !leechFails latexPre
latexPost hexCache cssCache
/Κ
AӕT AӕT
BasicBasic?<
" !2011-08-25" !2011-08-25
#ܰ
j'2BackArial1$ݳ
j'2FrontArial1
" " e
j'2Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeӐ
j'2Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFF
1 1
V
r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVarsJktablesourcessourcesCREATE 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)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistory 4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)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 (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
CHECK (numeric IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
yu !!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)
)
@G
3 L -
CܓĨ
S j'2Aӕj hAӕjfui a la playa I went to the beach9
? j'2AӕWCAӕ/Soy turista I'm a tourist^n
j'2AӕFAӕ voy a comprar unas camisetas I’m going to buy some T-shirtsLг
e j'2AӕrAӕ!Ayer por la tarde … Yesterday evening …WǓ/
{ j'2AӕAӕ{Svoy a ir al Tibidabo I’m going to go to the TibidaboL
e j'2AӕQ7AӕŤLo pasé fenomenal. I had a wonderful time.F
Y j'2Aӕg yAӕgdescansé un poco I had a little rest7A
; j'2Aӕ eAӕ! 7Me gustó. I liked it.H,
] j'2Aӕ:AAӕ;JEstoy en Barcelona. I’m in Barcelona.2ӳ
1 j'2AӕGAӕdsHoy … Today …9ɦ۴
? j'2Aӕ#Aӕ$W~Es genial. It’s great.9㩵ӐŽ
? j'2Aӕ F5Aӕ Mañana … Tomorrow …BӐ
Q j'2AӕAӕYNo me gustó. I didn’t like it.Oۜ
k j'2Aӕ
uAӕ
vMvoy a ir de compras I’m going to go shoppingJԌ
a j'2Aӕĩ$AӕĩAnteayer … The day before yesterday …^ޜ6
j'2AӕAAӕd$comí paella y bebí limonada I ate paella and drank lemonadeNǑ
i j'2AӕTAӕBPasado mañana … The day after tomorrow …
Y Y $%
M -%#
AӕKAӕ Aj'2744a0dc2cc6f79aa76883c3a168548a4Aӕ? XPriorityVeryHighPriorityHighPriorityLowX8@
Z
3 Y
} ,;JDH Z cӐ(
u32y 2Aӕĩ$AӕĩeAnteayer … The day before yesterday …Aӕĩ$@ @ Aӕĩ$q퓐)
92n/ 2AӕAӕvoy a ir al Tibidabo I’m going to go to the TibidaboAӕ@ @ Aӕ{߳e)
x26 2AӕAAӕcomí paella y bebí limonada
I ate paella and drank lemonadeAӕA@ @ AӕAf%)
k2H 2AӕQ7AӕLo pasé fenomenal. I had a wonderful time.AӕQ7@ @ AӕQ7fĐč)
"2 2AӕrAӕAyer por la tarde … Yesterday evening …Aӕr@ @ AӕrցQj'
qwC_2 2AӕWCAӕ eSoy turistaI'm a touristAӕWC@ @ AӕWC[قŢ(
w2( 2AӕAӕNo me gustó. I didn’t like it.Aӕ@ @ Aӕ_ؿȬ(
S2" 2Aӕg yAӕghdescansé un poco I had a little restAӕg y@ @ Aӕg yJ'
kor2 2AӕGAӕHoy … Today …AӕG@ @ AӕGQ˳r'
qw%72[ 2Aӕ#Aӕ$Es genial. It’s great.Aӕ#@ @ Aӕ#iﻳR)
q2 2Aӕ
uAӕ
v{voy a ir de compras I’m going to go shoppingAӕ
u@ @ Aӕ
uQɪ'
suƥ2E 2Aӕ F5Aӕ #Mañana … Tomorrow …Aӕ F5@ @ Aӕ F5O'
qs2A 2Aӕ eAӕ!2<Me gustó. I liked it.Aӕ e@ @ Aӕ e\峐(
yx2Ĩ 2Aӕj hAӕjfui a la playa I went to the beachAӕj h@ @ Aӕj hhг)
2I 2AӕTAӕr`Pasado mañana … The day after tomorrow …AӕT@ @ AӕT{߈5)
$Y!2n 2AӕFAӕ;?voy a comprar unas camisetas
I’m going to buy some T-shirtsAӕF@ @ AӕFb˂ۘ)
29, 2Aӕ:AAӕ;@Estoy en Barcelona. I’m in Barcelona.Aӕ:A@ @ Aӕ:A
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)
" 2 n9a.
b
/
P % k 4
g
9 ^ 2 "Ž %ƥ2Ekq2Tomorrow …+ 7"2kq2Yesterday evening …5Ӑ6 Kx26kq2I ate paella and drank lemonade# 'C_2kq2I'm a tourist0Ӑ A 2Ikq2The day after tomorrow …$ )2( 2No me gustó. *, 529, 2Estoy en Barcelona. *徳 5k2H 2Lo pasé fenomenal. 2賐 E32ykq2The day before yesterday … r2 kq2Today …- ;k2Hkq2I had a wonderful time."Ž %ƥ2E 2Mañana … *Ӑ 5q2 2voy a ir de compras !֍ #C_2 2Soy turista%Ӑĩ +x2Ĩ 2fui a la playa !ӐA #2A 2Me gustó. 6õn M$Y!2nkq2I’m going to buy some T-shirts7ګ6 Ox26 2comí paella y bebí limonada
)뤓ĩ 3x2Ĩkq2I went to the beach!֑A #2Akq2I liked it.)Ӑ 32(kq2I didn’t like it.7ܔӐ/ O 92n/kq2I’m going to go to the Tibidabo ד r2 2Hoy … #Ӑ۴ '%72[kq2It’s great.,ܳ 9"2 2Ayer por la tarde … )ڽ 3 2I 2Pasado mañana … )״ 3S2"kq2I had a little rest6мn M$Y!2n 2voy a comprar unas camisetas
)̓Ӑ, 329,kq2I’m in Barcelona.(̡Ӑ 1S2" 2descansé un poco +̗/ 7 92n/ 2voy a ir al Tibidabo 0퓐 Aq2kq2I’m going to go shopping!ŷӐ۴ #%72[ 2Es genial. #ņ '32y 2Anteayer …
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
"
|l[K:* tdSC2"
" !25! !25 2R 2R Xwi2 Xwi2 >2n >2n 2I 2I d2E d2E 2( 2( 'K2% 'K2% a2H a2H *2"e *2"e ߃+2
߃+2 2č 2č
dXm2 dXm2 [2yr [2yr
2[
2[ 29 29 a2 j a2 j
^P?3$ # fieldModels0' modelsDeleted0 fields0' reviewHistory0 models0
stats0
cardTags0
media0
! cardModels0 sources0+ CdeckVarssqlite_autoindex_deckVars_112 1% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
eF'mN/
AӕF$Y!2n!25 Aӕ
uq22R Aӕ 92n/Xwi2 AӕT 2I>2n Aӕ F5ƥ2E2I Aӕη2(d2E Aӕ e2A2( AӕQ7k2H'K2% Aӕg yS2"a2H AӕAx26*2"e Aӕj hx2Ĩ߃+2 Aӕr"22č Aӕĩ$32ydXm2 Aӕ#%72[[2yr Aӕ:A29,
2[ AӕGr2 29 AӕWCC_2a2 j
# ~qdWJ=0# dXm2 Xwi2 *2"e 'K2% 2č a2 j d2E a2H 29 [2yr 2R 2I 2( ߃+2 >2n !25
2[
t`L8$ Aӕ;?!25Aӕ
v{2RAӕXwi2Aӕr`>2nAӕ #2IAӕd2EAӕ!2<2(Aӕ'K2%Aӕgha2HAӕ*2"eAӕj߃+2Aӕ2čAӕĩedXm2Aӕ$[2yrAӕ;@
2[Aӕ29Aӕ ea2 j
t`L8$ Aӕ $Y!2nAӕ
vMq2Aӕ{S 92n/AӕB 2IAӕ ƥ2EAӕYⷁ2(Aӕ! 72AAӕŤk2HAӕgS2"Aӕd$x26Aӕjx2ĨAӕ!"2Aӕĩݨ32yAӕ$W~%72[Aӕ;J29,Aӕdsr2 Aӕ/C_2
# ~qdWJ=0# dXm2 Xwi2 *2"e 'K2% 2č a2 j d2E a2H 29 [2yr 2R 2I 2( ߃+2 >2n !25
2[
|fP:$ @ dXm2@ Xwi2@ *2"e@ 'K2%@ 2č@ a2 j@ d2E@ a2H@ 29@ [2yr@ 2R@ 2I@ 2(@ ߃+2@ >2n@ !25@
2[
t`L8$ x2Ĩ߃+2C_2a2 j$Y!2n!25"22č 92n/Xwi2k2H'K2%S2"a2H2A2(29,
2[r2 29%72[[2yrƥ2E2I2(d2Eq22R32ydXm2x26*2"e 2I>2n
!2011-08-25! 2011-08-25
"
X t`L8$p\H4
l
X x2Ĩ
]2ĩx2Ĩ!2ĩC_2d2C_2Xo2$Y!2n
2n$Y!2nA2n"2x 2"2q2 92n/p2n/ 92n/\2n/k2HQ2Hk2HD2HS2"w2"S2"]2"2A
2A2AX2A29,S29,29,}29,r2 Dw2 r2 Œ2 %72[2[%72[M2[ƥ2E|k2Eƥ2E#2E2(Z#2(2(؛M2(q22q2i232yMkC2y32yw2yx26r26x26iY26 2I`E2I 2Iƴ2I
"
X t`L8$p\H4
l
X kq2|k2Ekq2x 2kq2r26kq2d2kq2`E2Ikq2MkC2ykq2Dw2 kq2D2Hkq2
2nkq2!2ĩkq2X2Akq2؛M2(kq2p2n/kq2۷2[kq2ۮw2"kq2ۚ}29,kq2ۋi2 2Z#2( 2S29, 2Q2H 2#2E 22 2Xo2 2
]2ĩ 2
2A 2iY26 2Œ2 2۵q2 2۴2I 2A2n 2ۘ]2" 2ۘ\2n/ 2ۊM2[ 2ۊw2y
" zO0Z4
`
I
# b G 5voy a ir de compras 2 7voy a ir al Tibidabo \2n/+Mvoy a comprar unas camisetas
A2n+fui a la playa
]2ĩ 1descansé un poco ]2",Ocomí paella y bebí limonada
iY26 7Yesterday evening …x 2%Tomorrow …|k2E Today …Dw2 'EThe day before yesterday …MkC2y%AThe day after tomorrow …`E2I#Soy turistaXo2 3Pasado mañana … 2I)No me gustó. Z#2(#Me gustó.
2A%Mañana … #2E 5Lo pasé fenomenal. Q2H 3I’m in Barcelona.}29,,OI’m going to go to the Tibidabop2n/%AI’m going to go shoppingi2+MI’m going to buy some T-shirts
2n'It’s great.2['I'm a touristd2 3I went to the beach!2ĩ#I liked it.X2A";I had a wonderful time.D2H 3I had a little restw2" 3I didn’t like it.؛M2(*KI ate paella and drank lemonader26 Hoy … Œ2 5Estoy en Barcelona. S29,#Es genial. M2[!9Ayer por la tarde … q2'Anteayer … w2y
" yj[M>/ {l]N?0! dXm2
Xwi2 *2"e'K2%2č a2 jd2Ea2H29[2yr2R 2I2(߃+2>2n !25"
2[dXm2 Xwi2 *2"e'K2%2č
a2 jd2Ea2H29[2yr2R 2I2(߃+2
>2n!25!
2[
"G ~qdWJ=0# {naTG dXm2
dXm2 Xwi2 Xwi2 *2"e *2"e 'K2% 'K2% 2č 2č a2 j a2 j d2E d2E a2H a2H 29 29 [2yr [2yr 2R 2R 2I 2I 2( 2( ߃+2 ߃+2
>2n >2n !25" !25!
2[
2[
xV4hF$
!x2ĨAӕj h߃+2!C_2AӕWCa2 j!$Y!2nAӕF!25!"2Aӕr2č! 92n/AӕXwi2!k2HAӕQ7'K2%!S2"Aӕg ya2H!2AAӕ e2(!29,Aӕ:A
2[!r2 AӕG29!%72[Aӕ#[2yr!ƥ2EAӕ F52I!2(Aӕd2E!q2Aӕ
u2R!32yAӕĩ$dXm2!x26AӕA*2"e! 2IAӕT>2n
6 X.\2
`
6 )AӕF$Y!2nAӕF!25)Aӕ
uq2Aӕ
u2R)Aӕ 92n/AӕXwi2)AӕT 2IAӕT>2n)Aӕ F5ƥ2EAӕ F52I)Aӕη2(Aӕd2E)Aӕ e2AAӕ e2()AӕQ7k2HAӕQ7'K2%)Aӕg yS2"Aӕg ya2H)AӕAx26AӕA*2"e)Aӕj hx2ĨAӕj h߃+2)Aӕr"2Aӕr2č)Aӕĩ$32yAӕĩ$dXm2)Aӕ#%72[Aӕ#[2yr)Aӕ:A29,Aӕ:A
2[)AӕGr2 AӕG29)AӕWCC_2AӕWCa2 j
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
; \
=
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