Setup Scm Activity Database

CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;

CREATE USER 'scmactivity'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON scmactivity.* TO 'scmactivity'@'%';
FLUSH PRIVILEGES;

jdbc:mariadb://localhost/scmactivity

//use this for unicode character encoding
jdbc:mariadb://localhost/scmactivity?useUnicode=yes&characterEncoding=UTF-8

jdbc:postgresql://localhost:5432/scmactivity