* feat: client schema change * feat: add testcases * fix typo * hash client password * fix fk * upgrade script * fix failing testcase