From b2abbf589c6ea41d7746ffe8a117b81abb42c86a Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Fri, 10 Nov 2017 00:00:07 +0000 Subject: update create_databases_schama.sql Fri Nov 10 00:00:07 UTC 2017 --- salt/openbook/database/files/create_openbook_schemas.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index ed21ba2..ce0bdc2 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql +++ b/salt/openbook/database/files/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=1798 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1801 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=315462 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=315465 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=82254 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=82718 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=1940 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1954 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=824 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=849 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=824 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=849 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