/* 删除脏数据，删除未发布的订阅应用  */


/* 删除脏数据  */
/* kd_1.5.43.1_hrcs_msgpublisher.sql  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573056;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573057;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573058;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573059;
/* kd_1.5.43_hrcs_msgpublisher.sql  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573056;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573057;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573058;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1392038839014573059;
/* kd_1.5.44_hrcs_msgpublisher.sql  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518272;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518273;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518274;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518275;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518276;
/* kd_1.5.45_hrcs_msgpublisher.sql  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518272;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518273;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518274;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518275;
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518276;


/* 删除未发布的订阅应用  */
/* 102010  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518272;
/* 107020  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518275;
/* 106010  */
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518276;


DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518273;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,103010,1397100321758518273); 
DELETE FROM t_hrcs_subbsifield WHERE FPKID = 1397100321758518274;
INSERT INTO t_hrcs_subbsifield(FID,FBASEDATAID,FPKID) VALUES (1335553746759046144,107010,1397100321758518274); 
