store indexes relationally in sqlite.

[open768]

the indexes are created manually and stored as another file object in the database. it was ok when there was not database, but now its time to migrate to a relational structure as adding to the index is going to get incrementally more expensive as it

• pulls the index from the database
• adds an entry
• puts the whole index back into the database

[open768]

While this doesn't seem like a big deal, it will become a big problem as soon as there are a handful of users

[open768]

New table. 5 columns

• type
• sol
• instr
• product
• user

Unique type,sol,instr,product