SQLite format 3 @ 0 2 N - 0=- 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
/
AӔ͋AӔ͋BasicBasic?<
" !2011-08-22" !2011-08-22
Y uyjY pageSize4096
hexCache{}
cssCache !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 pageSize) suspendLeeches!revSpacing #revInactive
revActive
perDay!newSpacing#newInactive
newActive mediaURL !leechFails latexPre
latexPost hexCache cssCache
$ӏ
:?1kFrontArial1#ƴ̳
:?1kBackArial1
" " e
:?1kForward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFFe͂ɳ
:?1kReverse%(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)
)
& c#[
V
a & 13
/ :?1kAӔm AӔnT
una mesa a table1׃ӏ;
/ :?1kAӔA7vAӔApósters posters3ӏ
3 :?1kAӔ AӔ una alfombra a rug2q
1 :?1kAӔ
pAӔŁuna puerta a door7Æh
; :?1kAӔnAӔ2un ordenador a computer/ӏ
+ :?1kAӔ=ٶAӔ>Muna cama a bed=ӏ
G :?1kAӔ,AӔi4una televisión a television1ű
/ :?1kAӔAӔ!una silla a chair@ġ"
M :?1kAӔJ#AӔ̿una estantería a shelf/shelves88
= :?1kAӔϙAӔϚGMi dormitorio My bedroom=-
G :?1kAӔwAӔxpun equipo de música a hi-fi5
7 :?1kAӔnAӔCuna ventana a window6I
9 :?1kAӔ@rAӔ@un armario a wardrobeUӏ
w :?1kAӔОAӔC9En mi dormitorio hay … In my bedroom there’s …4ŝ
5 :?1kAӔ ZAӔ suna lámpara a lamp
|%
-%#
AӔ}AӔBeMA:?1k? XPriorityVeryHighPriorityHighPriorityLowX8@
0
] {
Fb Oӏ'
sqכ1I; 1kAӔ@rAӔAun armario a wardrobeAӔ@r@ @ AӔ@rV'
}u4G}1q; 1kAӔ,AӔEuna televisión a televisionAӔ,@ @ AӔ,L'
wgBO1L
; 1kAӔ AӔ J8una alfombra a rugAӔ @ @ AӔ M'
wivg1; 1kAӔ ZAӔ 9una lámpara a lampAӔ Z@ @ AӔ ZP'
uq9 71h; 1kAӔnAӔ un ordenadora computerAӔn@ @ AӔnY'
}{+ 1"; 1kAӔJ#AӔ-una estantería a shelf/shelvesAӔJ#@ @ AӔJ#J '
okk\ 1;; 1kAӔA7vAӔAspósters postersAӔA7v@ @ AӔA7vNҳ '
umSO1; 1kAӔnAӔuna ventana a windowAӔn@ @ AӔnQ'
wq1p8; 1kAӔϙAӔϚPeMi dormitorioMy bedroomAӔϙ@ @ AӔϙ́JӏV'
okw&13; 1kAӔm AӔn<una mesa a tableAӔm @ @ AӔm Kޓ'
si>Ń1 q; 1kAӔ
pAӔŴ_una puerta a doorAӔ
p@ @ AӔ
pWM(
khI1-; 1kAӔwAӔx7
un equipo de música a hi-fiAӔw@ @ AӔwHŨ㓏'
og8 E1; 1kAӔ=ٶAӔ>|(una cama a bedAӔ=ٶ@ @ AӔ=ٶJêz'
ok-1D; 1kAӔAӔQnuna sillaa chairAӔ@ @ AӔpÍ/)
F1; 1kAӔОAӔtEn mi dormitorio hay … In my bedroom there’s …AӔО@ @ AӔО
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)
[1 S$
b
;
a 1 b ;
֘3 w&13(1kuna mesa ų3 w&13c1ka table < k\ 1;c1kposters ӏi !9 71hc1ka computerӏ 8 E1c1ka bed I !כ1Ic1ka wardrobe#蓏 'BO1L
(1kuna alfombra ӏ 8 E1(1kuna cama & -4G}1q(1kuna televisión " %4G}1qc1ka television&" -+ 1"(1kuna estantería !dzq #>Ń1 q(1kuna puerta ̓- hI1-c1ka hi-fi"͛ %SO1(1kuna ventana -1Dc1ka chair -1D(1kuna silla+ӏ- 7hI1-(1kun equipo de música !תI #כ1I(1kun armario /Ɀ ?F1(1kEn mi dormitorio hay … %촓# ++ 1"c1ka shelf/shelves"ޗӏi %9 71h(1kun ordenador1ۯӏ CF1ߌc1kIn my bedroom there’s … ӏ SO1ٌc1ka window ; k\ 1;(1kpósters ӏ vg1c1ka lamp ʏܓ; !1p8c1kMy bedroom#Ȑӏ 'vg1(1kuna lámpara Ǐ BO1L
c1ka rug LJr >Ń1 qc1ka door#´; '1p8(1kMi dormitorio
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow
|l[K:* tdSC2" 1 1 1 1 N1 N1 ?1qz ?1qz r1C r1C }1 V }1 V 2H11 2H11 t1 t1 1
1 7W1 7W1
a1K a1K 1M 1M t1 t1 71/ 71/ 1 1
}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
/ eF'mN/ AӔA7vk\ 1;1 AӔnSO11 AӔ,4G}1qN1 AӔ-1D?1qz AӔ
p>Ń1 qr1C AӔm w&13}1 V AӔ Zvg12H11 AӔJ#+ 1"t1 AӔ=ٶ8 E11 AӔ BO1L
7W1 AӔn9 71h a1K AӔwhI1-1M AӔ@rכ1It1 AӔОF1߆71/ AӔϙ1p81
= ~qdWJ= t1 N1 7W1 2H11 a1K t1 1 1 1 }1 V r1C 1M 1 ?1qz 71/
t`L8$ AӔAs1 AӔ1 AӔEN1AӔQn?1qzAӔŴ_r1CAӔn<}1 VAӔ 92H11AӔ-t1AӔ>|(1AӔ J87W1AӔ a1KAӔx7
1MAӔAt1AӔt71/AӔϚPe1
t`L8$ AӔAk\ 1;AӔCSO1AӔi44G}1qAӔ!-1DAӔŁ>Ń1 qAӔnT
w&13AӔ svg1AӔ̿+ 1"AӔ>M8 E1AӔ BO1L
AӔ29 71hAӔxphI1-AӔ@ټכ1IAӔC9F1AӔϚG1p8
= ~qdWJ= t1 N1 7W1 2H11 a1K t1 1 1 1 }1 V r1C 1M 1 ?1qz 71/
|fP:$ @ t1@ N1@ 7W1@ 2H11@ a1K@ t1@ 1 @ 1 @ 1@ }1 V@ r1C@ 1M@ 1@ ?1qz@ 71/
t`L8$ w&13}1 Vk\ 1;1 BO1L
7W1>Ń1 qr1C9 71h a1K8 E114G}1qN1-1D?1qz+ 1"t11p81hI1-1MSO11 כ1It1F1߆71/vg12H11
!2011-08-22! 2011-08-22
t`L8$p\H4
w&13X13w&13|+13k\ 1;zlw1<k\ 1;1;BO1L
2A1LBO1L
< 1L>Ń1 qz;1 q>Ń1 q 1 r9 71hht1i9 71h\1i8 E1f=18 E12S14G}1q,'1q4G}1q)1q-1Dq1D-1D1D+ 1" 1"+ 1"1#1p8>1p;1p81p;hI1- a1-hI1-U1-SO1 41SO1ٟ1כ1I1p;c1k< 1Lc1k 1 r
C taK9&kT3
w
[
C %una ventana 41-una televisión ,'1q una silla1D#una puerta z;1 q una mesa X13'una lámpara B1-una estantería 1" una cama 2S1'una alfombra 2A1L%un ordenador\1i 7un equipo de música U1-#un armario ]W1I pósters 1;posterszlw1< a window1!a wardrobe1p;'Mi dormitorio1p;&CIn my bedroom there’s …1$?En mi dormitorio hay … 1
? zk\M>/ {l]N? t1N17W1 2H11 a1K
t11 1 1}1 Vr1C1M1?1qz71/t1N17W1 2H11 a1K t11 1
1}1 Vr1C1M1
?1qz71/
{ ~qdXK>1$
{ t1 t1 N1 N1 7W1 7W1 2H11 2H11 a1K
a1K t1 t1 1 1 1 1 1 1 }1 V }1 V r1C r1C 1M 1M 1 1
?1qz ?1qz 71/ 71/
xV4hF$ !w&13AӔm }1 V!k\ 1;AӔA7v1 !BO1L
AӔ 7W1!>Ń1 qAӔ
pr1C!9 71hAӔn a1K!8 E1AӔ=ٶ1!4G}1qAӔ,N1!-1DAӔ솩?1qz!+ 1"AӔJ#t1!1p8AӔϙ1!hI1-AӔw1M!SO1AӔn1 !כ1IAӔ@rt1!F1AӔО71/!vg1AӔ Z2H11
X.\2
)AӔA7vk\ 1;AӔA7v1 )AӔnSO1AӔn1 )AӔ,4G}1qAӔ,N1)AӔ-1DAӔ솩?1qz)AӔ
p>Ń1 qAӔ
pr1C)AӔm w&13AӔm }1 V)AӔ Zvg1AӔ Z2H11)AӔJ#+ 1"AӔJ#t1)AӔ=ٶ8 E1AӔ=ٶ1)AӔ BO1L
AӔ 7W1)AӔn9 71hAӔn a1K)AӔwhI1-AӔw1M)AӔ@rכ1IAӔ@rt1)AӔОF1AӔО71/)AӔϙ1p8AӔϙ1
-PriorityVeryHigh# PriorityLow%PriorityHigh Forward Basic
; \
=
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