delete FROM person_vaccine WHERE export_vaccine_code ='815';

delete FROM vaccine_combination WHERE vaccine_code = 'FLU';

delete FROM anc_service WHERE export_vaccine_code ='815';

delete FROM provis_vcctype WHERE code ='FLU';

delete FROM provis_aptype WHERE CODE = '815';

SET @FLUv = 'FLU';/*แก้ 'FLU' เป็น code ที่ต้องการ */

INSERT IGNORE INTO `provis_vcctype` (`code`, `name`, `hos_guid`)

VALUES ('815', 'FLU', NULL);

#---------

SET @FLU = (SELECT MAX(person_vaccine_id)+1 FROM person_vaccine) ;

INSERT IGNORE INTO`person_vaccine` (`person_vaccine_id`, `vaccine_name`, `vaccine_code`, `vaccine_group`, `export_vaccine_code`, `hos_guid`, `combine_vaccine`, `icode`)

VALUES (@FLU, 'Flu ไข้หวัดใหญ่(Z251)', '815', @FLUv, '815', NULL, 'N', NULL);

#------------

SET @FLU =(SELECT MAX(vaccine_combination_id)+1 FROM vaccine_combination);

SET @FLUv = 'FLU';

INSERT IGNORE INTO`vaccine_combination` (`vaccine_combination_id`, `vaccine_code`, `vaccine_combine_code`, `hos_guid`)

VALUES (@FLU,@FLUv,'FLU', NULL);

#------------

SET @FLU = (SELECT MAX(anc_service_id)+1 FROM anc_service) ;

INSERT INTO `anc_service` (`anc_service_id`, `anc_service_name`, `anc_service_code`, `export_vaccine_code`, `icode`, `price`, `hos_guid`) VALUES (@FLU, 'FLU', 'FLU', '815', NULL, NULL, NULL);

#------------

SET @FLUz = 'Flu ไข้หวัดใหญ่(Z251)';

INSERT INTO `provis_aptype` (`code`, `name`, `hos_guid`, `hos_guid_ext`) VALUES ('815', @FLUz, NULL, NULL);

#------------

SET @group = (SELECT MAX(person_vaccine_group_lot_id)+1 FROM person_vaccine_group_lot) ;

INSERT INTO `person_vaccine_group_lot` (`person_vaccine_group_lot_id`, `vaccine_group`, `vaccine_lot`, `receive_date`, `expire_date`, `receive_qty`, `left_qty`, `vaccine_lot_active`, `hos_guid`)

VALUES (@group, 'Flu',NULL,NULL,NULL,NULL, NULL, 'Y', NULL);

SELECT * FROM provis_vcctype where CODE = '815';