CREATE TABLE h_hcourt_stat_allegation_mapping_11 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=20 AND `STAT_GROUP` IN(1);
CREATE TABLE h_hcourt_stat_allegation_mapping_1 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=10 AND `STAT_GROUP` IN(1);
CREATE TABLE h_hcourt_stat_allegation_mapping_13 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=20 AND `STAT_GROUP` IN(17,18,19);
CREATE TABLE h_hcourt_stat_allegation_mapping_14 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=20 AND `STAT_GROUP` IN(14,15,16);
CREATE TABLE h_hcourt_stat_allegation_mapping_4 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=10 AND `STAT_GROUP` IN(5,6,7);
CREATE TABLE h_hcourt_stat_allegation_mapping_15 SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=20 AND `STAT_GROUP` IN(20);
TRUNCATE TABLE h_hcourt_stat_allegation_mapping_11 INSERT INTO h_hcourt_stat_allegation_mapping_11  SELECT * FROM `h_hcourt_stat_allegation_mapping` WHERE `CASE_TYPE`=20 AND `STAT_GROUP` IN(1,2,3,6,7);



UPDATE hcase SET case_judge=AES_ENCRYPT('235', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='361';
UPDATE hcase SET case_judge=AES_ENCRYPT('24', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='261';
UPDATE hcase SET case_judge=AES_ENCRYPT('33', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='263';
UPDATE hcase SET case_judge=AES_ENCRYPT('43', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='266';
UPDATE hcase SET case_judge=AES_ENCRYPT('200', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='199';
UPDATE hcase SET case_judge=AES_ENCRYPT('57', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='270';
UPDATE hcase SET case_judge=AES_ENCRYPT('140', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='309';
UPDATE hcase SET case_judge=AES_ENCRYPT('132', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='304';
UPDATE hcase SET case_judge=AES_ENCRYPT('154', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='321';
UPDATE hcase SET case_judge=AES_ENCRYPT('190', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='329';
UPDATE hcase SET case_judge=AES_ENCRYPT('151', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='315';
UPDATE hcase SET case_judge=AES_ENCRYPT('2', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='257';
UPDATE hcase SET case_judge=AES_ENCRYPT('215', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='346';
UPDATE hcase SET case_judge=AES_ENCRYPT('158', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='157';
UPDATE hcase SET case_judge=AES_ENCRYPT('183', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='325';
UPDATE hcase SET case_judge=AES_ENCRYPT('224', '4b5ce2f') WHERE AES_DECRYPT( case_judge,  '4b5ce2f' )='356';


UPDATE hcase_work_flow SET respons_id='235' WHERE respons_id='361';
UPDATE hcase_work_flow SET respons_id='24' WHERE respons_id='261';
UPDATE hcase_work_flow SET respons_id='33' WHERE respons_id='263';
UPDATE hcase_work_flow SET respons_id='43' WHERE respons_id='266';
UPDATE hcase_work_flow SET respons_id='200' WHERE respons_id='199';
UPDATE hcase_work_flow SET respons_id='57' WHERE respons_id='270';
UPDATE hcase_work_flow SET respons_id='140' WHERE respons_id='309';
UPDATE hcase_work_flow SET respons_id='132' WHERE respons_id='304';
UPDATE hcase_work_flow SET respons_id='154' WHERE respons_id='321';
UPDATE hcase_work_flow SET respons_id='190' WHERE respons_id='329';
UPDATE hcase_work_flow SET respons_id='151' WHERE respons_id='315';
UPDATE hcase_work_flow SET respons_id='2' WHERE respons_id='257';
UPDATE hcase_work_flow SET respons_id='215' WHERE respons_id='346';
UPDATE hcase_work_flow SET respons_id='158' WHERE respons_id='157';
UPDATE hcase_work_flow SET respons_id='183' WHERE respons_id='325';
UPDATE hcase_work_flow SET respons_id='224' WHERE respons_id='356';