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
u '
mediaLocation pageSize4096d =hexCache{"-1495565396936515618": "eb3eaf32013b9fde", "7588898738911551453": "69512f32013b9fdd", "-8930957804190326819": "840edd32013b9fdd", "-3739769784297087010": "cc19ab32013b9fde", "248541519692931037": "372ff32013b9fdd"}(
EcssCache.fm840edd32013b9fdd {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm69512f32013b9fdd {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqcc19ab32013b9fde {text-align:center;}
#cmqeb3eaf32013b9fde {text-align:center;}
#cmacc19ab32013b9fde {text-align:center;}
#cmaeb3eaf32013b9fde {text-align:center;}
.cmbcc19ab32013b9fde {background:#FFFFFF;}
.cmbeb3eaf32013b9fde {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ӕ9V"Aӕ9V"BasicBasic?<
" !2011-08-25" !2011-08-25
#ԥ
r2;BackArial1$Ӑ
r2;FrontArial1
" " e
r2;Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe憵
r2;Reverse%(Back)s%(Front)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)
)
_$b
v
6 B L
r
2 0 -Ђ
' r2;Aӕr۩?Aӕr largo/a longFӐ
Y r2;Aӕ=?Aӕ=¿Qué prefieres? What do you prefer?k
! r2;Aӕ]=Aӕ]=Estas botas son las menos prácticas. These boots are the least practical.3Ӑ
3 r2;Aӕ`Aӕ`ade cuadros checked6̗|
9 r2;Aӕm[Aӕmщsin mangas sleeveless\
r2;Aӕ@AӕA ~N¿Qué vestido es el más …? Which dress is the most …?j
r2;AӕTTHAӕTUvEsta camiseta es la menos cómoda. This T-shirt is the least comfortable.Y̒ӐƑ
r2;AӕPΒAӕPEoEste vestido es el más bonito. This dress is the nicest.3S
3 r2;AӕaAӕau!de lunares spottedLӐi
e r2;Aӕy Aӕyv`¿Cuál prefieres? Which one do you prefer?6숳
9 r2;AӕvHAӕvde tacón high-heeledcӐ
r2;AӕZYAӕZZ Estos zapatos son los más baratos. These shoes are the cheapest.=ωӐ
G r2;AӕgAӕgo~de manga corta short-sleeved6Ӑ
9 r2;AӕeኜAӕeestampado/a patterned1ӐX
/ r2;AӕcDAӕcde rayas striped<
E r2;Aӕk(Aӕk)cde manga larga long-sleeveda鉶
r2;AӕDm9uAӕDm¿Qué camiseta es la menos …? Which T-shirt is the least …?_儆ӐF
r2;AӕHNZAӕHN¿Qué zapatos son los más …? Which shoes are the most …?Oߖӓ
k r2;Aӕ|iAӕ|F¿Cuáles prefieres? Which ones do you prefer?1٧𓐄
/ r2;Aӕt,Aӕt/de cuero leather.טR
) r2;AӕoUqiAӕoUBcorto/a short_糐
r2;AӕL0lAӕL0ߨ¿Qué botas son las menos …? Which boots are the least …?
Y Y $%
M -%#
Aӕ9FxAӕ|Ar2;4eef171030d3c8de41d0a18fc259470fAӕ? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 ` n
=* Ӑű)
))JI 2=>2;AӕTTHAӕTU+Esta camiseta es la menos cómoda.
This T-shirt is the least comfortable.AӕTTH@ @ AӕTTHJ쓐'
ok2?">2;Aӕt,Aӕtode cuero leatherAӕt,@ @ Aӕt,ÁO6'
sqc02>|>2;Aӕm[Aӕm sin mangas sleevelessAӕm[@ @ Aӕm[Ua'
{u2>x>2;Aӕk(Aӕk)de manga larga long-sleevedAӕk(@ @ Aӕk( )
/%k2=>2;Aӕ]=Aӕ]=Estas botas son las menos prácticas.
These boots are the least practical.Aӕ]=@ @ Aӕ]=x)
#;02<Ƒ>2;AӕPΒAӕPtGEste vestido es el más bonito.
This dress is the nicest.AӕPΒ@ @ AӕPΒG境Ӑ'
mga[2>R>2;AӕoUqiAӕoVcorto/a shortAӕoUqi@ @ AӕoUqijމӐ
)
Z2?>2;Aӕ|iAӕ|u¿Cuáles prefieres? Which ones do you prefer?Aӕ|i@ @ Aӕ|iVӐ'
{wX>2;AӕgAӕgde manga corta short-sleevedAӕg@ @ Aӕgڲ)
- 2=E>2;AӕZYAӕZZ8aEstos zapatos son los más baratos.
These shoes are the cheapest.AӕZY@ @ AӕZYLѦœ='
sk1~w2=S>2;AӕaAӕaߣde lunares spottedAӕa@ @ Aӕag⬓)
.e2?\i>2;Aӕy Aӕyj¿Cuál prefieres? Which one do you prefer?Aӕy @ @ Aӕy aړ)
l-U2; >2;Aӕ=?Aӕ=h¿Qué prefieres? What do you prefer?Aӕ=?@ @ Aӕ=?LӐ8'
skew2=>2;Aӕ`Aӕ`de cuadros checkedAӕ`@ @ Aӕ`鼁}ī˓)
%522;AӕHNZAӕHO)9¿Qué zapatos son los más …?
Which shoes are the most …?AӕHNZ@ @ AӕHNZJҳ'
okh2>X>2;AӕcDAӕcde rayas stripedAӕcD@ @ 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)
, U"^2
l
(
T * S *
k
% Z / a#O 3ԓ G 2=EiQ/2;These shoes are the cheapest.3ȶӐG G52|2;sin mangas ӐX h2>X2;de rayas 9Ӑ So;2<2;¿Qué botas son las menos …?
4 Io;2!Ӑ #ew2=2;de cuadros R a[2>R2;corto/a ! #'C2?>iQ/2;high-heeled.i =.e2?\iiQ/2;Which one do you prefer?5۔ K%2<iQ/2;Which T-shirt is the least …?!S #1~w2=S2;de lunares 䳐 2>8 iQ/2;patterned<Ӑ YJI 2=2;Esta camiseta es la menos cómoda.
q@2>봄2;largo/a ֚ !'C2?>2;de tacón Y h2>XiQ/2;striped<Ӑ YJI 2=iQ/2;This T-shirt is the least comfortable. Ӑ 2?"ń2;de cuero :땓 U%2<2;¿Qué camiseta es la menos …?
)i 3.e2?\i2;¿Cuál prefieres? /ӐƑ ?;02<ƑiQ/2;This dress is the nicest. ϳS 1~w2=SiQ/2;spotted | !c02>|iQ/2;sleeveless? _k2=Ԅ2;Estas botas son las menos prácticas.
% +2>x2;de manga larga + 7Z2?2;¿Cuáles prefieres? ف 2?"iQ/2;leather:铐 Uk2=iQ/2;These boots are the least practical.(렱Ӑ 1l-U2; 2;¿Qué prefieres? 譪 ew2=iQ/2;checked>Ӑ ] 2=Ē2;Estos zapatos son los más baratos.
аR a[2>RiQ/2;short"ⰡӐ %2>xiQ/2;long-sleeved% +X2;de manga corta #߯Ӑ 'XiQ/2;short-sleevedӐ q@2>iQ/2;long:՜F U52)Ӑ 3l-U2; iQ/2;What do you prefer?"ͩӐ %2>8 2;estampado/a 9ݓƑ S;02<Ƒ2;Este vestido es el más bonito.
2ʎ EN_2;iQ/2;Which dress is the most …?
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
,
* |l[K:* tdSC2"
}
l
\
K
;
* , '2?
+ '2?
* a2?) a2?( rp2?\N' rp2?\N& a2?=% a2?=$ Na2?"# Na2?"" ʈ 2>! ʈ 2> S2>6 S2>6 2>a 2>a 2>x 2>x W2>W W2>W 2>8 2>8 )2>= )2>= 2=8 2=8 㸷2= 㸷2= 2= 2= ,2=E
,2=E ѿ2= ѿ2=
Dz2rp2?\N Aӕt,ò2?" a2?= Aӕr۩?q@2>Na2?" AӕoUqia[2>Rʈ 2> Aӕm[c02>|S2>6 Aӕk(2>x2>a AӕgX2>x Aӕeኜ2>8 W2>W AӕcDh2>X2>8 Aӕa1~w2=S)2>= Aӕ`ew2=2=8 Aӕ]=k2=㸷2= AӕZY 2=E̴2= AӕTTHJI 2=,2=E AӕPΒ;02<Ƒѿ2= AӕL0lo;2W Na2?" Dz26 2>a 㸷2= ѿ2= ʈ 2> '2?
2>x 2= )2>= a2? 2; 2=8 Y2< 2>8
H t`L8$p\H Aӕ|u'2?
Aӕyja2?Aӕvgrp2?\NAӕto a2?=AӕrNHNa2?"AӕoVʈ 2>Aӕm S2>6Aӕk)2>aAӕg2>xAӕe=W2>WAӕc2>8Aӕaߣۢ)2>=Aӕ`2=8Aӕ]=㸷2=AӕZZ8a2=AӕTU+,2=EAӕPtGѿ2=AӕL1(Dz2|u2<Aӕ=h2;
H t`L8$p\H Aӕ|FZ2?Aӕyv`.e2?\iAӕv'C2?>Aӕt/2?"Aӕr q@2>AӕoUBa[2>RAӕmщc02>|Aӕk)c2>xAӕgo~XAӕe2>8 Aӕch2>XAӕau!1~w2=SAӕ`aew2=Aӕ]=k2=AӕZZ 2=EAӕTUvJI 2=AӕPEo;02<ƑAӕL0ߨo;2<AӕHN52W Na2?" Dz26 2>a 㸷2= ѿ2= ʈ 2> '2?
2>x 2= )2>= a2? 2; 2=8 Y2< 2>8
|fP:$t^H2 @ |u2<@ u2W@ Na2?"@ Dz26@ 2>a@ 㸷2=@ ѿ2=@ ʈ 2>@ '2?
@ 2>x@ 2=@ )2>=@ a2?@ 2;@ 2=8@ Y2<@ 2>8
H t`L8$p\H q@2>Na2?"l-U2; 2;k2=㸷2=ew2=2=8c02>|S2>6N_2;|u2<JI 2=,2=E;02<Ƒѿ2=1~w2=S)2>=.e2?\ia2?'C2?>rp2?\N 2=E̴2=X2>x2>8 W2>Wh2>X2>82>x2>a%2<u2Rʈ 2>o;2 no2>q@2>봮2>l-U2; ց2; l-U2; E2; k2=2=k2=I2=ew2=J2=ew2=еW2=c02>|p2>|c02>|t2>|N_2;Yu2;N_2;ἅ(s2;JI 2=! ]2=JI 2=
2=;02<ƑU2<Ƒ;02<Ƒ62<Ƒ1~w2=S+'2=S1~w2=S{2=S.e2?\iDDF2?>'C2?>X2?> 2=Ew2=E 2=E&M2=EXć2>XX2>X2>8 &/#2>8 2>8 5M2>8 h2>Xn2>Xh2>X
_2>Y2>xؙ2>x2>x
2>x%2<7l2<%2<2<52RI֏2>Ra[2>RA2>Ro;2iQ/2;D8 iQ/2;
_2>YiQ/2;
2=iQ/2;U2<ƑiQ/2;{2=SiQ/2;t2>|iQ/2;d 2?"iQ/2;I2=iQ/2;еW2=iQ/2;A2>RiQ/2;
2>xiQ/2;ݾ2>XiQ/2;ݮ2>iQ/2;ݝE2; iQ/2;݅(s2;2;p2>|2;n2>X2;jM2<2;Yu2;2;J2=2;I֏2>R2;+'2=S2;! ]2=2; no2>2;X2?>2; 2?"2;2<2;q2?\i2;2=2;ؙ2>x2;ߋ2?2;ց2; 2;&M2=E2;ć2>X2;ݧT28 2;ݕ62<Ƒ
,
j6g<
x
e
Q
:
%
~ j W G / ~ ] .
/U¿Qué zapatos son los más …?
T2Yu2; 1¿Qué prefieres? ց2; /U¿Qué camiseta es la menos …?
2<.S¿Qué botas son las menos …?
jM2< 7¿Cuáles prefieres? ߋ2? 3¿Cuál prefieres? q2?\istriped
_2>Yspotted{2=S!sleevelesst2>|#sin mangas p2>|'short-sleeved2>XshortA2>R patterned&/#2>8 %long-sleeved
2>xlong2>leatherd 2?" largo/a no2>#high-heeledDF2?>%estampado/a 5M2>8 !de tacón X2?> de rayas n2>X+de manga larga ؙ2>x+de manga corta ć2>X#de lunares +'2=S de cuero 2?"#de cuadros J2= corto/a I֏2>RcheckedеW2=(GWhich shoes are the most …?u!2 &M2=E.SEste vestido es el más bonito.
62<Ƒ4_Estas botas son las menos prácticas.
2=1YEsta camiseta es la menos cómoda.
! ]2=
,
m zk\M>/ {l]N?0!
|
m |u2<u2WNa2?"$Dz26 2>a 㸷2=ѿ2= ʈ 2>"'2?
,2>x 2=)2>=a2?*2;2=8Y2<2>8|u2<u2WNa2?"#Dz26 2>a 㸷2=ѿ2= ʈ 2>!'2?
+2>x2=)2>=a2?)
2;2=8Y2<2>8
,
reXK>1$
{naTG:-
|u2< |u2< u2W W2>W Na2?"$ Na2?"# Dz26 S2>6 2>a 2>a 㸷2= 㸷2= ѿ2= ѿ2= ʈ 2>" ʈ 2>! '2?
, '2?
+ 2>x 2>x 2= 2= )2>= )2>= a2?* a2?) 2; 2; 2=8 2=8 Y2< Y2< 2>8 2>8
xV4hF$
z
X
6
!q@2>Aӕr۩?Na2?"!l-U2; Aӕ=?2;!k2=Aӕ]=㸷2=!ew2=Aӕ`鼍2=8!c02>|Aӕm[S2>6!N_2;Aӕ@|u2<!JI 2=AӕTTH,2=E!;02<ƑAӕPΒѿ2=!1~w2=SAӕa)2>=!.e2?\iAӕy a2?!'C2?>AӕvHrp2?\N! 2=EAӕZY2=!XAӕg»2>x!2>8 AӕeኜW2>W!h2>XAӕcD2>8!2>xAӕk(2>a!%2<AӕDm9uu2RAӕoUqiʈ 2>!o;2AӕvHrp2?\N)Aӕt,ò2?"Aӕt, a2?=)Aӕr۩?q@2>Aӕr۩?Na2?")AӕoUqia[2>RAӕoUqiʈ 2>)Aӕm[c02>|Aӕm[S2>6)Aӕk(2>xAӕk(2>a)AӕgXAӕg»2>x)Aӕeኜ2>8 AӕeኜW2>W)AӕcDh2>XAӕcD2>8)Aӕa1~w2=SAӕa)2>=)Aӕ`ew2=Aӕ`鼍2=8)Aӕ]=k2=Aӕ]=㸷2=)AӕZY 2=EAӕZY2=)AӕTTHJI 2=AӕTTH,2=E)AӕPΒ;02<ƑAӕPΒѿ2=)AӕL0lo;22;AӕTTHAӕTU+Esta camiseta es la menos cómoda.
This T-shirt is the least comfortable.AӕTTH@ @ AӕTTHJ쓐'
ok2?">2;Aӕt,Aӕtode cuero leatherAӕt,@ @ Aӕt,ÁO6'
sqc02>|>2;Aӕm[Aӕm sin mangas sleevelessAӕm[@ @ Aӕm[Ua'
{u2>x>2;Aӕk(Aӕk)de manga larga long-sleevedAӕk(@ @ Aӕk( )
/%k2=>2;Aӕ]=Aӕ]=Estas botas son las menos prácticas.
These boots are the least practical.Aӕ]=@ @ Aӕ]=x)
#;02<Ƒ>2;AӕPΒAӕPtGEste vestido es el más bonito.
This dress is the nicest.AӕPΒ@ @ AӕPΒG境Ӑ'
mga[2>R>2;AӕoUqiAӕoVcorto/a shortAӕoUqi@ @ AӕoUqijމӐ
)
Z2?>2;Aӕ|iAӕ|u¿Cuáles prefieres? Which ones do you prefer?Aӕ|i@ @ Aӕ|iVӐ'
{wX>2;AӕgAӕgde manga corta short-sleevedAӕg@ @ Aӕgڲ)
- 2=E>2;AӕZYAӕZZ8aEstos zapatos son los más baratos.
These shoes are the cheapest.AӕZY@ @ AӕZYLѦœ='
sk1~w2=S>2;AӕaAӕaߣde lunares spottedAӕa@ @ Aӕag⬓)
.e2?\i>2;Aӕy Aӕyj¿Cuál prefieres? Which one do you prefer?Aӕy @ @ Aӕy aړ)
l-U2; >2;Aӕ=?Aӕ=h¿Qué prefieres? What do you prefer?Aӕ=?@ @ Aӕ=?LӐ8'
skew2=>2;Aӕ`Aӕ`de cuadros checkedAӕ`@ @ Aӕ`鼁}ī˓)
%522;AӕHNZAӕHO)9¿Qué zapatos son los más …?
Which shoes are the most …?AӕHNZ@ @ AӕHNZJҳ'
okh2>X>2;AӕcDAӕcde rayas stripedAӕcD@ @ AӕcD
d '
M s i
d zӐ)
!N_2;>2;Aӕ@AӕA >¿Qué vestido es el más …?
Which dress is the most …?Aӕ@@ @ Aӕ@,)
%%2<>2;AӕDm9uAӕDm¿Qué camiseta es la menos …?
Which T-shirt is the least …?AӕDm9u@ @ AӕDm9uON'
qs'C2?>>2;AӕvHAӕvgde tacón high-heeledAӕvH@ @ AӕvHOơ'
uo2>8 >2;AӕeኜAӕe=estampado/a patternedAӕeኜ@ @ AӕeኜF'
meq@2>>2;Aӕr۩?AӕrNHlargo/a longAӕr۩?@ @ Aӕr۩?}߳v)
#o;2<>2;AӕL0lAӕL1(¿Qué botas son las menos …?
Which boots are the least …?AӕL0l@ @ AӕL0l
; \
=
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