   `context` varchar(100) NOT NULL DEFAULT '',
   `mediationName` varchar(100) NOT NULL DEFAULT '',
   `executionTime` int(11) DEFAULT NULL,
-  `year` smallint(6) NOT NULL,
-  `month` smallint(6) NOT NULL,
-  `day` smallint(6) NOT NULL,
-  `time` bigint(20),
-  PRIMARY KEY (`api`,`version`,`apiPublisher`,`context`,`year`,`month`,`day`,`mediationName`)
+  `tenantDomain` varchar(100) NOT NULL DEFAULT '',
+  `year` smallint(6) NOT NULL,
+  `month` smallint(6) NOT NULL,
+  `day` smallint(6) NOT NULL,
+  `time` bigint(20),
+  PRIMARY KEY (`api`,`version`,`apiPublisher`,`context`,`year`,`month`,`day`,`mediationName`,`tenantDomain`)
 );
 CREATE TABLE IF NOT EXISTS `API_EXE_TIME_HOUR_SUMMARY` (
   `api` varchar(100) NOT NULL DEFAULT '',

  `day` smallint(6) DEFAULT NULL,
  `time` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`api`,`version`,`apiPublisher`,`context`,`destination`,`hostName`,`time`)
); 

CREATE TABLE IF NOT EXISTS `API_FAULT_SUMMARY` (
  `api` varchar(100) NOT NULL DEFAULT '',
  `version` varchar(100) NOT NULL DEFAULT '',	
  `apiPublisher` varchar(100) NOT NULL DEFAULT '',
  `consumerKey` varchar(100) DEFAULT NULL,
  `context` varchar(100) NOT NULL DEFAULT '',

  `day` smallint(6) DEFAULT NULL,
  `time` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`api`,`api_version`,`version`,`apiPublisher`,`consumerKey`,`userId`,`context`,`hostName`,`time`)
);

CREATE TABLE IF NOT EXISTS `API_Resource_USAGE_SUMMARY` (
  `api` varchar(100) NOT NULL DEFAULT '',
