queries:
  -
   type: default
   version: default
   mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE:
      CREATE_BUSINESS_RULES_TABLE:
      ADD_BUSINESS_RULE:
      UPDATE_BUSINESS_RULE:
      UPDATE_DEPLOYMENT_STATUS:
      UPDATE_ARTIFACT_COUNT:
      RETRIEVE_BUSINESS_RULE:
      RETRIEVE_ALL:
      RETRIEVE_ARTIFACT_COUNT:
      RETRIEVE_DEPLOYMENT_STATUS:
      DELETE_BUSINESS_RULE:
      CHECK_FOR_RULE_TEMPLATES_TABLE:
      CREATE_RULE_TEMPLATES_TABLE:
      ADD_RULE_TEMPLATE:
      RETRIEVE_ALL_RULE_TEMPLATES:
      DELETE_RULE_TEMPLATE:
  -
   type: H2
   version: default
   mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT 1 FROM business_rules LIMIT 1
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE IF NOT EXISTS business_rules ( uuid varchar(255) PRIMARY KEY, business_rule blob, deployment_status tinyInt, artifact_count int )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT 1 FROM rule_templates LIMIT 1
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE IF NOT EXISTS rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
  -
   type: MySQL
   version: default
   mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT 1 FROM business_rules LIMIT 1
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE IF NOT EXISTS business_rules ( uuid varchar(255) PRIMARY KEY, business_rule blob, deployment_status tinyInt(1), artifact_count int )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT 1 FROM rule_templates LIMIT 1
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE IF NOT EXISTS rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
  -
   type: Microsoft SQL Server
   version: default
   mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT TOP 1 1 from business_rules
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE business_rules ( uuid varchar(255) PRIMARY KEY, business_rule varbinary(max), deployment_status SMALLINT, artifact_count int )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT TOP 1 1 from rule_templates
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
  -
   type: Oracle
   version: default
   mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT 1 FROM business_rules
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE business_rules ( uuid varchar(255) PRIMARY KEY, business_rule blob, deployment_status int, artifact_count int )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT 1 FROM rule_templates
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
  -
    type: postgresql
    version: default
    mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT 1 FROM business_rules LIMIT 1
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE business_rules ( uuid varchar(255) PRIMARY KEY, business_rule BYTEA, deployment_status int, artifact_count int )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT 1 FROM rule_templates LIMIT 1
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
  -
    type: DB2
    version: default
    mappings:
      CHECK_FOR_BUSINESS_RULES_TABLE: SELECT 1 FROM business_rules FETCH FIRST 1 ROWS ONLY
      CREATE_BUSINESS_RULES_TABLE: CREATE TABLE business_rules ( uuid varchar(255) NOT NULL PRIMARY KEY, business_rule BLOB(65535), deployment_status SMALLINT, artifact_count INTEGER )
      ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
      UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
      UPDATE_ARTIFACT_COUNT: UPDATE business_rules SET artifact_count = ? WHERE business_rules.uuid = ?
      RETRIEVE_BUSINESS_RULE: SELECT uuid, business_rule, deployment_status FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_ALL: SELECT * FROM business_rules
      RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
      RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
      DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
      CHECK_FOR_RULE_TEMPLATES_TABLE: SELECT 1 FROM rule_templates FETCH FIRST 1 ROWS ONLY
      CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE rule_templates ( uuid varchar(255))
      ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
      RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
      DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
