Wiz.bin SQL importer

[wnjj]

I never did get around to adding "REFERENCES" statements which would help tremendously in connecting the tables to each other. Many are self-explanatory and the tables called x_by_y are sorted indices to other tables.

[stuckless]

Originally Posted by wnjj

I never did get around to adding "REFERENCES" statements which would help tremendously in connecting the tables to each other. Many are self-explanatory and the tables called x_by_y are sorted indices to other tables.

That is cool, thanks. I didn't realize there were that many tables thx.

[wnjj]

Originally Posted by stuckless

That is cool, thanks. I didn't realize there were that many tables thx.

There are less "main" tables than it may seem. Any with an underscore in the name are embedded subtables (i.e. they were just serialized inline with a count and objects following). Basically non-normalized data with 'many' objects associated with 'one'. Those got put into distinct tables for proper DB form. For example, 'show_person' contains a personID and role but those were just stored in the show table in wiz.db. Look at Show.java's DataInput constructor to see this.

Also, there's at least one table (primeTitle) that was only used in prior revisions but my schema dumper doesn't discriminate.