summaryrefslogtreecommitdiff
path: root/templates/database/etc
diff options
context:
space:
mode:
Diffstat (limited to 'templates/database/etc')
-rw-r--r--templates/database/etc/openbook/database/create_openbook_schemas.sql132
1 files changed, 66 insertions, 66 deletions
diff --git a/templates/database/etc/openbook/database/create_openbook_schemas.sql b/templates/database/etc/openbook/database/create_openbook_schemas.sql
index bec504d..15659be 100644
--- a/templates/database/etc/openbook/database/create_openbook_schemas.sql
+++ b/templates/database/etc/openbook/database/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=1853 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1897 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 */;
@@ -290,7 +290,7 @@ CREATE TABLE `t_customer` (
`registration_number` varchar(128) DEFAULT NULL,
PRIMARY KEY (`customer_id`),
UNIQUE KEY `ix_customer_3` (`management_region_id`,`customer_name`(255))
-) ENGINE=InnoDB AUTO_INCREMENT=315519 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=315563 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 */;
@@ -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=1980 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1984 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=1980 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1984 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 */;
@@ -559,13 +559,7 @@ CREATE TABLE `t_metric_aggregate_customer_daily` (
PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
PARTITION BY RANGE (to_days(`aggregate_datetime`))
-(PARTITION `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
- PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
- PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
- PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
- PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
- PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
- PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+(PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
@@ -956,7 +950,13 @@ CREATE TABLE `t_metric_aggregate_customer_daily` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -973,13 +973,7 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` (
PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
PARTITION BY RANGE (to_days(`aggregate_datetime`))
-(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 `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,
@@ -1065,7 +1059,13 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -1104,13 +1104,7 @@ CREATE TABLE `t_metric_aggregate_resource_daily` (
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 `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
- PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
- PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
- PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
- PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
- PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
- PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+(PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
@@ -1501,7 +1495,13 @@ CREATE TABLE `t_metric_aggregate_resource_daily` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -1521,13 +1521,7 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` (
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 `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 `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,
@@ -1613,7 +1607,13 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -1653,13 +1653,7 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` (
PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
PARTITION BY RANGE (to_days(`aggregate_datetime`))
-(PARTITION `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
- PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
- PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
- PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
- PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
- PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
- PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+(PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
@@ -2050,7 +2044,13 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -2068,13 +2068,7 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` (
PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
PARTITION BY RANGE (to_days(`aggregate_datetime`))
-(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 `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,
@@ -2160,7 +2154,13 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -2198,13 +2198,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 `p737033` VALUES LESS THAN (737033) ENGINE = InnoDB,
- PARTITION `p737034` VALUES LESS THAN (737034) ENGINE = InnoDB,
- PARTITION `p737035` VALUES LESS THAN (737035) ENGINE = InnoDB,
- PARTITION `p737036` VALUES LESS THAN (737036) ENGINE = InnoDB,
- PARTITION `p737037` VALUES LESS THAN (737037) ENGINE = InnoDB,
- PARTITION `p737038` VALUES LESS THAN (737038) ENGINE = InnoDB,
- PARTITION `p737039` VALUES LESS THAN (737039) ENGINE = InnoDB,
+(PARTITION `p737039` VALUES LESS THAN (737039) ENGINE = InnoDB,
PARTITION `p737040` VALUES LESS THAN (737040) ENGINE = InnoDB,
PARTITION `p737041` VALUES LESS THAN (737041) ENGINE = InnoDB,
PARTITION `p737042` VALUES LESS THAN (737042) ENGINE = InnoDB,
@@ -2237,7 +2231,13 @@ CREATE TABLE `t_metric_values` (
PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB,
PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB,
PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB,
- PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB);
+ PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB,
+ PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB,
+ PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB,
+ PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB,
+ PARTITION `p737076` VALUES LESS THAN (737076) ENGINE = InnoDB,
+ PARTITION `p737077` VALUES LESS THAN (737077) ENGINE = InnoDB,
+ PARTITION `p737078` VALUES LESS THAN (737078) ENGINE = InnoDB);
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
@@ -2476,7 +2476,7 @@ CREATE TABLE `t_region` (
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=145 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=151 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 */;
@@ -2543,7 +2543,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=86803 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=87962 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 */;
@@ -2601,7 +2601,7 @@ CREATE TABLE `t_service_manager` (
`service_manager_type_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`service_manager_id`),
UNIQUE KEY `ix_service_manager_1` (`service_manager_name`(255))
-) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=79 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 */;
@@ -2647,7 +2647,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=2053 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=2107 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 */;
@@ -2686,7 +2686,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=854 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=863 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 */;
@@ -2768,7 +2768,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=854 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=840 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 */;
generated by cgit v1.3 (git 2.53.0) at 2026-09-24 19:09:21 +0000