update create_databases_schama.sql Tue Feb 13 00:00:02 UTC 2018

1 files changed, 48 insertions, 981 deletions

diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql
index 9523bb6..63be2f5 100644
--- a/salt/openbook/database/files/create_openbook_schemas.sql
+++ b/salt/openbook/database/files/create_openbook_schemas.sql
@@ -620,7 +620,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -698,7 +699,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -798,7 +800,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -879,7 +882,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -980,7 +984,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1059,7 +1064,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1097,8 +1103,7 @@ CREATE TABLE `t_metric_values` (
   KEY `ix_metric_values_3` (`metric_id`,`customer_id`,`service_region_id`,`metric_datetime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  PARTITION BY RANGE (to_days(`metric_datetime`))
-(PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
- PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
+(PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
  PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
  PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
  PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
@@ -1136,7 +1141,8 @@ CREATE TABLE `t_metric_values` (
  PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
  PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
  PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
- PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB);
+ PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
+ PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1172,6 +1178,15 @@ CREATE TABLE `t_payment` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_permissions` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `name` varchar(128) DEFAULT NULL,
+  `description` text DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `t_product` (
   `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `product_name` varchar(64) NOT NULL,
@@ -1417,6 +1432,25 @@ CREATE TABLE `t_resource_group` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_role` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `name` varchar(128) DEFAULT NULL,
+  `description` text DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `t_role_permissions` (
+  `role_id` int(11) NOT NULL,
+  `permission_id` int(11) NOT NULL,
+  `modifiedBy` varchar(128) NOT NULL DEFAULT '',
+  `modifiedDate` datetime NOT NULL,
+  PRIMARY KEY (`role_id`,`permission_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `t_service` (
   `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `service_type` varchar(128) NOT NULL,
@@ -1442,7 +1476,7 @@ CREATE TABLE `t_service_instance` (
   PRIMARY KEY (`service_instance_id`),
   UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)),
   KEY `ix_provisioned_entity_3` (`service_manager_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=106673 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=106842 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1585,7 +1619,7 @@ CREATE TABLE `t_unbilled_charges` (
   `payer_metadata` text DEFAULT NULL,
   PRIMARY KEY (`invoice_id`),
   KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1667,15 +1701,7 @@ CREATE TABLE `t_unbilled_charges_temp` (
   `payer_metadata` text DEFAULT NULL,
   PRIMARY KEY (`invoice_id`),
   KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `t_user_permissions` (
-  `user_id` int(10) unsigned NOT NULL,
-  `permission` longtext NOT NULL,
-  PRIMARY KEY (`user_id`,`permission`(255))
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1697,10 +1723,10 @@ CREATE TABLE `t_user_projects` (
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `t_user_roles` (
   `user_id` int(10) unsigned NOT NULL,
-  `role_name` varchar(128) NOT NULL,
+  `role_id` int(10) unsigned NOT NULL,
   `role_context` int(10) unsigned NOT NULL,
   `context_type` varchar(64) NOT NULL,
-  UNIQUE KEY `user_id` (`user_id`,`role_name`,`role_context`,`context_type`)
+  PRIMARY KEY (`user_id`,`role_id`,`role_context`,`context_type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
@@ -2056,965 +2082,6 @@ SET character_set_client = utf8;
   `tenant_type` tinyint NOT NULL
 ) ENGINE=MyISAM */;
 SET character_set_client = @saved_cs_client;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-/*!50001 CREATE TABLE `v_users` (
-  `user_id` tinyint NOT NULL,
-  `username` tinyint NOT NULL,
-  `first_name` tinyint NOT NULL,
-  `last_name` tinyint NOT NULL,
-  `email_address` tinyint NOT NULL,
-  `phone_number` tinyint NOT NULL,
-  `password` tinyint NOT NULL,
-  `is_active` tinyint NOT NULL,
-  `password_change_token` tinyint NOT NULL,
-  `last_password_change_date` tinyint NOT NULL,
-  `password_change_token_expire_date` tinyint NOT NULL,
-  `role_name` tinyint NOT NULL,
-  `role_context` tinyint NOT NULL
-) ENGINE=MyISAM */;
-SET character_set_client = @saved_cs_client;
-/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
-/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
-/*!50003 SET @saved_col_connection = @@collation_connection */ ;
-/*!50003 SET character_set_client  = utf8 */ ;
-/*!50003 SET character_set_results = utf8 */ ;
-/*!50003 SET collation_connection  = utf8_general_ci */ ;
-/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
-/*!50003 SET sql_mode              = 'IGNORE_SPACE,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
-DELIMITER ;;
-CREATE DEFINER=`openbook`@`%` PROCEDURE `p_preallocate_partitions`(IN tableName VARCHAR(255), IN columnName VARCHAR(255), IN beginDate DATETIME, IN numDays INT)
-BEGIN
-    DECLARE partitionDay, endDay INT;
-    DECLARE partitionName VARCHAR(255);
-    DECLARE partitionList VARCHAR(5000);
-
-    SET partitionDay = (SELECT (TO_DAYS(beginDate + INTERVAL 1 DAY)));
-    SET endDay = partitionDay + numDays;
-    SET partitionList = "";
-    WHILE partitionDay <= endDay DO
-      SET partitionName = CONCAT("p", partitionDay);
-      SET partitionList = CONCAT(partitionList, 'PARTITION ', partitionName, ' VALUES LESS THAN(', partitionDay, ')');
-      IF partitionDay < endDay THEN
-        SET partitionList = CONCAT(partitionList, ',');
-      END IF;
-      SET partitionDay = partitionDay + 1;
-    END WHILE;
-    SET @stmt = CONCAT('ALTER TABLE ', tableName, ' PARTITION BY RANGE (TO_DAYS(', columnName, ')) (', partitionList, ')');
-    PREPARE pStmt FROM @stmt;
-    EXECUTE pStmt;
-    DEALLOCATE PREPARE pStmt;
-  END ;;
-DELIMITER ;
-/*!50003 SET sql_mode              = @saved_sql_mode */ ;
-/*!50003 SET character_set_client  = @saved_cs_client */ ;
-/*!50003 SET character_set_results = @saved_cs_results */ ;
-/*!50003 SET collation_connection  = @saved_col_connection */ ;
-
-CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */;
-
-GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-
-USE `openbook_jobs`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `BLOB_DATA` blob DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_CALENDARS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `CALENDAR_NAME` varchar(200) NOT NULL,
-  `CALENDAR` blob NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_CRON_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `CRON_EXPRESSION` varchar(120) NOT NULL,
-  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `ENTRY_ID` varchar(95) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `INSTANCE_NAME` varchar(200) NOT NULL,
-  `FIRED_TIME` bigint(13) NOT NULL,
-  `SCHED_TIME` bigint(13) NOT NULL,
-  `PRIORITY` int(11) NOT NULL,
-  `STATE` varchar(16) NOT NULL,
-  `JOB_NAME` varchar(200) DEFAULT NULL,
-  `JOB_GROUP` varchar(200) DEFAULT NULL,
-  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
-  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
-  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
-  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
-  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
-  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
-  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_JOB_DETAILS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `JOB_NAME` varchar(200) NOT NULL,
-  `JOB_GROUP` varchar(200) NOT NULL,
-  `DESCRIPTION` varchar(250) DEFAULT NULL,
-  `JOB_CLASS_NAME` varchar(250) NOT NULL,
-  `IS_DURABLE` varchar(1) NOT NULL,
-  `IS_NONCONCURRENT` varchar(1) NOT NULL,
-  `IS_UPDATE_DATA` varchar(1) NOT NULL,
-  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
-  `JOB_DATA` blob DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
-  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
-  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_LOCKS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `LOCK_NAME` varchar(40) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_SCHEDULER_STATE` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `INSTANCE_NAME` varchar(200) NOT NULL,
-  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
-  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `REPEAT_COUNT` bigint(7) NOT NULL,
-  `REPEAT_INTERVAL` bigint(12) NOT NULL,
-  `TIMES_TRIGGERED` bigint(10) NOT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `STR_PROP_1` varchar(512) DEFAULT NULL,
-  `STR_PROP_2` varchar(512) DEFAULT NULL,
-  `STR_PROP_3` varchar(512) DEFAULT NULL,
-  `INT_PROP_1` int(11) DEFAULT NULL,
-  `INT_PROP_2` int(11) DEFAULT NULL,
-  `LONG_PROP_1` bigint(20) DEFAULT NULL,
-  `LONG_PROP_2` bigint(20) DEFAULT NULL,
-  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
-  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
-  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
-  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `QRTZ_TRIGGERS` (
-  `SCHED_NAME` varchar(120) NOT NULL,
-  `TRIGGER_NAME` varchar(200) NOT NULL,
-  `TRIGGER_GROUP` varchar(200) NOT NULL,
-  `JOB_NAME` varchar(200) NOT NULL,
-  `JOB_GROUP` varchar(200) NOT NULL,
-  `DESCRIPTION` varchar(250) DEFAULT NULL,
-  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
-  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
-  `PRIORITY` int(11) DEFAULT NULL,
-  `TRIGGER_STATE` varchar(16) NOT NULL,
-  `TRIGGER_TYPE` varchar(8) NOT NULL,
-  `START_TIME` bigint(13) NOT NULL,
-  `END_TIME` bigint(13) DEFAULT NULL,
-  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
-  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
-  `JOB_DATA` blob DEFAULT NULL,
-  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
-  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
-  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
-  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
-  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
-  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
-  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
-  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
-  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
-  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
-  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
-  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
-  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
-  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
-CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_workflow` /*!40100 DEFAULT CHARACTER SET utf8 */;
-
-GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-
-USE `openbook_workflow`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_EVT_LOG` (
-  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
-  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT current_timestamp(3) ON UPDATE current_timestamp(3),
-  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `DATA_` longblob DEFAULT NULL,
-  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
-  `IS_PROCESSED_` tinyint(4) DEFAULT 0,
-  PRIMARY KEY (`LOG_NR_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_GE_BYTEARRAY` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `BYTES_` longblob DEFAULT NULL,
-  `GENERATED_` tinyint(4) DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
-  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_GE_PROPERTY` (
-  `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  PRIMARY KEY (`NAME_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_ACTINST` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `START_TIME_` datetime(3) NOT NULL,
-  `END_TIME_` datetime(3) DEFAULT NULL,
-  `DURATION_` bigint(20) DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
-  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
-  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
-  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_ATTACHMENT` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TIME_` datetime(3) DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_COMMENT` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TIME_` datetime(3) NOT NULL,
-  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `FULL_MSG_` longblob DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_DETAIL` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `TIME_` datetime(3) NOT NULL,
-  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DOUBLE_` double DEFAULT NULL,
-  `LONG_` bigint(20) DEFAULT NULL,
-  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
-  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
-  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
-  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
-  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_IDENTITYLINK` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
-  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
-  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_PROCINST` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `START_TIME_` datetime(3) NOT NULL,
-  `END_TIME_` datetime(3) DEFAULT NULL,
-  `DURATION_` bigint(20) DEFAULT NULL,
-  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
-  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
-  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_TASKINST` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `START_TIME_` datetime(3) NOT NULL,
-  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
-  `END_TIME_` datetime(3) DEFAULT NULL,
-  `DURATION_` bigint(20) DEFAULT NULL,
-  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `PRIORITY_` int(11) DEFAULT NULL,
-  `DUE_DATE_` datetime(3) DEFAULT NULL,
-  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_HI_VARINST` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DOUBLE_` double DEFAULT NULL,
-  `LONG_` bigint(20) DEFAULT NULL,
-  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `CREATE_TIME_` datetime(3) DEFAULT NULL,
-  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
-  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
-  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_ID_GROUP` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_ID_INFO` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PASSWORD_` longblob DEFAULT NULL,
-  `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_ID_MEMBERSHIP` (
-  `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
-  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
-  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`),
-  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_ID_USER` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_PROCDEF_INFO` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
-  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
-  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
-  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
-  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RE_DEPLOYMENT` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
-  PRIMARY KEY (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RE_MODEL` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
-  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
-  `VERSION_` int(11) DEFAULT NULL,
-  `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
-  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
-  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
-  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`),
-  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
-  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RE_PROCDEF` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `VERSION_` int(11) NOT NULL,
-  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
-  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
-  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_EVENT_SUBSCR` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `CREATED_` timestamp(3) NOT NULL DEFAULT current_timestamp(3),
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
-  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
-  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_EXECUTION` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
-  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
-  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
-  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
-  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
-  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
-  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
-  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
-  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
-  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
-  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
-  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
-  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_IDENTITYLINK` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
-  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
-  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
-  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
-  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
-  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
-  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
-  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_JOB` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
-  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `RETRIES_` int(11) DEFAULT NULL,
-  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
-  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
-  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_TASK` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PRIORITY_` int(11) DEFAULT NULL,
-  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
-  `DUE_DATE_` datetime(3) DEFAULT NULL,
-  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
-  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
-  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
-  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
-  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
-  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
-  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
-  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
-  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ACT_RU_VARIABLE` (
-  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
-  `REV_` int(11) DEFAULT NULL,
-  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
-  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
-  `DOUBLE_` double DEFAULT NULL,
-  `LONG_` bigint(20) DEFAULT NULL,
-  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
-  PRIMARY KEY (`ID_`),
-  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
-  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
-  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
-  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
-  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
-  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
-  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
-GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-
-USE `openbook`;
-/*!50001 DROP TABLE IF EXISTS `v_all_charges`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_all_charges` AS select `t_invoice`.`invoice_id` AS `invoice_id`,`t_invoice`.`payer_id` AS `payer_id`,`t_invoice`.`payer_type` AS `payer_type`,`t_invoice`.`payer_name` AS `payer_name`,`t_invoice`.`invoice_number` AS `invoice_number`,`t_invoice`.`invoice_date` AS `invoice_date`,`t_invoice`.`period_begin` AS `period_begin`,`t_invoice`.`period_end` AS `period_end`,`t_invoice`.`invoice_amount` AS `invoice_amount`,`t_invoice`.`actual_charges` AS `actual_charges`,`t_invoice`.`invoice_currency` AS `invoice_currency`,`t_invoice`.`management_region_id` AS `management_region_id` from `t_invoice` union select `t_unbilled_charges`.`invoice_id` AS `invoice_id`,`t_unbilled_charges`.`payer_id` AS `payer_id`,`t_unbilled_charges`.`payer_type` AS `payer_type`,`t_unbilled_charges`.`payer_name` AS `payer_name`,`t_unbilled_charges`.`invoice_number` AS `invoice_number`,`t_unbilled_charges`.`invoice_date` AS `invoice_date`,`t_unbilled_charges`.`period_begin` AS `period_begin`,`t_unbilled_charges`.`period_end` AS `period_end`,`t_unbilled_charges`.`invoice_amount` AS `invoice_amount`,`t_unbilled_charges`.`actual_charges` AS `actual_charges`,`t_unbilled_charges`.`invoice_currency` AS `invoice_currency`,`t_unbilled_charges`.`management_region_id` AS `management_region_id` from `t_unbilled_charges` */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_all_charges_detail`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_all_charges_detail` AS select `t_invoice_detail`.`invoice_id` AS `invoice_id`,`t_invoice_detail`.`customer_id` AS `customer_id`,`t_invoice_detail`.`customer_name` AS `customer_name`,`t_invoice_detail`.`service_region_id` AS `service_region_id`,`t_invoice_detail`.`rate` AS `rate`,`t_invoice_detail`.`rate_display` AS `rate_display`,`t_invoice_detail`.`rate_unit` AS `rate_unit`,`t_invoice_detail`.`rate_interval` AS `rate_interval`,`t_invoice_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_invoice_detail`.`units_billed` AS `units_billed`,`t_invoice_detail`.`units_billed_display` AS `units_billed_display`,`t_invoice_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_invoice_detail`.`item_category` AS `item_category`,`t_invoice_detail`.`item_group` AS `item_group`,`t_invoice_detail`.`item_type` AS `item_type`,`t_invoice_detail`.`item_detail` AS `item_detail`,`t_invoice_detail`.`tenant_id` AS `tenant_id`,`t_invoice_detail`.`tenant_name` AS `tenant_name` from `t_invoice_detail` union select `t_unbilled_charges_detail`.`invoice_id` AS `invoice_id`,`t_unbilled_charges_detail`.`customer_id` AS `customer_id`,`t_unbilled_charges_detail`.`customer_name` AS `customer_name`,`t_unbilled_charges_detail`.`service_region_id` AS `service_region_id`,`t_unbilled_charges_detail`.`rate` AS `rate`,`t_unbilled_charges_detail`.`rate_display` AS `rate_display`,`t_unbilled_charges_detail`.`rate_unit` AS `rate_unit`,`t_unbilled_charges_detail`.`rate_interval` AS `rate_interval`,`t_unbilled_charges_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_unbilled_charges_detail`.`units_billed` AS `units_billed`,`t_unbilled_charges_detail`.`units_billed_display` AS `units_billed_display`,`t_unbilled_charges_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_unbilled_charges_detail`.`item_category` AS `item_category`,`t_unbilled_charges_detail`.`item_group` AS `item_group`,`t_unbilled_charges_detail`.`item_type` AS `item_type`,`t_unbilled_charges_detail`.`item_detail` AS `item_detail`,`t_unbilled_charges_detail`.`tenant_id` AS `tenant_id`,`t_unbilled_charges_detail`.`tenant_name` AS `tenant_name` from `t_unbilled_charges_detail` */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_current_host`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_current_host` AS select `h`.`host_id` AS `host_id`,`h`.`service_manager_id` AS `service_manager_id`,`sm`.`service_manager_name` AS `service_manager_name`,`h`.`service_region_id` AS `service_region_id`,`r`.`region_name` AS `region_name`,`h`.`host_foreign_id` AS `host_foreign_id`,`h`.`host_name` AS `host_name`,`h`.`hypervisor_type` AS `hypervisor_type`,`h`.`host_aggregate` AS `host_aggregate`,`h`.`add_date` AS `add_date`,`h`.`remove_date` AS `remove_date`,`h`.`cpu_allocation_ratio` AS `cpu_allocation_ratio`,`h`.`ram_allocation_ratio` AS `ram_allocation_ratio`,`h`.`disk_allocation_ratio` AS `disk_allocation_ratio`,`ha`.`update_date` AS `update_date`,`ha`.`ram_mb` AS `ram_mb`,`ha`.`ram_mb_used` AS `ram_mb_used`,`ha`.`disk_gb` AS `disk_gb`,`ha`.`disk_gb_used` AS `disk_gb_used`,`ha`.`vcpus` AS `vcpus`,`ha`.`vcpus_used` AS `vcpus_used`,`ha`.`vm_count` AS `vm_count`,`ha`.`socket_count` AS `socket_count` from (((`t_host` `h` join `v_current_host_attributes` `ha` on(`h`.`host_id` = `ha`.`host_id`)) join `t_service_manager` `sm` on(`h`.`service_manager_id` = `sm`.`service_manager_id`)) join `t_region` `r` on(`h`.`service_region_id` = `r`.`region_id`)) where `h`.`remove_date` > curdate() */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_current_host_attributes`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_current_host_attributes` AS select `tha1`.`host_id` AS `host_id`,`tha1`.`update_date` AS `update_date`,`tha1`.`ram_mb` AS `ram_mb`,`tha1`.`ram_mb_used` AS `ram_mb_used`,`tha1`.`disk_gb` AS `disk_gb`,`tha1`.`disk_gb_used` AS `disk_gb_used`,`tha1`.`vcpus` AS `vcpus`,`tha1`.`vcpus_used` AS `vcpus_used`,`tha1`.`vm_count` AS `vm_count`,`tha1`.`socket_count` AS `socket_count` from `t_host_attributes` `tha1` where `tha1`.`update_date` = (select max(`t_host_attributes`.`update_date`) from `t_host_attributes` where `t_host_attributes`.`host_id` = `tha1`.`host_id`) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_customer`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_customer` AS select `c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name`,`c`.`metadata` AS `metadata`,`c`.`tax_rate` AS `tax_rate`,`c`.`currency` AS `currency`,`c`.`discount_percent` AS `discount_percent`,`c`.`billing_frequency` AS `billing_frequency`,`c`.`last_bill_date` AS `last_bill_date`,`c`.`next_bill_date` AS `next_bill_date`,`c`.`is_active` AS `is_active`,`c`.`create_date` AS `create_date`,`c`.`activate_date` AS `activate_date`,`c`.`billing_start_date` AS `billing_start_date`,`c`.`last_payment_date` AS `last_payment_date`,`c`.`deactivate_date` AS `deactivate_date`,`c`.`description` AS `description`,`c`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`c`.`invoicing_method` AS `invoicing_method`,`c`.`management_region_id` AS `management_region_id`,`c`.`billing_address_line_1` AS `billing_address_line_1`,`c`.`billing_address_line_2` AS `billing_address_line_2`,`c`.`billing_address_city` AS `billing_address_city`,`c`.`billing_address_region` AS `billing_address_region`,`c`.`billing_address_country` AS `billing_address_country`,`c`.`billing_address_postal_code` AS `billing_address_postal_code`,`c`.`payer_payment_details` AS `payer_payment_details`,`c`.`payment_method_confirmed` AS `payment_method_confirmed`,`c`.`balance_due` AS `balance_due`,`c`.`spend_soft_limit` AS `spend_soft_limit`,`c`.`spend_hard_limit` AS `spend_hard_limit`,`c`.`terms_and_conditions_2_accept_date` AS `terms_and_conditions_2_accept_date`,`c`.`tax_id` AS `tax_id`,`c`.`registration_number` AS `registration_number`,`r1`.`region_name` AS `management_region_name` from (`t_customer` `c` left join `t_region` `r1` on(`c`.`management_region_id` = `r1`.`region_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_metric`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_metric` AS select `m`.`metric_id` AS `metric_id`,`m`.`service_manager_type_id` AS `service_manager_type_id`,`m`.`metric_name` AS `metric_name`,`m`.`metric_label` AS `metric_label`,`m`.`metric_source` AS `metric_source`,`m`.`metric_type` AS `metric_type`,`m`.`metric_unit` AS `metric_unit`,`m`.`entity_resolution` AS `entity_resolution`,`m`.`time_resolution` AS `time_resolution`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_metric` `m` left join `t_service_manager_type` `sm` on(`m`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_promo_code_redemption`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_promo_code_redemption` AS select `p`.`management_region_id` AS `management_region_id`,`p`.`promo_code_id` AS `promo_code_id`,`p`.`promo_code` AS `promo_code`,`p`.`salesperson` AS `salesperson`,`p`.`discount_or_credit` AS `discount_or_credit`,`p`.`credit_amount` AS `credit_amount`,`p`.`credit_type` AS `credit_type`,`p`.`apply_to_charge_category` AS `apply_to_charge_category`,`p`.`trigger_charge_category` AS `trigger_charge_category`,`p`.`trigger_amount` AS `trigger_amount`,`p`.`discount_percent` AS `discount_percent`,`p`.`available_invoice_periods` AS `available_invoice_periods`,`p`.`expire_date` AS `expire_date`,`p`.`currency` AS `currency`,`r`.`redemption_date` AS `redemption_date`,`c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name` from ((`t_promo_code_redemption` `r` join `t_customer` `c`) join `t_promo_code` `p`) where `r`.`payer_type` = 'Customer' and `r`.`payer_id` = `c`.`customer_id` and `p`.`promo_code_id` = `r`.`promo_code_id` */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_provider`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_provider` AS select `t_provider`.`provider_id` AS `provider_id`,`t_provider`.`provider_name` AS `provider_name`,`t_provider`.`provider_type` AS `provider_type`,`t_provider`.`metadata` AS `metadata`,`t_provider`.`tax_rate` AS `tax_rate`,`t_provider`.`currency` AS `currency`,`t_provider`.`discount_percent` AS `discount_percent`,`t_provider`.`billing_frequency` AS `billing_frequency`,`t_provider`.`last_bill_date` AS `last_bill_date`,`t_provider`.`next_bill_date` AS `next_bill_date`,`t_provider`.`last_payment_date` AS `last_payment_date`,`t_provider`.`is_active` AS `is_active`,`t_provider`.`create_date` AS `create_date`,`t_provider`.`activate_date` AS `activate_date`,`t_provider`.`billing_start_date` AS `billing_start_date`,`t_provider`.`deactivate_date` AS `deactivate_date`,`t_provider`.`description` AS `description`,`t_provider`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`t_provider`.`invoicing_method` AS `invoicing_method`,`t_provider`.`invoice_processing_method` AS `invoice_processing_method`,`t_provider`.`billing_address_line_1` AS `billing_address_line_1`,`t_provider`.`billing_address_line_2` AS `billing_address_line_2`,`t_provider`.`billing_address_city` AS `billing_address_city`,`t_provider`.`billing_address_region` AS `billing_address_region`,`t_provider`.`billing_address_country` AS `billing_address_country`,`t_provider`.`billing_address_postal_code` AS `billing_address_postal_code`,`t_provider`.`legal_address_line_1` AS `legal_address_line_1`,`t_provider`.`legal_address_line_2` AS `legal_address_line_2`,`t_provider`.`legal_address_city` AS `legal_address_city`,`t_provider`.`legal_address_region` AS `legal_address_region`,`t_provider`.`legal_address_country` AS `legal_address_country`,`t_provider`.`legal_address_postal_code` AS `legal_address_postal_code`,`t_provider`.`payer_payment_details` AS `payer_payment_details`,`t_provider`.`payee_payment_details` AS `payee_payment_details`,`t_provider`.`public_url` AS `public_url`,`t_provider`.`management_region_id` AS `management_region_id`,`t_provider`.`balance_due` AS `balance_due`,`t_provider`.`openbook_processes_payments` AS `openbook_processes_payments`,`t_provider`.`openbook_processes_past_due_invoices` AS `openbook_processes_past_due_invoices`,`t_provider`.`openstack_tenant_id` AS `openstack_tenant_id`,`t_provider`.`tax_id` AS `tax_id`,`t_provider`.`registration_number` AS `registration_number`,`t_provider`.`os_service_manager_id` AS `os_service_manager_id`,`t_region`.`parent_region_id` AS `parent_management_region_id` from (`t_provider` left join `t_region` on(`t_region`.`region_id` = `t_provider`.`management_region_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_rate_plan_assignment`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_rate_plan_assignment` AS select `a`.`rate_plan_id` AS `rate_plan_id`,`a`.`assignee_id` AS `assignee_id`,`a`.`assignee_type` AS `assignee_type`,`a`.`assignment_start_date` AS `assignment_start_date`,`a`.`assignment_end_date` AS `assignment_end_date`,`a`.`assignment_type` AS `assignment_type`,`r`.`management_region_id` AS `management_region_id` from (`t_rate_plan_assignment` `a` left join `t_rate_plan` `r` on(`a`.`rate_plan_id` = `r`.`rate_plan_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_service`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_service` AS select `s`.`service_id` AS `service_id`,`s`.`service_type` AS `service_type`,`s`.`service_description` AS `service_description`,`s`.`service_manager_type_id` AS `service_manager_type_id`,`s`.`states` AS `states`,`s`.`externally_managed` AS `externally_managed`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_service` `s` left join `t_service_manager_type` `sm` on(`s`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_service_instance`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_service_instance` AS select `tsi`.`service_instance_id` AS `service_instance_id`,`tsi`.`service_id` AS `service_id`,`tsi`.`service_instance_name` AS `service_instance_name`,`tsi`.`service_manager_id` AS `service_manager_id`,`tsi`.`service_region_id` AS `service_region_id`,`tsi`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tsi`.`tenant_id` AS `tenant_id`,`tsi`.`current_attributes` AS `current_attributes`,`tt`.`tenant_name` AS `tenant_name`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tr`.`region_name` AS `service_region_name`,`tsmt`.`service_manager_type` AS `service_manager_type`,`ts`.`service_type` AS `service_type`,`tsis`.`start_date` AS `provisioned_date`,`tsis`.`end_date` AS `deprovisioned_date` from (((((((`t_service_instance` `tsi` left join `t_tenant` `tt` on(`tsi`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tc`.`customer_id` = `tt`.`customer_id`)) left join `t_service` `ts` on(`tsi`.`service_id` = `ts`.`service_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_region` `tr` on(`tsi`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager` `tsm` on(`tsi`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_instance_state` `tsis` on(`tsi`.`service_instance_id` = `tsis`.`service_instance_id` and `tsis`.`state` = 'In Existence')) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_service_instance_attributes`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_service_instance_attributes` AS select `tpsa`.`service_instance_id` AS `service_instance_id`,`tpsa`.`start_date` AS `start_date`,`tpsa`.`end_date` AS `end_date`,`tpsa`.`attributes` AS `attributes`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_attributes` `tpsa` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpsa`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_service_instance_state`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_service_instance_state` AS select `tpss`.`service_instance_id` AS `service_instance_id`,`tpss`.`state` AS `state`,`tpss`.`start_date` AS `start_date`,`tpss`.`end_date` AS `end_date`,`tpss`.`interval_length_milliseconds` AS `interval_length_milliseconds`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_state` `tpss` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpss`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_service_manager`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_service_manager` AS select `tsm`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tsm`.`service_manager_description` AS `service_manager_description`,`tsm`.`metadata` AS `metadata`,`tsm`.`service_region_id` AS `service_region_id`,`tsm`.`service_manager_type_id` AS `service_manager_type_id`,`tsmt`.`service_manager_type` AS `service_manager_type` from (`t_service_manager` `tsm` left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_tenant`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_tenant` AS select `t`.`tenant_id` AS `tenant_id`,`t`.`tenant_name` AS `tenant_name`,`t`.`tenant_foreign_id` AS `tenant_foreign_id`,`t`.`create_date` AS `create_date`,`t`.`deactivate_date` AS `deactivate_date`,`t`.`customer_id` AS `customer_id`,`t`.`service_manager_id` AS `service_manager_id`,`t`.`is_active` AS `is_active`,`c`.`customer_name` AS `customer_name`,`c`.`management_region_id` AS `management_region_id`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tt`.`name` AS `tenant_type` from ((((`t_tenant` `t` left join `t_customer` `c` on(`t`.`customer_id` = `c`.`customer_id`)) left join `t_service_manager` `tsm` on(`t`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant_type` `tt` on(`t`.`tenant_type_id` = `tt`.`id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-/*!50001 DROP TABLE IF EXISTS `v_users`*/;
-/*!50001 SET @saved_cs_client          = @@character_set_client */;
-/*!50001 SET @saved_cs_results         = @@character_set_results */;
-/*!50001 SET @saved_col_connection     = @@collation_connection */;
-/*!50001 SET character_set_client      = utf8 */;
-/*!50001 SET character_set_results     = utf8 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
-/*!50001 CREATE ALGORITHM=UNDEFINED */
-/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
-/*!50001 VIEW `v_users` AS select `u`.`user_id` AS `user_id`,`u`.`username` AS `username`,`u`.`first_name` AS `first_name`,`u`.`last_name` AS `last_name`,`u`.`email_address` AS `email_address`,`u`.`phone_number` AS `phone_number`,`u`.`password` AS `password`,`u`.`is_active` AS `is_active`,`u`.`password_change_token` AS `password_change_token`,`u`.`last_password_change_date` AS `last_password_change_date`,`u`.`password_change_token_expire_date` AS `password_change_token_expire_date`,`r`.`role_name` AS `role_name`,`r`.`role_context` AS `role_context` from (`t_users` `u` left join `t_user_roles` `r` on(`u`.`user_id` = `r`.`user_id`)) */;
-/*!50001 SET character_set_client      = @saved_cs_client */;
-/*!50001 SET character_set_results     = @saved_cs_results */;
-/*!50001 SET collation_connection      = @saved_col_connection */;
-
-GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-
-USE `openbook_jobs`;
-
-GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
-
-USE `openbook_workflow`;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
 use openbook;
 CALL p_preallocate_partitions('t_metric_values', 'metric_datetime', CURDATE(), 31);
 CALL p_preallocate_partitions('t_metric_aggregate_resource_hourly', 'aggregate_datetime', CURDATE(), 31);