initial commit

8 files changed, 2649 insertions, 0 deletions

diff --git a/templates/database/etc/openbook/database/bin/fix_permissions.sh b/templates/database/etc/openbook/database/bin/fix_permissions.sh
new file mode 100755
index 0000000..69f2b75
--- /dev/null
+++ b/templates/database/etc/openbook/database/bin/fix_permissions.sh
@@ -0,0 +1,39 @@
+#!/bin/bash
+
+sed -e 's|{{ "{{" }} openbook_database_password {{ "}}" }}|{{ openbook_database_password }}|g' -i /root/.my.cnf
+
+# wait for mysql to start
+for i in {120..0}; do
+	if echo 'SELECT 1' | mysql &>/dev/null; then
+		break
+	fi
+    sleep 1
+done
+
+# privilege fixes - must be idempotent!
+mysql <<EOF
+DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('%', 'localhost', '127.0.0.1', '127.0.2.1', '::', '::1');
+DELETE FROM mysql.user WHERE User='';
+DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';
+FLUSH PRIVILEGES;
+GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '{{ openbook_database_password }}' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '{{ openbook_database_password }}' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY '{{ openbook_database_password }}' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '{{ openbook_database_password }}' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO 'openbook'@'localhost' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO 'openbook'@'127.0.0.1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO 'openbook'@'::1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO 'openbook'@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO 'openbook'@'localhost' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO 'openbook'@'127.0.0.1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO 'openbook'@'::1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO 'openbook'@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO 'openbook'@'localhost' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO 'openbook'@'127.0.0.1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO 'openbook'@'::1' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO 'openbook'@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+FLUSH PRIVILEGES;
+EOF
+
+exit 0
diff --git a/templates/database/etc/openbook/database/bin/start_galera_node.sh b/templates/database/etc/openbook/database/bin/start_galera_node.sh
new file mode 100755
index 0000000..ee580d8
--- /dev/null
+++ b/templates/database/etc/openbook/database/bin/start_galera_node.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+
+# the mysql database files will be missing if this is the first startup after a fresh install
+if [ ! -d "/var/lib/mysql/mysql" ]; then
+    export DEBIAN_FRONTEND=noninteractive
+    . /etc/profile
+    debconf-set-selections /etc/mysql/conf.d/debconfrc
+    dpkg-reconfigure mariadb-server-10.2
+fi
+
+/etc/mysql/bin/fix_permissions.sh &
+/etc/init.d/xinetd start
+exec /usr/sbin/mysqld ${@}
diff --git a/templates/database/etc/openbook/database/conf.d/cluster.cnf b/templates/database/etc/openbook/database/conf.d/cluster.cnf
new file mode 100644
index 0000000..cbc26a6
--- /dev/null
+++ b/templates/database/etc/openbook/database/conf.d/cluster.cnf
@@ -0,0 +1,17 @@
+[mysqld]
+query_cache_size=0
+default-storage-engine=innodb
+query_cache_type=0
+group_concat_max_len=1000000
+innodb_autoinc_lock_mode=2
+innodb_locks_unsafe_for_binlog=1
+binlog_format=row
+
+[galera]
+wsrep_on=ON
+wsrep_provider=/usr/lib/galera/libgalera_smm.so
+wsrep_cluster_name="openbook_cluster"
+wsrep_cluster_address="gcomm://{{ openbook_gcomm_addresses }}"
+wsrep_sst_method=rsync
+wsrep_node_address="{{ ansible_default_ipv4.address }}"
+wsrep_node_name="{{ ansible_hostname }}"
diff --git a/templates/database/etc/openbook/database/conf.d/debconfrc b/templates/database/etc/openbook/database/conf.d/debconfrc
new file mode 100644
index 0000000..e86387e
--- /dev/null
+++ b/templates/database/etc/openbook/database/conf.d/debconfrc
@@ -0,0 +1,2 @@
+mariadb-server-10.2 mysql-server/root_password password {{ openbook_database_password }}
+mariadb-server-10.2 mysql-server/root_password_again password {{ openbook_database_password }}
diff --git a/templates/database/etc/openbook/database/create_openbook_schemas.sql b/templates/database/etc/openbook/database/create_openbook_schemas.sql
new file mode 100644
index 0000000..d3011e2
--- /dev/null
+++ b/templates/database/etc/openbook/database/create_openbook_schemas.sql
@@ -0,0 +1,2538 @@
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET latin1 */;
+GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+USE `openbook`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DATABASECHANGELOG` (
+  `ID` varchar(63) NOT NULL,
+  `AUTHOR` varchar(63) NOT NULL,
+  `FILENAME` varchar(200) NOT NULL,
+  `DATEEXECUTED` datetime NOT NULL,
+  `ORDEREXECUTED` int(11) NOT NULL,
+  `EXECTYPE` varchar(10) NOT NULL,
+  `MD5SUM` varchar(35) DEFAULT NULL,
+  `DESCRIPTION` varchar(255) DEFAULT NULL,
+  `COMMENTS` varchar(255) DEFAULT NULL,
+  `TAG` varchar(255) DEFAULT NULL,
+  `LIQUIBASE` varchar(20) DEFAULT NULL,
+  `CONTEXTS` varchar(255) DEFAULT NULL,
+  `LABELS` varchar(255) DEFAULT NULL,
+  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL,
+  PRIMARY KEY (`ID`,`AUTHOR`,`FILENAME`)
+) 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 `DATABASECHANGELOGLOCK` (
+  `ID` int(11) NOT NULL,
+  `LOCKED` tinyint(1) NOT NULL,
+  `LOCKGRANTED` datetime DEFAULT NULL,
+  `LOCKEDBY` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`ID`)
+) 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 `t_adhoc_charge` (
+  `charge_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `posted_date` datetime(6) NOT NULL,
+  `product_name` varchar(64) NOT NULL,
+  `invoice_group` varchar(64) NOT NULL,
+  `quantity` decimal(36,12) DEFAULT NULL,
+  `quantity_units` varchar(128) DEFAULT NULL,
+  `rate` decimal(22,12) DEFAULT NULL,
+  `charge` decimal(19,2) NOT NULL,
+  `currency` varchar(3) NOT NULL,
+  `item_detail` varchar(1024) DEFAULT NULL,
+  PRIMARY KEY (`charge_id`),
+  KEY `ix_adhoc_charge_1` (`payer_id`,`payer_type`,`posted_date`)
+) 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 `t_app_config` (
+  `property_group` varchar(128) NOT NULL,
+  `property_name` varchar(128) NOT NULL,
+  `property_value` text DEFAULT NULL
+) 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 `t_audit_event` (
+  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `event_time` datetime(6) NOT NULL,
+  `event_type` varchar(32) NOT NULL,
+  `entity_id` varchar(64) NOT NULL,
+  `entity_name` varchar(255) DEFAULT NULL,
+  `entity_type` varchar(45) NOT NULL,
+  `user_id` varchar(128) DEFAULT NULL,
+  `event_data` longtext DEFAULT NULL,
+  PRIMARY KEY (`event_id`),
+  KEY `ix_audit_event_1` (`event_time`,`event_type`,`entity_id`),
+  KEY `ix_audit_event_2` (`user_id`,`event_time`)
+) ENGINE=InnoDB AUTO_INCREMENT=1801 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_aws_raw_charges` (
+  `identity_LineItemId` varchar(64) DEFAULT NULL,
+  `sync_timestamp` datetime DEFAULT NULL,
+  `bill_InvoiceId` varchar(64) DEFAULT NULL,
+  `bill_BillingEntity` varchar(64) DEFAULT NULL,
+  `bill_BillType` varchar(64) DEFAULT NULL,
+  `bill_PayerAccountId` varchar(64) DEFAULT NULL,
+  `bill_BillingPeriodStartDate` varchar(64) DEFAULT NULL,
+  `bill_BillingPeriodEndDate` varchar(64) DEFAULT NULL,
+  `lineItem_UsageAccountId` varchar(64) DEFAULT NULL,
+  `lineItem_LineItemType` varchar(64) DEFAULT NULL,
+  `lineItem_UsageStartDate` varchar(64) DEFAULT NULL,
+  `lineItem_UsageEndDate` varchar(64) DEFAULT NULL,
+  `lineItem_ProductCode` varchar(64) DEFAULT NULL,
+  `lineItem_UsageType` varchar(64) DEFAULT NULL,
+  `lineItem_Operation` varchar(64) DEFAULT NULL,
+  `lineItem_AvailabilityZone` varchar(64) DEFAULT NULL,
+  `lineItem_ResourceId` varchar(64) DEFAULT NULL,
+  `lineItem_UsageAmount` decimal(22,12) DEFAULT NULL,
+  `lineItem_CurrencyCode` varchar(64) DEFAULT NULL,
+  `lineItem_UnblendedRate` decimal(22,12) DEFAULT NULL,
+  `lineItem_UnblendedCost` decimal(22,12) DEFAULT NULL,
+  `lineItem_BlendedRate` decimal(22,12) DEFAULT NULL,
+  `lineItem_BlendedCost` decimal(22,12) DEFAULT NULL,
+  `lineItem_LineItemDescription` varchar(256) DEFAULT NULL,
+  `lineItem_TaxType` varchar(64) DEFAULT NULL,
+  `product_ProductName` varchar(64) DEFAULT NULL,
+  `product_availability` varchar(64) DEFAULT NULL,
+  `product_clockSpeed` varchar(64) DEFAULT NULL,
+  `product_durability` varchar(64) DEFAULT NULL,
+  `product_fromLocation` varchar(64) DEFAULT NULL,
+  `product_fromLocationType` varchar(64) DEFAULT NULL,
+  `product_group` varchar(64) DEFAULT NULL,
+  `product_groupDescription` varchar(64) DEFAULT NULL,
+  `product_instanceFamily` varchar(64) DEFAULT NULL,
+  `product_instanceType` varchar(64) DEFAULT NULL,
+  `product_licenseModel` varchar(64) DEFAULT NULL,
+  `product_location` varchar(64) DEFAULT NULL,
+  `product_locationType` varchar(64) DEFAULT NULL,
+  `product_maxIopsBurstPerformance` varchar(64) DEFAULT NULL,
+  `product_maxIopsvolume` varchar(64) DEFAULT NULL,
+  `product_maxThroughputvolume` varchar(64) DEFAULT NULL,
+  `product_maxVolumeSize` varchar(64) DEFAULT NULL,
+  `product_memory` varchar(64) DEFAULT NULL,
+  `product_networkPerformance` varchar(64) DEFAULT NULL,
+  `product_operatingSystem` varchar(64) DEFAULT NULL,
+  `product_operation` varchar(64) DEFAULT NULL,
+  `product_physicalProcessor` varchar(64) DEFAULT NULL,
+  `product_preInstalledSw` varchar(64) DEFAULT NULL,
+  `product_processorArchitecture` varchar(64) DEFAULT NULL,
+  `product_processorFeatures` varchar(64) DEFAULT NULL,
+  `product_productFamily` varchar(64) DEFAULT NULL,
+  `product_servicecode` varchar(64) DEFAULT NULL,
+  `product_sku` varchar(64) DEFAULT NULL,
+  `product_storage` varchar(64) DEFAULT NULL,
+  `product_storageClass` varchar(64) DEFAULT NULL,
+  `product_storageMedia` varchar(64) DEFAULT NULL,
+  `product_tenancy` varchar(64) DEFAULT NULL,
+  `product_toLocation` varchar(64) DEFAULT NULL,
+  `product_toLocationType` varchar(64) DEFAULT NULL,
+  `product_transferType` varchar(64) DEFAULT NULL,
+  `product_usagetype` varchar(64) DEFAULT NULL,
+  `product_vcpu` varchar(64) DEFAULT NULL,
+  `product_volumeType` varchar(64) DEFAULT NULL,
+  `pricing_term` varchar(64) DEFAULT NULL,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) DEFAULT 'Customer',
+  `tenant_name` varchar(64) DEFAULT NULL,
+  `tags` text DEFAULT NULL,
+  UNIQUE KEY `aws_id` (`lineItem_ResourceId`,`lineItem_UsageType`)
+) 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 `t_aws_raw_data` (
+  `identity_LineItemId` varchar(64) DEFAULT NULL,
+  `sync_timestamp` datetime DEFAULT NULL,
+  `bill_InvoiceId` varchar(64) DEFAULT NULL,
+  `bill_BillingEntity` varchar(64) DEFAULT NULL,
+  `bill_BillType` varchar(64) DEFAULT NULL,
+  `bill_PayerAccountId` varchar(64) DEFAULT NULL,
+  `bill_BillingPeriodStartDate` varchar(64) DEFAULT NULL,
+  `bill_BillingPeriodEndDate` varchar(64) DEFAULT NULL,
+  `lineItem_UsageAccountId` varchar(64) DEFAULT NULL,
+  `lineItem_LineItemType` varchar(64) DEFAULT NULL,
+  `lineItem_UsageStartDate` varchar(64) DEFAULT NULL,
+  `lineItem_UsageEndDate` varchar(64) DEFAULT NULL,
+  `lineItem_ProductCode` varchar(64) DEFAULT NULL,
+  `lineItem_UsageType` varchar(64) DEFAULT NULL,
+  `lineItem_Operation` varchar(64) DEFAULT NULL,
+  `lineItem_AvailabilityZone` varchar(64) DEFAULT NULL,
+  `lineItem_ResourceId` varchar(64) DEFAULT NULL,
+  `lineItem_UsageAmount` decimal(22,12) DEFAULT NULL,
+  `lineItem_CurrencyCode` varchar(64) DEFAULT NULL,
+  `lineItem_UnblendedRate` decimal(22,12) DEFAULT NULL,
+  `lineItem_UnblendedCost` decimal(22,12) DEFAULT NULL,
+  `lineItem_BlendedRate` decimal(22,12) DEFAULT NULL,
+  `lineItem_BlendedCost` decimal(22,12) DEFAULT NULL,
+  `lineItem_LineItemDescription` varchar(256) DEFAULT NULL,
+  `lineItem_TaxType` varchar(64) DEFAULT NULL,
+  `product_ProductName` varchar(64) DEFAULT NULL,
+  `product_availability` varchar(64) DEFAULT NULL,
+  `product_clockSpeed` varchar(64) DEFAULT NULL,
+  `product_durability` varchar(64) DEFAULT NULL,
+  `product_fromLocation` varchar(64) DEFAULT NULL,
+  `product_fromLocationType` varchar(64) DEFAULT NULL,
+  `product_group` varchar(64) DEFAULT NULL,
+  `product_groupDescription` varchar(64) DEFAULT NULL,
+  `product_instanceFamily` varchar(64) DEFAULT NULL,
+  `product_instanceType` varchar(64) DEFAULT NULL,
+  `product_licenseModel` varchar(64) DEFAULT NULL,
+  `product_location` varchar(64) DEFAULT NULL,
+  `product_locationType` varchar(64) DEFAULT NULL,
+  `product_maxIopsBurstPerformance` varchar(64) DEFAULT NULL,
+  `product_maxIopsvolume` varchar(64) DEFAULT NULL,
+  `product_maxThroughputvolume` varchar(64) DEFAULT NULL,
+  `product_maxVolumeSize` varchar(64) DEFAULT NULL,
+  `product_memory` varchar(64) DEFAULT NULL,
+  `product_networkPerformance` varchar(64) DEFAULT NULL,
+  `product_operatingSystem` varchar(64) DEFAULT NULL,
+  `product_operation` varchar(64) DEFAULT NULL,
+  `product_physicalProcessor` varchar(64) DEFAULT NULL,
+  `product_preInstalledSw` varchar(64) DEFAULT NULL,
+  `product_processorArchitecture` varchar(64) DEFAULT NULL,
+  `product_processorFeatures` varchar(64) DEFAULT NULL,
+  `product_productFamily` varchar(64) DEFAULT NULL,
+  `product_servicecode` varchar(64) DEFAULT NULL,
+  `product_sku` varchar(64) DEFAULT NULL,
+  `product_storage` varchar(64) DEFAULT NULL,
+  `product_storageClass` varchar(64) DEFAULT NULL,
+  `product_storageMedia` varchar(64) DEFAULT NULL,
+  `product_tenancy` varchar(64) DEFAULT NULL,
+  `product_toLocation` varchar(64) DEFAULT NULL,
+  `product_toLocationType` varchar(64) DEFAULT NULL,
+  `product_transferType` varchar(64) DEFAULT NULL,
+  `product_usagetype` varchar(64) DEFAULT NULL,
+  `product_vcpu` varchar(64) DEFAULT NULL,
+  `product_volumeType` varchar(64) DEFAULT NULL,
+  `pricing_term` varchar(64) DEFAULT NULL,
+  `tags` text DEFAULT NULL
+) 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 `t_credit` (
+  `credit_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `credit_amount` decimal(19,2) DEFAULT NULL,
+  `remaining_amount` decimal(19,2) DEFAULT NULL,
+  `credit_type` varchar(16) NOT NULL,
+  `granted_by` varchar(256) NOT NULL,
+  `posted_date` datetime(6) NOT NULL,
+  `expire_date` datetime(6) NOT NULL,
+  `currency` varchar(3) NOT NULL,
+  `memo` varchar(1024) DEFAULT NULL,
+  PRIMARY KEY (`credit_id`),
+  KEY `ix_credit_1` (`payer_id`,`payer_type`,`expire_date`)
+) 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 `t_customer` (
+  `customer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `customer_name` varchar(512) NOT NULL,
+  `created_via` varchar(128) DEFAULT NULL,
+  `metadata` text DEFAULT NULL,
+  `tax_rate` decimal(18,4) DEFAULT 0.0000,
+  `currency` char(6) DEFAULT NULL,
+  `discount_percent` decimal(18,4) DEFAULT 0.0000,
+  `billing_frequency` varchar(40) DEFAULT NULL,
+  `last_bill_date` datetime(6) DEFAULT NULL,
+  `next_bill_date` datetime(6) DEFAULT NULL,
+  `is_active` tinyint(1) DEFAULT 1,
+  `create_date` datetime(6) DEFAULT NULL,
+  `activate_date` datetime(6) DEFAULT NULL,
+  `billing_start_date` datetime(6) DEFAULT NULL,
+  `last_payment_date` datetime(6) DEFAULT NULL,
+  `deactivate_date` datetime(6) DEFAULT NULL,
+  `description` varchar(5120) DEFAULT NULL,
+  `minimum_invoice_commitment` decimal(19,2) DEFAULT NULL,
+  `invoicing_method` varchar(32) NOT NULL,
+  `management_region_id` varchar(64) DEFAULT NULL,
+  `billing_address_line_1` varchar(512) DEFAULT NULL,
+  `billing_address_line_2` varchar(512) DEFAULT NULL,
+  `billing_address_city` varchar(512) DEFAULT NULL,
+  `billing_address_region` varchar(128) DEFAULT NULL,
+  `billing_address_country` varchar(2) DEFAULT NULL,
+  `billing_address_postal_code` varchar(64) DEFAULT NULL,
+  `payer_payment_details` varchar(5120) DEFAULT '{"PaymentMethod":"None"}',
+  `payment_method_confirmed` tinyint(1) DEFAULT 0,
+  `balance_due` decimal(19,2) DEFAULT NULL,
+  `spend_soft_limit` decimal(12,2) DEFAULT NULL,
+  `spend_hard_limit` decimal(12,2) DEFAULT NULL,
+  `terms_and_conditions_2_accept_date` datetime(6) DEFAULT NULL,
+  `tax_id` varchar(128) DEFAULT NULL,
+  `registration_number` varchar(128) DEFAULT NULL,
+  PRIMARY KEY (`customer_id`),
+  UNIQUE KEY `ix_customer_3` (`management_region_id`,`customer_name`(255))
+) ENGINE=InnoDB AUTO_INCREMENT=315465 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_discount` (
+  `discount_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `discount_percent` decimal(5,2) NOT NULL,
+  `granted_by` varchar(256) NOT NULL,
+  `apply_to_charge_category` varchar(32) DEFAULT NULL,
+  `trigger_charge_category` varchar(32) DEFAULT NULL,
+  `trigger_amount` decimal(19,2) DEFAULT NULL,
+  `start_date` datetime(6) NOT NULL,
+  `end_date` datetime(6) NOT NULL,
+  PRIMARY KEY (`discount_id`),
+  KEY `ix_discount_1` (`payer_id`,`payer_type`,`end_date`)
+) 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 `t_email_notification` (
+  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `recipient` varchar(128) NOT NULL,
+  `sender` varchar(128) NOT NULL,
+  `subject` varchar(256) NOT NULL,
+  `message_text` longtext NOT NULL,
+  `smtp_server_details` longtext NOT NULL,
+  `date_generated` datetime(6) NOT NULL,
+  `date_sent` datetime(6) DEFAULT NULL,
+  `date_last_send_attempt` datetime(6) DEFAULT NULL,
+  `send_status` varchar(16) DEFAULT NULL,
+  `send_status_detail` varchar(5120) DEFAULT NULL,
+  `send_attempt_count` smallint(6) DEFAULT NULL,
+  `payer_id` int(10) unsigned DEFAULT NULL,
+  `payer_type` varchar(64) DEFAULT NULL,
+  `message_type` varchar(128) NOT NULL,
+  PRIMARY KEY (`message_id`),
+  KEY `ix_email_notification_1` (`recipient`,`date_generated`),
+  KEY `ix_email_notification_2` (`sender`,`date_generated`),
+  KEY `ix_email_notification_3` (`date_sent`),
+  KEY `ix_email_notification_4` (`payer_id`,`payer_type`,`message_type`,`date_sent`)
+) 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 `t_email_template` (
+  `provider_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `template_subject` varchar(256) NOT NULL,
+  `template_name` varchar(128) NOT NULL,
+  `template_text` longtext NOT NULL,
+  PRIMARY KEY (`provider_id`,`template_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 `t_entity_attribute` (
+  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `attribute_class` varchar(32) NOT NULL,
+  `attribute_category` varchar(128) NOT NULL,
+  `attribute_name` varchar(128) NOT NULL,
+  `attribute_value` varchar(512) NOT NULL,
+  `attribute_unit` varchar(64) DEFAULT NULL,
+  `add_date` datetime(6) DEFAULT NULL,
+  `expire_date` datetime(6) NOT NULL,
+  PRIMARY KEY (`entity_id`,`expire_date`,`attribute_class`,`attribute_category`,`attribute_name`),
+  KEY `ix_entity_attribute_1` (`attribute_class`),
+  KEY `ix_entity_attribute_2` (`attribute_category`),
+  KEY `ix_entity_attribute_3` (`attribute_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 `t_exception_event` (
+  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `event_time` datetime(6) NOT NULL,
+  `event_type` varchar(32) NOT NULL,
+  `entity_id` varchar(64) NOT NULL,
+  `entity_name` varchar(255) DEFAULT NULL,
+  `entity_type` varchar(45) NOT NULL,
+  `user_id` varchar(128) DEFAULT NULL,
+  `event_data` longtext DEFAULT NULL,
+  PRIMARY KEY (`event_id`),
+  KEY `ix_exception_event_1` (`event_time`,`event_type`,`entity_id`),
+  KEY `ix_exception_event_2` (`user_id`,`event_time`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 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_gcp_raw_charges` (
+  `accountId` varchar(128) DEFAULT NULL,
+  `amount` decimal(22,12) DEFAULT NULL,
+  `cost` varchar(64) DEFAULT NULL,
+  `creditId` varchar(64) DEFAULT NULL,
+  `credits` varchar(64) DEFAULT NULL,
+  `currency` varchar(64) DEFAULT NULL,
+  `description` varchar(255) DEFAULT NULL,
+  `endTime` varchar(64) DEFAULT NULL,
+  `lineItemId` varchar(255) DEFAULT NULL,
+  `measurementId` varchar(64) DEFAULT NULL,
+  `measurements` varchar(64) DEFAULT NULL,
+  `projectId` varchar(64) DEFAULT NULL,
+  `projectName` varchar(64) DEFAULT NULL,
+  `projectNumber` varchar(64) DEFAULT NULL,
+  `startTime` varchar(64) DEFAULT NULL,
+  `sum` bigint(20) DEFAULT NULL,
+  `unit` varchar(64) DEFAULT NULL,
+  `payer_id` int(10) unsigned DEFAULT 0,
+  `payer_type` varchar(64) DEFAULT 'Customer',
+  `tenant_name` varchar(64) DEFAULT NULL,
+  `tags` text DEFAULT NULL
+) 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 `t_host` (
+  `host_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `service_region_id` int(10) unsigned NOT NULL,
+  `host_foreign_id` varchar(256) DEFAULT NULL,
+  `host_name` varchar(256) NOT NULL,
+  `hypervisor_type` varchar(64) DEFAULT NULL,
+  `add_date` datetime(6) NOT NULL,
+  `remove_date` datetime(6) NOT NULL,
+  `cpu_allocation_ratio` decimal(6,2) DEFAULT NULL,
+  `ram_allocation_ratio` decimal(6,2) DEFAULT NULL,
+  `host_aggregate` varchar(255) DEFAULT NULL,
+  `disk_allocation_ratio` decimal(6,2) DEFAULT NULL,
+  PRIMARY KEY (`host_id`),
+  KEY `ix_host_1` (`service_manager_id`,`service_region_id`,`host_foreign_id`(255))
+) ENGINE=InnoDB AUTO_INCREMENT=1858 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_host_attributes` (
+  `host_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `update_date` datetime(6) NOT NULL,
+  `ram_mb` int(11) NOT NULL,
+  `ram_mb_used` int(11) NOT NULL,
+  `disk_gb` int(11) NOT NULL,
+  `disk_gb_used` int(11) NOT NULL,
+  `vcpus` int(11) NOT NULL,
+  `vcpus_used` int(11) NOT NULL,
+  `vm_count` int(11) NOT NULL,
+  `socket_count` int(11) NOT NULL,
+  PRIMARY KEY (`host_id`,`update_date`)
+) ENGINE=InnoDB AUTO_INCREMENT=1858 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_invoice` (
+  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `payer_name` varchar(512) NOT NULL,
+  `invoice_number` varchar(45) DEFAULT NULL,
+  `invoice_date` datetime(6) NOT NULL,
+  `period_begin` datetime(6) NOT NULL,
+  `period_end` datetime(6) NOT NULL,
+  `invoice_amount` decimal(19,2) NOT NULL,
+  `actual_charges` decimal(19,2) NOT NULL,
+  `invoice_currency` varchar(16) DEFAULT NULL,
+  `management_region_id` int(10) unsigned NOT NULL,
+  `balance_due` decimal(19,2) NOT NULL,
+  `invoice_pdf` longblob DEFAULT NULL,
+  `payment_processing` tinyint(1) DEFAULT 0,
+  `payer_metadata` text DEFAULT NULL,
+  PRIMARY KEY (`invoice_id`),
+  KEY `ix_invoice_1` (`management_region_id`,`payer_type`,`payer_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=12484695 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_invoice_detail` (
+  `invoice_id` int(10) unsigned NOT NULL,
+  `customer_id` int(10) unsigned DEFAULT NULL,
+  `customer_name` varchar(255) DEFAULT NULL,
+  `service_region_id` int(10) unsigned DEFAULT NULL,
+  `service_region_name` varchar(128) DEFAULT NULL,
+  `rate` decimal(22,12) NOT NULL,
+  `rate_display` varchar(255) DEFAULT NULL,
+  `rate_unit` varchar(128) NOT NULL,
+  `rate_interval` varchar(128) DEFAULT NULL,
+  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
+  `units_billed` decimal(36,12) DEFAULT NULL,
+  `units_billed_display` varchar(128) DEFAULT NULL,
+  `item_invoice_amount` decimal(19,2) NOT NULL,
+  `item_category` varchar(128) NOT NULL,
+  `item_group` varchar(128) NOT NULL,
+  `item_type` varchar(128) NOT NULL,
+  `item_detail` varchar(512) NOT NULL,
+  `tenant_id` int(10) unsigned DEFAULT NULL,
+  `tenant_name` varchar(256) DEFAULT NULL,
+  `stack_type` varchar(16) DEFAULT NULL,
+  `service_manager_id` int(10) unsigned DEFAULT NULL,
+  `service_manager_name` varchar(128) DEFAULT NULL,
+  `service_instance_metadata` text DEFAULT NULL,
+  KEY `ix_invoice_detail_1` (`invoice_id`),
+  KEY `ix_invoice_detail_2` (`customer_id`),
+  KEY `ix_invoice_detail_4` (`invoice_id`,`customer_name`,`item_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 `t_job_status` (
+  `job_id` varchar(256) NOT NULL,
+  `start_time` datetime(6) NOT NULL,
+  `end_time` datetime(6) DEFAULT NULL,
+  `status` varchar(32) DEFAULT NULL,
+  `result` varchar(32) DEFAULT NULL,
+  `result_detail` longtext DEFAULT NULL,
+  PRIMARY KEY (`job_id`(255),`start_time`)
+) 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 `t_lookup_values` (
+  `type` varchar(128) NOT NULL,
+  `name` varchar(256) NOT NULL,
+  `value` longtext NOT NULL,
+  PRIMARY KEY (`type`,`name`(255))
+) 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 `t_metadata_attributes` (
+  `entity_id` int(10) unsigned NOT NULL,
+  `entity_type` varchar(32) NOT NULL,
+  `name` varchar(128) NOT NULL,
+  `datatype` varchar(16) NOT NULL,
+  `unit` varchar(16) DEFAULT NULL,
+  `value_range` text DEFAULT NULL,
+  PRIMARY KEY (`entity_id`,`entity_type`,`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 `t_metric` (
+  `metric_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_manager_type_id` int(10) unsigned DEFAULT NULL,
+  `metric_name` varchar(128) DEFAULT NULL,
+  `metric_label` varchar(128) DEFAULT NULL,
+  `metric_source` varchar(32) DEFAULT NULL,
+  `metric_type` varchar(16) NOT NULL,
+  `metric_unit` varchar(16) NOT NULL,
+  `entity_resolution` varchar(32) NOT NULL,
+  `time_resolution` varchar(16) NOT NULL,
+  PRIMARY KEY (`metric_id`),
+  UNIQUE KEY `ix_metric_1` (`service_manager_type_id`,`metric_name`)
+) ENGINE=InnoDB AUTO_INCREMENT=56 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_metric_aggregate_customer_daily` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_customer_hourly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_customer_monthly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
+) 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 `t_metric_aggregate_resource_daily` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `resource_id` int(11) NOT NULL DEFAULT 0,
+  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_resource_hourly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `resource_id` int(11) NOT NULL DEFAULT 0,
+  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
+  `tenant_id` int(11) NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_resource_monthly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `resource_id` int(11) NOT NULL DEFAULT 0,
+  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
+) 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 `t_metric_aggregate_tenant_daily` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `tenant_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_tenant_hourly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `tenant_id` int(11) NOT NULL DEFAULT 0,
+  `customer_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+ PARTITION BY RANGE (to_days(`aggregate_datetime`));
+/*!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_metric_aggregate_tenant_monthly` (
+  `metric_id` int(11) NOT NULL DEFAULT 0,
+  `tenant_id` int(11) NOT NULL DEFAULT 0,
+  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `min` double DEFAULT NULL,
+  `max` double DEFAULT NULL,
+  `avg` double DEFAULT NULL,
+  `sum` double DEFAULT NULL,
+  `count` int(11) DEFAULT NULL,
+  `sum_of_hourly_max` double DEFAULT NULL,
+  `sum_of_hourly_avg` double DEFAULT NULL,
+  `diff_of_min_max` double DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
+) 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 `t_metric_values` (
+  `metric_id` int(11) NOT NULL,
+  `resource_id` int(11) DEFAULT NULL,
+  `resource_foreign_id` varchar(256) DEFAULT NULL,
+  `service_manager_id` int(11) DEFAULT NULL,
+  `tenant_id` int(11) DEFAULT NULL,
+  `tenant_foreign_id` varchar(64) DEFAULT NULL,
+  `customer_id` int(11) DEFAULT NULL,
+  `metric_datetime` datetime(6) DEFAULT NULL,
+  `metric_value` double NOT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  KEY `ix_metric_values_1` (`metric_id`,`resource_id`,`service_region_id`,`metric_datetime`),
+  KEY `ix_metric_values_2` (`metric_id`,`tenant_id`,`service_region_id`,`metric_datetime`),
+  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`));
+/*!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_parent_child_relationships` (
+  `parent_id` int(10) unsigned NOT NULL,
+  `parent_type` varchar(64) NOT NULL,
+  `child_id` int(10) unsigned NOT NULL,
+  `child_type` varchar(64) NOT NULL,
+  `add_date` datetime(6) NOT NULL,
+  `remove_date` datetime(6) NOT NULL,
+  PRIMARY KEY (`parent_id`,`parent_type`,`child_id`,`child_type`,`add_date`,`remove_date`),
+  KEY `ix_parent_child_relationships_1` (`child_id`,`child_type`),
+  KEY `ix_parent_child_relationships_2` (`parent_id`,`parent_type`)
+) 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 `t_payment` (
+  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `payment_date` datetime(6) NOT NULL,
+  `amount` decimal(19,2) NOT NULL,
+  `payment_method` varchar(64) NOT NULL,
+  `payment_reference` varchar(256) DEFAULT NULL,
+  `payment_method_detail` longtext DEFAULT NULL,
+  `payment_status` varchar(64) DEFAULT NULL,
+  `payment_status_detail` longtext DEFAULT NULL,
+  `external_reference` varchar(256) DEFAULT NULL,
+  PRIMARY KEY (`payment_id`),
+  KEY `ix_payment_1` (`payer_type`,`payer_id`,`payment_date`)
+) 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 `t_product` (
+  `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `product_name` varchar(64) NOT NULL,
+  `product_type` varchar(16) NOT NULL,
+  `base_entity_id` int(10) unsigned DEFAULT NULL,
+  `product_group` varchar(64) NOT NULL,
+  `product_details` text DEFAULT NULL,
+  `active_product` tinyint(4) NOT NULL,
+  `public_product` tinyint(4) NOT NULL,
+  `management_region_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`product_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=91 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_promo_code` (
+  `management_region_id` int(10) unsigned NOT NULL,
+  `promo_code_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `promo_code` varchar(128) NOT NULL,
+  `salesperson` varchar(128) DEFAULT NULL,
+  `discount_or_credit` varchar(8) NOT NULL,
+  `credit_amount` decimal(19,2) DEFAULT NULL,
+  `credit_type` varchar(16) DEFAULT NULL,
+  `apply_to_charge_category` varchar(32) DEFAULT NULL,
+  `trigger_charge_category` varchar(32) DEFAULT NULL,
+  `trigger_amount` decimal(19,2) DEFAULT NULL,
+  `discount_percent` decimal(5,2) DEFAULT NULL,
+  `available_invoice_periods` int(11) DEFAULT NULL,
+  `expire_date` datetime(6) DEFAULT NULL,
+  `currency` varchar(3) DEFAULT NULL,
+  PRIMARY KEY (`promo_code_id`),
+  UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`),
+  KEY `ix_promo_code_1` (`promo_code`),
+  KEY `ix_promo_code_2` (`salesperson`)
+) 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 `t_promo_code_redemption` (
+  `promo_code_id` int(10) unsigned NOT NULL,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `redemption_date` datetime(6) DEFAULT NULL,
+  PRIMARY KEY (`payer_id`,`promo_code_id`)
+) 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 `t_properties_schema` (
+  `property_group` varchar(128) NOT NULL,
+  `property_name` varchar(128) NOT NULL,
+  `default_value` text DEFAULT NULL,
+  `form_label` varchar(1024) NOT NULL,
+  `form_order` smallint(6) NOT NULL,
+  `data_type` varchar(16) NOT NULL,
+  `data_format` varchar(32) DEFAULT NULL,
+  `permitted_values` text DEFAULT NULL,
+  `required` tinyint(4) NOT NULL DEFAULT 0,
+  `description` varchar(2048) DEFAULT NULL,
+  `property_type` tinyint(4) NOT NULL DEFAULT 0,
+  PRIMARY KEY (`property_group`,`property_name`,`property_type`)
+) 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 `t_provider` (
+  `provider_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `provider_name` varchar(512) NOT NULL,
+  `provider_type` varchar(64) NOT NULL,
+  `metadata` text DEFAULT NULL,
+  `tax_rate` decimal(18,4) DEFAULT 0.0000,
+  `currency` char(6) DEFAULT NULL,
+  `discount_percent` decimal(18,4) DEFAULT 0.0000,
+  `billing_frequency` varchar(40) DEFAULT NULL,
+  `last_bill_date` datetime(6) DEFAULT NULL,
+  `next_bill_date` datetime(6) DEFAULT NULL,
+  `last_payment_date` datetime(6) DEFAULT NULL,
+  `is_active` tinyint(1) DEFAULT 1,
+  `create_date` datetime(6) DEFAULT NULL,
+  `activate_date` datetime(6) DEFAULT NULL,
+  `billing_start_date` datetime(6) DEFAULT NULL,
+  `deactivate_date` datetime(6) DEFAULT NULL,
+  `description` longtext DEFAULT NULL,
+  `minimum_invoice_commitment` decimal(19,2) DEFAULT NULL,
+  `invoicing_method` varchar(32) DEFAULT NULL,
+  `invoice_processing_method` varchar(32) DEFAULT NULL,
+  `billing_address_line_1` varchar(512) DEFAULT NULL,
+  `billing_address_line_2` varchar(512) DEFAULT NULL,
+  `billing_address_city` varchar(512) DEFAULT NULL,
+  `billing_address_region` varchar(128) DEFAULT NULL,
+  `billing_address_country` varchar(2) DEFAULT NULL,
+  `billing_address_postal_code` varchar(64) DEFAULT NULL,
+  `legal_address_line_1` varchar(512) DEFAULT NULL,
+  `legal_address_line_2` varchar(512) DEFAULT NULL,
+  `legal_address_city` varchar(512) DEFAULT NULL,
+  `legal_address_region` varchar(128) DEFAULT NULL,
+  `legal_address_country` varchar(2) DEFAULT NULL,
+  `legal_address_postal_code` varchar(64) DEFAULT NULL,
+  `payer_payment_details` varchar(5120) DEFAULT NULL,
+  `payee_payment_details` varchar(5120) DEFAULT NULL,
+  `public_url` varchar(512) NOT NULL,
+  `management_region_id` varchar(64) NOT NULL,
+  `balance_due` decimal(19,2) DEFAULT NULL,
+  `openbook_processes_payments` tinyint(1) DEFAULT 0,
+  `openbook_processes_past_due_invoices` tinyint(1) DEFAULT 0,
+  `openstack_tenant_id` varchar(36) DEFAULT NULL,
+  `tax_id` varchar(128) DEFAULT NULL,
+  `registration_number` varchar(128) DEFAULT NULL,
+  `os_service_manager_id` int(10) unsigned DEFAULT NULL,
+  PRIMARY KEY (`provider_id`),
+  UNIQUE KEY `ix_provider_2` (`management_region_id`),
+  UNIQUE KEY `ix_provider_1` (`public_url`(255))
+) ENGINE=InnoDB AUTO_INCREMENT=2 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_provider_payment_processors` (
+  `provider_id` int(10) unsigned NOT NULL,
+  `processor_name` varchar(128) NOT NULL,
+  `property_name` varchar(128) NOT NULL,
+  `property_value` text DEFAULT NULL,
+  PRIMARY KEY (`provider_id`,`processor_name`,`property_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 `t_provider_properties` (
+  `provider_id` int(10) unsigned NOT NULL,
+  `property_group` varchar(128) NOT NULL,
+  `property_name` varchar(128) NOT NULL,
+  `property_value` text DEFAULT NULL,
+  PRIMARY KEY (`provider_id`,`property_group`,`property_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 `t_provider_region` (
+  `provider_id` int(10) unsigned NOT NULL,
+  `region_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`provider_id`,`region_id`)
+) 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 `t_provider_service_manager` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `provider_id` int(11) NOT NULL,
+  `service_manager_id` int(11) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=117 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_rate` (
+  `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `rate_plan_id` int(10) unsigned NOT NULL,
+  `description` varchar(256) DEFAULT NULL,
+  `product_id` int(10) unsigned NOT NULL,
+  `service_region_id` int(10) unsigned NOT NULL,
+  `rate_structure` text NOT NULL,
+  PRIMARY KEY (`rate_id`),
+  KEY `ix_rate_1` (`rate_plan_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=681 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_rate_plan` (
+  `rate_plan_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `rate_plan_name` varchar(255) DEFAULT NULL,
+  `applies_to` varchar(32) NOT NULL,
+  `rate_plan_description` varchar(1024) DEFAULT NULL,
+  `currency` char(6) DEFAULT NULL,
+  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
+  `management_region_id` varchar(64) NOT NULL,
+  PRIMARY KEY (`rate_plan_id`),
+  UNIQUE KEY `ix_rate_plan_2` (`management_region_id`,`rate_plan_name`),
+  KEY `ix_rate_plan_1` (`management_region_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=7 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_rate_plan_assignment` (
+  `rate_plan_id` int(10) unsigned NOT NULL,
+  `assignee_id` int(10) unsigned NOT NULL,
+  `assignee_type` varchar(64) NOT NULL,
+  `assignment_start_date` datetime(6) NOT NULL,
+  `assignment_end_date` datetime(6) NOT NULL,
+  `assignment_type` varchar(64) NOT NULL,
+  PRIMARY KEY (`rate_plan_id`,`assignee_id`,`assignment_start_date`,`assignment_end_date`),
+  KEY `ix_rate_plan_assignment_1` (`assignee_type`,`assignee_id`,`assignment_start_date`,`assignment_end_date`),
+  KEY `ix_rate_plan_assignment_2` (`assignment_type`,`assignee_id`,`assignment_start_date`,`assignment_end_date`)
+) 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 `t_region` (
+  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `region_name` varchar(128) NOT NULL,
+  `region_type` varchar(64) NOT NULL,
+  `parent_region_id` int(10) unsigned DEFAULT NULL,
+  PRIMARY KEY (`region_id`),
+  UNIQUE KEY `ix_region_1` (`parent_region_id`,`region_type`,`region_name`),
+  KEY `ix_region_2` (`parent_region_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=140 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_resource_event` (
+  `event_id` varchar(100) NOT NULL,
+  `event_type` varchar(128) NOT NULL,
+  `event_date` datetime(6) NOT NULL,
+  `resource_id` varchar(36) DEFAULT NULL,
+  `resource_name` varchar(256) DEFAULT NULL,
+  `resource_foreign_id` varchar(512) DEFAULT NULL,
+  `customer_id` varchar(36) DEFAULT NULL,
+  `customer_name` varchar(512) DEFAULT NULL,
+  `tenant_foreign_id` varchar(512) DEFAULT NULL,
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `service_region_id` int(10) unsigned DEFAULT NULL,
+  `management_region_id` int(10) unsigned DEFAULT NULL,
+  `tenant_id` int(10) unsigned DEFAULT NULL,
+  `tenant_name` varchar(512) DEFAULT NULL,
+  PRIMARY KEY (`service_manager_id`,`event_id`),
+  KEY `ix_vm_event_1` (`resource_foreign_id`(255),`event_date`),
+  KEY `ix_vm_event_2` (`customer_id`),
+  KEY `ix_vm_event_3` (`resource_name`(255),`event_date`),
+  KEY `ix_vm_event_4` (`service_manager_id`)
+) 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 `t_resource_group` (
+  `resource_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `resource_group_name` varchar(512) NOT NULL,
+  `resource_group_type` varchar(64) DEFAULT NULL,
+  `customer_id` int(10) unsigned NOT NULL,
+  `parent_id` int(10) unsigned NOT NULL,
+  `parent_type` varchar(64) NOT NULL,
+  PRIMARY KEY (`resource_group_id`),
+  KEY `ix_resource_group_1` (`parent_id`),
+  KEY `ix_resource_group_2` (`customer_id`)
+) 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 `t_service` (
+  `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_type` varchar(128) NOT NULL,
+  `service_description` longtext DEFAULT NULL,
+  `service_manager_type_id` int(10) unsigned DEFAULT NULL,
+  `states` text DEFAULT NULL,
+  `externally_managed` tinyint(4) NOT NULL DEFAULT 1,
+  PRIMARY KEY (`service_id`),
+  UNIQUE KEY `ix_service_1` (`service_manager_type_id`,`service_type`)
+) ENGINE=InnoDB AUTO_INCREMENT=40 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_service_instance` (
+  `service_instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_id` int(10) unsigned NOT NULL,
+  `service_instance_name` varchar(256) NOT NULL,
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
+  `service_instance_foreign_id` varchar(256) DEFAULT NULL,
+  `tenant_id` int(10) unsigned DEFAULT NULL,
+  `current_attributes` text DEFAULT NULL,
+  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=82971 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_service_instance_aggregates` (
+  `customer_id` int(10) unsigned NOT NULL DEFAULT 0,
+  `customer_name` varchar(255) DEFAULT NULL,
+  `tenant_id` int(10) unsigned NOT NULL DEFAULT 0,
+  `tenant_name` varchar(255) DEFAULT NULL,
+  `management_region_id` varchar(128) NOT NULL DEFAULT '',
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `service_manager_name` varchar(256) NOT NULL,
+  `service_region_id` int(10) unsigned NOT NULL,
+  `service_region_name` varchar(128) NOT NULL,
+  `aggregate_category` varchar(128) NOT NULL,
+  `aggregate_name` varchar(128) NOT NULL,
+  `aggregate_type` varchar(64) NOT NULL,
+  `aggregate_value` int(11) NOT NULL,
+  `aggregate_interval` varchar(32) NOT NULL,
+  `aggregate_datetime` datetime(6) NOT NULL,
+  PRIMARY KEY (`management_region_id`,`customer_id`,`service_manager_id`,`tenant_id`,`service_region_id`,`aggregate_category`,`aggregate_name`,`aggregate_type`,`aggregate_interval`,`aggregate_datetime`),
+  KEY `ix_service_instance_aggregates_2` (`service_manager_id`,`service_region_id`,`aggregate_datetime`,`aggregate_name`),
+  KEY `ix_service_instance_aggregates_3` (`customer_id`,`tenant_id`,`aggregate_datetime`,`aggregate_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 `t_service_instance_attributes` (
+  `service_instance_id` int(10) unsigned NOT NULL,
+  `start_date` datetime(6) NOT NULL,
+  `end_date` datetime(6) NOT NULL,
+  `attributes` blob DEFAULT NULL,
+  UNIQUE KEY `ix_resource_configuration_history_1` (`service_instance_id`,`start_date`,`end_date`)
+) 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 `t_service_instance_state` (
+  `service_instance_id` int(10) unsigned NOT NULL,
+  `state` varchar(64) NOT NULL,
+  `start_date` datetime(6) NOT NULL,
+  `end_date` datetime(6) NOT NULL,
+  `interval_length_milliseconds` bigint(20) DEFAULT NULL,
+  PRIMARY KEY (`service_instance_id`,`state`,`start_date`),
+  KEY `ix_service_instance_state_1` (`service_instance_id`,`state`,`start_date`,`end_date`)
+) 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 `t_service_manager` (
+  `service_manager_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_manager_name` varchar(256) NOT NULL,
+  `service_manager_description` varchar(512) DEFAULT NULL,
+  `metadata` longtext DEFAULT NULL,
+  `service_region_id` int(10) unsigned NOT NULL,
+  `service_manager_type_id` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`service_manager_id`),
+  UNIQUE KEY `ix_service_manager_1` (`service_manager_name`(255))
+) ENGINE=InnoDB AUTO_INCREMENT=71 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_service_manager_properties` (
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `property_group` varchar(128) NOT NULL,
+  `property_name` varchar(128) NOT NULL,
+  `property_value` text DEFAULT NULL,
+  PRIMARY KEY (`service_manager_id`,`property_group`,`property_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 `t_service_manager_sync_metrics` (
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `metric_name` varchar(255) NOT NULL,
+  `metric_value` text NOT NULL,
+  PRIMARY KEY (`service_manager_id`,`metric_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 `t_service_manager_type` (
+  `service_manager_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `service_manager_type` varchar(32) NOT NULL,
+  `service_manager_type_description` varchar(256) DEFAULT NULL,
+  `system_defined` tinyint(4) NOT NULL DEFAULT 0,
+  PRIMARY KEY (`service_manager_type_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 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_tenant` (
+  `tenant_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `tenant_name` varchar(512) NOT NULL,
+  `tenant_foreign_id` varchar(512) DEFAULT NULL,
+  `create_date` datetime(6) NOT NULL,
+  `deactivate_date` datetime(6) DEFAULT NULL,
+  `customer_id` int(10) unsigned DEFAULT NULL,
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `is_active` tinyint(4) NOT NULL DEFAULT 0,
+  KEY `ix_tenant_1` (`tenant_id`),
+  KEY `ix_tenant_2` (`customer_id`),
+  KEY `ix_tenant_3` (`service_manager_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1958 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_unbilled_charges` (
+  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `payer_name` varchar(512) NOT NULL,
+  `invoice_number` varchar(45) DEFAULT NULL,
+  `invoice_date` datetime(6) NOT NULL,
+  `period_begin` datetime(6) NOT NULL,
+  `period_end` datetime(6) NOT NULL,
+  `invoice_amount` decimal(19,2) NOT NULL,
+  `actual_charges` decimal(19,2) NOT NULL,
+  `invoice_currency` varchar(16) DEFAULT NULL,
+  `management_region_id` int(10) unsigned NOT NULL,
+  `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=845 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_unbilled_charges_detail` (
+  `invoice_id` int(10) unsigned NOT NULL,
+  `customer_id` int(10) unsigned DEFAULT NULL,
+  `customer_name` varchar(255) DEFAULT NULL,
+  `service_region_id` int(10) unsigned DEFAULT NULL,
+  `service_region_name` varchar(128) DEFAULT NULL,
+  `rate` decimal(22,12) NOT NULL,
+  `rate_display` varchar(255) DEFAULT NULL,
+  `rate_unit` varchar(128) NOT NULL,
+  `rate_interval` varchar(128) DEFAULT NULL,
+  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
+  `units_billed` decimal(36,12) DEFAULT NULL,
+  `units_billed_display` varchar(128) DEFAULT NULL,
+  `item_invoice_amount` decimal(19,2) NOT NULL,
+  `item_category` varchar(128) NOT NULL,
+  `item_group` varchar(128) NOT NULL,
+  `item_type` varchar(128) NOT NULL,
+  `item_detail` varchar(512) NOT NULL,
+  `tenant_id` int(10) unsigned DEFAULT NULL,
+  `tenant_name` varchar(256) DEFAULT NULL,
+  `stack_type` varchar(16) DEFAULT NULL,
+  `service_manager_id` int(10) unsigned DEFAULT NULL,
+  `service_manager_name` varchar(128) DEFAULT NULL,
+  `service_instance_metadata` text DEFAULT NULL,
+  KEY `ix_unbilled_charges_detail_1` (`invoice_id`),
+  KEY `ix_unbilled_charges_detail_2` (`customer_id`),
+  KEY `ix_unbilled_charges_detail_4` (`invoice_id`,`customer_name`,`item_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 `t_unbilled_charges_detail_temp` (
+  `invoice_id` int(10) unsigned NOT NULL,
+  `customer_id` int(10) unsigned DEFAULT NULL,
+  `customer_name` varchar(255) DEFAULT NULL,
+  `service_region_id` int(10) unsigned DEFAULT NULL,
+  `service_region_name` varchar(128) DEFAULT NULL,
+  `rate` decimal(22,12) NOT NULL,
+  `rate_display` varchar(255) DEFAULT NULL,
+  `rate_unit` varchar(128) NOT NULL,
+  `rate_interval` varchar(128) DEFAULT NULL,
+  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
+  `units_billed` decimal(36,12) DEFAULT NULL,
+  `units_billed_display` varchar(128) DEFAULT NULL,
+  `item_invoice_amount` decimal(19,2) NOT NULL,
+  `item_category` varchar(128) NOT NULL,
+  `item_group` varchar(128) NOT NULL,
+  `item_type` varchar(128) NOT NULL,
+  `item_detail` varchar(512) NOT NULL,
+  `tenant_id` int(10) unsigned DEFAULT NULL,
+  `tenant_name` varchar(256) DEFAULT NULL,
+  `stack_type` varchar(16) DEFAULT NULL,
+  `service_manager_id` int(10) unsigned DEFAULT NULL,
+  `service_manager_name` varchar(128) DEFAULT NULL,
+  `service_instance_metadata` text DEFAULT NULL,
+  KEY `ix_unbilled_charges_detail_1` (`invoice_id`),
+  KEY `ix_unbilled_charges_detail_2` (`customer_id`),
+  KEY `ix_unbilled_charges_detail_4` (`invoice_id`,`customer_name`,`item_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 `t_unbilled_charges_temp` (
+  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `payer_id` int(10) unsigned NOT NULL,
+  `payer_type` varchar(64) NOT NULL,
+  `payer_name` varchar(512) NOT NULL,
+  `invoice_number` varchar(45) DEFAULT NULL,
+  `invoice_date` datetime(6) NOT NULL,
+  `period_begin` datetime(6) NOT NULL,
+  `period_end` datetime(6) NOT NULL,
+  `invoice_amount` decimal(19,2) NOT NULL,
+  `actual_charges` decimal(19,2) NOT NULL,
+  `invoice_currency` varchar(16) DEFAULT NULL,
+  `management_region_id` int(10) unsigned NOT NULL,
+  `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=845 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;
+/*!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_projects` (
+  `user_projects_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `user_id` int(10) unsigned NOT NULL,
+  `user_foreign_id` varchar(128) NOT NULL,
+  `service_manager_id` int(10) unsigned NOT NULL,
+  `role_id` varchar(128) NOT NULL,
+  `role_name` varchar(128) NOT NULL,
+  `project_id` varchar(128) NOT NULL,
+  `add_date` datetime(6) NOT NULL,
+  `remove_date` datetime(6) NOT NULL,
+  PRIMARY KEY (`user_projects_id`),
+  KEY `ix_host_1` (`user_id`,`service_manager_id`,`role_id`,`project_id`)
+) 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 `t_user_roles` (
+  `user_id` int(10) unsigned NOT NULL,
+  `role_name` varchar(128) 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`)
+) 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 `t_users` (
+  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `username` varchar(128) NOT NULL,
+  `first_name` varchar(256) DEFAULT NULL,
+  `last_name` varchar(256) DEFAULT NULL,
+  `email_address` varchar(512) DEFAULT NULL,
+  `phone_number` varchar(64) DEFAULT NULL,
+  `password` varchar(512) DEFAULT NULL,
+  `is_active` tinyint(1) DEFAULT NULL,
+  `password_change_token` varchar(64) DEFAULT NULL,
+  `last_password_change_date` datetime(6) DEFAULT NULL,
+  `password_change_token_expire_date` datetime(6) DEFAULT NULL,
+  `external` tinyint(1) DEFAULT 0,
+  PRIMARY KEY (`user_id`),
+  UNIQUE KEY `username` (`username`)
+) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE TABLE `v_all_charges` (
+  `invoice_id` tinyint NOT NULL,
+  `payer_id` tinyint NOT NULL,
+  `payer_type` tinyint NOT NULL,
+  `payer_name` tinyint NOT NULL,
+  `invoice_number` tinyint NOT NULL,
+  `invoice_date` tinyint NOT NULL,
+  `period_begin` tinyint NOT NULL,
+  `period_end` tinyint NOT NULL,
+  `invoice_amount` tinyint NOT NULL,
+  `actual_charges` tinyint NOT NULL,
+  `invoice_currency` tinyint NOT NULL,
+  `management_region_id` 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_all_charges_detail` (
+  `invoice_id` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `rate` tinyint NOT NULL,
+  `rate_display` tinyint NOT NULL,
+  `rate_unit` tinyint NOT NULL,
+  `rate_interval` tinyint NOT NULL,
+  `rate_multiplier_percent` tinyint NOT NULL,
+  `units_billed` tinyint NOT NULL,
+  `units_billed_display` tinyint NOT NULL,
+  `item_invoice_amount` tinyint NOT NULL,
+  `item_category` tinyint NOT NULL,
+  `item_group` tinyint NOT NULL,
+  `item_type` tinyint NOT NULL,
+  `item_detail` tinyint NOT NULL,
+  `tenant_id` tinyint NOT NULL,
+  `tenant_name` 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_current_host` (
+  `host_id` tinyint NOT NULL,
+  `service_manager_id` tinyint NOT NULL,
+  `service_manager_name` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `region_name` tinyint NOT NULL,
+  `host_foreign_id` tinyint NOT NULL,
+  `host_name` tinyint NOT NULL,
+  `hypervisor_type` tinyint NOT NULL,
+  `host_aggregate` tinyint NOT NULL,
+  `add_date` tinyint NOT NULL,
+  `remove_date` tinyint NOT NULL,
+  `cpu_allocation_ratio` tinyint NOT NULL,
+  `ram_allocation_ratio` tinyint NOT NULL,
+  `disk_allocation_ratio` tinyint NOT NULL,
+  `update_date` tinyint NOT NULL,
+  `ram_mb` tinyint NOT NULL,
+  `ram_mb_used` tinyint NOT NULL,
+  `disk_gb` tinyint NOT NULL,
+  `disk_gb_used` tinyint NOT NULL,
+  `vcpus` tinyint NOT NULL,
+  `vcpus_used` tinyint NOT NULL,
+  `vm_count` tinyint NOT NULL,
+  `socket_count` 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_current_host_attributes` (
+  `host_id` tinyint NOT NULL,
+  `update_date` tinyint NOT NULL,
+  `ram_mb` tinyint NOT NULL,
+  `ram_mb_used` tinyint NOT NULL,
+  `disk_gb` tinyint NOT NULL,
+  `disk_gb_used` tinyint NOT NULL,
+  `vcpus` tinyint NOT NULL,
+  `vcpus_used` tinyint NOT NULL,
+  `vm_count` tinyint NOT NULL,
+  `socket_count` 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_customer` (
+  `customer_id` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `metadata` tinyint NOT NULL,
+  `tax_rate` tinyint NOT NULL,
+  `currency` tinyint NOT NULL,
+  `discount_percent` tinyint NOT NULL,
+  `billing_frequency` tinyint NOT NULL,
+  `last_bill_date` tinyint NOT NULL,
+  `next_bill_date` tinyint NOT NULL,
+  `is_active` tinyint NOT NULL,
+  `create_date` tinyint NOT NULL,
+  `activate_date` tinyint NOT NULL,
+  `billing_start_date` tinyint NOT NULL,
+  `last_payment_date` tinyint NOT NULL,
+  `deactivate_date` tinyint NOT NULL,
+  `description` tinyint NOT NULL,
+  `minimum_invoice_commitment` tinyint NOT NULL,
+  `invoicing_method` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `billing_address_line_1` tinyint NOT NULL,
+  `billing_address_line_2` tinyint NOT NULL,
+  `billing_address_city` tinyint NOT NULL,
+  `billing_address_region` tinyint NOT NULL,
+  `billing_address_country` tinyint NOT NULL,
+  `billing_address_postal_code` tinyint NOT NULL,
+  `payer_payment_details` tinyint NOT NULL,
+  `payment_method_confirmed` tinyint NOT NULL,
+  `balance_due` tinyint NOT NULL,
+  `spend_soft_limit` tinyint NOT NULL,
+  `spend_hard_limit` tinyint NOT NULL,
+  `terms_and_conditions_2_accept_date` tinyint NOT NULL,
+  `tax_id` tinyint NOT NULL,
+  `registration_number` tinyint NOT NULL,
+  `management_region_name` 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_metric` (
+  `metric_id` tinyint NOT NULL,
+  `service_manager_type_id` tinyint NOT NULL,
+  `metric_name` tinyint NOT NULL,
+  `metric_label` tinyint NOT NULL,
+  `metric_source` tinyint NOT NULL,
+  `metric_type` tinyint NOT NULL,
+  `metric_unit` tinyint NOT NULL,
+  `entity_resolution` tinyint NOT NULL,
+  `time_resolution` tinyint NOT NULL,
+  `service_manager_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_promo_code_redemption` (
+  `management_region_id` tinyint NOT NULL,
+  `promo_code_id` tinyint NOT NULL,
+  `promo_code` tinyint NOT NULL,
+  `salesperson` tinyint NOT NULL,
+  `discount_or_credit` tinyint NOT NULL,
+  `credit_amount` tinyint NOT NULL,
+  `credit_type` tinyint NOT NULL,
+  `apply_to_charge_category` tinyint NOT NULL,
+  `trigger_charge_category` tinyint NOT NULL,
+  `trigger_amount` tinyint NOT NULL,
+  `discount_percent` tinyint NOT NULL,
+  `available_invoice_periods` tinyint NOT NULL,
+  `expire_date` tinyint NOT NULL,
+  `currency` tinyint NOT NULL,
+  `redemption_date` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `customer_name` 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_provider` (
+  `provider_id` tinyint NOT NULL,
+  `provider_name` tinyint NOT NULL,
+  `provider_type` tinyint NOT NULL,
+  `metadata` tinyint NOT NULL,
+  `tax_rate` tinyint NOT NULL,
+  `currency` tinyint NOT NULL,
+  `discount_percent` tinyint NOT NULL,
+  `billing_frequency` tinyint NOT NULL,
+  `last_bill_date` tinyint NOT NULL,
+  `next_bill_date` tinyint NOT NULL,
+  `last_payment_date` tinyint NOT NULL,
+  `is_active` tinyint NOT NULL,
+  `create_date` tinyint NOT NULL,
+  `activate_date` tinyint NOT NULL,
+  `billing_start_date` tinyint NOT NULL,
+  `deactivate_date` tinyint NOT NULL,
+  `description` tinyint NOT NULL,
+  `minimum_invoice_commitment` tinyint NOT NULL,
+  `invoicing_method` tinyint NOT NULL,
+  `invoice_processing_method` tinyint NOT NULL,
+  `billing_address_line_1` tinyint NOT NULL,
+  `billing_address_line_2` tinyint NOT NULL,
+  `billing_address_city` tinyint NOT NULL,
+  `billing_address_region` tinyint NOT NULL,
+  `billing_address_country` tinyint NOT NULL,
+  `billing_address_postal_code` tinyint NOT NULL,
+  `legal_address_line_1` tinyint NOT NULL,
+  `legal_address_line_2` tinyint NOT NULL,
+  `legal_address_city` tinyint NOT NULL,
+  `legal_address_region` tinyint NOT NULL,
+  `legal_address_country` tinyint NOT NULL,
+  `legal_address_postal_code` tinyint NOT NULL,
+  `payer_payment_details` tinyint NOT NULL,
+  `payee_payment_details` tinyint NOT NULL,
+  `public_url` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `balance_due` tinyint NOT NULL,
+  `openbook_processes_payments` tinyint NOT NULL,
+  `openbook_processes_past_due_invoices` tinyint NOT NULL,
+  `openstack_tenant_id` tinyint NOT NULL,
+  `tax_id` tinyint NOT NULL,
+  `registration_number` tinyint NOT NULL,
+  `os_service_manager_id` tinyint NOT NULL,
+  `parent_management_region_id` 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_rate_plan_assignment` (
+  `rate_plan_id` tinyint NOT NULL,
+  `assignee_id` tinyint NOT NULL,
+  `assignee_type` tinyint NOT NULL,
+  `assignment_start_date` tinyint NOT NULL,
+  `assignment_end_date` tinyint NOT NULL,
+  `assignment_type` tinyint NOT NULL,
+  `management_region_id` 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_service` (
+  `service_id` tinyint NOT NULL,
+  `service_type` tinyint NOT NULL,
+  `service_description` tinyint NOT NULL,
+  `service_manager_type_id` tinyint NOT NULL,
+  `states` tinyint NOT NULL,
+  `externally_managed` tinyint NOT NULL,
+  `service_manager_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_service_instance` (
+  `service_instance_id` tinyint NOT NULL,
+  `service_id` tinyint NOT NULL,
+  `service_instance_name` tinyint NOT NULL,
+  `service_manager_id` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `service_instance_foreign_id` tinyint NOT NULL,
+  `tenant_id` tinyint NOT NULL,
+  `current_attributes` tinyint NOT NULL,
+  `tenant_name` tinyint NOT NULL,
+  `tenant_foreign_id` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `service_manager_name` tinyint NOT NULL,
+  `service_region_name` tinyint NOT NULL,
+  `service_manager_type` tinyint NOT NULL,
+  `service_type` tinyint NOT NULL,
+  `provisioned_date` tinyint NOT NULL,
+  `deprovisioned_date` 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_service_instance_attributes` (
+  `service_instance_id` tinyint NOT NULL,
+  `start_date` tinyint NOT NULL,
+  `end_date` tinyint NOT NULL,
+  `attributes` tinyint NOT NULL,
+  `tenant_id` tinyint NOT NULL,
+  `tenant_foreign_id` tinyint NOT NULL,
+  `tenant_name` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `service_instance_name` tinyint NOT NULL,
+  `service_instance_foreign_id` tinyint NOT NULL,
+  `service_manager_id` tinyint NOT NULL,
+  `service_manager_name` tinyint NOT NULL,
+  `service_id` tinyint NOT NULL,
+  `service_type` tinyint NOT NULL,
+  `service_manager_type` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `service_region_name` 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_service_instance_state` (
+  `service_instance_id` tinyint NOT NULL,
+  `state` tinyint NOT NULL,
+  `start_date` tinyint NOT NULL,
+  `end_date` tinyint NOT NULL,
+  `interval_length_milliseconds` tinyint NOT NULL,
+  `tenant_id` tinyint NOT NULL,
+  `tenant_foreign_id` tinyint NOT NULL,
+  `tenant_name` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `service_instance_name` tinyint NOT NULL,
+  `service_instance_foreign_id` tinyint NOT NULL,
+  `service_manager_id` tinyint NOT NULL,
+  `service_manager_name` tinyint NOT NULL,
+  `service_id` tinyint NOT NULL,
+  `service_type` tinyint NOT NULL,
+  `service_manager_type` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `service_region_name` 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_service_manager` (
+  `service_manager_id` tinyint NOT NULL,
+  `service_manager_name` tinyint NOT NULL,
+  `service_manager_description` tinyint NOT NULL,
+  `metadata` tinyint NOT NULL,
+  `service_region_id` tinyint NOT NULL,
+  `service_manager_type_id` tinyint NOT NULL,
+  `service_manager_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_tenant` (
+  `tenant_id` tinyint NOT NULL,
+  `tenant_name` tinyint NOT NULL,
+  `tenant_foreign_id` tinyint NOT NULL,
+  `create_date` tinyint NOT NULL,
+  `deactivate_date` tinyint NOT NULL,
+  `customer_id` tinyint NOT NULL,
+  `service_manager_id` tinyint NOT NULL,
+  `is_active` tinyint NOT NULL,
+  `customer_name` tinyint NOT NULL,
+  `management_region_id` tinyint NOT NULL,
+  `service_manager_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;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */;
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+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 '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+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 '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+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` 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`)) */;
+/*!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 '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+USE `openbook_jobs`;
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{{ openbook_database_password }}';
+GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{{ openbook_database_password }}';
+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);
+CALL p_preallocate_partitions('t_metric_aggregate_tenant_hourly', 'aggregate_datetime', CURDATE(), 31);
+CALL p_preallocate_partitions('t_metric_aggregate_customer_hourly', 'aggregate_datetime', CURDATE(), 31);
+CALL p_preallocate_partitions('t_metric_aggregate_resource_daily', 'aggregate_datetime', CURDATE(), 31);
+CALL p_preallocate_partitions('t_metric_aggregate_tenant_daily', 'aggregate_datetime', CURDATE(), 31);
+CALL p_preallocate_partitions('t_metric_aggregate_customer_daily', 'aggregate_datetime', CURDATE(), 31);
diff --git a/templates/database/etc/openbook/database/debian.cnf b/templates/database/etc/openbook/database/debian.cnf
new file mode 100644
index 0000000..c4c3297
--- /dev/null
+++ b/templates/database/etc/openbook/database/debian.cnf
@@ -0,0 +1,11 @@
+[client]
+host     = localhost
+user     = debian-sys-maint
+password = {{ openbook_database_password }}
+socket   = /var/run/mysqld/mysqld.sock
+[mysql_upgrade]
+host     = localhost
+user     = debian-sys-maint
+password = {{ openbook_database_password }}
+socket   = /var/run/mysqld/mysqld.sock
+basedir  = /usr
diff --git a/templates/database/root/.my.cnf b/templates/database/root/.my.cnf
new file mode 100644
index 0000000..269e0ba
--- /dev/null
+++ b/templates/database/root/.my.cnf
@@ -0,0 +1,6 @@
+[mysql]
+user=root
+password={{ openbook_database_password }}
+[mysqldump]
+user=root
+password={{ openbook_database_password }}
diff --git a/templates/database/run.sh b/templates/database/run.sh
new file mode 100755
index 0000000..9a61648
--- /dev/null
+++ b/templates/database/run.sh
@@ -0,0 +1,23 @@
+#!/bin/bash
+
+# find other running nodes
+other_nodes_found=1
+for i in $(echo "{{ openbook_gcomm_addresses }}" | sed -e 's|,| |g'); do
+    if [ "${i}" != "{{ ansible_default_ipv4.address }}" ]; then
+        nc ${i} 4567 </dev/null >/dev/null
+        if [ "${?}" == "0" ]; then
+            other_nodes_found=0
+        fi
+    fi
+done
+
+# bootstrap or cluster join depending on whether other nodes were found
+if [ "${other_nodes_found}" == "0" ]; then
+    mysql_args=""
+else
+    mysql_args="--wsrep-new-cluster"
+fi
+
+docker run -d --rm --net=host -p 3306:3306 -p 4444:4444 -p 4567:4567 -p 4567:4567/udp -p 4568:4568 -p 9200:9200 -v /etc/openbook/database:/etc/mysql -v /var/lib/mysql:/var/lib/mysql -v /var/log/mysql:/var/log/mysql --name database openbook-docker-registry.verizoncloudplatform.com/openbook_database ${mysql_args}
+
+exit 0