A lot of changes:
Quick rundown:
- Everything is organized into directories (devs)
- Docker actually works
- Schedule, and most other .MDs moved to the wiki
- Tests to see if the app actually works (devs)
- Branch sqlite3
- I actually provided binaries for the people lazy enough to compile it
Migrating from older databases
if your PRAGMA table_info(levels);
displays id
and data
your probably using an older db.
To migrate type this shit i made up in 20 minutes
CREATE TABLE IF NOT EXISTS levels2(data BLOB UNIQUE);
DELETE FROM levels WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM levels GROUP BY data);
INSERT INTO levels2 (data) SELECT data FROM levels;
DROP TABLE levels;
ALTER TABLE 'levels2' RENAME TO 'levels';
This also removes duplicates