text: -- used in tests that use HSQL
  create table oauth_client_details (
    client_id VARCHAR(256) PRIMARY KEY,
    resource_ids VARCHAR(256),
    client_secret VARCHAR(256),
    scope VARCHAR(256),
    authorized_grant_types VARCHAR(256),
    web_server_redirect_uri VARCHAR(256),
    authorities VARCHAR(256),
    access_token_validity INTEGER,
    refresh_token_validity INTEGER,
    auth_code_validity INTEGER,
    additional_information VARCHAR(4096),
    autoapprove VARCHAR(256),
    token_endpoint_auth_method VARCHAR(256)
  );
  
  create table oauth_client_token (
    token_id VARCHAR(256),
    token LONGVARBINARY,
    authentication_id VARCHAR(256) PRIMARY KEY,
    user_name VARCHAR(256),
    client_id VARCHAR(256)
  );
  
  create table oauth_access_token (
    token_id VARCHAR(256),
    token LONGVARBINARY,
    authentication_id VARCHAR(256) PRIMARY KEY,
    user_name VARCHAR(256),
    client_id VARCHAR(256),
    authentication LONGVARBINARY,
    refresh_token VARCHAR(256)
  );
  
  create table oauth_refresh_token (
    token_id VARCHAR(256),
    token LONGVARBINARY,
    authentication LONGVARBINARY
  );
  
  create table oauth_code (
    code VARCHAR(256), authentication LONGVARBINARY, expires TIMESTAMP, challenge VARCHAR(256)
  );
  
  create table oauth_approvals (
  	userId VARCHAR(256),
  	clientId VARCHAR(256),
  	scope VARCHAR(256),
  	status VARCHAR(10),
  	expiresAt TIMESTAMP,
  	lastModifiedAt TIMESTAMP
  );
  
  
  -- customized oauth_client_details table
  create table ClientDetails (
    appId VARCHAR(256) PRIMARY KEY,
    resourceIds VARCHAR(256),
    appSecret VARCHAR(256),
    scope VARCHAR(256),
    grantTypes VARCHAR(256),
    redirectUrl VARCHAR(256),
    authorities VARCHAR(256),
    access_token_validity INTEGER,
    refresh_token_validity INTEGER,
    auth_code_validity INTEGER,
    additionalInformation VARCHAR(4096),
    autoApproveScopes VARCHAR(256),
    token_endpoint_auth_method VARCHAR(256)
  );
  