- Install mysql
CREATE USER 'evochia_developer'@'localhost' IDENTIFIED BY 'apassword';
CREATE DATABASE evochia_dev;
CREATE DATABASE evochia_test;
GRANT ALL ON evochia_dev.* TO 'evochia_developer'@'localhost';
GRANT ALL ON evochia_test.* TO 'evochia_developer'@'localhost';
- clean flyway schema
./gradlew flywayClean
- run schema migration
./gradlew flywayMigrate --stacktrace
./gradlew bootRun -Dspring.profiles.active=dev
example:
SELECT
LOWER(CONCAT(
SUBSTR(HEX(client_id), 1, 8), '-',
SUBSTR(HEX(client_id), 9, 4), '-',
SUBSTR(HEX(client_id), 13, 4), '-',
SUBSTR(HEX(client_id), 17, 4), '-',
SUBSTR(HEX(client_id), 21)
))
FROM client_credentials;