PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Ramesh Narayan Jangid (Sharma)   Open Swoole Microservices   Sql/global.sql   Download  
File: Sql/global.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Open Swoole Microservices
Implement microservices using Open Swoole
Author: By
Last change: Refactoring
Refactoring
Refactoring
Converted Indentation to Tab
Converted Indentation to Tab
Converted Indentation to Tab
Converted Indentation to Tab
Refactoring
Refactoring
Date: 12 days ago
Size: 4,705 bytes
 

Contents

Class file image Download 
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;