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,
`allowed_cidr` TEXT,
`api_domain` VARCHAR(255) DEFAULT NULL,
`open_api_domain` VARCHAR(255) DEFAULT NULL,
`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,
`usersTable` VARCHAR(255) NOT NULL,
`master_cache_server_type` VARCHAR(255) NOT NULL,
`master_cache_server_hostname` VARCHAR(255) NOT NULL,
`master_cache_server_port` VARCHAR(255) NOT NULL,
`master_cache_server_username` VARCHAR(255) NOT NULL,
`master_cache_server_password` VARCHAR(255) NOT NULL,
`master_cache_server_db` VARCHAR(255) NOT NULL,
`master_cache_server_table` VARCHAR(255) NOT NULL,
`slave_cache_server_type` VARCHAR(255) NOT NULL,
`slave_cache_server_hostname` VARCHAR(255) NOT NULL,
`slave_cache_server_port` VARCHAR(255) NOT NULL,
`slave_cache_server_username` VARCHAR(255) NOT NULL,
`slave_cache_server_password` VARCHAR(255) NOT NULL,
`slave_cache_server_db` VARCHAR(255) NOT NULL,
`slave_cache_server_table` VARCHAR(255) NOT NULL,
`rateLimitMaxRequest` INT DEFAULT NULL,
`rateLimitMaxRequestWindow` INT DEFAULT NULL,
`comments` VARCHAR(255) DEFAULT NULL,
`created_by` INT DEFAULT NULL,
`created_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` INT DEFAULT NULL,
`approved_on` TIMESTAMP NULL DEFAULT NULL,
`updated_by` INT DEFAULT NULL,
`updated_on` TIMESTAMP 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;
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`customer_id` INT DEFAULT NULL,
`allowed_cidr` TEXT,
`rateLimitMaxRequest` INT DEFAULT NULL,
`rateLimitMaxRequestWindow` INT DEFAULT NULL,
`comments` VARCHAR(255) DEFAULT NULL,
`created_by` INT DEFAULT NULL,
`created_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`approved_by` INT DEFAULT NULL,
`approved_on` TIMESTAMP NULL DEFAULT NULL,
`updated_by` INT DEFAULT NULL,
`updated_on` TIMESTAMP 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','0.0.0.0/0','api.customer001.localhost','localhost','cDbServerType001','cDbServerHostname001','cDbServerPort001','cDbServerUsername001','cDbServerPassword001','cCacheServerDB001','cDbServerQueryPlaceholder001','cDbServerType001','cDbServerHostname001','cDbServerPort001','cDbServerUsername001','cDbServerPassword001','cCacheServerDB001','cDbServerQueryPlaceholder001','customerUsersTable','gCacheServerType','gCacheServerHostname','gCacheServerPort','gCacheServerUsername','gCacheServerPassword','gCacheServerDB','gCacheServerTable','gCacheServerType','gCacheServerHostname','gCacheServerPort','gCacheServerUsername','gCacheServerPassword','gCacheServerDB','gCacheServerTable',NULL,NULL,'',NULL,'2023-04-15 08:54:50',NULL,NULL,NULL,'2023-04-29 16:00:41','Yes', 'No','No');
UNLOCK TABLES;
LOCK TABLES `group` WRITE;
INSERT INTO `group` VALUES
(2,'Customer001UserGroup1',1,'0.0.0.0/0',NULL,NULL,'',NULL,'2023-04-15 08:54:50',NULL,NULL,NULL,'2023-04-21 06:38:22','Yes', 'No','No'),
(3,'AdminGroup',1,'0.0.0.0/0',NULL,NULL,'',NULL,'2023-04-15 08:54:50',NULL,NULL,NULL,'2023-04-21 06:38:22','Yes', 'No','No');
UNLOCK TABLES;
DROP TABLE IF EXISTS `request`;
CREATE TABLE `request` (
`request_no` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`request_by` ENUM('Admin', 'Customer', 'WebsiteAdmin') NOT NULL,
`request_by_no` BIGINT NOT NULL,
`request_route` VARCHAR(250),
`request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`request_payload_json` JSON NOT NULL,
`request_operated_on` DATETIME DEFAULT CURRENT_TIMESTAMP,
`request_operator_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`request_no`)
) ENGINE = InnoDB;
DROP TABLE IF EXISTS `error_log`;
CREATE TABLE `error_log` (
`error_log_no` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`request_no` BIGINT NOT NULL,
`operated_by` ENUM('Admin', 'Customer', 'WebsiteAdmin') NOT NULL,
`operated_by_no` BIGINT NOT NULL,
`operated_route` VARCHAR(250),
`operated_request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`operated_config_json` JSON NOT NULL,
`operated_payload_json` JSON NOT NULL,
`operated_session_json` JSON NOT NULL,
`exception_json` JSON NOT NULL,
`operated_on` DATETIME DEFAULT CURRENT_TIMESTAMP,
`operator_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`error_log_no`)
) ENGINE = InnoDB;
DROP TABLE IF EXISTS `debug_log`;
CREATE TABLE `debug_log` (
`debug_log_no` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`debug_mode` VARCHAR(250),
`request_no` BIGINT NOT NULL,
`operated_by` ENUM('Admin', 'Customer', 'WebsiteAdmin') NOT NULL,
`operated_by_no` BIGINT NOT NULL,
`operated_route` VARCHAR(250),
`operated_request_method` ENUM('GET', 'POST', 'PUT', 'PATCH', 'DELETE') NOT NULL,
`operated_config_json` JSON NOT NULL,
`operated_payload_json` JSON NOT NULL,
`operated_session_json` JSON NOT NULL,
`exception_json` JSON NOT NULL,
`operated_on` DATETIME DEFAULT CURRENT_TIMESTAMP,
`operator_ip` VARCHAR(25) NOT NULL,
PRIMARY KEY (`debug_log_no`)
) ENGINE = InnoDB;
|
Download
