/*!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 */;

/*!40000 DROP DATABASE IF EXISTS `openbook`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET utf8 */;

GRANT ALL PRIVILEGES ON openbook.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
GRANT ALL PRIVILEGES ON openbook.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
FLUSH PRIVILEGES;

USE `openbook`;
DROP TABLE IF EXISTS `t_adhoc_charge`;
/*!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 */;

LOCK TABLES `t_adhoc_charge` WRITE;
/*!40000 ALTER TABLE `t_adhoc_charge` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_adhoc_charge` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_app_config`;
/*!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 */;

LOCK TABLES `t_app_config` WRITE;
/*!40000 ALTER TABLE `t_app_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_app_config` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_audit_event`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_audit_event` WRITE;
/*!40000 ALTER TABLE `t_audit_event` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_audit_event` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_aws_raw_charges`;
/*!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 */;

LOCK TABLES `t_aws_raw_charges` WRITE;
/*!40000 ALTER TABLE `t_aws_raw_charges` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_aws_raw_charges` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_aws_raw_data`;
/*!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 */;

LOCK TABLES `t_aws_raw_data` WRITE;
/*!40000 ALTER TABLE `t_aws_raw_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_aws_raw_data` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_credit`;
/*!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 */;

LOCK TABLES `t_credit` WRITE;
/*!40000 ALTER TABLE `t_credit` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_credit` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_customer`;
/*!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=314159 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_customer` WRITE;
/*!40000 ALTER TABLE `t_customer` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_customer` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_discount`;
/*!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 */;

LOCK TABLES `t_discount` WRITE;
/*!40000 ALTER TABLE `t_discount` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_discount` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_email_notification`;
/*!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 */;

LOCK TABLES `t_email_notification` WRITE;
/*!40000 ALTER TABLE `t_email_notification` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_email_notification` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_email_template`;
/*!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 */;

LOCK TABLES `t_email_template` WRITE;
/*!40000 ALTER TABLE `t_email_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_email_template` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_entity_attribute`;
/*!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 */;

LOCK TABLES `t_entity_attribute` WRITE;
/*!40000 ALTER TABLE `t_entity_attribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_entity_attribute` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_exception_event`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_exception_event` WRITE;
/*!40000 ALTER TABLE `t_exception_event` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_exception_event` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_gcp_raw_charges`;
/*!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 */;

LOCK TABLES `t_gcp_raw_charges` WRITE;
/*!40000 ALTER TABLE `t_gcp_raw_charges` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_gcp_raw_charges` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_host`;
/*!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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_host` WRITE;
/*!40000 ALTER TABLE `t_host` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_host` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_host_attributes`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_host_attributes` WRITE;
/*!40000 ALTER TABLE `t_host_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_host_attributes` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_invoice`;
/*!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=12480500 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_invoice` WRITE;
/*!40000 ALTER TABLE `t_invoice` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_invoice` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_invoice_detail`;
/*!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 */;

LOCK TABLES `t_invoice_detail` WRITE;
/*!40000 ALTER TABLE `t_invoice_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_invoice_detail` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_job_status`;
/*!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 */;

LOCK TABLES `t_job_status` WRITE;
/*!40000 ALTER TABLE `t_job_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_job_status` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_lookup_values`;
/*!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 */;

