UPDATE `mn_EventFormFieldValue` SET `value` = 'Check-Paid' WHERE `mn_EventFormFieldValue`.`id_fmf` =5 AND CONVERT( `mn_EventFormFieldValue`.`lang` USING utf8 ) = 'eng' AND `mn_EventFormFieldValue`.`sorter` =1 LIMIT 1 ;
UPDATE `mn_EventFormFieldValue` SET `value` = 'Manual Credit' WHERE `mn_EventFormFieldValue`.`id_fmf` =5 AND CONVERT( `mn_EventFormFieldValue`.`lang` USING utf8 ) = 'eng' AND `mn_EventFormFieldValue`.`sorter` =3 LIMIT 1 ;

INSERT INTO `mn_EventFormFieldValue` 
(`id_fmf` , `lang` , `sorter` , `value` )
VALUES 
('5', 'eng', '4', 'COMP'), 
('5', 'eng', '5', 'Check-Pending');


UPDATE `mn_EventFormReqFldVal` AS `Value`
INNER JOIN mn_EventFormReqFld AS `Field` ON `Field`.`id` = `Value`.`id_fmrf`
SET `Value`.`value` = 'Manual Credit'
WHERE `Field`.`id_fmfld` = 5 AND `Value`.`value` = 'MNCAR Credit';


UPDATE `mn_EventFormReqFldVal` AS `Value`
INNER JOIN mn_EventFormReqFld AS `Field` ON `Field`.`id` = `Value`.`id_fmrf`
SET `Value`.`value` = 'Check-Paid'
WHERE `Field`.`id_fmfld` = 5 AND `Value`.`value` = 'Check';


INSERT INTO `mn_EventFormReqType` 
(`id` , `name`)
VALUES ('7', 'COMP');

UPDATE `mn_EventFormReq` SET `payment_type` = 5 WHERE `payment_type` = 6;

UPDATE `mn_EventFormFieldValue` SET `sorter` = '6' WHERE `id_fmf` = 5  AND `value` = 'Online Credit' LIMIT 1; 
UPDATE `mn_EventFormFieldValue` SET `sorter` = '10' WHERE `id_fmf` = 5 AND `value` = 'Check-Paid' LIMIT 1;
UPDATE `mn_EventFormFieldValue` SET `sorter` = '8' WHERE `id_fmf` = 5 AND `value` = 'Cash' LIMIT 1; 
UPDATE `mn_EventFormFieldValue` SET `sorter` = '7' WHERE `id_fmf` = 5 AND `value` = 'Manual Credit' LIMIT 1;
UPDATE `mn_EventFormFieldValue` SET `sorter` = '11' WHERE `id_fmf` = 5 AND `value` = 'COMP';
UPDATE `mn_EventFormFieldValue` SET `sorter` = '9' WHERE `id_fmf` = 5 AND `value` = 'Check-Pending';


UPDATE `mn_EventFormReqType` SET `name` = 'Manual Credit' WHERE `mn_EventFormReqType`.`id` =2 LIMIT 1 ;