/*sps_menu table query*/
INSERT INTO `sps_menu`
        (`id`, `menu_item`, `menu_url`, `menu_class`, `parent_menu_id`, `action`, `order`, `status`, `location_id`, `area_id`, `created_by`, `created_at`, `updated_at`, `deleted_at`, `updated_by`)
        VALUES (NULL, 'frequency_report', 'admin/frequency_report', 'menu', '46', '', '11.32', '1', '1', '1', '1', CURRENT_TIMESTAMP, '0000-00-00 00:00:00.000000', NULL, '');


/*sps_menu mapping table query*/
INSERT INTO `sps_menu_action_mapping`
        (`id`, `menu_id`, `action_id`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
        VALUES (NULL, (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "frequency_report"), '1', '0', '0', '0', '0', CURRENT_TIMESTAMP, '0000-00-00 00:00:00.000000', NULL);

INSERT INTO `sps_menu_action_mapping`
        (`id`, `menu_id`, `action_id`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
        VALUES (NULL, (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "frequency_report"), '6', '0', '0', '0', '0', CURRENT_TIMESTAMP, '0000-00-00 00:00:00.000000', NULL);

/*If sps_reports_list table exist in database then run following query for alert configuration*/
INSERT INTO `sps_reports_list` (`id`, `report_name`) VALUES (NULL, 'frequency_report');


/*sps_access_rights table query*/

INSERT INTO `sps_access_rights`
	(`id`, `role_id`, `menu_id`, `action_id`, `created_by`, `updated_at`, `deleted_at`, `location_id`, `area_id`, `updated_by`, `created_at`)
	VALUES ('0', '1', (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "frequency_report"), '1', '0', CURRENT_TIMESTAMP, NULL, '0', '0', '0', CURRENT_TIMESTAMP);

INSERT INTO `sps_access_rights`
	(`id`, `role_id`, `menu_id`, `action_id`, `created_by`, `updated_at`, `deleted_at`, `location_id`, `area_id`, `updated_by`, `created_at`)
	VALUES ('0', '1', (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "frequency_report"), '6', '0', CURRENT_TIMESTAMP, NULL, '0', '0', '0', CURRENT_TIMESTAMP);