LOCK TABLES `t_lookup_values` WRITE;
/*!40000 ALTER TABLE `t_lookup_values` DISABLE KEYS */;
INSERT INTO `t_lookup_values` VALUES ('Countries','Albania','AL'),('Countries','Algeria','DZ'),('Countries','American Samoa','AS'),('Countries','Andorra','AD'),('Countries','Angola','AO'),('Countries','Anguilla','AI'),('Countries','Antigua','AG'),('Countries','Argentina','AR'),('Countries','Armenia','AM'),('Countries','Aruba','AW'),('Countries','Australia','AU'),('Countries','Austria','AT'),('Countries','Azerbaijan','AZ'),('Countries','Bahamas','BS'),('Countries','Bahrain','BH'),('Countries','Bangladesh','BD'),('Countries','Barbados','BB'),('Countries','Belarus','BY'),('Countries','Belgium','BE'),('Countries','Belize','BZ'),('Countries','Benin','BJ'),('Countries','Bermuda','BM'),('Countries','Bhutan','BT'),('Countries','Bolivia','BO'),('Countries','Bosnia-Herzegovina','BA'),('Countries','Botswana','BW'),('Countries','Brazil','BR'),('Countries','British Virgin Islands','VG'),('Countries','Brunei Darussalam','BN'),('Countries','Bulgaria','BG'),('Countries','Burkina FASO','BF'),('Countries','Burundi','BI'),('Countries','Cambodia','KH'),('Countries','Cameroon','CM'),('Countries','Canada','CA'),('Countries','Cape Verde','CV'),('Countries','Cayman Islands','KY'),('Countries','Central African Republic','CF'),('Countries','Chad','TS'),('Countries','Chile','CL'),('Countries','China','CN'),('Countries','Colombia','CO'),('Countries','Cook Islands','CK'),('Countries','Costa Rica','CR'),('Countries','Croatia','HR'),('Countries','Cyprus','CY'),('Countries','Czech Republic','CZ'),('Countries','Democratic Republic of Congo','ZR'),('Countries','Denmark','DK'),('Countries','Djibouti','DJ'),('Countries','Dominica','DM'),('Countries','Dominican Republic','DO'),('Countries','Ecuador','EC'),('Countries','Egypt','EG'),('Countries','El Salvador','SV'),('Countries','Equatorial Guinea','GQ'),('Countries','Eritrea','ER'),('Countries','Estonia','EE'),('Countries','Ethiopia','ET'),('Countries','Faeroe Islands','FO'),('Countries','Fiji','FJ'),('Countries','Finland','FI'),('Countries','France','FR'),('Countries','French Guiana','GF'),('Countries','French Polynesia','PF'),('Countries','Gabon','GA'),('Countries','Gambia','GM'),('Countries','Georgia, Republic of','GE'),('Countries','Germany','DE'),('Countries','Ghana','GH'),('Countries','Greece','GR'),('Countries','Greenland','GL'),('Countries','Grenada','GD'),('Countries','Guadeloupe','GP'),('Countries','Guam','GU'),('Countries','Guatemala','GT'),('Countries','Guinea','GN'),('Countries','Guinea-Bissau','GW'),('Countries','Guyana','GY'),('Countries','Haiti','HT'),('Countries','Honduras','HN'),('Countries','Hong Kong','HK'),('Countries','Hungary','HU'),('Countries','Iceland','IS'),('Countries','India','IN'),('Countries','Indonesia','ID'),('Countries','Iran','IR'),('Countries','Iraq','IQ'),('Countries','Ireland','IE'),('Countries','Israel','IL'),('Countries','Italy','IT'),('Countries','Ivory Coast','CI'),('Countries','Jamaica','JM'),('Countries','Japan','JP'),('Countries','Jordan','JO'),('Countries','Kazakhstan','KZ'),('Countries','Kenya','KE'),('Countries','Kuwait','KW'),('Countries','Kyrgyzstan','KG'),('Countries','Laos','LA'),('Countries','Latvia','LV'),('Countries','Lesotho','LS'),('Countries','Liberia','LR'),('Countries','Liechtenstein','LI'),('Countries','Lithuania','LT'),('Countries','Luxembourg','LU'),('Countries','Macau','MO'),('Countries','Macedonia, Republic of','MK'),('Countries','Madagascar','MG'),('Countries','Malawi','MW'),('Countries','Malaysia','MY'),('Countries','Maldives','MV'),('Countries','Mali','ML'),('Countries','Malta','MT'),('Countries','Marshall Islands','MH'),('Countries','Martinique','MQ'),('Countries','Mauritania','MR'),('Countries','Mauritius','MU'),('Countries','Mexico','MX'),('Countries','Moldova','MD'),('Countries','Monaco','MC'),('Countries','Mongolia','MN'),('Countries','Montserrat','MS'),('Countries','Morocco','MA'),('Countries','Mozambique','MZ'),('Countries','Namibia','NA'),('Countries','Nauru','NR'),('Countries','Nepal','NP'),('Countries','Netherlands','NL'),('Countries','Netherlands Antilles','AN'),('Countries','New Caledonia','NC'),('Countries','New Zealand','NZ'),('Countries','Nicaragua','NI'),('Countries','Niger','NE'),('Countries','Nigeria','NG'),('Countries','Norway','NO'),('Countries','Oman','OM'),('Countries','Pakistan','PK'),('Countries','Palau','PW'),('Countries','Panama','PA'),('Countries','Papua New Guinea','PG'),('Countries','Paraguay','PY'),('Countries','Peru','PE'),('Countries','Phillipines','PH'),('Countries','Poland','PL'),('Countries','Portugal','PT'),('Countries','Qatar','QA'),('Countries','Republic of the Congo (Brazaville)','CG'),('Countries','Reunion Island','RE'),('Countries','Romania','RO'),('Countries','Russia','RU'),('Countries','Rwanda','RW'),('Countries','Saipan','MP'),('Countries','San Marino','SM'),('Countries','Saudi Arabia','SA'),('Countries','Senegal','SN'),('Countries','Serbia Montenegro','YU'),('Countries','Seychelles','SC'),('Countries','Sierra Leone','SL'),('Countries','Singapore','SG'),('Countries','Slovak Republic','SK'),('Countries','Slovenia','SI'),('Countries','Solomon Islands','SB'),('Countries','Somalia','SO'),('Countries','South Africa','ZA'),('Countries','South Korea, Republic of','KR'),('Countries','Spain','ES'),('Countries','Sri Lanka','LK'),('Countries','St. Kitts & Nevis','KN'),('Countries','St. Lucia','LC'),('Countries','St. Vincent and the Grenadines','VC'),('Countries','Sudan','SD'),('Countries','Swaziland','SZ'),('Countries','Sweden','SE'),('Countries','Switzerland','CH'),('Countries','Syrian Arab Republic','SY'),('Countries','Taiwan','TW'),('Countries','Tajikistan','TJ'),('Countries','Tanzania','TZ'),('Countries','Thailand','TH'),('Countries','Togo','TG'),('Countries','Trinidad & Tobago','TT'),('Countries','Tunisia','TN'),('Countries','Turkey','TR'),('Countries','Turkmenistan','TM'),('Countries','Turks & Caicos Islands','TC'),('Countries','Uganda','UG'),('Countries','Ukraine','UA'),('Countries','United Arab Emirates','AE'),('Countries','United Kingdom','UK'),('Countries','United States of America','US'),('Countries','Uruguay','UY'),('Countries','US Virgin Islands','VI'),('Countries','Uzbekistan','UZ'),('Countries','Vanuatu','VU'),('Countries','Vatican City','VA'),('Countries','Venezuela','VE'),('Countries','Vietnam','VN'),('Countries','Wallis & Futuna Islands','WF'),('Countries','Western Samoa','WS'),('Countries','Yemen','YE'),('Countries','Zambia','ZM'),('Countries','Zimbabwe','ZW'),('Currencies','AED - UAE Dirham','AED'),('Currencies','AFN - Afghani','AF'),('Currencies','ALL - Lek','ALL'),('Currencies','AMD - Armenian Dram','AMD'),('Currencies','ANG - Netherlands Antillean Guilder','ANG'),('Currencies','AOA - Kwanza','AOA'),('Currencies','ARS - Argentine Peso','ARS'),('Currencies','AUD - Australian Dollar','AUD'),('Currencies','AWG - Aruban Florin','AWG'),('Currencies','AZN - Azerbaijanian Manat','AZ'),('Currencies','BAM - Convertible Mark','BAM'),('Currencies','BBD - Barbados Dollar','BBD'),('Currencies','BDT - Taka','BDT'),('Currencies','BGN - Bulgarian Lev','BG'),('Currencies','BHD - Bahraini Dinar','BHD'),('Currencies','BIF - Burundi Franc','BIF'),('Currencies','BMD - Bermudian Dollar','BMD'),('Currencies','BND - Brunei Dollar','BND'),('Currencies','BOB - Boliviano','BOB'),('Currencies','BOV - Mvdol','BOV'),('Currencies','BRL - Brazilian Real','BRL'),('Currencies','BSD - Bahamian Dollar','BSD'),('Currencies','BTN - Ngultrum','BT'),('Currencies','BWP - Pula','BWP'),('Currencies','BYR - Belarussian Ruble','BYR'),('Currencies','BZD - Belize Dollar','BZD'),('Currencies','CAD - Canadian Dollar','CAD'),('Currencies','CDF - Congolese Franc','CDF'),('Currencies','CHE - WIR Euro','CHE'),('Currencies','CHF - Swiss Franc','CHF'),('Currencies','CHW - WIR Franc','CHW'),('Currencies','CLF - Unidades de fomento','CLF'),('Currencies','CLP - Chilean Peso','CLP'),('Currencies','CNY - Yuan Renminbi','CNY'),('Currencies','COP - Colombian Peso','COP'),('Currencies','COU - Unidad de Valor Real','COU'),('Currencies','CRC - Costa Rican Colon','CRC'),('Currencies','CUC - Peso Convertible','CUC'),('Currencies','CUP - Cuban Peso','CUP'),('Currencies','CVE - Cape Verde Escudo','CVE'),('Currencies','CZK - Czech Koruna','CZK'),('Currencies','DJF - Djibouti Franc','DJF'),('Currencies','DKK - Danish Krone','DKK'),('Currencies','DOP - Dominican Peso','DOP'),('Currencies','DZD - Algerian Dinar','DZD'),('Currencies','EGP - Egyptian Pound','EGP'),('Currencies','ERN - Nakfa','ER'),('Currencies','ETB - Ethiopian Birr','ETB'),('Currencies','EUR - Euro','EUR'),('Currencies','FJD - Fiji Dollar','FJD'),('Currencies','FKP - Falkland Islands Pound','FKP'),('Currencies','GBP - Pound Sterling','GBP'),('Currencies','GEL - Lari','GEL'),('Currencies','GHS - Ghana Cedi','GHS'),('Currencies','GIP - Gibraltar Pound','GIP'),('Currencies','GMD - Dalasi','GMD'),('Currencies','GNF - Guinea Franc','GNF'),('Currencies','GTQ - Quetzal','GTQ'),('Currencies','GYD - Guyana Dollar','GYD'),('Currencies','HKD - Hong Kong Dollar','HKD'),('Currencies','HNL - Lempira','HNL'),('Currencies','HRK - Croatian Kuna','HRK'),('Currencies','HTG - Gourde','HTG'),('Currencies','HUF - Forint','HUF'),('Currencies','IDR - Rupiah','IDR'),('Currencies','ILS - New Israeli Sheqel','ILS'),('Currencies','INR - Indian Rupee','INR'),('Currencies','IQD - Iraqi Dinar','IQD'),('Currencies','IRR - Iranian Rial','IRR'),('Currencies','ISK - Iceland Krona','ISK'),('Currencies','JMD - Jamaican Dollar','JMD'),('Currencies','JOD - Jordanian Dinar','JOD'),('Currencies','JPY - Yen','JPY'),('Currencies','KES - Kenyan Shilling','KES'),('Currencies','KGS - Som','KGS'),('Currencies','KHR - Riel','KHR'),('Currencies','KMF - Comoro Franc','KMF'),('Currencies','KPW - North Korean Won','KPW'),('Currencies','KRW - Won','KRW'),('Currencies','KWD - Kuwaiti Dinar','KWD'),('Currencies','KYD - Cayman Islands Dollar','KYD'),('Currencies','KZT - Tenge','KZT'),('Currencies','LAK - Kip','LAK'),('Currencies','LBP - Lebanese Pound','LBP'),('Currencies','LKR - Sri Lanka Rupee','LKR'),('Currencies','LRD - Liberian Dollar','LRD'),('Currencies','LSL - Loti','LSL'),('Currencies','LTL - Lithuanian Litas','LTL'),('Currencies','LVL - Latvian Lats','LVL'),('Currencies','LYD - Libyan Dinar','LYD'),('Currencies','MAD - Moroccan Dirham','MAD'),('Currencies','MDL - Moldovan Leu','MDL'),('Currencies','MGA - Malagasy Ariary','MGA'),('Currencies','MKD - Denar','MKD'),('Currencies','MMK - Kyat','MMK'),('Currencies','MNT - Tugrik','MNT'),('Currencies','MOP - Pataca','MOP'),('Currencies','MRO - Ouguiya','MRO'),('Currencies','MUR - Mauritius Rupee','MUR'),('Currencies','MVR - Rufiyaa','MVR'),('Currencies','MWK - Kwacha','MWK'),('Currencies','MXN - Mexican Peso','MX'),('Currencies','MXV - Mexican Unidad de Inversion (UDI)','MXV'),('Currencies','MYR - Malaysian Ringgit','MYR'),('Currencies','MZN - Mozambique Metical','MZ'),('Currencies','NAD - Namibia Dollar','NAD'),('Currencies','NGN - Naira','NG'),('Currencies','NIO - Cordoba Oro','NIO'),('Currencies','NOK - Norwegian Krone','NOK'),('Currencies','NPR - Nepalese Rupee','NPR'),('Currencies','NZD - New Zealand Dollar','NZD'),('Currencies','OMR - Rial Omani','OMR'),('Currencies','PAB - Balboa','PAB'),('Currencies','PEN - Nuevo Sol','PE'),('Currencies','PGK - Kina','PGK'),('Currencies','PHP - Philippine Peso','PHP'),('Currencies','PKR - Pakistan Rupee','PKR'),('Currencies','PLN - Zloty','PL'),('Currencies','PYG - Guarani','PYG'),('Currencies','QAR - Qatari Rial','QAR'),('Currencies','RCU - Resource Consumption Unit','RCU'),('Currencies','RON - New Romanian Leu','RO'),('Currencies','RSD - Serbian Dinar','RSD'),('Currencies','RUB - Russian Ruble','RUB'),('Currencies','RWF - Rwanda Franc','RWF'),('Currencies','SAR - Saudi Riyal','SAR'),('Currencies','SBD - Solomon Islands Dollar','SBD'),('Currencies','SCR - Seychelles Rupee','SCR'),('Currencies','SDG - Sudanese Pound','SDG'),('Currencies','SEK - Swedish Krona','SEK'),('Currencies','SGD - Singapore Dollar','SGD'),('Currencies','SHP - Saint Helena Pound','SHP'),('Currencies','SLL - Leone','SLL'),('Currencies','SOS - Somali Shilling','SOS'),('Currencies','SRD - Surinam Dollar','SRD'),('Currencies','SSP - South Sudanese Pound','SSP'),('Currencies','STD - Dobra','STD'),('Currencies','SVC - El Salvador Colon','SVC'),('Currencies','SYP - Syrian Pound','SYP'),('Currencies','SZL - Lilangeni','SZL'),('Currencies','THB - Baht','THB'),('Currencies','TJS - Somoni','TJS'),('Currencies','TMT - Turkmenistan New Manat','TMT'),('Currencies','TND - Tunisian Dinar','TND'),('Currencies','TOP - Paanga','TOP'),('Currencies','TRY - Turkish Lira','TRY'),('Currencies','TTD - Trinidad and Tobago Dollar','TTD'),('Currencies','TWD - New Taiwan Dollar','TWD'),('Currencies','TZS - Tanzanian Shilling','TZS'),('Currencies','UAH - Hryvnia','UAH'),('Currencies','UGX - Uganda Shilling','UGX'),('Currencies','USD - US Dollar','USD'),('Currencies','UYI - Uruguay Peso en Unidades Indexadas (URUIURUI)','UYI'),('Currencies','UYU - Peso Uruguayo','UYU'),('Currencies','UZS - Uzbekistan Sum','UZS'),('Currencies','VEF - Bolivar ','VEF'),('Currencies','VND - Dong','VND'),('Currencies','VUV - Vatu','VUV'),('Currencies','WST - Tala','WST'),('Currencies','XAF - CFA Franc BEAC','XAF'),('Currencies','XAG - Silver','XAG'),('Currencies','XAU - Gold','XAU'),('Currencies','XBA - Bond Markets Unit European Composite Unit (EURCO)','XBA'),('Currencies','XBB - Bond Markets Unit European Monetary Unit (E.M.U.-6)','XBB'),('Currencies','XBC - Bond Markets Unit European Unit of Account 9 (E.U.A.-9)','XBC'),('Currencies','XBD - Bond Markets Unit European Unit of Account 17 (E.U.A.-17)','XBD'),('Currencies','XCD - East Caribbean Dollar','XCD'),('Currencies','XDR - SDR (Special Drawing Right)','XDR'),('Currencies','XFU - UIC-Franc','XFU'),('Currencies','XOF - CFA Franc BCEAO','XOF'),('Currencies','XPD - Palladium','XPD'),('Currencies','XPF - CFP Franc','XPF'),('Currencies','XPT - Platinum','XPT'),('Currencies','XSU - Sucre','XSU'),('Currencies','XUA - ADB Unit of Account','XUA'),('Currencies','YER - Yemeni Rial','YER'),('Currencies','ZAR - Rand','ZAR'),('Currencies','ZMW - Zambian Kwacha','ZMW'),('Currencies','ZWL - Zimbabwe Dollar','ZWL'),('CurrencySymbols','AED','&#x62f;&#x2e;&#x625'),('CurrencySymbols','ANG','&#x192'),('CurrencySymbols','ARS','&#x24'),('CurrencySymbols','AUD','&#x41;&#x24'),('CurrencySymbols','BRL','&#x52;&#x24'),('CurrencySymbols','BSD','&#x42;&#x24'),('CurrencySymbols','CAD','&#x24'),('CurrencySymbols','CHF','&#x43;&#x48;&#x46'),('CurrencySymbols','CLP','&#x24'),('CurrencySymbols','CNY','&#xa5'),('CurrencySymbols','COP','&#x24'),('CurrencySymbols','CZK','&#x4b;&#x10d'),('CurrencySymbols','DKK','&#x6b;&#x72'),('CurrencySymbols','EUR','&#x20ac'),('CurrencySymbols','FJD','&#x46;&#x4a;&#x24'),('CurrencySymbols','GBP','&#xa3'),('CurrencySymbols','GHS','&#x47;&#x48;&#x20b5'),('CurrencySymbols','GTQ','&#x51'),('CurrencySymbols','HKD','&#x24'),('CurrencySymbols','HNL','&#x4c'),('CurrencySymbols','HRK','&#x6b;&#x6e'),('CurrencySymbols','HUF','&#x46;&#x74'),('CurrencySymbols','IDR','&#x52;&#x70'),('CurrencySymbols','ILS','&#x20aa'),('CurrencySymbols','INR','&#x20b9'),('CurrencySymbols','ISK','&#x6b;&#x72'),('CurrencySymbols','JMD','&#x4a;&#x24'),('CurrencySymbols','JPY','&#xa5'),('CurrencySymbols','KRW','&#x20a9'),('CurrencySymbols','LKR','&#x20a8'),('CurrencySymbols','MAD','&#x2e;&#x62f;&#x2e;&#x645'),('CurrencySymbols','MMK','&#x4b'),('CurrencySymbols','MXN','&#x24'),('CurrencySymbols','MYR','&#x52;&#x4d'),('CurrencySymbols','NOK','&#x6b;&#x72'),('CurrencySymbols','NZD','&#x24'),('CurrencySymbols','PAB','&#x42;&#x2f;&#x2e'),('CurrencySymbols','PEN','&#x53;&#x2f;&#x2e'),('CurrencySymbols','PHP','&#x20b1'),('CurrencySymbols','PKR','&#x20a8'),('CurrencySymbols','PLN','&#x7a;&#x142'),('CurrencySymbols','RON','&#x6c;&#x65;&#x69'),('CurrencySymbols','RSD','&#x52;&#x53;&#x44'),('CurrencySymbols','RUB','&#x440;&#x443;&#x431'),('CurrencySymbols','SEK','&#x6b;&#x72'),('CurrencySymbols','SGD','&#x53;&#x24'),('CurrencySymbols','THB','&#xe3f'),('CurrencySymbols','TND','&#x44;&#x54'),('CurrencySymbols','TRY','&#x54;&#x4c'),('CurrencySymbols','TTD','&#x24'),('CurrencySymbols','TWD','&#x4e;&#x54;&#x24'),('CurrencySymbols','USD','&#x24'),('CurrencySymbols','VEF','&#x42;&#x73'),('CurrencySymbols','VND','&#x20ab'),('CurrencySymbols','XAF','&#x46;&#x43;&#x46;&#x41'),('CurrencySymbols','XCD','&#x24'),('CurrencySymbols','XPF','&#x46'),('CurrencySymbols','ZAR','&#x52'),('DefaultEmailTemplate','Activate Customer Account','<p>Dear {firstName},<p><p>We\'re almost done!  One last step to complete your registration - please follow the link below to activate your customer account:</p><p>{customerName} - {customerActivationUrl}</p><p>Thank you!</p>'),('DefaultEmailTemplate','Billing Method Change','<p>Dear {firstName},</p><p>Your request to change your billing preference has been received.  You will receive another email once the change has been approved or denied.</p>'),('DefaultEmailTemplate','Billing Method Status','<p>Dear {firstName},</p><p>Your request to change your billing preference has been {status}.</p>'),('DefaultEmailTemplate','Credit Card Payment Failure','<p>Dear {firstName},</p><p>A credit card payment request has failed to complete for customer {customerName}.  Current balance still due: {balanceDue}</p>'),('DefaultEmailTemplate','Credit Card Payment Success','<p>Dear {firstName},</p><p>Your credit card payment to {reseller} has been successfully processed.  Amount charged: {balanceDue}</p>'),('DefaultEmailTemplate','Customer Account Activated','<p>Dear {firstName},</p><p>Your {customerName} customer account has been activated.</p><p>The reason for activation was: {activationReason}</p>'),('DefaultEmailTemplate','Customer Account Deactivated','<p>Dear {firstName},</p><p>Your {customerName} customer account has been deactivated.</p><p>The reason for deactivation was: {deactivationReason}</p>'),('DefaultEmailTemplate','Customer Account Deleted','<p>Dear {firstName},</p><p>Your {customerName} customer account has been deleted.</p><p>The reason for deletion was: {deletionReason}</p>'),('DefaultEmailTemplate','Customer PayPal PreAuthorization timeout','<p>Dear {firstName},</p><p>The PayPal PreAuthorization request has timed out.  As a result no accounts will be created for the customer {customer}.  The customer will need to redo the registration process in order to continue.</p>'),('DefaultEmailTemplate','New invoice available','<p>Dear {firstName},</p><p>We are sending you this mail to inform you that invoice no. {invoiceNumber} has been generated. It is also included as an attachment to this mail</p><p><br> {formTemplate}<br></p>'),('DefaultEmailTemplate','Password Change Request processed','<p>Dear {firstName},</p><p>Your Openbook password change request has been processed.</p><p>Please go to {passwordChangeUrl} to set your new password.</p><p> Please note that this link will expire at {tokenExpireDate}.</p>'),('DefaultEmailTemplate','Past Due Balance First Notice','<p>Dear {firstName},</p><p>Your account has an unpaid balance of {amountDue} that is {daysPastDue} days past due.</p><p>Please pay this balance as soon as possible to avoid any interruption of service.</p><p>Thank you.</p>'),('DefaultEmailTemplate','Past Due Balance Second Notice','<p>Dear {firstName},</p><p>Your account has an unpaid balance of {amountDue} that is {daysPastDue} days past due.</p><p>If not paid in full within {daysUntilNextAction} days, all instances and user logins associated with your account will be deactivated.</p><p>Please pay this balance as soon as possible to avoid any interruption of service.</p><p>Thank you.</p>'),('DefaultEmailTemplate','Past Due Balance Third Notice','<p>Dear {firstName},</p><p>Your account has an unpaid balance of {amountDue} that is {daysPastDue} days past due.</p><p>All instances and user logins associated with your account have been deactivated.  If not paid in full in {daysUntilNextAction} days, instance and other data, as well as user logins for your account will be permanently deleted.<p>Please pay this balance as soon as possible to restore you access and to avoid any loss of data.</p><p>Thank you.</p>'),('DefaultEmailTemplate','PayFast Payment Complete','<p>Dear {firstName},</p><p>Your payment of {amount} has successfully been processed via PayFast.</p><p>Thank You.</p>'),('DefaultEmailTemplate','PayFast Payment Failed','<p>Dear {firstName},</p><p>Your payment of {amount} via PayFast has failed.  Please review the payment to see if further action is needed.</p>'),('DefaultEmailTemplate','PayFast Payment Pending','<p>Dear {firstName},</p><p>Your payment of {amount} via PayFast is in a pending status.  Please contact PayFast support for further assistance.</p>'),('DefaultEmailTemplate','PayPal Payment Failure','<p>Dear {firstName},</p><p>The PayPal PreAuthorization payment request has failed to complete for customer {customerName}.  Curent balance still due: {balanceDue}</p>'),('DefaultEmailTemplate','PayPal Payment Pending','<p>Dear {firstName},</p><p>Your payment of {amount} via PayPal is currently processing and in a pending status.</p>'),('DefaultEmailTemplate','PayPal Payment Success','<p>Dear {firstName},</p><p>Your PayPal payment to {reseller} has been successfully processed.  Amount charged: {balanceDue}.</p>'),('DefaultEmailTemplate','PayPal PreAuthorization','<p>Dear {firstName},</p><p>Please confirm your PayPal PreAuthorization by clicking on the link below.<br/><br/>https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_ap-preapproval&preapprovalkey={key} </p>'),('DefaultEmailTemplate','PayPal PreAuthorization declined','<p>Dear {firstName},</p><p>The PayPal PreAuthorization request has been declined.  As a result no accounts will be created and you will need to redo the registration in order to continue.</p>'),('DefaultEmailTemplate','PayPal PreAuthorization timeout','<p>Dear {firstName},</p><p>The PayPal PreAuthorization request has timed out.  As a result no accounts will be created and you will need to redo the registration in order to continue.</p>'),('DefaultEmailTemplate','Quota Change Request','<p>Dear {firstName},</p><p>Customer {customerName} has submitted a new request to modify the value for quota {quotaName} from {oldValue} to {newValue}.  A new task has been added to the queue and is awaiting approval.</p>'),('DefaultEmailTemplate','Quota Change Request approved','<p>Dear {firstName},</p><p>Your request to modify the value for quota {quotaName} has been completed.</p><p>The quota was changed from {oldValue} to {newValue}</p>'),('DefaultEmailTemplate','Quota Change Request denied','<p>Dear {firstName},</p><p>Your request to modify the value for quota {quotaName} from {oldValue} to {newValue} has been denied for the following reason: {reason}</p>'),('DefaultEmailTemplate','Self Registration denied','<p>Dear {firstName},</p><p>Your request to create an Openbook login account has been denied for the following reason: {reason}</p>'),('DefaultEmailTemplate','Self Registration Processing','<p>Dear {firstName},</p><p>Your request to create an Openbook login account has been received and is currently awaiting approval.</p>'),('DefaultEmailTemplate','Self Registration Task Created','<p>Dear {firstName},</p><p>A self registration approval is required for new customer \"{customerName}\".  A task has been added to the queue and is awaiting approval.</p>'),('DefaultEmailTemplate','Task Created','<p>Dear {firstName},</p><p>A task is awaiting approval for customer \"{customerName}\".  Please log into the administrator dashboard to approve or deny this task.</p>'),('DefaultEmailTemplate','User Account created','<p>Dear {firstName},</p><p>An Openbook login account has been created for you with login id {username}.</p><p>To complete your registration, go to {passwordChangeUrl} to set your password.</p><p> Please note that this account will be deleted if you don&#39;t complete the registration by {tokenExpireDate}.</p>'),('DefaultEmailTemplate','Workflow Failure','<p>Dear {firstName},</p><p>A workflow process for customer {customerName} failed to complete.  Please check the logs and process history for details.\n\nProcess Instance ID:{processID}</p>'),('DefaultEmailTemplate','Workflow Failure Detail','<p>Dear {firstName},</p><p>A workflow process ({processName}) for customer {customerName} failed to complete.</p><p>Process Instance ID:{processID}</p><p>Exception Message:{errorMessage}</p><p></p><p>Stack Trace:\n{stack}</p>'),('MailingAddressTemplate','CH.MultiLine','<p>{streetAddress}</p><p>{postalCode} {city} {region}</p><p>{country}</p>'),('MailingAddressTemplate','CH.SingleLine','{streetAddress}, {postalCode} {city} {region}, {country}'),('MailingAddressTemplate','US.MultiLine','<p>{streetAddress}</p><p>{city} {region} {postalCode}</p><p>{country}</p>'),('MailingAddressTemplate','US.SingleLine','{streetAddress}, {city} {region} {postalCode}, {country}'),('USStates','Alabama','AL'),('USStates','Alaska','AK'),('USStates','Arizona','AZ'),('USStates','Arkansas','AR'),('USStates','California','CA'),('USStates','Colorado','CO'),('USStates','Connecticut','CT'),('USStates','Delaware','DE'),('USStates','District of Columbia','DC'),('USStates','Florida','FL'),('USStates','Georgia','GA'),('USStates','Hawaii','HI'),('USStates','Idaho','ID'),('USStates','Illinois','IL'),('USStates','Indiana','IN'),('USStates','Iowa','IA'),('USStates','Kansas','KS'),('USStates','Kentucky','KY'),('USStates','Louisiana','LA'),('USStates','Maine','ME'),('USStates','Maryland','MD'),('USStates','Massachusetts','MA'),('USStates','Michigan','MI'),('USStates','Minnesota','MN'),('USStates','Mississippi','MS'),('USStates','Missouri','MO'),('USStates','Montana','MT'),('USStates','Nebraska','NE'),('USStates','Nevada','NV'),('USStates','New Hampshire','NH'),('USStates','New Jersey','NJ'),('USStates','New Mexico','NM'),('USStates','New York','NY'),('USStates','North Carolina','NC'),('USStates','North Dakota','ND'),('USStates','Ohio','OH'),('USStates','Oklahoma','OK'),('USStates','Oregon','OR'),('USStates','Pennsylvania','PA'),('USStates','Rhode Island','RI'),('USStates','South Carolina','SC'),('USStates','South Dakota','SD'),('USStates','Tennessee','TN'),('USStates','Texas','TX'),('USStates','Utah','UT'),('USStates','Vermont','VT'),('USStates','Virginia','VA'),('USStates','Washington','WA'),('USStates','West Virginia','WV'),('USStates','Wisconsin','WI'),('USStates','Wyoming','WY');
/*!40000 ALTER TABLE `t_lookup_values` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metadata_attributes`;
/*!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 */;

