src/resources/manual_schema_postgre.sql

alter system set max_connections=4000;

DROP SCHEMA IF EXISTS demo_ds CASCADE;
DROP SCHEMA IF EXISTS demo_ds_0 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_1 CASCADE;

DROP SCHEMA IF EXISTS demo_ds_master CASCADE;
DROP SCHEMA IF EXISTS demo_ds_slave_0 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_slave_1 CASCADE;

DROP SCHEMA IF EXISTS demo_ds_master_0 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_master_0_slave_0 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_master_0_slave_1 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_master_1 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_master_1_slave_0 CASCADE;
DROP SCHEMA IF EXISTS demo_ds_master_1_slave_1 CASCADE;

CREATE SCHEMA IF NOT EXISTS demo_ds;
CREATE SCHEMA IF NOT EXISTS demo_ds_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_1;

CREATE SCHEMA IF NOT EXISTS demo_ds_master;
CREATE SCHEMA IF NOT EXISTS demo_ds_slave_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_slave_1;

CREATE SCHEMA IF NOT EXISTS demo_ds_master_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_master_0_slave_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_master_0_slave_1;
CREATE SCHEMA IF NOT EXISTS demo_ds_master_1;
CREATE SCHEMA IF NOT EXISTS demo_ds_master_1_slave_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_master_1_slave_1;

-- Should sync from master-salve automatically
 CREATE TABLE IF NOT EXISTS demo_ds_0.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
  PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_0.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
  PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_1.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
  PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_1.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
  PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_0.t_order (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_1.t_order (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_0.t_order_item (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_1.t_order_item (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_0.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                    PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_1.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                    PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_0.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
 CREATE TABLE IF NOT EXISTS demo_ds_slave_0.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));

 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_order_0 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_order_1 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_order_0 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_order_1 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_order_0 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_order_1 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_order_0 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_order_1 (order_id SERIAL NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                             PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                             PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                             PRIMARY KEY (user_id));
 
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_user_0 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_user_1 (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                               PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_cipher VARCHAR(200), pwd VARCHAR(200), pwd_cipher VARCHAR(200), pwd_plain VARCHAR(200),
                                                             PRIMARY KEY (user_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_order_item_0 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_0.t_order_item_1 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_order_item_0 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_0_slave_1.t_order_item_1 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_order_item_0 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_0.t_order_item_1 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_order_item_0 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));
 CREATE TABLE IF NOT EXISTS demo_ds_master_1_slave_1.t_order_item_1 (order_item_id SERIAL NOT NULL, order_id BIGINT NOT NULL, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_item_id));