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 pageSize4096g ChexCache{"1672431067899772262": "1735ab32017e3d66", "-5308944400943006363": "b652d732017e3d65", "-7276889894755091099": "9b034b32017e3d65", "-1078709752516690586": "f107a732017e3d66", "-6807717288066794139": "a1862132017e3d65"}(
EcssCache.fma1862132017e3d65 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
.fmb652d732017e3d65 {font-family:"Arial";font-size:20px;white-space:pre-wrap;}
#cmqf107a732017e3d66 {text-align:center;}
#cmq1735ab32017e3d66 {text-align:center;}
#cmaf107a732017e3d66 {text-align:center;}
#cma1735ab32017e3d66 {text-align:center;}
.cmbf107a732017e3d66 {background:#FFFFFF;}
.cmb1735ab32017e3d66 {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
/鳐e
Aӕ|*Aӕ|* BasicBasic?<
" !2011-08-25" !2011-08-25
$۔e
K2~=eFrontArial1#ēe
K2~=eBackArial1
" " e͵f
K2~=eForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFef
K2~=eReverse%(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)
)
U P}1
v
W R
U :Ӑ
A K2~=eAӕTAӕTrA ver … Let’s see …:Ӑ
A K2~=eAӕSMAӕS
Está aquí. It’s here.kӐě
! K2~=eAӕAAӕBiToma la segunda calle a la derecha. Take the second (street) on the right.:
A K2~=eAӕ$oAӕ%Las direcciones DirectionsAg
O K2~=eAӕAӕDobla a la izquierda. Turn left.lc
# K2~=eAӕ5AӕfToma la segunda calle a la izquierda. Take the second (street) on the left.aӐ
K2~=eAӕAӕ(Está) al final de la calle. (It’s) at the end of the street.Bг=
Q K2~=eAӕz Aӕ{6Sigue todo recto. Go straight on.^>
K2~=eAӕ5xAӕ5¿Dónde está el museo Picasso? Where is the Picasso Museum?@Ӑ[
M K2~=eAӕPAӕTDobla a la derecha. Turn right.+㳐f
# K2~=eAӕCAӕX luego then2
1 K2~=eAӕ~Aӕ~Bueno … Well …BӐ
Q K2~=eAӕϷAӕCCruza la plaza. Cross the square.:鳐
A K2~=eAӕ`AӕԻPerdón … Excuse me …IW
_ K2~=eAӕbAӕbUEstá a la derecha. It’s on the right.2Ӑ.
1 K2~=eAӕAӕPues … Well …Iڒ
_ K2~=eAӕVAӕEstá a la izquierda. It’s on the left.SİӐ
s K2~=eAӕAӕu¿Dónde están las Ramblas? Where are the Ramblas?
Y Y $%
M -%#
Aӕ||AӕTAK2~=e869aba1a4ae01ed449ff5df31fc8812dAӕv:? XPriorityVeryHighPriorityHighPriorityLowX8@ 1 ~ t
_ b- > dӐ)
2W52~=fAӕbAӕbEstá a la derecha. It’s on the right.Aӕb@ @ AӕbˁZL(
s 52[52~=fAӕPAӕDobla a la derecha. Turn right.AӕP@ @ AӕPKdz'
omh_2! 52~=fAӕ~Aӕ~Bueno …Well …Aӕ~@ @ Aӕ~|泐)
%x2~>52~=fAӕ5xAӕ6¿Dónde está el museo Picasso?
Where is the Picasso Museum?Aӕ5x@ @ Aӕ5xS$'
uwK2~b52~=fAӕ`Aӕ )Perdón … Excuse me …Aӕ`@ @ Aӕ`[̓(
qH2 2g52~=fAӕAӕาDobla a la izquierda. Turn left.Aӕ@ @ AӕSƓ'
q{o[2~52~=fAӕTAӕTA ver … Let’s see …AӕT@ @ AӕT H)
+)]2D52~=fAӕAAӕBToma la segunda calle a la derecha.
Take the second (street) on the right.AӕA@ @ AӕA\?(
{"n2=52~=fAӕz Aӕ{prSigue todo recto. Go straight on.Aӕz @ @ Aӕz KK'
om˓2b.52~=fAӕAӕPues … Well …Aӕ@ @ Aӕrz)
2~ 52~=fAӕAӕ¿Dónde están las Ramblas?
Where are the Ramblas?Aӕ@ @ Aӕ
)
/'@W2c52~=fAӕ5AӕToma la segunda calle a la izquierda.
Take the second (street) on the left.Aӕ5@ @ Aӕ5㐺Ӑ;)
!. 252~=fAӕAӕ7 (Está) al final de la calle.
(It’s) at the end of the street.Aӕ@ @ AӕdӐ)
h252~=fAӕVAӕ .Está a la izquierda.It’s on the left.AӕV@ @ AӕVD"'
ie2f52~=fAӕCAӕluego thenAӕC@ @ AӕC[Ā'
}2#52~=fAӕϷAӕs Cruza la plaza. Cross the square.AӕϷ@ @ AӕϷSվӐ'
wu`2>52~=fAӕSMAӕSEstá aquí. It’s here.AӕSM@ @ 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)
$ B k'
q
B
? W +
l
6
j B =ě []2DR2~=eToma la segunda calle a la derecha.
&Ӑ -2#R2~=eCruza la plaza. h_2! !2~=eWell …2Ӑ? Ex2~>!2~=eWhere is the Picasso Museum?8Ӑ Q. 2!2~=e(It’s) at the end of the street.f 2f!2~=ethen ʳg !H2 2g!2~=eTurn left.,Ӑg 9H2 2gR2~=eDobla a la izquierda. *ӐW 52W!2~=eIt’s on the right.;ɑc W@W2c!2~=eTake the second (street) on the left.<ě Y]2D!2~=eTake the second (street) on the right."䓐 %`2>ԡ!2~=eIt’s here. Ӑ !\2~A!2~=eDirections#ҷ '`2>ԶR2~=eEstá aquí. !o[2~R2~=eA ver … *W 52WR2~=eEstá a la derecha. ) 3h2!2~=eIt’s on the left.6Ӑ M2~ R2~=e¿Dónde están las Ramblas?
+ 7h2R2~=eEstá a la izquierda.%ճ +\2~AR2~=eLas direcciones h_2! R2~=eBueno …, 92~ !2~=eWhere are the Ramblas?%ó= +"n2=!2~=eGo straight on.(Ɠ= 1"n2=R2~=eSigue todo recto. "ݸ %K2~bR2~=ePerdón … ڑγ. ˓2b.R2~=ePues … %ڃ +o[2~!2~=eLet’s see …:ּ> Ux2~>R2~=e¿Dónde está el museo Picasso?
!Ց㓐[ # 52[!2~=eTurn right. Ә/ ˓2b.!2~=eWell …# 'K2~b!2~=eExcuse me …'Р /2#!2~=eCross the square. ˧鳐f 2fR2~=eluego ?Ӑc _@W2cR2~=eToma la segunda calle a la izquierda.
7Ű O. 2R2~=e(Está) al final de la calle.
*듐[ 5 52[R2~=eDobla a la derecha.
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
$
|l[K:* tdSC2"
$ ]2c# ]2c" #M2>! #M2> u2 u2 A2; A2; ǚ2 ǚ2 ,UK2H ,UK2H Oo2D Oo2D KNa2# KNa2# q2L q2L q2? q2? ŕ2" ŕ2" 2K
2K j;2b j;2b
F612! F612! 2~z 2~z ]#32~ ]#32~ RS2~$ RS2~$ v2~b v2~b
^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/
AӕSM`2>Ԫ]2c AӕVh2#M2> Aӕb2Wu2 Aӕ. 2A2; Aӕ5@W2cǚ2 AӕA]2D,UK2H AӕϷ2#Oo2D AӕH2 2gKNa2# AӕP 52[q2L Aӕz "n2=q2? AӕC2fŕ2" Aӕ˓2b.2K Aӕ~h_2! j;2b AӕTo[2~F612! Aӕ2~ 2~z Aӕ5xx2~>]#32~ Aӕ`K2~bRS2~$ Aӕ$o\2~Av2~b
~qdWJ=0# v2~b u2 q2L j;2b ]#32~ RS2~$ KNa2# F612! ,UK2H q2? 2K 2~z ǚ2 A2; #M2> ŕ2" Oo2D ]2c
t`L8$ AӕSǪ]2cAӕ .#M2>Aӕbu2Aӕ7 A2;Aӕǚ2AӕB,UK2HAӕs Oo2DAӕาKNa2#Aӕq2LAӕ{prq2?Aӕŕ2"Aӕ2KAӕ~j;2bAӕTF612!Aӕ2~zAӕ6]#32~Aӕ )RS2~$Aӕ%v2~b
t`L8$ AӕS
`2>Aӕؙh2AӕbU2WAӕ. 2Aӕf@W2cAӕBi]2DAӕC2#AӕH2 2gAӕT 52[Aӕ{6"n2=AӕX 2fAӕ˓2b.Aӕ~h_2! AӕTro[2~Aӕu2~ Aӕ5x2~>AӕԻK2~bAӕ%\2~A
~qdWJ=0# v2~b u2 q2L j;2b ]#32~ RS2~$ KNa2# F612! ,UK2H q2? 2K 2~z ǚ2 A2; #M2> ŕ2" Oo2D ]2c
t |fP:$t @ v2~b@ u2@ q2L@ j;2b@ ]#32~@ RS2~$@ KNa2#@ F612!@ ,UK2H@ q2?@ 2K@ 2~z@ ǚ2@ A2;@ #M2>@ ŕ2"@ Oo2D@ ]2c
t`L8$ o[2~F612!`2>Ԫ]2c]2D,UK2H\2~Av2~bH2 2gKNa2#@W2cǚ2. 2A2;"n2=q2?x2~>]#32~ 52[q2L2fŕ2"h_2! j;2b2#Oo2DK2~bRS2~$2Wu2˓2b.2Kh2#M2>2~ 2~z
!2011-08-25! 2011-08-25
$
0 t`L8$p\H4
l
X
D
0 o[2~2~o[2~h 2~`2>"!2>`2>I2>]2Dr2D]2D"Y2D\2~A ?52~A\2~A2~AH2 2g:BS2gH2 2g42g@W2c-$2c@W2c52c. 2C=2 . 2S2 "n2=β2="n2=^12=x2~>X]2~?x2~>2~> 52[G2[ 52[wY2[2f<2f2fK2fh_2! b+g2! h_2! _2! 2#d2#2#y2#K2~b2~bK2~b82~b2W/2W2W 52W˓2b.Fs2b.˓2b.`2b/h2_2h2j22~ 52~ 2~ 92~
$
0 t`L8$p\H4
l
X
D
0 R2~=er2DR2~=ed2#R2~=e42gR2~=eI2>R2~=e2~R2~=e 52WR2~=e52~ R2~=ej2R2~=e2~AR2~=e_2! R2~=e^12=R2~=e2~bR2~=eFs2b.R2~=e2~>R2~=eK2fR2~=e52cR2~=eS2 R2~=ewY2[!2~=eb+g2! !2~=eX]2~?!2~=eC=2 !2~=e<2f!2~=e:BS2g!2~=e/2W!2~=e-$2c!2~=e"Y2D!2~=e"!2>!2~=e ?52~A!2~=e_2!2~=e92~ !2~=eβ2=!2~=eh 2~!2~=eG2[!2~=e`2b/!2~=e82~b!2~=ey2#
$ z]A+ v[C$
R
w c A +M¿Dónde están las Ramblas?
52~ /U¿Dónde está el museo Picasso?
2~>then<2fluego K2f'EWhere is the Picasso Museum?X]2~?!9Where are the Ramblas?92~ Well …b+g2! Well …`2b/#Turn right.G2[!Turn left.:BS2g4_Toma la segunda calle a la izquierda.
52c2[Toma la segunda calle a la derecha.
r2D1YTake the second (street) on the right."Y2D0WTake the second (street) on the left.-$2c 1Sigue todo recto. ^12= Pues … Fs2b.%Perdón … 2~b+Let’s see …h 2~+Las direcciones2~A 5It’s on the right./2W 3It’s on the left._2%It’s here."!2>+Go straight on.β2='Excuse me …82~b'Está aquí. I2> 7Está a la izquierda.j2 5Está a la derecha. 52W!9Dobla a la izquierda. 42g 5Dobla a la derecha. wY2[!Directions ?52~A-Cruza la plaza. d2# /Cross the square.y2# Bueno …_2! !A ver … 2~-Q(It’s) at the end of the street.C=2 ,O(Está) al final de la calle.
S2
$
yj[L=. {l]N?0!
v2~bu2 q2Lj;2b ]#32~RS2~$KNa2#F612!
,UK2Hq2?2K2~zǚ2 A2; #M2>"ŕ2"Oo2D]2c$
v2~bu2 q2Lj;2b ]#32~RS2~$KNa2#F612! ,UK2Hq2?2K
2~zǚ2A2; #M2>!ŕ2"Oo2D]2c#
$- ~qdWJ=0# zm`SF:- v2~b v2~b u2 u2 q2L q2L j;2b j;2b ]#32~ ]#32~ RS2~$ RS2~$ KNa2# KNa2# F612!
F612! ,UK2H ,UK2H q2? q2? 2K 2K
2~z 2~z ǚ2 ǚ2 A2; A2; #M2>" #M2>! ŕ2" ŕ2" Oo2D Oo2D ]2c$ ]2c#
xV4hF$
!o[2~AӕTF612!!`2>AӕSM]2c!]2DAӕA,UK2H!\2~AAӕ$ov2~b!H2 2gAӕKNa2#!@W2cAӕ5ǚ2!. 2AӕA2;!"n2=Aӕz q2?!x2~>Aӕ5x]#32~! 52[AӕPq2L!2fAӕCŕ2"!h_2! Aӕ~j;2b!2#AӕϷOo2D!K2~bAӕ`RS2~$!2WAӕbu2!˓2b.Aӕ2K!h2AӕV#M2>!2~ Aӕ2~z
X.\2
`
6
)AӕSM`2>AӕSM]2c)AӕVh2AӕV#M2>)Aӕb2WAӕbu2)Aӕ. 2AӕA2;)Aӕ5@W2cAӕ5ǚ2)AӕA]2DAӕA,UK2H)AӕϷ2#AӕϷOo2D)AӕH2 2gAӕKNa2#)AӕP 52[AӕPq2L)Aӕz "n2=Aӕz q2?)AӕC2fAӕCŕ2")Aӕ˓2b.Aӕ2K)Aӕ~h_2! Aӕ~j;2b)AӕTo[2~AӕTF612!)Aӕ2~ Aӕ2~z)Aӕ5xx2~>Aӕ5x]#32~)Aӕ`K2~bAӕ`RS2~$)Aӕ$o\2~AAӕ$ov2~b
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
> "<
m ~ t
_ b- > dӐ)
2W52~=fAӕbAӕbEstá a la derecha. It’s on the right.Aӕb@ @ AӕbˁZL(
s 52[52~=fAӕPAӕDobla a la derecha. Turn right.AӕP@ @ AӕPKdz'
omh_2! 52~=fAӕ~Aӕ~Bueno …Well …Aӕ~@ @ Aӕ~|泐)
%x2~>52~=fAӕ5xAӕ6¿Dónde está el museo Picasso?
Where is the Picasso Museum?Aӕ5x@ @ Aӕ5xS$'
uwK2~b52~=fAӕ`Aӕ )Perdón … Excuse me …Aӕ`@ @ Aӕ`[̓(
qH2 2g52~=fAӕAӕาDobla a la izquierda. Turn left.Aӕ@ @ AӕSƓ'
q{o[2~52~=fAӕTAӕTA ver … Let’s see …AӕT@ @ AӕT H)
+)]2D52~=fAӕAAӕBToma la segunda calle a la derecha.
Take the second (street) on the right.AӕA@ @ AӕA\?(
{"n2=52~=fAӕz Aӕ{prSigue todo recto. Go straight on.Aӕz @ @ Aӕz KK'
om˓2b.52~=fAӕAӕPues … Well …Aӕ@ @ Aӕrz)
2~ 52~=fAӕAӕ¿Dónde están las Ramblas?
Where are the Ramblas?Aӕ@ @ Aӕ
)
/'@W2c52~=fAӕ5AӕToma la segunda calle a la izquierda.
Take the second (street) on the left.Aӕ5@ @ Aӕ5㐺Ӑ;)
!. 252~=fAӕAӕ7 (Está) al final de la calle.
(It’s) at the end of the street.Aӕ@ @ AӕdӐ)
h252~=fAӕVAӕ .Está a la izquierda.It’s on the left.AӕV@ @ AӕVD"'
ie2f52~=fAӕCAӕluego thenAӕC@ @ AӕC[Ā'
}2#52~=fAӕϷAӕs Cruza la plaza. Cross the square.AӕϷ@ @ AӕϷSվӐ'
wu`2>52~=fAӕSMAӕSEstá aquí. It’s here.AӕSM@ @ AӕSM
" " S'
{q\2~A52~=fAӕ$oAӕ%Las direccionesDirectionsAӕ$o@ @ Aӕ$o
; \
=
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