CREATE TABLE ohrm_license_details (id  INT NOT NULL AUTO_INCREMENT, content TEXT NOT NULL, PRIMARY KEY (`id`));

INSERT INTO `ohrm_module`(`name`, `status`) VALUES ('license', 1);
SET @module_id := (SELECT LAST_INSERT_ID());

INSERT INTO ohrm_screen (`name`, `module_id`, `action_url`) VALUES('License Update', @module_id, 'addLicense');
SET @addLicense_screen_id := (SELECT LAST_INSERT_ID());


INSERT INTO ohrm_menu_item (`menu_title`, `screen_id`, `parent_id`, `level`, `order_hint`, `url_extras`, `status`) VALUES('License Update',@addLicense_screen_id , 1, 2, 900, '', 1);
SET @licenseUpload_menu_id :=(SELECT LAST_INSERT_ID());

SET @sys_admin_role_id := (SELECT `id` FROM ohrm_user_role WHERE `name` = 'ConfigAdmin');

INSERT INTO `ohrm_user_role_screen` (`user_role_id`, `screen_id`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES (@sys_admin_role_id, @addLicense_screen_id, '1', '1', '1', '1');
