PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE learn (
        word TEXT UNIQUE PRIMARY KEY,
        steno TEXT NOT NULL,
        goods INTEGER NOT NULL,
        interval REAL NOT NULL,
        next REAL NOT NULL);
INSERT INTO learn VALUES('rat','RAT',18,8813.4883233873260906,1646326417.1723234653);
INSERT INTO learn VALUES('rug','RUG',18,9133.977180497307927,1646326738.4371805191);
INSERT INTO learn VALUES('sup','SUP',18,8791.3608039410974012,1646326402.4348037243);
INSERT INTO learn VALUES('hers','HERS',27,8970.2955038399140906,1646326624.2605037689);
INSERT INTO learn VALUES('held','HELD',16,7515.1877019297526204,1646325207.3547019958);
INSERT INTO learn VALUES('words','WORDZ',17,7923.6770677751128459,1646325619.1190676689);
INSERT INTO learn VALUES('red','RED',14,7289.7854318230238279,1646324990.8874318599);
INSERT INTO learn VALUES('world','WORLD',18,7487.8234208141866475,1646325193.320420742);
INSERT INTO learn VALUES('whose','WHOZ',17,8203.4449635432538346,1646325910.2219634055);
INSERT INTO learn VALUES('spur','SPUR',21,9086.6165895898975577,1646326796.1515896319);
INSERT INTO learn VALUES('part','PART',29,7969.7591536774089037,1646325679.9231536388);
INSERT INTO learn VALUES('step','STEP',38,10103.755486594034664,1646327814.7904865741);
INSERT INTO learn VALUES('hut','HUT',33,8624.9490550445116242,1646326336.7220549583);
INSERT INTO learn VALUES('web','WEB',35,9755.2241648877097762,1646327468.0371649265);
INSERT INTO learn VALUES('sob','SOB',20,10338.016958754293227,1646328051.9419586657);
INSERT INTO learn VALUES('rub','RUB',29,10124.608774295526017,1646327839.3587741851);
INSERT INTO learn VALUES('word','WORD',23,8851.9983805380034027,1646326567.8093805312);
INSERT INTO learn VALUES('her','HER',19,9418.2283678165586021,1646327134.6703677176);
INSERT INTO learn VALUES('put','PUT',19,9494.5672275305678343,1646327211.9072275162);
INSERT INTO learn VALUES('hot','HOT',19,9095.9277199782573005,1646326814.0287201404);
INSERT INTO learn VALUES('pat','PAT',31,10195.151103120313564,1646327914.0461030006);
INSERT INTO learn VALUES('kept','KEPT',40,9815.0583193984894028,1646327538.1053192615);
INSERT INTO learn VALUES('port','PORT',42,11944.659367778462183,1646329669.210367918);
INSERT INTO learn VALUES('star','STAR',48,10060.415615723937662,1646327785.8536157607);
INSERT INTO learn VALUES('well','WEL',18,11113.757209022227471,1646328839.9712090492);
INSERT INTO learn VALUES('tell','TEL',18,11165.781434250991879,1646328892.6574342251);
INSERT INTO learn VALUES('was','WAS',18,10858.435763648792999,1646328586.4827635287);
INSERT INTO learn VALUES('has','HAS',18,10307.885272556650306,1646328036.6832726001);
INSERT INTO learn VALUES('stop','STOP',19,12394.95043383977827,1646330124.5914337635);
INSERT INTO learn VALUES('hat','HAT',19,11616.214219434848928,1646329346.6192193031);
INSERT INTO learn VALUES('hurt','HURT',19,11047.611599465049948,1646328778.8025994301);
INSERT INTO learn VALUES('salt','SALT',19,10711.022536712045621,1646328443.174536705);
INSERT INTO learn VALUES('wept','WEPT',19,11442.88850394676956,1646329176.6715040207);
INSERT INTO learn VALUES('pet','PET',19,12352.64301225820418,1646330092.0710122585);
INSERT INTO learn VALUES('harp','HARP',37,10760.78999055253007,1646328501.5489907265);
INSERT INTO learn VALUES('sap','SAP',26,10671.438689396589324,1646328413.1106894016);
INSERT INTO learn VALUES('per','PER',19,14021.841549321583443,1646331764.840549469);
INSERT INTO learn VALUES('the','-T',29,13866.14684635215417,1646331609.7378463744);
INSERT INTO learn VALUES('set','SET',25,12371.678598311969836,1646330116.5835983753);
INSERT INTO learn VALUES('war','WAR',27,13943.171694049637153,1646331688.7606940269);
INSERT INTO learn VALUES('wet','WET',24,14209.647831088343082,1646331955.8058311939);
INSERT INTO learn VALUES('trap','TRAP',21,14271.103498526703333,1646332017.9864983558);
INSERT INTO learn VALUES('tops','TOPS',21,15439.86898105477303,1646333188.1409811973);
INSERT INTO learn VALUES('wore','WOR',13,4710.0926085356250041,1646324948.5146083831);
INSERT INTO learn VALUES('halt','HALT',26,2635.3607114367700887,1646324889.022711277);
INSERT INTO learn VALUES('rob','ROB',52,7308.2721102366340346,1646329562.6461102962);
INSERT INTO learn VALUES('heart','HART',37,8494.7273878902851721,1646330750.5073878764);
INSERT INTO learn VALUES('peg','PEG',35,2788.2047013564601912,1646325044.9317014217);
INSERT INTO learn VALUES('what''s','WHATS',14,3070.9400208579399986,1646325329.0050208568);
INSERT INTO learn VALUES('spread','SPRED',21,2796.1997912834217459,1646325055.9527912139);
INSERT INTO learn VALUES('in','TPH',14,8386.0663574676800637,1646330646.3983573913);
INSERT INTO learn VALUES('sub','SUB',43,3107.7821012599251844,1646325369.4061012267);
INSERT INTO learn VALUES('horse','HORS',39,2869.955443111304703,1646325132.2364430427);
INSERT INTO learn VALUES('worse','WORS',16,8225.110890516345535,1646330488.5968906878);
INSERT INTO learn VALUES('raft','RAFT',35,9483.9881781699041313,1646331749.5911781787);
INSERT INTO learn VALUES('says','SEZ',28,9373.0573633438216346,1646331640.2793631553);
INSERT INTO learn VALUES('steps','STEPS',27,7967.0980513451313525,1646330235.5860512256);
INSERT INTO learn VALUES('cast','KAFT',18,9664.8540114019433535,1646331940.1690113544);
INSERT INTO learn VALUES('his','HEUS',14,9235.1595857692427675,1646331511.6085855961);
INSERT INTO learn VALUES('court','KORT',16,8506.6325800538343171,1646330784.1905801295);
INSERT INTO learn VALUES('pub','PUB',50,9929.7889604198608139,1646332209.0149605273);
INSERT INTO learn VALUES('pot','POT',43,9267.2576390796111813,1646331550.6636390686);
INSERT INTO learn VALUES('past','PAFT',15,9822.2048625244551657,1646332109.6118626594);
INSERT INTO learn VALUES('said','SED',27,4836.3159087515577992,1646327140.044908762);
INSERT INTO learn VALUES('to','TO',14,10691.043330361715561,1646333000.7393305301);
INSERT INTO learn VALUES('and','SKP',14,10065.308063089625648,1646332376.1530630588);
INSERT INTO learn VALUES('of','-F',14,11197.362955517313821,1646333518.9189555645);
INSERT INTO learn VALUES('press','PRES',13,5224.3398775121595461,1646327554.2298777103);
INSERT INTO learn VALUES('trust','TRUFT',14,11064.393445857638653,1646333398.4374458789);
INSERT INTO learn VALUES('prove','PROF',14,10012.868745792151458,1646332364.9017457962);
INSERT INTO learn VALUES('I','EU',14,10020.422434450942091,1646332373.4674346446);
INSERT INTO learn VALUES('tap','TAP',42,5422.2712901273935129,1646327865.6882901191);
INSERT INTO learn VALUES('west','WEFT',14,9623.8398909694587929,1646332107.0788910389);
INSERT INTO learn VALUES('stove','STOF',14,10204.510602601198116,1646332726.515602827);
INSERT INTO learn VALUES('spot','SPOT',35,5872.4963087910609827,1646328527.9833087921);
INSERT INTO learn VALUES('store','STOR',15,6232.2543573832153923,1646329176.5713572501);
INSERT INTO learn VALUES('cost','KOFT',28,6503.6333239111963847,1646329472.607323885);
INSERT INTO learn VALUES('costs','KOFTS',22,2077.4797987554775317,1646325099.0657987594);
INSERT INTO learn VALUES('rests','REFTS',25,6505.373716255533509,1646329532.8157162666);
INSERT INTO learn VALUES('holds','HOLDZ',10,1848.5189463462097592,1646324951.0439465046);
INSERT INTO learn VALUES('stars','STARS',26,1844.3940014600595986,1646325045.7510015964);
INSERT INTO learn VALUES('cat','KAT',11,2480.1913211654859879,1646325742.1713211536);
INSERT INTO learn VALUES('roll','ROL',14,1712.5975765163459527,1646325047.0645766258);
INSERT INTO learn VALUES('course','KORS',42,1783.1459139303294705,1646325136.5829138755);
INSERT INTO learn VALUES('sad','SAD',13,7246.9852842203254113,1646330672.841284275);
INSERT INTO learn VALUES('score','SKOR',11,1782.9851351667864492,1646325368.8311350345);
INSERT INTO learn VALUES('cart','KART',14,1353.7593130730122084,1646324941.644313097);
INSERT INTO learn VALUES('head','HED',27,2914.5757854050571039,1646326506.9177854061);
INSERT INTO learn VALUES('pull','PUL',10,1905.1981467804152999,1646325505.2311468124);
INSERT INTO learn VALUES('rest','REFT',24,1525.5919515234581921,1646325128.1969516277);
INSERT INTO learn VALUES('corpse','KORPS',12,1438.3144532834101028,1646325050.2224533557);
INSERT INTO learn VALUES('curse','KURS',14,1583.1120133377169167,1646325225.8920133113);
INSERT INTO learn VALUES('sport','SPORT',16,1449.9376823141412842,1646325102.8836824893);
INSERT INTO learn VALUES('wrought','WROT',11,1898.7137954556151272,1646325567.6667954922);
INSERT INTO learn VALUES('stuff','STUF',16,1743.5411501865489753,1646325428.4491500854);
INSERT INTO learn VALUES('rag','RAG',29,3019.4294769205462217,1646326712.3964769839);
INSERT INTO learn VALUES('cab','KAB',11,1066.1755424201382993,1646325452.6975424289);
INSERT INTO learn VALUES('rough','RUF',14,7827.3929863612938789,1646332215.7059862614);
INSERT INTO learn VALUES('{"}','KR-GS',7,1121.3530001781577994,1646325532.0420000553);
INSERT INTO learn VALUES('told','TOLD',46,3629.062431877301151,1646328041.7064318656);
INSERT INTO learn VALUES('ward','WARD',10,2314.3765974069883668,1646326728.6775975228);
INSERT INTO learn VALUES('half','HAF',27,2346.7215284718540716,1646326762.1175284385);
INSERT INTO learn VALUES('pour','POR',15,679.38063680262064281,1646325099.4456367493);
INSERT INTO learn VALUES('test','TEFT',25,1647.6572850851930524,1646326069.4732849597);
INSERT INTO learn VALUES('hold','HOLD',29,8498.8706272680683466,1646332921.9126272201);
INSERT INTO learn VALUES('{&}','SP-PBD',7,670.43926478633670742,1646325095.4282648563);
INSERT INTO learn VALUES('wars','WARS',28,2545.9651543582831436,1646326973.7531545162);
INSERT INTO learn VALUES('that','THA',20,1456.4115089384365546,1646325884.896508932);
INSERT INTO learn VALUES('tour','TOR',8,1571.3969594186285121,1646326000.9189593791);
INSERT INTO learn VALUES('cups','KUPS',8,1589.2161345417403026,1646326019.634134531);
INSERT INTO learn VALUES('sell','SEL',14,9533.9569543113102554,1646333965.0989542006);
INSERT INTO learn VALUES('wrap','WRAP',35,9245.762508402345702,1646333678.6745083332);
INSERT INTO learn VALUES('soft','SOFT',29,3628.8197391950939164,1646328064.4597392081);
INSERT INTO learn VALUES('top','TOP',54,2536.6444917532057843,1646326973.0254917144);
INSERT INTO learn VALUES('wells','WELS',8,1878.787258096883761,1646326316.557258129);
INSERT INTO learn VALUES('sets','SETS',10,2364.6735703929011834,1646326803.5635704993);
INSERT INTO learn VALUES('{$}','TK-PL',7,981.40133549762879287,1646325421.6913354396);
INSERT INTO learn VALUES('{''}','AE',7,1101.0809074949534079,1646325542.0939075946);
INSERT INTO learn VALUES('car','KAR',15,8647.4322059427468044,1646333089.0492060184);
INSERT INTO learn VALUES('hell','HEL',12,4397.705077147869815,1646328840.1370770931);
INSERT INTO learn VALUES('{(}','PREPB',7,1074.9653852452745468,1646325518.3353850841);
INSERT INTO learn VALUES('cup','KUP',14,9350.4343599848180022,1646333794.9253599643);
INSERT INTO learn VALUES('tells','TELS',21,3384.6097505392135644,1646327830.155750513);
INSERT INTO learn VALUES('heads','HEDZ',14,9599.7604031562132152,1646334047.0824031829);
INSERT INTO learn VALUES('worlds','WORLDZ',13,1137.5817107087007115,1646325588.0847108363);
INSERT INTO learn VALUES('tub','TUB',34,8420.2803524294577075,1646332871.8763523101);
INSERT INTO learn VALUES('courts','KORTS',18,1142.0792721310247088,1646325595.4412720203);
INSERT INTO learn VALUES('{#}','HA*ERB',8,1287.4260253218678826,1646325744.1830253601);
INSERT INTO learn VALUES('purse','PURS',10,2766.3420976786142091,1646327225.3760976791);
INSERT INTO learn VALUES('cars','KARS',8,2629.7252247523224468,1646327089.5342247485);
INSERT INTO learn VALUES('sorts','SORTS',10,3205.0563690833964755,1646327666.9973690509);
INSERT INTO learn VALUES('{!}','SKHRAPL',8,1744.1295123212867111,1646326209.5595123768);
INSERT INTO learn VALUES('Scott','SKOT',11,3315.1882811109940122,1646327782.3252811431);
INSERT INTO learn VALUES('hats','HATS',8,2107.6810887416850164,1646326575.7820887565);
INSERT INTO learn VALUES('hard','HARD',40,3397.4822037244234707,1646327866.8272037506);
INSERT INTO learn VALUES('sort','SORT',71,2312.6820756974930191,1646326783.1320757866);
INSERT INTO learn VALUES('spots','SPOTS',14,2299.3044185110429679,1646326776.3004186153);
INSERT INTO learn VALUES('pass','PAS',15,15354.913221621531192,1646339834.466221571);
INSERT INTO learn VALUES('sore','SOR',21,2016.9891883874247469,1646326501.658188343);
INSERT INTO learn VALUES('cut','KUT',17,13858.524261596261567,1646338597.1832616328);
INSERT INTO learn VALUES('card','KARD',16,166.78587522692976108,1646324909.746875286);
INSERT INTO learn VALUES('staff','STAF',19,3230.6689240514665471,1646327974.6459240913);
INSERT INTO learn VALUES('{%}','P*ERS',14,224.83143272225001396,1646324972.0404329299);
INSERT INTO learn VALUES('roar','ROR',11,2886.7891419022535047,1646327634.8981418609);
INSERT INTO learn VALUES('rot','ROT',42,16836.239385816828871,1646341585.0683858394);
INSERT INTO learn VALUES('sweat','SWET',6,345.84192752382904244,1646325095.4649274349);
INSERT INTO learn VALUES('cord','KORD',6,420.35820359355886921,1646325170.7822036742);
INSERT INTO learn VALUES('tread','TRED',15,621.73108170352838898,1646325373.6670818328);
INSERT INTO learn VALUES('{/}','OEU',8,672.99065986489847546,1646325425.7956600189);
INSERT INTO learn VALUES('rod','ROD',11,2957.6909808076275111,1646327713.7389810085);
INSERT INTO learn VALUES('{:}','STPH-FPLT',6,641.50900802424735049,1646325398.812007904);
INSERT INTO learn VALUES('cap','KAP',25,2980.2586462641356775,1646327738.2336461544);
INSERT INTO learn VALUES('parts','PARTS',15,16606.70309313173493,1646341365.6090929508);
INSERT INTO learn VALUES('{)}','PR*EPB',10,707.46341122930357413,1646325468.4644112586);
INSERT INTO learn VALUES('{*}','STA*R',10,704.47188072257017664,1646325467.6808807849);
INSERT INTO learn VALUES('hearts','HARTS',14,9905.8589102864698363,1646334670.5649104118);
INSERT INTO learn VALUES('{.}','TP-PL',7,703.39620363974734119,1646325469.4362037182);
INSERT INTO learn VALUES('ports','PORTS',8,109.75771140881244036,1646324899.1377115249);
INSERT INTO learn VALUES('start','START',37,107.42858649242516832,1646324902.6315865516);
INSERT INTO learn VALUES('{-}','H-PB',7,982.58339983098585438,1646325795.3593997955);
INSERT INTO learn VALUES('{,}','KW-BG',7,962.14466695051680741,1646325777.0926668643);
INSERT INTO learn VALUES('trot','TROT',36,4446.9227111768404939,1646329265.263711214);
INSERT INTO learn VALUES('stead','STED',3,42.99292340929400069,1646324880.2539234161);
INSERT INTO learn VALUES('skull','SKUL',4,69.649694274588370033,1646324914.1226942539);
INSERT INTO learn VALUES('tough','TUF',3,64.584653187423612052,1646324916.4556531906);
INSERT INTO learn VALUES('cats','KATS',4,88.944040080584485961,1646324943.1160399913);
INSERT INTO learn VALUES('rolls','ROLS',4,75.736859470094017865,1646324934.0188596248);
INSERT INTO learn VALUES('pulse','PULS',4,92.394347779467565825,1646324951.424347639);
INSERT INTO learn VALUES('pots','POTS',3,32.994056730884096851,1646324895.638056755);
INSERT INTO learn VALUES('cuts','KUTS',3,40.103116373887054634,1646324904.4341163635);
INSERT INTO learn VALUES('spell','SPEL',11,3797.6918756606178248,1646328665.0068757534);
INSERT INTO learn VALUES('sports','SPORTS',2,11.651120574056058387,1646324880.3541207314);
INSERT INTO learn VALUES('Carl','KARL',3,33.856560585694396082,1646324903.4115605353);
INSERT INTO learn VALUES('swell','SWEL',13,2765.9935987074486547,1646327636.3795986175);
INSERT INTO learn VALUES('stress','STRES',5,26.08494750365152015,1646324897.9309475421);
INSERT INTO learn VALUES('Scots','SKOTS',3,21.587047660346041055,1646324895.5520474911);
INSERT INTO learn VALUES('calf','KAF',1,6.9538625353072633927,1646324883.0328624248);
CREATE TABLE list (
        id INTEGER PRIMARY KEY,
        name TEXT UNIQUE NOT NULL);
CREATE TABLE lesson (
        word TEXT NOT NULL,
        steno TEXT NOT NULL,
        listid INTEGER REFERENCES list (id) NOT NULL,
        seq INTEGER NOT NULL,
        UNIQUE (word, listid));
CREATE TABLE schema (version TEXT NOT NULL);
INSERT INTO schema VALUES('2022-03-02a');
CREATE INDEX learn_steno_idx ON learn (steno);
CREATE INDEX learn_next_idx ON learn (next);
COMMIT;