SQLite format 3 @ / j K 1
!!-tablecardModelscardModelsCREATE 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),
FOREIGN KEY("modelId") REFERENCES models (id)
)/ %%!tablefactsDeletedfactsDeleted
CREATE TABLE "factsDeleted" (
"factId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("factId") REFERENCES facts (id)
)vKtablefactsfacts CREATE TABLE facts (
id INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
"spaceUntil" FLOAT NOT NULL,
"lastCardId" INTEGER,
PRIMARY KEY (id),
FOREIGN KEY("modelId") REFERENCES models (id),
CONSTRAINT "lastCardIdfk" FOREIGN KEY("lastCardId") REFERENCES cards (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),
CONSTRAINT "deckIdfk" FOREIGN KEY("deckId") REFERENCES decks (id)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars`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)
);''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
" !2010-06-24" !2010-06-24
pageSize4096!leechFails16)suspendLeeches1
pageSize) suspendLeeches!leechFails
/˝2
A8A8BasicBasic?< @~qdWJ=0# d:h>
l
B
p F tJ xN$|R(V,Z0^4
b8f< ŗ˝
K)gDw2A@A@ ŎӲ˝
K)gDw2A@hA@h ˝
K)gDw2A@zA@ ˝
K)gDw2A@TA@h ˝
K)gDw2A@A@h 컒˝
K)gDw2A@A@ ˝
K)gDw2A@QA@ 緒˝
K)gDw2A@A@h ˝
K)gDw2A@!A@h 撲˝
K)gDw2A@A@ ˝
K)gDw2A@A@h ަ˝
K)gDw2A@A@ ݸ˝
K)gDw2A@A@ Ն˝
K)gDw2A@A@ ɩ˝
K)gDw2A@VA@h ˝
K)gDw2A@5A@h Ļ˝
K)gDw2A@A@ Ĺ˝
K)gDw2A@IA@ ĸ˝
K)gDw2A@A@h ķDz˝
K)gDw2A@A@h ĩ˝
K)gDw2A@eA@h ĥ˝
K)gDw2A@bA@h ĥ˝
K)gDw2A@A@h Ĥ˝
K)gDw2A@A@h Ĥ˝
K)gDw2A@A@h ē˝
K)gDw2A@KsA@h đ˝
K)gDw2A@A@h Ď˝
K)gDw2A@A@h ²˝
K)gDw2A@A@ 뵒˝
K)gDw2A@%A@h ˝
K)gDw2A@A@h ݒ˝
K)gDw2A@A@ ˝
K)gDw2A@A@ ˝
K)gDw2A@CA@h ը˝
K)gDw2A@A@ ˝
K)gDw2A@8qA@h ó˝
K)gDw2A@'A@ ñؒ˝
K)gDw2A@nYA@ â˝
K)gDw2A@dA@ Þ˝
K)gDw2A@A@ Ü˝
K)gDw2A@")A@h Ò˝
K)gDw2A@A@ Ï˝
K)gDw2A@A@h ν
K)gDw2A@A@ Ë˝
K)gDw2A@)A@h ÆΒ˝
K)gDw2A@/A@ Ã˝
K)gDw2A@[A@ ˝
K)gDw2A@A@ ޒ˝
K)gDw2A@SA@h ˝
K)gDw2A@(cA@h ˝
K)gDw2A@jA@ ˝
K)gDw2A@A@h ˝
K)gDw2A@9A@h Œ˝
K)gDw2A@A@ Ħ˝
K)gDw2A@~gA@ ¨˝
K)gDw2A@_A@ в˝
K)gDw2A@A@ ˝
K)gDw2A@;A@h ˝
K)gDw2A@kA@ в˝
K)gDw2A@.A@h ˝
K)gDw2A@I{A@h ˝
K)gDw2A@VA@h ˝
K)gDw2A@VmA@h Œ˝
K)gDw2A@A@h ˝
K)gDw2A@/A@h ˝
K)gDw2A@A@ ˝
K)gDw2A@6A@h ө˝
K)gDw2A@A@ Ȯ˝
K)gDw2A@ A@ Ɣ˝
K)gDw2A@A@h ˝
K)gDw2A@pA@h ˝
K)gDw2A@A@h ˝
K)gDw2A@A@h ˝
K)gDw2A@A@h ˝
K)gDw2A@۶A@h ˝
K)gDw2A@pA@ ˝
K)gDw2A@'A@ ˝
K)gDw2A@,(A@h ˝
K)gDw2A@-A@h ˝
K)gDw2A@A@h ˝
K)gDw2A@҉A@h ˒˝
K)gDw2A@6A@ ֲ˝
K)gDw2A@}A@h ˝
K)gDw2A@#A@h ˝
K)gDw2A@A@h ˝
K)gDw2A@A@h ?˝ >悒˝ =Œ˝ <˝ ;˝ :˒˝ 9˝ 8˝ 7˝ 6˝ 5˝ 4递˝ 3˝ 2˝ 1˝ 0Ι˝ /ҩ˝ .˝ -ŗ˝
" " e˨˝2
K)gDw2Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeظ˝2
K)gDw2Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFF g
~qdWJ=0# zm`SF9,
v
i
\
O
B
5
(
reXK>1$
{naTG:-
,entirely,completelyAAd@ @ AAdP˝'
i \)gD))gDw2AAjUAA_;d意思intention,purposeAAjU@ @ AAjUZ˝(
i u)gD))gDw2AA^AA_;d礼儀manners,courtesy,etiquetteAA^@ @ AA^Sٯ˝(
i )gD))gDw2AA!AA_;d去るto leave,to go awayAA!@ @ AA!C˝'
ck )gD))gDw2AA>AA_;d革leatherAA>@ @ AA>`¨˝(
i ')gD))gDw2AAXdAA_;d平均equilibrium,balance,average,meanAAXd@ @ AAXdZ˝(
u i)gD))gDw2AA}kAA_;dライターlighter,rider,writerAA}k@ @ AA}kE̒˝'
co )gD))gDw2AAOAA_;d便way,meansAAO@ @ AAOp˝(
o7 |)gD))gDw2AAAA_;d備えるto furnish,to provide for,to equip,to installAA@ @ AAP˝'
i )gD))gDw2AAmAA_;d想像imagination,guessAAm@ @ AAmYȒ˝(
i )gD))gDw2AA]AA_;d歩道footpath,walkway,sidewalkAA]@ @ AA][Œ˝(
i *)gD))gDw2AAAA_;d香りaroma,fragrance,scent,smellAA@ @ AA^ ˝ ˝ ˝ ˝ Ȳ˝ ˝ ˝ ϴ˝ ˝ ˝ ˝ ˝ ˝ ˝ ˝ ܒ˝ ے˝ ˝ ˝ ˝ ˝ ˝ ˝ Ē˝ ˝ ˝ 諲˝ ˝ ˝ ˝ ˝ ˝ ˝ ˝ ˝ ˝ ˝ ս˝ ˝ ˝ ˝ ~ǒ˝ }˝ |˝ {˝ z˝ yк˝ x˝ w˝ v˝ u˝ t˝ s˝ r˝ q˝ pܪ˝ o撒˝ n˝ m˝ l˝ k˝ j۲˝ iܲ˝ h˝ g˝ fŒ˝ e˝ d˝ cϲ˝ b˝ a達˝ `˝ _˝ ^垲˝ ]䇺˝ \⥈˝ [˝ Z߲˝ Y᧒˝ Xݻ˝ Wܬے˝ Vۡ˝ Uږ˝ Tو˝ S˝ R֩˝ Qò˝ PԜ˝ O䘲˝ Ndž˝ MФ͒˝ Lπ˝ Kഒ˝ J˝ I˱˝ Hʧ˝ G˝ Fݼ˝ Eƻ˝ D˝ C˝ B˝ A˝
J{
!L 1
{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`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)
)r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" (
"key" TEXT NOT NULL,
value TEXT,
PRIMARY KEY ("key")
)/C indexsqlite_autoindex_deckVars_1deckVars#!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),
CONSTRAINT "deckIdfk" FOREIGN KEY("deckId") REFERENCES decks (id)
)vKtablefactsfacts CREATE TABLE facts (
id INTEGER NOT NULL,
"modelId" INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FLOAT NOT NULL,
tags TEXT NOT NULL,
"spaceUntil" FLOAT NOT NULL,
"lastCardId" INTEGER,
PRIMARY KEY (id),
FOREIGN KEY("modelId") REFERENCES models (id),
CONSTRAINT "lastCardIdfk" FOREIGN KEY("lastCardId") REFERENCES cards (id)
)/ %%!tablefactsDeletedfactsDeleted
CREATE TABLE "factsDeleted" (
"factId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("factId") REFERENCES facts (id)
)1
!!-tablecardModelscardModelsCREATE 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),
FOREIGN KEY("modelId") REFERENCES models (id)
)
R
G
rCtabledecksdecksCREATE TABLE decks (
id INTEGER NOT NULL,
created FLOAT NOT NULL,
modified FL :OtablefieldsfieldsCREATE 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("factId") REFERENCES facts (id),
FOREIGN KEY("fieldModelId") REFERENCES "fieldModels" (id)
)tablecardscardsCREATE 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("factId") REFERENCES facts (id),
FOREIGN KEY("cardModelId") REFERENCES "cardModels" (id)
)1%%%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)
)rCtabledecksdecksCREATE 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)
)5'')tablemodelsDeletedmodelsDeletedCREATE TABLE "modelsDeleted" (
"modelId" INTEGER NOT NULL,
"deletedTime" FLOAT NOT NULL,
FOREIGN KEY("modelId") REFERENCES models (id)
)~##CtablefieldModelsfieldModelsCREATE 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),
FOREIGN KEY("modelId") REFERENCES models (id)
)
t t %
-%#
A8AB.y+K)gDw2?O;dZ? XXPriorityVeryHighPriorityHighPriorityLowX
²˝2
K)gDw2Back˝2
K)gDw2Front +
~qdWJ=0# zm`SF9,
=\r2 qK(8r'f@ ˝b h^e)gD㫉)gDw2信じる#˝ 'A
)gDV)gDw2master,expert˝b {!)gD㫉)gDw2深刻˝b ;)gD㫉)gDw2需要"˝ %Y)gDV)gDw2river,stream˝b Mx)gD㫉)gDw2劇場-˝ ;zM)gDV)gDw2record,minutes,document.ц˝ =G)gDV)gDw2environment,circumstanceAġ˝ c9+)gDV)gDw2living,livelihood,subsistence,circumstances"Ā˝ %j)gDV)gDw2report,paper0˝ AV)gDV)gDw2increasingly,more and more˝r r)gD)gDw2まさか-½˝ ;!y)gDV)gDw2seriousness,earnestnessM³˝ {V5)gDV)gDw2enforcement,enact,put into practice,carry out,operation2¯˝ E-)gDV)gDw2start,commencement,beginning0¯˝ A
)gDV)gDw2tendency,trend,inclination®˝r @)gD)gDw2灯¬˝b w)gD㫉)gDw2傷¬˝r )gD)gDw2予報©˝ '-W)gDV)gDw2invention4¥˝ Ip/)gDV)gDw2to raise,to lift up,to flatter' ˝ /)gDV)gDw2always,constantly˝r Y)gD)gDw2命じる6˝ M/)gDV)gDw2middle school,junior high school*˝ 5)gDV)gDw2direction,course,wayE˝ k%kI)gDV)gDw2subject,contents,matter,substance,detail,import˝b )gD㫉)gDw2少女7˝ O)gDV)gDw2approval,agreement,support,favour˝b ')gD㫉)gDw2額˝r )gD)gDw2肌˝b 43)gD㫉)gDw2支給˝r )gD)gDw2雰囲気˝b )gD㫉)gDw2単位˝b SY)gD㫉)gDw2速度 ˝ !C)gDV)gDw2high price˝r )gD)gDw2迷子;˝ W)gDV)gDw2settlement,conclusion,regulation,rule˝ `)gDV)gDw2warm,mild+ز˝ 7Q!)gDV)gDw2friend,ally,supporter˝b y)gD㫉)gDw2桜1т˝ C)gDV)gDw2society,the world,the timesΝ˝b >)gD㫉)gDw2時6ǖ˝ M[)gDV)gDw2really,truly,entirely,completely˝b )gD㫉)gDw2欠点˝b )gD㫉)gDw2引退.˝ =I()gDV)gDw2feeling,sense,impression.˝ =Q)gDV)gDw2approximately,about,some˝ Wg)gDV)gDw2headache(˝ 1E)gDV)gDw2collision,conflict˝r )gD)gDw2皆˝b ;')gD㫉)gDw2詳しい˝b C)gD㫉)gDw2沈む)˝ 3)gDV)gDw2sequel,continuation颒˝b )gD㫉)gDw2徐々に⊲˝b 9)gD㫉)gDw2成功(˝ 1(-)gDV)gDw2symptoms,condition˝b >)gD㫉)gDw2進歩)˝ 3k)gDV)gDw2controversy,dispute"˝b %di)gD㫉)gDw2必ずしも?خ˝ _)gDV)gDw2to notice,to recognize,to become aware of+Մ˝ 78)gDV)gDw2abdomen,belly,stomachʣ˝b sm)gD㫉)gDw2正直ɞ˝b %`)gD)gDw2莫大˝b >.s)gD㫉)gDw2地平線ȵ˝b )gD)gDw2共に0Ȩ˝ AM)gDV)gDw2construction,establishment"ķ˝S %s)gD㫉)gDw2あんなに+˝ 7o/)gDV)gDw2help,helper,assistant˝b }q)gD㫉)gDw2給料˝b ϭ)gD㫉)gDw2髪の毛{˝ Uw)gDV ؒ˝b ˝b ˝ ˝ ˝ ˝ ˒˝ ˝ ˝b ˝S Ғ˝ ҉˝b Þ˝ ˝b ˝ ʒ˝r ˝r ˝
˝ ˝b ˝
˝b ˝b ˝ ˝b ˝ ˝b ˝ ˝b 薢˝b ˝r ˝ ޒ˝b Բ˝ ڔ˝b ˝ Ւ˝ ۖ˝ ˝ ˝ ˝ ˝ ˝b
aR@A M
l.
u
Pu
+##eviewrevCardsNewrevCardsNewCREATE VIEW revCardsNew as
select * from cards
where type = 1 and isDue = 1
ord
/##eviewacqCardsNewacqCardsNewCREATE VIEW acqCardsNew as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due desc.##[viewacqCardsOldacqCardsOldCREATE VIEW acqCardsOld as
select * from cards
where type = 2 and isDue = 1
order by priority desc, due-))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as
select * from cards
where type = 1 and isDue = 1
order by priority desc, factId, ordinal:OtablefieldsfieldsCREATE 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("factId") REFERENCES facts (id),
FOREIGN KEY("fieldModelId") REFERENCES "fieldModels" (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)
)
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)u5+indexix_cards_duePrioritycardsCREATE INDEX ix_cards_duePriority on cards
(type, isDue, combinedDue, priority)u5+indexix_cards_priorityDuecardsCREATE INDEX ix_cards_priorityDue on cards
(type, isDue, priority, combinedDue)T+uindexix_cards_factorcardsCREATE INDEX ix_cards_factor on cards
(type, factor)T+uindexix_cards_factIdcardsCREATE INDEX ix_cards_factId on cards (factId, type)S-qindexix_stats_typeDaystatsCREATE INDEX ix_stats_typeDay on stats (type, day)R-mindexix_fields_factIdfieldsCREATE INDEX ix_fields_factId on fields (factId)e9indexix_fields_fieldModelIdfields CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)O+iindexix_fields_valuefields!CREATE INDEX ix_fields_value on fields (value)a7indexix_media_originalPathmedia"CREATE INDEX ix_media_originalPath on media (originalPath)k9%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#3indexix_cardTags_tagCardcardTags'CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z$1uindexix_cardTags_cardIdcardTags(CREATE INDEX ix_cardTags_cardId on cardTags (cardId)~%7;indexix_cards_intervalDesccards)CREATE INDEX ix_cards_intervalDesc on cards (type, isDue, priority desc, interval desc)h&+indexix_cards_dueAsccards*CREATE INDEX ix_cards_dueAsc on cards (type, isDue, priority desc, due)['/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
Forward
Basic -PriorityVeryHigh %PriorityHigh # PriorityLow {tdSC2"
}
l
\
K
;
*
udTC3"}m\L;+
u
e
T
D
3
#
~ m ] L < +
veUD4#yhVE3"saP>-
~l[I8&wfTC1 q_N<+|jYG6$ X Aa)gDW Aa)gDV Wڗ)gDU Wڗ)gDT *xc)gDS *xc)gDR <.#)gDQ <.#)gDP i1)gDO i1)gDN O)gDM O)gDL )gDK )gDJ R)gDI R)gDH d)gDG d)gDF Q)gDE Q)gDD -)gDC -)gDB q)gDA q)gD@ b)gD? b)gD> 5;o)gD= 5;o)gD< `K)gD; `K)gD: )gD9 )gD8 9+)gD7 9+)gD6
/)gD5
/)gD4 )gD3 )gD2 )gD1 )gD0 ))gD/ ))gD. N_)gD- N_)gD,
)gD+
)gD* 3[)gD) 3[)gD( =Y)gD' =Y)gD& E)gD% E)gD$ )gD# )gD" dO)gD! dO)gD )gD )gD )gD )gD 1)gD 1)gD Y)gD Y)gD bG)gD bG)gD W)gD W)gD )gD )gD gI)gD gI)gD ')gD ')gD /)gD
/)gD T)gD T)gD
)gD )gD Բ)gD Բ)gD s)gD s)gD