update mysqladapter.php and defaultview.php