diff options
| author | Carlos Konstanski <carlos.konstanski@verizonwireless.com> | 2017-10-26 00:01:42 +0000 |
|---|---|---|
| committer | Carlos Konstanski <carlos.konstanski@verizonwireless.com> | 2017-10-26 00:01:42 +0000 |
| commit | 733d887b7bd624c7b8a621cdd40fbbced20d0e00 (patch) | |
| tree | 37f22175429426395f8e481c5ad687c5bbffbee4 | |
| parent | ee5874f254b9ce2fb48bebb9b86170acf59ea488 (diff) | |
update create_databases_schama.sql Thu Oct 26 00:01:42 UTC 2017
| -rw-r--r-- | salt/openbook/database/files/create_openbook_schemas.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql index b0f3552..aa5ecfe 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=1790 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1795 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=315455 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=315459 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 */; @@ -455,7 +455,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=12480629 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=12483741 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 */; @@ -1025,7 +1025,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=77754 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=80235 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 */; @@ -1118,7 +1118,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=1672 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1861 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 */; @@ -1138,7 +1138,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=615 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=798 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 */; @@ -1220,7 +1220,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=615 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=372 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 */; |