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 pageSize4096b 9hexCache{"7560181694140170398": "68eb2931fca2c09e", "3334727722271424671": "2e475531fca2c09f", "2926534030459584670": "289d2331fca2c09e", "979314330831077534": "d973931fca2c09e", "-3085146949475450721": "d52f5b31fca2c09f"}'
CcssCache.fmd973931fca2c09e {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fm289d2331fca2c09e {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqd52f5b31fca2c09f {text-align:center;}
#cmq2e475531fca2c09f {text-align:center;}
#cmad52f5b31fca2c09f {text-align:center;}
#cma2e475531fca2c09f {text-align:center;}
.cmbd52f5b31fca2c09f {background:#FFFFFF;}
.cmb2e475531fca2c09f {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ӕIv9AӕIvJBasicBasic?<
" !2011-08-24" !2011-08-24
$
h)1FrontArial1#瓏
h)1BackArial1
" " eӏ
h)1Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFe볏
h)1Forward%(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)
)
' @r6
: E %
r
$ b ' 1ʝ
/ h)1AӕJuAӕJamás tarde later=̍+
G h)1AӕJ AӕJ Vamos a … We’re going …3ӏɏ
3 h)1AӕJAӕJlesta noche tonight4ӏʹ
5 h)1AӕJ6 AӕJ6por último finallyD̮
U h)1AӕJ!`AӕJ!\>escuchar música to listen to music0ӏi
- h)1AӕJ*pAӕJ*Gsalir to go out+ƫ2
# h)1AӕJ [ةAӕJ \Mluego then:o
A h)1AӕJ6]AӕJesta mañana this morningQ͔"
o h)1AӕJ(AӕJ(vSir a la peluquería to go to the hairdresser’s.ӏɹ
) h)1AӕJ
ooAӕJ
poprimero first2˳N
1 h)1AӕIȓAӕI< el viernes FridayGܓ6
[ h)1AӕJ.q`$AӕJ.qver la televisión to watch television2Ɔ
1 h)1AӕIAӕIel martes Tuesday4昮ӏʁ7
5 h)1AӕJ#NAӕJ#después afterwards4ǂ
5 h)1AӕIAӕIWel sábado Saturday3ߵó
3 h)1AӕIAӕIPel jueves ThursdayXҟӭ
} h)1AӕJ 6zAӕJ 6¿Qué vas a hacer hoy? What are you going to do today?A
O h)1AӕJ$AӕJ$ir al balneario to go to the spaEЇճ
W h)1AӕJ nAӕJ W!(No) Voy a … I’m (not) going …2ƕǬh
1 h)1AӕIpAӕIel domingo Sunday8ۥӏ
= h)1AӕJAӕJresta tarde this evening8Ƨ
= h)1AӕI .AӕI el miércoles Wednesday@
M h)1AӕJ͈AӕJEste fin de semana This weekendAِ
O h)1AӕJ&%-fAӕJ&%nir al casino to go to the casino1á
/ h)1AӕIJAAӕI Mi semana My week0
- h)1AӕIMAӕI el lunes Monday
Y Y $%
M -%#
AӕIh9AӕJ.r Ah)17dbfa5d760198d210c913317faae8e86AӕJ1>k? XPriorityVeryHighPriorityHighPriorityLowX8@ 1
4Y.] kŮӏN)
w1"/[1AӕJ(AӕJ(+ir a la peluquería to go to the hairdresser’sAӕJ(@ @ AӕJ(L̓ʜ'
ooau17/[1AӕJ#NAӕJ#después afterwardsAӕJ#N@ @ AӕJ#NF̓'
me1/[1AӕJ
ooAӕJ
p4primero firstAӕJ
oo@ @ AӕJ
ooL'
uir19/[1AӕJ6 AӕJ6Bpor último finallyAӕJ6 @ @ AӕJ6 Uӏ̮m'
s}xg1
+/[1AӕJ AӕJ 9Vamos a …We’re going …AӕJ @ @ AӕJ Y(
sw1\/[1AӕJ͈AӕJ+Este fin de semana This weekendAӕJ͈@ @ AӕJ͈K允ӏɹ'
sisGu1/[1AӕJAӕJǚesta noche tonightAӕJ@ @ AӕJρZߠӏ͔(
wd1s/[1AӕJ&%-fAӕJ&%ir al casino to go to the casinoAӕJ&%-f@ @ AӕJ&%-fJݳӏƦ'
qi 1/[1AӕIAӕI.Ael martes TuesdayAӕI@ @ AӕIPܦǓɏ'
ssm-1p/[1AӕJAӕJesta tarde this eveningAӕJ@ @ AӕJﮁR'
ws>1Co/[1AӕJ6]AӕJMesta mañana this morningAӕJ6]@ @ AӕJ6]Jљǂ'
sgj[1fN/[1AӕIȓAӕImjel viernes FridayAӕIȓ@ @ AӕIȓC̥ʁ '
icQ_12/[1AӕJ [ةAӕJ \|luego thenAӕJ [ة@ @ AӕJ [ة^ʶӏ̍(
{ 1/[1AӕJ nAӕJ (No) Voy a … I’m (not) going …AӕJ n@ @ AӕJ nHƺƆ'
og W1/[1AӕIMAӕIel lunes MondayAӕIM@ @ AӕIMLƴճǬJ'
sk1/[1AӕIAӕIel sábado SaturdayAӕI@ @ AӕI܁JŦӒ'
sg1h/[1AӕIpAӕIel domingo SundayAӕIp@ @ AӕIpҁYب'
}{G 1P/[1AӕJ$AӕJ$*ir al balneario to go to the spaAӕJ$@ @ 0ŮӏN
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)
4 }R&^7
f
>
b 5
N (
v
K
\ 6 [0|V* ʝ z1
91later"ʹ %r19(#1por último W1
91Monday Ɔ 1
91Tuesday"峏p %>1Co
91this morning*͔" 5w1"(#1ir a la peluquería # 'd1s(#1ir al casino !ӏ̍+ #xg1
+(#1Vamos a …ӏ3 Q_12
91then!ӏǬi #1h(#1el domingo ܳi _51i
91to go out+ӏ 7 1
91I’m (not) going …$Ƨ )k1'(#1el miércoles דN j[1fN
91Friday& -G 1P(#1ir al balneario 2 Q_12(#1luego )ӏ 3d1s
91to go to the casino ؝ K1
91My week5ӭ KH1ӭ
91What are you going to do today?!ӏʝ #z1 (#1más tarde !1F(#1el jueves !˰ #m-1p(#1esta tarde "Г %m-1p
91this evening'̮ /h1.(#1escuchar música ӏǬi 1h
91Sunday)泏7 3p16(#1ver la televisión ٓƆ ! 1(#1el martes سʁ7 !au17
91afterwards.ӭ =H1ӭ(#1¿Qué vas a hacer hoy? ɹ 1(#1primero #ӏo '>1Co(#1esta mañana 㓏ʁ7 au17(#1después !舧ǂ #1(#1el sábado '夛̍+ /xg1
+
91We’re going …쎓ɹ 1
91first(ܓ̮ 1h1.
91to listen to music ֻӏ 1F
91Thursday ӏǂ 1
91Saturday սӏi _51i(#1salir Կ K1(#1Mi semana Ըʹ r19
91finally)Ϻ 3w1\(#1Este fin de semana ϳӏɏ sGu1
91tonight Ƨ k1'
91Wednesday& -G 1P
91to go to the spa)ٻ7 3p16
91to watch television2Ʉӏ͔" Ew1"
91to go to the hairdresser’s"ӏ %w1\
91This weekend!ƠN #j[1fN(#1el viernes %ž蓏 + 1(#1(No) Voy a … » W1(#1el lunes !¢ɏ #sGu1(#1esta noche
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
4 |l[K:* tdSC2"
}
l
\
K
;
*
4 -Ze13 -Ze12 Uy1 1 Uy1 0 u1N/ u1N. m1- m1, aC1s+ aC1s* n1P) n1P( 川1.m' 川1.m& 1
% 1
$ c1# c1" w1\! w1\ jf19 jf19 a1 a1 1 1 a1 a1
1
1 91 91 ˯1p ˯1p |11CT |11CT 1Ӓ 1Ӓ ҫ1J
ҫ1J d1 d1
_1f4 _1f4 4+1F 4+1F ΅1& ΅1& O1 O1 ]K1 ]K1
^P?3$ # fieldModels0' modelsDeleted0 fields0' reviewHistory0 models0
stats0
cardTags0
media0
! cardModels0 sources0+ CdeckVarssqlite_autoindex_deckVars_112 1% mediaDeleted0
facts0
decks1% factsDeleted0
cards0% cardsDeleted0#tagsix_tags_tag3 1
eF'mN/
u
V
7
AӕJ.q`$p16-Ze1 AӕJ*p_51iUy1 AӕJ(w1" u1N AӕJ&%-fd1sξm1 AӕJ$۫G 1PaC1s AӕJ!`h1.n1P AӕJ xg1
+川1.m AӕJ n 11
AӕJ͈w1\c1 AӕJ6 r19w1\ AӕJuz1 jf19 AӕJ#Nau17a1 AӕJ [ةQ_121 AӕJ
oo1a1 AӕJsGu1
1 AӕJﮝm-1p91 AӕJ6]>1Co˯1p AӕJ 6zH1ӭ|11CT AӕIpҟ1h1Ӓ AӕI1ҫ1J AӕIȓj[1fNd1 AӕI1F_1f4 AӕI .k1'4+1F AӕI 1΅1& AӕIM W1O1 AӕIJAK1]K1
~qdWJ=0# |11CT n1P jf19 _1f4 ]K1 Uy1 4+1F -Ze1 u1N a1 a1 w1\ 川1.m c1
1 m1 ΅1& 91 ˯1p d1 1 1
O1 ҫ1J 1Ӓ aC1s
t`L8$p\H4
AӕJ.r-Ze1AӕJ*wUy1 AӕJ(+ u1NAӕJ&%оm1AӕJ$*aC1sAӕJ!ٗ n1PAӕJ 9川1.mAӕJ 1
AӕJ+c1AӕJ6Bw1\AӕJjf19AӕJ#a1 AӕJ \|1 AӕJ
p4a1AӕJǚ
1AӕJ91AӕJM˯1pAӕJ 7(g|11CTAӕI1ӒAӕIҫ1JAӕImjd1AӕI-M_1f4AӕI }4+1FAӕI.A΅1&AӕIO1AӕI]K1
t`L8$p\H4
AӕJ.qp16AӕJ*G_51iAӕJ(vSw1"AӕJ&%nd1sAӕJ$ʫG 1PAӕJ!\>h1.AӕJ xg1
+AӕJ W! 1AӕJw1\AӕJ6r19AӕJaz1 AӕJ#au17AӕJ \MQ_12AӕJ
po1AӕJlsGu1AӕJrm-1pAӕJ>1CoAӕJ 6H1ӭAӕI1hAӕIW1AӕI< j[1fNAӕIP1FAӕI ԑk1'AӕI 1AӕI W1AӕI K1
~qdWJ=0# |11CT n1P jf19 _1f4 ]K1 Uy1 4+1F -Ze1 u1N a1 a1 w1\ 川1.m c1
1 m1 ΅1& 91 ˯1p d1 1 1
O1 ҫ1J 1Ӓ aC1s
|fP:$t^H2
@ |11CT@ n1P@ jf19@ _1f4@ ]K1@ Uy1 @ 4+1F@ -Ze1@ u1N@ a1 @ a1@ w1\@ 川1.m@ c1@
1@ m1@ ΅1&@ 91@ ˯1p@ d1@ 1 @ 1
@ O1@ ҫ1J@ 1Ӓ@ aC1s
t`L8$p\H4
z1 jf19xg1
+川1.msGu1
1r19w1\h1.n1P_51iUy1 Q_121 >1Co˯1pw1" u1N1a1j[1fNd1p16-Ze1 1΅1&au17a1 1ҫ1J1F_1f4H1ӭ|11CTG 1PaC1s 11
1h1Ӓm-1p91k1'4+1Fw1\c1d1sξm1K1]K1 W1O1
!2011-08-24! 2011-08-24
4 t`L8$p\H4
l
X
D
0
| h T @ , z1 n[1 z1 &xE1 xg1
+Ve1
+xg1
+ʐ1
+sGu1E1sGu11r19j=19r19g19h1. Ї1.h1.1._51iIZ1i_51iM1iQ_12P13Q_12>I)12>1Coc+1Cp>1Cou1Cow1"Z)i1"w1"1"1?11q1j[1fN?1fNj[1fNQ1fNp16c317p16e17 1c1 11au17B17au17171!91111F#~1F1Fڬm1FH1ӭ11ӭH1ӭg1ӭG 1P>)1PG 1P31P 1H1 1A11hNU1i1h=1im-1p-1pm-1p 1pk1'H 1'k1' s1'w1\ʞ1\w1\ʏ1\d1sV1sd1s:e1sK17`1 K11 W1i11 W11
4 t`L8$p\H4
l
X
D
0
| h T @ , (#1j=19(#1Z)i1"(#1V1s(#1Ve1
+(#1NU1i(#1H 1'(#1>)1P(#1>I)12(#1&xE1 (#1#~1F(#1-1p(#1 Ї1.(#1c317(#11(#1g1ӭ(#1?1(#1u1Co(#117(#1!91(#1M1i(#11 (#11\(#1Q1fN(#1A1(#11(#11
91n[1
91i11
91c1
91c+1Cp
91P13
91IZ1i
91H1
91?1fN
91:e1s
917`1
9111ӭ
91 1p
91=1i
91B17
91ʐ1
+
91q1
911.
91m1F
911
91g19
91E1
91 s1'
9131P
91e17
911"
911\
4 ~lYE3jU>(
h
Q
>
-
r ` P 8 k X 9 #=¿Qué vas a hacer hoy? g1ӭ 3ver la televisión c317tonightE1 3to watch televisione17 1to listen to music1.-to go to the spa31P'Eto go to the hairdresser’s1" 3to go to the casino:e1s to go outIZ1i%this morningc+1Cp%this evening 1pthenP13salir M1i primero ?1%por último j=19#más tarde &xE1 luego >I)12latern[1 'ir al casino V1s-ir al balneario >)1P 5ir a la peluquería Z)i1"firstq1finallyg19#esta tarde -1p#esta noche 1'esta mañana u1Co /escuchar música Ї1.#el viernes Q1fN#el sábado !91)el miércoles H 1'!el martes 1 el lunes 1!el jueves #~1F#el domingo NU1i después 17!afterwardsB17*KWhat are you going to do today?11ӭ /We’re going …ʐ1
+ Wednesday s1'#Vamos a …Ve1
+Tuesdayc1 Thursdaym1F%This weekend1\Sunday=1i Saturday1My week7`1 Mondayi11 Mi semana1 7I’m (not) going …H1Friday?1fN 3Este fin de semana 1\+(No) Voy a … A1
4 yj[L=. {l]N?0!
|
m
^
O
@
1
"
|11CTn1P*jf19 _1f4
]K1Uy1 24+1F-Ze14 u1N0a1 a1w1\"川1.m(c1$
1m1.΅1&91˯1pd1 1 1
&O1ҫ1J1ӒaC1s,|11CTn1P)jf19 _1f4
]K1Uy1 14+1F-Ze13 u1N/a1 a1w1\!川1.m'c1#
1m1-΅1&91˯1pd1 1 1
%O1ҫ1J
1ӒaC1s+
4
] ~qdWJ=0# zm`SF9,
w
j
] |11CT |11CT n1P* n1P) jf19 jf19 _1f4
_1f4 ]K1 ]K1 Uy1 2 Uy1 1 4+1F 4+1F -Ze14 -Ze13 u1N0 u1N/ a1 a1 a1 a1 w1\" w1\! 川1.m( 川1.m' c1$ c1#
1
1 m1. m1- ΅1& ΅1& 91 91 ˯1p ˯1p d1 d1 1 1 1
& 1
% O1 O1 ҫ1J ҫ1J
1Ӓ 1Ӓ aC1s, aC1s+
xV4hF$
z
X
6
!z1 AӕJujf19!xg1
+AӕJ 川1.m!sGu1AӕJ
1!r19AӕJ6 w1\!h1.AӕJ!`n1P!_51iAӕJ*pUy1 !Q_12AӕJ [ة1 !>1CoAӕJ6]˯1p!w1"AӕJ( u1N!1AӕJ
ooa1!j[1fNAӕIȓd1!p16AӕJ.q`$-Ze1! 1AӕI΅1&!au17AӕJ#Na1 !1AӕI܌ҫ1J!1FAӕI_1f4!H1ӭAӕJ 6z|11CT!G 1PAӕJ$ۅaC1s! 1AӕJ n1
!1hAӕIpҊ1Ӓ!m-1pAӕJ﮸91!k1'AӕI .4+1F!w1\AӕJ͈c1!d1sAӕJ&%-fm1!K1AӕIJA]K1! W1AӕIMO1
X.\2
`
6
d : )AӕJ.q`$p16AӕJ.q`$-Ze1)AӕJ*p_51iAӕJ*pUy1 )AӕJ(w1"AӕJ( u1N)AӕJ&%-fd1sAӕJ&%-fm1)AӕJ$۫G 1PAӕJ$ۅaC1s)AӕJ!`h1.AӕJ!`n1P)AӕJ xg1
+AӕJ 川1.m)AӕJ n 1AӕJ n1
)AӕJ͈w1\AӕJ͈c1)AӕJ6 r19AӕJ6 w1\)AӕJuz1 AӕJujf19)AӕJ#Nau17AӕJ#Na1 )AӕJ [ةQ_12AӕJ [ة1 )AӕJ
oo1AӕJ
ooa1)AӕJsGu1AӕJ
1)AӕJﮝm-1pAӕJ﮸91)AӕJ6]>1CoAӕJ6]˯1p)AӕJ 6zH1ӭAӕJ 6z|11CT)AӕIpҟ1hAӕIpҊ1Ӓ)AӕI1AӕI܌ҫ1J)AӕIȓj[1fNAӕIȓd1)AӕI1FAӕI_1f4)AӕI .k1'AӕI .4+1F)AӕI 1AӕI΅1&)AӕIM W1AӕIMO1)AӕIJAK1AӕIJA]K1
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
G
p
4Y.] kŮӏN)
w1"/[1AӕJ(AӕJ(+ir a la peluquería to go to the hairdresser’sAӕJ(@ @ AӕJ(L̓ʜ'
ooau17/[1AӕJ#NAӕJ#después afterwardsAӕJ#N@ @ AӕJ#NF̓'
me1/[1AӕJ
ooAӕJ
p4primero firstAӕJ
oo@ @ AӕJ
ooL'
uir19/[1AӕJ6 AӕJ6Bpor último finallyAӕJ6 @ @ AӕJ6 Uӏ̮m'
s}xg1
+/[1AӕJ AӕJ 9Vamos a …We’re going …AӕJ @ @ AӕJ Y(
sw1\/[1AӕJ͈AӕJ+Este fin de semana This weekendAӕJ͈@ @ AӕJ͈K允ӏɹ'
sisGu1/[1AӕJAӕJǚesta noche tonightAӕJ@ @ AӕJρZߠӏ͔(
wd1s/[1AӕJ&%-fAӕJ&%ir al casino to go to the casinoAӕJ&%-f@ @ AӕJ&%-fJݳӏƦ'
qi 1/[1AӕIAӕI.Ael martes TuesdayAӕI@ @ AӕIPܦǓɏ'
ssm-1p/[1AӕJAӕJesta tarde this eveningAӕJ@ @ AӕJﮁR'
ws>1Co/[1AӕJ6]AӕJMesta mañana this morningAӕJ6]@ @ AӕJ6]Jљǂ'
sgj[1fN/[1AӕIȓAӕImjel viernes FridayAӕIȓ@ @ AӕIȓC̥ʁ '
icQ_12/[1AӕJ [ةAӕJ \|luego thenAӕJ [ة@ @ AӕJ [ة^ʶӏ̍(
{ 1/[1AӕJ nAӕJ (No) Voy a … I’m (not) going …AӕJ n@ @ AӕJ nHƺƆ'
og W1/[1AӕIMAӕIel lunes MondayAӕIM@ @ AӕIMLƴճǬJ'
sk1/[1AӕIAӕIel sábado SaturdayAӕI@ @ AӕI܁JŦӒ'
sg1h/[1AӕIpAӕIel domingo SundayAӕIp@ @ AӕIpҁYب'
}{G 1P/[1AӕJ$AӕJ$*ir al balneario to go to the spaAӕJ$@ @ AӕJ$
9
f
rT)
H1ӭ/[1AӕJ 6zAӕJ 7(g¿Qué vas a hacer hoy? What are you going to do today?AӕJ 6z@ @ AӕJ 6z\'
h1./[1AӕJ!`AӕJ!ٗ escuchar música to listen to musicAӕJ!`@ @ AӕJ!`I֓ʹ'
sez1 /[1AӕJuAӕJmás tarde laterAӕJu@ @ AӕJuKӏ4'
qk1F/[1AӕIAӕI-Mel jueves ThursdayAӕI@ @ AӕIIɳ'
oiK1/[1AӕIJAAӕIMi semanaMy weekAӕIJA@ @ AӕIJAHϓ '
im_51i/[1AӕJ*pAӕJ*wsalir to go outAӕJ*p@ @ AӕJ*pPųƿ'
ymk1'/[1AӕI .AӕI }el miércoles WednesdayAӕI .@ @ AӕI .aӏΕ)
p16/[1AӕJ.q`$AӕJ.rver la televisión to watch televisionAӕJ.q`$@ @ AӕJ.q`$
; \
=
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