added mysql pager and prompt defaults