INSERT INTO sps_menu (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
	 ('transactions_anpr_entry','admin/transaction/view_anpr_entry','menu',12,'1',4.05,1,0,0,0,'2024-09-16 05:56:47','2017-04-10 12:52:34',NULL,0);

-- menu_id will be sps_menu id	
INSERT INTO sps_menu_action_mapping (menu_id,action_id,area_id,location_id,created_by,updated_by,created_at,updated_at,deleted_at) VALUES
	 (112,1,0,0,0,0,'2024-09-16 09:20:36','0000-00-00 00:00:00',NULL);

-- menu_id will be sps_menu id
INSERT INTO sps_access_rights (role_id,menu_id,action_id,created_by,updated_at,deleted_at,location_id,area_id,updated_by,created_at) VALUES
	 (1,112,1,0,'2024-09-16 01:00:00',NULL,1,1,0,'2024-09-16 09:21:00');
	 
	
	
	
-- db_mgf_menu_anpr.sps_anpr_correction definition
-- use db_anpr_menu_mgf;
CREATE TABLE `sps_anpr_correction` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sps_transaction_id` bigint(20) NOT NULL,
  `vehicle_number` varchar(255) NOT NULL,
  `txn_entry_time` datetime NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;