SQLite format 3 @ ' 2 2 N ' - 2=- V
##stablefieldModelsfieldModels CREATE TABLE "fieldModels" (
id INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
required BOOLEAN NOT NULL,
"unique" BOOLEAN NOT NULL,
numeric BOOLEAN NOT NULL,
"quizFontFamily" TEXT,
"quizFontSize" INTEGER,
"quizFontColour" VARCHAR(7),
"editFontFamily" TEXT,
"editFontSize" INTEGER,
PRIMARY KEY (id),
CHECK (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars {tablestatsstatsCREATE TABLE stats (
id INTEGER NOT NULL,
type INTEGER NOT NULL,
day DATE NOT NULL,
reps INTEGER NOT NULL,
"averageTime" FLOAT NOT NULL,
"reviewTime" FLOAT NOT NULL,
"distractedTime" FLOAT NOT NULL,
"distractedReps" INTEGER NOT NULL,
"newEase0" INTEGER NOT NULL,
"newEase1" INTEGER NOT NULL,
"newEase2" INTEGER NOT NULL,
"newEase3" INTEGER NOT NULL,
"newEase4" INTEGER NOT NULL,
"youngEase0" INTEGER NOT NULL,
"youngEase1" INTEGER NOT NULL,
"youngEase2" INTEGER NOT NULL,
"youngEase3" INTEGER NOT NULL,
"youngEase4" INTEGER NOT NULL,
"matureEase0" INTEGER NOT NULL,
"matureEase1" INTEGER NOT NULL,
"matureEase2" INTEGER NOT NULL,
"matureEase3" INTEGER NOT NULL,
"matureEase4" INTEGER NOT NULL,
PRIMARY KEY (id)
)]tablemodelsmodelsCREATE TABLE models (
id INTEGER NOT NULL,
"deckId" INTEGER,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
spacing FLOAT NOT NULL,
"initialSpacing" FLOAT NOT NULL,
source INTEGER NOT NULL,
PRIMARY KEY (id)
)` tablemediamediaCREATE TABLE media (
id INTEGER NOT NULL,
filename TEXT NOT NULL,
size INTEGER NOT NULL,
created FLOAT NOT NULL,
"originalPath" TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id)
)JktablesourcessourcesCREATE TABLE sources (
id INTEGER NOT NULL,
name TEXT NOT NULL,
created FLOAT NOT NULL,
"lastSync" FLOAT NOT NULL,
"syncPeriod" INTEGER NOT NULL,
PRIMARY KEY (id)
);''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1rev
/܍Q
AӔAӔBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
j u Yt f AhexCache{"-7032066038897351599": "9e691531f26f6451", "2799859295652373586": "26db1931f26f6452", "6442803002241672274": "59696f31f26f6452", "-1738034099388455855": "e7e14331f26f6451", "-5172508202328169391": "b8378f31f26f6451"}(
EcssCache.fm9e691531f26f6451 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fme7e14331f26f6451 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq26db1931f26f6452 {text-align:center;}
#cmq59696f31f26f6452 {text-align:center;}
#cma26db1931f26f6452 {text-align:center;}
#cma59696f31f26f6452 {text-align:center;}
.cmb26db1931f26f6452 {background:#FFFFFF;}
.cmb59696f31f26f6452 {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
$Q
71odQFrontArial1#ϚӏQ
71odQBackArial1
" " eڭR
71odQForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe㓏R
71odQReverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFF
1 1* : K
V
;''5tablereviewHistoryreviewHistoryCREATE TABLE "reviewHistory" (
"cardId" INTEGER NOT NULL,
time FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
"nextInterval" FLOAT NOT NULL,
ease INTEGER NOT NULL,
delay FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"nextFactor" FLOAT NOT NULL,
reps FLOAT NOT NULL,
"thinkingTime" FLOAT NOT NULL,
"yesCount" FLOAT NOT NULL,
"noCount" FLOAT NOT NULL,
PRIMARY KEY ("cardId", time)
)9M' indexsqlite_autoindex_reviewHistory_1reviewHistoryJktablesourcessourcesCREATE TABLE sources (
id INTEGER NOT NULL,
name TEXT NOT NULL,
created FLOAT NOT NULL,
"lastSync" FLOAT NOT NULL,
"syncPeriod" INTEGER NOT NULL,
PRIMARY KEY (id)
)` tablemediamediaCREATE TABLE media (
id INTEGER NOT NULL,
filename TEXT NOT NULL,
size INTEGER NOT NULL,
created FLOAT NOT NULL,
"originalPath" TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id)
)]tablemodelsmodelsCREATE TABLE models (
id INTEGER NOT NULL,
"deckId" INTEGER,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
spacing FLOAT NOT NULL,
"initialSpacing" FLOAT NOT NULL,
source INTEGER NOT NULL,
PRIMARY KEY (id)
){tablestatsstatsCREATE TABLE stats (
id INTEGER NOT NULL,
type INTEGER NOT NULL,
day DATE NOT NULL,
reps INTEGER NOT NULL,
"averageTime" FLOAT NOT NULL,
"reviewTime" FLOAT NOT NULL,
"distractedTime" FLOAT NOT NULL,
"distractedReps" INTEGER NOT NULL,
"newEase0" INTEGER NOT NULL,
"newEase1" INTEGER NOT NULL,
"newEase2" INTEGER NOT NULL,
"newEase3" INTEGER NOT NULL,
"newEase4" INTEGER NOT NULL,
"youngEase0" INTEGER NOT NULL,
"youngEase1" INTEGER NOT NULL,
"youngEase2" INTEGER NOT NULL,
"youngEase3" INTEGER NOT NULL,
"youngEase4" INTEGER NOT NULL,
"matureEase0" INTEGER NOT NULL,
"matureEase1" INTEGER NOT NULL,
"matureEase2" INTEGER NOT NULL,
"matureEase3" INTEGER NOT NULL,
"matureEase4" INTEGER NOT NULL,
PRIMARY KEY (id)
)r 7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars 4 '''tablemodelsDeletedmodelsDeleted
CREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)V
##stablefieldModelsfieldModels CREATE TABLE "fieldModels" (
id INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
features TEXT NOT NULL,
required BOOLEAN NOT NULL,
"unique" BOOLEAN NOT NULL,
numeric BOOLEAN NOT NULL,
"quizFontFamily" TEXT,
"quizFontSize" INTEGER,
"quizFontColour" VARCHAR(7),
"editFontFamily" TEXT,
"editFontSize" INTEGER,
PRIMARY KEY (id),
CHECK (numeric IN (0, 1)),
CHECK (required IN (0, 1)),
CHECK ("unique" IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)
!!tablecardModelscardModels CREATE TABLE "cardModels" (
id INTEGER NOT NULL,
ordinal INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT NOT NULL,
active BOOLEAN NOT NULL,
qformat TEXT NOT NULL,
aformat TEXT NOT NULL,
lformat TEXT,
qedformat TEXT,
aedformat TEXT,
"questionInAnswer" BOOLEAN NOT NULL,
"questionFontFamily" TEXT,
"questionFontSize" INTEGER,
"questionFontColour" VARCHAR(7),
"questionAlign" INTEGER,
"answerFontFamily" TEXT,
"answerFontSize" INTEGER,
"answerFontColour" VARCHAR(7),
"answerAlign" INTEGER,
"lastFontFamily" TEXT,
"lastFontSize" INTEGER,
"lastFontColour" VARCHAR(7),
"editQuestionFontFamily" TEXT,
"editQuestionFontSize" INTEGER,
"editAnswerFontFamily" TEXT,
"editAnswerFontSize" INTEGER,
"allowEmptyAnswer" BOOLEAN NOT NULL,
"typeAnswer" TEXT NOT NULL,
PRIMARY KEY (id),
CHECK ("questionInAnswer" IN (0, 1)),
CHECK ("allowEmptyAnswer" IN (0, 1)),
CHECK (active IN (0, 1)),
FOREIGN KEY("modelId") REFERENCES models (id)
)& +tablefactsfactsCREATE TABLE facts (
id INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
"spaceUntil" TEXT NOT NULL,
"lastCardId" INTEGER,
PRIMARY KEY (id),
FOREIGN KEY("modelId") REFERENCES models (id)
)q
AtabledecksdecksCREATE TABLE decks (
id INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
description TEXT NOT NULL,
version INTEGER NOT NULL,
"currentModelId" INTEGER,
"syncName" TEXT,
"lastSync" FLOAT NOT NULL,
"hardIntervalMin" FLOAT NOT NULL,
"hardIntervalMax" FLOAT NOT NULL,
"midIntervalMin" FLOAT NOT NULL,
"midIntervalMax" FLOAT NOT NULL,
"easyIntervalMin" FLOAT NOT NULL,
"easyIntervalMax" FLOAT NOT NULL,
delay0 INTEGER NOT NULL,
delay1 INTEGER NOT NULL,
delay2 FLOAT NOT NULL,
"collapseTime" INTEGER NOT NULL,
"highPriority" TEXT NOT NULL,
"medPriority" TEXT NOT NULL,
"lowPriority" TEXT NOT NULL,
suspended TEXT NOT NULL,
"newCardOrder" INTEGER NOT NULL,
"newCardSpacing" INTEGER NOT NULL,
"failedCardMax" INTEGER NOT NULL,
"newCardsPerDay" INTEGER NOT NULL,
"sessionRepLimit" INTEGER NOT NULL,
"sessionTimeLimit" INTEGER NOT NULL,
"utcOffset" FLOAT NOT NULL,
"cardCount" INTEGER NOT NULL,
"factCount" INTEGER NOT NULL,
"failedNowCount" INTEGER NOT NULL,
"failedSoonCount" INTEGER NOT NULL,
"revCount" INTEGER NOT NULL,
"newCount" INTEGER NOT NULL,
"revCardOrder" INTEGER NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY("currentModelId") REFERENCES models (id)
)5ItablecardscardsCREATE TABLE cards (
id INTEGER NOT NULL,
"factId" INTEGER NOT NULL,
"cardModelId" INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
ordinal INTEGER NOT NULL,
question TEXT NOT NULL,
answer TEXT NOT NULL,
priority INTEGER NOT NULL,
interval FLOAT NOT NULL,
"lastInterval" FLOAT NOT NULL,
due FLOAT NOT NULL,
"lastDue" FLOAT NOT NULL,
factor FLOAT NOT NULL,
"lastFactor" FLOAT NOT NULL,
"firstAnswered" FLOAT NOT NULL,
reps INTEGER NOT NULL,
successive INTEGER NOT NULL,
"averageTime" FLOAT NOT NULL,
"reviewTime" FLOAT NOT NULL,
"youngEase0" INTEGER NOT NULL,
"youngEase1" INTEGER NOT NULL,
"youngEase2" INTEGER NOT NULL,
"youngEase3" INTEGER NOT NULL,
"youngEase4" INTEGER NOT NULL,
"matureEase0" INTEGER NOT NULL,
"matureEase1" INTEGER NOT NULL,
"matureEase2" INTEGER NOT NULL,
"matureEase3" INTEGER NOT NULL,
"matureEase4" INTEGER NOT NULL,
"yesCount" INTEGER NOT NULL,
"noCount" INTEGER NOT NULL,
"spaceUntil" FLOAT NOT NULL,
"relativeDelay" FLOAT NOT NULL,
"isDue" BOOLEAN NOT NULL,
type INTEGER NOT NULL,
"combinedDue" INTEGER NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY("cardModelId") REFERENCES "cardModels" (id),
CHECK ("isDue" IN (0, 1)),
FOREIGN KEY("factId") REFERENCES facts (id)
)
QV
U
J ` (
0ޤӏ೫
- 71odQAӔC AӔuna chica a girl.N
) 71odQAӔ#AӔÈnalto/alta tall9ӏ
? 71odQAӔLAӔM!%guapo/guapa good-looking8
= 71odQAӔN
5AӔNinteligente intelligent'ӏŠ
71odQAӔxAӔr.soy I'm*ߥ
! 71odQAӔ'
AӔ'ser to be49
5 71odQAӔ݂AӔ݃.delgado/delgada thin+Q
# 71odQAӔFAӔQEres You'reA
O 71odQAӔRAӔS,gsimpático/simpática nice, kindC.
S 71odQAӔA}AӔantipático/antipática unpleasant06
- 71odQAӔAӔSgordo/gorda fat@U
M 71odQAӔAӔ z¿Cómo eres? What are you like?<
E 71odQAӔrTAӔ2divertido/divertida amusing-Ǔ
' 71odQAӔdAӔeu feo/fea ugly.ۓ
) 71odQAӔ2aAӔ2un chico a boy5ӏN
7 71odQAӔ LAӔ severo/severa strict9ד
? 71odQAӔz AӔNaburrido/aburrida boring7)
; 71odQAӔy`AӔyperezoso/perezosa lazy4
5 71odQAӔDAӔEqTtímido/tímida shy0匓d
- 71odQAӔ`^AӔ` bajo/baja short-ӏ
' 71odQAӔbAӔEs He's/She's
Y Y $%
M -%#
AӔAӔOEcA71odQfafdfea2bd8025af68fd9309d02a72e0AӔ%u? XPriorityVeryHighPriorityHighPriorityLowX8@ 1
Hy/W @Į4'
cc[1oŠYio1odRAӔxAӔ̦soyI'mAӔx@ @ AӔxNӏ'
yiߵ-1qNYio1odRAӔ LAӔ severo/severa strictAӔ L@ @ AӔ LˁI '
qga1pkdYio1odRAӔ`^AӔ`bajo/baja shortAӔ`^@ @ AӔ`^MФ'
}c'71r Yio1odRAӔDAӔE^tímido/tímida shyAӔD@ @ AӔD[ӏ(
q01qYio1odRAӔRAӔSZsimpático/simpática nice, kindAӔR@ @ AӔRMӏ '
{e@W1p9Yio1odRAӔ݂AӔ݃]5delgado/delgadathinAӔ݂@ @ AӔ݂Gӏ'
mg&1p!Yio1odRAӔ2aAӔ2un chicoa boyAӔ2a@ @ AӔ2aS̓(
iٺ1q0Yio1odRAӔz AӔ aburrido/aburrida boringAӔz @ @ AӔz Q䌪(
eZ1q)Yio1odRAӔy`AӔzperezoso/perezosa lazyAӔy`@ @ AӔy`ԁD'
ei:t1oQYio1odRAӔFAӔsEresYou'reAӔF@ @ AӔFCŃ'
egA's1oYio1odRAӔ'
AӔ'0ser to beAӔ'
@ @ AӔ'
́Vӏ3(
kL1qvYio1odRAӔrTAӔdivertido/divertida amusingAӔrT@ @ AӔrTQ袓Ņ'
us^Y1rHYio1odRAӔN
5AӔNinteligente intelligentAӔN
5@ @ AӔN
5Iѡӏ3'
oiqy%1p3Yio1odRAӔC AӔuna chicaa girlAӔC @ @ AӔC ZĊ峏ߥ(
w 1ohUYio1odRAӔAӔ {¿Cómo eres?What are you like?AӔ@ @ AӔF'
aqBM1oYio1odRAӔbAӔ$%EsHe's/She'sAӔb@ @ AӔbGӏI'
oek[71pPNYio1odRAӔ#AӔöalto/altatallAӔ#@ @ AӔ#F擏Ⱛ'
me 91q
Yio1odRAӔdAӔefeo/fea uglyAӔd@ @ 0Į4
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 R,~U#
b
>
p K ( | M !
b
9
| X 6 ӏ BM1oC1odQEsؓ) Z1q)i1odQlazy,ӏ 901qC1odQsimpático/simpática "ӏ %^U1pC1odQguapo/guapa ӏ L1qvi1odQamusing*ӏ 5L1qvC1odQdivertido/divertida ೫ qy%1p3C1odQuna chicaӏ '71r Şi1odQshy ҨQ :t1oQi1odQYou're ӏ &1p!C1odQun chico7 ,/1p6i1odQfat! #^Y1rHi1odQintelligent"꙳ %^Y1rHC1odQinteligente %: +@W1p9C1odQdelgado/delgada& -'71r C1odQtímido/tímida ӏ ٺ1q0Ǟi1odQboringʓ: @W1p9i1odQthin( 1ٺ1q0C1odQaburrido/aburrida ЭŠ [1oŠC1odQsoyd a1pkdi1odQshort"ؓ %^U1p꾞i1odQgood-looking ٟӏ !BM1oi1odQHe's/She'sӏߥ A's1oC1odQser 染Ġ
91q
C1odQfeo/fea #W ' 1ohUC1odQ¿Cómo eres?ӏN k[71pPNi1odQtallӓߥ A's1oi1odQto be d !a1pkdC1odQbajo/baja 壳Š [1oŠi1odQI'm &1p!i1odQa boy !01qi1odQnice, kind(W 1 1ohUi1odQWhat are you like? N k[71pPNC1odQalto/alta ޒ೫ qy%1p3i1odQa girl.ڨӏ. =.
1qU.C1odQantipático/antipática "٧ӏ6 %,/1p6C1odQgordo/gorda ِQ :t1oQC1odQEres ؒN ߵ-1qNi1odQstrict(֩) 1Z1q)C1odQperezoso/perezosa $䳏N )ߵ-1qNC1odQsevero/severa ɛ
91q
i1odQugly Ⱥ. !.
1qU.i1odQunpleasant
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
*
K |l[K:* tdSC2"
}
l
\
K * 1rŅ) 1rŅ( !A#1rG' !A#1rG& /1r % /1r $ N1q# N1q" -M1q! -M1q 1q3 1q3 /1qv /1qv fa1qU fa1qU 11q0 11q0 ae1q ae1q Y
S1p Y
S1p 1p 1p $ 1p $ 1p Uu1pkI Uu1pkI M1pP3
M1pP3 s1p3 s1p3
1p! 1p! ש1o ש1o /w1o4 /w1o4 O1oŃ O1oŃ ++1o ++1o
}l`L?0$ # fieldModels0' modelsDeleted0 fields0+ CdeckVarssqlite_autoindex_deckVars_112 1
stats0
cardTags0 models0 ' reviewHistory0
media0 ! cardModels0 sources0% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
u eF'mN/
u AӔN
5^Y1rH1rŅ AӔD'71r !A#1rG AӔy`Z1q)/1r AӔR01q N1q AӔ Lߵ-1qN-M1q AӔrTL1qv1q3 AӔA}.
1qU./1qv AӔz ٺ1q0 fa1qU AӔd 91q
11q0 AӔL^U1pae1q AӔ,/1p6Y
S1p AӔ݂@W1p91p AӔ`^a1pkd$ 1p AӔ#k[71pPNUu1pkI AӔC qy%1p3M1pP3 AӔ2a&1p! s1p3 AӔbBM1o煓1p! AӔF:t1oQש1o AӔx[1oŠ/w1o4 AӔ'
A's1oO1oŃ AӔ 1ohU++1o
~qdWJ=0# ae1q Y
S1p /1qv /w1o4 -M1q $ 1p !A#1rG N1q 1p s1p3 fa1qU /1r ש1o O1oŃ 1q3 1rŅ M1pP3 ++1o 1p! Uu1pkI 11q0
\ t`L8$p\ AӔN1rŅAӔE^!A#1rGAӔz/1r AӔSZ N1qAӔ -M1qAӔ1q3AӔ/1qvAӔ fa1qUAӔe11q0AӔMPrae1qAӔH4Y
S1pAӔ݃]51p AӔ`$ 1p AӔöԄUu1pkIAӔ颅M1pP3AӔ2 s1p3AӔ$%1p!AӔsש1oAӔ̦/w1o4AӔ'0O1oŃAӔ {++1o
\ t`L8$p\ AӔN^Y1rHAӔEqT'71r AӔyZ1q)AӔS,g01qAӔ ߵ-1qNAӔ2L1qvAӔ.
1qU.AӔNٺ1q0AӔeu 91q
AӔM!%^U1pAӔS,/1p6AӔ݃.@W1p9AӔ` a1pkdAӔÈnk[71pPNAӔqy%1p3AӔ2&1p!AӔBM1oAӔQ:t1oQAӔr.[1oŠAӔ'A's1oAӔ z 1ohU
~qdWJ=0# ae1q Y
S1p /1qv /w1o4 -M1q $ 1p !A#1rG N1q 1p s1p3 fa1qU /1r ש1o O1oŃ 1q3 1rŅ M1pP3 ++1o 1p! Uu1pkI 11q0
2 |fP:$t^H2 @ ae1q@ Y
S1p@ /1qv@ /w1o4@ -M1q@ $ 1p @ !A#1rG@ N1q@ 1p @ s1p3@ fa1qU@ /1r @ ש1o@ O1oŃ@ 1q3@ 1rŅ@ M1pP3@ ++1o@ 1p!@ Uu1pkI@ 11q0
\ t`L8$p\ qy%1p3M1pP3k[71pPNUu1pkI^U1pae1q^Y1rH1rŅ[1oŠ/w1o4A's1oO1oŃ@W1p91p :t1oQש1o01q N1q.
1qU./1qv,/1p6Y
S1p 1ohU++1oL1qv1q3 91q
11q0&1p! s1p3ߵ-1qN-M1qٺ1q0 fa1qUZ1q)/1r '71r !A#1rGa1pkd$ 1p BM1o煓1p!
!2011-08-23 !2011-08-22! 2011-08-22
* t`L8$p\H4
l
X
D
0
qy%1p3j:W1p3qy%1p3H1p3k[71pPNG}1pPNk[71pPN@I1pPN^U1pzK1p^U1pf1p^Y1rHS1rH^Y1rHM1rH[1oŠ Ao1oŠ[1oŠ1oŠA's1o
1oA's1o1o@W1p9/ 1p:@W1p9$>Q1p::t1oQaIG1oQ:t1oQA71oQ01q~A1q01q1q.
1qU.1qU..
1qU.1qU.,/1p6X_1p7,/1p6u1p6 1ohU1ohW 1ohU1ohWL1qvw1qvL1qvl1qv 91q
)71q
91q
m1q
&1p!^m1p!&1p!1p!ߵ-1qNH1qNߵ-1qNc#1qNٺ1q0)1q0ٺ1q0"ˣ1q0Z1q)j1q)Z1q)YK1q)'71r hc1r '71r +1r a1pkdo1pkda1pkdQ1pkdBM1o-1oBM1o d1o
* t`L8$p\H4
l
X
D
0
C1odQ-1oC1odQ~A1qC1odQzK1pC1odQl1qvC1odQj:W1p3C1odQ^m1p!C1odQM1rHC1odQ/ 1p:C1odQ+1r C1odQ"ˣ1q0C1odQ Ao1oŠC1odQ
1oC1odQ )71q
C1odQ1ohWC1odQQ1pkdC1odQ@I1pPNC1odQ1qU.C1odQu1p6C1odQA71oQC1odQYK1q)C1odQc#1qNi1odQj1q)i1odQw1qvi1odQhc1r i1odQaIG1oQi1odQX_1p7i1odQS1rHi1odQ)1q0i1odQ$>Q1p:i1odQo1pkdi1odQf1pi1odQ d1oi1odQG}1pPNi1odQ1oi1odQ1oŠi1odQ1p!i1odQ1qi1odQ1ohWi1odQH1p3i1odQH1qNi1odQm1q
i1odQ1qU.
* } |jL7$ zbJ2
u
S
D
2
"
} '¿Cómo eres?1ohW!unpleasant1qU. una chicaj:W1p3 un chico^m1p!uglym1q
-tímido/tímida +1r to be1othin$>Q1p:tallG}1pPNstrictH1qNsoy Ao1oŠ!9simpático/simpática ~A1qshyhc1r shorto1pkd)severo/severa c#1qNser
1o 1perezoso/perezosa YK1q)!nice, kind1qlazyj1q)#intelligentS1rH%inteligente M1rH%guapo/guapa zK1p%gordo/gorda u1p6%good-lookingf1p feo/fea )71q
fatX_1p7 5divertido/divertida l1qv+delgado/delgada/ 1p:boring)1q0!bajo/baja Q1pkd#=antipático/antipática 1qU.amusingw1qv alto/alta@I1pPN 1aburrido/aburrida "ˣ1q0a girlH1p3a boy1p!You'reaIG1oQ 1What are you like?1ohWI'm1oŠ!He's/She's d1o
Es-1oEresA71oQ
*
zk\M>/ {l]N?0!
ae1qY
S1p/1qv /w1o4-M1q"$ 1p !A#1rG( N1q$1p s1p3 fa1qU /1r &ש1oO1oŃ1q3 1rŅ*M1pP3++1o1p!
Uu1pkI11q0ae1qY
S1p/1qv /w1o4-M1q!$ 1p !A#1rG' N1q#1p s1p3 fa1qU/1r %ש1oO1oŃ1q3 1rŅ)M1pP3
++1o1p! Uu1pkI11q0
*
reXK>1$
{naTG:-
ae1q ae1q Y
S1p Y
S1p /1qv /1qv /w1o4 /w1o4 -M1q" -M1q! $ 1p $ 1p !A#1rG( !A#1rG' N1q$ N1q# 1p 1p s1p3 s1p3 fa1qU fa1qU /1r & /1r % ש1o ש1o O1oŃ O1oŃ 1q3 1q3 1rŅ* 1rŅ) M1pP3 M1pP3
++1o ++1o 1p!
1p! Uu1pkI Uu1pkI 11q0 11q0
6 xV4hF$
z
X
6 !qy%1p3AӔC M1pP3!k[71pPNAӔ#Uu1pkI!^U1pAӔLae1q!^Y1rHAӔN
51rŅ![1oŠAӔx/w1o4!A's1oAӔ'
O1oŃ!@W1p9AӔ݂1p !:t1oQAӔFש1o!01qAӔR N1q!.
1qU.AӔA}/1qv!,/1p6AӔY
S1p! 1ohUAӔወ++1o!L1qvAӔrT1q3! 91q
AӔd11q0!&1p!AӔ2a s1p3!ߵ-1qNAӔ L-M1q!ٺ1q0AӔz fa1qU!Z1q)AӔy`/1r !'71r AӔD!A#1rG!a1pkdAӔ`^$ 1p !BM1oAӔb1p!
X.\2
`
6
)AӔN
5^Y1rHAӔN
51rŅ)AӔD'71r AӔD!A#1rG)AӔy`Z1q)AӔy`/1r )AӔR01qAӔR N1q)AӔ Lߵ-1qNAӔ L-M1q)AӔrTL1qvAӔrT1q3)AӔA}.
1qU.AӔA}/1qv)AӔz ٺ1q0AӔz fa1qU)AӔd 91q
AӔd11q0)AӔL^U1pAӔLae1q)AӔ,/1p6AӔY
S1p)AӔ݂@W1p9AӔ݂1p )AӔ`^a1pkdAӔ`^$ 1p )AӔ#k[71pPNAӔ#Uu1pkI)AӔC qy%1p3AӔC M1pP3)AӔ2a&1p!AӔ2a s1p3)AӔbBM1oAӔb1p!)AӔF:t1oQAӔFש1o)AӔx[1oŠAӔx/w1o4)AӔ'
A's1oAӔ'
O1oŃ)AӔ 1ohUAӔወ++1o
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
/]
Hy/W @Į4'
cc[1oŠYio1odRAӔxAӔ̦soyI'mAӔx@ @ AӔxNӏ'
yiߵ-1qNYio1odRAӔ LAӔ severo/severa strictAӔ L@ @ AӔ LˁI '
qga1pkdYio1odRAӔ`^AӔ`bajo/baja shortAӔ`^@ @ AӔ`^MФ'
}c'71r Yio1odRAӔDAӔE^tímido/tímida shyAӔD@ @ AӔD[ӏ(
q01qYio1odRAӔRAӔSZsimpático/simpática nice, kindAӔR@ @ AӔRMӏ '
{e@W1p9Yio1odRAӔ݂AӔ݃]5delgado/delgadathinAӔ݂@ @ AӔ݂Gӏ'
mg&1p!Yio1odRAӔ2aAӔ2un chicoa boyAӔ2a@ @ AӔ2aS̓(
iٺ1q0Yio1odRAӔz AӔ aburrido/aburrida boringAӔz @ @ AӔz Q䌪(
eZ1q)Yio1odRAӔy`AӔzperezoso/perezosa lazyAӔy`@ @ AӔy`ԁD'
ei:t1oQYio1odRAӔFAӔsEresYou'reAӔF@ @ AӔFCŃ'
egA's1oYio1odRAӔ'
AӔ'0ser to beAӔ'
@ @ AӔ'
́Vӏ3(
kL1qvYio1odRAӔrTAӔdivertido/divertida amusingAӔrT@ @ AӔrTQ袓Ņ'
us^Y1rHYio1odRAӔN
5AӔNinteligente intelligentAӔN
5@ @ AӔN
5Iѡӏ3'
oiqy%1p3Yio1odRAӔC AӔuna chicaa girlAӔC @ @ AӔC ZĊ峏ߥ(
w 1ohUYio1odRAӔAӔ {¿Cómo eres?What are you like?AӔ@ @ AӔF'
aqBM1oYio1odRAӔbAӔ$%EsHe's/She'sAӔb@ @ AӔbGӏI'
oek[71pPNYio1odRAӔ#AӔöalto/altatallAӔ#@ @ AӔ#F擏Ⱛ'
me 91q
Yio1odRAӔdAӔefeo/fea uglyAӔd@ @ AӔd
g D
g Rӏ'
uu^U1pYio1odRAӔLAӔMPrguapo/guapa good-lookingAӔL@ @ AӔLցIʳ'
uc,/1p6Yio1odRAӔAӔH4gordo/gorda fatAӔ@ @ AӔ](
q.
1qU.Yio1odRAӔA}AӔantipático/antipática unpleasantAӔA}@ @ 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