account dev

------------------------------------------------------------------------------------------
CREATE DATABASE dev_ga_ags CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------
-- create usage
GRANT USAGE ON * . * TO  'dev_ga_ags'@'172.20.%' IDENTIFIED BY  'AxTe7uRiAqCI7I4NN77LeFkz' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_ga_ags` . * TO  'dev_ga_ags'@'172.20.%';

-- mysql -h 172.20.31.9 -u dev_ga_ags -pAxTe7uRiAqCI7I4NN77LeFkz dev_ga_ags < garuda_ags-structure.sql
-- mysql -h 172.20.31.9 -u dev_ga_ags -pAxTe7uRiAqCI7I4NN77LeFkz dev_ga_ags < garuda_ags-data.sql

==========================================================================================

------------------------------------------------------------------------------------------
CREATE DATABASE dev_ga_ags_client CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------


GRANT USAGE ON * . * TO  'dev_ga_client'@'172.20.%' IDENTIFIED BY  'KYOr0yUUXjmXTrVRbGabfhWy' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_ga_ags_client` . * TO  'dev_ga_client'@'172.20.%';

-- mysql -h 172.20.31.9 -u dev_ga_client -pKYOr0yUUXjmXTrVRbGabfhWy dev_ga_ags_client < ags_client-structure.sql

==========================================================================================

------------------------------------------------------------------------------------------
CREATE DATABASE dev_geolite CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------


GRANT USAGE ON * . * TO  'dev_geolite'@'172.20.%' IDENTIFIED BY  'KYyR8vHR7vg3iIxnPVkUwifR' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_geolite` . * TO  'dev_geolite'@'172.20.%';

-- mysql -h 172.20.31.9 -u dev_geolite -pKYyR8vHR7vg3iIxnPVkUwifR dev_geolite < geolite-20180305.sql

==========================================================================================

------------------------------------------------------------------------------------------
CREATE DATABASE dev_ga_gos CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------


-- create usage
GRANT USAGE ON * . * TO  'dev_ga_gos'@'172.20.%' IDENTIFIED BY  'JESMUr9F1x0RnhHlh2YObPzx' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_ga_gos` . * TO  'dev_ga_gos'@'172.20.%';
------------------------------------------------------------------------------------------

-- mysql -h 172.20.31.9 -u dev_ga_gos -pJESMUr9F1x0RnhHlh2YObPzx dev_ga_gos < dev_garudagos2-structure.sql
-- mysql -h 172.20.31.9 -u dev_ga_gos -pJESMUr9F1x0RnhHlh2YObPzx dev_ga_gos < dev_garudagos2-data.sql




==========================================================================================

------------------------------------------------------------------------------------------
CREATE DATABASE dev_ga_ota CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------


-- create usage
GRANT USAGE ON * . * TO  'dev_ga_ota'@'172.20.%' IDENTIFIED BY  'NAbFX1emZtup8RAHNFzDyRfR' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_ga_ota` . * TO  'dev_ga_ota'@'172.20.%';

GRANT SELECT, LOCK TABLES, SHOW VIEW ON  `dev_ga_gos` . * TO  'dev_ga_ota'@'172.20.%';

-- mysql -h 172.20.31.9 -u dev_ga_ota -pNAbFX1emZtup8RAHNFzDyRfR dev_ga_ota < dev_garuda_ota-orders-structure.sql
-- mysql -h 172.20.31.9 -u dev_ga_ota -pNAbFX1emZtup8RAHNFzDyRfR dev_ga_ota < dev_garuda_ota-payment-structure.sql

-- mysql -h 172.20.31.9 -u dev_ga_ota -pNAbFX1emZtup8RAHNFzDyRfR dev_ga_ota < dev_garuda_ota-orders-data.sql
-- mysql -h 172.20.31.9 -u dev_ga_ota -pNAbFX1emZtup8RAHNFzDyRfR dev_ga_ota < dev_garuda_ota-payment-data.sql







CREATE OR REPLACE
  VIEW branch
AS
  SELECT
    *
  FROM
    dev_ga_gos.branch
;

CREATE OR REPLACE
  VIEW ga_webmember
AS
  SELECT
    *
  FROM
    dev_ga_gos.ga_webmember
;


CREATE OR REPLACE
  VIEW users
AS
  SELECT
    *
  FROM
    dev_ga_gos.users
;



CREATE OR REPLACE
  VIEW user_profiles
AS
  SELECT
    *
  FROM
    dev_ga_gos.user_profiles
;




==========================================================================================

------------------------------------------------------------------------------------------
CREATE DATABASE dev_ga_ags_log CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------

GRANT USAGE ON * . * TO  'dev_ga_ags_log'@'172.20.%' IDENTIFIED BY  'S3oyXahVAcyCIV56cESqHD4q' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `dev_ga_ags_log` . * TO  'dev_ga_ags_log'@'172.20.%';

GRANT SELECT, LOCK TABLES, SHOW VIEW ON  `dev_ga_ags` . * TO  'dev_ga_ags_log'@'172.20.%';


-- mysql -h 172.20.31.9 -u dev_ga_ags_log -pS3oyXahVAcyCIV56cESqHD4q dev_ga_ags_log < garuda_ags_log-structure.sql




==========================================================================================
------------------------------------------------------------------------------------------
CREATE DATABASE cacti01 CHARACTER SET utf8 COLLATE utf8_general_ci;
------------------------------------------------------------------------------------------


GRANT USAGE ON * . * TO  'cacti01'@'172.20.%' IDENTIFIED BY  'AIm6Z8bGAbUTY2baZcqWKZ1O' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

-- create permission
GRANT ALL PRIVILEGES ON  `cacti01` . * TO  'cacti01'@'172.20.%';

-- mysql -h 172.20.31.9 -u cacti01 -pKYOr0yUUXjmXTrVRbGabfhWy cacti01 < ags_client-structure.sql