

CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(11) NOT NULL,  
  `role` varchar(100) NOT NULL,
  `access` varchar(100) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

INSERT INTO user_roles (slug,role,access) VALUES ('UR89JK1BHG','Admin','{​​"admin":"Y", "model":"Y", "forecast":"Y", "reporting":"Y" }');

INSERT INTO user_roles (slug,role,access) VALUES ('UR687DFEJK','Modeller','{​​"admin":"N", "model":"Y", "forecast":"Y", "reporting":"Y" }');

INSERT INTO user_roles (slug,role,access) VALUES ('UR12LKMDYU','Forecaster','{​​"admin":"N", "model":"N", "forecast":"Y", "reporting":"Y" }');

INSERT INTO user_roles (slug,role,access) VALUES ('URVB45CX9G','Business Manager','{​​"admin":"N", "model":"N", "forecast":"N", "reporting":"Y" }');


​​​