SQLite format 3@ >02N >-0 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) )r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" ( "key" TEXT NOT NULL, value TEXT, PRIMARY KEY ("key") )/Cindexsqlite_autoindex_deckVars j u Yte?hexCache{"6998500576957799398": "611fab31f1ef9be6", "8483866019292486630": "75bcbf31f1ef9be6", "-1450925225105450010": "ebdd4731f1ef9be6", "-4146894751063368730": "c6734531f1ef9be6", "5096488397416930279": "46ba5d31f1ef9be7"}( EcssCache.fm611fab31f1ef9be6 {font-family:"Arial";font-size:20px;white-space:pre-wrap;} .fm75bcbf31f1ef9be6 {font-family:"Arial";font-size:20px;white-space:pre-wrap;} #cmqebdd4731f1ef9be6 {text-align:center;} #cmq46ba5d31f1ef9be7 {text-align:center;} #cmaebdd4731f1ef9be6 {text-align:center;} #cma46ba5d31f1ef9be7 {text-align:center;} .cmbebdd4731f1ef9be6 {background:#FFFFFF;} .cmb46ba5d31f1ef9be7 {background:#FFFFFF;} pageSize4096 hexCa' mediaLocation !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ӔV*AӔV6BasicBasic?< " !2011-08-23" !2011-08-22"!2011-08-22    $ߛ sE1FrontArial1#ߛ  sE1BackArial1 ""eӏߛ   sE1Reverse%(Back)s%(Front)sArial#000000Arial#000000Arial#FFFFFFeߛ  sE1Forward%(Front)s%(Back)sArial#000000Arial#000000Arial#FFFFFF 11 V r7tabledeckVarsdeckVarsCREATE TABLE "deckVars" ( "key" TEXT NOT NULL, value TEXT, PRIMARY KEY ("key") )/Cindexsqlite_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) )  ny=C | ; n:J AsE1AӔ TAӔ Cun monedero a purse/wallet<Ԉ EsE1AӔAӔeun cuaderno an exercise book9ӏߡ ?sE1AӔ"ɗAӔ#h4un bolígrafo/boli a pen7㵔 ;sE1AӔGXSAӔGuna mochila a schoolbag@⚨ MsE1AӔ_)AӔun sacapuntas a pencil sharpener8ݳ =sE1AӔӳSAӔ&un móvil a mobile phone1қ㓪 /sE1AӔAӔjuna goma a rubber3r 3sE1AӔ dAӔun libro a textbook1 /sE1AӔDAӔ͗tuna regla a ruler2ͥӏC 1sE1AӔ AӔ 2'un lápiz a pencil<$ EsE1AӔCAӔuna calculadora a calculator2泏$ 1sE1AӔ!AӔuna agenda a diary8œD =sE1AӔAӔkun estuche a pencil case;֞ӏv CsE1AӔvAӔun diccionario a dictionary YY$% M  -%# AӔH4AӔQ+AsE1269d2d33550700318e238118a8cc5556AӔX?񙙙 XPriorityVeryHighPriorityHighPriorityLowX8@ F g  'GpKӏ)' om 5-1CG1AӔ AӔ c0un lápiza pencilAӔ @@AӔ ӁQ⚍' oyLR1G1AӔӳSAӔVun móvila mobile phoneAӔӳS@@AӔӳSSӏZ' sypܳ1;JG1AӔ TAӔ Yun monederoa purse/walletAӔ T@@AӔ TŁU̘㓏' {u^1m$G1AӔCAӔ>una calculadoraa calculatorAӔC@@AӔCLٓ0' mq/k1rG1AӔ dAӔTun libroa textbookAӔ d@@AӔ dUӏX' s}oPC1G1AӔAӔun cuadernoan exercise bookAӔ@@AӔﷁS糏( gW1G1AӔ"ɗAӔ#pun bolígrafo/boli a penAӔ"ɗ@@AӔ"ɗQ' qw2)1DG1AӔAӔun estuchea pencil caseAӔ@@AӔK̓ ' qk31L$G1AӔ!AӔzuna agendaa diaryAӔ!@@AӔ!J뮁䄆' ok c1G1AӔDAӔuna reglaa rulerAӔD@@AӔDP' ssR1G1AӔGXSAӔGuna mochilaa schoolbagAӔGXS@@AӔGXSTֿ(' yuy1svG1AӔvAӔun diccionarioa dictionaryAӔv@@AӔvJˌy' mm1H1G1AӔAӔuna gomaa rubberAӔ@@AӔZ߳( wR<1G1AӔ_)AӔun sacapuntasa pencil sharpenerAӔ_)@@AӔ_)  J 8 % r H JE D%g\$tk$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'1uindexix_cardTags_cardIdcardTags+CREATE INDEX ix_cardTags_cardId on cardTags (cardId)d&3indexix_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_modifiedcardsCREATE INDEX ix_cards_modified on cards (modified)T/qindexix_facts_modifiedfactsCREATE INDEX ix_facts_modified on facts (modified)T/qindexix_cards_prioritycardsCREATE INDEX ix_cards_priority on cards (priority)T+uindexix_cards_factorcardsCREATE 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)e9indexix_fields_fieldModelIdfields#CREATE INDEX ix_fields_fieldModelId on fields (fieldModelId)  HY2[0 O " z L " x H& -oPC1a1an exercise book%ѳ%+^1m$u1una calculadora D!2)1Du1un estucheC  5-1Ca1a pencilųLR1u1un móvil 醓s !/k1ra1a textbook$ѓv)y1svu1un diccionario!ӏ#oPC1u1un cuaderno c1u1una reglaÍ㓪1H1u1una goma"Τw %y1sva1a dictionary#ӏD '2)1Da1a pencil case(⚨ 1R<1a1a pencil sharpener$Ǚӏ )LR1a1a mobile phone㓪 1H1a1a rubber$K )pܳ1;Ja1a purse/wallet!㵔#R1u1una mochila!ғJ#pܳ1;Ju1un monedero#ޓ⚨'R<1u1un sacapuntas!݉㵔 #R1a1a schoolbag ۴ӏ$!31L$u1una agendaC 5-1Cu1un lápiz"Ӟӏ% %^1m$a1a calculator놓$ 31L$a1a diary)ӏߡ3W1u1un bolígrafo/boli Ρr/k1ru1un libroƵߡ W1a1a penˆӏ  c1a1a ruler    Forward Basic-PriorityVeryHigh%PriorityHigh# PriorityLow 2|l[K:* tdSC2ָ 1 ָ 11 1,g1y ,g1yY01 Y01a1m  a1m f1L f1Ljk1 jk11  1 v1)  v1) 1(  1(j[1sZ j[1sZ91;0 91;0M1X M1XO;1 O;1 ^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 NeF'mNAӔD c1ָ 1AӔGXSR11AӔ1H1񓪙,g1yAӔC^1m$Y01AӔ!31L$a1m AӔ_)R<1f1LAӔӳSLR1jk1AӔ2)1D1AӔ 5-1Cv1)AӔvy1sv1(AӔ Tpܳ1;Jj[1sZAӔ d/k1r91;0AӔoPC1M1XAӔ"ɗW1O;1 J~qdWJ v1) jk1 j[1sZ Y01 91;0 M1X O;1 1 a1m ָ 1 1 1( ,g1y f1L t`L8$AӔָ 1AӔG1AӔ,g1yAӔ>Y01AӔza1m AӔf1LAӔVjk1AӔ1AӔ c0v1)AӔ1(AӔ Yj[1sZAӔT91;0AӔM1XAӔ#pO;1 t`L8$AӔ͗t c1AӔGR1AӔj1H1AӔ^1m$AӔ31L$AӔR<1AӔ&LR1AӔk2)1DAӔ 2' 5-1CAӔy1svAӔ Cpܳ1;JAӔ/k1rAӔeoPC1AӔ#h4W1 J~qdWJ v1) jk1 j[1sZ Y01 91;0 M1X O;1 1 a1m ָ 1 1 1( ,g1y f1L |fP:$@v1)@jk1@j[1sZ@Y01@91;0@M1X@O;1@1@a1m @ָ 1@1@1(@,g1y@f1L t`L8$pܳ1;Jj[1sZoPC1M1XW1O;1R11R<1f1LLR1jk11H1񓪙,g1y/k1r91;0 c1ָ 1 5-1Cv1)^1m$Y0131L$a1m 2)1D1y1sv1(  !2011-08-23 !2011-08-22! 2011-08-22  t`L8$p\H4  pܳ1;JG1;Kpܳ1;Jɞ1;JoPC1~1oPC13E1W1Vm1W1q1R11R1񵔺%1R<1\q1R<1Ŋ1LR1g+1LR111H1 o11H11/k1r=11s/k1r1r c1!1 c1ل#1 5-1Ch1C 5-1C1C^1m$z1m%^1m$x1m%31L$=1L$31L$11L$2)1Dvw1D2)1D1Dy1sv/ {l]v1) jk1j[1sZY0191;0M1XO;11a1m ָ 111( ,g1yf1Lv1) jk1j[1sZY0191;0M1X  O;11 a1m ָ 111( ,g1yf1L ~qdWJ>1$  v1) v1) jk1 jk1 j[1sZ j[1sZ Y01 Y01 91;0 91;0 M1X M1X O;1  O;1 1 1 a1m  a1m  ָ 1 ָ 1 1 1 1( 1( ,g1y ,g1y f1L f1L $xV4hF$!pܳ1;JAӔ Tj[1sZ!oPC1AӔM1X!W1AӔ"ɗO;1!R1AӔGXS1!R<1AӔ_)f1L!LR1AӔӳSjk1!1H1AӔ,g1y!/k1rAӔ d91;0! c1AӔDָ 1! 5-1CAӔ v1)!^1m$AӔCY01!31L$AӔ!a1m !2)1DAӔ1!y1svAӔv1(  X.\2 )AӔD c1AӔDָ 1)AӔGXSR1AӔGXS1)AӔ1H1AӔ,g1y)AӔC^1m$AӔCY01)AӔ!31L$AӔ!a1m )AӔ_)R<1AӔ_)f1L)AӔӳSLR1AӔӳSjk1)AӔ2)1DAӔ1)AӔ 5-1CAӔ v1))AӔvy1svAӔv1()AӔ Tpܳ1;JAӔ Tj[1sZ)AӔ d/k1rAӔ d91;0)AӔoPC1AӔM1X)AӔ"ɗW1AӔ"ɗO;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&3indexix_cardTags_tagCardcardTags*CREATE INDEX ix_cardTags_tagCard on cardTags (tagId, cardId)Z'1uindexix_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, due0))yviewrevCardsRandomrevCardsRandomCREATE VIEW revCardsRandom as select * from cards where type = 1 and isDue = 1 order by priority desc, factId, ordinal