ls-db-setup.sql

USE mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
CREATE USER 'ls'@'172.%' IDENTIFIED BY 'phaibooth3sha6Hi';
CREATE DATABASE ls;
GRANT ALL PRIVILEGES ON ls.* TO 'ls'@'172.%';
USE ls;
CREATE TABLE player (name varchar(255) NOT NULL PRIMARY KEY, password varchar(255) NOT NULL, preferred_colour varchar(255) NOT NULL, role varchar(255) NOT NULL);
INSERT INTO player VALUES ('admin', '$2a$12$hB0DoJ2PAIEdUmWiQh.9d.f9IuO/L85ZY.Gxf/iHbnyTWgZM0zgS2', 'CAFFEE', 'ROLE_ADMIN');
INSERT INTO player VALUES ('maex', '$2a$12$6.McsTs654WOtJTB8ItKK.ARPo05Wv2ErCKiXKbXudvjE/EGJrZTy', 'FCBA03', 'ROLE_PLAYER');
INSERT INTO player VALUES ('joerg', '$2a$12$6.McsTs654WOtJTB8ItKK.ARPo05Wv2ErCKiXKbXudvjE/EGJrZTy', '03FC9D', 'ROLE_PLAYER');
INSERT INTO player VALUES ('hyacinth', '$2a$12$6.McsTs654WOtJTB8ItKK.ARPo05Wv2ErCKiXKbXudvjE/EGJrZTy', '0367FC', 'ROLE_PLAYER');
INSERT INTO player VALUES ('ryan', '$2a$12$6.McsTs654WOtJTB8ItKK.ARPo05Wv2ErCKiXKbXudvjE/EGJrZTy', 'FC0356', 'ROLE_PLAYER');