manage userrole hris

use 'dps_hris_db';

CREATE TABLE `hris_userrole` (
  `userrole_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `userrole_name` varchar(255) NOT NULL,
  `userrole_status` int NOT NULL
) COLLATE 'utf8_general_ci';

CREATE TABLE `hris_userrole_header` (
  `userrole_header_id` int NOT NULL,
  `userrole_id` int(11) NOT NULL,
  `user_id` int NOT NULL,
  FOREIGN KEY (`userrole_id`) REFERENCES `hris_userrole` (`userrole_id`)
);