ENDqtablelistlistCREATE TABLE list (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(50), leaf INTEGER, lft INTEGER, rgt INTEGER)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)$+tabletasktaskCREATE TABLE task (id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(255), list_id INTEGER, due DATE, reminder DATE, done INTEGER, note BLOB)^tableconfigconfigCREATE TABLE config (key VARCHAR(50) PRIMARY KEY, value VARCHAR(255))+? indexsqlite_autoindex_config_1config
|
