From 40e6a394f11a03a810229f456d13ecd6ce823f23 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Fri, 26 Jan 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Fri Jan 26 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 32 +++++++++++++--------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index fcd0c0e..7ca02be 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -602,7 +602,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -662,7 +663,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -744,7 +746,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -807,7 +810,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -890,7 +894,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -951,7 +956,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -989,8 +995,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB, - PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB, +(PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB, PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB, PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB, PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, @@ -1028,7 +1033,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737112` VALUES LESS THAN (737112) ENGINE = InnoDB, PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, - PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB); + PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1334,7 +1340,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=103913 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104143 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1438,7 +1444,7 @@ CREATE TABLE `t_tenant` ( KEY `ix_tenant_1` (`tenant_id`), KEY `ix_tenant_2` (`customer_id`), KEY `ix_tenant_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=2439 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2443 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1477,7 +1483,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=709 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=651 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1559,7 +1565,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=709 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=651 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 71b2c84c1a5a2b48a766b8ae47ea950c990acc95 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Sat, 27 Jan 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Sat Jan 27 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 32 +++++++++++++--------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 7ca02be..accec66 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -603,7 +603,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -664,7 +665,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -747,7 +749,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -811,7 +814,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -895,7 +899,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -957,7 +962,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -995,8 +1001,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB, - PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB, +(PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB, PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB, PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, @@ -1034,7 +1039,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737113` VALUES LESS THAN (737113) ENGINE = InnoDB, PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, - PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB); + PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1104,7 +1110,7 @@ CREATE TABLE `t_promo_code` ( 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; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1340,7 +1346,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104143 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104423 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1483,7 +1489,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=651 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=639 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1565,7 +1571,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=651 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=639 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 4403321bdc94c55f8a102d5a7424847f51821511 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Sun, 28 Jan 2018 00:00:02 +0000 Subject: update create_databases_schama.sql Sun Jan 28 00:00:02 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 30 +++++++++++++--------- 1 file changed, 18 insertions(+), 12 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index accec66..38bbd03 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -604,7 +604,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -666,7 +667,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -750,7 +752,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -815,7 +818,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -900,7 +904,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -963,7 +968,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1001,8 +1007,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB, - PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB, +(PARTITION `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB, PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, @@ -1040,7 +1045,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737114` VALUES LESS THAN (737114) ENGINE = InnoDB, PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, - PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB); + PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1346,7 +1352,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104423 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104523 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1489,7 +1495,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=639 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=656 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1571,7 +1577,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=639 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=657 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From d667c039330d4c208cfb951689df5a4faa48d4fc Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Mon, 29 Jan 2018 00:00:02 +0000 Subject: update create_databases_schama.sql Mon Jan 29 00:00:02 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 30 +++++++++++++--------- 1 file changed, 18 insertions(+), 12 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 38bbd03..b6a7a38 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -605,7 +605,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -668,7 +669,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -753,7 +755,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -819,7 +822,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -905,7 +909,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -969,7 +974,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1007,8 +1013,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737079` VALUES LESS THAN (737079) ENGINE = InnoDB, - PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, +(PARTITION `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, @@ -1046,7 +1051,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737115` VALUES LESS THAN (737115) ENGINE = InnoDB, PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, - PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB); + PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1352,7 +1358,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104523 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104571 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1495,7 +1501,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=656 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1577,7 +1583,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=657 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From d555cf76fe622bbc2f3e8185a312e2f8b18768be Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Tue, 30 Jan 2018 00:00:04 +0000 Subject: update create_databases_schama.sql Tue Jan 30 00:00:04 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 32 +++++++++++++--------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index b6a7a38..1522810 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -606,7 +606,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -670,7 +671,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -756,7 +758,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -823,7 +826,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -910,7 +914,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -975,7 +980,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1013,8 +1019,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737080` VALUES LESS THAN (737080) ENGINE = InnoDB, - PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, +(PARTITION `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, @@ -1052,7 +1057,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737116` VALUES LESS THAN (737116) ENGINE = InnoDB, PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, - PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB); + PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1122,7 +1128,7 @@ CREATE TABLE `t_promo_code` ( UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`), KEY `ix_promo_code_1` (`promo_code`), KEY `ix_promo_code_2` (`salesperson`) -) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1358,7 +1364,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104571 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104653 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1501,7 +1507,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1583,7 +1589,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 1581e48c4ede165663257173843ce8524c9a9170 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Wed, 31 Jan 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Wed Jan 31 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 32 +++++++++++++--------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 1522810..6625d23 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -607,7 +607,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -672,7 +673,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -759,7 +761,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -827,7 +830,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -915,7 +919,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -981,7 +986,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1019,8 +1025,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737081` VALUES LESS THAN (737081) ENGINE = InnoDB, - PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, +(PARTITION `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, @@ -1058,7 +1063,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737117` VALUES LESS THAN (737117) ENGINE = InnoDB, PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, - PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB); + PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1128,7 +1134,7 @@ CREATE TABLE `t_promo_code` ( UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`), KEY `ix_promo_code_1` (`promo_code`), KEY `ix_promo_code_2` (`salesperson`) -) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1364,7 +1370,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104653 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104768 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1507,7 +1513,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=621 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1589,7 +1595,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=621 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 808a46271b393cc69ead876a4e2d71d1545b37ac Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Thu, 1 Feb 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Thu Feb 1 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 34 +++++++++++++--------- 1 file changed, 20 insertions(+), 14 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 6625d23..8aff1e9 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -87,7 +87,7 @@ CREATE TABLE `t_audit_event` ( PRIMARY KEY (`event_id`), KEY `ix_audit_event_1` (`event_time`,`event_type`,`entity_id`), KEY `ix_audit_event_2` (`user_id`,`event_time`) -) ENGINE=InnoDB AUTO_INCREMENT=2219 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2239 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -608,7 +608,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -674,7 +675,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -762,7 +764,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -831,7 +834,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -920,7 +924,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -987,7 +992,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1025,8 +1031,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737082` VALUES LESS THAN (737082) ENGINE = InnoDB, - PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, +(PARTITION `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, @@ -1064,7 +1069,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737118` VALUES LESS THAN (737118) ENGINE = InnoDB, PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, - PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB); + PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1262,7 +1268,7 @@ CREATE TABLE `t_rate` ( `rate_structure` text NOT NULL, PRIMARY KEY (`rate_id`), KEY `ix_rate_1` (`rate_plan_id`) -) ENGINE=InnoDB AUTO_INCREMENT=887 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=896 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1370,7 +1376,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104768 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=104895 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1513,7 +1519,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=621 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=612 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1595,7 +1601,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=621 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=613 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 1f7ed1a0f7ee250dd3d105fb207b548d8b879ce0 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Fri, 2 Feb 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Fri Feb 2 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 32 +++++++++++++--------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 8aff1e9..37a6ec7 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -459,7 +459,7 @@ CREATE TABLE `t_invoice` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `ix_invoice_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=12486601 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=12487308 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -609,7 +609,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -676,7 +677,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -765,7 +767,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -835,7 +838,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -925,7 +929,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -993,7 +998,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1031,8 +1037,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737083` VALUES LESS THAN (737083) ENGINE = InnoDB, - PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, +(PARTITION `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, @@ -1070,7 +1075,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, - PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB); + PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1376,7 +1382,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=104895 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=105009 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1519,7 +1525,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=612 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1601,7 +1607,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=613 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=611 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 2d527aa2d4858f1716233eef590a7308248852f1 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Sat, 3 Feb 2018 00:00:03 +0000 Subject: update create_databases_schama.sql Sat Feb 3 00:00:03 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 30 +++++++++++++--------- 1 file changed, 18 insertions(+), 12 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 37a6ec7..463d156 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -610,7 +610,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -678,7 +679,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -768,7 +770,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -839,7 +842,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -930,7 +934,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -999,7 +1004,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1037,8 +1043,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737084` VALUES LESS THAN (737084) ENGINE = InnoDB, - PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, +(PARTITION `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB, @@ -1076,7 +1081,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = InnoDB, PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, - PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB); + PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1382,7 +1388,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=105009 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=105111 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1525,7 +1531,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=624 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1607,7 +1613,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=611 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=625 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 8bdbbfcd2b10fd52ddbf78ec0150985a8d5ad2d1 Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Sun, 4 Feb 2018 00:00:02 +0000 Subject: update create_databases_schama.sql Sun Feb 4 00:00:02 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 34 +++++++++++++--------- 1 file changed, 20 insertions(+), 14 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 463d156..69375e6 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -420,7 +420,7 @@ CREATE TABLE `t_host` ( `disk_allocation_ratio` decimal(6,2) DEFAULT NULL, PRIMARY KEY (`host_id`), KEY `ix_host_1` (`service_manager_id`,`service_region_id`,`host_foreign_id`(255)) -) ENGINE=InnoDB AUTO_INCREMENT=2035 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2075 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -436,7 +436,7 @@ CREATE TABLE `t_host_attributes` ( `vm_count` int(11) NOT NULL, `socket_count` int(11) NOT NULL, PRIMARY KEY (`host_id`,`update_date`) -) ENGINE=InnoDB AUTO_INCREMENT=2035 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2075 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -611,7 +611,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -680,7 +681,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -771,7 +773,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -843,7 +846,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -935,7 +939,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1005,7 +1010,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1043,8 +1049,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737085` VALUES LESS THAN (737085) ENGINE = InnoDB, - PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, +(PARTITION `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB, PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB, @@ -1082,7 +1087,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737121` VALUES LESS THAN (737121) ENGINE = InnoDB, PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, - PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB); + PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1388,7 +1394,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=105111 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=105203 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1531,7 +1537,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=624 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1613,7 +1619,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=625 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From b9ceb77ab79919cc3d4256e9d1e1c779fe8b98da Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Mon, 5 Feb 2018 00:00:02 +0000 Subject: update create_databases_schama.sql Mon Feb 5 00:00:02 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 26 +++++++++++++--------- 1 file changed, 16 insertions(+), 10 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index 69375e6..ad1cbda 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -612,7 +612,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -682,7 +683,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -774,7 +776,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -847,7 +850,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -940,7 +944,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1011,7 +1016,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1049,8 +1055,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737086` VALUES LESS THAN (737086) ENGINE = InnoDB, - PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, +(PARTITION `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB, PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB, PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB, @@ -1088,7 +1093,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737122` VALUES LESS THAN (737122) ENGINE = InnoDB, PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, - PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB); + PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1394,7 +1400,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=105203 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=105327 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3 From 7429133bd9ea59be4d47cb772d0ab2aa6bb19d7f Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Tue, 6 Feb 2018 00:00:02 +0000 Subject: update create_databases_schama.sql Tue Feb 6 00:00:02 UTC 2018 --- .../database/files/create_openbook_schemas.sql | 30 +++++++++++++--------- 1 file changed, 18 insertions(+), 12 deletions(-) (limited to 'salt') diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index ad1cbda..9a2f65f 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/create_openbook_schemas.sql @@ -613,7 +613,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -684,7 +685,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -777,7 +779,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -851,7 +854,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -945,7 +949,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1017,7 +1022,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1055,8 +1061,7 @@ CREATE TABLE `t_metric_values` ( 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 `p737087` VALUES LESS THAN (737087) ENGINE = InnoDB, - PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB, +(PARTITION `p737088` VALUES LESS THAN (737088) ENGINE = InnoDB, PARTITION `p737089` VALUES LESS THAN (737089) ENGINE = InnoDB, PARTITION `p737090` VALUES LESS THAN (737090) ENGINE = InnoDB, PARTITION `p737091` VALUES LESS THAN (737091) ENGINE = InnoDB, @@ -1094,7 +1099,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737123` VALUES LESS THAN (737123) ENGINE = InnoDB, PARTITION `p737124` VALUES LESS THAN (737124) ENGINE = InnoDB, PARTITION `p737125` VALUES LESS THAN (737125) ENGINE = InnoDB, - PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB); + PARTITION `p737126` VALUES LESS THAN (737126) ENGINE = InnoDB, + PARTITION `p737127` VALUES LESS THAN (737127) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1400,7 +1406,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=105327 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=105439 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1543,7 +1549,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=666 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1625,7 +1631,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=667 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -- cgit v1.3