SQLite format 3 @ & 2 2 N & - 2 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
j u Yt c ;hexCache{"1208408573587799856": "10c52131fc3cbf30", "2697010978154659632": "256db531fc3cbf30", "7531350300229943088": "6884bb31fc3cbf30", "8480415751977353008": "75b07d31fc3cbf30", "5880013577682468656": "519a0131fc3cbf30"}(
EcssCache.fm519a0131fc3cbf30 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm6884bb31fc3cbf30 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq256db531fc3cbf30 {text-align:center;}
#cmq75b07d31fc3cbf30 {text-align:center;}
#cma256db531fc3cbf30 {text-align:center;}
#cma75b07d31fc3cbf30 {text-align:center;}
.cmb256db531fc3cbf30 {background:#FFFFFF;}
.cmb75b07d31fc3cbf30 {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
/0
AӕC`4{-AӕC`4{FBasicBasic?<
" !2011-08-24" !2011-08-24
$0
!1<0FrontArial1#0
!1<0BackArial1
" " eӏ0
!1<0Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFe۶ӏ0
!1<0Forward%(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)
)
{Ae!
V d u 1
~
< GT Bğ
Q !1<0AӕC TAӕC u¿Qué te gusta? What do you like?<ߓG
E !1<0AӕC6AӕClas hamburguesas hamburgersIä
_ !1<0AӕCzAӕCMe interesan … I’m interested in …P
m !1<0AӕC|
AӕC|ٖ>Salgo con mis amigos. I go out with my friends.AY
O !1<0AӕC{
AӕC{
Mando mensajes. I send messages.c쳏
!1<0AӕCeZAӕCe,¿Qué haces en tu tiempo libre? What do you do in your free time?3䰳Ձ
3 !1<0AӕCRAӕCSAlos cómics comics8ӏ
= !1<0AӕC AӕC :Me gustan … I like …Bȓ°
Q !1<0AӕCb,AӕCbEn mi tiempo libre In my free time]7
!1<0AӕCЅAӕCDNo me interesan los cómics. I’m not interested in comics.:ӏ
A !1<0AӕCtAӕCtEHago deporte. I do sport.Dӏ
U !1<0AӕCmAӕCmɔChateo por internet. I chat online.Nε
i !1<0AӕCwƤAӕCw9Juego con el ordenador. I play on my computer.?顓
K !1<0AӕCaAӕCbOVoy de compras. I go shopping.KޓK
c !1<0AӕCJAӕC{¿Qué no te gusta? What don’t you like?<ؐ
E !1<0AӕCӞAӕCFlos videojuegos video gamesNQ
i !1<0AӕCAӕCLNo me gusta la música. I don’t like music.8i
= !1<0AӕC\֡AӕC]LMe gusta … I like …1-
/ !1<0AӕC$:KAӕC$la música musicD
U !1<0AӕCoCAӕCo7Escucho música. I listen to music.:ߓ*
A !1<0AӕC*AӕC3Me encanta … I love …Bϓ:
Q !1<0AӕCl6AӕClOdio el fútbol. I hate football.4ݱ
5 !1<0AӕCyAӕCxel fútbol footballH״'
] !1<0AӕC
AӕC]Me interesa … I’m interested in …0Խ
- !1<0AӕCk)NAӕCk)ϼBailo. I dance.;̨[
C !1<0AӕC)> AӕC){Me encantan … I love …6鬳
9 !1<0AӕCO*AӕCPla natación swimming
Y Y $%
M -%#
AӕC`%KAӕCA!1<0f5f0ac92c1064f7d5e59b0f5dccc56ecAӕE 2? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 w
-Xd fȓ)
1AKK%m1<0AӕCJAӕC¿Qué no te gusta? What don’t you like?AӕCJ@ @ AӕCJTӏf'
}q1@[%m1<0AӕC)> AӕC)Me encantan … I love …AӕC)> @ @ AӕC)> M'
smc1?%m1<0AӕCyAӕCԩ;el fútbol footballAӕCy@ @ AӕCyiဓ )
!W1Ay%m1<0AӕCAӕCGNo me gusta la música. I don’t like music.AӕC@ @ AӕCJӏ'
sgC1@-%m1<0AӕC$:KAӕC$la música musicAӕC$:K@ @ AӕC$:Kcӏ@(
m
!1@%m1<0AӕCzAӕC'Me interesan … I’m interested in …AӕCz@ @ AӕCzU.'
qz1A)G%m1<0AӕC6AӕC-las hamburguesas hamburgersAӕC6@ @ AӕC6^(
o1=%m1<0AӕCoCAӕCofEscucho música. I listen to music.AӕCoC@ @ AӕCoCペ)
% ]c1< %m1<0AӕCeZAӕCe[6¿Qué haces en tu tiempo libre?
What do you do in your free time?AӕCeZ@ @ AӕCeZQ䓏'
wqT%u1@Z%m1<0AӕC AӕC m
Me gustan …I like …AӕC @ @ AӕC bܔӏ(
} 1?'%m1<0AӕC
AӕCLMe interesa … I’m interested in …AӕC
@ @ AӕC
Uڱ,'
}s
`1A%m1<0AӕCӞAӕCwlos videojuegos video gamesAӕCӞ@ @ AӕCӞSГ'
{q61?*%m1<0AӕC*AӕCҿMe encanta … I love …AӕC*@ @ AӕC*Iҷg'
ioO1=%m1<0AӕCk)NAӕCk*Bailo. I dance.AӕCk)N@ @ AӕCk)N߁XŰ'
}y 1>~%m1<0AӕCaAӕCbVoy de compras. I go shopping.AӕCa@ @ AӕCakɡ)
f^1>b%m1<0AӕC|
AӕC|Salgo con mis amigos. I go out with my friends.AӕC|
@ @ AӕC|
Qɛ '
wq;1>i%m1<0AӕC\֡AӕC]{Me gusta … I like …AӕC\֡@ @ 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)
6 ~FmC
J
T ' ` *
S
X -q< uEo@ 퓏+ !61?*Q1<0I love … ߓ O1=Q1<0 I dance.!瓏 #+1=Q1<0I do sport.%ӏ³ +MA1<°Q1<0In my free time*гK 5
1AKKh1<0¿Qué no te gusta? ,ۓ 991=Q1<0I play on my computer. ³ c1@8Q1<0swimming:Ì U]c1< h1<0¿Qué haces en tu tiempo libre?
&ɓ - 1>~h1<0Voy de compras. G !z1A)GQ1<0hamburgers"ߖӏՁ %U1@Ձh1<0los cómics 6㓏7 M61A7h1<0No me interesan los cómics.
': /*y1A:h1<0Odio el fútbol. + 7&-1=jh1<0Chateo por internet. Ղ U1@ՁQ1<0comics'G /z1A)Gh1<0las hamburguesas -Փ ;m
!1@Q1<0I’m interested in …$ )&-1=jQ1<0I chat online.! #c1?h1<0el fútbol %擏+ +61?*h1<0Me encanta … #ӏ 'T%u1@Zh1<0Me gustan …&ӏ -
`1Ah1<0los videojuegos *Y 5^t+1>0Yh1<0Mando mensajes.
1ͱ C91=h1<0Juego con el ordenador.
' /m
!1@h1<0Me interesan … 5ӏ7 K61A7Q1<0I’m not interested in comics.(ӏ 1o1=Q1<0I listen to music.+ 7 !W1AyQ1<0I don’t like music.,ӏ 9f^1>bh1<0Salgo con mis amigos. ,K 9
1AKKQ1<0What don’t you like? ų !T%u1@ZQ1<0I like …-ӏ' ;1?'Q1<0I’m interested in …&ӏ' -1?'h1<0Me interesa … #ӏ 'c1@8h1<0la natación !荖ӏ #
`1AQ1<0video games&[ -1@[h1<0Me encantan … &䈩: -*y1A:Q1<0I hate football. ⓠj !;1>iQ1<0I like …7Σӏ O]c1< Q1<0What do you do in your free time?/ޒ ?f^1>bQ1<0I go out with my friends.&ОY -^t+1>0YQ1<0I send messages.'܄ӏ /{1>Q1<0What do you like?(ӏ³ 1MA1<°h1<0En mi tiempo libre#ӏi ';1>ih1<0Me gusta … γ\ !1@[Q1<0I love …؊ӏ. C1@-Q1<0music$ӏ )+1=h1<0Hago deporte. c1?Q1<0football$˖ϓ ) 1>~Q1<0I go shopping.&ԇӏ -{1>h1<0¿Qué te gusta?.ą = !W1Ayh1<0No me gusta la música. ӏ O1=h1<0Bailo.!ӏ. #C1@-h1<0la música 'ӏ /o1=h1<0Escucho música.
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
6 |l[K:* tdSC2"
}
l
\
K
;
*
6 1B&5 1B&4 d 1A 3 d 1A 2 1A 1 1A 0 A1Ay/ A1Ay. ٿ1AK.- ٿ1AK., 1A),+ 1A),* S1A) S1A( 1@f' 1@f& -1@@% -1@@$ _!1@# _!1@" l1@Z! l1@Z 1@8 1@8 1@ 1@ @1? @1? R1? R1? m1? m1? !ڻ1>O !ڻ1>O 1> 1> 1>~ 1>~ ;1>b ;1>b 8Q1>0>
8Q1>0> zq1= zq1=
1= 1= 81=g 81=g 71=jg 71=jg 1= 1= [ƣ1< [ƣ1<
^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/
u
V
7
AӕCЅ61A7 1B& AӕCl6ƻ*y1A:d 1A AӕC !W1Ay1A AӕCJ
1AKKA1Ay AӕC6z1A)Gٿ1AK. AӕCӞ
`1A1A), AӕCRU1@ՁS1A AӕC)> 1@[1@f AӕCzm
!1@-1@@ AӕC T%u1@Zؿ_!1@ AӕCO*c1@8l1@Z AӕC$:KC1@-1@8 AӕCyc1?1@ AӕC*61?*@1? AӕC
1?'R1? AӕC\֡;1>im1? AӕC T{1>!ڻ1>O AӕCa 1>~ݣ1> AӕC|
f^1>bʒ1>~ AӕC{
^t+1>0Y;1>b AӕCwƤ91=8Q1>0> AӕCt+1=zq1= AӕCoCo1=1= AӕCm&-1=j81=g AӕCk)NߨO1=ߤ71=jg AӕCeZ]c1< 1= AӕCb,MA1<°[ƣ1<
~qdWJ=0# l1@Z zq1= d 1A [ƣ1< S1A ;1>b 81=g 8Q1>0> !ڻ1>O 1B& A1Ay 1@f 1@ 1A 1@8 -1@@ ٿ1AK. 1= 1= _!1@ R1? 1A), @1? 71=jg 1> 1>~ m1?
t`L8$p\H4
AӕCt 1B&AӕCld 1A AӕCG1A AӕCA1AyAӕC-ٿ1AK.AӕCwɴ1A),AӕCSpS1AAӕC)1@fAӕC'-1@@AӕC m
_!1@AӕCP;l1@ZAӕC$1@8AӕCԩ;1@AӕCҿ@1?AӕCLR1?AӕC]{m1? AӕC /o!ڻ1>OAӕCb1>AӕC|1>~AӕC{
@;1>bAӕCwhb8Q1>0>AӕCtv)zq1=AӕCof1=AӕCmz81=gAӕCk*71=jgAӕCe[6 1=AӕCb![ƣ1<
t`L8$p\H4
AӕCD61A7AӕCl*y1A:AӕCL !W1AyAӕC{
1AKKAӕCz1A)GAӕCF
`1AAӕCSAU1@ՁAӕC){1@[AӕCm
!1@AӕC :T%u1@ZAӕCPc1@8AӕC$C1@-AӕCxc1?AӕC361?*AӕC]1?'AӕC]L;1>iAӕC u{1>AӕCbO 1>~AӕC|ٖ>f^1>bAӕC{
^t+1>0YAӕCw991=AӕCtE+1=AӕCo7o1=AӕCmɔ&-1=jAӕCk)ϼO1=AӕCe,]c1< AӕCbMA1<°
~qdWJ=0# l1@Z zq1= d 1A [ƣ1< S1A ;1>b 81=g 8Q1>0> !ڻ1>O 1B& A1Ay 1@f 1@ 1A 1@8 -1@@ ٿ1AK. 1= 1= _!1@ R1? 1A), @1? 71=jg 1> 1>~ m1?
|fP:$t^H2
@ l1@Z@ zq1=@ d 1A @ [ƣ1<@ S1A@ ;1>b@ 81=g@ 8Q1>0>@ !ڻ1>O@ 1B&@ A1Ay@ 1@f@ 1@@ 1A @ 1@8@ -1@@@ ٿ1AK.@ 1=@ 1=@ _!1@@ R1?@ 1A),@ @1?@ 71=jg@ 1>@ 1>~@ m1?
t`L8$p\H4
{1>!ڻ1>Oz1A)Gٿ1AK.m
!1@-1@@f^1>bʒ1>~^t+1>0Y;1>b]c1< 1=U1@ՁS1AT%u1@Zؿ_!1@MA1<°[ƣ1<61A7 1B&+1=zq1=&-1=j81=g91=8Q1>0> 1>~ݣ1>
1AKKA1Ay
`1A1A), !W1Ay1A ;1>im1? C1@-1@8o1=1=61?*@1?*y1A:d 1A c1?1@1?'R1?O1=ߤ71=jg1@[1@fc1@8l1@Z
!2011-08-24! 2011-08-24
6 t`L8$p\H4
l
X
D
0
| h T @ , {1>1>{1>P=1>z1A)GK 1A)Gz1A)G:o1A)Gm
!1@51@m
!1@Û1@f^1>bM1>bf^1>bʼH1>b^t+1>0Y1>0Y^t+1>0Y@1>0Y]c1< W a1< ]c1< 9 1< U1@ՁE|1@ՁU1@Ձ=1@ՂT%u1@Z.1@ZT%u1@Zڪ+1@ZMA1<°q=1<³MA1<° 1<³61A7A/1A761A71A7+1=y91=+1=ڦ~TI1>~ 1>~ݖZy1>~
1AKKnF1AKK
1AKK1AKK
`1A51A
`1A41A !W1AyO1Ay !W1Ayш1Ay;1>iM1>j;1>i1>iC1@-(=1@.C1@-K1@.o1=.1=o1= 1=61?*#i1?+61?*%{11?+*y1A:@j1A:*y1A:!O1A:c1?+1?c1?㽗1?1?'1?'1?'b1?'O1=z1=O1=߅#1=1@[ϻ1@[1@[Rs1@\c1@8a1@8c1@8߭1@8
6 t`L8$p\H4
l
X
D
0
| h T @ , h1<0nF1AKKh1<0W a1< h1<0TI1>~h1<0E|1@Ձh1<0A/1A7h1<0@j1A:h1<0?2g1=jh1<0:o1A)Gh1<0+1?h1<0%{11?+h1<0.1@Zh1<051Ah1<01>0Yh1<051=h1<0Û1@h1<0M1>bh1<0b1?'h1<0߭1@8h1<0ϻ1@[h1<0 1<³h1<01>ih1<0h1<01Ayh1<0#1=h1<0K1@.h1<0 1=Q1<0#i1?+Q1<0z1=Q1<0y91=Q1<0q=1<³Q1<0f1=Q1<0a1@8Q1<0K 1A)GQ1<0=1@ՂQ1<051@Q1<0-1=jQ1<01A7Q1<0.1=Q1<0O1AyQ1<01AKKQ1<0ڪ+1@ZQ1<01?'Q1<041AQ1<0!O1A:Q1<0M1>jQ1<09 1< Q1<0H1>bQ1<0@1>0YQ1<01>Q1<0Rs1@\Q1<0(=1@.Q1<01?Q1<0Zy1>~
6 }cI2lV@
v
O
/
i = v d M 9 #
}
f
6
-¿Qué te gusta?P=1> 5¿Qué no te gusta? nF1AKK/U¿Qué haces en tu tiempo libre?
W a1< #video games41A swimminga1@8music(=1@.-los videojuegos 51A%los cómics E|1@Ձ /las hamburguesas :o1A)G'la natación ߭1@8#la música K1@.!hamburgersK 1A)G football1?#el fútbol +1?comics=1@Ղ!9What don’t you like?1AKK /What do you like?1>,OWhat do you do in your free time?9 1< -Voy de compras. TI1>~!9Salgo con mis amigos. M1>b /Odio el fútbol. @j1A:+MNo me interesan los cómics.
A/1A7#=No me gusta la música. 1Ay /Me interesan … Û1@-Me interesa … b1?''Me gustan ….1@Z'Me gusta … 1>i-Me encantan … ϻ1@[+Me encanta … %{11?+ 5Mando mensajes.
1>0Y&CJuego con el ordenador.
51=*KI’m not interested in comics.1A7";I’m interested in …51@";I’m interested in …1?'+In my free timeq=1<³-I send messages.@1>0Y!9I play on my computer.f1=!I love …#i1?+!I love …Rs1@\ 1I listen to music..1=!I like …ڪ+1@Z!I like …M1>j-I hate football.!O1A:)I go shopping.Zy1>~$?I go out with my friends.H1>b 7I don’t like music.O1Ay#I do sport.y91=)I chat online.-1=j)Hago deporte. b81=g8Q1>0>!ڻ1>O 1B&6A1Ay01@f(1@ 1A 21@8 -1@@&ٿ1AK..1=
1=_!1@$R1?1A),,@1? 71=jg1>1>~m1? l1@Z!zq1= d 1A 3
[ƣ1<S1A);1>b81=g8Q1>0>
!ڻ1>O 1B&5A1Ay/1@f'1@ 1A 11@8 -1@@%ٿ1AK.-1= 1=_!1@#R1?1A),+@1?71=jg1>1>~m1?
6
C ~qdWJ=0# zm`SF9,
w
j
]
P
C l1@Z" l1@Z! zq1= zq1= d 1A 4 d 1A 3 [ƣ1< [ƣ1< S1A* S1A) ;1>b ;1>b 81=g 81=g 8Q1>0> 8Q1>0>
!ڻ1>O !ڻ1>O 1B&6 1B&5 A1Ay0 A1Ay/ 1@f( 1@f' 1@ 1@ 1A 2 1A 1 1@8 1@8 -1@@& -1@@% ٿ1AK.. ٿ1AK.- 1=
1= 1= 1= _!1@$ _!1@# R1? R1? 1A),, 1A),+ @1? @1? 71=jg 71=jg 1> 1> 1>~ 1>~ m1? m1?
j xV4hF$
z
X
6
j !{1>AӕC T!ڻ1>O!z1A)GAӕC6ٿ1AK.!m
!1@AӕCz-1@@!f^1>bAӕC|
1>~!^t+1>0YAӕC{
;1>b!]c1< AӕCeZ 1=!U1@ՁAӕCRS1A!T%u1@ZAӕC _!1@!MA1<°AӕCb,[ƣ10>! 1>~AӕCa1>!
1AKKAӕCJA1Ay!
`1AAӕCӞ1A),! !W1AyAӕC1A !;1>iAӕC\֡m1? !C1@-AӕC$:K1@8!o1=AӕCoC1=!61?*AӕC*س@1?!*y1A:AӕCl6d 1A !c1?AӕCy1@!1?'AӕC
R1?!O1=AӕCk)Nߤ71=jg!1@[AӕC)> 1@f!c1@8AӕCO*l1@Z
X.\2
`
6
d : )AӕCЅ61A7AӕCЅ 1B&)AӕCl6ƻ*y1A:AӕCl6d 1A )AӕC !W1AyAӕC1A )AӕCJ
1AKKAӕCJA1Ay)AӕC6z1A)GAӕC6ٿ1AK.)AӕCӞ
`1AAӕCӞ1A),)AӕCRU1@ՁAӕCRS1A)AӕC)> 1@[AӕC)> 1@f)AӕCzm
!1@AӕCz-1@@)AӕC T%u1@ZAӕC _!1@)AӕCO*c1@8AӕCO*l1@Z)AӕC$:KC1@-AӕC$:K1@8)AӕCyc1?AӕCy1@)AӕC*61?*AӕC*س@1?)AӕC
1?'AӕC
R1?)AӕC\֡;1>iAӕC\֡m1? )AӕC T{1>AӕC T!ڻ1>O)AӕCa 1>~AӕCa1>)AӕC|
f^1>bAӕC|
1>~)AӕC{
^t+1>0YAӕC{
;1>b)AӕCwƤ91=AӕCwƤ8Q1>0>)AӕCt+1=AӕCtzq1=)AӕCoCo1=AӕCoC1=)AӕCm&-1=jAӕCm81=g)AӕCk)NߨO1=AӕCk)Nߤ71=jg)AӕCeZ]c1< AӕCeZ 1=)AӕCb,MA1<°AӕCb,[ƣ1<
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
$.
K w
-Xd fȓ)
1AKK%m1<0AӕCJAӕC¿Qué no te gusta? What don’t you like?AӕCJ@ @ AӕCJTӏf'
}q1@[%m1<0AӕC)> AӕC)Me encantan … I love …AӕC)> @ @ AӕC)> M'
smc1?%m1<0AӕCyAӕCԩ;el fútbol footballAӕCy@ @ AӕCyiဓ )
!W1Ay%m1<0AӕCAӕCGNo me gusta la música. I don’t like music.AӕC@ @ AӕCJӏ'
sgC1@-%m1<0AӕC$:KAӕC$la música musicAӕC$:K@ @ AӕC$:Kcӏ@(
m
!1@%m1<0AӕCzAӕC'Me interesan … I’m interested in …AӕCz@ @ AӕCzU.'
qz1A)G%m1<0AӕC6AӕC-las hamburguesas hamburgersAӕC6@ @ AӕC6^(
o1=%m1<0AӕCoCAӕCofEscucho música. I listen to music.AӕCoC@ @ AӕCoCペ)
% ]c1< %m1<0AӕCeZAӕCe[6¿Qué haces en tu tiempo libre?
What do you do in your free time?AӕCeZ@ @ AӕCeZQ䓏'
wqT%u1@Z%m1<0AӕC AӕC m
Me gustan …I like …AӕC @ @ AӕC bܔӏ(
} 1?'%m1<0AӕC
AӕCLMe interesa … I’m interested in …AӕC
@ @ AӕC
Uڱ,'
}s
`1A%m1<0AӕCӞAӕCwlos videojuegos video gamesAӕCӞ@ @ AӕCӞSГ'
{q61?*%m1<0AӕC*AӕCҿMe encanta … I love …AӕC*@ @ AӕC*Iҷg'
ioO1=%m1<0AӕCk)NAӕCk*Bailo. I dance.AӕCk)N@ @ AӕCk)N߁XŰ'
}y 1>~%m1<0AӕCaAӕCbVoy de compras. I go shopping.AӕCa@ @ AӕCakɡ)
f^1>b%m1<0AӕC|
AӕC|Salgo con mis amigos. I go out with my friends.AӕC|
@ @ AӕC|
Qɛ '
wq;1>i%m1<0AӕC\֡AӕC]{Me gusta … I like …AӕC\֡@ @ AӕC\֡
3 I
r O۔ڼ'
wmc1@8%m1<0AӕCO*AӕCP;la natación swimmingAӕCO*@ @ AӕCO*S'
ys+1=%m1<0AӕCtAӕCtv)Hago deporte. I do sport.AӕCt@ @ AӕCt[ӏ '
}*y1A:%m1<0AӕCl6AӕClOdio el fútbol. I hate football.AӕCl6@ @ AӕCl6Ɓ\Գ(
{MA1<°%m1<0AӕCb,AӕCb!En mi tiempo libreIn my free timeAӕCb,@ @ AӕCb,Lճ'
uiU1@Ձ%m1<0AӕCRAӕCSplos cómics comicsAӕCR@ @ AӕCR_(
}^t+1>0Y%m1<0AӕC{
AӕC{
@Mando mensajes.
I send messages.AӕC{
@ @ AӕC{
^ӏg(
y&-1=j%m1<0AӕCmAӕCmzChateo por internet. I chat online.AӕCm@ @ AӕCmm>)
91=%m1<0AӕCwƤAӕCwhbJuego con el ordenador.
I play on my computer.AӕCwƤ@ @ AӕCwƤ[׳O'
}{1>%m1<0AӕC TAӕC /o¿Qué te gusta?What do you like?AӕC T@ @ AӕC T{)
61A7%m1<0AӕCЅAӕCtNo me interesan los cómics.
I’m not interested in comics.AӕCЅ@ @ AӕCЅ
; \
=
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