  `regionalID` varchar(254) DEFAULT NULL,
  `AGG_COUNT` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`AGG_TIMESTAMP`,`AGG_EVENT_TIMESTAMP`,`apiContext`,`apiHostname`,`applicationId`,`username`,`userTenantDomain`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ApiUserPerAppAgg_YEARS`
--

LOCK TABLES `ApiUserPerAppAgg_YEARS` WRITE;
/*!40000 ALTER TABLE `ApiUserPerAppAgg_YEARS` DISABLE KEYS */;
/*!40000 ALTER TABLE `ApiUserPerAppAgg_YEARS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ApiVersionPerAppAgg_DAYS`
--

DROP TABLE IF EXISTS `ApiVersionPerAppAgg_DAYS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `ApiVersionPerAppAgg_DAYS` (
  `AGG_TIMESTAMP` bigint(20) NOT NULL,
  `AGG_EVENT_TIMESTAMP` bigint(20) NOT NULL,
  `apiContext` varchar(254) NOT NULL,
  `apiHostname` varchar(254) NOT NULL,
  `applicationId` varchar(254) NOT NULL,
  `AGG_LAST_EVENT_TIMESTAMP` bigint(20) DEFAULT NULL,
  `apiName` varchar(254) DEFAULT NULL,
  `apiVersion` varchar(254) DEFAULT NULL,
  `apiCreator` varchar(254) DEFAULT NULL,
  `apiCreatorTenantDomain` varchar(254) DEFAULT NULL,
  `applicationName` varchar(254) DEFAULT NULL,
  `gatewayType` varchar(254) DEFAULT NULL,
  `label` varchar(254) DEFAULT NULL,
  `regionalID` varchar(254) DEFAULT NULL,
  `AGG_COUNT` bigint(20) DEFAULT NULL,
  `AGG_SUM_quotaExceededValue` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`AGG_TIMESTAMP`,`AGG_EVENT_TIMESTAMP`,`apiContext`,`apiHostname`,`applicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ApiVersionPerAppAgg_DAYS`
--

LOCK TABLES `ApiVersionPerAppAgg_DAYS` WRITE;
/*!40000 ALTER TABLE `ApiVersionPerAppAgg_DAYS` DISABLE KEYS */;
INSERT INTO `ApiVersionPerAppAgg_DAYS` VALUES (1541116800000,1541116800000,'/phoneverify/1.0.0','44353f2a20e8','2',1541193611320,'PhoneVerification','1.0.0','james','carbon.super','TestApp','SYNAPSE','Synapse','default',1001,0),(1541116800000,1541116800000,'/phoneverify/1.0.0','44353f2a20e8','3',1541193865142,'PhoneVerification','1.0.0','james','carbon.super','LimitedApp','SYNAPSE','Synapse','default',27,0);
/*!40000 ALTER TABLE `ApiVersionPerAppAgg_DAYS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ApiVersionPerAppAgg_HOURS`
--

DROP TABLE IF EXISTS `ApiVersionPerAppAgg_HOURS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `ApiVersionPerAppAgg_HOURS` (
  `AGG_TIMESTAMP` bigint(20) NOT NULL,
  `AGG_EVENT_TIMESTAMP` bigint(20) NOT NULL,
  `apiContext` varchar(254) NOT NULL,
  `apiHostname` varchar(254) NOT NULL,
  `applicationId` varchar(254) NOT NULL,
  `AGG_LAST_EVENT_TIMESTAMP` bigint(20) DEFAULT NULL,
  `apiName` varchar(254) DEFAULT NULL,
  `apiVersion` varchar(254) DEFAULT NULL,
  `apiCreator` varchar(254) DEFAULT NULL,
  `apiCreatorTenantDomain` varchar(254) DEFAULT NULL,
  `applicationName` varchar(254) DEFAULT NULL,
  `gatewayType` varchar(254) DEFAULT NULL,
  `label` varchar(254) DEFAULT NULL,
  `regionalID` varchar(254) DEFAULT NULL,
  `AGG_COUNT` bigint(20) DEFAULT NULL,
  `AGG_SUM_quotaExceededValue` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`AGG_TIMESTAMP`,`AGG_EVENT_TIMESTAMP`,`apiContext`,`apiHostname`,`applicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ApiVersionPerAppAgg_HOURS`
--

LOCK TABLES `ApiVersionPerAppAgg_HOURS` WRITE;
/*!40000 ALTER TABLE `ApiVersionPerAppAgg_HOURS` DISABLE KEYS */;
INSERT INTO `ApiVersionPerAppAgg_HOURS` VALUES (1541192400000,1541192400000,'/phoneverify/1.0.0','44353f2a20e8','2',1541193611320,'PhoneVerification','1.0.0','james','carbon.super','TestApp','SYNAPSE','Synapse','default',1001,0),(1541192400000,1541192400000,'/phoneverify/1.0.0','44353f2a20e8','3',1541193865142,'PhoneVerification','1.0.0','james','carbon.super','LimitedApp','SYNAPSE','Synapse','default',27,0);
/*!40000 ALTER TABLE `ApiVersionPerAppAgg_HOURS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ApiVersionPerAppAgg_MINUTES`
--

DROP TABLE IF EXISTS `ApiVersionPerAppAgg_MINUTES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `ApiVersionPerAppAgg_MINUTES` (
  `AGG_TIMESTAMP` bigint(20) NOT NULL,
  `AGG_EVENT_TIMESTAMP` bigint(20) NOT NULL,
  `apiContext` varchar(254) NOT NULL,
  `apiHostname` varchar(254) NOT NULL,
  `applicationId` varchar(254) NOT NULL,
  `AGG_LAST_EVENT_TIMESTAMP` bigint(20) DEFAULT NULL,
  `apiName` varchar(254) DEFAULT NULL,
  `apiVersion` varchar(254) DEFAULT NULL,
  `apiCreator` varchar(254) DEFAULT NULL,
  `apiCreatorTenantDomain` varchar(254) DEFAULT NULL,
  `applicationName` varchar(254) DEFAULT NULL,
  `gatewayType` varchar(254) DEFAULT NULL,
  `label` varchar(254) DEFAULT NULL,
  `regionalID` varchar(254) DEFAULT NULL,
  `AGG_COUNT` bigint(20) DEFAULT NULL,
  `AGG_SUM_quotaExceededValue` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`AGG_TIMESTAMP`,`AGG_EVENT_TIMESTAMP`,`apiContext`,`apiHostname`,`applicationId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ApiVersionPerAppAgg_MINUTES`
--

LOCK TABLES `ApiVersionPerAppAgg_MINUTES` WRITE;
/*!40000 ALTER TABLE `ApiVersionPerAppAgg_MINUTES` DISABLE KEYS */;
INSERT INTO `ApiVersionPerAppAgg_MINUTES` VALUES (1541193300000,1541193300000,'/phoneverify/1.0.0','44353f2a20e8','2',1541193346275,'PhoneVerification','1.0.0','james','carbon.super','TestApp','