ALTER TABLE tst_aggregate_remonty ADD COLUMN TAR_TST_ID int(11) NULL DEFAULT NULL AFTER TAR_ID;
ALTER TABLE tst_aggregate_export_spm ADD COLUMN TAR_TST_ID int(11) NULL DEFAULT NULL AFTER TAR_ID;



DROP TABLE IF EXISTS tst_aggregate_export_spm_tmp;
CREATE TABLE tst_aggregate_export_spm_tmp
SELECT
TAR_ID
,(SELECT TST_ID FROM tst_tests WHERE TST_ID=(SELECT MAX(TST_ID) FROM tst_tests WHERE TST_PUP_NAME=TAR_PUP_NAME AND TST_PUP_SN_NO=TAR_PUP_SN_NO AND TST_ENG_NAME=TAR_ENG_NAME AND TST_ENG_SN_NO=TAR_ENG_SN_NO AND date(TST_AUDIT_CD)=date(TAR_AUDIT_CD))) TAR_TST_ID
,TAR_PUP_DRS_ID
,TAR_PUP_NAME
,TAR_PUP_SN_NO
,TAR_ENG_DRS_ID
,TAR_ENG_NAME
,TAR_ENG_SN_NO
,TAR_CABLE_TYP
,TAR_CABLE_DLUGOSC
,TAR_CABLE_OZNAK_01
,TAR_CABLE_OZNAK_02
,TAR_CABLE_MEMO
,TAR_DEPARTMENT
,TAR_DEV_RESOURCES_ID
,TAR_AUDIT_CD
FROM tst_aggregate_export_spm
ORDER BY TAR_ID;

TRUNCATE TABLE tst_aggregate_export_spm;

INSERT INTO tst_aggregate_export_spm
SELECT * FROM tst_aggregate_export_spm_tmp;

DROP TABLE tst_aggregate_export_spm_tmp;

