CSPACE-1010 added constraints to account, users and users_roles tables. added validat...

CSPACE-1010 added constraints to account, users and users_roles tables. added validation tests to account service client. in case of constraint violation (performed by db), 500 is returned instead of 400.
account,authn poms use consistent mysql jdbc driver version
test: account, security

M    services/authentication/jaxb/src/main/resources/authentication_identity_provider.xsd
M    services/authentication/pstore/src/main/resources/db/mysql/authentication.sql
M    services/authentication/pstore/pom.xml
M    services/account/jaxb/src/main/resources/accounts_common.xsd
M    services/account/pstore/src/main/resources/db/mysql/account.sql
M    services/account/pstore/pom.xml
M    services/account/client/src/test/java/org/collectionspace/services/account/client/test/AccountServiceTest.java