db/migration/000001_init_schema.up.sql

BEGIN;

CREATE DATABASE IF NOT EXISTS lake_test;

CREATE USER IF NOT EXISTS 'merico'@'localhost' IDENTIFIED BY 'merico';
GRANT ALL PRIVILEGES ON *.* TO 'merico'@'%';

USE lake_test;

CREATE TABLE `schema_migrations` (
  `version` bigint NOT NULL DEFAULT 1,
  `dirty` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

SELECT now();

COMMIT;