From 5de4464e958576914bbe8c1464731ce7f8849a3c Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Tue, 14 Nov 2017 00:23:26 +0000 Subject: autocommit Tue Nov 14 00:23:26 UTC 2017 --- .../etc/openbook/database/create_openbook_schemas.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'templates/database/etc') diff --git a/templates/database/etc/openbook/database/create_openbook_schemas.sql b/templates/database/etc/openbook/database/create_openbook_schemas.sql index d3011e2..705a138 100644 --- a/templates/database/etc/openbook/database/create_openbook_schemas.sql +++ b/templates/database/etc/openbook/database/create_openbook_schemas.sql @@ -83,7 +83,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=1801 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1798 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 */; @@ -286,7 +286,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=315465 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=315462 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 */; @@ -1026,7 +1026,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=82971 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=82254 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 */; @@ -1129,7 +1129,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=1958 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1940 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 */; @@ -1149,7 +1149,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=845 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=824 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 */; @@ -1231,7 +1231,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=845 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=824 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