diff options
| author | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-22 16:35:10 -0700 |
|---|---|---|
| committer | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-22 16:35:10 -0700 |
| commit | 8f7606bfe6e6e0d525c11f022b9cad2f3d4f38cf (patch) | |
| tree | 5287773d679c8d551f7841d32cc50d75ea4fb0c0 /salt/openbook/database/files/create_openbook_schemas.sql | |
| parent | e00e8747ac0ba74cc949d89e20fd1bfed7ecaaf2 (diff) | |
update create_databases_schema.sql Do 22. Feb 16:35:10 MST 2018
Diffstat (limited to 'salt/openbook/database/files/create_openbook_schemas.sql')
| -rw-r--r-- | salt/openbook/database/files/create_openbook_schemas.sql | 2138 |
1 files changed, 0 insertions, 2138 deletions
diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index e309e6a..26001e6 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -1,2141 +1,3 @@ - -/*!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=2263 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=315871 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=2129 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=2129 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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 `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, - PARTITION `p737137` VALUES LESS THAN (737137) ENGINE = InnoDB, - PARTITION `p737138` VALUES LESS THAN (737138) ENGINE = InnoDB, - PARTITION `p737139` VALUES LESS THAN (737139) ENGINE = InnoDB, - PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, - PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, - PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) 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=108497 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=2467 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=692 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=693 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); |