DROP TABLE IF EXISTS `global_counter`;
CREATE TABLE `global_counter` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) DEFAULT NULL,
`groupTable` VARCHAR(255) NOT NULL,
`userTable` VARCHAR(255) NOT NULL,
`allowed_cidr` VARCHAR(250) DEFAULT NULL,
`rateLimitMaxRequest` INT DEFAULT NULL,
`rateLimitMaxRequestWindow` INT DEFAULT NULL,
`private_token_domain` VARCHAR(255) DEFAULT NULL,
`private_session_domain` VARCHAR(255) DEFAULT NULL,
`public_domain` VARCHAR(255) DEFAULT NULL,
`enableCidrCheck` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableConcurrentLogin` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableCronRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableCustomRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableDropboxRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableDownloadRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableExplainRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableGlobalCounter` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableImportRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableImportSampleRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableInputRepresentationAsQueryParam` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableOutputRepresentationAsQueryParam` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enablePayloadInResponse` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enablePrivateRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enablePublicRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimiting` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForCustomer` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForGroup` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForIp` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForRoute` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForUser` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForUserPerIp` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRateLimitForUserRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableReloadRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableResponseCaching` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableRoutesRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableThirdPartyRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableUploadRequest` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableQueryCacheForPublic` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`enableQueryCacheForPrivate` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`cronRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`customRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`dropboxRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`explainRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`exportRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`importSampleRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`importRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`reloadRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`routesRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`thirdPatyRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`uploadRestrictedCidr` VARCHAR(250) DEFAULT NULL,
`rateLimitIPMaxRequest` INT DEFAULT NULL, -- ; Max request allowed per IP
`rateLimitIPMaxRequestWindow` INT DEFAULT NULL, -- ; Window for Max request allowed per IP
`rateLimitMaxUserPerIp` INT DEFAULT NULL, -- ; Max User allowed per IP
`rateLimitMaxUserPerIpWindow` INT DEFAULT NULL, -- ; Window for Max User allowed per IP
`rateLimitUserMaxRequest` INT DEFAULT NULL, -- ; Max request allowed for user
`rateLimitUserMaxRequestWindow` INT DEFAULT NULL, -- ; Window for Max request allowed for user
`rateLimitMaxUserLoginRequest` INT DEFAULT NULL, -- ; Max User Login request
`rateLimitMaxUserLoginRequestWindow` INT DEFAULT NULL, -- ; Window for Max User Login request
`master_db_server_type` VARCHAR(255) NOT NULL,
`master_db_server_hostname` VARCHAR(255) NOT NULL,
`master_db_server_port` VARCHAR(255) NOT NULL,
`master_db_server_username` VARCHAR(255) NOT NULL,
`master_db_server_password` VARCHAR(255) NOT NULL,
`master_db_server_db` VARCHAR(255) NOT NULL,
`master_db_server_query_placeholder` VARCHAR(255) NOT NULL,
`slave_db_server_type` VARCHAR(255) NOT NULL,
`slave_db_server_hostname` VARCHAR(255) NOT NULL,
`slave_db_server_port` VARCHAR(255) NOT NULL,
`slave_db_server_username` VARCHAR(255) NOT NULL,
`slave_db_server_password` VARCHAR(255) NOT NULL,
`slave_db_server_db` VARCHAR(255) NOT NULL,
`slave_db_server_query_placeholder` VARCHAR(255) NOT NULL,
`cache_server_type` VARCHAR(255) NOT NULL,
`cache_server_hostname` VARCHAR(255) NOT NULL,
`cache_server_port` VARCHAR(255) NOT NULL,
`cache_server_username` VARCHAR(255) NOT NULL,
`cache_server_password` VARCHAR(255) NOT NULL,
`cache_server_db` VARCHAR(255) NOT NULL,
`cache_server_table` VARCHAR(255) NOT NULL,
`session_server_type` VARCHAR(255) DEFAULT NULL,
`session_server_hostname` VARCHAR(255) DEFAULT NULL,
`session_server_port` VARCHAR(255) DEFAULT NULL,
`session_server_username` VARCHAR(255) DEFAULT NULL,
`session_server_password` VARCHAR(255) DEFAULT NULL,
`session_server_db` VARCHAR(255) DEFAULT NULL,
`session_server_table` VARCHAR(255) DEFAULT NULL,
`query_cache_server_type` VARCHAR(255) DEFAULT NULL,
`query_cache_server_hostname` VARCHAR(255) DEFAULT NULL,
`query_cache_server_port` VARCHAR(255) DEFAULT NULL,
`query_cache_server_username` VARCHAR(255) DEFAULT NULL,
`query_cache_server_password` VARCHAR(255) DEFAULT NULL,
`query_cache_server_db` VARCHAR(255) DEFAULT NULL,
`query_cache_server_table` VARCHAR(255) DEFAULT NULL, -- ; For MongoDb
`comments` VARCHAR(255) DEFAULT NULL,
`created_by` INT DEFAULT NULL,
`created_on` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` INT DEFAULT NULL,
`approved_on` DATETIME NULL DEFAULT NULL,
`updated_by` INT DEFAULT NULL,
`updated_on` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_approved` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`is_disabled` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
`is_deleted` ENUM('Yes', 'No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
LOCK TABLES `customer` WRITE;
INSERT INTO `customer` VALUES
(1,'Customer 001','group','user',NULL,NULL,NULL,'api.customer001.localhost','web.customer001.localhost','customer001.localhost','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes','Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,600,300,600,300,600,300,600,300,'cDbServerType001','cDbServerHostname001','cDbServerPort001','cDbServerUsername001','cDbServerPassword001','cDbServerDatabase001','cDbServerQueryPlaceholder001','cDbServerType001','cDbServerHostname001','cDbServerPort001','cDbServerUsername001','cDbServerPassword001','cDbServerDatabase001','cDbServerQueryPlaceholder001','cCacheServerType001','cCacheServerHostname001','cCacheServerPort001','cCacheServerUsername001','cCacheServerPassword001','cCacheServerDatabase001','cCacheServerTable001','fileSessionMode',NULL,NULL,NULL,NULL,NULL,NULL,'queryCacheServerType','queryCacheServerHostname','queryCacheServerPort','queryCacheServerUsername','queryCacheServerPassword','queryCacheServerDatabase','queryCacheServerTable','',NULL,'2023-04-15 08:54:50',NULL,NULL,NULL,'2023-04-29 16:00:41','Yes', 'No','No');
UNLOCK TABLES;
DROP TABLE IF EXISTS `request`;
CREATE TABLE `request` (
`request_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`customer_id` INT NOT NULL,
`group_id` INT NOT NULL,
`user_id` INT NOT NULL,
`request_route` VARCHAR(250),
`request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`request_payload_json` JSON NOT NULL,
`request_datetime` DATETIME DEFAULT CURRENT_TIMESTAMP,
`request_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`request_id`)
) ENGINE = InnoDB;
DROP TABLE IF EXISTS `error_log`;
CREATE TABLE `error_log` (
`error_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`request_id` BIGINT UNSIGNED NOT NULL,
`customer_id` INT NOT NULL,
`group_id` INT NOT NULL,
`user_id` INT NOT NULL,
`request_route` VARCHAR(250),
`request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`request_config_json` JSON NOT NULL,
`request_payload_json` JSON NOT NULL,
`request_session_json` JSON NOT NULL,
`request_exception_json` JSON NOT NULL,
`request_datetime` DATETIME DEFAULT CURRENT_TIMESTAMP,
`request_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`error_id`)
) ENGINE = InnoDB;
DROP TABLE IF EXISTS `debug_log`;
CREATE TABLE `debug_log` (
`debug_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`debug_mode` VARCHAR(250),
`request_id` BIGINT UNSIGNED NOT NULL,
`customer_id` INT NOT NULL,
`group_id` INT NOT NULL,
`user_id` INT NOT NULL,
`request_route` VARCHAR(250),
`request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`request_config_json` JSON NOT NULL,
`request_payload_json` JSON NOT NULL,
`request_session_json` JSON NOT NULL,
`request_debug_json` JSON NOT NULL,
`request_datetime` DATETIME DEFAULT CURRENT_TIMESTAMP,
`request_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`debug_id`)
) ENGINE = InnoDB;
|
Download
