Installation:
    Install: make install
        WARNING: This will delete the current public schema of your VegBIEN DB!
    Uninstall: make uninstall
        WARNING: This will delete your entire VegBIEN DB!
        This includes all archived imports and staging tables.
    Reinstall all datasources at once: . bin/reinstall_all

Data import:
    Import data into VegBIEN: . bin/import_all
        Using column-based import: . bin/with_all 'import by_col=1'
    Stop all running imports: . bin/stop_imports
    Archive the last import: make schemas/rotate
    Remove the last import: make schemas/public/reinstall
        WARNING: This will delete the current public schema of your VegBIEN DB!
    Re-import data: make schemas/rotate; . bin/import_all
        Note: This will archive the last import.

Maintenance of archived imports:
    Back up: make backups/public.<date>.backup &
        Note: To back up the last import, you must archive it first (see above)
    Restore: make backups/public.<date>.backup/restore &
    Remove: make backups/public.<date>.backup/remove

Datasource setup:
    Add a new datasource: make inputs/<short_name>/add
        If the datasource is a herbarium, <short_name> should be the herbarium
        code as defined by the Index Herbariorum <http://sweetgum.nybg.org/ih/>

Schema changes:
    Regenerate schema from installed DB: make schemas/remake
    Reinstall DB from schema: make schemas/reinstall
        WARNING: This will delete the current public schema of your VegBIEN DB!
    Sync ERD with vegbien.sql schema:
        Run make schemas/vegbien.my.sql
        Open schemas/vegbien.ERD.mwb in MySQLWorkbench
        Go to File > Export > Synchronize With SQL CREATE Script...
        For Input File, select schemas/vegbien.my.sql
        Click Continue
        Click in the changes list and press Ctrl+A or Apple+A to select all
        Click Update Model
        Click Continue
        Note: The generated SQL script will be empty because we are syncing in
            the opposite direction
        Click Execute
        Reposition any lines that have been reset
        Add any new tables by dragging them from the Catalog in the left sidebar
            to the diagram
        Remove any deleted tables by right-clicking the table's diagram element,
            selecting Delete '<table name>', and clicking Delete
        Save
        If desired, update the graphical ERD exports (see below)
    Update graphical ERD exports:
        Go to File > Export > Export as PNG...
        Select schemas/vegbien.ERD.png and click Save
        Go to File > Export > Export as SVG...
        Select schemas/vegbien.ERD.svg and click Save
        Go to File > Export > Export as Single Page PDF...
        Select schemas/vegbien.ERD.pdf and click Save
        Go to File > Print...
        For Pages, choose From 1 To 1
        In the lower left corner, click PDF > Save as PDF...
        Set the Title and Author to ""
        Select schemas/vegbien.ERD.core.pdf and click Save

Testing:
    Mapping process: make test
    Map spreadsheet generation: make remake
    Missing mappings: make missing_mappings
    Everything (for most complete coverage): make test-all

Documentation:
    To generate a Redmine-formatted list of steps for column-based import:
        make inputs/QMOR/import/steps.by_col.sql

General:
    To see a program's description, read its top-of-file comment
    To see a program's usage, run it without arguments
    To remake a directory: make <dir>/remake
    To remake a file: make <file>-remake