From 28144eda73eb77aa3b6632af354bb7ccd8e6f962 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Wed, 11 Oct 2017 19:34:26 +0000 Subject: update create_databases_schama.sql Wed Oct 11 19:34:26 UTC 2017 --- .../database/files/create_openbook_schemas.sql | 4160 +++++++++++++------- 1 file changed, 2752 insertions(+), 1408 deletions(-) (limited to 'salt/openbook/database/files') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index f6544fc..404ce3b 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -1,1416 +1,2760 @@ -SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; -SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; -SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; -DROP SCHEMA IF EXISTS openbook; -CREATE SCHEMA openbook DEFAULT CHARACTER SET utf8; +/*!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 %}'; -FLUSH PRIVILEGES; - -USE openbook; - -CREATE TABLE t_audit_event ( - event_id INT 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) NULL, - entity_type VARCHAR(45) NOT NULL, - user_id VARCHAR(128) NULL, - event_data LONGTEXT NULL, - PRIMARY KEY (event_id), - INDEX ix_audit_event_1 (event_time, event_type, entity_id), - INDEX ix_audit_event_2 (user_id, event_time)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_billable_feature ( - billable_feature_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - billable_feature_category VARCHAR(128) NOT NULL, - billable_feature_vendor_type VARCHAR(128) NOT NULL, - billable_feature_type VARCHAR(128) NOT NULL, - billable_feature_subtypes LONGTEXT NULL DEFAULT NULL, - billable_feature_subtype_classifier LONGTEXT NULL DEFAULT NULL, - billable_feature_description LONGTEXT NULL DEFAULT NULL, - billable_feature_details LONGTEXT NULL DEFAULT NULL, - PRIMARY KEY (billable_feature_id), - UNIQUE INDEX ix_billable_feature_1 (billable_feature_vendor_type ASC, billable_feature_type ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_credit ( - credit_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - payer_id INT UNSIGNED NOT NULL, - payer_type VARCHAR(64) NOT NULL, - credit_amount DECIMAL(19,2) NULL, - remaining_amount DECIMAL(19,2) 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, - PRIMARY KEY (credit_id), - INDEX ix_credit_1 (payer_id, payer_type, expire_date)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_customer ( - customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - resource_manager_id VARCHAR(36) NULL DEFAULT NULL, - resource_manager_foreign_id VARCHAR(512) NULL DEFAULT NULL, - customer_name VARCHAR(512) NOT NULL, - other_foreign_ids LONGTEXT NULL DEFAULT NULL, - tax_rate DECIMAL(18,4) NULL DEFAULT 0.0000, - currency CHAR(6) NULL DEFAULT NULL, - discount_percent DECIMAL(18,4) NULL DEFAULT 0.0000, - billing_frequency VARCHAR(40) NULL DEFAULT NULL, - last_bill_date DATETIME(6) NULL DEFAULT NULL, - next_bill_date DATETIME(6) NULL DEFAULT NULL, - is_active TINYINT(1) NULL DEFAULT 1, - create_date DATETIME(6) NULL DEFAULT NULL, - activate_date DATETIME(6) NULL DEFAULT NULL, - billing_start_date DATETIME(6) NULL DEFAULT NULL, - last_payment_date DATETIME(6) NULL DEFAULT NULL, - deactivate_date DATETIME(6) NULL DEFAULT NULL, - description VARCHAR(5120) NULL DEFAULT NULL, - minimum_invoice_commitment DECIMAL(19,4) NULL, - invoicing_method VARCHAR(32) NOT NULL, - management_region_id VARCHAR(64) NULL, - infrastructure_region_id VARCHAR(64) NULL, - billing_address_line_1 VARCHAR(512) NULL, - billing_address_line_2 VARCHAR(512) NULL, - billing_address_city VARCHAR(512) NULL, - billing_address_region VARCHAR(128) NULL, - billing_address_country VARCHAR(2) NULL, - billing_address_postal_code VARCHAR(64) NULL, - payer_payment_details VARCHAR(5120) NULL, - payment_method_confirmed TINYINT(1) DEFAULT 0, - balance_due DECIMAL(19,4) NULL DEFAULT 0, - PRIMARY KEY (customer_id), - INDEX ix_customer_1 (resource_manager_id ASC), - INDEX ix_customer_2 (resource_manager_foreign_id(255) ASC), - UNIQUE INDEX ix_customer_3 (management_region_id, customer_name(255))) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_discount ( - discount_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - payer_id INT 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) NOT NULL, - trigger_charge_category VARCHAR(32) NULL, - trigger_amount DECIMAL(19,2) NULL, - start_date DATETIME(6) NOT NULL, - end_date DATETIME(6) NOT NULL, - PRIMARY KEY (discount_id), - INDEX ix_discount_1 (payer_id, payer_type, end_date)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_email_notification ( - message_id INT 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) NULL, - date_last_send_attempt DATETIME(6) NULL, - send_status VARCHAR(16) NULL, - send_status_detail VARCHAR(5120) NULL, - send_attempt_count SMALLINT NULL, - PRIMARY KEY (message_id), - INDEX ix_email_notification_1 (recipient, date_generated), - INDEX ix_email_notification_2 (sender, date_generated), - INDEX ix_email_notification_3 (date_sent)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_email_template ( - provider_id INT 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 CHARACTER SET = utf8; - -CREATE TABLE t_entity_attribute ( - entity_id INT 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) NULL DEFAULT NULL, - add_date DATETIME(6) NULL DEFAULT NULL, - expire_date DATETIME(6) NOT NULL, - PRIMARY KEY (entity_id ASC, expire_date ASC, attribute_class ASC, attribute_category ASC, attribute_name ASC), - INDEX ix_entity_attribute_1 (attribute_class ASC), - INDEX ix_entity_attribute_2 (attribute_category ASC), - INDEX ix_entity_attribute_3 (attribute_name ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_invoice ( - invoice_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - payer_id INT UNSIGNED NOT NULL, - payer_type VARCHAR(64) NOT NULL, - payer_name VARCHAR(512) NOT NULL, - invoice_number VARCHAR(45) 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) NULL, - management_region_id INT UNSIGNED NOT NULL, - balance_due DECIMAL(19,2) NOT NULL, - PRIMARY KEY (invoice_id), - INDEX ix_invoice_1 (management_region_id, payer_type, payer_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_invoice_detail ( - invoice_id INT UNSIGNED NOT NULL, - customer_id INT UNSIGNED NOT NULL, - resource_group_id VARCHAR(36) NULL, - invoice_group VARCHAR(128) NULL, - item_name VARCHAR(512) NULL, - item_vendor_type VARCHAR(128) NULL, - item_type VARCHAR(128) NOT NULL, - item_subtype VARCHAR(128) NOT NULL, - item_description VARCHAR(512) NOT NULL, - rate_plan_id VARCHAR(36) NULL, - rate_plan_billable_feature_id VARCHAR(36) NULL DEFAULT NULL, - billing_interval VARCHAR(64) NULL DEFAULT NULL, - item_invoice_amount DECIMAL(19,2) NOT NULL, - num_units VARCHAR(32) NOT NULL, - num_units_unit VARCHAR(16) NULL, - INDEX ix_invoice_detail_1 (invoice_id ASC), - INDEX ix_invoice_detail_2 (customer_id ASC), - INDEX ix_invoice_detail_3 (item_vendor_type, item_type, item_subtype ASC), - INDEX ix_invoice_detail_4 (rate_plan_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_job_status ( - job_id VARCHAR(256) NOT NULL, - start_time DATETIME(6) NOT NULL, - end_time DATETIME(6) NULL DEFAULT NULL, - status VARCHAR(32) NULL DEFAULT NULL, - result VARCHAR(32) NULL DEFAULT NULL, - result_detail LONGTEXT NULL DEFAULT NULL, - PRIMARY KEY (job_id(255), start_time)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = 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 CHARACTER SET = utf8; - -CREATE TABLE t_parent_child_relationships ( - parent_id INT UNSIGNED NOT NULL, - parent_type VARCHAR(64) NOT NULL, - child_id INT UNSIGNED NOT NULL, - child_type VARCHAR(64) NOT NULL, - assigned_quantity INT NOT NULL DEFAULT 1, - 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), - INDEX ix_parent_child_relationships_1 (child_id, child_type ASC), - INDEX ix_parent_child_relationships_2 (parent_id, parent_type ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_payment ( - payment_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - payer_id INT 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) NULL, - payment_method_detail LONGTEXT NULL DEFAULT NULL, - payment_status VARCHAR(64) NULL DEFAULT NULL, - payment_status_detail LONGTEXT NULL DEFAULT NULL, - PRIMARY KEY (payment_id), - INDEX ix_payment_1 (payer_type, payer_id, payment_date)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_promo_code ( - management_region_id INT UNSIGNED NOT NULL, - promo_code_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - promo_code VARCHAR(128) NOT NULL, - salesperson VARCHAR(128) NULL, - discount_or_credit VARCHAR(8) NOT NULL, - credit_amount DECIMAL(19,2) NULL, - credit_type VARCHAR(16) NULL, - apply_to_charge_category VARCHAR(32) NULL, - trigger_charge_category VARCHAR(32) NULL, - trigger_amount DECIMAL(19,2) NULL, - discount_percent DECIMAL(5,2) NULL, - available_invoice_periods INT NULL, - expire_date DATETIME(6) NULL, - currency VARCHAR(3) NULL DEFAULT NULL, - PRIMARY KEY (promo_code_id), - INDEX ix_promo_code_1 (promo_code), - INDEX ix_promo_code_2 (salesperson), - UNIQUE INDEX ix_promo_code_3 (management_region_id, promo_code)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_promo_code_redemption ( - promo_code_id INT UNSIGNED NOT NULL, - payer_id INT UNSIGNED NOT NULL, - payer_type VARCHAR(64) NOT NULL, - redemption_date DATETIME(6) NULL, - PRIMARY KEY (payer_id, promo_code_id)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - - -CREATE TABLE t_provider ( - provider_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - provider_name VARCHAR(512) NOT NULL, - provider_type VARCHAR(64) NOT NULL, - other_foreign_ids LONGTEXT NULL DEFAULT NULL, - tax_rate DECIMAL(18,4) NULL DEFAULT 0.0000, - currency CHAR(6) NULL DEFAULT NULL, - discount_percent DECIMAL(18,4) NULL DEFAULT 0.0000, - billing_frequency VARCHAR(40) NULL DEFAULT NULL, - last_bill_date DATETIME(6) NULL DEFAULT NULL, - next_bill_date DATETIME(6) NULL DEFAULT NULL, - last_payment_date DATETIME(6) NULL DEFAULT NULL, - is_active TINYINT(1) NULL DEFAULT 1, - create_date DATETIME(6) NULL DEFAULT NULL, - activate_date DATETIME(6) NULL DEFAULT NULL, - billing_start_date DATETIME(6) NULL DEFAULT NULL, - deactivate_date DATETIME(6) NULL DEFAULT NULL, - description LONGTEXT NULL DEFAULT NULL, - minimum_invoice_commitment DECIMAL(19,2) NULL, - invoicing_method VARCHAR(32) NULL DEFAULT NULL, - invoice_processing_method VARCHAR(32) NULL DEFAULT NULL, - billing_address_line_1 VARCHAR(512) NULL, - billing_address_line_2 VARCHAR(512) NULL, - billing_address_city VARCHAR(512) NULL, - billing_address_region VARCHAR(128) NULL, - billing_address_country VARCHAR(2) NULL, - billing_address_postal_code VARCHAR(64) NULL, - legal_address_line_1 VARCHAR(512) NULL, - legal_address_line_2 VARCHAR(512) NULL, - legal_address_city VARCHAR(512) NULL, - legal_address_region VARCHAR(128) NULL, - legal_address_country VARCHAR(2) NULL, - legal_address_postal_code VARCHAR(64) NULL, - payer_payment_details VARCHAR (5120) NULL, - payee_payment_details VARCHAR(5120) NULL, - public_url VARCHAR(512) NOT NULL, - private_url VARCHAR(512) NOT NULL, - management_region_id VARCHAR(64) NOT NULL, - notification_settings LONGTEXT NOT NULL, - personalization_settings LONGTEXT NOT NULL, - balance_due DECIMAL(19,2) NULL, - openbook_processes_payments TINYINT(1) NULL DEFAULT 1, - openbook_processes_past_due_invoices TINYINT(1) NULL DEFAULT 1, - openstack_tenant_id VARCHAR(36) NULL DEFAULT NULL, - PRIMARY KEY (provider_id), - UNIQUE INDEX ix_provider_1 (public_url(255)), - UNIQUE INDEX ix_provider_2 (management_region_id)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_provider_region ( - provider_id INT UNSIGNED NOT NULL, - region_id INT UNSIGNED NOT NULL, - PRIMARY KEY (provider_id, region_id)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_provisioned_entity ( - entity_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - billable_feature_id INT UNSIGNED NOT NULL, - entity_name VARCHAR(256) NOT NULL, - entity_subtype VARCHAR(128) NULL DEFAULT NULL, - customer_id INT UNSIGNED NOT NULL, - resource_manager_id INT UNSIGNED NOT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL, - entity_foreign_id VARCHAR(256) NULL DEFAULT NULL, - provisioned_date DATETIME(6) NULL DEFAULT NULL, - deprovisioned_date DATETIME(6) NULL DEFAULT NULL, - PRIMARY KEY (entity_id), - INDEX ix_provisioned_entity_1 (entity_foreign_id(255) ASC), - INDEX ix_provisioned_entity_2 (customer_id), - INDEX ix_provisioned_entity_3 (resource_manager_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan ( - rate_plan_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - rate_plan_name VARCHAR(255) NULL DEFAULT NULL, - applies_to VARCHAR(32) NOT NULL, - rate_plan_description VARCHAR(1024) NULL DEFAULT NULL, - proration_details LONGTEXT NULL DEFAULT NULL, - currency CHAR(6) NULL DEFAULT NULL, - discount_percent VARCHAR(20) NULL DEFAULT NULL, - management_region_id VARCHAR(64) NOT NULL, - PRIMARY KEY (rate_plan_id), - INDEX ix_rate_plan_1 (management_region_id ASC), - UNIQUE INDEX ix_rate_plan_2 (management_region_id, rate_plan_name)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan_assignment ( - rate_plan_id INT UNSIGNED NOT NULL, - assignee_id INT 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), - INDEX ix_rate_plan_assignment_1 (assignee_type, assignee_id, assignment_start_date, assignment_end_date ASC), - INDEX ix_rate_plan_assignment_2 (assignment_type, assignee_id, assignment_start_date, assignment_end_date ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan_billable_attribute ( - rate_plan_id INT UNSIGNED NOT NULL, - feature_type VARCHAR(128) NOT NULL, - 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) NULL DEFAULT NULL, - attribute_datatype VARCHAR(32) NOT NULL, - charge VARCHAR(32) NOT NULL, - operator VARCHAR(32) NULL DEFAULT NULL, - billing_scheme VARCHAR(64) NOT NULL, - cost_calculation_frequency VARCHAR(64) NOT NULL, - filter TEXT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL DEFAULT 0, - INDEX ix_rate_plan_billable_attribute_1 (rate_plan_id, infrastructure_region_id)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan_billable_feature ( - rate_plan_id INT UNSIGNED NOT NULL, - billable_feature_id INT UNSIGNED NOT NULL, - billable_feature_subtype VARCHAR(128) NOT NULL, - billable_interval_type VARCHAR(64) NOT NULL, - cost_calculation_frequency VARCHAR(64) NOT NULL, - charge VARCHAR(100) NULL DEFAULT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (rate_plan_id, infrastructure_region_id, billable_feature_id, billable_feature_subtype, billable_interval_type)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan_billable_metric ( - rate_plan_id INT UNSIGNED NOT NULL, - vendor_type VARCHAR(128) NOT NULL, - metric_name VARCHAR(128) NOT NULL, - metric_unit VARCHAR(32) NULL DEFAULT NULL, - metric_type VARCHAR(32) NULL DEFAULT NULL, - billing_scheme VARCHAR(64) NOT NULL, - billing_scheme_details LONGTEXT NULL DEFAULT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (rate_plan_id, infrastructure_region_id, vendor_type, metric_name, billing_scheme)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_rate_plan_billable_event ( - rate_plan_id INT UNSIGNED NOT NULL, - billable_feature_id INT UNSIGNED NOT NULL, - billable_feature_subtype VARCHAR(128) NOT NULL, - event_type VARCHAR(128) NOT NULL, - charge VARCHAR(100) NOT NULL, - billing_scheme_details LONGTEXT NULL DEFAULT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (rate_plan_id, infrastructure_region_id, billable_feature_id, billable_feature_subtype, event_type)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_region ( - region_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - region_name VARCHAR(128) NOT NULL, - region_type VARCHAR(64) NOT NULL, - parent_region_id INT UNSIGNED NULL DEFAULT NULL, - PRIMARY KEY (region_id), - UNIQUE INDEX ix_region_1 (parent_region_id, region_type, region_name ASC), - INDEX ix_region_2 (parent_region_id)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_resource_configuration_history ( - resource_id INT UNSIGNED NOT NULL, - resource_name VARCHAR(512) NULL DEFAULT NULL, - resource_foreign_id VARCHAR(146) NULL DEFAULT NULL, - resource_configuration LONGTEXT NOT NULL, - start_date DATETIME(6) NOT NULL, - end_date DATETIME(6) NOT NULL, - customer_id LONGTEXT NULL DEFAULT NULL, - customer_foreign_id VARCHAR(146) NULL DEFAULT NULL, - customer_name VARCHAR(512) NULL DEFAULT NULL, - resource_manager_id VARCHAR(72) NULL DEFAULT NULL, - resource_manager_name VARCHAR(512) NULL DEFAULT NULL, - resource_manager_foreign_id VARCHAR(72) NULL DEFAULT NULL) -ENGINE = InnoDB -DEFAULT CHARACTER SET = 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) NULL DEFAULT NULL, - resource_name VARCHAR(256) NULL DEFAULT NULL, - resource_foreign_id VARCHAR(512) NULL DEFAULT NULL, - customer_id VARCHAR(36) NULL DEFAULT NULL, - customer_name VARCHAR(512) NULL DEFAULT NULL, - customer_foreign_id VARCHAR(512) NULL DEFAULT NULL, - resource_manager_id VARCHAR(36) NOT NULL, - resource_manager_foreign_id VARCHAR(512) NULL DEFAULT NULL, - infrastructure_region_id INT UNSIGNED NULL DEFAULT NULL, - management_region_id INT UNSIGNED NULL DEFAULT NULL, - PRIMARY KEY (resource_manager_id, event_id), - INDEX ix_vm_event_1 (resource_foreign_id(255) ASC, event_date ASC), - INDEX ix_vm_event_2 (customer_id ASC), - INDEX ix_vm_event_3 (resource_name(255), event_date DESC), - INDEX ix_vm_event_4 (resource_manager_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_resource_group ( - resource_group_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - resource_group_name VARCHAR(512) NOT NULL, - resource_group_type VARCHAR(64) NULL DEFAULT NULL, - customer_id INT UNSIGNED NOT NULL, - parent_id INT UNSIGNED NOT NULL, - parent_type VARCHAR(64) NOT NULL, - PRIMARY KEY (resource_group_id), - INDEX ix_resource_group_1 (parent_id ASC), - INDEX ix_resource_group_2 (customer_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_resource_in_use_interval ( - resource_id VARCHAR(36) NULL DEFAULT NULL, - resource_name VARCHAR(512) NULL DEFAULT NULL, - resource_foreign_id LONGTEXT NULL DEFAULT NULL, - interval_type VARCHAR(64) NOT NULL, - start_date DATETIME(6) NOT NULL, - end_date DATETIME(6) NOT NULL, - interval_length_milliseconds BIGINT(20) NULL DEFAULT NULL, - resource_manager_id VARCHAR(36) NULL DEFAULT NULL, - resource_manager_name VARCHAR(512) NULL DEFAULT NULL, - resource_manager_foreign_id VARCHAR(512) NULL DEFAULT NULL, - customer_id VARCHAR(36) NULL DEFAULT NULL, - customer_name VARCHAR(512) NULL DEFAULT NULL, - customer_foreign_id VARCHAR(512) NULL DEFAULT NULL, - management_region_id INT UNSIGNED NOT NULL, - PRIMARY KEY (resource_id, interval_type, start_date, end_date), - INDEX ix_resource_in_use_interval_1 (resource_name(255) ASC), - INDEX ix_resource_in_use_interval_2 (customer_name(255) ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_resource_manager ( - resource_manager_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - resource_manager_name VARCHAR(512) NOT NULL, - resource_manager_description VARCHAR(1024) NULL DEFAULT NULL, - resource_manager_vendor_type VARCHAR(64) NULL DEFAULT NULL, - resource_manager_foreign_id VARCHAR(512) NULL DEFAULT NULL, - metadata LONGTEXT NULL DEFAULT NULL, - last_metric_sync_times VARCHAR(5120) NULL DEFAULT NULL, - last_entity_sync_times VARCHAR(5120) NULL DEFAULT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL, - PRIMARY KEY (resource_manager_id)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_resource_manager_sync_times ( - resource_manager_id INT UNSIGNED NOT NULL, - sync_time_key VARCHAR(255) NOT NULL, - sync_time VARCHAR(255) NOT NULL, - PRIMARY KEY (resource_manager_id, sync_time_key)) -ENGINE=InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_usage_metric ( - resource_id INT UNSIGNED NULL DEFAULT 0, - resource_foreign_id VARCHAR(255) NOT NULL, - resource_name VARCHAR(256) NULL DEFAULT NULL, - resource_type VARCHAR(256) NULL DEFAULT NULL, - metric_name VARCHAR(128) NOT NULL, - metric_interval VARCHAR(64) NULL DEFAULT 600, - collection_time DATETIME(6) NOT NULL, - collection_hour varchar(10) NOT NULL, - metric_value DOUBLE NOT NULL, - metric_unit VARCHAR(64) NOT NULL, - customer_id INT UNSIGNED NOT NULL, - customer_name VARCHAR(256) NULL DEFAULT NULL, - customer_foreign_id VARCHAR(255) NULL DEFAULT NULL, - resource_manager_id INT UNSIGNED NOT NULL, - infrastructure_region_id INT UNSIGNED NOT NULL, - management_region_id INT UNSIGNED NOT NULL, - PRIMARY KEY (resource_foreign_id, metric_name, collection_time), - INDEX ix_usage_metrics_2 (customer_id, collection_time, resource_foreign_id, metric_name)) - ENGINE = InnoDB - DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_user_permissions ( - user_id INT UNSIGNED NOT NULL, - permission LONGTEXT NOT NULL, - PRIMARY KEY (user_id, permission(255))) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_user_roles ( - user_id INT UNSIGNED NOT NULL, - role_name VARCHAR(128) NOT NULL, - role_context INT UNSIGNED NOT NULL, - context_type VARCHAR(64) NOT NULL, - UNIQUE INDEX (user_id, role_name, role_context, context_type)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_users ( - user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - username VARCHAR(128) NOT NULL, - first_name VARCHAR(256) NULL DEFAULT NULL, - last_name VARCHAR(256) NULL DEFAULT NULL, - email_address VARCHAR(512) NULL DEFAULT NULL, - phone_number VARCHAR(64) NULL DEFAULT NULL, - password VARCHAR(512) NOT NULL, - is_active TINYINT(1) NULL DEFAULT NULL, - password_change_token VARCHAR(64) NULL, - last_password_change_date DATETIME(6) NULL, - password_change_token_expire_date DATETIME(6) NULL, - PRIMARY KEY (user_id), - UNIQUE INDEX (username)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_unbilled_charges ( - invoice_id INT UNSIGNED NOT NULL AUTO_INCREMENT, - payer_id INT UNSIGNED NOT NULL, - payer_type VARCHAR(64) NOT NULL, - payer_name VARCHAR(512) NOT NULL, - invoice_number VARCHAR(45) 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) NULL, - management_region_id INT UNSIGNED NOT NULL, - PRIMARY KEY (invoice_id), - INDEX t_unbilled_charges_1 (management_region_id, payer_type, payer_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - -CREATE TABLE t_unbilled_charges_detail ( - invoice_id INT UNSIGNED NOT NULL, - customer_id INT UNSIGNED NOT NULL, - resource_group_id VARCHAR(36) NULL, - invoice_group VARCHAR(128) NULL, - item_name VARCHAR(512) NULL, - item_vendor_type VARCHAR(128) NULL, - item_type VARCHAR(128) NOT NULL, - item_subtype VARCHAR(128) NOT NULL, - item_description VARCHAR(512) NOT NULL, - rate_plan_id VARCHAR(36) NULL, - rate_plan_billable_feature_id VARCHAR(36) NULL DEFAULT NULL, - billing_interval VARCHAR(64) NULL DEFAULT NULL, - item_invoice_amount DECIMAL(19,2) NOT NULL, - num_units VARCHAR(32) NOT NULL, - num_units_unit VARCHAR(16) NULL, - INDEX ix_unbilled_charges_detail_1 (invoice_id ASC), - INDEX ix_unbilled_charges_detail_2 (customer_id ASC), - INDEX ix_unbilled_charges_detail_3 (item_vendor_type, item_type, item_subtype ASC), - INDEX ix_unbilled_charges_detail_4 (rate_plan_id ASC)) -ENGINE = InnoDB -DEFAULT CHARACTER SET = utf8; - --- ----------------------------------------------------- --- Views --- ----------------------------------------------------- - -CREATE VIEW v_invoice_detail AS SELECT - i.*, - c.customer_name - FROM - (t_invoice_detail i - LEFT JOIN t_customer c ON ((i.customer_id = c.customer_id))); - -CREATE VIEW v_customer AS SELECT - c.*, - r1.region_name as management_region_name, - r2.region_name as infrastructure_region_name - FROM - (t_customer c - LEFT JOIN t_region r1 ON (c.management_region_id = r1.region_id) - LEFT JOIN t_region r2 ON (c.infrastructure_region_id = r2.region_id)); - -CREATE VIEW v_rate_plan_assignment AS SELECT - a.*, - r.management_region_id - FROM - (t_rate_plan_assignment a - LEFT JOIN t_rate_plan r ON (a.rate_plan_id = r.rate_plan_id)); - -CREATE VIEW v_users AS SELECT - u.*, - r.role_name, - r.role_context - FROM - (t_users u - LEFT JOIN t_user_roles r ON (u.user_id = r.user_id)); - -CREATE VIEW v_provider AS SELECT - t_provider.*, - t_region.parent_region_id as parent_management_region_id - FROM - (t_provider - LEFT JOIN t_region ON (t_region.region_id = t_provider.management_region_id)); - -CREATE VIEW v_provider_region AS SELECT - t_region.*, - t_provider_region.provider_id - FROM - (t_region - LEFT JOIN t_provider_region ON (t_region.region_id = t_provider_region.region_id)); - -CREATE VIEW v_unbilled_charges_detail AS SELECT - i.*, - c.customer_name - FROM - (t_unbilled_charges_detail i - LEFT JOIN t_customer c ON ((i.customer_id = c.customer_id))); - -commit; - -SET SQL_MODE=@OLD_SQL_MODE; -SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; -SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; - --- ----------------------------------------------------- --- Recreate workflow schema and tables. --- ----------------------------------------------------- - -DROP SCHEMA IF EXISTS openbook_workflow; -CREATE SCHEMA openbook_workflow DEFAULT CHARACTER SET utf8; - -GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -FLUSH PRIVILEGES; - -USE openbook_workflow; - -create table ACT_GE_PROPERTY ( - NAME_ varchar(64), - VALUE_ varchar(300), - REV_ integer, - primary key (NAME_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -insert into ACT_GE_PROPERTY -values ('schema.version', '5.20.0.1', 1); - -insert into ACT_GE_PROPERTY -values ('schema.history', 'create(5.20.0.1)', 1); - -insert into ACT_GE_PROPERTY -values ('next.dbid', '1', 1); - -create table ACT_GE_BYTEARRAY ( - ID_ varchar(64), - REV_ integer, - NAME_ varchar(255), - DEPLOYMENT_ID_ varchar(64), - BYTES_ LONGBLOB, - GENERATED_ TINYINT, - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RE_DEPLOYMENT ( - ID_ varchar(64), - NAME_ varchar(255), - CATEGORY_ varchar(255), - TENANT_ID_ varchar(255) default '', - DEPLOY_TIME_ timestamp(3) NULL, - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RE_MODEL ( - ID_ varchar(64) not null, - REV_ integer, - NAME_ varchar(255), - KEY_ varchar(255), - CATEGORY_ varchar(255), - CREATE_TIME_ timestamp(3) null, - LAST_UPDATE_TIME_ timestamp(3) null, - VERSION_ integer, - META_INFO_ varchar(4000), - DEPLOYMENT_ID_ varchar(64), - EDITOR_SOURCE_VALUE_ID_ varchar(64), - EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64), - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RU_EXECUTION ( - ID_ varchar(64), - REV_ integer, - PROC_INST_ID_ varchar(64), - BUSINESS_KEY_ varchar(255), - PARENT_ID_ varchar(64), - PROC_DEF_ID_ varchar(64), - SUPER_EXEC_ varchar(64), - ACT_ID_ varchar(255), - IS_ACTIVE_ TINYINT, - IS_CONCURRENT_ TINYINT, - IS_SCOPE_ TINYINT, - IS_EVENT_SCOPE_ TINYINT, - SUSPENSION_STATE_ integer, - CACHED_ENT_STATE_ integer, - TENANT_ID_ varchar(255) default '', - NAME_ varchar(255), - LOCK_TIME_ timestamp(3) NULL, - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RU_JOB ( - ID_ varchar(64) NOT NULL, - REV_ integer, - TYPE_ varchar(255) NOT NULL, - LOCK_EXP_TIME_ timestamp(3) NULL, - LOCK_OWNER_ varchar(255), - EXCLUSIVE_ boolean, - EXECUTION_ID_ varchar(64), - PROCESS_INSTANCE_ID_ varchar(64), - PROC_DEF_ID_ varchar(64), - RETRIES_ integer, - EXCEPTION_STACK_ID_ varchar(64), - EXCEPTION_MSG_ varchar(4000), - DUEDATE_ timestamp(3) NULL, - REPEAT_ varchar(255), - HANDLER_TYPE_ varchar(255), - HANDLER_CFG_ varchar(4000), - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RE_PROCDEF ( - ID_ varchar(64) not null, - REV_ integer, - CATEGORY_ varchar(255), - NAME_ varchar(255), - KEY_ varchar(255) not null, - VERSION_ integer not null, - DEPLOYMENT_ID_ varchar(64), - RESOURCE_NAME_ varchar(4000), - DGRM_RESOURCE_NAME_ varchar(4000), - DESCRIPTION_ varchar(4000), - HAS_START_FORM_KEY_ TINYINT, - HAS_GRAPHICAL_NOTATION_ TINYINT, - SUSPENSION_STATE_ integer, - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; -create table ACT_RU_TASK ( - ID_ varchar(64), - REV_ integer, - EXECUTION_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - PROC_DEF_ID_ varchar(64), - NAME_ varchar(255), - PARENT_TASK_ID_ varchar(64), - DESCRIPTION_ varchar(4000), - TASK_DEF_KEY_ varchar(255), - OWNER_ varchar(255), - ASSIGNEE_ varchar(255), - DELEGATION_ varchar(64), - PRIORITY_ integer, - CREATE_TIME_ timestamp(3) NULL, - DUE_DATE_ datetime(3), - CATEGORY_ varchar(255), - SUSPENSION_STATE_ integer, - TENANT_ID_ varchar(255) default '', - FORM_KEY_ varchar(255), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; +USE `openbook`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `DATABASECHANGELOG` ( + `ID` varchar(255) NOT NULL, + `AUTHOR` varchar(255) NOT NULL, + `FILENAME` varchar(255) 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 +) 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` bit(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 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 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 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 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 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 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=101 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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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, + `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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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, + `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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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, + `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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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 `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) 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 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_product` ( + `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `product_name` varchar(64) NOT NULL, + `product_type` varchar(16) NOT NULL, + `base_entity_id` int(10) unsigned DEFAULT NULL, + `product_group` varchar(64) NOT NULL, + `product_details` text DEFAULT NULL, + `active_product` tinyint(4) NOT NULL, + `public_product` tinyint(4) NOT NULL, + `management_region_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`product_id`) +) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_promo_code` ( + `management_region_id` int(10) unsigned NOT NULL, + `promo_code_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `promo_code` varchar(128) NOT NULL, + `salesperson` varchar(128) DEFAULT NULL, + `discount_or_credit` varchar(8) NOT NULL, + `credit_amount` decimal(19,2) DEFAULT NULL, + `credit_type` varchar(16) DEFAULT NULL, + `apply_to_charge_category` varchar(32) DEFAULT NULL, + `trigger_charge_category` varchar(32) DEFAULT NULL, + `trigger_amount` decimal(19,2) DEFAULT NULL, + `discount_percent` decimal(5,2) DEFAULT NULL, + `available_invoice_periods` int(11) DEFAULT NULL, + `expire_date` datetime(6) DEFAULT NULL, + `currency` varchar(3) DEFAULT NULL, + PRIMARY KEY (`promo_code_id`), + UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`), + KEY `ix_promo_code_1` (`promo_code`), + KEY `ix_promo_code_2` (`salesperson`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_promo_code_redemption` ( + `promo_code_id` int(10) unsigned NOT NULL, + `payer_id` int(10) unsigned NOT NULL, + `payer_type` varchar(64) NOT NULL, + `redemption_date` datetime(6) DEFAULT NULL, + PRIMARY KEY (`payer_id`,`promo_code_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_properties_schema` ( + `property_group` varchar(128) NOT NULL, + `property_name` varchar(128) NOT NULL, + `default_value` text DEFAULT NULL, + `form_label` varchar(1024) NOT NULL, + `form_order` smallint(6) NOT NULL, + `data_type` varchar(16) NOT NULL, + `data_format` varchar(32) DEFAULT NULL, + `permitted_values` text DEFAULT NULL, + `required` tinyint(4) NOT NULL DEFAULT 0, + `description` varchar(2048) DEFAULT NULL, + PRIMARY KEY (`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` ( + `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 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 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 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=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_resource_event` ( + `event_id` varchar(100) NOT NULL, + `event_type` varchar(128) NOT NULL, + `event_date` datetime(6) NOT NULL, + `resource_id` varchar(36) DEFAULT NULL, + `resource_name` varchar(256) DEFAULT NULL, + `resource_foreign_id` varchar(512) DEFAULT NULL, + `customer_id` varchar(36) DEFAULT NULL, + `customer_name` varchar(512) DEFAULT NULL, + `tenant_foreign_id` varchar(512) DEFAULT NULL, + `service_manager_id` int(10) unsigned NOT NULL, + `service_region_id` int(10) unsigned DEFAULT NULL, + `management_region_id` int(10) unsigned DEFAULT NULL, + `tenant_id` int(10) unsigned DEFAULT NULL, + `tenant_name` varchar(512) DEFAULT NULL, + PRIMARY KEY (`service_manager_id`,`event_id`), + KEY `ix_vm_event_1` (`resource_foreign_id`(255),`event_date`), + KEY `ix_vm_event_2` (`customer_id`), + KEY `ix_vm_event_3` (`resource_name`(255),`event_date`), + KEY `ix_vm_event_4` (`service_manager_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_resource_group` ( + `resource_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `resource_group_name` varchar(512) NOT NULL, + `resource_group_type` varchar(64) DEFAULT NULL, + `customer_id` int(10) unsigned NOT NULL, + `parent_id` int(10) unsigned NOT NULL, + `parent_type` varchar(64) NOT NULL, + PRIMARY KEY (`resource_group_id`), + KEY `ix_resource_group_1` (`parent_id`), + KEY `ix_resource_group_2` (`customer_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_service` ( + `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `service_type` varchar(128) NOT NULL, + `service_description` longtext DEFAULT NULL, + `service_manager_type_id` int(10) unsigned DEFAULT NULL, + `states` text DEFAULT NULL, + `externally_managed` tinyint(4) NOT NULL DEFAULT 1, + PRIMARY KEY (`service_id`), + UNIQUE KEY `ix_service_1` (`service_manager_type_id`,`service_type`) +) ENGINE=InnoDB AUTO_INCREMENT=29 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 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, + `customer_name` varchar(255) DEFAULT NULL, + `tenant_id` int(10) unsigned NOT NULL, + `tenant_name` varchar(255) DEFAULT NULL, + `management_region_id` varchar(128) NOT NULL, + `service_manager_id` int(10) unsigned NOT NULL, + `service_manager_name` varchar(256) NOT NULL, + `service_region_id` int(10) unsigned NOT NULL, + `service_region_name` varchar(128) NOT NULL, + `aggregate_category` varchar(128) NOT NULL, + `aggregate_name` varchar(128) NOT NULL, + `aggregate_type` varchar(64) NOT NULL, + `aggregate_value` int(11) NOT NULL, + `aggregate_interval` varchar(32) NOT NULL, + `aggregate_datetime` datetime(6) NOT NULL, + PRIMARY KEY (`management_region_id`,`customer_id`,`service_manager_id`,`tenant_id`,`service_region_id`,`aggregate_category`,`aggregate_name`,`aggregate_type`,`aggregate_interval`,`aggregate_datetime`), + KEY `ix_service_instance_aggregates_2` (`service_manager_id`,`service_region_id`,`aggregate_datetime`,`aggregate_name`), + KEY `ix_service_instance_aggregates_3` (`customer_id`,`tenant_id`,`aggregate_datetime`,`aggregate_name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!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 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=11 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_tenant` ( + `tenant_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `tenant_name` varchar(512) NOT NULL, + `tenant_foreign_id` varchar(512) DEFAULT NULL, + `create_date` datetime(6) NOT NULL, + `deactivate_date` datetime(6) DEFAULT NULL, + `customer_id` int(10) unsigned DEFAULT NULL, + `service_manager_id` int(10) unsigned NOT NULL, + `is_active` tinyint(4) NOT NULL DEFAULT 0, + KEY `ix_tenant_1` (`tenant_id`), + KEY `ix_tenant_2` (`customer_id`), + KEY `ix_tenant_3` (`service_manager_id`) +) ENGINE=InnoDB 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 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 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_user_permissions` ( + `user_id` int(10) unsigned NOT NULL, + `permission` longtext NOT NULL, + PRIMARY KEY (`user_id`,`permission`(255)) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_user_projects` ( + `user_projects_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `user_id` int(10) unsigned NOT NULL, + `user_foreign_id` varchar(128) NOT NULL, + `service_manager_id` int(10) unsigned NOT NULL, + `role_id` varchar(128) NOT NULL, + `role_name` varchar(128) NOT NULL, + `project_id` varchar(128) NOT NULL, + `add_date` datetime(6) NOT NULL, + `remove_date` datetime(6) NOT NULL, + PRIMARY KEY (`user_projects_id`), + KEY `ix_host_1` (`user_id`,`service_manager_id`,`role_id`,`project_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_user_roles` ( + `user_id` int(10) unsigned NOT NULL, + `role_name` varchar(128) NOT NULL, + `role_context` int(10) unsigned NOT NULL, + `context_type` varchar(64) NOT NULL, + UNIQUE KEY `user_id` (`user_id`,`role_name`,`role_context`,`context_type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_users` ( + `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `username` varchar(128) NOT NULL, + `first_name` varchar(256) DEFAULT NULL, + `last_name` varchar(256) DEFAULT NULL, + `email_address` varchar(512) DEFAULT NULL, + `phone_number` varchar(64) DEFAULT NULL, + `password` varchar(512) DEFAULT NULL, + `is_active` tinyint(1) DEFAULT NULL, + `password_change_token` varchar(64) DEFAULT NULL, + `last_password_change_date` datetime(6) DEFAULT NULL, + `password_change_token_expire_date` datetime(6) DEFAULT NULL, + `external` tinyint(1) DEFAULT 0, + PRIMARY KEY (`user_id`), + UNIQUE KEY `username` (`username`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_all_charges` ( + `invoice_id` tinyint NOT NULL, + `payer_id` tinyint NOT NULL, + `payer_type` tinyint NOT NULL, + `payer_name` tinyint NOT NULL, + `invoice_number` tinyint NOT NULL, + `invoice_date` tinyint NOT NULL, + `period_begin` tinyint NOT NULL, + `period_end` tinyint NOT NULL, + `invoice_amount` tinyint NOT NULL, + `actual_charges` tinyint NOT NULL, + `invoice_currency` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_all_charges_detail` ( + `invoice_id` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `rate` tinyint NOT NULL, + `rate_display` tinyint NOT NULL, + `rate_unit` tinyint NOT NULL, + `rate_interval` tinyint NOT NULL, + `rate_multiplier_percent` tinyint NOT NULL, + `units_billed` tinyint NOT NULL, + `units_billed_display` tinyint NOT NULL, + `item_invoice_amount` tinyint NOT NULL, + `item_category` tinyint NOT NULL, + `item_group` tinyint NOT NULL, + `item_type` tinyint NOT NULL, + `item_detail` tinyint NOT NULL, + `tenant_id` tinyint NOT NULL, + `tenant_name` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_current_host` ( + `host_id` tinyint NOT NULL, + `service_manager_id` tinyint NOT NULL, + `service_manager_name` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `region_name` tinyint NOT NULL, + `host_foreign_id` tinyint NOT NULL, + `host_name` tinyint NOT NULL, + `hypervisor_type` tinyint NOT NULL, + `host_aggregate` tinyint NOT NULL, + `add_date` tinyint NOT NULL, + `remove_date` tinyint NOT NULL, + `cpu_allocation_ratio` tinyint NOT NULL, + `ram_allocation_ratio` tinyint NOT NULL, + `disk_allocation_ratio` tinyint NOT NULL, + `update_date` tinyint NOT NULL, + `ram_mb` tinyint NOT NULL, + `ram_mb_used` tinyint NOT NULL, + `disk_gb` tinyint NOT NULL, + `disk_gb_used` tinyint NOT NULL, + `vcpus` tinyint NOT NULL, + `vcpus_used` tinyint NOT NULL, + `vm_count` tinyint NOT NULL, + `socket_count` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_current_host_attributes` ( + `host_id` tinyint NOT NULL, + `update_date` tinyint NOT NULL, + `ram_mb` tinyint NOT NULL, + `ram_mb_used` tinyint NOT NULL, + `disk_gb` tinyint NOT NULL, + `disk_gb_used` tinyint NOT NULL, + `vcpus` tinyint NOT NULL, + `vcpus_used` tinyint NOT NULL, + `vm_count` tinyint NOT NULL, + `socket_count` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_customer` ( + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `metadata` tinyint NOT NULL, + `tax_rate` tinyint NOT NULL, + `currency` tinyint NOT NULL, + `discount_percent` tinyint NOT NULL, + `billing_frequency` tinyint NOT NULL, + `last_bill_date` tinyint NOT NULL, + `next_bill_date` tinyint NOT NULL, + `is_active` tinyint NOT NULL, + `create_date` tinyint NOT NULL, + `activate_date` tinyint NOT NULL, + `billing_start_date` tinyint NOT NULL, + `last_payment_date` tinyint NOT NULL, + `deactivate_date` tinyint NOT NULL, + `description` tinyint NOT NULL, + `minimum_invoice_commitment` tinyint NOT NULL, + `invoicing_method` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `billing_address_line_1` tinyint NOT NULL, + `billing_address_line_2` tinyint NOT NULL, + `billing_address_city` tinyint NOT NULL, + `billing_address_region` tinyint NOT NULL, + `billing_address_country` tinyint NOT NULL, + `billing_address_postal_code` tinyint NOT NULL, + `payer_payment_details` tinyint NOT NULL, + `payment_method_confirmed` tinyint NOT NULL, + `balance_due` tinyint NOT NULL, + `spend_soft_limit` tinyint NOT NULL, + `spend_hard_limit` tinyint NOT NULL, + `terms_and_conditions_2_accept_date` tinyint NOT NULL, + `tax_id` tinyint NOT NULL, + `registration_number` tinyint NOT NULL, + `management_region_name` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_metric` ( + `metric_id` tinyint NOT NULL, + `service_manager_type_id` tinyint NOT NULL, + `metric_name` tinyint NOT NULL, + `metric_label` tinyint NOT NULL, + `metric_source` tinyint NOT NULL, + `metric_type` tinyint NOT NULL, + `metric_unit` tinyint NOT NULL, + `entity_resolution` tinyint NOT NULL, + `time_resolution` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_promo_code_redemption` ( + `management_region_id` tinyint NOT NULL, + `promo_code_id` tinyint NOT NULL, + `promo_code` tinyint NOT NULL, + `salesperson` tinyint NOT NULL, + `discount_or_credit` tinyint NOT NULL, + `credit_amount` tinyint NOT NULL, + `credit_type` tinyint NOT NULL, + `apply_to_charge_category` tinyint NOT NULL, + `trigger_charge_category` tinyint NOT NULL, + `trigger_amount` tinyint NOT NULL, + `discount_percent` tinyint NOT NULL, + `available_invoice_periods` tinyint NOT NULL, + `expire_date` tinyint NOT NULL, + `currency` tinyint NOT NULL, + `redemption_date` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_provider` ( + `provider_id` tinyint NOT NULL, + `provider_name` tinyint NOT NULL, + `provider_type` tinyint NOT NULL, + `metadata` tinyint NOT NULL, + `tax_rate` tinyint NOT NULL, + `currency` tinyint NOT NULL, + `discount_percent` tinyint NOT NULL, + `billing_frequency` tinyint NOT NULL, + `last_bill_date` tinyint NOT NULL, + `next_bill_date` tinyint NOT NULL, + `last_payment_date` tinyint NOT NULL, + `is_active` tinyint NOT NULL, + `create_date` tinyint NOT NULL, + `activate_date` tinyint NOT NULL, + `billing_start_date` tinyint NOT NULL, + `deactivate_date` tinyint NOT NULL, + `description` tinyint NOT NULL, + `minimum_invoice_commitment` tinyint NOT NULL, + `invoicing_method` tinyint NOT NULL, + `invoice_processing_method` tinyint NOT NULL, + `billing_address_line_1` tinyint NOT NULL, + `billing_address_line_2` tinyint NOT NULL, + `billing_address_city` tinyint NOT NULL, + `billing_address_region` tinyint NOT NULL, + `billing_address_country` tinyint NOT NULL, + `billing_address_postal_code` tinyint NOT NULL, + `legal_address_line_1` tinyint NOT NULL, + `legal_address_line_2` tinyint NOT NULL, + `legal_address_city` tinyint NOT NULL, + `legal_address_region` tinyint NOT NULL, + `legal_address_country` tinyint NOT NULL, + `legal_address_postal_code` tinyint NOT NULL, + `payer_payment_details` tinyint NOT NULL, + `payee_payment_details` tinyint NOT NULL, + `public_url` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `balance_due` tinyint NOT NULL, + `openbook_processes_payments` tinyint NOT NULL, + `openbook_processes_past_due_invoices` tinyint NOT NULL, + `openstack_tenant_id` tinyint NOT NULL, + `tax_id` tinyint NOT NULL, + `registration_number` tinyint NOT NULL, + `os_service_manager_id` tinyint NOT NULL, + `parent_management_region_id` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_rate_plan_assignment` ( + `rate_plan_id` tinyint NOT NULL, + `assignee_id` tinyint NOT NULL, + `assignee_type` tinyint NOT NULL, + `assignment_start_date` tinyint NOT NULL, + `assignment_end_date` tinyint NOT NULL, + `assignment_type` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_service` ( + `service_id` tinyint NOT NULL, + `service_type` tinyint NOT NULL, + `service_description` tinyint NOT NULL, + `service_manager_type_id` tinyint NOT NULL, + `states` tinyint NOT NULL, + `externally_managed` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_service_instance` ( + `service_instance_id` tinyint NOT NULL, + `service_id` tinyint NOT NULL, + `service_instance_name` tinyint NOT NULL, + `service_manager_id` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `service_instance_foreign_id` tinyint NOT NULL, + `tenant_id` tinyint NOT NULL, + `current_attributes` tinyint NOT NULL, + `tenant_name` tinyint NOT NULL, + `tenant_foreign_id` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `service_manager_name` tinyint NOT NULL, + `service_region_name` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL, + `service_type` tinyint NOT NULL, + `provisioned_date` tinyint NOT NULL, + `deprovisioned_date` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_service_instance_attributes` ( + `service_instance_id` tinyint NOT NULL, + `start_date` tinyint NOT NULL, + `end_date` tinyint NOT NULL, + `attributes` tinyint NOT NULL, + `tenant_id` tinyint NOT NULL, + `tenant_foreign_id` tinyint NOT NULL, + `tenant_name` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `service_instance_name` tinyint NOT NULL, + `service_instance_foreign_id` tinyint NOT NULL, + `service_manager_id` tinyint NOT NULL, + `service_manager_name` tinyint NOT NULL, + `service_id` tinyint NOT NULL, + `service_type` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `service_region_name` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_service_instance_state` ( + `service_instance_id` tinyint NOT NULL, + `state` tinyint NOT NULL, + `start_date` tinyint NOT NULL, + `end_date` tinyint NOT NULL, + `interval_length_milliseconds` tinyint NOT NULL, + `tenant_id` tinyint NOT NULL, + `tenant_foreign_id` tinyint NOT NULL, + `tenant_name` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `service_instance_name` tinyint NOT NULL, + `service_instance_foreign_id` tinyint NOT NULL, + `service_manager_id` tinyint NOT NULL, + `service_manager_name` tinyint NOT NULL, + `service_id` tinyint NOT NULL, + `service_type` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `service_region_name` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_service_manager` ( + `service_manager_id` tinyint NOT NULL, + `service_manager_name` tinyint NOT NULL, + `service_manager_description` tinyint NOT NULL, + `metadata` tinyint NOT NULL, + `service_region_id` tinyint NOT NULL, + `service_manager_type_id` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_tenant` ( + `tenant_id` tinyint NOT NULL, + `tenant_name` tinyint NOT NULL, + `tenant_foreign_id` tinyint NOT NULL, + `create_date` tinyint NOT NULL, + `deactivate_date` tinyint NOT NULL, + `customer_id` tinyint NOT NULL, + `service_manager_id` tinyint NOT NULL, + `is_active` tinyint NOT NULL, + `customer_name` tinyint NOT NULL, + `management_region_id` tinyint NOT NULL, + `service_manager_type` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_users` ( + `user_id` tinyint NOT NULL, + `username` tinyint NOT NULL, + `first_name` tinyint NOT NULL, + `last_name` tinyint NOT NULL, + `email_address` tinyint NOT NULL, + `phone_number` tinyint NOT NULL, + `password` tinyint NOT NULL, + `is_active` tinyint NOT NULL, + `password_change_token` tinyint NOT NULL, + `last_password_change_date` tinyint NOT NULL, + `password_change_token_expire_date` tinyint NOT NULL, + `role_name` tinyint NOT NULL, + `role_context` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */; + +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; + +USE `openbook_jobs`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_BLOB_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `BLOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_CALENDARS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `CALENDAR_NAME` varchar(200) NOT NULL, + `CALENDAR` blob NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_CRON_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `CRON_EXPRESSION` varchar(120) NOT NULL, + `TIME_ZONE_ID` varchar(80) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_FIRED_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `ENTRY_ID` varchar(95) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `INSTANCE_NAME` varchar(200) NOT NULL, + `FIRED_TIME` bigint(13) NOT NULL, + `SCHED_TIME` bigint(13) NOT NULL, + `PRIORITY` int(11) NOT NULL, + `STATE` varchar(16) NOT NULL, + `JOB_NAME` varchar(200) DEFAULT NULL, + `JOB_GROUP` varchar(200) DEFAULT NULL, + `IS_NONCONCURRENT` varchar(1) DEFAULT NULL, + `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), + KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), + KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_JOB_DETAILS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `JOB_NAME` varchar(200) NOT NULL, + `JOB_GROUP` varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + `JOB_CLASS_NAME` varchar(250) NOT NULL, + `IS_DURABLE` varchar(1) NOT NULL, + `IS_NONCONCURRENT` varchar(1) NOT NULL, + `IS_UPDATE_DATA` varchar(1) NOT NULL, + `REQUESTS_RECOVERY` varchar(1) NOT NULL, + `JOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_LOCKS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `LOCK_NAME` varchar(40) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SCHEDULER_STATE` ( + `SCHED_NAME` varchar(120) NOT NULL, + `INSTANCE_NAME` varchar(200) NOT NULL, + `LAST_CHECKIN_TIME` bigint(13) NOT NULL, + `CHECKIN_INTERVAL` bigint(13) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `REPEAT_COUNT` bigint(7) NOT NULL, + `REPEAT_INTERVAL` bigint(12) NOT NULL, + `TIMES_TRIGGERED` bigint(10) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `STR_PROP_1` varchar(512) DEFAULT NULL, + `STR_PROP_2` varchar(512) DEFAULT NULL, + `STR_PROP_3` varchar(512) DEFAULT NULL, + `INT_PROP_1` int(11) DEFAULT NULL, + `INT_PROP_2` int(11) DEFAULT NULL, + `LONG_PROP_1` bigint(20) DEFAULT NULL, + `LONG_PROP_2` bigint(20) DEFAULT NULL, + `DEC_PROP_1` decimal(13,4) DEFAULT NULL, + `DEC_PROP_2` decimal(13,4) DEFAULT NULL, + `BOOL_PROP_1` varchar(1) DEFAULT NULL, + `BOOL_PROP_2` varchar(1) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `JOB_NAME` varchar(200) NOT NULL, + `JOB_GROUP` varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, + `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, + `PRIORITY` int(11) DEFAULT NULL, + `TRIGGER_STATE` varchar(16) NOT NULL, + `TRIGGER_TYPE` varchar(8) NOT NULL, + `START_TIME` bigint(13) NOT NULL, + `END_TIME` bigint(13) DEFAULT NULL, + `CALENDAR_NAME` varchar(200) DEFAULT NULL, + `MISFIRE_INSTR` smallint(2) DEFAULT NULL, + `JOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), + KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_workflow` /*!40100 DEFAULT CHARACTER SET utf8 */; + +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; + +USE `openbook_workflow`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_EVT_LOG` ( + `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT, + `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT current_timestamp(3) ON UPDATE current_timestamp(3), + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DATA_` longblob DEFAULT NULL, + `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, + `IS_PROCESSED_` tinyint(4) DEFAULT 0, + PRIMARY KEY (`LOG_NR_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_GE_BYTEARRAY` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BYTES_` longblob DEFAULT NULL, + `GENERATED_` tinyint(4) DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), + CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_GE_PROPERTY` ( + `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, + `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + PRIMARY KEY (`NAME_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_ACTINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_TIME_` datetime(3) NOT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`), + KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`), + KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`), + KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_ATTACHMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TIME_` datetime(3) DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_COMMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TIME_` datetime(3) NOT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `FULL_MSG_` longblob DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_DETAIL` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + `TIME_` datetime(3) NOT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`), + KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`), + KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`), + KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_IDENTITYLINK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_PROCINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `START_TIME_` datetime(3) NOT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`), + KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_TASKINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_TIME_` datetime(3) NOT NULL, + `CLAIM_TIME_` datetime(3) DEFAULT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `PRIORITY_` int(11) DEFAULT NULL, + `DUE_DATE_` datetime(3) DEFAULT NULL, + `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_VARINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `CREATE_TIME_` datetime(3) DEFAULT NULL, + `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`), + KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_GROUP` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_INFO` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PASSWORD_` longblob DEFAULT NULL, + `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_MEMBERSHIP` ( + `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + PRIMARY KEY (`USER_ID_`,`GROUP_ID_`), + KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`), + CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`), + CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_USER` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_PROCDEF_INFO` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`), + KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`), + KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`), + CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_DEPLOYMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_MODEL` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `VERSION_` int(11) DEFAULT NULL, + `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`), + KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`), + KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`), + CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`), + CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_PROCDEF` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin NOT NULL, + `VERSION_` int(11) NOT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL, + `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_EVENT_SUBSCR` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CREATED_` timestamp(3) NOT NULL DEFAULT current_timestamp(3), + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`), + KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`), + CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_EXECUTION` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `IS_ACTIVE_` tinyint(4) DEFAULT NULL, + `IS_CONCURRENT_` tinyint(4) DEFAULT NULL, + `IS_SCOPE_` tinyint(4) DEFAULT NULL, + `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `CACHED_ENT_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`), + KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`), + KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`), + KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`), + CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_IDENTITYLINK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`), + KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`), + KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`), + KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`), + KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`), + CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_JOB` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, + `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EXCLUSIVE_` tinyint(1) DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `RETRIES_` int(11) DEFAULT NULL, + `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DUEDATE_` timestamp(3) NULL DEFAULT NULL, + `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`), + CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_TASK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PRIORITY_` int(11) DEFAULT NULL, + `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `DUE_DATE_` datetime(3) DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`), + KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`), + KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`), + CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_VARIABLE` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`), + KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`), + KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`), + CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; -create table ACT_RU_IDENTITYLINK ( - ID_ varchar(64), - REV_ integer, - GROUP_ID_ varchar(255), - TYPE_ varchar(255), - USER_ID_ varchar(255), - TASK_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - PROC_DEF_ID_ varchar(64), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RU_VARIABLE ( - ID_ varchar(64) not null, - REV_ integer, - TYPE_ varchar(255) not null, - NAME_ varchar(255) not null, - EXECUTION_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - TASK_ID_ varchar(64), - BYTEARRAY_ID_ varchar(64), - DOUBLE_ double, - LONG_ bigint, - TEXT_ varchar(4000), - TEXT2_ varchar(4000), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_RU_EVENT_SUBSCR ( - ID_ varchar(64) not null, - REV_ integer, - EVENT_TYPE_ varchar(255) not null, - EVENT_NAME_ varchar(255), - EXECUTION_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - ACTIVITY_ID_ varchar(64), - CONFIGURATION_ varchar(255), - CREATED_ timestamp(3) not null DEFAULT CURRENT_TIMESTAMP(3), - PROC_DEF_ID_ varchar(64), - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_EVT_LOG ( - LOG_NR_ bigint auto_increment, - TYPE_ varchar(64), - PROC_DEF_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - EXECUTION_ID_ varchar(64), - TASK_ID_ varchar(64), - TIME_STAMP_ timestamp(3) not null, - USER_ID_ varchar(255), - DATA_ LONGBLOB, - LOCK_OWNER_ varchar(255), - LOCK_TIME_ timestamp(3) null, - IS_PROCESSED_ tinyint default 0, - primary key (LOG_NR_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_PROCDEF_INFO ( - ID_ varchar(64) not null, - PROC_DEF_ID_ varchar(64) not null, - REV_ integer, - INFO_JSON_ID_ varchar(64), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_); -create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_); -create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_); -create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_); -create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_); -create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_); -create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_); -create index ACT_IDX_INFO_PROCDEF on ACT_PROCDEF_INFO(PROC_DEF_ID_); - -alter table ACT_GE_BYTEARRAY - add constraint ACT_FK_BYTEARR_DEPL -foreign key (DEPLOYMENT_ID_) -references ACT_RE_DEPLOYMENT (ID_); - -alter table ACT_RE_PROCDEF - add constraint ACT_UNIQ_PROCDEF -unique (KEY_,VERSION_, TENANT_ID_); - -alter table ACT_RU_EXECUTION - add constraint ACT_FK_EXE_PROCINST -foreign key (PROC_INST_ID_) -references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade; - -alter table ACT_RU_EXECUTION - add constraint ACT_FK_EXE_PARENT -foreign key (PARENT_ID_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_EXECUTION - add constraint ACT_FK_EXE_SUPER -foreign key (SUPER_EXEC_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_EXECUTION - add constraint ACT_FK_EXE_PROCDEF -foreign key (PROC_DEF_ID_) -references ACT_RE_PROCDEF (ID_); - -alter table ACT_RU_IDENTITYLINK - add constraint ACT_FK_TSKASS_TASK -foreign key (TASK_ID_) -references ACT_RU_TASK (ID_); - -alter table ACT_RU_IDENTITYLINK - add constraint ACT_FK_ATHRZ_PROCEDEF -foreign key (PROC_DEF_ID_) -references ACT_RE_PROCDEF(ID_); - -alter table ACT_RU_IDENTITYLINK - add constraint ACT_FK_IDL_PROCINST -foreign key (PROC_INST_ID_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_TASK - add constraint ACT_FK_TASK_EXE -foreign key (EXECUTION_ID_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_TASK - add constraint ACT_FK_TASK_PROCINST -foreign key (PROC_INST_ID_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_TASK - add constraint ACT_FK_TASK_PROCDEF -foreign key (PROC_DEF_ID_) -references ACT_RE_PROCDEF (ID_); - -alter table ACT_RU_VARIABLE - add constraint ACT_FK_VAR_EXE -foreign key (EXECUTION_ID_) -references ACT_RU_EXECUTION (ID_); - -alter table ACT_RU_VARIABLE - add constraint ACT_FK_VAR_PROCINST -foreign key (PROC_INST_ID_) -references ACT_RU_EXECUTION(ID_); - -alter table ACT_RU_VARIABLE - add constraint ACT_FK_VAR_BYTEARRAY -foreign key (BYTEARRAY_ID_) -references ACT_GE_BYTEARRAY (ID_); - -alter table ACT_RU_JOB - add constraint ACT_FK_JOB_EXCEPTION -foreign key (EXCEPTION_STACK_ID_) -references ACT_GE_BYTEARRAY (ID_); - -alter table ACT_RU_EVENT_SUBSCR - add constraint ACT_FK_EVENT_EXEC -foreign key (EXECUTION_ID_) -references ACT_RU_EXECUTION(ID_); - -alter table ACT_RE_MODEL - add constraint ACT_FK_MODEL_SOURCE -foreign key (EDITOR_SOURCE_VALUE_ID_) -references ACT_GE_BYTEARRAY (ID_); - -alter table ACT_RE_MODEL - add constraint ACT_FK_MODEL_SOURCE_EXTRA -foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) -references ACT_GE_BYTEARRAY (ID_); - -alter table ACT_RE_MODEL - add constraint ACT_FK_MODEL_DEPLOYMENT -foreign key (DEPLOYMENT_ID_) -references ACT_RE_DEPLOYMENT (ID_); - -alter table ACT_PROCDEF_INFO - add constraint ACT_FK_INFO_JSON_BA -foreign key (INFO_JSON_ID_) -references ACT_GE_BYTEARRAY (ID_); - -alter table ACT_PROCDEF_INFO - add constraint ACT_FK_INFO_PROCDEF -foreign key (PROC_DEF_ID_) -references ACT_RE_PROCDEF (ID_); - -alter table ACT_PROCDEF_INFO - add constraint ACT_UNIQ_INFO_PROCDEF -unique (PROC_DEF_ID_); - -create table ACT_HI_PROCINST ( - ID_ varchar(64) not null, - PROC_INST_ID_ varchar(64) not null, - BUSINESS_KEY_ varchar(255), - PROC_DEF_ID_ varchar(64) not null, - START_TIME_ datetime(3) not null, - END_TIME_ datetime(3), - DURATION_ bigint, - START_USER_ID_ varchar(255), - START_ACT_ID_ varchar(255), - END_ACT_ID_ varchar(255), - SUPER_PROCESS_INSTANCE_ID_ varchar(64), - DELETE_REASON_ varchar(4000), - TENANT_ID_ varchar(255) default '', - NAME_ varchar(255), - primary key (ID_), - unique (PROC_INST_ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_ACTINST ( - ID_ varchar(64) not null, - PROC_DEF_ID_ varchar(64) not null, - PROC_INST_ID_ varchar(64) not null, - EXECUTION_ID_ varchar(64) not null, - ACT_ID_ varchar(255) not null, - TASK_ID_ varchar(64), - CALL_PROC_INST_ID_ varchar(64), - ACT_NAME_ varchar(255), - ACT_TYPE_ varchar(255) not null, - ASSIGNEE_ varchar(255), - START_TIME_ datetime(3) not null, - END_TIME_ datetime(3), - DURATION_ bigint, - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_TASKINST ( - ID_ varchar(64) not null, - PROC_DEF_ID_ varchar(64), - TASK_DEF_KEY_ varchar(255), - PROC_INST_ID_ varchar(64), - EXECUTION_ID_ varchar(64), - NAME_ varchar(255), - PARENT_TASK_ID_ varchar(64), - DESCRIPTION_ varchar(4000), - OWNER_ varchar(255), - ASSIGNEE_ varchar(255), - START_TIME_ datetime(3) not null, - CLAIM_TIME_ datetime(3), - END_TIME_ datetime(3), - DURATION_ bigint, - DELETE_REASON_ varchar(4000), - PRIORITY_ integer, - DUE_DATE_ datetime(3), - FORM_KEY_ varchar(255), - CATEGORY_ varchar(255), - TENANT_ID_ varchar(255) default '', - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_VARINST ( - ID_ varchar(64) not null, - PROC_INST_ID_ varchar(64), - EXECUTION_ID_ varchar(64), - TASK_ID_ varchar(64), - NAME_ varchar(255) not null, - VAR_TYPE_ varchar(100), - REV_ integer, - BYTEARRAY_ID_ varchar(64), - DOUBLE_ double, - LONG_ bigint, - TEXT_ varchar(4000), - TEXT2_ varchar(4000), - CREATE_TIME_ datetime(3), - LAST_UPDATED_TIME_ datetime(3), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_DETAIL ( - ID_ varchar(64) not null, - TYPE_ varchar(255) not null, - PROC_INST_ID_ varchar(64), - EXECUTION_ID_ varchar(64), - TASK_ID_ varchar(64), - ACT_INST_ID_ varchar(64), - NAME_ varchar(255) not null, - VAR_TYPE_ varchar(255), - REV_ integer, - TIME_ datetime(3) not null, - BYTEARRAY_ID_ varchar(64), - DOUBLE_ double, - LONG_ bigint, - TEXT_ varchar(4000), - TEXT2_ varchar(4000), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_COMMENT ( - ID_ varchar(64) not null, - TYPE_ varchar(255), - TIME_ datetime(3) not null, - USER_ID_ varchar(255), - TASK_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - ACTION_ varchar(255), - MESSAGE_ varchar(4000), - FULL_MSG_ LONGBLOB, - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_ATTACHMENT ( - ID_ varchar(64) not null, - REV_ integer, - USER_ID_ varchar(255), - NAME_ varchar(255), - DESCRIPTION_ varchar(4000), - TYPE_ varchar(255), - TASK_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - URL_ varchar(4000), - CONTENT_ID_ varchar(64), - TIME_ datetime(3), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_HI_IDENTITYLINK ( - ID_ varchar(64), - GROUP_ID_ varchar(255), - TYPE_ varchar(255), - USER_ID_ varchar(255), - TASK_ID_ varchar(64), - PROC_INST_ID_ varchar(64), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - - -create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_); -create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_); -create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_); -create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_); -create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_); -create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_); -create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_); -create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_); -create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_); -create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_); -create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_); -create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_); -create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_); -create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_); -create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_); -create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_); -create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_); -create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_); - -create table ACT_ID_GROUP ( - ID_ varchar(64), - REV_ integer, - NAME_ varchar(255), - TYPE_ varchar(255), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_ID_MEMBERSHIP ( - USER_ID_ varchar(64), - GROUP_ID_ varchar(64), - primary key (USER_ID_, GROUP_ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_ID_USER ( - ID_ varchar(64), - REV_ integer, - FIRST_ varchar(255), - LAST_ varchar(255), - EMAIL_ varchar(255), - PWD_ varchar(255), - PICTURE_ID_ varchar(64), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -create table ACT_ID_INFO ( - ID_ varchar(64), - REV_ integer, - USER_ID_ varchar(64), - TYPE_ varchar(64), - KEY_ varchar(255), - VALUE_ varchar(255), - PASSWORD_ LONGBLOB, - PARENT_ID_ varchar(255), - primary key (ID_) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; - -alter table ACT_ID_MEMBERSHIP - add constraint ACT_FK_MEMB_GROUP -foreign key (GROUP_ID_) -references ACT_ID_GROUP (ID_); - -alter table ACT_ID_MEMBERSHIP - add constraint ACT_FK_MEMB_USER -foreign key (USER_ID_) -references ACT_ID_USER (ID_); - -COMMIT; - --- ----------------------------------------------------- --- Create Quartz tables --- ----------------------------------------------------- - -DROP SCHEMA IF EXISTS openbook_jobs; -CREATE SCHEMA openbook_jobs DEFAULT CHARACTER SET utf8; - -GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -FLUSH PRIVILEGES; - -USE openbook_jobs; - -CREATE TABLE QRTZ_JOB_DETAILS( - SCHED_NAME VARCHAR(120) NOT NULL, - JOB_NAME VARCHAR(200) NOT NULL, - JOB_GROUP VARCHAR(200) NOT NULL, - DESCRIPTION VARCHAR(250) NULL, - JOB_CLASS_NAME VARCHAR(250) NOT NULL, - IS_DURABLE VARCHAR(1) NOT NULL, - IS_NONCONCURRENT VARCHAR(1) NOT NULL, - IS_UPDATE_DATA VARCHAR(1) NOT NULL, - REQUESTS_RECOVERY VARCHAR(1) NOT NULL, - JOB_DATA BLOB NULL, -PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - JOB_NAME VARCHAR(200) NOT NULL, - JOB_GROUP VARCHAR(200) NOT NULL, - DESCRIPTION VARCHAR(250) NULL, - NEXT_FIRE_TIME BIGINT(13) NULL, - PREV_FIRE_TIME BIGINT(13) NULL, - PRIORITY INTEGER NULL, - TRIGGER_STATE VARCHAR(16) NOT NULL, - TRIGGER_TYPE VARCHAR(8) NOT NULL, - START_TIME BIGINT(13) NOT NULL, - END_TIME BIGINT(13) NULL, - CALENDAR_NAME VARCHAR(200) NULL, - MISFIRE_INSTR SMALLINT(2) NULL, - JOB_DATA BLOB NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP) -REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_SIMPLE_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - REPEAT_COUNT BIGINT(7) NOT NULL, - REPEAT_INTERVAL BIGINT(12) NOT NULL, - TIMES_TRIGGERED BIGINT(10) NOT NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_CRON_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - CRON_EXPRESSION VARCHAR(120) NOT NULL, - TIME_ZONE_ID VARCHAR(80), -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_SIMPROP_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - STR_PROP_1 VARCHAR(512) NULL, - STR_PROP_2 VARCHAR(512) NULL, - STR_PROP_3 VARCHAR(512) NULL, - INT_PROP_1 INT NULL, - INT_PROP_2 INT NULL, - LONG_PROP_1 BIGINT NULL, - LONG_PROP_2 BIGINT NULL, - DEC_PROP_1 NUMERIC(13,4) NULL, - DEC_PROP_2 NUMERIC(13,4) NULL, - BOOL_PROP_1 VARCHAR(1) NULL, - BOOL_PROP_2 VARCHAR(1) NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_BLOB_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - BLOB_DATA BLOB NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), -INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP), -FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) -REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_CALENDARS ( - SCHED_NAME VARCHAR(120) NOT NULL, - CALENDAR_NAME VARCHAR(200) NOT NULL, - CALENDAR BLOB NOT NULL, -PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS ( - SCHED_NAME VARCHAR(120) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, -PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_FIRED_TRIGGERS ( - SCHED_NAME VARCHAR(120) NOT NULL, - ENTRY_ID VARCHAR(95) NOT NULL, - TRIGGER_NAME VARCHAR(200) NOT NULL, - TRIGGER_GROUP VARCHAR(200) NOT NULL, - INSTANCE_NAME VARCHAR(200) NOT NULL, - FIRED_TIME BIGINT(13) NOT NULL, - SCHED_TIME BIGINT(13) NOT NULL, - PRIORITY INTEGER NOT NULL, - STATE VARCHAR(16) NOT NULL, - JOB_NAME VARCHAR(200) NULL, - JOB_GROUP VARCHAR(200) NULL, - IS_NONCONCURRENT VARCHAR(1) NULL, - REQUESTS_RECOVERY VARCHAR(1) NULL, -PRIMARY KEY (SCHED_NAME,ENTRY_ID)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_SCHEDULER_STATE ( - SCHED_NAME VARCHAR(120) NOT NULL, - INSTANCE_NAME VARCHAR(200) NOT NULL, - LAST_CHECKIN_TIME BIGINT(13) NOT NULL, - CHECKIN_INTERVAL BIGINT(13) NOT NULL, -PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)) -ENGINE=InnoDB; - -CREATE TABLE QRTZ_LOCKS ( - SCHED_NAME VARCHAR(120) NOT NULL, - LOCK_NAME VARCHAR(40) NOT NULL, -PRIMARY KEY (SCHED_NAME,LOCK_NAME)) -ENGINE=InnoDB; - -CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY); -CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP); - -CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP); -CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP); -CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME); -CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP); -CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE); -CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE); -CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE); -CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME); -CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME); -CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME); -CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE); -CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE); +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 %}'; -CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME); -CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY); -CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP); -CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP); -CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP); -CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP); +USE `openbook`; +/*!50001 DROP TABLE IF EXISTS `v_all_charges`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_all_charges` AS select `t_invoice`.`invoice_id` AS `invoice_id`,`t_invoice`.`payer_id` AS `payer_id`,`t_invoice`.`payer_type` AS `payer_type`,`t_invoice`.`payer_name` AS `payer_name`,`t_invoice`.`invoice_number` AS `invoice_number`,`t_invoice`.`invoice_date` AS `invoice_date`,`t_invoice`.`period_begin` AS `period_begin`,`t_invoice`.`period_end` AS `period_end`,`t_invoice`.`invoice_amount` AS `invoice_amount`,`t_invoice`.`actual_charges` AS `actual_charges`,`t_invoice`.`invoice_currency` AS `invoice_currency`,`t_invoice`.`management_region_id` AS `management_region_id` from `t_invoice` union select `t_unbilled_charges`.`invoice_id` AS `invoice_id`,`t_unbilled_charges`.`payer_id` AS `payer_id`,`t_unbilled_charges`.`payer_type` AS `payer_type`,`t_unbilled_charges`.`payer_name` AS `payer_name`,`t_unbilled_charges`.`invoice_number` AS `invoice_number`,`t_unbilled_charges`.`invoice_date` AS `invoice_date`,`t_unbilled_charges`.`period_begin` AS `period_begin`,`t_unbilled_charges`.`period_end` AS `period_end`,`t_unbilled_charges`.`invoice_amount` AS `invoice_amount`,`t_unbilled_charges`.`actual_charges` AS `actual_charges`,`t_unbilled_charges`.`invoice_currency` AS `invoice_currency`,`t_unbilled_charges`.`management_region_id` AS `management_region_id` from `t_unbilled_charges` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_all_charges_detail`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_all_charges_detail` AS select `t_invoice_detail`.`invoice_id` AS `invoice_id`,`t_invoice_detail`.`customer_id` AS `customer_id`,`t_invoice_detail`.`customer_name` AS `customer_name`,`t_invoice_detail`.`service_region_id` AS `service_region_id`,`t_invoice_detail`.`rate` AS `rate`,`t_invoice_detail`.`rate_display` AS `rate_display`,`t_invoice_detail`.`rate_unit` AS `rate_unit`,`t_invoice_detail`.`rate_interval` AS `rate_interval`,`t_invoice_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_invoice_detail`.`units_billed` AS `units_billed`,`t_invoice_detail`.`units_billed_display` AS `units_billed_display`,`t_invoice_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_invoice_detail`.`item_category` AS `item_category`,`t_invoice_detail`.`item_group` AS `item_group`,`t_invoice_detail`.`item_type` AS `item_type`,`t_invoice_detail`.`item_detail` AS `item_detail`,`t_invoice_detail`.`tenant_id` AS `tenant_id`,`t_invoice_detail`.`tenant_name` AS `tenant_name` from `t_invoice_detail` union select `t_unbilled_charges_detail`.`invoice_id` AS `invoice_id`,`t_unbilled_charges_detail`.`customer_id` AS `customer_id`,`t_unbilled_charges_detail`.`customer_name` AS `customer_name`,`t_unbilled_charges_detail`.`service_region_id` AS `service_region_id`,`t_unbilled_charges_detail`.`rate` AS `rate`,`t_unbilled_charges_detail`.`rate_display` AS `rate_display`,`t_unbilled_charges_detail`.`rate_unit` AS `rate_unit`,`t_unbilled_charges_detail`.`rate_interval` AS `rate_interval`,`t_unbilled_charges_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_unbilled_charges_detail`.`units_billed` AS `units_billed`,`t_unbilled_charges_detail`.`units_billed_display` AS `units_billed_display`,`t_unbilled_charges_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_unbilled_charges_detail`.`item_category` AS `item_category`,`t_unbilled_charges_detail`.`item_group` AS `item_group`,`t_unbilled_charges_detail`.`item_type` AS `item_type`,`t_unbilled_charges_detail`.`item_detail` AS `item_detail`,`t_unbilled_charges_detail`.`tenant_id` AS `tenant_id`,`t_unbilled_charges_detail`.`tenant_name` AS `tenant_name` from `t_unbilled_charges_detail` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_current_host`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_current_host` AS select `h`.`host_id` AS `host_id`,`h`.`service_manager_id` AS `service_manager_id`,`sm`.`service_manager_name` AS `service_manager_name`,`h`.`service_region_id` AS `service_region_id`,`r`.`region_name` AS `region_name`,`h`.`host_foreign_id` AS `host_foreign_id`,`h`.`host_name` AS `host_name`,`h`.`hypervisor_type` AS `hypervisor_type`,`h`.`host_aggregate` AS `host_aggregate`,`h`.`add_date` AS `add_date`,`h`.`remove_date` AS `remove_date`,`h`.`cpu_allocation_ratio` AS `cpu_allocation_ratio`,`h`.`ram_allocation_ratio` AS `ram_allocation_ratio`,`h`.`disk_allocation_ratio` AS `disk_allocation_ratio`,`ha`.`update_date` AS `update_date`,`ha`.`ram_mb` AS `ram_mb`,`ha`.`ram_mb_used` AS `ram_mb_used`,`ha`.`disk_gb` AS `disk_gb`,`ha`.`disk_gb_used` AS `disk_gb_used`,`ha`.`vcpus` AS `vcpus`,`ha`.`vcpus_used` AS `vcpus_used`,`ha`.`vm_count` AS `vm_count`,`ha`.`socket_count` AS `socket_count` from (((`t_host` `h` join `v_current_host_attributes` `ha` on(`h`.`host_id` = `ha`.`host_id`)) join `t_service_manager` `sm` on(`h`.`service_manager_id` = `sm`.`service_manager_id`)) join `t_region` `r` on(`h`.`service_region_id` = `r`.`region_id`)) where `h`.`remove_date` > curdate() */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_current_host_attributes`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_current_host_attributes` AS select `tha1`.`host_id` AS `host_id`,`tha1`.`update_date` AS `update_date`,`tha1`.`ram_mb` AS `ram_mb`,`tha1`.`ram_mb_used` AS `ram_mb_used`,`tha1`.`disk_gb` AS `disk_gb`,`tha1`.`disk_gb_used` AS `disk_gb_used`,`tha1`.`vcpus` AS `vcpus`,`tha1`.`vcpus_used` AS `vcpus_used`,`tha1`.`vm_count` AS `vm_count`,`tha1`.`socket_count` AS `socket_count` from `t_host_attributes` `tha1` where `tha1`.`update_date` = (select max(`t_host_attributes`.`update_date`) from `t_host_attributes` where `t_host_attributes`.`host_id` = `tha1`.`host_id`) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_customer`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_customer` AS select `c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name`,`c`.`metadata` AS `metadata`,`c`.`tax_rate` AS `tax_rate`,`c`.`currency` AS `currency`,`c`.`discount_percent` AS `discount_percent`,`c`.`billing_frequency` AS `billing_frequency`,`c`.`last_bill_date` AS `last_bill_date`,`c`.`next_bill_date` AS `next_bill_date`,`c`.`is_active` AS `is_active`,`c`.`create_date` AS `create_date`,`c`.`activate_date` AS `activate_date`,`c`.`billing_start_date` AS `billing_start_date`,`c`.`last_payment_date` AS `last_payment_date`,`c`.`deactivate_date` AS `deactivate_date`,`c`.`description` AS `description`,`c`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`c`.`invoicing_method` AS `invoicing_method`,`c`.`management_region_id` AS `management_region_id`,`c`.`billing_address_line_1` AS `billing_address_line_1`,`c`.`billing_address_line_2` AS `billing_address_line_2`,`c`.`billing_address_city` AS `billing_address_city`,`c`.`billing_address_region` AS `billing_address_region`,`c`.`billing_address_country` AS `billing_address_country`,`c`.`billing_address_postal_code` AS `billing_address_postal_code`,`c`.`payer_payment_details` AS `payer_payment_details`,`c`.`payment_method_confirmed` AS `payment_method_confirmed`,`c`.`balance_due` AS `balance_due`,`c`.`spend_soft_limit` AS `spend_soft_limit`,`c`.`spend_hard_limit` AS `spend_hard_limit`,`c`.`terms_and_conditions_2_accept_date` AS `terms_and_conditions_2_accept_date`,`c`.`tax_id` AS `tax_id`,`c`.`registration_number` AS `registration_number`,`r1`.`region_name` AS `management_region_name` from (`t_customer` `c` left join `t_region` `r1` on(`c`.`management_region_id` = `r1`.`region_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_metric`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_metric` AS select `m`.`metric_id` AS `metric_id`,`m`.`service_manager_type_id` AS `service_manager_type_id`,`m`.`metric_name` AS `metric_name`,`m`.`metric_label` AS `metric_label`,`m`.`metric_source` AS `metric_source`,`m`.`metric_type` AS `metric_type`,`m`.`metric_unit` AS `metric_unit`,`m`.`entity_resolution` AS `entity_resolution`,`m`.`time_resolution` AS `time_resolution`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_metric` `m` left join `t_service_manager_type` `sm` on(`m`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_promo_code_redemption`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_promo_code_redemption` AS select `p`.`management_region_id` AS `management_region_id`,`p`.`promo_code_id` AS `promo_code_id`,`p`.`promo_code` AS `promo_code`,`p`.`salesperson` AS `salesperson`,`p`.`discount_or_credit` AS `discount_or_credit`,`p`.`credit_amount` AS `credit_amount`,`p`.`credit_type` AS `credit_type`,`p`.`apply_to_charge_category` AS `apply_to_charge_category`,`p`.`trigger_charge_category` AS `trigger_charge_category`,`p`.`trigger_amount` AS `trigger_amount`,`p`.`discount_percent` AS `discount_percent`,`p`.`available_invoice_periods` AS `available_invoice_periods`,`p`.`expire_date` AS `expire_date`,`p`.`currency` AS `currency`,`r`.`redemption_date` AS `redemption_date`,`c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name` from ((`t_promo_code_redemption` `r` join `t_customer` `c`) join `t_promo_code` `p`) where `r`.`payer_type` = 'Customer' and `r`.`payer_id` = `c`.`customer_id` and `p`.`promo_code_id` = `r`.`promo_code_id` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_provider`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_provider` AS select `t_provider`.`provider_id` AS `provider_id`,`t_provider`.`provider_name` AS `provider_name`,`t_provider`.`provider_type` AS `provider_type`,`t_provider`.`metadata` AS `metadata`,`t_provider`.`tax_rate` AS `tax_rate`,`t_provider`.`currency` AS `currency`,`t_provider`.`discount_percent` AS `discount_percent`,`t_provider`.`billing_frequency` AS `billing_frequency`,`t_provider`.`last_bill_date` AS `last_bill_date`,`t_provider`.`next_bill_date` AS `next_bill_date`,`t_provider`.`last_payment_date` AS `last_payment_date`,`t_provider`.`is_active` AS `is_active`,`t_provider`.`create_date` AS `create_date`,`t_provider`.`activate_date` AS `activate_date`,`t_provider`.`billing_start_date` AS `billing_start_date`,`t_provider`.`deactivate_date` AS `deactivate_date`,`t_provider`.`description` AS `description`,`t_provider`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`t_provider`.`invoicing_method` AS `invoicing_method`,`t_provider`.`invoice_processing_method` AS `invoice_processing_method`,`t_provider`.`billing_address_line_1` AS `billing_address_line_1`,`t_provider`.`billing_address_line_2` AS `billing_address_line_2`,`t_provider`.`billing_address_city` AS `billing_address_city`,`t_provider`.`billing_address_region` AS `billing_address_region`,`t_provider`.`billing_address_country` AS `billing_address_country`,`t_provider`.`billing_address_postal_code` AS `billing_address_postal_code`,`t_provider`.`legal_address_line_1` AS `legal_address_line_1`,`t_provider`.`legal_address_line_2` AS `legal_address_line_2`,`t_provider`.`legal_address_city` AS `legal_address_city`,`t_provider`.`legal_address_region` AS `legal_address_region`,`t_provider`.`legal_address_country` AS `legal_address_country`,`t_provider`.`legal_address_postal_code` AS `legal_address_postal_code`,`t_provider`.`payer_payment_details` AS `payer_payment_details`,`t_provider`.`payee_payment_details` AS `payee_payment_details`,`t_provider`.`public_url` AS `public_url`,`t_provider`.`management_region_id` AS `management_region_id`,`t_provider`.`balance_due` AS `balance_due`,`t_provider`.`openbook_processes_payments` AS `openbook_processes_payments`,`t_provider`.`openbook_processes_past_due_invoices` AS `openbook_processes_past_due_invoices`,`t_provider`.`openstack_tenant_id` AS `openstack_tenant_id`,`t_provider`.`tax_id` AS `tax_id`,`t_provider`.`registration_number` AS `registration_number`,`t_provider`.`os_service_manager_id` AS `os_service_manager_id`,`t_region`.`parent_region_id` AS `parent_management_region_id` from (`t_provider` left join `t_region` on(`t_region`.`region_id` = `t_provider`.`management_region_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_rate_plan_assignment`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_rate_plan_assignment` AS select `a`.`rate_plan_id` AS `rate_plan_id`,`a`.`assignee_id` AS `assignee_id`,`a`.`assignee_type` AS `assignee_type`,`a`.`assignment_start_date` AS `assignment_start_date`,`a`.`assignment_end_date` AS `assignment_end_date`,`a`.`assignment_type` AS `assignment_type`,`r`.`management_region_id` AS `management_region_id` from (`t_rate_plan_assignment` `a` left join `t_rate_plan` `r` on(`a`.`rate_plan_id` = `r`.`rate_plan_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service` AS select `s`.`service_id` AS `service_id`,`s`.`service_type` AS `service_type`,`s`.`service_description` AS `service_description`,`s`.`service_manager_type_id` AS `service_manager_type_id`,`s`.`states` AS `states`,`s`.`externally_managed` AS `externally_managed`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_service` `s` left join `t_service_manager_type` `sm` on(`s`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance` AS select `tsi`.`service_instance_id` AS `service_instance_id`,`tsi`.`service_id` AS `service_id`,`tsi`.`service_instance_name` AS `service_instance_name`,`tsi`.`service_manager_id` AS `service_manager_id`,`tsi`.`service_region_id` AS `service_region_id`,`tsi`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tsi`.`tenant_id` AS `tenant_id`,`tsi`.`current_attributes` AS `current_attributes`,`tt`.`tenant_name` AS `tenant_name`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tr`.`region_name` AS `service_region_name`,`tsmt`.`service_manager_type` AS `service_manager_type`,`ts`.`service_type` AS `service_type`,`tsis`.`start_date` AS `provisioned_date`,`tsis`.`end_date` AS `deprovisioned_date` from (((((((`t_service_instance` `tsi` left join `t_tenant` `tt` on(`tsi`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tc`.`customer_id` = `tt`.`customer_id`)) left join `t_service` `ts` on(`tsi`.`service_id` = `ts`.`service_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_region` `tr` on(`tsi`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager` `tsm` on(`tsi`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_instance_state` `tsis` on(`tsi`.`service_instance_id` = `tsis`.`service_instance_id` and `tsis`.`state` = 'In Existence')) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance_attributes`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance_attributes` AS select `tpsa`.`service_instance_id` AS `service_instance_id`,`tpsa`.`start_date` AS `start_date`,`tpsa`.`end_date` AS `end_date`,`tpsa`.`attributes` AS `attributes`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_attributes` `tpsa` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpsa`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance_state`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance_state` AS select `tpss`.`service_instance_id` AS `service_instance_id`,`tpss`.`state` AS `state`,`tpss`.`start_date` AS `start_date`,`tpss`.`end_date` AS `end_date`,`tpss`.`interval_length_milliseconds` AS `interval_length_milliseconds`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_state` `tpss` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpss`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_manager`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_manager` AS select `tsm`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tsm`.`service_manager_description` AS `service_manager_description`,`tsm`.`metadata` AS `metadata`,`tsm`.`service_region_id` AS `service_region_id`,`tsm`.`service_manager_type_id` AS `service_manager_type_id`,`tsmt`.`service_manager_type` AS `service_manager_type` from (`t_service_manager` `tsm` left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_tenant`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_tenant` AS select `t`.`tenant_id` AS `tenant_id`,`t`.`tenant_name` AS `tenant_name`,`t`.`tenant_foreign_id` AS `tenant_foreign_id`,`t`.`create_date` AS `create_date`,`t`.`deactivate_date` AS `deactivate_date`,`t`.`customer_id` AS `customer_id`,`t`.`service_manager_id` AS `service_manager_id`,`t`.`is_active` AS `is_active`,`c`.`customer_name` AS `customer_name`,`c`.`management_region_id` AS `management_region_id`,`vsm`.`service_manager_type` AS `service_manager_type` from ((`t_tenant` `t` left join `t_customer` `c` on(`t`.`customer_id` = `c`.`customer_id`)) left join `v_service_manager` `vsm` on(`t`.`service_manager_id` = `vsm`.`service_manager_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_users`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_users` AS select `u`.`user_id` AS `user_id`,`u`.`username` AS `username`,`u`.`first_name` AS `first_name`,`u`.`last_name` AS `last_name`,`u`.`email_address` AS `email_address`,`u`.`phone_number` AS `phone_number`,`u`.`password` AS `password`,`u`.`is_active` AS `is_active`,`u`.`password_change_token` AS `password_change_token`,`u`.`last_password_change_date` AS `last_password_change_date`,`u`.`password_change_token_expire_date` AS `password_change_token_expire_date`,`r`.`role_name` AS `role_name`,`r`.`role_context` AS `role_context` from (`t_users` `u` left join `t_user_roles` `r` on(`u`.`user_id` = `r`.`user_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; + +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; + +USE `openbook_jobs`; + +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; + +USE `openbook_workflow`; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -COMMIT; -- cgit v1.3