queries:
  -
    mappings:
      check_for_resource_mapping_table: ~
      create_resource_mapping_table: ~
      ps_delete_resource_mapping_row: ~
      ps_insert_resource_mapping_row: ~
      ps_select_resource_mapping_row: ~
    type: default
    version: default
  -
    mappings:
      check_for_resource_mapping_table: "SELECT 1 FROM RESOURCE_POOL_TABLE"
      create_resource_mapping_table: "CREATE TABLE RESOURCE_POOL_TABLE (GROUP_ID VARCHAR(512) NOT NULL, RESOURCE_MAPPING BLOB NOT NULL, PRIMARY KEY (GROUP_ID))"
      ps_delete_resource_mapping_row: "DELETE FROM RESOURCE_POOL_TABLE WHERE GROUP_ID = ?"
      ps_insert_resource_mapping_row: "INSERT INTO RESOURCE_POOL_TABLE (GROUP_ID, RESOURCE_MAPPING) VALUES (?,?)"
      ps_select_resource_mapping_row: "SELECT GROUP_ID, RESOURCE_MAPPING FROM RESOURCE_POOL_TABLE WHERE GROUP_ID =?"
    type: H2
    version: default
  -
    mappings:
      check_for_resource_mapping_table: "SELECT 1 FROM RESOURCE_POOL_TABLE"
      create_resource_mapping_table: "CREATE TABLE RESOURCE_POOL_TABLE (GROUP_ID VARCHAR(512) NOT NULL, RESOURCE_MAPPING BLOB NOT NULL, PRIMARY KEY (GROUP_ID))"
      ps_delete_resource_mapping_row: "DELETE FROM RESOURCE_POOL_TABLE WHERE GROUP_ID = ?"
      ps_insert_resource_mapping_row: "INSERT INTO RESOURCE_POOL_TABLE (GROUP_ID, RESOURCE_MAPPING) VALUES (?,?)"
      ps_select_resource_mapping_row: "SELECT GROUP_ID, RESOURCE_MAPPING FROM RESOURCE_POOL_TABLE WHERE GROUP_ID =?"
    type: MySQL
    version: default
  -
    mappings:
      check_for_resource_mapping_table: "SELECT 1 FROM resource_pool_table"
      create_resource_mapping_table: "CREATE TABLE resource_pool_table (group_id text PRIMARY KEY, resource_mapping bytea NOT NULL)"
      ps_delete_resource_mapping_row: "DELETE FROM resource_pool_table WHERE GROUP_ID = ?"
      ps_insert_resource_mapping_row: "INSERT INTO resource_pool_table (GROUP_ID, RESOURCE_MAPPING) VALUES (?,?)"
      ps_select_resource_mapping_row: "SELECT GROUP_ID, RESOURCE_MAPPING FROM resource_pool_table WHERE GROUP_ID =?"
    type: PostgreSQL
    version: default
  -
    mappings:
      check_for_resource_mapping_table: "SELECT 1 FROM RESOURCE_POOL_TABLE"
      create_resource_mapping_table: "CREATE TABLE RESOURCE_POOL_TABLE (GROUP_ID VARCHAR(512) NOT NULL, RESOURCE_MAPPING BLOB NOT NULL, PRIMARY KEY (GROUP_ID))"
      ps_delete_resource_mapping_row: "DELETE FROM RESOURCE_POOL_TABLE WHERE GROUP_ID = ?"
      ps_insert_resource_mapping_row: "INSERT INTO RESOURCE_POOL_TABLE (GROUP_ID, RESOURCE_MAPPING) VALUES (?,?)"
      ps_select_resource_mapping_row: "SELECT GROUP_ID, RESOURCE_MAPPING FROM RESOURCE_POOL_TABLE WHERE GROUP_ID =?"
    type: Oracle
    version: default
  -
    mappings:
      check_for_resource_mapping_table: "SELECT 1 FROM RESOURCE_POOL_TABLE"
      create_resource_mapping_table: "CREATE TABLE  RESOURCE_POOL_TABLE (GROUP_ID VARCHAR(512) NOT NULL, RESOURCE_MAPPING varbinary(MAX) NOT NULL, PRIMARY KEY (GROUP_ID))"
      ps_delete_resource_mapping_row: "DELETE FROM RESOURCE_POOL_TABLE WHERE GROUP_ID = ?"
      ps_insert_resource_mapping_row: "INSERT INTO RESOURCE_POOL_TABLE (GROUP_ID, RESOURCE_MAPPING) VALUES (?,?)"
      ps_select_resource_mapping_row: "SELECT GROUP_ID, RESOURCE_MAPPING FROM RESOURCE_POOL_TABLE WHERE GROUP_ID =?"
    type: Microsoft SQL Server
    version: default
