/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

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

USE `openbook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DATABASECHANGELOG` (
  `ID` varchar(63) NOT NULL,
  `AUTHOR` varchar(63) NOT NULL,
  `FILENAME` varchar(200) NOT NULL,
  `DATEEXECUTED` datetime NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) NOT NULL,
  `MD5SUM` varchar(35) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `COMMENTS` varchar(255) DEFAULT NULL,
  `TAG` varchar(255) DEFAULT NULL,
  `LIQUIBASE` varchar(20) DEFAULT NULL,
  `CONTEXTS` varchar(255) DEFAULT NULL,
  `LABELS` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`,`AUTHOR`,`FILENAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DATABASECHANGELOGLOCK` (
  `ID` int(11) NOT NULL,
  `LOCKED` tinyint(1) NOT NULL,
  `LOCKGRANTED` datetime DEFAULT NULL,
  `LOCKEDBY` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_adhoc_charge` (
  `charge_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `posted_date` datetime(6) NOT NULL,
  `product_name` varchar(64) NOT NULL,
  `invoice_group` varchar(64) NOT NULL,
  `quantity` decimal(36,12) DEFAULT NULL,
  `quantity_units` varchar(128) DEFAULT NULL,
  `rate` decimal(22,12) DEFAULT NULL,
  `charge` decimal(19,2) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `item_detail` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`charge_id`),
  KEY `ix_adhoc_charge_1` (`payer_id`,`payer_type`,`posted_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_app_config` (
  `property_group` varchar(128) NOT NULL,
  `property_name` varchar(128) NOT NULL,
  `property_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_audit_event` (
  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `event_time` datetime(6) NOT NULL,
  `event_type` varchar(32) NOT NULL,
  `entity_id` varchar(64) NOT NULL,
  `entity_name` varchar(255) DEFAULT NULL,
  `entity_type` varchar(45) NOT NULL,
  `user_id` varchar(128) DEFAULT NULL,
  `event_data` longtext DEFAULT NULL,
  PRIMARY KEY (`event_id`),
  KEY `ix_audit_event_1` (`event_time`,`event_type`,`entity_id`),
  KEY `ix_audit_event_2` (`user_id`,`event_time`)
) ENGINE=InnoDB AUTO_INCREMENT=2249 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_aws_raw_charges` (
  `identity_LineItemId` varchar(64) DEFAULT NULL,
  `sync_timestamp` datetime DEFAULT NULL,
  `bill_InvoiceId` varchar(64) DEFAULT NULL,
  `bill_BillingEntity` varchar(64) DEFAULT NULL,
  `bill_BillType` varchar(64) DEFAULT NULL,
  `bill_PayerAccountId` varchar(64) DEFAULT NULL,
  `bill_BillingPeriodStartDate` varchar(64) DEFAULT NULL,
  `bill_BillingPeriodEndDate` varchar(64) DEFAULT NULL,
  `lineItem_UsageAccountId` varchar(64) DEFAULT NULL,
  `lineItem_LineItemType` varchar(64) DEFAULT NULL,
  `lineItem_UsageStartDate` varchar(64) DEFAULT NULL,
  `lineItem_UsageEndDate` varchar(64) DEFAULT NULL,
  `lineItem_ProductCode` varchar(64) DEFAULT NULL,
  `lineItem_UsageType` varchar(64) DEFAULT NULL,
  `lineItem_Operation` varchar(64) DEFAULT NULL,
  `lineItem_AvailabilityZone` varchar(64) DEFAULT NULL,
  `lineItem_ResourceId` varchar(64) DEFAULT NULL,
  `lineItem_UsageAmount` decimal(22,12) DEFAULT NULL,
  `lineItem_CurrencyCode` varchar(64) DEFAULT NULL,
  `lineItem_UnblendedRate` decimal(22,12) DEFAULT NULL,
  `lineItem_UnblendedCost` decimal(22,12) DEFAULT NULL,
  `lineItem_BlendedRate` decimal(22,12) DEFAULT NULL,
  `lineItem_BlendedCost` decimal(22,12) DEFAULT NULL,
  `lineItem_LineItemDescription` varchar(256) DEFAULT NULL,
  `lineItem_TaxType` varchar(64) DEFAULT NULL,
  `product_ProductName` varchar(64) DEFAULT NULL,
  `product_availability` varchar(64) DEFAULT NULL,
  `product_clockSpeed` varchar(64) DEFAULT NULL,
  `product_durability` varchar(64) DEFAULT NULL,
  `product_fromLocation` varchar(64) DEFAULT NULL,
  `product_fromLocationType` varchar(64) DEFAULT NULL,
  `product_group` varchar(64) DEFAULT NULL,
  `product_groupDescription` varchar(64) DEFAULT NULL,
  `product_instanceFamily` varchar(64) DEFAULT NULL,
  `product_instanceType` varchar(64) DEFAULT NULL,
  `product_licenseModel` varchar(64) DEFAULT NULL,
  `product_location` varchar(64) DEFAULT NULL,
  `product_locationType` varchar(64) DEFAULT NULL,
  `product_maxIopsBurstPerformance` varchar(64) DEFAULT NULL,
  `product_maxIopsvolume` varchar(64) DEFAULT NULL,
  `product_maxThroughputvolume` varchar(64) DEFAULT NULL,
  `product_maxVolumeSize` varchar(64) DEFAULT NULL,
  `product_memory` varchar(64) DEFAULT NULL,
  `product_networkPerformance` varchar(64) DEFAULT NULL,
  `product_operatingSystem` varchar(64) DEFAULT NULL,
  `product_operation` varchar(64) DEFAULT NULL,
  `product_physicalProcessor` varchar(64) DEFAULT NULL,
  `product_preInstalledSw` varchar(64) DEFAULT NULL,
  `product_processorArchitecture` varchar(64) DEFAULT NULL,
  `product_processorFeatures` varchar(64) DEFAULT NULL,
  `product_productFamily` varchar(64) DEFAULT NULL,
  `product_servicecode` varchar(64) DEFAULT NULL,
  `product_sku` varchar(64) DEFAULT NULL,
  `product_storage` varchar(64) DEFAULT NULL,
  `product_storageClass` varchar(64) DEFAULT NULL,
  `product_storageMedia` varchar(64) DEFAULT NULL,
  `product_tenancy` varchar(64) DEFAULT NULL,
  `product_toLocation` varchar(64) DEFAULT NULL,
  `product_toLocationType` varchar(64) DEFAULT NULL,
  `product_transferType` varchar(64) DEFAULT NULL,
  `product_usagetype` varchar(64) DEFAULT NULL,
  `product_vcpu` varchar(64) DEFAULT NULL,
  `product_volumeType` varchar(64) DEFAULT NULL,
  `pricing_term` varchar(64) DEFAULT NULL,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) DEFAULT 'Customer',
  `tenant_name` varchar(64) DEFAULT NULL,
  `tags` text DEFAULT NULL,
  UNIQUE KEY `aws_id` (`lineItem_ResourceId`,`lineItem_UsageType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_aws_raw_data` (
  `identity_LineItemId` varchar(64) DEFAULT NULL,
  `sync_timestamp` datetime DEFAULT NULL,
  `bill_InvoiceId` varchar(64) DEFAULT NULL,
  `bill_BillingEntity` varchar(64) DEFAULT NULL,
  `bill_BillType` varchar(64) DEFAULT NULL,
  `bill_PayerAccountId` varchar(64) DEFAULT NULL,
  `bill_BillingPeriodStartDate` varchar(64) DEFAULT NULL,
  `bill_BillingPeriodEndDate` varchar(64) DEFAULT NULL,
  `lineItem_UsageAccountId` varchar(64) DEFAULT NULL,
  `lineItem_LineItemType` varchar(64) DEFAULT NULL,
  `lineItem_UsageStartDate` varchar(64) DEFAULT NULL,
  `lineItem_UsageEndDate` varchar(64) DEFAULT NULL,
  `lineItem_ProductCode` varchar(64) DEFAULT NULL,
  `lineItem_UsageType` varchar(64) DEFAULT NULL,
  `lineItem_Operation` varchar(64) DEFAULT NULL,
  `lineItem_AvailabilityZone` varchar(64) DEFAULT NULL,
  `lineItem_ResourceId` varchar(64) DEFAULT NULL,
  `lineItem_UsageAmount` decimal(22,12) DEFAULT NULL,
  `lineItem_CurrencyCode` varchar(64) DEFAULT NULL,
  `lineItem_UnblendedRate` decimal(22,12) DEFAULT NULL,
  `lineItem_UnblendedCost` decimal(22,12) DEFAULT NULL,
  `lineItem_BlendedRate` decimal(22,12) DEFAULT NULL,
  `lineItem_BlendedCost` decimal(22,12) DEFAULT NULL,
  `lineItem_LineItemDescription` varchar(256) DEFAULT NULL,
  `lineItem_TaxType` varchar(64) DEFAULT NULL,
  `product_ProductName` varchar(64) DEFAULT NULL,
  `product_availability` varchar(64) DEFAULT NULL,
  `product_clockSpeed` varchar(64) DEFAULT NULL,
  `product_durability` varchar(64) DEFAULT NULL,
  `product_fromLocation` varchar(64) DEFAULT NULL,
  `product_fromLocationType` varchar(64) DEFAULT NULL,
  `product_group` varchar(64) DEFAULT NULL,
  `product_groupDescription` varchar(64) DEFAULT NULL,
  `product_instanceFamily` varchar(64) DEFAULT NULL,
  `product_instanceType` varchar(64) DEFAULT NULL,
  `product_licenseModel` varchar(64) DEFAULT NULL,
  `product_location` varchar(64) DEFAULT NULL,
  `product_locationType` varchar(64) DEFAULT NULL,
  `product_maxIopsBurstPerformance` varchar(64) DEFAULT NULL,
  `product_maxIopsvolume` varchar(64) DEFAULT NULL,
  `product_maxThroughputvolume` varchar(64) DEFAULT NULL,
  `product_maxVolumeSize` varchar(64) DEFAULT NULL,
  `product_memory` varchar(64) DEFAULT NULL,
  `product_networkPerformance` varchar(64) DEFAULT NULL,
  `product_operatingSystem` varchar(64) DEFAULT NULL,
  `product_operation` varchar(64) DEFAULT NULL,
  `product_physicalProcessor` varchar(64) DEFAULT NULL,
  `product_preInstalledSw` varchar(64) DEFAULT NULL,
  `product_processorArchitecture` varchar(64) DEFAULT NULL,
  `product_processorFeatures` varchar(64) DEFAULT NULL,
  `product_productFamily` varchar(64) DEFAULT NULL,
  `product_servicecode` varchar(64) DEFAULT NULL,
  `product_sku` varchar(64) DEFAULT NULL,
  `product_storage` varchar(64) DEFAULT NULL,
  `product_storageClass` varchar(64) DEFAULT NULL,
  `product_storageMedia` varchar(64) DEFAULT NULL,
  `product_tenancy` varchar(64) DEFAULT NULL,
  `product_toLocation` varchar(64) DEFAULT NULL,
  `product_toLocationType` varchar(64) DEFAULT NULL,
  `product_transferType` varchar(64) DEFAULT NULL,
  `product_usagetype` varchar(64) DEFAULT NULL,
  `product_vcpu` varchar(64) DEFAULT NULL,
  `product_volumeType` varchar(64) DEFAULT NULL,
  `pricing_term` varchar(64) DEFAULT NULL,
  `tags` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_credit` (
  `credit_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `credit_amount` decimal(19,2) DEFAULT NULL,
  `remaining_amount` decimal(19,2) DEFAULT NULL,
  `credit_type` varchar(16) NOT NULL,
  `granted_by` varchar(256) NOT NULL,
  `posted_date` datetime(6) NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `memo` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`credit_id`),
  KEY `ix_credit_1` (`payer_id`,`payer_type`,`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_customer` (
  `customer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(512) NOT NULL,
  `created_via` varchar(128) DEFAULT NULL,
  `metadata` text DEFAULT NULL,
  `tax_rate` decimal(18,4) DEFAULT 0.0000,
  `currency` char(6) DEFAULT NULL,
  `discount_percent` decimal(18,4) DEFAULT 0.0000,
  `billing_frequency` varchar(40) DEFAULT NULL,
  `last_bill_date` datetime(6) DEFAULT NULL,
  `next_bill_date` datetime(6) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `create_date` datetime(6) DEFAULT NULL,
  `activate_date` datetime(6) DEFAULT NULL,
  `billing_start_date` datetime(6) DEFAULT NULL,
  `last_payment_date` datetime(6) DEFAULT NULL,
  `deactivate_date` datetime(6) DEFAULT NULL,
  `description` varchar(5120) DEFAULT NULL,
  `minimum_invoice_commitment` decimal(19,2) DEFAULT NULL,
  `invoicing_method` varchar(32) NOT NULL,
  `management_region_id` varchar(64) DEFAULT NULL,
  `billing_address_line_1` varchar(512) DEFAULT NULL,
  `billing_address_line_2` varchar(512) DEFAULT NULL,
  `billing_address_city` varchar(512) DEFAULT NULL,
  `billing_address_region` varchar(128) DEFAULT NULL,
  `billing_address_country` varchar(2) DEFAULT NULL,
  `billing_address_postal_code` varchar(64) DEFAULT NULL,
  `payer_payment_details` varchar(5120) DEFAULT '{"PaymentMethod":"None"}',
  `payment_method_confirmed` tinyint(1) DEFAULT 0,
  `balance_due` decimal(19,2) DEFAULT NULL,
  `spend_soft_limit` decimal(12,2) DEFAULT NULL,
  `spend_hard_limit` decimal(12,2) DEFAULT NULL,
  `terms_and_conditions_2_accept_date` datetime(6) DEFAULT NULL,
  `tax_id` varchar(128) DEFAULT NULL,
  `registration_number` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `ix_customer_3` (`management_region_id`,`customer_name`(255))
) ENGINE=InnoDB AUTO_INCREMENT=315853 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_discount` (
  `discount_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `discount_percent` decimal(5,2) NOT NULL,
  `granted_by` varchar(256) NOT NULL,
  `apply_to_charge_category` varchar(32) DEFAULT NULL,
  `trigger_charge_category` varchar(32) DEFAULT NULL,
  `trigger_amount` decimal(19,2) DEFAULT NULL,
  `start_date` datetime(6) NOT NULL,
  `end_date` datetime(6) NOT NULL,
  PRIMARY KEY (`discount_id`),
  KEY `ix_discount_1` (`payer_id`,`payer_type`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_email_notification` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `recipient` varchar(128) NOT NULL,
  `sender` varchar(128) NOT NULL,
  `subject` varchar(256) NOT NULL,
  `message_text` longtext NOT NULL,
  `smtp_server_details` longtext NOT NULL,
  `date_generated` datetime(6) NOT NULL,
  `date_sent` datetime(6) DEFAULT NULL,
  `date_last_send_attempt` datetime(6) DEFAULT NULL,
  `send_status` varchar(16) DEFAULT NULL,
  `send_status_detail` varchar(5120) DEFAULT NULL,
  `send_attempt_count` smallint(6) DEFAULT NULL,
  `payer_id` int(10) unsigned DEFAULT NULL,
  `payer_type` varchar(64) DEFAULT NULL,
  `message_type` varchar(128) NOT NULL,
  PRIMARY KEY (`message_id`),
  KEY `ix_email_notification_1` (`recipient`,`date_generated`),
  KEY `ix_email_notification_2` (`sender`,`date_generated`),
  KEY `ix_email_notification_3` (`date_sent`),
  KEY `ix_email_notification_4` (`payer_id`,`payer_type`,`message_type`,`date_sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_email_template` (
  `provider_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `template_subject` varchar(256) NOT NULL,
  `template_name` varchar(128) NOT NULL,
  `template_text` longtext NOT NULL,
  PRIMARY KEY (`provider_id`,`template_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_entity_attribute` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_class` varchar(32) NOT NULL,
  `attribute_category` varchar(128) NOT NULL,
  `attribute_name` varchar(128) NOT NULL,
  `attribute_value` varchar(512) NOT NULL,
  `attribute_unit` varchar(64) DEFAULT NULL,
  `add_date` datetime(6) DEFAULT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`entity_id`,`expire_date`,`attribute_class`,`attribute_category`,`attribute_name`),
  KEY `ix_entity_attribute_1` (`attribute_class`),
  KEY `ix_entity_attribute_2` (`attribute_category`),
  KEY `ix_entity_attribute_3` (`attribute_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_exception_event` (
  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `event_time` datetime(6) NOT NULL,
  `event_type` varchar(32) NOT NULL,
  `entity_id` varchar(64) NOT NULL,
  `entity_name` varchar(255) DEFAULT NULL,
  `entity_type` varchar(45) NOT NULL,
  `user_id` varchar(128) DEFAULT NULL,
  `event_data` longtext DEFAULT NULL,
  PRIMARY KEY (`event_id`),
  KEY `ix_exception_event_1` (`event_time`,`event_type`,`entity_id`),
  KEY `ix_exception_event_2` (`user_id`,`event_time`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_gcp_raw_charges` (
  `accountId` varchar(128) DEFAULT NULL,
  `amount` decimal(22,12) DEFAULT NULL,
  `cost` varchar(64) DEFAULT NULL,
  `creditId` varchar(64) DEFAULT NULL,
  `credits` varchar(64) DEFAULT NULL,
  `currency` varchar(64) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `endTime` varchar(64) DEFAULT NULL,
  `lineItemId` varchar(255) DEFAULT NULL,
  `measurementId` varchar(64) DEFAULT NULL,
  `measurements` varchar(64) DEFAULT NULL,
  `projectId` varchar(64) DEFAULT NULL,
  `projectName` varchar(64) DEFAULT NULL,
  `projectNumber` varchar(64) DEFAULT NULL,
  `startTime` varchar(64) DEFAULT NULL,
  `sum` bigint(20) DEFAULT NULL,
  `unit` varchar(64) DEFAULT NULL,
  `payer_id` int(10) unsigned DEFAULT 0,
  `payer_type` varchar(64) DEFAULT 'Customer',
  `tenant_name` varchar(64) DEFAULT NULL,
  `tags` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_host` (
  `host_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_manager_id` int(10) unsigned NOT NULL,
  `service_region_id` int(10) unsigned NOT NULL,
  `host_foreign_id` varchar(256) DEFAULT NULL,
  `host_name` varchar(256) NOT NULL,
  `hypervisor_type` varchar(64) DEFAULT NULL,
  `add_date` datetime(6) NOT NULL,
  `remove_date` datetime(6) NOT NULL,
  `cpu_allocation_ratio` decimal(6,2) DEFAULT NULL,
  `ram_allocation_ratio` decimal(6,2) DEFAULT NULL,
  `host_aggregate` varchar(255) DEFAULT NULL,
  `disk_allocation_ratio` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`host_id`),
  KEY `ix_host_1` (`service_manager_id`,`service_region_id`,`host_foreign_id`(255))
) ENGINE=InnoDB AUTO_INCREMENT=2090 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_host_attributes` (
  `host_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `update_date` datetime(6) NOT NULL,
  `ram_mb` int(11) NOT NULL,
  `ram_mb_used` int(11) NOT NULL,
  `disk_gb` int(11) NOT NULL,
  `disk_gb_used` int(11) NOT NULL,
  `vcpus` int(11) NOT NULL,
  `vcpus_used` int(11) NOT NULL,
  `vm_count` int(11) NOT NULL,
  `socket_count` int(11) NOT NULL,
  PRIMARY KEY (`host_id`,`update_date`)
) ENGINE=InnoDB AUTO_INCREMENT=2090 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_invoice` (
  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `payer_name` varchar(512) NOT NULL,
  `invoice_number` varchar(45) DEFAULT NULL,
  `invoice_date` datetime(6) NOT NULL,
  `period_begin` datetime(6) NOT NULL,
  `period_end` datetime(6) NOT NULL,
  `invoice_amount` decimal(19,2) NOT NULL,
  `actual_charges` decimal(19,2) NOT NULL,
  `invoice_currency` varchar(16) DEFAULT NULL,
  `management_region_id` int(10) unsigned NOT NULL,
  `balance_due` decimal(19,2) NOT NULL,
  `invoice_pdf` longblob DEFAULT NULL,
  `payment_processing` tinyint(1) DEFAULT 0,
  `payer_metadata` text DEFAULT NULL,
  PRIMARY KEY (`invoice_id`),
  KEY `ix_invoice_1` (`management_region_id`,`payer_type`,`payer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12487308 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_invoice_detail` (
  `invoice_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `service_region_id` int(10) unsigned DEFAULT NULL,
  `service_region_name` varchar(128) DEFAULT NULL,
  `rate` decimal(22,12) NOT NULL,
  `rate_display` varchar(255) DEFAULT NULL,
  `rate_unit` varchar(128) NOT NULL,
  `rate_interval` varchar(128) DEFAULT NULL,
  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
  `units_billed` decimal(36,12) DEFAULT NULL,
  `units_billed_display` varchar(128) DEFAULT NULL,
  `item_invoice_amount` decimal(19,2) NOT NULL,
  `item_category` varchar(128) NOT NULL,
  `item_group` varchar(128) NOT NULL,
  `item_type` varchar(128) NOT NULL,
  `item_detail` varchar(512) NOT NULL,
  `tenant_id` int(10) unsigned DEFAULT NULL,
  `tenant_name` varchar(256) DEFAULT NULL,
  `stack_type` varchar(16) DEFAULT NULL,
  `service_manager_id` int(10) unsigned DEFAULT NULL,
  `service_manager_name` varchar(128) DEFAULT NULL,
  `service_instance_metadata` text DEFAULT NULL,
  KEY `ix_invoice_detail_1` (`invoice_id`),
  KEY `ix_invoice_detail_2` (`customer_id`),
  KEY `ix_invoice_detail_4` (`invoice_id`,`customer_name`,`item_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_job_status` (
  `job_id` varchar(256) NOT NULL,
  `start_time` datetime(6) NOT NULL,
  `end_time` datetime(6) DEFAULT NULL,
  `status` varchar(32) DEFAULT NULL,
  `result` varchar(32) DEFAULT NULL,
  `result_detail` longtext DEFAULT NULL,
  PRIMARY KEY (`job_id`(255),`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_lookup_values` (
  `type` varchar(128) NOT NULL,
  `name` varchar(256) NOT NULL,
  `value` longtext NOT NULL,
  PRIMARY KEY (`type`,`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metadata_attributes` (
  `entity_id` int(10) unsigned NOT NULL,
  `entity_type` varchar(32) NOT NULL,
  `name` varchar(128) NOT NULL,
  `datatype` varchar(16) NOT NULL,
  `unit` varchar(16) DEFAULT NULL,
  `value_range` text DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`entity_type`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric` (
  `metric_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_manager_type_id` int(10) unsigned DEFAULT NULL,
  `metric_name` varchar(128) DEFAULT NULL,
  `metric_label` varchar(128) DEFAULT NULL,
  `metric_source` varchar(32) DEFAULT NULL,
  `metric_type` varchar(16) NOT NULL,
  `metric_unit` varchar(16) NOT NULL,
  `entity_resolution` varchar(32) NOT NULL,
  `time_resolution` varchar(16) NOT NULL,
  PRIMARY KEY (`metric_id`),
  UNIQUE KEY `ix_metric_1` (`service_manager_type_id`,`metric_name`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_customer_daily` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_customer_hourly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_customer_monthly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_resource_daily` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `resource_id` int(11) NOT NULL DEFAULT 0,
  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_resource_hourly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `resource_id` int(11) NOT NULL DEFAULT 0,
  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
  `tenant_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_resource_monthly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `resource_id` int(11) NOT NULL DEFAULT 0,
  `resource_foreign_id` varchar(255) NOT NULL DEFAULT '',
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_tenant_daily` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `tenant_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_tenant_hourly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `tenant_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`aggregate_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_aggregate_tenant_monthly` (
  `metric_id` int(11) NOT NULL DEFAULT 0,
  `tenant_id` int(11) NOT NULL DEFAULT 0,
  `aggregate_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `min` double DEFAULT NULL,
  `max` double DEFAULT NULL,
  `avg` double DEFAULT NULL,
  `sum` double DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `sum_of_hourly_max` double DEFAULT NULL,
  `sum_of_hourly_avg` double DEFAULT NULL,
  `diff_of_min_max` double DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_metric_values` (
  `metric_id` int(11) NOT NULL,
  `resource_id` int(11) DEFAULT NULL,
  `resource_foreign_id` varchar(256) DEFAULT NULL,
  `service_manager_id` int(11) DEFAULT NULL,
  `tenant_id` int(11) DEFAULT NULL,
  `tenant_foreign_id` varchar(64) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `metric_datetime` datetime(6) DEFAULT NULL,
  `metric_value` double NOT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  KEY `ix_metric_values_1` (`metric_id`,`resource_id`,`service_region_id`,`metric_datetime`),
  KEY `ix_metric_values_2` (`metric_id`,`tenant_id`,`service_region_id`,`metric_datetime`),
  KEY `ix_metric_values_3` (`metric_id`,`customer_id`,`service_region_id`,`metric_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
 PARTITION BY RANGE (to_days(`metric_datetime`))
(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,
 PARTITION `p737102` VALUES LESS THAN (737102) ENGINE = InnoDB,
 PARTITION `p737103` VALUES LESS THAN (737103) ENGINE = InnoDB,
 PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB,
 PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB,
 PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB,
 PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB,
 PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB,
 PARTITION `p737109` VALUES LESS THAN (737109) ENGINE = InnoDB,
 PARTITION `p737110` VALUES LESS THAN (737110) ENGINE = InnoDB,
 PARTITION `p737111` VALUES LESS THAN (737111) ENGINE = InnoDB,
 PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB,
 PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB,
 PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB,
 PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB,
 PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB,
 PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB,
 PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB,
 PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB,
 PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB,
 PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB,
 PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB,
 PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB,
 PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB,
 PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB,
 PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB,
 PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB,
 PARTITION `p737128` VALUES LESS THAN (737128) ENGINE = InnoDB,
 PARTITION `p737129` VALUES LESS THAN (737129) ENGINE = InnoDB,
 PARTITION `p737130` VALUES LESS THAN (737130) ENGINE = InnoDB,
 PARTITION `p737131` VALUES LESS THAN (737131) ENGINE = InnoDB,
 PARTITION `p737132` VALUES LESS THAN (737132) ENGINE = InnoDB,
 PARTITION `p737133` VALUES LESS THAN (737133) ENGINE = InnoDB,
 PARTITION `p737134` VALUES LESS THAN (737134) ENGINE = InnoDB,
 PARTITION `p737135` VALUES LESS THAN (737135) ENGINE = InnoDB,
 PARTITION `p737136` VALUES LESS THAN (737136) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_parent_child_relationships` (
  `parent_id` int(10) unsigned NOT NULL,
  `parent_type` varchar(64) NOT NULL,
  `child_id` int(10) unsigned NOT NULL,
  `child_type` varchar(64) NOT NULL,
  `add_date` datetime(6) NOT NULL,
  `remove_date` datetime(6) NOT NULL,
  PRIMARY KEY (`parent_id`,`parent_type`,`child_id`,`child_type`,`add_date`,`remove_date`),
  KEY `ix_parent_child_relationships_1` (`child_id`,`child_type`),
  KEY `ix_parent_child_relationships_2` (`parent_id`,`parent_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_payment` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `payment_date` datetime(6) NOT NULL,
  `amount` decimal(19,2) NOT NULL,
  `payment_method` varchar(64) NOT NULL,
  `payment_reference` varchar(256) DEFAULT NULL,
  `payment_method_detail` longtext DEFAULT NULL,
  `payment_status` varchar(64) DEFAULT NULL,
  `payment_status_detail` longtext DEFAULT NULL,
  `external_reference` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `ix_payment_1` (`payer_type`,`payer_id`,`payment_date`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_permissions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_product` (
  `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_name` varchar(64) NOT NULL,
  `product_type` varchar(16) NOT NULL,
  `base_entity_id` int(10) unsigned DEFAULT NULL,
  `product_group` varchar(64) NOT NULL,
  `product_details` text DEFAULT NULL,
  `active_product` tinyint(4) NOT NULL,
  `public_product` tinyint(4) NOT NULL,
  `management_region_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_promo_code` (
  `management_region_id` int(10) unsigned NOT NULL,
  `promo_code_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `promo_code` varchar(128) NOT NULL,
  `salesperson` varchar(128) DEFAULT NULL,
  `discount_or_credit` varchar(8) NOT NULL,
  `credit_amount` decimal(19,2) DEFAULT NULL,
  `credit_type` varchar(16) DEFAULT NULL,
  `apply_to_charge_category` varchar(32) DEFAULT NULL,
  `trigger_charge_category` varchar(32) DEFAULT NULL,
  `trigger_amount` decimal(19,2) DEFAULT NULL,
  `discount_percent` decimal(5,2) DEFAULT NULL,
  `available_invoice_periods` int(11) DEFAULT NULL,
  `expire_date` datetime(6) DEFAULT NULL,
  `currency` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`promo_code_id`),
  UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`),
  KEY `ix_promo_code_1` (`promo_code`),
  KEY `ix_promo_code_2` (`salesperson`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_promo_code_redemption` (
  `promo_code_id` int(10) unsigned NOT NULL,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `redemption_date` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`payer_id`,`promo_code_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_properties_schema` (
  `property_group` varchar(128) NOT NULL,
  `property_name` varchar(128) NOT NULL,
  `default_value` text DEFAULT NULL,
  `form_label` varchar(1024) NOT NULL,
  `form_order` smallint(6) NOT NULL,
  `data_type` varchar(16) NOT NULL,
  `data_format` varchar(32) DEFAULT NULL,
  `permitted_values` text DEFAULT NULL,
  `required` tinyint(4) NOT NULL DEFAULT 0,
  `description` varchar(2048) DEFAULT NULL,
  `property_type` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`property_group`,`property_name`,`property_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_provider` (
  `provider_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `provider_name` varchar(512) NOT NULL,
  `provider_type` varchar(64) NOT NULL,
  `metadata` text DEFAULT NULL,
  `tax_rate` decimal(18,4) DEFAULT 0.0000,
  `currency` char(6) DEFAULT NULL,
  `discount_percent` decimal(18,4) DEFAULT 0.0000,
  `billing_frequency` varchar(40) DEFAULT NULL,
  `last_bill_date` datetime(6) DEFAULT NULL,
  `next_bill_date` datetime(6) DEFAULT NULL,
  `last_payment_date` datetime(6) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `create_date` datetime(6) DEFAULT NULL,
  `activate_date` datetime(6) DEFAULT NULL,
  `billing_start_date` datetime(6) DEFAULT NULL,
  `deactivate_date` datetime(6) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `minimum_invoice_commitment` decimal(19,2) DEFAULT NULL,
  `invoicing_method` varchar(32) DEFAULT NULL,
  `invoice_processing_method` varchar(32) DEFAULT NULL,
  `billing_address_line_1` varchar(512) DEFAULT NULL,
  `billing_address_line_2` varchar(512) DEFAULT NULL,
  `billing_address_city` varchar(512) DEFAULT NULL,
  `billing_address_region` varchar(128) DEFAULT NULL,
  `billing_address_country` varchar(2) DEFAULT NULL,
  `billing_address_postal_code` varchar(64) DEFAULT NULL,
  `legal_address_line_1` varchar(512) DEFAULT NULL,
  `legal_address_line_2` varchar(512) DEFAULT NULL,
  `legal_address_city` varchar(512) DEFAULT NULL,
  `legal_address_region` varchar(128) DEFAULT NULL,
  `legal_address_country` varchar(2) DEFAULT NULL,
  `legal_address_postal_code` varchar(64) DEFAULT NULL,
  `payer_payment_details` varchar(5120) DEFAULT NULL,
  `payee_payment_details` varchar(5120) DEFAULT NULL,
  `public_url` varchar(512) NOT NULL,
  `management_region_id` varchar(64) NOT NULL,
  `balance_due` decimal(19,2) DEFAULT NULL,
  `openbook_processes_payments` tinyint(1) DEFAULT 0,
  `openbook_processes_past_due_invoices` tinyint(1) DEFAULT 0,
  `openstack_tenant_id` varchar(36) DEFAULT NULL,
  `tax_id` varchar(128) DEFAULT NULL,
  `registration_number` varchar(128) DEFAULT NULL,
  `os_service_manager_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`provider_id`),
  UNIQUE KEY `ix_provider_2` (`management_region_id`),
  UNIQUE KEY `ix_provider_1` (`public_url`(255))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_provider_payment_processors` (
  `provider_id` int(10) unsigned NOT NULL,
  `processor_name` varchar(128) NOT NULL,
  `property_name` varchar(128) NOT NULL,
  `property_value` text DEFAULT NULL,
  PRIMARY KEY (`provider_id`,`processor_name`,`property_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_provider_properties` (
  `provider_id` int(10) unsigned NOT NULL,
  `property_group` varchar(128) NOT NULL,
  `property_name` varchar(128) NOT NULL,
  `property_value` text DEFAULT NULL,
  PRIMARY KEY (`provider_id`,`property_group`,`property_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_provider_region` (
  `provider_id` int(10) unsigned NOT NULL,
  `region_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`provider_id`,`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_provider_service_manager` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int(11) NOT NULL,
  `service_manager_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_rate` (
  `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate_plan_id` int(10) unsigned NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `service_region_id` int(10) unsigned NOT NULL,
  `rate_structure` text NOT NULL,
  PRIMARY KEY (`rate_id`),
  KEY `ix_rate_1` (`rate_plan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=896 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_rate_plan` (
  `rate_plan_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate_plan_name` varchar(255) DEFAULT NULL,
  `applies_to` varchar(32) NOT NULL,
  `rate_plan_description` varchar(1024) DEFAULT NULL,
  `currency` char(6) DEFAULT NULL,
  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
  `management_region_id` varchar(64) NOT NULL,
  PRIMARY KEY (`rate_plan_id`),
  UNIQUE KEY `ix_rate_plan_2` (`management_region_id`,`rate_plan_name`),
  KEY `ix_rate_plan_1` (`management_region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_rate_plan_assignment` (
  `rate_plan_id` int(10) unsigned NOT NULL,
  `assignee_id` int(10) unsigned NOT NULL,
  `assignee_type` varchar(64) NOT NULL,
  `assignment_start_date` datetime(6) NOT NULL,
  `assignment_end_date` datetime(6) NOT NULL,
  `assignment_type` varchar(64) NOT NULL,
  PRIMARY KEY (`rate_plan_id`,`assignee_id`,`assignment_start_date`,`assignment_end_date`),
  KEY `ix_rate_plan_assignment_1` (`assignee_type`,`assignee_id`,`assignment_start_date`,`assignment_end_date`),
  KEY `ix_rate_plan_assignment_2` (`assignment_type`,`assignee_id`,`assignment_start_date`,`assignment_end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_region` (
  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `region_name` varchar(128) NOT NULL,
  `region_type` varchar(64) NOT NULL,
  `parent_region_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`region_id`),
  UNIQUE KEY `ix_region_1` (`parent_region_id`,`region_type`,`region_name`),
  KEY `ix_region_2` (`parent_region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_resource_event` (
  `event_id` varchar(100) NOT NULL,
  `event_type` varchar(128) NOT NULL,
  `event_date` datetime(6) NOT NULL,
  `resource_id` varchar(36) DEFAULT NULL,
  `resource_name` varchar(256) DEFAULT NULL,
  `resource_foreign_id` varchar(512) DEFAULT NULL,
  `customer_id` varchar(36) DEFAULT NULL,
  `customer_name` varchar(512) DEFAULT NULL,
  `tenant_foreign_id` varchar(512) DEFAULT NULL,
  `service_manager_id` int(10) unsigned NOT NULL,
  `service_region_id` int(10) unsigned DEFAULT NULL,
  `management_region_id` int(10) unsigned DEFAULT NULL,
  `tenant_id` int(10) unsigned DEFAULT NULL,
  `tenant_name` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`service_manager_id`,`event_id`),
  KEY `ix_vm_event_1` (`resource_foreign_id`(255),`event_date`),
  KEY `ix_vm_event_2` (`customer_id`),
  KEY `ix_vm_event_3` (`resource_name`(255),`event_date`),
  KEY `ix_vm_event_4` (`service_manager_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_resource_group` (
  `resource_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `resource_group_name` varchar(512) NOT NULL,
  `resource_group_type` varchar(64) DEFAULT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `parent_type` varchar(64) NOT NULL,
  PRIMARY KEY (`resource_group_id`),
  KEY `ix_resource_group_1` (`parent_id`),
  KEY `ix_resource_group_2` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_role_permissions` (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `modifiedBy` varchar(128) NOT NULL DEFAULT '',
  `modifiedDate` datetime NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service` (
  `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_type` varchar(128) NOT NULL,
  `service_description` longtext DEFAULT NULL,
  `service_manager_type_id` int(10) unsigned DEFAULT NULL,
  `states` text DEFAULT NULL,
  `externally_managed` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`service_id`),
  UNIQUE KEY `ix_service_1` (`service_manager_type_id`,`service_type`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_instance` (
  `service_instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` int(10) unsigned NOT NULL,
  `service_instance_name` varchar(256) NOT NULL,
  `service_manager_id` int(10) unsigned NOT NULL,
  `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
  `service_instance_foreign_id` varchar(256) DEFAULT NULL,
  `tenant_id` int(10) unsigned DEFAULT NULL,
  `current_attributes` text DEFAULT NULL,
  PRIMARY KEY (`service_instance_id`),
  UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)),
  KEY `ix_provisioned_entity_3` (`service_manager_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107463 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_instance_aggregates` (
  `customer_id` int(10) unsigned NOT NULL DEFAULT 0,
  `customer_name` varchar(255) DEFAULT NULL,
  `tenant_id` int(10) unsigned NOT NULL DEFAULT 0,
  `tenant_name` varchar(255) DEFAULT NULL,
  `management_region_id` varchar(128) NOT NULL DEFAULT '',
  `service_manager_id` int(10) unsigned NOT NULL,
  `service_manager_name` varchar(256) NOT NULL,
  `service_region_id` int(10) unsigned NOT NULL,
  `service_region_name` varchar(128) NOT NULL,
  `aggregate_category` varchar(128) NOT NULL,
  `aggregate_name` varchar(128) NOT NULL,
  `aggregate_type` varchar(64) NOT NULL,
  `aggregate_value` int(11) NOT NULL,
  `aggregate_interval` varchar(32) NOT NULL,
  `aggregate_datetime` datetime(6) NOT NULL,
  PRIMARY KEY (`management_region_id`,`customer_id`,`service_manager_id`,`tenant_id`,`service_region_id`,`aggregate_category`,`aggregate_name`,`aggregate_type`,`aggregate_interval`,`aggregate_datetime`),
  KEY `ix_service_instance_aggregates_2` (`service_manager_id`,`service_region_id`,`aggregate_datetime`,`aggregate_name`),
  KEY `ix_service_instance_aggregates_3` (`customer_id`,`tenant_id`,`aggregate_datetime`,`aggregate_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_instance_attributes` (
  `service_instance_id` int(10) unsigned NOT NULL,
  `start_date` datetime(6) NOT NULL,
  `end_date` datetime(6) NOT NULL,
  `attributes` blob DEFAULT NULL,
  UNIQUE KEY `ix_resource_configuration_history_1` (`service_instance_id`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_instance_state` (
  `service_instance_id` int(10) unsigned NOT NULL,
  `state` varchar(64) NOT NULL,
  `start_date` datetime(6) NOT NULL,
  `end_date` datetime(6) NOT NULL,
  `interval_length_milliseconds` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`service_instance_id`,`state`,`start_date`),
  KEY `ix_service_instance_state_1` (`service_instance_id`,`state`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_manager` (
  `service_manager_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_manager_name` varchar(256) NOT NULL,
  `service_manager_description` varchar(512) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `service_region_id` int(10) unsigned NOT NULL,
  `service_manager_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`service_manager_id`),
  UNIQUE KEY `ix_service_manager_1` (`service_manager_name`(255))
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_manager_properties` (
  `service_manager_id` int(10) unsigned NOT NULL,
  `property_group` varchar(128) NOT NULL,
  `property_name` varchar(128) NOT NULL,
  `property_value` text DEFAULT NULL,
  PRIMARY KEY (`service_manager_id`,`property_group`,`property_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_manager_sync_metrics` (
  `service_manager_id` int(10) unsigned NOT NULL,
  `metric_name` varchar(255) NOT NULL,
  `metric_value` text NOT NULL,
  PRIMARY KEY (`service_manager_id`,`metric_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_service_manager_type` (
  `service_manager_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `service_manager_type` varchar(32) NOT NULL,
  `service_manager_type_description` varchar(256) DEFAULT NULL,
  `system_defined` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`service_manager_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_tenant` (
  `tenant_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_name` varchar(512) NOT NULL,
  `tenant_foreign_id` varchar(512) DEFAULT NULL,
  `create_date` datetime(6) NOT NULL,
  `deactivate_date` datetime(6) DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `service_manager_id` int(10) unsigned NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `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 AUTO_INCREMENT=2443 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_tenant_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=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_tenant_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 */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_unbilled_charges` (
  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `payer_name` varchar(512) NOT NULL,
  `invoice_number` varchar(45) DEFAULT NULL,
  `invoice_date` datetime(6) NOT NULL,
  `period_begin` datetime(6) NOT NULL,
  `period_end` datetime(6) NOT NULL,
  `invoice_amount` decimal(19,2) NOT NULL,
  `actual_charges` decimal(19,2) NOT NULL,
  `invoice_currency` varchar(16) DEFAULT NULL,
  `management_region_id` int(10) unsigned NOT NULL,
  `payer_metadata` text DEFAULT NULL,
  PRIMARY KEY (`invoice_id`),
  KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=628 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_unbilled_charges_detail` (
  `invoice_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `service_region_id` int(10) unsigned DEFAULT NULL,
  `service_region_name` varchar(128) DEFAULT NULL,
  `rate` decimal(22,12) NOT NULL,
  `rate_display` varchar(255) DEFAULT NULL,
  `rate_unit` varchar(128) NOT NULL,
  `rate_interval` varchar(128) DEFAULT NULL,
  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
  `units_billed` decimal(36,12) DEFAULT NULL,
  `units_billed_display` varchar(128) DEFAULT NULL,
  `item_invoice_amount` decimal(19,2) NOT NULL,
  `item_category` varchar(128) NOT NULL,
  `item_group` varchar(128) NOT NULL,
  `item_type` varchar(128) NOT NULL,
  `item_detail` varchar(512) NOT NULL,
  `tenant_id` int(10) unsigned DEFAULT NULL,
  `tenant_name` varchar(256) DEFAULT NULL,
  `stack_type` varchar(16) DEFAULT NULL,
  `service_manager_id` int(10) unsigned DEFAULT NULL,
  `service_manager_name` varchar(128) DEFAULT NULL,
  `service_instance_metadata` text DEFAULT NULL,
  KEY `ix_unbilled_charges_detail_1` (`invoice_id`),
  KEY `ix_unbilled_charges_detail_2` (`customer_id`),
  KEY `ix_unbilled_charges_detail_4` (`invoice_id`,`customer_name`,`item_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_unbilled_charges_detail_temp` (
  `invoice_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `service_region_id` int(10) unsigned DEFAULT NULL,
  `service_region_name` varchar(128) DEFAULT NULL,
  `rate` decimal(22,12) NOT NULL,
  `rate_display` varchar(255) DEFAULT NULL,
  `rate_unit` varchar(128) NOT NULL,
  `rate_interval` varchar(128) DEFAULT NULL,
  `rate_multiplier_percent` decimal(10,6) DEFAULT NULL,
  `units_billed` decimal(36,12) DEFAULT NULL,
  `units_billed_display` varchar(128) DEFAULT NULL,
  `item_invoice_amount` decimal(19,2) NOT NULL,
  `item_category` varchar(128) NOT NULL,
  `item_group` varchar(128) NOT NULL,
  `item_type` varchar(128) NOT NULL,
  `item_detail` varchar(512) NOT NULL,
  `tenant_id` int(10) unsigned DEFAULT NULL,
  `tenant_name` varchar(256) DEFAULT NULL,
  `stack_type` varchar(16) DEFAULT NULL,
  `service_manager_id` int(10) unsigned DEFAULT NULL,
  `service_manager_name` varchar(128) DEFAULT NULL,
  `service_instance_metadata` text DEFAULT NULL,
  KEY `ix_unbilled_charges_detail_1` (`invoice_id`),
  KEY `ix_unbilled_charges_detail_2` (`customer_id`),
  KEY `ix_unbilled_charges_detail_4` (`invoice_id`,`customer_name`,`item_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_unbilled_charges_temp` (
  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payer_id` int(10) unsigned NOT NULL,
  `payer_type` varchar(64) NOT NULL,
  `payer_name` varchar(512) NOT NULL,
  `invoice_number` varchar(45) DEFAULT NULL,
  `invoice_date` datetime(6) NOT NULL,
  `period_begin` datetime(6) NOT NULL,
  `period_end` datetime(6) NOT NULL,
  `invoice_amount` decimal(19,2) NOT NULL,
  `actual_charges` decimal(19,2) NOT NULL,
  `invoice_currency` varchar(16) DEFAULT NULL,
  `management_region_id` int(10) unsigned NOT NULL,
  `payer_metadata` text DEFAULT NULL,
  PRIMARY KEY (`invoice_id`),
  KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=629 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_projects` (
  `user_projects_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `user_foreign_id` varchar(128) NOT NULL,
  `service_manager_id` int(10) unsigned NOT NULL,
  `role_id` varchar(128) NOT NULL,
  `role_name` varchar(128) NOT NULL,
  `project_id` varchar(128) NOT NULL,
  `add_date` datetime(6) NOT NULL,
  `remove_date` datetime(6) NOT NULL,
  PRIMARY KEY (`user_projects_id`),
  KEY `ix_host_1` (`user_id`,`service_manager_id`,`role_id`,`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_roles` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `role_context` int(10) unsigned NOT NULL,
  `context_type` varchar(64) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`role_context`,`context_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_users` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(128) NOT NULL,
  `first_name` varchar(256) DEFAULT NULL,
  `last_name` varchar(256) DEFAULT NULL,
  `email_address` varchar(512) DEFAULT NULL,
  `phone_number` varchar(64) DEFAULT NULL,
  `password` varchar(512) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `password_change_token` varchar(64) DEFAULT NULL,
  `last_password_change_date` datetime(6) DEFAULT NULL,
  `password_change_token_expire_date` datetime(6) DEFAULT NULL,
  `external` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_all_charges` (
  `invoice_id` tinyint NOT NULL,
  `payer_id` tinyint NOT NULL,
  `payer_type` tinyint NOT NULL,
  `payer_name` tinyint NOT NULL,
  `invoice_number` tinyint NOT NULL,
  `invoice_date` tinyint NOT NULL,
  `period_begin` tinyint NOT NULL,
  `period_end` tinyint NOT NULL,
  `invoice_amount` tinyint NOT NULL,
  `actual_charges` tinyint NOT NULL,
  `invoice_currency` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_all_charges_detail` (
  `invoice_id` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `rate` tinyint NOT NULL,
  `rate_display` tinyint NOT NULL,
  `rate_unit` tinyint NOT NULL,
  `rate_interval` tinyint NOT NULL,
  `rate_multiplier_percent` tinyint NOT NULL,
  `units_billed` tinyint NOT NULL,
  `units_billed_display` tinyint NOT NULL,
  `item_invoice_amount` tinyint NOT NULL,
  `item_category` tinyint NOT NULL,
  `item_group` tinyint NOT NULL,
  `item_type` tinyint NOT NULL,
  `item_detail` tinyint NOT NULL,
  `tenant_id` tinyint NOT NULL,
  `tenant_name` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_current_host` (
  `host_id` tinyint NOT NULL,
  `service_manager_id` tinyint NOT NULL,
  `service_manager_name` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `region_name` tinyint NOT NULL,
  `host_foreign_id` tinyint NOT NULL,
  `host_name` tinyint NOT NULL,
  `hypervisor_type` tinyint NOT NULL,
  `host_aggregate` tinyint NOT NULL,
  `add_date` tinyint NOT NULL,
  `remove_date` tinyint NOT NULL,
  `cpu_allocation_ratio` tinyint NOT NULL,
  `ram_allocation_ratio` tinyint NOT NULL,
  `disk_allocation_ratio` tinyint NOT NULL,
  `update_date` tinyint NOT NULL,
  `ram_mb` tinyint NOT NULL,
  `ram_mb_used` tinyint NOT NULL,
  `disk_gb` tinyint NOT NULL,
  `disk_gb_used` tinyint NOT NULL,
  `vcpus` tinyint NOT NULL,
  `vcpus_used` tinyint NOT NULL,
  `vm_count` tinyint NOT NULL,
  `socket_count` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_current_host_attributes` (
  `host_id` tinyint NOT NULL,
  `update_date` tinyint NOT NULL,
  `ram_mb` tinyint NOT NULL,
  `ram_mb_used` tinyint NOT NULL,
  `disk_gb` tinyint NOT NULL,
  `disk_gb_used` tinyint NOT NULL,
  `vcpus` tinyint NOT NULL,
  `vcpus_used` tinyint NOT NULL,
  `vm_count` tinyint NOT NULL,
  `socket_count` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_customer` (
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `metadata` tinyint NOT NULL,
  `tax_rate` tinyint NOT NULL,
  `currency` tinyint NOT NULL,
  `discount_percent` tinyint NOT NULL,
  `billing_frequency` tinyint NOT NULL,
  `last_bill_date` tinyint NOT NULL,
  `next_bill_date` tinyint NOT NULL,
  `is_active` tinyint NOT NULL,
  `create_date` tinyint NOT NULL,
  `activate_date` tinyint NOT NULL,
  `billing_start_date` tinyint NOT NULL,
  `last_payment_date` tinyint NOT NULL,
  `deactivate_date` tinyint NOT NULL,
  `description` tinyint NOT NULL,
  `minimum_invoice_commitment` tinyint NOT NULL,
  `invoicing_method` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `billing_address_line_1` tinyint NOT NULL,
  `billing_address_line_2` tinyint NOT NULL,
  `billing_address_city` tinyint NOT NULL,
  `billing_address_region` tinyint NOT NULL,
  `billing_address_country` tinyint NOT NULL,
  `billing_address_postal_code` tinyint NOT NULL,
  `payer_payment_details` tinyint NOT NULL,
  `payment_method_confirmed` tinyint NOT NULL,
  `balance_due` tinyint NOT NULL,
  `spend_soft_limit` tinyint NOT NULL,
  `spend_hard_limit` tinyint NOT NULL,
  `terms_and_conditions_2_accept_date` tinyint NOT NULL,
  `tax_id` tinyint NOT NULL,
  `registration_number` tinyint NOT NULL,
  `management_region_name` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_metric` (
  `metric_id` tinyint NOT NULL,
  `service_manager_type_id` tinyint NOT NULL,
  `metric_name` tinyint NOT NULL,
  `metric_label` tinyint NOT NULL,
  `metric_source` tinyint NOT NULL,
  `metric_type` tinyint NOT NULL,
  `metric_unit` tinyint NOT NULL,
  `entity_resolution` tinyint NOT NULL,
  `time_resolution` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_promo_code_redemption` (
  `management_region_id` tinyint NOT NULL,
  `promo_code_id` tinyint NOT NULL,
  `promo_code` tinyint NOT NULL,
  `salesperson` tinyint NOT NULL,
  `discount_or_credit` tinyint NOT NULL,
  `credit_amount` tinyint NOT NULL,
  `credit_type` tinyint NOT NULL,
  `apply_to_charge_category` tinyint NOT NULL,
  `trigger_charge_category` tinyint NOT NULL,
  `trigger_amount` tinyint NOT NULL,
  `discount_percent` tinyint NOT NULL,
  `available_invoice_periods` tinyint NOT NULL,
  `expire_date` tinyint NOT NULL,
  `currency` tinyint NOT NULL,
  `redemption_date` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_provider` (
  `provider_id` tinyint NOT NULL,
  `provider_name` tinyint NOT NULL,
  `provider_type` tinyint NOT NULL,
  `metadata` tinyint NOT NULL,
  `tax_rate` tinyint NOT NULL,
  `currency` tinyint NOT NULL,
  `discount_percent` tinyint NOT NULL,
  `billing_frequency` tinyint NOT NULL,
  `last_bill_date` tinyint NOT NULL,
  `next_bill_date` tinyint NOT NULL,
  `last_payment_date` tinyint NOT NULL,
  `is_active` tinyint NOT NULL,
  `create_date` tinyint NOT NULL,
  `activate_date` tinyint NOT NULL,
  `billing_start_date` tinyint NOT NULL,
  `deactivate_date` tinyint NOT NULL,
  `description` tinyint NOT NULL,
  `minimum_invoice_commitment` tinyint NOT NULL,
  `invoicing_method` tinyint NOT NULL,
  `invoice_processing_method` tinyint NOT NULL,
  `billing_address_line_1` tinyint NOT NULL,
  `billing_address_line_2` tinyint NOT NULL,
  `billing_address_city` tinyint NOT NULL,
  `billing_address_region` tinyint NOT NULL,
  `billing_address_country` tinyint NOT NULL,
  `billing_address_postal_code` tinyint NOT NULL,
  `legal_address_line_1` tinyint NOT NULL,
  `legal_address_line_2` tinyint NOT NULL,
  `legal_address_city` tinyint NOT NULL,
  `legal_address_region` tinyint NOT NULL,
  `legal_address_country` tinyint NOT NULL,
  `legal_address_postal_code` tinyint NOT NULL,
  `payer_payment_details` tinyint NOT NULL,
  `payee_payment_details` tinyint NOT NULL,
  `public_url` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `balance_due` tinyint NOT NULL,
  `openbook_processes_payments` tinyint NOT NULL,
  `openbook_processes_past_due_invoices` tinyint NOT NULL,
  `openstack_tenant_id` tinyint NOT NULL,
  `tax_id` tinyint NOT NULL,
  `registration_number` tinyint NOT NULL,
  `os_service_manager_id` tinyint NOT NULL,
  `parent_management_region_id` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_rate_plan_assignment` (
  `rate_plan_id` tinyint NOT NULL,
  `assignee_id` tinyint NOT NULL,
  `assignee_type` tinyint NOT NULL,
  `assignment_start_date` tinyint NOT NULL,
  `assignment_end_date` tinyint NOT NULL,
  `assignment_type` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_service` (
  `service_id` tinyint NOT NULL,
  `service_type` tinyint NOT NULL,
  `service_description` tinyint NOT NULL,
  `service_manager_type_id` tinyint NOT NULL,
  `states` tinyint NOT NULL,
  `externally_managed` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_service_instance` (
  `service_instance_id` tinyint NOT NULL,
  `service_id` tinyint NOT NULL,
  `service_instance_name` tinyint NOT NULL,
  `service_manager_id` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `service_instance_foreign_id` tinyint NOT NULL,
  `tenant_id` tinyint NOT NULL,
  `current_attributes` tinyint NOT NULL,
  `tenant_name` tinyint NOT NULL,
  `tenant_foreign_id` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `service_manager_name` tinyint NOT NULL,
  `service_region_name` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL,
  `service_type` tinyint NOT NULL,
  `provisioned_date` tinyint NOT NULL,
  `deprovisioned_date` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_service_instance_attributes` (
  `service_instance_id` tinyint NOT NULL,
  `start_date` tinyint NOT NULL,
  `end_date` tinyint NOT NULL,
  `attributes` tinyint NOT NULL,
  `tenant_id` tinyint NOT NULL,
  `tenant_foreign_id` tinyint NOT NULL,
  `tenant_name` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `service_instance_name` tinyint NOT NULL,
  `service_instance_foreign_id` tinyint NOT NULL,
  `service_manager_id` tinyint NOT NULL,
  `service_manager_name` tinyint NOT NULL,
  `service_id` tinyint NOT NULL,
  `service_type` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `service_region_name` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_service_instance_state` (
  `service_instance_id` tinyint NOT NULL,
  `state` tinyint NOT NULL,
  `start_date` tinyint NOT NULL,
  `end_date` tinyint NOT NULL,
  `interval_length_milliseconds` tinyint NOT NULL,
  `tenant_id` tinyint NOT NULL,
  `tenant_foreign_id` tinyint NOT NULL,
  `tenant_name` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `service_instance_name` tinyint NOT NULL,
  `service_instance_foreign_id` tinyint NOT NULL,
  `service_manager_id` tinyint NOT NULL,
  `service_manager_name` tinyint NOT NULL,
  `service_id` tinyint NOT NULL,
  `service_type` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `service_region_name` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_service_manager` (
  `service_manager_id` tinyint NOT NULL,
  `service_manager_name` tinyint NOT NULL,
  `service_manager_description` tinyint NOT NULL,
  `metadata` tinyint NOT NULL,
  `service_region_id` tinyint NOT NULL,
  `service_manager_type_id` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v_tenant` (
  `tenant_id` tinyint NOT NULL,
  `tenant_name` tinyint NOT NULL,
  `tenant_foreign_id` tinyint NOT NULL,
  `create_date` tinyint NOT NULL,
  `deactivate_date` tinyint NOT NULL,
  `customer_id` tinyint NOT NULL,
  `service_manager_id` tinyint NOT NULL,
  `is_active` tinyint NOT NULL,
  `customer_name` tinyint NOT NULL,
  `management_region_id` tinyint NOT NULL,
  `service_manager_type` tinyint NOT NULL,
  `tenant_type` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
use openbook;
CALL p_preallocate_partitions('t_metric_values', 'metric_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_resource_hourly', 'aggregate_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_tenant_hourly', 'aggregate_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_customer_hourly', 'aggregate_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_resource_daily', 'aggregate_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_tenant_daily', 'aggregate_datetime', CURDATE(), 31);
CALL p_preallocate_partitions('t_metric_aggregate_customer_daily', 'aggregate_datetime', CURDATE(), 31);