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('sort','SORT',13,648.73168945312500001,1646285932.8666894435);
INSERT INTO learn VALUES('per','PER',13,648.73168945312500001,1646285934.2146894931);
INSERT INTO learn VALUES('the','-T',23,648.73168945312500001,1646285934.9516894817);
INSERT INTO learn VALUES('soft','SOFT',15,648.73168945312500001,1646285936.3276894092);
INSERT INTO learn VALUES('set','SET',19,648.73168945312500001,1646285940.399689436);
INSERT INTO learn VALUES('her','HER',14,875.78778076171874995,1646286168.3817808628);
INSERT INTO learn VALUES('put','PUT',14,875.78778076171874995,1646286170.1537806987);
INSERT INTO learn VALUES('hot','HOT',14,875.78778076171874995,1646286170.8427808285);
INSERT INTO learn VALUES('was','WAS',13,973.09753417968749998,1646286269.6535341739);
INSERT INTO learn VALUES('has','HAS',13,973.09753417968749998,1646286270.8455340862);
INSERT INTO learn VALUES('spot','SPOT',18,432.48779296874999998,1646285988.3867928981);
INSERT INTO learn VALUES('trap','TRAP',14,432.48779296874999998,1646285989.1787929534);
INSERT INTO learn VALUES('tops','TOPS',14,432.48779296874999998,1646286000.1807930469);
INSERT INTO learn VALUES('pot','POT',13,583.85852050781250001,1646286243.2065205574);
INSERT INTO learn VALUES('hers','HERS',20,288.3251953125,1646285967.0751953124);
INSERT INTO learn VALUES('pub','PUB',12,389.23901367187500001,1646286077.2030136585);
INSERT INTO learn VALUES('pet','PET',12,389.23901367187500001,1646286078.0340137481);
INSERT INTO learn VALUES('war','WAR',21,648.73168945312500001,1646286489.7166893481);
INSERT INTO learn VALUES('wet','WET',18,648.73168945312500001,1646286490.8416893482);
INSERT INTO learn VALUES('top','TOP',34,56.953125,1646285900.8791251182);
INSERT INTO learn VALUES('kept','KEPT',29,56.953125,1646285905.5451250076);
INSERT INTO learn VALUES('rag','RAG',9,115.33007812499999999,1646285964.6860780716);
INSERT INTO learn VALUES('step','STEP',30,192.216796875,1646286042.329796791);
INSERT INTO learn VALUES('peg','PEG',11,85.4296875,1646285936.7216875552);
INSERT INTO learn VALUES('star','STAR',36,37.96875,1646285889.9557499885);
INSERT INTO learn VALUES('rot','ROT',9,115.33007812499999999,1646285970.1050782204);
INSERT INTO learn VALUES('hut','HUT',25,192.216796875,1646286047.6547968387);
INSERT INTO learn VALUES('spur','SPUR',14,288.3251953125,1646286144.6861953735);
INSERT INTO learn VALUES('web','WEB',27,192.216796875,1646286049.3907968997);
INSERT INTO learn VALUES('halt','HALT',11,432.48779296874999998,1646286290.4407930373);
INSERT INTO learn VALUES('sob','SOB',12,192.216796875,1646286051.7517969608);
INSERT INTO learn VALUES('pat','PAT',21,85.4296875,1646285945.6516873836);
INSERT INTO learn VALUES('sup','SUP',9,115.33007812499999999,1646285979.5480780601);
INSERT INTO learn VALUES('trot','TROT',10,172.99511718749999999,1646286038.0591170788);
INSERT INTO learn VALUES('tub','TUB',8,128.14453124999999999,1646285995.4185311793);
INSERT INTO learn VALUES('rat','RAT',10,172.99511718749999999,1646286040.990117073);
INSERT INTO learn VALUES('tap','TAP',10,172.99511718749999999,1646286041.9751172065);
INSERT INTO learn VALUES('rug','RUG',10,172.99511718749999999,1646286042.8311171532);
INSERT INTO learn VALUES('rub','RUB',21,192.216796875,1646286062.7607967854);
INSERT INTO learn VALUES('raft','RAFT',10,192.216796875,1646286063.704796791);
INSERT INTO learn VALUES('stop','STOP',14,875.78778076171874995,1646286748.2437808513);
INSERT INTO learn VALUES('hat','HAT',14,875.78778076171874995,1646286748.9237806797);
INSERT INTO learn VALUES('hurt','HURT',14,875.78778076171874995,1646286749.6857807636);
INSERT INTO learn VALUES('salt','SALT',14,875.78778076171874995,1646286750.6607806682);
INSERT INTO learn VALUES('sap','SAP',6,25.3125,1646285901.0555000305);
INSERT INTO learn VALUES('wept','WEPT',14,875.78778076171874995,1646286752.9257807731);
INSERT INTO learn VALUES('wars','WARS',14,875.78778076171874995,1646286753.7327806949);
INSERT INTO learn VALUES('part','PART',22,288.3251953125,1646286168.1971952915);
INSERT INTO learn VALUES('harp','HARP',19,7.5,1646285888.4960000514);
INSERT INTO learn VALUES('rob','ROB',20,432.48779296874999998,1646286314.5507929325);
INSERT INTO learn VALUES('wrap','WRAP',7,37.96875,1646285920.8417499065);
INSERT INTO learn VALUES('port','PORT',31,56.953125,1646285942.9141249657);
INSERT INTO learn VALUES('sub','SUB',13,5.0,1646285892.98300004);
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;