LOCK TABLES `t_metadata_attributes` WRITE;
/*!40000 ALTER TABLE `t_metadata_attributes` DISABLE KEYS */;
INSERT INTO `t_metadata_attributes` VALUES (1,'Service','firewall_policy_id','string',NULL,NULL),(1,'Service','host','string',NULL,NULL),(2,'Service','fixed_ip_address','string',NULL,NULL),(2,'Service','floating_ip_address','string',NULL,NULL),(2,'Service','host','string',NULL,NULL),(2,'Service','port_id','string',NULL,NULL),(2,'Service','router_id','string',NULL,NULL),(3,'Service','availability_zone','string',NULL,NULL),(3,'Service','disk_gb','number','GB',NULL),(3,'Service','flavor','string',NULL,NULL),(3,'Service','flavor_id','string',NULL,NULL),(3,'Service','host','string',NULL,NULL),(3,'Service','image','string',NULL,NULL),(3,'Service','image_id','string',NULL,NULL),(3,'Service','memory_mb','number','MB',NULL),(3,'Service','root_gb','number','GB',NULL),(3,'Service','vcpus','number','vcpu',NULL),(4,'Service','image_type','string',NULL,NULL),(4,'Service','size','number','GB',NULL),(5,'Service','address','string',NULL,NULL),(5,'Service','connection_limit','number',NULL,NULL),(5,'Service','pool_id','string',NULL,NULL),(5,'Service','port_id','string',NULL,NULL),(5,'Service','protocol','string',NULL,NULL),(5,'Service','protocol_port','string',NULL,NULL),(5,'Service','subnet_id','string',NULL,NULL),(6,'Service','shared','boolean',NULL,NULL),(6,'Service','subnets','string',NULL,NULL),(7,'Service','device_id','string',NULL,NULL),(7,'Service','device_owner','string',NULL,NULL),(7,'Service','fixed_ips','string',NULL,NULL),(7,'Service','network_id','string',NULL,NULL),(8,'Service','image_type','string',NULL,NULL),(8,'Service','size_gb','number','GB',NULL),(9,'Service','availability_zone','string',NULL,NULL),(9,'Service','host','string',NULL,NULL),(9,'Service','size','number','GB',NULL),(10,'Service','cidr','string',NULL,NULL),(10,'Service','enable_dhcp','boolean',NULL,NULL),(10,'Service','gateway_ip','string',NULL,NULL),(10,'Service','host','string',NULL,NULL),(10,'Service','ip_version','string',NULL,NULL),(11,'Service','availability_zone','string',NULL,NULL),(11,'Service','bootable','boolean',NULL,NULL),(11,'Service','encrypted','boolean',NULL,NULL),(11,'Service','host','string',NULL,NULL),(11,'Service','size','number','GB',NULL),(11,'Service','volume_type','string',NULL,NULL),(12,'Service','disks','number','disk',NULL),(12,'Service','disk_gb','number','GB',NULL),(12,'Service','guest_id','string',NULL,NULL),(12,'Service','guest_name','string',NULL,NULL),(12,'Service','host','string',NULL,NULL),(12,'Service','memory_gb','number','GB',NULL),(12,'Service','vcpus','number','vcpu',NULL),(13,'Service','bytes','number','B',NULL),(13,'Service','size_gb','number','GB',NULL);
/*!40000 ALTER TABLE `t_metadata_attributes` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric`;
/*!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=50 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric` WRITE;
/*!40000 ALTER TABLE `t_metric` DISABLE KEYS */;
INSERT INTO `t_metric` VALUES (1,1,'bandwidth','Layer 3 Bandwidth','Ceilometer','delta','B','serviceInstance','hour'),(3,1,'cpu.delta','Instance CPU Delta','Ceilometer','delta','ns','serviceInstance','hour'),(4,1,'cpu_util','Instance CPU Utilization','Ceilometer','gauge','percent','serviceInstance','hour'),(9,1,'disk.read.requests.rate','Instance Disk Read Requests Rate','Ceilometer','gauge','request/s','serviceInstance','hour'),(10,1,'disk.write.requests.rate','Instance Disk Write Requests Rate','Ceilometer','gauge','request/s','serviceInstance','hour'),(11,1,'disk.read.bytes.rate','Instance Disk Read Bytes Rate','Ceilometer','gauge','B/s','serviceInstance','hour'),(12,1,'disk.write.bytes.rate','Instance Disk Write Bytes Rate','Ceilometer','gauge','B/s','serviceInstance','hour'),(13,1,'energy','Energy','Ceilometer','cumulative','kWh','serviceInstance','hour'),(14,1,'ip.floating.receive.bytes','Floating IP Incoming Bandwidth','Ceilometer','cumulative','B','serviceInstance','hour'),(15,1,'ip.floating.transmit.bytes','Floating IP Outgoing Bandwidth','Ceilometer','cumulative','B','serviceInstance','hour'),(16,1,'ip.floating.receive.packets','Floating IP Incoming Packets','Ceilometer','cumulative','packet','serviceInstance','hour'),(17,1,'ip.floating.transmit.packets','Floating IP Outgoing Packets','Ceilometer','cumulative','packet','serviceInstance','hour'),(18,1,'image.size','Image Size','Ceilometer','gauge','B','serviceInstance','hour'),(23,1,'network.incoming.bytes.rate','Instance Incoming Bandwidth Rate','Ceilometer','gauge','B/s','serviceInstance','hour'),(24,1,'network.outgoing.bytes.rate','Instance Outgoing Bandwidth Rate','Ceilometer','gauge','B/s','serviceInstance','hour'),(25,1,'network.incoming.packets.rate','Instance Incoming Packets Rate','Ceilometer','gauge','packet/s','serviceInstance','hour'),(26,1,'network.outgoing.packets.rate','Instance Outgoing Packets Rate','Ceilometer','gauge','packet/s','serviceInstance','hour'),(28,1,'network.services.lb.active.connections','Load Balancer Active Connections','Ceilometer','gauge','connection','serviceInstance','hour'),(31,1,'storage.objects.size','Object Storage Size','Ceilometer','gauge','B','serviceInstance','hour'),(32,1,'storage.api.request','Object Storage API Requests','Ceilometer','delta','request','serviceInstance','hour'),(33,1,'storage.objects.incoming.bytes','Object Storage Incoming Bytes','Ceilometer','delta','B','serviceInstance','hour'),(34,1,'storage.objects.outgoing.bytes','Object Storage Outgoing Bytes','Ceilometer','delta','B','serviceInstance','hour'),(35,1,'radosgw.objects.size','Ceph Object Storage Size','Ceilometer','gauge','B','serviceInstance','hour'),(36,1,'radosgw.api.request','Ceph Object Storage API Requests','Ceilometer','delta','request','serviceInstance','hour'),(37,1,'memory','Instance Memory','Ceilometer','gauge','MB','serviceInstance','hour'),(38,1,'memory.usage','Instance Memory Usage','Ceilometer','gauge','MB','serviceInstance','hour'),(39,1,'power','Power','Ceilometer','gauge','W','serviceInstance','hour'),(40,1,'snapshot.size','Snapshot Size','Ceilometer','gauge','GB','serviceInstance','hour'),(41,1,'volume.size','Volume Size','Ceilometer','gauge','GB','serviceInstance','hour'),(42,1,'compute.node.cpu.frequency','Compute Host CPU Frequency','Ceilometer','gauge','MHz','serviceInstance','hour'),(43,1,'compute.node.cpu.percent','Compute Host CPU Percent','Ceilometer','gauge','percent','serviceInstance','hour'),(44,1,'quota.compute.cores','Compute Quota - VCPUs','Openbook','gauge','vcpu','tenant','day'),(45,1,'quota.compute.ram','Compute Quota - RAM','Openbook','gauge','MB','tenant','day'),(46,1,'quota.compute.instances','Compute Quota - Instances','Openbook','gauge','instance','tenant','day'),(47,1,'quota.volume.gigabytes','Volume Quota - Volume GB','Openbook','gauge','GB','tenant','day'),(48,1,'quota.volume.volumes','Volume Quota - Volumes','Openbook','gauge','volume','tenant','day'),(49,1,'quota.volume.snapshots','Volume Quota - Snapshots','Openbook','gauge','snapshots','tenant','day');
/*!40000 ALTER TABLE `t_metric` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_customer_daily`;
/*!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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_customer_daily` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_daily` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_daily` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_customer_hourly`;
/*!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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_customer_hourly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_hourly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_hourly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_customer_monthly`;
/*!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 */;

