Missing pieces: - fix long text index entries (for new general sort order) * ??? - implement foreign key index creation & relationship creation * MEDIUM - implement table creation w/ complex columns * MEDIUM - implement (optional) foreign key enforcement * MEDIUM - implement write support for properties * EASY - implement table, column, index renaming * EASY - implement table, column, index deletion * EASY - MEDIUM - implement more comprehensive unicode compression write support * EASY? (have the code, do we trust it?) - implement createReadOnlyTemp(InputStream) (delete temp file on close) * EASY - figure out how msaccess manages page/row locks * MEDIUM Refactor goals: - simplify public API (separate "internal" and "external" api) * separate table creation objects from existing metadata objects * remove "simple" index support? * remove "table traversal methods" from Table? * enable integrity by default? * remove import/export methods from Database? * move database open/create options to DBBuilder * tweak how import filters work to make them more flexible? - tweak lookup apis (specify column vs column name) - separate classes into more packages (api,builder,util,impl) * remove debug log blocks - add Row interface - change savepoint to use table number instead of name? * don't use columnimpl for creating tables * clean up columnimpl/tableimpl constructors - add updateCurrentRow(Map), add updateRow(Row) - sort out query types - clean up javadocs - enhance public api classes - add @usage tags to util classes * add unit tests for Row update/delete methods, add/update *FromMap methods * add reason to unsupop throws for indexes