35 lines
1011 B
Plaintext
35 lines
1011 B
Plaintext
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;
|
|
|