SQLite format 3 @ @ 3 3 N @ - 3 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 pageSize4096
sortIndex0e ?hexCache{"-6706014661784909990": "a2ef7331f1bfc75a", "5790168084354418522": "505acf31f1bfc75a", "2805603144384366426": "26ef8131f1bfc75a", "-4873960009072916646": "bc5c3731f1bfc75a", "3707484154137397082": "3373a131f1bfc75a"}(
EcssCache.fmbc5c3731f1bfc75a {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm26ef8131f1bfc75a {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmq3373a131f1bfc75a {text-align:center;}
#cmq505acf31f1bfc75a {text-align:center;}
#cma3373a131f1bfc75a {text-align:center;}
#cma505acf31f1bfc75a {text-align:center;}
.cmb3373a131f1bfc75a {background:#FFFFFF;}
.cmb505acf31f1bfc75a {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
wiYJ<* 'mediaLocation pageSize) suspendLeeches
sortIndex!revSpacing #revInactive
revActive
perDay!newSpacing#newInactive
newActive mediaURL !leechFails latexPre
latexPost hexCache cssCache
/ѻZ
AӔAӔBasicBasic?<
" !2011-08-23" !2011-08-22" !2011-08-22
$Z
s1ZFrontArial1#ޗZ
s1ZBackArial1
" " eZ
s1ZForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFeZ
s1ZReverse%(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)
)
f,*
F
z / i
6 ,
% s1ZAӔ.R"AӔ.S fatal awfulFН
Y s1ZAӔ#"+9AӔ#"¿Cómo estás? How are you? (formal)E䶓Է
W s1ZAӔD\AӔS¡Feliz cumpleaños! Happy birthday!<
E s1ZAӔ'Z>AӔ'BBien, gracias. Fine, thanks@ޕׇ
M s1ZAӔ%rAӔ%Me llamo Juan. My name is Juan.J׳Ҵ
a s1ZAӔ2$AӔ2¿Cuántos años tienes? How old are you?2ғ
1 s1ZAӔ0nAӔ0n¿Y tú? And you?3ǂ"
3 s1ZAӔvAӔM¡Adiós! Goodbye!CϚ%
S s1ZAӔXAӔYEJ¿Dónde vives? Where do you live?Aǁݘ
O s1ZAӔKӍAӔLFt¡Buenas tardes! Good afternoon!=ǃF
G s1ZAӔAӔj¡Hasta luego! See you laterAＷ'
O s1ZAӔHAӔ۽jVivo en Madrid. I live in Madrid0ᓏͽ
- s1ZAӔ,YQAӔ,Y regular not badD^
U s1ZAӔ AӔ$ԛ(¿Qué tal? How are you? (informal)CӠ
S s1ZAӔ;BAӔ;ӷ|Tengo 13 años. I am 13 years old.?ӏǂ
K s1ZAӔu4AӔu¡Buenas noches! Good evening!cλ
s1ZAӔ@AӔ@{Mi cumpleaños es el uno de enero. My birthday is the 1st January.S͋i
s s1ZAӔ7V"AӔ7We¿Cuándo es tu cumpleaños? When is your birthday?.
) s1ZAӔAӔ!¡Hola! Hello!0Ǩ̓ѩ
- s1ZAӔ)eAӔ)Սqfenomenal greatHӏǃ"
] s1ZAӔVAӔd¿Cómo te llamas? What are you called?>ǁP
I s1ZAӔ|sAӔ}0¡Buenos días! Good morning!
Y Y $%
M -%#
AӔZAӔP\ɬAs1Z68e9def6d624aaa3ec233501c38271c0AӔm j? XPriorityVeryHighPriorityHighPriorityLowX8@ 2 a ~
v 5_z dM(
}V14PZ1ZAӔ2$AӔ2¿Cuántos años tienes? How old are you?AӔ2$@ @ AӔ2$ZӏC'
}}1'PZ1ZAӔHAӔOVivo en Madrid. I live in MadridAӔH@ @ AӔHZӏǂ'
{1ݘPZ1ZAӔKӍAӔLt¡Buenas tardes! Good afternoon!AӔKӍ@ @ AӔKӍKҴ'
om1PZ1ZAӔ0nAӔ0o%$¿Y tú? And you?AӔ0n@ @ AӔ0nYܳϚ
'
{} x1WPZ1ZAӔ%rAӔ&Me llamo Juan. My name is Juan.AӔ%r@ @ AӔ%r]
(
}詡1%PZ1ZAӔXAӔYs¿Dónde vives? Where do you live?AӔX@ @ AӔXȁU櫳ѩ'
{u {1ePZ1ZAӔ'Z>AӔ'Bien, gracias. Fine, thanksAӔ'Z>@ @ AӔ'Z>Wǁ~'
}w 1PPZ1ZAӔ|sAӔ}c¡Buenos días! Good morning!AӔ|s@ @ AӔ|sIͣ'
qga1詾PZ1ZAӔ)eAӔ)ռfenomenal greatAӔ)e@ @ AӔ)elᳺǁ(
3io1PZ1ZAӔAӔ+¡Hola!Hello!AӔ@ @ AӔȁ]Ӎ(
}#1PZ1ZAӔ;BAӔ;Tengo 13 años. I am 13 years old.AӔ;B@ @ AӔ;B}퓏Զ)
!)1PZ1ZAӔ@AӔ@Mi cumpleaños es el uno de enero.My birthday is the 1st January.AӔ@@ @ AӔ@XÓǂ'
w1(PZ1ZAӔu4AӔu¡Buenas noches! Good evening!AӔu4@ @ AӔu4ƁV˓ǃ'
{w1FPZ1ZAӔAӔl¡Hasta luego! See you laterAӔ@ @ AӔˁL̺ǃ+'
qmy1Z"PZ1ZAӔvAӔ|F¡Adiós! Goodbye!AӔv@ @ AӔvck)
}1"PZ1ZAӔVAӔ⓯¿Cómo te llamas? What are you called?AӔV@ @ AӔVnɓӠ)
,1[iPZ1ZAӔ7V"AӔ7WG¿Cuándo es tu cumpleaños?When is your birthday?AӔ7V"@ @ 1M
̭11l;AӔPW
P
I
[W
)
D%g\W1 k$9%indexix_factsDeleted_factIdfactsDeleted(CREATE INDEX ix_f
/##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_tagtags0CREATE UNIQUE INDEX ix_tags_tag on tags (tag)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)\*'indexix_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)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,
FOREIGN KEY("mediaId") REFERENCES cards (id)
).%% tablecardsDeletedcardsDeletedCREATE TABLE "ca.%% 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)
, m=^.
f
7
y @ { F
]
1 a 1 L *Γǃ# 5}1"\71ZWhat are you called? ϶ӏͽ 1ͽ&1Zregular &챓' -1'\71ZI live in Madrid)ǃ" 3}1"&1Z¿Cómo te llamas? b]1\71Zawful ӏǂ" y1Z"\71ZGoodbye!2i E,1[i&1Z¿Cuándo es tu cumpleaños? ӏғ 1&1Z¿Y tú? &ﳏӠ -#1&1ZTengo 13 años. &ׇ - x1W\71ZMy name is Juan.%Է +=17\71ZHappy birthday! ȳ b]1&1Zfatal Aӏ co1&1Z¡Hola!"^ %1^&1Z¿Qué tal? &ƓϚ% -詡1%&1Z¿Dónde vives? ғ 1\71ZAnd you?#ﳏǂ '1(Ӽ\71ZGood evening!%柏 + x1W&1ZMe llamo Juan. ,i 9,1[i\71ZWhen is your birthday?+Է 7=17&1Z¡Feliz cumpleaños! ; 1ͽ\71Znot bad-^ ;1^\71ZHow are you? (informal)ѩ a1詾\71Zgreat8 Q)1&1ZMi cumpleaños es el uno de enero./Ҵ ?V14&1Z¿Cuántos años tienes? &ӏ' -1'&1ZVivo en Madrid. ѩ !a1詾&1Zfenomenal %ҳǁݘ +1ݘ\71ZGood afternoon!+ɢН 7_V1 \71ZHow are you? (formal)%ާӏ + {1e&1ZBien, gracias. o1\71ZHello!5כ K)1\71ZMy birthday is the 1st January.'֙ǁݘ /1ݘ&1Z¡Buenas tardes! (泏Ӡ 1#1Ƽ\71ZI am 13 years old.&ǁP - 1P&1Z¡Buenos días! #ӏǁP ' 1P\71ZGood morning!#ӱǃG '1F\71ZSee you later%ǃF +1F&1Z¡Hasta luego! " % {1e\71ZFine, thanks Ġؓǂ" !y1Z"&1Z¡Adiós! &ßҴ -V14ۼ\71ZHow old are you?'볏ǂ /1(&1Z¡Buenas noches! (ãϚ% 1詡1%\71ZWhere do you live?&Н -_V1 &1Z¿Cómo estás?
sq1jAӔPT
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
,
* |l[K:* tdSC2"
}
l
\
K
;
* , t
1l + t
1l * oi16) oi16( Lo1' Lo1& I1頫% I1頫$ M1[M# M1[M" T14! T14 q 1 q 1 n 1 n 1 ո1ͣ ո1ͣ [1詤 [1詤 XJ;1d XJ;1d k1 k1 %-1C %-1C q1
q1
R1
R1
1Wk
1Wk Y1 Y1
31+ 31+ 1Z 1Z "B1( "B1( ܋1~ ܋1~ 1 1
hK,
eR%
p
R
-
# fieldModels2 ' modelsDeleted0 -fieldsix_fields_factId4 2#9fieldsix_fields_fieldModelId4 2 +fieldsix_fields_value4 1' reviewHistory0 models1 -statsix_stats_typeDay2 1 1$ 3cardTagsix_cardTags_tagCard4 2 1! 1cardTagsix_cardTags_cardId4 2
media0! cardModels2 sources0+ CdeckVarssqlite_autoindex_deckVars_114 1% mediaDeleted0 /factsix_facts_modified2 1
decks1 % factsDeleted0% 7cardsix_cards_typeCombined2 2 1 1"
9cardsix_cards_relativeDelay2 2 /cardsix_cards_modified2 1 /cardsix_cards_priority2 2 +cardsix_cards_factor2 2 2+cardsix_cards_factId2 1*9#cardsix_cards_intervalDesc22 2 2 2 1 1$-#cardsix_cards_dueAsc22 2 2 1 1 1'cardsix_cards_sort2 1% cardsDeleted0#tagsix_tags_tag5 1
V eF'mN/
u
V AӔD\=17t
1l AӔ@)1oi16 AӔ;B#1Lo1 AӔ7V",1[iI1頫 AӔ2$V14M1[M AӔ0n1T14 AӔ.R"b]1q 1 AӔ,YQ 1ͽn 1 AӔ)ea1詾ո1ͣ AӔ'Z> {1e[1詤 AӔ#"+9_V1 XJ;1d AӔ 1^k1 AӔH1'%-1C AӔX詡1%q1
AӔ%r x1WR1
AӔV}1"1Wk AӔ1FY1 AӔvy1Z"31+ AӔu4Ƴ1(ӹ 1Z AӔKӍ1ݘ"B1( AӔ|s 1P܋1~ AӔȓo11
~qdWJ=0# t
1l q 1 n 1 k1 XJ;1d M1[M %-1C "B1( T14 R1
q1
[1詤 ܋1~ ո1ͣ 1 Lo1 oi16 1Z Y1 31+ 1Wk I1頫
H t`L8$p\H AӔSdt
1l AӔ@oi16AӔ;Lo1AӔ7WGI1頫AӔ2M1[MAӔ0o%$T14AӔ.S/q 1AӔ,Yn 1AӔ)ռո1ͣAӔ'[1詤AӔ$Ԥk1 AӔ#"XJ;1dAӔO%-1CAӔYsq1
AӔ&R1
AӔ⓯1WkAӔlY1AӔ|F31+AӔuع 1ZAӔLt"B1(AӔ+1AӔ}c܋1~
H t`L8$p\H AӔS=17AӔ@{)1AӔ;ӷ|#1AӔ7We,1[iAӔ2V14AӔ0n1AӔ.S b]1AӔ,Y 1ͽAӔ)Սqa1詾AӔ'B {1eAӔ$ԛ(1^AӔ#"_V1 AӔ۽j1'AӔYEJ詡1%AӔ% x1WAӔd}1"AӔj1FAӔMy1Z"AӔu1(AӔLFt1ݘAӔ!o1AӔ}0 1P
~qdWJ=0# t
1l q 1 n 1 k1 XJ;1d M1[M %-1C "B1( T14 R1
q1
[1詤 ܋1~ ո1ͣ 1 Lo1 oi16 1Z Y1 31+ 1Wk I1頫
|fP:$t^H2 @ t
1l @ q 1@ n 1@ k1 @ XJ;1d@ M1[M@ %-1C@ "B1(@ T14@ R1
@ q1
@ [1詤@ ܋1~@ ո1ͣ@ 1@ Lo1@ oi16@ 1Z@ Y1@ 31+@ 1Wk@ I1頫
H t`L8$p\H b]1q 1_V1 XJ;1d=17t
1l {1e[1詤 x1WR1
V14M1[M1T14y1Z"31+詡1%q1
1ݘ"B1(1FY11'%-1C 1ͽn 11^k1 #1Lo11(ӹ 1Z)1oi16,1[iI1頫o11a1詾ո1ͣ}1"1Wk 1P܋1~
!2011-08-23 !2011-08-22! 2011-08-22
, t`L8$p\H4
l
X
D
0
b]1^11b]1 C1_V1 %1 _V1 1 =17(17=1717 {1ey=1e {1ek1e x1W(1W x1W V_1WV1414V14ۆ| 141¡Hola! u1
sq1j
̭11l;
,
m zk\M>/ {l]N?0!
|
m t
1l ,q 1 n 1 k1 XJ;1dM1[M$%-1C"B1(T14"R1
q1
[1詤܋1~ո1ͣ 1Lo1(oi16* 1ZY1 31+
1WkI1頫&t
1l +q 1 n 1 k1 XJ;1dM1[M#%-1C"B1(T14!R1
q1
[1詤܋1~ո1ͣ
1Lo1'oi16) 1ZY1 31+ 1Wk
I1頫%
,
~qdWJ>1$
{naTG:-
t
1l , t
1l + q 1 q 1 n 1 n 1 k1 k1 XJ;1d XJ;1d M1[M$ M1[M# %-1C %-1C "B1( "B1( T14" T14! R1
R1
q1
q1
[1詤 [1詤 ܋1~ ܋1~ ո1ͣ ո1ͣ 1 1 Lo1( Lo1' oi16* oi16) 1Z 1Z Y1 Y1 31+
31+ 1Wk 1Wk
I1頫& I1頫%
xV4hF$
z
X
6
!b]1AӔ.R"q 1!_V1 AӔ#"+9XJ;1d!=17AӔD\t
1l ! {1eAӔ'Z>[1詤! x1WAӔ%rR1
!V14AӔ2$M1[M!1AӔ0nT14!y1Z"AӔv31+!詡1%AӔXq1
!1ݘAӔKӍ"B1(!1FAӔ˥Y1!1'AӔH%-1C! 1ͽAӔ,YQn 1!1^AӔ k1 !#1AӔ;BLo1!1(AӔu4ƹ 1Z!)1AӔ@oi16!,1[iAӔ7V"I1頫!o1AӔ1!a1詾AӔ)eո1ͣ!}1"AӔV1Wk! 1PAӔ|s܋1~
d X.\2
`
6
d )AӔD\=17AӔD\t
1l )AӔ@)1AӔ@oi16)AӔ;B#1AӔ;BLo1)AӔ7V",1[iAӔ7V"I1頫)AӔ2$V14AӔ2$M1[M)AӔ0n1AӔ0nT14)AӔ.R"b]1AӔ.R"q 1)AӔ,YQ 1ͽAӔ,YQn 1)AӔ)ea1詾AӔ)eո1ͣ)AӔ'Z> {1eAӔ'Z>[1詤)AӔ#"+9_V1 AӔ#"+9XJ;1d)AӔ 1^AӔ k1 )AӔH1'AӔH%-1C)AӔX詡1%AӔXq1
)AӔ%r x1WAӔ%rR1
)AӔV}1"AӔV1Wk)AӔ1FAӔ˥Y1)AӔvy1Z"AӔv31+)AӔu4Ƴ1(AӔu4ƹ 1Z)AӔKӍ1ݘAӔKӍ"B1()AӔ|s 1PAӔ|s܋1~)AӔȓo1AӔ1
]#K
I
{ 1 O
?
<o¿Y tú? T14?u¿Qué tal? k1 C}¿Dónde vives? q1
G¿Cómo te llamas? 1WkC}¿Cómo estás? XJ;1dM¿Cuántos años tienes? M1[MP¿Cuándo es tu cumpleaños?I1頫B{¡Hasta luego! Y1I¡Feliz cumpleaños! t
1l C}¡Buenos días! ܋1~D¡Buenas tardes! "B1(D¡Buenas noches! 1Z=q¡Adiós! 31+C}Vivo en Madrid. %-1CC}Tengo 13 años. Lo1;mregular n 1V!Mi cumpleaños es el uno de enero.oi16B{Me llamo Juan. R1
=qfenomenal ո1ͣ9ifatal q 1B{Bien, gracias. [1詤_3¡Hola!1
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
B a ~
v 5_z dM(
}V14PZ1ZAӔ2$AӔ2¿Cuántos años tienes? How old are you?AӔ2$@ @ AӔ2$ZӏC'
}}1'PZ1ZAӔHAӔOVivo en Madrid. I live in MadridAӔH@ @ AӔHZӏǂ'
{1ݘPZ1ZAӔKӍAӔLt¡Buenas tardes! Good afternoon!AӔKӍ@ @ AӔKӍKҴ'
om1PZ1ZAӔ0nAӔ0o%$¿Y tú? And you?AӔ0n@ @ AӔ0nYܳϚ
'
{} x1WPZ1ZAӔ%rAӔ&Me llamo Juan. My name is Juan.AӔ%r@ @ AӔ%r]
(
}詡1%PZ1ZAӔXAӔYs¿Dónde vives? Where do you live?AӔX@ @ AӔXȁU櫳ѩ'
{u {1ePZ1ZAӔ'Z>AӔ'Bien, gracias. Fine, thanksAӔ'Z>@ @ AӔ'Z>Wǁ~'
}w 1PPZ1ZAӔ|sAӔ}c¡Buenos días! Good morning!AӔ|s@ @ AӔ|sIͣ'
qga1詾PZ1ZAӔ)eAӔ)ռfenomenal greatAӔ)e@ @ AӔ)elᳺǁ(
3io1PZ1ZAӔAӔ+¡Hola!Hello!AӔ@ @ AӔȁ]Ӎ(
}#1PZ1ZAӔ;BAӔ;Tengo 13 años. I am 13 years old.AӔ;B@ @ AӔ;B}퓏Զ)
!)1PZ1ZAӔ@AӔ@Mi cumpleaños es el uno de enero.My birthday is the 1st January.AӔ@@ @ AӔ@XÓǂ'
w1(PZ1ZAӔu4AӔu¡Buenas noches! Good evening!AӔu4@ @ AӔu4ƁV˓ǃ'
{w1FPZ1ZAӔAӔl¡Hasta luego! See you laterAӔ@ @ AӔˁL̺ǃ+'
qmy1Z"PZ1ZAӔvAӔ|F¡Adiós! Goodbye!AӔv@ @ AӔvck)
}1"PZ1ZAӔVAӔ⓯¿Cómo te llamas? What are you called?AӔV@ @ AӔVnɓӠ)
,1[iPZ1ZAӔ7V"AӔ7WG¿Cuándo es tu cumpleaños?When is your birthday?AӔ7V"@ @ AӔ7V"
,
X _ (
{=17PZ1ZAӔD\AӔSd¡Feliz cumpleaños! Happy birthday!AӔD\@ @ AӔD\ƁE½ӏғ'
igb]1PZ1ZAӔ.R"AӔ.S/fatal awfulAӔ.R"@ @ AӔ.R"Iҳ'
mk 1ͽPZ1ZAӔ,YQAӔ,Yregular not badAӔ,YQ@ @ AӔ,YQ^Н(
u 1^PZ1ZAӔ AӔ$Ԥ¿Qué tal? How are you? (informal)AӔ @ @ AӔ `dz(
}_V1 PZ1ZAӔ#"+9AӔ#"¿Cómo estás? How are you? (formal)AӔ#"+9@ @ AӔ#"+9
[ } 1
S @
u
Puv[
3##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc2##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due 1))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinale 9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)O +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_cards_sortcards.CREATE INDEX ix_cards_sort on cards (question collate nocase)[+/indexix_media_filenamemedia/CREATE UNIQUE INDEX ix_media_filename on media (filename)H,#gindexix_tags_tagtags0CREATE 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, interval0##[viewrevCardsDuerevCardsDueCREATE VIEW revCardsDue as
select * from cards
where type = 1 and isDue = 1
order by priority desc, due