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.

Backups:
    After a new import:
        make schemas/rotate
        Rename the rotated schema using the date in the first datasource's log
            file name
        Delete previous imports so they won't bloat the full DB backup:
            make backups/public.<date>.backup/remove
        make backups/<schema>.backup/test & make backups/vegbien.backup/all &
    Archived imports:
        Back up: make backups/public.<date>.backup &
            Note: To back up the last import, you must archive it first (above)
        Test: make backups/public.<date>.backup/test &
        Restore: make backups/public.<date>.backup/restore &
        Remove: make backups/public.<date>.backup/remove
    Full DB:
        Back up, test, and rotate: make backups/vegbien.backup/all &
        Back up and rotate: make backups/vegbien.backup/rotate &
        Test: make backups/vegbien.<date>.backup/test &
        Restore: make backups/vegbien.<date>.backup/restore &

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/>
    Populate the src/ subdir with input data:
        Obtain/create CSVs for the tables present in the datasource:
            specimens, plots, organisms, stems
        Rename each CSV so it ends in ".<table>.<ext>" (see tables above)
        Auto-create the src column spreadsheets: make inputs/<short_name>/

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!
    Reinstall errors tables: make inputs/install errors_table_only=1
    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