LOCK TABLES `t_metric_aggregate_customer_monthly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_monthly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_customer_monthly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_resource_daily`;
/*!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,
  `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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_resource_daily` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_daily` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_daily` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_resource_hourly`;
/*!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,
  `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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_resource_hourly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_hourly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_hourly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_resource_monthly`;
/*!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,
  `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 */;

LOCK TABLES `t_metric_aggregate_resource_monthly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_monthly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_resource_monthly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_tenant_daily`;
/*!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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_tenant_daily` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_daily` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_daily` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_tenant_hourly`;
/*!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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_aggregate_tenant_hourly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_hourly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_hourly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_aggregate_tenant_monthly`;
/*!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 */;

LOCK TABLES `t_metric_aggregate_tenant_monthly` WRITE;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_monthly` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_aggregate_tenant_monthly` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_metric_values`;
/*!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`))
(PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
 PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
 PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
 PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
 PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
 PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
 PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
 PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
 PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB,
 PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB,
 PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB,
 PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB,
 PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB,
 PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB,
 PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB,
 PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB,
 PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB,
 PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB,
 PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB,
 PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB,
 PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB,
 PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB,
 PARTITION `p737092` VALUES LESS THAN (737092) ENGINE = InnoDB,
 PARTITION `p737093` VALUES LESS THAN (737093) ENGINE = InnoDB,
 PARTITION `p737094` VALUES LESS THAN (737094) ENGINE = InnoDB,
 PARTITION `p737095` VALUES LESS THAN (737095) ENGINE = InnoDB,
 PARTITION `p737096` VALUES LESS THAN (737096) ENGINE = InnoDB,
 PARTITION `p737097` VALUES LESS THAN (737097) ENGINE = InnoDB,
 PARTITION `p737098` VALUES LESS THAN (737098) ENGINE = InnoDB,
 PARTITION `p737099` VALUES LESS THAN (737099) ENGINE = InnoDB,
 PARTITION `p737100` VALUES LESS THAN (737100) ENGINE = InnoDB,
 PARTITION `p737101` VALUES LESS THAN (737101) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_metric_values` WRITE;
/*!40000 ALTER TABLE `t_metric_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_metric_values` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_parent_child_relationships`;
/*!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 */;

LOCK TABLES `t_parent_child_relationships` WRITE;
/*!40000 ALTER TABLE `t_parent_child_relationships` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_parent_child_relationships` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_payment`;
/*!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 */;

LOCK TABLES `t_payment` WRITE;
/*!40000 ALTER TABLE `t_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_payment` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_product`;
/*!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=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_product` WRITE;
/*!40000 ALTER TABLE `t_product` DISABLE KEYS */;
INSERT INTO `t_product` VALUES (1,'OpenStack Instance','ServiceBased',3,'Instances','{\"ratingInterval\":\"hour\",\"ratingScheme\":\"flatRate\"}',1,1,1),(2,'OpenStack Floating IP','ServiceBased',2,'Floating IPs','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(3,'OpenStack Subnet','ServiceBased',10,'Subnets','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(4,'OpenStack Port','ServiceBased',7,'Ports','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(5,'OpenStack Router','ServiceBased',8,'Routers','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(6,'OpenStack Image','ServiceBased',4,'Images','{\"billableUnit\":\"GB\",\"billableAttribute\":\"size\",\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(7,'OpenStack Volume','ServiceBased',11,'Volumes','{\"billableUnit\":\"GB\",\"billableAttribute\":\"size\",\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(8,'OpenStack LB VIP','ServiceBased',5,'Load Balancer VIPs','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(9,'OpenStack Firewall','ServiceBased',1,'Firewalls','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(10,'OpenStack Network','ServiceBased',6,'Networks','{\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(11,'OpenStack Snapshot','ServiceBased',9,'Snapshots','{\"billableUnit\":\"GB\", \"billableAttribute\":\"size\",\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1),(12,'OpenStack Object Container','ServiceBased',13,'Object Containers','{\"billableUnit\":\"GB\",\"billableAttribute\":\"size_gb\",\"ratingInterval\":\"month\",\"ratingScheme\":\"flatRate\"}',1,1,1);
/*!40000 ALTER TABLE `t_product` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_promo_code`;
/*!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 */;

LOCK TABLES `t_promo_code` WRITE;
/*!40000 ALTER TABLE `t_promo_code` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_promo_code` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_promo_code_redemption`;
/*!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 */;

LOCK TABLES `t_promo_code_redemption` WRITE;
/*!40000 ALTER TABLE `t_promo_code_redemption` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_promo_code_redemption` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_properties_schema`;
/*!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 */;

LOCK TABLES `t_properties_schema` WRITE;
/*!40000 ALTER TABLE `t_properties_schema` DISABLE KEYS */;
INSERT INTO `t_properties_schema` VALUES ('Advanced','apiEndpointURLType','publicURL','API Endpoint URL Type',10,'string','','',0,'public, private, internal, etc..',1),('Advanced','collectCapacityStats','TRUE','Collect capacity stats',15,'boolean','checkbox','',0,'Flag for collecting capacity stats',1),('Advanced','collectQuotaMetrics','FALSE','Collect quota metrics',35,'boolean','checkbox','',0,'',1),('Advanced','defaultHostCPUAllocationRatio','16','Default host CPU allocation ratio',20,'string','','',0,'',1),('Advanced','defaultHostDiskAllocationRatio','1','Default host disk allocation ratio',30,'string','','',0,'',1),('Advanced','defaultHostRAMAllocationRatio','1.5','Default host RAM Allocation Ratio',25,'string','','',0,'',1),('Advanced','isLab','FALSE','Is lab environment',55,'boolean','checkbox','',0,'',1),('Advanced','jwtSSOEnabled','FALSE','JWT SSO Enabled',45,'boolean','checkbox','',0,'',1),('Advanced','ldapEnabled','FALSE','LDAP Enabled',50,'boolean','checkbox','',0,'',1),('Advanced','memberRoleName','_member_','OpenStack member role name',0,'string','','',0,'OpenStack member role name',1),('Advanced','protectedTenants','admin, services, demo','Protected tenants',5,'string','','',0,'',1),('Advanced','quotaMetricsToCollect','{\"compute\": [\"ram\",\"floating_ips\",\"instances\",\"cores\"],\"volume\": [\"snapshots_iscsi\",\"gigabytes\",\"backup_gigabytes\",\"volumes_iscsi\",\"snapshots\",\"volumes\",\"backups\",\"gigabytes_iscsi\"]}','Quota metrics to collect',40,'string','','',0,'',1),('Advanced','syncTenantUsers','FALSE','Sync tenant users',60,'boolean','checkbox','',0,'',1),('Advanced','tenantSyncDomain','default','Keystone domain to sync',60,'string','','',0,'',1),('Email Server','authRequired','','Auth Required',60,'boolean','checkbox','',0,'',0),('Email Server','enableStartTLS','','Enable StartTLS',50,'boolean','checkbox','',0,'',0),('Email Server','host','','Host',10,'string','','',1,'',0),('Email Server','password','','Password',40,'string','password','',0,'',0),('Email Server','port','25','Port',20,'integer','','',1,'',0),('Email Server','user','','User',30,'string','','',0,'',0),('Invoice Customization','createInvoiceWhenNoLineItems','false','Generate an invoice even when the invoice has no line items',90,'boolean','checkbox','',0,'',0),('Invoice Customization','customerTaxIdLabel','VAT Number','Customer Tax ID label',30,'string','','',0,'',0),('Invoice Customization','displayCustomerId','TRUE','Display Customer ID',64,'boolean','checkbox','',0,'',0),('Invoice Customization','displayCustomerTaxIdOnInvoice','FALSE','Display my Tax ID on invoice',40,'boolean','checkbox','',0,'',0),('Invoice Customization','displayInvoiceNumber','TRUE','Display Invoice Number',62,'boolean','checkbox','',0,'',0),('Invoice Customization','displayProviderTaxIdOnInvoice','FALSE','Display customer Tax ID on invoice',20,'boolean','checkbox','',0,'',0),('Invoice Customization','displayStackType','true','Display stack type as prefix for region name',64,'boolean','checkbox','',0,'',0),('Invoice Customization','invoiceFooterText','','Footer Text',70,'string','html','',0,'',0),('Invoice Customization','invoiceLabel','Invoice','Invoice label',10,'string','','',1,'',0),('Invoice Customization','minimumCharge','0.00','Invoice line item minimum charge',80,'number','','',1,'',0),('Invoice Customization','nullRegionLabel','Unspecified Region','Null Region Label',66,'string','','',0,'',0),('Invoice Customization','nullTenantLabel','Unspecified Tenant','Null Tenant Label',68,'string','','',0,'',0),('Invoice Customization','providerTaxIdLabel','VAT Number','My Tax ID label',60,'string','','',0,'',0),('Invoice Customization','sendInvoiceEmails','true','Send invoice emails',100,'boolean','checkbox','',1,'',0),('Invoice Customization','taxId','','My Tax ID',50,'string','','',0,'',0),('Notifications','slackApprovalUrl','','Workflow approval URL',20,'string','url','',0,'URL used to approve workflow items',0),('Notifications','slackChannel','','Channel',10,'string','','',0,'Channel to send messages to',0),('Notifications','slackWebhook','','Slack Webhook',0,'string','url','',0,'Webhook for Slack messages',0),('Payment Processing','allowMonthlyInvoicingAsPaymentOption','FALSE','Allow registrants to select Monthly Invoicing In Arrears as a payment option',40,'boolean','checkbox','',0,'',0),('Payment Processing','allowRegistrationsWithoutPaymentInfo','TRUE','Allow registrations without providing payment details',20,'boolean','checkbox','',0,'',0),('Payment Processing','askRegistrantsForPaymentInfo','FALSE','Ask self-registering customers for payment details',10,'boolean','checkbox','',0,'',0),('Payment Processing','automaticPaymentProcessingEnabled','FALSE','Enable automatic payment processing',60,'boolean','checkbox','',0,'',0),('Payment Processing','defaultCurrency','USD','Default Currency',5,'string','dropdown','NameValueLookup:Currencies',1,'',0),('Payment Processing','deleteCustomerOnFinalNotice','FALSE','Delete customer on 4th notice',130,'boolean','checkbox','',0,'',0),('Payment Processing','disableCustomerOnThirdNotice','FALSE','Disable customer on 3rd notice',110,'boolean','checkbox','',0,'',0),('Payment Processing','finalNoticeOnDay','0','4th late payment notice on day',120,'integer','','',0,'',0),('Payment Processing','firstNoticeOnDay','0','1st late payment notice on day',80,'integer','','',0,'',0),('Payment Processing','latePaymentProcessingEnabled','FALSE','Enable late payment processing',70,'boolean','checkbox','',0,'',0),('Payment Processing','requireApprovalForMonthlyInvoicing','FALSE','Require approval when registrant requests monthly invoicing in arrears',50,'boolean','checkbox','',0,'',0),('Payment Processing','requirePromoCodeWhenNoPaymentInfo','FALSE','Require promo code when registering without providing a payment method',30,'boolean','checkbox','',0,'',0),('Payment Processing','secondNoticeOnDay','0','2nd late payment notice on day',90,'integer','','',0,'',0),('Payment Processing','thirdNoticeOnDay','0','3rd late payment notice on day',100,'integer','','',0,'',0),('Provision','allowProvisioning','FALSE','Allow provisioning',0,'boolean','checkbox','',0,'',1),('Provision','postProjectHeat1','heat_template_version: 2015-04-30\n\ndescription: >\n  Builds Security Group Rules using EDN aggregate address ranges as sources\n\nparameters:\n  web_secgroup_name: { type: string, description: Security Group Rules for web services built using EDN aggregate address ranges as sources, default: EDN-web_services }\n  ssh_secgroup_name: { type: string, description: Security Group Rules for ssh services built using EDN aggregate address ranges as sources, default: EDN-ssh_services }\n\nresources:\n  web_services_secgroup:\n    type: OS::Neutron::SecurityGroup\n    properties:\n      name: { get_param: web_secgroup_name }\n      description: Used for accessing remote security reporting webservers (allows SSH, SSL/TLS ports, ICMP and intra-tenant communications only)\n      rules:\n         - protocol: icmp\n           remote_ip_prefix: 0.0.0.0/0\n         - protocol: tcp\n           remote_ip_prefix: 192.168.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: udp\n           remote_ip_prefix: 192.168.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: tcp\n           remote_ip_prefix: 172.16.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: udp\n           remote_ip_prefix: 172.16.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: tcp\n           remote_ip_prefix: 10.0.0.0/18\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.0.0.0/18\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.70.0.0/15\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.70.0.0/15\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.84.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.84.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.88.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.88.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.92.0.0/15\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.92.0.0/15\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.132.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.132.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.136.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.136.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.140.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.140.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.185.0.0/19\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.185.0.0/19\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.192.0.0/13\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.192.0.0/13\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.200.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.200.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.212.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.212.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.216.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.216.0.0/14\n           port_range_min: 443\n           port_range_max: 443\n         - protocol: tcp\n           remote_ip_prefix: 10.232.0.0/13\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.232.0.0/13\n           port_range_min: 443\n           port_range_max: 443\n  ssh_services_secgroup:\n    type: OS::Neutron::SecurityGroup\n    properties:\n      name: { get_param: ssh_secgroup_name }\n      description: Used for accessing remote security auditing nodes (allows inbound SSH, ICMP and intra-tenant communication only)\n      rules:\n         - protocol: icmp\n           remote_ip_prefix: 0.0.0.0/0\n         - protocol: tcp\n           remote_ip_prefix: 192.168.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: udp\n           remote_ip_prefix: 192.168.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: tcp\n           remote_ip_prefix: 172.16.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: udp\n           remote_ip_prefix: 172.16.1.0/24\n           port_range_min: 1\n           port_range_max: 65535\n         - protocol: tcp\n           remote_ip_prefix: 10.0.0.0/18\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.70.0.0/15\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.84.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.88.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.92.0.0/15\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.132.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.136.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.140.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.185.0.0/19\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.192.0.0/13\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.200.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.212.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.216.0.0/14\n           port_range_min: 22\n           port_range_max: 22\n         - protocol: tcp\n           remote_ip_prefix: 10.232.0.0/13\n           port_range_min: 22\n           port_range_max: 22','Post project create heat template',10,'string','yaml','',0,'',1),('Quota','applyQuota','FALSE','Apply Quota When Provisioning',0,'boolean','checkbox','',0,'',1),('Quota','applyQuota','FALSE','Apply Quota When Provisioning',0,'boolean','checkbox','',0,'',2),('Quota','quota:compute:cores','20','Cores',50,'integer','','',0,'',1),('Quota','quota:compute:cores','20','Cores',50,'integer','','',0,'',2),('Quota','quota:compute:injected_files','5','Injected Files',40,'integer','','',0,'',1),('Quota','quota:compute:injected_files','5','Injected Files',40,'integer','','',0,'',2),('Quota','quota:compute:injected_file_content_bytes','10240','Injected File Content (Bytes)',9,'integer','','',0,'',1),('Quota','quota:compute:injected_file_content_bytes','10240','Injected File Content (Bytes)',9,'integer','','',0,'',2),('Quota','quota:compute:instances','10','Instances',30,'integer','','',0,'',1),('Quota','quota:compute:instances','10','Instances',30,'integer','','',0,'',2),('Quota','quota:compute:metadata_items','128','Metadata Items',10,'integer','','',0,'',1),('Quota','quota:compute:metadata_items','128','Metadata Items',10,'integer','','',0,'',2),('Quota','quota:compute:ram','51200','RAM',20,'integer','','',0,'',1),('Quota','quota:compute:ram','51200','RAM',20,'integer','','',0,'',2),('Quota','quota:network:floating_ips','50','Floating IPs',110,'integer','','',0,'',1),('Quota','quota:network:floating_ips','50','Floating IPs',110,'integer','','',0,'',2),('Quota','quota:network:networks','10','Networks',100,'integer','','',0,'',1),('Quota','quota:network:networks','10','Networks',100,'integer','','',0,'',2),('Quota','quota:network:ports','50','Ports',150,'integer','','',0,'',1),('Quota','quota:network:ports','50','Ports',150,'integer','','',0,'',2),('Quota','quota:network:routers','10','Routers',140,'integer','','',0,'',1),('Quota','quota:network:routers','10','Routers',140,'integer','','',0,'',2),('Quota','quota:network:security_groups','10','Security Groups',120,'integer','','',0,'',1),('Quota','quota:network:security_groups','10','Security Groups',120,'integer','','',0,'',2),('Quota','quota:network:security_group_rules','50','Security Group Rules',130,'integer','','',0,'',1),('Quota','quota:network:security_group_rules','50','Security Group Rules',130,'integer','','',0,'',2),('Quota','quota:network:subnets','10','Subnets',90,'integer','','',0,'',1),('Quota','quota:network:subnets','10','Subnets',90,'integer','','',0,'',2),('Quota','quota:volume:gigabytes','1000','Total Size of Volumes and Snapshots (GB)',80,'integer','','',0,'',1),('Quota','quota:volume:gigabytes','1000','Total Size of Volumes and Snapshots (GB)',80,'integer','','',0,'',2),('Quota','quota:volume:snapshots','10','Snapshots',70,'integer','','',0,'',1),('Quota','quota:volume:snapshots','10','Snapshots',70,'integer','','',0,'',2),('Quota','quota:volume:volumes','10','Volumes',60,'integer','','',0,'',1),('Quota','quota:volume:volumes','10','Volumes',60,'integer','','',0,'',2),('Self-Registration Settings','askCompaniesForRegNumber','FALSE','Ask companies for Registration Number',40,'boolean','checkbox','',0,'',0),('Self-Registration Settings','askCompaniesForVATNumber','FALSE','Ask companies for VAT Number',50,'boolean','checkbox','',0,'',0),('Self-Registration Settings','askIfRegisteringAsCompanyOrIndividual','FALSE','Ask registrants if they\'re registering as company or individual',20,'boolean','checkbox','',0,'',0),('Self-Registration Settings','askIndividualsForIDNumber','FALSE','Ask individuals for Identity Number',30,'boolean','checkbox','',0,'',0),('Self-Registration Settings','askRegistrantsForAddress','FALSE','Ask registrants for address',60,'boolean','checkbox','',0,'',0),('Self-Registration Settings','customerMetadata','','Customer Metadata',110,'string','','',0,'',0),('Self-Registration Settings','externalNetwork','','Name of external network to use for project router and VM floating IPs',125,'string','','',0,'',0),('Self-Registration Settings','pageTitle','Self-Registration','Registration page title',10,'string','','',1,'',0),('Self-Registration Settings','projectInitHeat1','heat_template_version: 2015-04-30\n\ndescription: Create project network and access\n\nparameters:\n  private_network_name:\n    type: string\n    description: Private Network\n    default: private_network\nresources:\n  private_net:\n    type: OS::Neutron::Net\n    description: Private Network\n    properties:\n      name: { get_param: private_network_name }\n  subnet:\n    type: OS::Neutron::Subnet\n    description: Private Subnet\n    properties:\n      network_id: { get_resource: private_net }\n      cidr: \"192.168.0.0/24\"\n      dns_nameservers: [ \"8.8.8.8\", \"8.8.4.4\" ]\n      ip_version: 4\n  external_access:\n    type: OS::Neutron::SecurityGroup\n    description: SSH Access\n    properties:\n      name: ssh-access\n      rules:\n        - remote_ip_prefix: 0.0.0.0/0\n          protocol: tcp\n          port_range_min: 22\n          port_range_max: 22\n  public_port:\n    type: OS::Neutron::Port\n    description: Public Port\n    properties:\n      network: { get_resource: private_net }\n      security_groups:\n      - {get_resource: external_access}\noutputs:\n private_network_id:\n   description: The subnet Id of the created resource\n   value: { get_resource: private_net }','Heat template to use for creating project and user',122,'string','yaml','',0,'',0),('Self-Registration Settings','projectInitHeat1Active','TRUE','Create OpenStack Project and User for self-registering customers',121,'boolean','checkbox','',0,'',0),('Self-Registration Settings','projectInitHeat2','heat_template_version: 2015-04-30\n\ndescription: Create access to public network\n\nparameters:\n  public_net_name:\n    type: string\n    description: Public Network\n    default: external_network3\n  private_network_id:\n    type: string\n    description: Private network subnet Id\n    default: 66b3ed6e-7b5c-47e1-bf05-ef823c513886\n  private_router_interface_ip:\n    type: string\n    description: IP\n    default: 192.168.0.253\nresources:\n  router:\n    type: OS::Neutron::Router\n    description: Router\n    properties:\n      external_gateway_info:\n        network: { get_param: public_net_name }\n  port:\n    type: OS::Neutron::Port\n    description: Port\n    properties:\n      network: { get_param: private_network_id }\n      fixed_ips:\n        - ip_address: { get_param: private_router_interface_ip }\n  router_interface:\n    type: OS::Neutron::RouterInterface\n    description: Router Interface\n    properties:\n      port: { get_resource: port }\n      router_id: { get_resource: router }\n  router_gateway_external:\n    type: OS::Quantum::RouterGateway\n    properties:\n      router_id: { get_resource: router }\n      network_id: { get_param: public_net_name }','Heat template to use for creating pre-requisite elements',124,'string','yaml','',0,'',0),('Self-Registration Settings','projectInitHeat2Active','TRUE','Create pre-requisite elements for VM provisioning (network, security group, etc.)',123,'boolean','checkbox','',0,'',0),('Self-Registration Settings','reCaptchaEnabled','FALSE','Enable Google reCAPTCHA',105,'boolean','checkbox','',0,'',0),('Self-Registration Settings','reCaptchaSecretKey','','Secret Key for reCAPTCHA verification',107,'string','','',0,'',0),('Self-Registration Settings','reCaptchaSiteKey','','Site Key for reCAPTCHA verification',106,'string','','',0,'',0),('Self-Registration Settings','selfRegImage','assets/images/register.png','Self Registration image',20,'string','url','',1,'',0),('Self-Registration Settings','termsAndConditions1Required','FALSE','Registrant is required to accept Terms and Conditions 1',80,'boolean','checkbox','',0,'',0),('Self-Registration Settings','termsAndConditions2Required','FALSE','Registrant is required to accept Terms and Conditions 2',100,'boolean','checkbox','',0,'',0),('Self-Registration Settings','termsAndConditionsText1','','Terms And Conditions Text 1',70,'string','html','',0,'',0),('Self-Registration Settings','termsAndConditionsText2','','Terms And Conditions Text 2',90,'string','html','',0,'',0),('UI Customization','allowProjectCreate','TRUE','Allow project create',89,'boolean','checkbox','',0,'',0),('UI Customization','appDisplayName','Openbook','Application display name',10,'string','','',1,'',0),('UI Customization','customerMenu','{\"version\":1,\"items\":[\n    {\"id\":\"dashboard\",\"index\":0,\"hidden\":false,\"visible\":true,\"title\":\"Dashboard\", \"description\":\"Dashboard with customizable widgets.\",\"imageSrc\":\"assets/images/Dashboard.png\",\"route\":\"/\"},\n    {\"id\":\"virtualMachines\",\"index\":1,\"hidden\":false,\"visible\":true,\"title\":\"Virtual Machines\", \"description\":\"View and manage virtual machines.\",\"imageSrc\":\"assets/images/Server.png\",\"route\":\"/viewVMs\"},\n    {\"id\":\"costEstimator\",\"index\":2,\"hidden\":false,\"visible\":true,\"title\":\"Cost Estimator\", \"description\":\"Estimate costs for products and services.\",\"imageSrc\":\"assets/images/Calculator.png\",\"route\":\"/costEstimator\"},\n    {\"id\":\"invoices\",\"index\":3,\"hidden\":false,\"visible\":true,\"title\":\"Invoices\", \"description\":\"View invoices for a customer.\",\"imageSrc\":\"assets/images/Invoice.png\",\"route\":\"/invoices\"},\n    {\"id\":\"currentCharges\",\"index\":4,\"hidden\":false,\"visible\":true,\"title\":\"Current Charges\", \"description\":\"View unbilled charges for a customer.\",\"imageSrc\":\"assets/images/Billing.png\",\"route\":\"/currentCharges\"},\n    {\"id\":\"spendOverTime\",\"index\":5,\"hidden\":false,\"visible\":true,\"title\":\"Spend Over Time\", \"description\":\"View billed charges over time.\", \"imageSrc\":\"assets/images/ComboChart.png\",\"route\":\"/spendOverTime\"},\n    {\"id\":\"consumptionTrends\",\"index\":6,\"hidden\":false,\"visible\":true,\"title\":\"Consumption Trends\", \"description\":\"View resource usage over time.\", \"imageSrc\":\"assets/images/AreaChart.png\",\"route\":\"/consumptionTrends\"},\n    {\"id\":\"quotaManagement\",\"index\":7,\"hidden\":false,\"visible\":true,\"title\":\"Quota Management\", \"description\":\"View and request changes to quotas.\", \"imageSrc\":\"assets/images/PieChart.png\",\"route\":\"/quotaManagement\"},\n    {\"id\":\"companyProfile\",\"index\":8,\"hidden\":false,\"visible\":true,\"title\":\"Company Profile\", \"description\":\"View and modify company profile information.\", \"imageSrc\":\"assets/images/Clipboard.png\",\"route\":\"/companyProfile\"},\n    {\"id\":\"userManagement\",\"index\":9,\"hidden\":false,\"visible\":true,\"title\":\"User Management\", \"description\":\"Manage user groups and roles.\", \"imageSrc\":\"assets/images/Users.png\",\"route\":\"/userManagement\"},\n    {\"id\":\"securityGroups\",\"index\":10,\"hidden\":true,\"visible\":true,\"title\":\"Security Groups\", \"description\":\"View and Manage security groups.\", \"imageSrc\":\"assets/images/CloudLock.svg\",\"route\":\"/securityGroups\"},\n    {\"id\":\"floatingIPs\",\"index\":11,\"hidden\":true,\"visible\":true,\"title\":\"Floating IPs\", \"description\":\"View and manage IP Address allocations.\", \"imageSrc\":\"assets/images/Cloud.svg\",\"route\":\"/floatingIPs\"},\n    {\"id\":\"volumes\",\"index\":12,\"hidden\":true,\"visible\":true,\"title\":\"Volumes\", \"description\":\"View and manage attached volumes.\", \"imageSrc\":\"assets/images/HDD.svg\",\"route\":\"/volumes\"}\n]}','Customer UI Menu Items',90,'string','menu','',0,'Customer UI menu items',0),('UI Customization','enableIdleTimeout','TRUE','Enable idle timeout',40,'boolean','checkbox','',1,'',0),('UI Customization','headerBGColor','#f8f8f8','Header background color',70,'string','color','',1,'',0),('UI Customization','headerFGColor','#3e8acc','Header foreground color',75,'string','color','',1,'',0),('UI Customization','idleTimeout','300','Override idle timeout (seconds)',41,'string','number','',0,'',0),('UI Customization','loginBG','assets/images/login-background.png','Login page background image',55,'string','','',1,'',0),('UI Customization','loginBGColor','#5DA5DA','Login page background color',55,'string','color','',1,'',0),('UI Customization','logoImage','assets/images/logo.svg','Logo image URL',20,'string','url','',1,'',0),('UI Customization','menuBGColor','#30416b','Menu background color',60,'string','color','',1,'',0),('UI Customization','menuFGColor','#D3D3D3','Menu foreground color',65,'string','color','',1,'',0),('UI Customization','overrideCSS','','Override CSS URL',30,'string','url','',0,'',0),('UI Customization','registrationBG','assets/images/login-background.png','Registration page background image',50,'string','','',1,'',0),('UI Customization','registrationBGColor','#5DA5DA','Registration page background color',50,'string','color','',1,'',0),('UI Customization','showEstimatedCostsVM','FALSE\n','Show estimated costs in VM create dialog',95,'boolean','checkbox','',0,'Boolean value that will show or hide estimated costs panel in create VM dialog',0),('UI Customization','showHeaderToolbar','TRUE','Show header toolbar',69,'boolean','checkbox','',1,'',0),('UI Customization','showQuotaAvailableVM','FALSE\n','Show quota available in VM create dialog',96,'boolean','checkbox','',0,NULL,0);
/*!40000 ALTER TABLE `t_properties_schema` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_provider`;
/*!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=3245 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_provider` WRITE;
/*!40000 ALTER TABLE `t_provider` DISABLE KEYS */;
INSERT INTO `t_provider` VALUES (1,'Root','RootProvider',NULL,0.0000,NULL,0.0000,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://127.0.0.1:8443','1',NULL,1,1,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `t_provider` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_provider_payment_processors`;
/*!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 */;

LOCK TABLES `t_provider_payment_processors` WRITE;
/*!40000 ALTER TABLE `t_provider_payment_processors` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_provider_payment_processors` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_provider_properties`;
/*!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 */;

LOCK TABLES `t_provider_properties` WRITE;
/*!40000 ALTER TABLE `t_provider_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_provider_properties` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_provider_region`;
/*!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 */;

LOCK TABLES `t_provider_region` WRITE;
/*!40000 ALTER TABLE `t_provider_region` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_provider_region` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_provider_service_manager`;
/*!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=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_provider_service_manager` WRITE;
/*!40000 ALTER TABLE `t_provider_service_manager` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_provider_service_manager` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_rate`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_rate` WRITE;
/*!40000 ALTER TABLE `t_rate` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_rate` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_rate_plan`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_rate_plan` WRITE;
/*!40000 ALTER TABLE `t_rate_plan` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_rate_plan` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_rate_plan_assignment`;
/*!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 */;

LOCK TABLES `t_rate_plan_assignment` WRITE;
/*!40000 ALTER TABLE `t_rate_plan_assignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_rate_plan_assignment` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_region`;
/*!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=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_region` WRITE;
/*!40000 ALTER TABLE `t_region` DISABLE KEYS */;
INSERT INTO `t_region` VALUES (1,'Root-Region','RootRegion',NULL);
/*!40000 ALTER TABLE `t_region` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_resource_event`;
/*!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 */;

LOCK TABLES `t_resource_event` WRITE;
/*!40000 ALTER TABLE `t_resource_event` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_resource_event` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_resource_group`;
/*!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 */;

LOCK TABLES `t_resource_group` WRITE;
/*!40000 ALTER TABLE `t_resource_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_resource_group` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service`;
/*!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=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_service` WRITE;
/*!40000 ALTER TABLE `t_service` DISABLE KEYS */;
INSERT INTO `t_service` VALUES (1,'Firewall','OpenStack Firewall',1,'In Existence',1),(2,'Floating IP','OpenStack Floating IP',1,'In Existence',1),(3,'Instance','OpenStack Instance',1,'In Existence,Powered On,In Use',1),(4,'Image','OpenStack Image',1,'In Existence',1),(5,'Load Balancer VIP','OpenStack Load Balancer VIP',1,'In Existence',1),(6,'Network','OpenStack Network',1,'In Existence',1),(7,'Port','OpenStack Port',1,'In Existence',1),(8,'Router','OpenStack Router',1,'In Existence',1),(9,'Snapshot','OpenStack Snapshot',1,'In Existence',1),(10,'Subnet','OpenStack Subnet',1,'In Existence',1),(11,'Volume','OpenStack Volume',1,'In Existence',1),(12,'Virtual Machine','VMware Virtual Machine',2,'In Existence,Powered On,In Use',1),(13,'Object Container','OpenStack Object Container',1,'In Existence',1);
/*!40000 ALTER TABLE `t_service` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_instance`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_service_instance` WRITE;
/*!40000 ALTER TABLE `t_service_instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_instance` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_instance_aggregates`;
/*!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,
  `customer_name` varchar(255) DEFAULT NULL,
  `tenant_id` int(10) unsigned NOT NULL,
  `tenant_name` varchar(255) DEFAULT NULL,
  `management_region_id` varchar(128) NOT NULL,
  `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 */;

LOCK TABLES `t_service_instance_aggregates` WRITE;
/*!40000 ALTER TABLE `t_service_instance_aggregates` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_instance_aggregates` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_instance_attributes`;
/*!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 */;

LOCK TABLES `t_service_instance_attributes` WRITE;
/*!40000 ALTER TABLE `t_service_instance_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_instance_attributes` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_instance_state`;
/*!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 */;

LOCK TABLES `t_service_instance_state` WRITE;
/*!40000 ALTER TABLE `t_service_instance_state` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_instance_state` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_manager`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_service_manager` WRITE;
/*!40000 ALTER TABLE `t_service_manager` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_manager` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_manager_properties`;
/*!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 */;

LOCK TABLES `t_service_manager_properties` WRITE;
/*!40000 ALTER TABLE `t_service_manager_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_manager_properties` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_manager_sync_metrics`;
/*!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 */;

LOCK TABLES `t_service_manager_sync_metrics` WRITE;
/*!40000 ALTER TABLE `t_service_manager_sync_metrics` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_service_manager_sync_metrics` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_service_manager_type`;
/*!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 */;

LOCK TABLES `t_service_manager_type` WRITE;
/*!40000 ALTER TABLE `t_service_manager_type` DISABLE KEYS */;
INSERT INTO `t_service_manager_type` VALUES (1,'OpenStack','OpenStack',1),(2,'VMware vCenter','VMware vCenter',1),(3,'AWS','AWS',1);
/*!40000 ALTER TABLE `t_service_manager_type` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_tenant`;
/*!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,
  `tenant_type_id` int(10) unsigned DEFAULT 1,
  KEY `ix_tenant_1` (`tenant_id`),
  KEY `ix_tenant_2` (`customer_id`),
  KEY `ix_tenant_3` (`service_manager_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_tenant` WRITE;
/*!40000 ALTER TABLE `t_tenant` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_tenant` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_tenant_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_tenant_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `description` varchar(256) DEFAULT NULL,
  KEY `ix_tenant_1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_tenant_type` WRITE;
/*!40000 ALTER TABLE `t_tenant_type` DISABLE KEYS */;
INSERT INTO `t_tenant_type` VALUES (1,'default','Default project properties');
/*!40000 ALTER TABLE `t_tenant_type` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_tenant_type_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_tenant_type_properties` (
  `tenant_type_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 (`tenant_type_id`,`property_group`,`property_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_tenant_type_properties` WRITE;
/*!40000 ALTER TABLE `t_tenant_type_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_tenant_type_properties` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_unbilled_charges`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_unbilled_charges` WRITE;
/*!40000 ALTER TABLE `t_unbilled_charges` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_unbilled_charges` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_unbilled_charges_detail`;
/*!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 */;

LOCK TABLES `t_unbilled_charges_detail` WRITE;
/*!40000 ALTER TABLE `t_unbilled_charges_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_unbilled_charges_detail` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_unbilled_charges_detail_temp`;
/*!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 */;

LOCK TABLES `t_unbilled_charges_detail_temp` WRITE;
/*!40000 ALTER TABLE `t_unbilled_charges_detail_temp` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_unbilled_charges_detail_temp` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_unbilled_charges_temp`;
/*!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 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_unbilled_charges_temp` WRITE;
/*!40000 ALTER TABLE `t_unbilled_charges_temp` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_unbilled_charges_temp` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_user_permissions`;
/*!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 */;

LOCK TABLES `t_user_permissions` WRITE;
/*!40000 ALTER TABLE `t_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_user_projects`;
/*!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 */;

LOCK TABLES `t_user_projects` WRITE;
/*!40000 ALTER TABLE `t_user_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_user_projects` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_user_roles`;
/*!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 */;

LOCK TABLES `t_user_roles` WRITE;
/*!40000 ALTER TABLE `t_user_roles` DISABLE KEYS */;
INSERT INTO `t_user_roles` VALUES (1,'RegionAdmin',1,'ManagementRegion');
/*!40000 ALTER TABLE `t_user_roles` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `t_users`;
/*!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=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `t_users` WRITE;
/*!40000 ALTER TABLE `t_users` DISABLE KEYS */;
INSERT INTO `t_users` VALUES (1,'openbook','Openbook','Admin',NULL,NULL,'$shiro1$SHA-256$500000$TjQG1Qm6tv1XKvm0IbTK1A==$r3GU6Nr4Mh88aQ/UP7CimwOGAJvu0MsP1tkAIYXsoLw=',1,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `t_users` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `v_all_charges`;
/*!50001 DROP VIEW IF EXISTS `v_all_charges`*/;
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;
DROP TABLE IF EXISTS `v_all_charges_detail`;
/*!50001 DROP VIEW IF EXISTS `v_all_charges_detail`*/;
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;
DROP TABLE IF EXISTS `v_current_host`;
/*!50001 DROP VIEW IF EXISTS `v_current_host`*/;
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;
DROP TABLE IF EXISTS `v_current_host_attributes`;
/*!50001 DROP VIEW IF EXISTS `v_current_host_attributes`*/;
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;
DROP TABLE IF EXISTS `v_customer`;
/*!50001 DROP VIEW IF EXISTS `v_customer`*/;
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;
DROP TABLE IF EXISTS `v_metric`;
/*!50001 DROP VIEW IF EXISTS `v_metric`*/;
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;
DROP TABLE IF EXISTS `v_promo_code_redemption`;
/*!50001 DROP VIEW IF EXISTS `v_promo_code_redemption`*/;
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;
DROP TABLE IF EXISTS `v_provider`;
/*!50001 DROP VIEW IF EXISTS `v_provider`*/;
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;
DROP TABLE IF EXISTS `v_rate_plan_assignment`;
/*!50001 DROP VIEW IF EXISTS `v_rate_plan_assignment`*/;
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;
DROP TABLE IF EXISTS `v_service`;
/*!50001 DROP VIEW IF EXISTS `v_service`*/;
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;
DROP TABLE IF EXISTS `v_service_instance`;
/*!50001 DROP VIEW IF EXISTS `v_service_instance`*/;
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;
DROP TABLE IF EXISTS `v_service_instance_attributes`;
/*!50001 DROP VIEW IF EXISTS `v_service_instance_attributes`*/;
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;
DROP TABLE IF EXISTS `v_service_instance_state`;
/*!50001 DROP VIEW IF EXISTS `v_service_instance_state`*/;
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;
DROP TABLE IF EXISTS `v_service_manager`;
/*!50001 DROP VIEW IF EXISTS `v_service_manager`*/;
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;
DROP TABLE IF EXISTS `v_tenant`;
/*!50001 DROP VIEW IF EXISTS `v_tenant`*/;
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,
  `tenant_type` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `v_users`;
/*!50001 DROP VIEW IF EXISTS `v_users`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_users` (
  `user_id` tinyint NOT NULL,
  `username` tinyint NOT NULL,
  `first_name` tinyint NOT NULL,
  `last_name` tinyint NOT NULL,
  `email_address` tinyint NOT NULL,
  `phone_number` tinyint NOT NULL,
  `password` tinyint NOT NULL,
  `is_active` tinyint NOT NULL,
  `password_change_token` tinyint NOT NULL,
  `last_password_change_date` tinyint NOT NULL,
  `password_change_token_expire_date` tinyint NOT NULL,
  `role_name` tinyint NOT NULL,
  `role_context` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
/*!50003 DROP PROCEDURE IF EXISTS `p_preallocate_partitions` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `p_preallocate_partitions`(IN tableName VARCHAR(255), IN columnName VARCHAR(255), IN beginDate DATETIME, IN numDays INT)
BEGIN
    DECLARE partitionDay, endDay INT;
    DECLARE partitionName VARCHAR(255);
    DECLARE partitionList VARCHAR(5000);

    SET partitionDay = (SELECT (TO_DAYS(beginDate + INTERVAL 1 DAY)));
    SET endDay = partitionDay + numDays;
    SET partitionList = "";
    WHILE partitionDay <= endDay DO
      SET partitionName = CONCAT("p", partitionDay);
      SET partitionList = CONCAT(partitionList, 'PARTITION ', partitionName, ' VALUES LESS THAN(', partitionDay, ')');
      IF partitionDay < endDay THEN
        SET partitionList = CONCAT(partitionList, ',');
      END IF;
      SET partitionDay = partitionDay + 1;
    END WHILE;
    SET @stmt = CONCAT('ALTER TABLE ', tableName, ' PARTITION BY RANGE (TO_DAYS(', columnName, ')) (', partitionList, ')');
    PREPARE pStmt FROM @stmt;
    EXECUTE pStmt;
    DEALLOCATE PREPARE pStmt;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

/*!40000 DROP DATABASE IF EXISTS `openbook_jobs`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */;

GRANT ALL PRIVILEGES ON openbook_jobs.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
GRANT ALL PRIVILEGES ON openbook_jobs.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
FLUSH PRIVILEGES;

USE `openbook_jobs`;
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_BLOB_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_BLOB_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_BLOB_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
/*!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 */;

LOCK TABLES `QRTZ_CALENDARS` WRITE;
/*!40000 ALTER TABLE `QRTZ_CALENDARS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_CALENDARS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_CRON_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_CRON_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_CRON_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_FIRED_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_FIRED_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_FIRED_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
/*!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 */;

LOCK TABLES `QRTZ_JOB_DETAILS` WRITE;
/*!40000 ALTER TABLE `QRTZ_JOB_DETAILS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_JOB_DETAILS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
/*!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 */;

LOCK TABLES `QRTZ_LOCKS` WRITE;
/*!40000 ALTER TABLE `QRTZ_LOCKS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_LOCKS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
/*!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 */;

LOCK TABLES `QRTZ_PAUSED_TRIGGER_GRPS` WRITE;
/*!40000 ALTER TABLE `QRTZ_PAUSED_TRIGGER_GRPS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_PAUSED_TRIGGER_GRPS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
/*!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 */;

LOCK TABLES `QRTZ_SCHEDULER_STATE` WRITE;
/*!40000 ALTER TABLE `QRTZ_SCHEDULER_STATE` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_SCHEDULER_STATE` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_SIMPLE_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_SIMPLE_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_SIMPLE_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_SIMPROP_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_SIMPROP_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_SIMPROP_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
/*!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 */;

LOCK TABLES `QRTZ_TRIGGERS` WRITE;
/*!40000 ALTER TABLE `QRTZ_TRIGGERS` DISABLE KEYS */;
/*!40000 ALTER TABLE `QRTZ_TRIGGERS` ENABLE KEYS */;
UNLOCK TABLES;

/*!40000 DROP DATABASE IF EXISTS `openbook_workflow`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_workflow` /*!40100 DEFAULT CHARACTER SET utf8 */;

GRANT ALL PRIVILEGES ON openbook_workflow.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
GRANT ALL PRIVILEGES ON openbook_workflow.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
FLUSH PRIVILEGES;

USE `openbook_workflow`;
DROP TABLE IF EXISTS `ACT_EVT_LOG`;
/*!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 */;

LOCK TABLES `ACT_EVT_LOG` WRITE;
/*!40000 ALTER TABLE `ACT_EVT_LOG` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_EVT_LOG` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`;
/*!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 */;

LOCK TABLES `ACT_GE_BYTEARRAY` WRITE;
/*!40000 ALTER TABLE `ACT_GE_BYTEARRAY` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_GE_BYTEARRAY` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_GE_PROPERTY`;
/*!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 */;

LOCK TABLES `ACT_GE_PROPERTY` WRITE;
/*!40000 ALTER TABLE `ACT_GE_PROPERTY` DISABLE KEYS */;
INSERT INTO `ACT_GE_PROPERTY` VALUES ('next.dbid','1',1),('schema.history','create(5.20.0.1)',1),('schema.version','5.20.0.1',1);
/*!40000 ALTER TABLE `ACT_GE_PROPERTY` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_ACTINST`;
/*!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 */;

LOCK TABLES `ACT_HI_ACTINST` WRITE;
/*!40000 ALTER TABLE `ACT_HI_ACTINST` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_ACTINST` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`;
/*!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 */;

LOCK TABLES `ACT_HI_ATTACHMENT` WRITE;
/*!40000 ALTER TABLE `ACT_HI_ATTACHMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_ATTACHMENT` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_COMMENT`;
/*!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 */;

LOCK TABLES `ACT_HI_COMMENT` WRITE;
/*!40000 ALTER TABLE `ACT_HI_COMMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_COMMENT` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_DETAIL`;
/*!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 */;

LOCK TABLES `ACT_HI_DETAIL` WRITE;
/*!40000 ALTER TABLE `ACT_HI_DETAIL` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_DETAIL` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`;
/*!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 */;

LOCK TABLES `ACT_HI_IDENTITYLINK` WRITE;
/*!40000 ALTER TABLE `ACT_HI_IDENTITYLINK` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_IDENTITYLINK` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_PROCINST`;
/*!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 */;

LOCK TABLES `ACT_HI_PROCINST` WRITE;
/*!40000 ALTER TABLE `ACT_HI_PROCINST` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_PROCINST` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
/*!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 */;

LOCK TABLES `ACT_HI_TASKINST` WRITE;
/*!40000 ALTER TABLE `ACT_HI_TASKINST` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_TASKINST` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_HI_VARINST`;
/*!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 */;

LOCK TABLES `ACT_HI_VARINST` WRITE;
/*!40000 ALTER TABLE `ACT_HI_VARINST` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_HI_VARINST` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_ID_GROUP`;
/*!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 */;

LOCK TABLES `ACT_ID_GROUP` WRITE;
/*!40000 ALTER TABLE `ACT_ID_GROUP` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_ID_GROUP` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_ID_INFO`;
/*!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 */;

LOCK TABLES `ACT_ID_INFO` WRITE;
/*!40000 ALTER TABLE `ACT_ID_INFO` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_ID_INFO` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`;
/*!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 */;

LOCK TABLES `ACT_ID_MEMBERSHIP` WRITE;
/*!40000 ALTER TABLE `ACT_ID_MEMBERSHIP` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_ID_MEMBERSHIP` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_ID_USER`;
/*!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 */;

LOCK TABLES `ACT_ID_USER` WRITE;
/*!40000 ALTER TABLE `ACT_ID_USER` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_ID_USER` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`;
/*!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 */;

LOCK TABLES `ACT_PROCDEF_INFO` WRITE;
/*!40000 ALTER TABLE `ACT_PROCDEF_INFO` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_PROCDEF_INFO` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`;
/*!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 */;

LOCK TABLES `ACT_RE_DEPLOYMENT` WRITE;
/*!40000 ALTER TABLE `ACT_RE_DEPLOYMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RE_DEPLOYMENT` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RE_MODEL`;
/*!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 */;

LOCK TABLES `ACT_RE_MODEL` WRITE;
/*!40000 ALTER TABLE `ACT_RE_MODEL` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RE_MODEL` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RE_PROCDEF`;
/*!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 */;

LOCK TABLES `ACT_RE_PROCDEF` WRITE;
/*!40000 ALTER TABLE `ACT_RE_PROCDEF` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RE_PROCDEF` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`;
/*!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 */;

LOCK TABLES `ACT_RU_EVENT_SUBSCR` WRITE;
/*!40000 ALTER TABLE `ACT_RU_EVENT_SUBSCR` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_EVENT_SUBSCR` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_EXECUTION`;
/*!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 */;

LOCK TABLES `ACT_RU_EXECUTION` WRITE;
/*!40000 ALTER TABLE `ACT_RU_EXECUTION` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_EXECUTION` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`;
/*!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 */;

LOCK TABLES `ACT_RU_IDENTITYLINK` WRITE;
/*!40000 ALTER TABLE `ACT_RU_IDENTITYLINK` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_IDENTITYLINK` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_JOB`;
/*!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 */;

LOCK TABLES `ACT_RU_JOB` WRITE;
/*!40000 ALTER TABLE `ACT_RU_JOB` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_JOB` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_TASK`;
/*!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 */;

LOCK TABLES `ACT_RU_TASK` WRITE;
/*!40000 ALTER TABLE `ACT_RU_TASK` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_TASK` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `ACT_RU_VARIABLE`;
/*!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 */;

LOCK TABLES `ACT_RU_VARIABLE` WRITE;
/*!40000 ALTER TABLE `ACT_RU_VARIABLE` DISABLE KEYS */;
/*!40000 ALTER TABLE `ACT_RU_VARIABLE` ENABLE KEYS */;
UNLOCK TABLES;

USE `openbook`;
/*!50001 DROP TABLE IF EXISTS `v_all_charges`*/;
/*!50001 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`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 DROP VIEW 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=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_tenant` AS select `t`.`tenant_id` AS `tenant_id`,`t`.`tenant_name` AS `tenant_name`,`t`.`tenant_foreign_id` AS `tenant_foreign_id`,`t`.`create_date` AS `create_date`,`t`.`deactivate_date` AS `deactivate_date`,`t`.`customer_id` AS `customer_id`,`t`.`service_manager_id` AS `service_manager_id`,`t`.`is_active` AS `is_active`,`c`.`customer_name` AS `customer_name`,`c`.`management_region_id` AS `management_region_id`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tt`.`name` AS `tenant_type` from ((((`t_tenant` `t` left join `t_customer` `c` on(`t`.`customer_id` = `c`.`customer_id`)) left join `t_service_manager` `tsm` on(`t`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant_type` `tt` on(`t`.`tenant_type_id` = `tt`.`id`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!50001 DROP TABLE IF EXISTS `v_users`*/;
/*!50001 DROP VIEW 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 */;

USE `openbook_jobs`;

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 */;