database-mysql.sql

SET tx_isolation = 'READ-COMMITTED';

CREATE SCHEMA IF NOT EXISTS `echo` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER IF NOT EXISTS echo_migrate;
CREATE USER IF NOT EXISTS echo_service;

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `echo`.* TO 'echo_service'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES, EXECUTE, SHOW VIEW ON `echo`.* TO 'echo_migrate'@'%';