--liquibase formatted sql

--changeset kelvin:update user and group

TRUNCATE `lionerdb`.`group`;
INSERT INTO `lionerdb`.`group` (`name`, `description`) VALUES
('Case Officer', 'Case Officer Group'),
('Administrator', 'Administrator Group'),
('System Admin', 'System Admin Group');

TRUNCATE `lionerdb`.`user`;
INSERT INTO `lionerdb`.`user` (`username`, `password`, `locked`, `name`, `fullname`) VALUES ('2fi', '$2a$10$65S7/AhKn8MldlYmvFN5JOfr1yaULwFNDIhTskLTuUCKgbbs8sFAi', '0', '2fi', '2fi');
SET @su_id = LAST_INSERT_ID();

TRUNCATE `lionerdb`.`user_group`;
INSERT INTO `lionerdb`.`user_group` (`groupId`, `userId`) VALUES ('3', @su_id);