setup DB for temp development

[prashantbabar002]

As a Developer I need temporary database created in azure instance So that we can use it in development systems

Acceptance Criteria

1. create cloud db to template tables
2. share connection string details

Notes

1. Temp home for data. All DBs will be migrated once data structures are defined

[prashantbabar002]

https://askubuntu.com/questions/1261422/how-to-install-mysql-8-0-with-lower-case-table-names-1-on-ubuntu-server-20-04-lt https://stackoverflow.com/questions/15663001/remote-connections-mysql-ubuntu

CREATE SCHEMA `mybogie`;

CREATE TABLE `mb_org_account` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `NAME` varchar(500) NOT NULL,
  `ADDRESS` varchar(4000) NOT NULL,
  `OWNER` varchar(200) NOT NULL,
  `CREATED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MODIFIED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CREATED_BY` varchar(200) NOT NULL,
  `MODIFIED_BY` varchar(200) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;