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{"928400345470272187": "ce25732011b02bb", "-1876130560567737669": "e5f6a532011b02bb", "-5198669981753343301": "b7da9d32011b02bb", "-3427209414848085317": "d0701b32011b02bb", "6968358565448450747": "60b49532011b02bb"}'
CcssCache.fmd0701b32011b02bb {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fmce25732011b02bb {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqe5f6a532011b02bb {text-align:center;}
#cmq60b49532011b02bb {text-align:center;}
#cmae5f6a532011b02bb {text-align:center;}
#cma60b49532011b02bb {text-align:center;}
.cmbe5f6a532011b02bb {background:#FFFFFF;}
.cmb60b49532011b02bb {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ӕ"Aӕ"BasicBasic?<
" !2011-08-25" !2011-08-25
#
ڝ2BackArial1$蜃
ڝ2FrontArial1
" " eӐ
ڝ2Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeӐ
ڝ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)
)
T
G A
f
& R |< ]ţ
ڝ2Aӕ&CAӕ' %Estos zapatos son incómodos. These shoes are uncomfortable.:
A ڝ2Aӕ;Aӕ;+estos zapatos these shoes6Ӑ
9 ڝ2AӕKNtAӕKN)cómodo/a comfortableMӐ
g ڝ2Aӕ'AӕNo llevo uniforme. I don’t wear a uniform.+
# ڝ2AӕMAӕMe8feo/a ugly@
M ڝ2Aӕ9tc9Aӕ9testos pantalones these trousersCⳐ
S ڝ2Aӕ XAӕ YkfTambién llevo … I also wear …;}
C ڝ2Aӕ,[Aӕ,\$5esta camiseta this T-shirt8泐l
= ڝ2Aӕ*CAӕ*Deste vestido this dress6ҳd
9 ڝ2AӕFAӕF.bonito/a nice, pretty:ڳ>
A ڝ2AӕRYO AӕRYȬincómodo/a uncomfortable/
+ ڝ2AӕE#GAӕE#^barato/a cheapT
u ڝ2AӕlAӕ$Tengo que llevar uniforme. I have to wear a uniform.UӐ
w ڝ2AӕWfAӕWEsta chaqueta es cómoda. This jacket is comfortable.bӐq
ڝ2Aӕ&|Aӕ&Me gusta porque es práctico. I like it because it’s practical.1燳~
/ ڝ2AӕIvAӕIwcaro/a expensiveB
Q ڝ2Aӕ&/?Aӕ&/El uniforme escolar School uniform1t
/ ڝ2AӕPAӕPnguay great, cool:4
A ڝ2Aӕ.yAӕ.`esta chaqueta this jacketj糐
ڝ2Aӕ Aӕ APara ir al colegio, normalmente llevo … For school, I normally wear …8ܘ
= ڝ2Aӕ(%Aӕ(&ceste jersey this jumper6֙Ӑ
9 ڝ2Aӕ0yyAӕ0esta corbata this tievӕ۳*
7 ڝ2Aӕ/!Aӕ/Es más elegante que llevar vaqueros. It’s more elegant/stylish than wearing jeans.q˖
- ڝ2Aӕ+4SAӕ+4y%No me gusta porque es incómodo. I don’t like it because it’s uncomfortable.GɫӐ
[ ڝ2AӕC\
EAӕC\Zanticuado/a old-fashioned, out of date7°5
; ڝ2Aӕ?y%Aӕ?z&gestas botas these bootsaг
ڝ2Aӕ#Aӕ#B(No) Me gusta llevar uniforme. I (don’t) like wearing uniform.
Y Y $%
M -%#
Aӕ"jAӕ/T.Aڝ2b84deba6fcac43bd99ff40a773735f9cAӕ3? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 }
@72 ن)
/9V2:*2Aӕ/!Aӕ/nEs más elegante que llevar vaqueros.
It’s more elegant/stylish than wearing jeans.Aӕ/!@ @ Aӕ/!zӐ)
q2 :2Aӕ&CAӕ'NEstos zapatos son incómodos.
These shoes are uncomfortable.Aӕ&C@ @ Aӕ&C~ӐU)
!
2:2Aӕ#Aӕ#p(No) Me gusta llevar uniforme.
I (don’t) like wearing uniform.Aӕ#@ @ Aӕ#́Rس'
yqY;2 a2Aӕ;Aӕ;[-estos zapatos these shoesAӕ;@ @ Aӕ;[(
w2 2Aӕ&/?Aӕ&0El uniforme escolarSchool uniformAӕ&/?@ @ Aӕ&/?݁Pb'
wo)32Sl2Aӕ*CAӕ*DEeste vestido this dressAӕ*C@ @ Aӕ*CN㎳'
qqL2 [2AӕKNtAӕKOcómodo/a comfortableAӕKNt@ @ AӕKNtgٓ)
J.292Aӕ'AӕNo llevo uniforme. I don’t wear a uniform.Aӕ'@ @ Aӕ'N'
wkg%22Aӕ0yyAӕ0 esta corbata this tieAӕ0yy@ @ Aӕ0yys)
2 2AӕWfAӕW/Esta chaqueta es cómoda.
This jacket is comfortable.AӕWf@ @ AӕWfrh)
g29Z2AӕlAӕ .Tengo que llevar uniforme.
I have to wear a uniform.Aӕl@ @ Aӕlܢ)
!2:Qq2Aӕ&|Aӕ&@Me gusta porque es práctico.
I like it because it’s practical.Aӕ&|@ @ Aӕ&|\נƳo(
y6292Aӕ XAӕ YgTambién llevo … I also wear …Aӕ X@ @ Aӕ XPԡӐR'
uqa242Aӕ(%Aӕ(&este jersey this jumperAӕ(%@ @ Aӕ(%āNҸb'
os ^2 d2AӕFAӕFbbonito/a nice, prettyAӕF@ @ AӕFSɶ'
ys3[2t}2Aӕ,[Aӕ,\S3esta camiseta this T-shirtAӕ,[@ @ 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@ O tF
t
H
" p / b 7
v
N
" z K wL
T(}Pn@ $ )2 W2School uniform"} %3[2t} W2this T-shirt$՝ ):}2 W2these trousers/ ?J.29 W2I don’t wear a uniform.Eи kY2: W2I don’t like it because it’s uncomfortable.#Ф? '2 > W2uncomfortableEⓐ+ kV2:* W2It’s more elegant/stylish than wearing jeans. ڡ~ ;2 4~ W2expensive)Ӑ 3629p2También llevo … "Ӑd % ^2 d W2nice, pretty1گӐ C 2 W2This jacket is comfortable.4 I
g29Zp2Tengo que llevar uniforme.
3 G 2 p2Esta chaqueta es cómoda.
8 Q
2:p2(No) Me gusta llevar uniforme.
!Ӑt #B 2 t W2great, cool! #a24 W2this jumper!ų #Y;2 a W2these shoes0 AE2 W2old-fashioned, out of date:Ӑ UY2:p2No me gusta porque es incómodo.
% +629 W2I also wear …"Ӑ? %2 >p2incómodo/a ?Ӑ* _V2:*p2Es más elegante que llevar vaqueros.
) 3J.29p2No llevo uniforme. " %E2 p2anticuado/a ޓ g%2 W2this tie) 32 p2El uniforme escolar4ۓ Iq2 : W2These shoes are uncomfortable.!5 #2 5 W2these bootst B 2 tp2guay !Ӑ #L2 [ W2comfortable
2 p2barato/a Cݓ g;29p2Para ir al colegio, normalmente llevo …
ƍӐ !L2 [p2cómodo/a #Ӑl ')32Slp2este vestido 7Ӑ O
2: W2I (don’t) like wearing uniform.!Գ5 #2 5p2estas botas d ^2 dp2bonito/a Ӑ
2 W2cheap/ ?
g29Z W2I have to wear a uniform. ij J 2 xp2feo/a "喹Ӑ %a24p2este jersey 7Ӑq O2:Qqp2Me gusta porque es práctico.
!㲁Ӑ4 #'24 W2this jacket5 K;29 W2For school, I normally wear … Ӑ~ ;2 4~p2caro/a $Ӑ4 )'24p2esta chaqueta ړӐ J 2 x W2ugly$ )Y;2 ap2estos zapatos $ςӐ} )3[2t}p2esta camiseta ͳᓐm !)32Sl W2this dress'ʈܳ /:}2p2estos pantalones 9ɥq S2:Qq W2I like it because it’s practical.7Ƙ Oq2 :p2Estos zapatos son incómodos.
#õ 'g%2p2esta corbata
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
6 |l[K:* tdSC2"
}
l
\
K
;
*
6 d12:5 d12:4 0[2:3 0[2:2 2:1 2:0 2:QU/ 2:QU. 32:o- 32:o, o29+ o29* Ҧ29) Ҧ29( 29h' 29h& "E29Z% "E29Z$ 2 :# 2 :" a2 ! a2 a2 AӕPB 2 tAӕPnB 2 tAӕMe8J 2 xAӕKN)L2 [AӕIw;2 4~AӕF. ^2 dAӕE#^
2 AӕC\ZE2 Aӕ?z&g2 5Aӕ;+Y;2 aAӕ9t:}2Aӕ0g%2Aӕ.`'24Aӕ,\$53[2t}Aӕ*D)32SlAӕ(&cǸa24Aӕ&/2
~qdWJ=0# q2 H i2 a a2 UW2 Y <2 [ a2
2 q2 H
g29Z29h 2 2 :2:Qq2:;2 4~<2 [2 Q24B 2 tgA!2 ?2 >6
2 ?
2
2
2 2
g29ZOO29Z
g29Z"29Z 2 Qi}2 2 N2 2:Qq"M2:Qq2:Qqy2:Qq;2 4~Wi 2 4~;2 4~2 4~2 r2 2 "2 B 2 tG 2 tB 2 tw2 t'24
24'2424;29.29;2929a24E124a24Y24g%2%:2g%2a2V2:*\2:+V2:*.|2:*Y2:gA2:Y2:@2:E2 @W2 E2 *12 2 52 52 5&2 5
2:Hw2:
2:]2:
6 t`L8$p\H4
l
X
D
0
| h T @ , W2r2 W2q2t} W2qT2 W2o29 W2gA2: W2gA!2 ? W2\2:+ W2Wi 2 4~ W2R"2 d W2Qi}2 W2G 2 t W2E124 W2D +2 a W2@W2 W2;cs29 W2%:2 W2V2 : W22 5 W2ٕ2 [ W2]2: W22 W2"29Z W2
24 W229 W2O2 x W2 2Sm W2y2:Qqp2TM29p2OO29Zp2N2 p2Hw2:p2@2:p26
2 ?p2.|2:*p2*29p2*12 p2"2 p2w2 tp2
2 p2.29p2m2 [p2ߕ2Slp2&2 5p2ݟ2 dp2#2 xp2Y24p2"M2:Qqp22 4~p224p2w2 ap2
2t}p2"2p2`2 :p2a2
6 x ~U(zU0
z
J
] E 0 } f N 5
Y
B
+
x 'uncomfortablegA!2 ?uglyO2 x this tie%:2#this jumperE124#this jacket
24!this dress 2Sm%this T-shirtq2t})these trousersqT2#these shoesD +2 a#these boots2 5%Aold-fashioned, out of date@W2 %nice, prettyR"2 d%incómodo/a 6
2 ?guay w2 t#great, coolG 2 tfeo/a #2 x expensiveWi 2 4~)estos zapatos w2 a /estos pantalones "2'este vestido ߕ2Sl%este jersey Y24#estas botas&2 5'esta corbata a2)esta chaqueta 24)esta camiseta
2t}!cómodo/a m2 [#comfortableٕ2 [cheap2 caro/a 2 4~ bonito/a ݟ2 d barato/a
2 %anticuado/a *12 &CThis jacket is comfortable.Qi}2 )IThese shoes are uncomfortable.V2 :)ITengo que llevar uniforme.
OO29Z 3También llevo … TM29)School uniformr2 8gPara ir al colegio, normalmente llevo …
.29/UNo me gusta porque es incómodo.
@2: 3No llevo uniforme. *29,OMe gusta porque es práctico.
"M2:Qq:kIt’s more elegant/stylish than wearing jeans.\2:+.SI like it because it’s practical.y2:Qq$?I have to wear a uniform."29Z$?I don’t wear a uniform.o29:kI don’t like it because it’s uncomfortable.gA2:+I also wear …;cs29,OI (don’t) like wearing uniform.]2:*KFor school, I normally wear …29,OEstos zapatos son incómodos.
`2 :(GEsta chaqueta es cómoda.
N2 4_Es más elegante que llevar vaqueros.
.|2:* 3El uniforme escolar"2 -Q(No) Me gusta llevar uniforme.
Hw2:
6 yj[M>/ {l]N?0!
|
m
^
O
@
1
"
q2 Hi2 aa2 "UW2 Y <2 [AӕRYO a2 !
2 AӕE#Gq2 H!
g29ZAӕl29h! 2 AӕWf2 :!2:QqAӕ&|2:!;2 4~AӕIv<2 [!2 Aӕ&/?Q24!B 2 tAӕPAӕRYO a2 )AӕPB 2 tAӕPEs más elegante que llevar vaqueros.
It’s more elegant/stylish than wearing jeans.Aӕ/!@ @ Aӕ/!zӐ)
q2 :2Aӕ&CAӕ'NEstos zapatos son incómodos.
These shoes are uncomfortable.Aӕ&C@ @ Aӕ&C~ӐU)
!
2:2Aӕ#Aӕ#p(No) Me gusta llevar uniforme.
I (don’t) like wearing uniform.Aӕ#@ @ Aӕ#́Rس'
yqY;2 a2Aӕ;Aӕ;[-estos zapatos these shoesAӕ;@ @ Aӕ;[(
w2 2Aӕ&/?Aӕ&0El uniforme escolarSchool uniformAӕ&/?@ @ Aӕ&/?݁Pb'
wo)32Sl2Aӕ*CAӕ*DEeste vestido this dressAӕ*C@ @ Aӕ*CN㎳'
qqL2 [2AӕKNtAӕKOcómodo/a comfortableAӕKNt@ @ AӕKNtgٓ)
J.292Aӕ'AӕNo llevo uniforme. I don’t wear a uniform.Aӕ'@ @ Aӕ'N'
wkg%22Aӕ0yyAӕ0 esta corbata this tieAӕ0yy@ @ Aӕ0yys)
2 2AӕWfAӕW/Esta chaqueta es cómoda.
This jacket is comfortable.AӕWf@ @ AӕWfrh)
g29Z2AӕlAӕ .Tengo que llevar uniforme.
I have to wear a uniform.Aӕl@ @ Aӕlܢ)
!2:Qq2Aӕ&|Aӕ&@Me gusta porque es práctico.
I like it because it’s practical.Aӕ&|@ @ Aӕ&|\נƳo(
y6292Aӕ XAӕ YgTambién llevo … I also wear …Aӕ X@ @ Aӕ XPԡӐR'
uqa242Aӕ(%Aӕ(&este jersey this jumperAӕ(%@ @ Aӕ(%āNҸb'
os ^2 d2AӕFAӕFbbonito/a nice, prettyAӕF@ @ AӕFSɶ'
ys3[2t}2Aӕ,[Aӕ,\S3esta camiseta this T-shirtAӕ,[@ @ Aӕ,[
+
) 3
_ + GسH'
oe
2 2AӕE#GAӕE#barato/a cheapAӕE#G@ @ AӕE#GX'
w:}22Aӕ9tc9Aӕ9u5estos pantalones these trousersAӕ9tc9@ @ Aӕ9tc9R'
uu2 >2AӕRYO AӕRYincómodo/a uncomfortableAӕRYO @ @ AӕRYO CY'
icJ 2 x2AӕMAӕMufeo/a uglyAӕM@ @ AӕMI'
km;2 4~2AӕIvAӕIw2caro/a expensiveAӕIv@ @ AӕIvIӐ"'
gqB 2 t2AӕPAӕPguay great, coolAӕP@ @ AӕPRɰ'
yq'242Aӕ.yAӕ.~esta chaqueta this jacketAӕ.y@ @ Aӕ.y˳)
%9Y2:2Aӕ+4SAӕ+4No me gusta porque es incómodo.
I don’t like it because it’s uncomfortable.Aӕ+4S@ @ Aӕ+4S`(
uE2 2AӕC\
EAӕC\ anticuado/a old-fashioned, out of dateAӕC\
E@ @ AӕC\
EO'
sq2 52Aӕ?y%Aӕ?zW estas botasthese bootsAӕ?y%@ @ Aӕ?y%)
7;292Aӕ Aӕ pPara ir al colegio, normalmente llevo …
For school, I normally wear …Aӕ @ @ Aӕ
; \
=
m x
E`
2##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc1##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, dueO +iindexix_fields_valuefields$CREATE INDEX ix_fields_value on fields (value)a!7indexix_media_originalPathmedia%CREATE INDEX ix_media_originalPath on media (originalPath)k"9%indexix_cardsDeleted_cardIdcardsDeleted&CREATE INDEX ix_cardsDeleted_cardId on cardsDeleted (cardId)r#='
indexix_modelsDeleted_modelIdmodelsDeleted'CREATE INDEX ix_modelsDeleted_modelId on modelsDeleted (modelId)k$9%indexix_factsDeleted_factIdfactsDeleted(CREATE INDEX ix_factsDeleted_factId on factsDeleted (factId)l%9%indexix_mediaDeleted_factIdmediaDeleted)CREATE INDEX ix_mediaDeleted_factId on mediaDeleted (mediaId)d&3 indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z'1 uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)(9Yindexix_cards_intervalDesc2cards,CREATE INDEX ix_cards_intervalDesc2 on cards (type, priority desc, interval desc, factId, combinedDue)x)-9indexix_cards_dueAsc2cards-CREATE INDEX ix_cards_dueAsc2 on cards (type, priority desc, due, factId, combinedDue)[*/indexix_media_filenamemedia.CREATE UNIQUE INDEX ix_media_filename on media (filename)H+#gindexix_tags_tagtags/CREATE UNIQUE INDEX ix_tags_tag on tags (tag),##gviewfailedCardsfailedCardsCREATE VIEW failedCards as
select * from cards
where type = 0 and isDue = 1
order by type, isDue, combinedDue-##oviewrevCardsOldrevCardsOldCREATE VIEW revCardsOld as
select * from cards
where type = 1 and isDue = 1
order by priority desc, interval desc
.##eviewrevCardsNewrevCardsNewCREATE VIEW revCardsNew as
select * from cards
where type = 1 and isDue = 1
order by priority desc, interval/##[viewrevCardsDuerevCardsDueCREATE VIEW revCardsDue as
select * from cards
where type = 1 and isDue = 1
order by priority desc, due 0))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinal