TRUNCATE TABLE softspm_test.seg_manufacturers;
INSERT INTO softspm_test.seg_manufacturers
SELECT * FROM softspm.seg_manufacturers;


TRUNCATE TABLE softspm_test.seg_pumps;
INSERT INTO softspm_test.seg_pumps
SELECT 
PUP_ID
,PUP_MCF_ID
,NULL
,PUP_NAME
,PUP_Q_N
,PUP_Q_MIN
,PUP_Q_MAX
,PUP_H_P
,PUP_H_MIN
,PUP_H_MAX
,PUP_ETA_MAX
,PUP_PUMP_LENGTH
,PUP_SHAFT_LENGTH
,PUP_WEIGHT
,PUP_DIAMETER
,NULL
,PUP_STATUS
 FROM softspm.seg_pumps ;


TRUNCATE TABLE softspm_test.seg_pump_eng_param;
INSERT INTO softspm_test.seg_pump_eng_param
SELECT * FROM softspm.seg_pump_eng_param;


TRUNCATE TABLE softspm_test.seg_engines;
INSERT INTO softspm_test.seg_engines
SELECT 
ENG_ID
,ENG_MCF_ID
,NULL
,ENG_NAME
,ENG_VOLTAGE
,ENG_LENGTH
,ENG_WEIGHT
,ENG_DIAMETER
,ENG_WIRES
,ENG_POWER
,ENG_ELECTRICITY
,ENG_RPM
,ENG_COS_FI
,ENG_ETA
,ENG_STATUS
FROM softspm.seg_engines;


TRUNCATE TABLE softspm_test.seg_pump_engine_rel;
INSERT INTO softspm_test.seg_pump_engine_rel
SELECT * FROM softspm.seg_pump_engine_rel;
 
 
TRUNCATE TABLE softspm_test.seg_dev_resources;
INSERT INTO softspm_test.seg_dev_resources
SELECT 
DRS_ID
,DRS_DEV_ID
,DRS_DEV_TYPE
,DRS_SN_NUMBER
,DRS_BUY_DATE
,DRS_AVAILABLE_DATE
,DRS_STATUS_DIC_ID
,DRS_RESOURCES_DIC_ID
,DRS_DEV_ATTENTION
,NULL
,DRS_AUDIT_USR
,DRS_AUDIT_DATE
 FROM softspm.seg_dev_resources;


UPDATE  
softspm.seg_dev_resources s, softspm_test.seg_dev_resources t 
SET t.DRS_AUDIT_USR = s.DRS_DEPARTMENT
WHERE s.DRS_ID=t.DRS_ID;


TRUNCATE TABLE softspm_test.sys_dictionaries;
INSERT INTO softspm_test.sys_dictionaries
SELECT * FROM softspm.sys_dictionaries;


TRUNCATE TABLE softspm_test.sys_participants;
INSERT INTO softspm_test.sys_participants SET PRT_NAME='P/Szczerców',PRT_DESCRIPTION='P/Szczerców',PRT_SYSTEM_TYPE='SoftSPM_test',PRT_SYSTEM_ACCESS_LEVEL=1,PRT_STATUS='1',PRT_AUDIT_CD=now();
INSERT INTO softspm_test.sys_participants SET PRT_NAME='P/Bełchatów',PRT_DESCRIPTION='P/Bełchatów',PRT_SYSTEM_TYPE='SoftSPM_test',PRT_SYSTEM_ACCESS_LEVEL=1,PRT_STATUS='1',PRT_AUDIT_CD=now();
INSERT INTO softspm_test.sys_participants SET PRT_NAME='Dębina',PRT_DESCRIPTION='Dębina',PRT_SYSTEM_TYPE='SoftSPM_test',PRT_SYSTEM_ACCESS_LEVEL=1,PRT_STATUS='1',PRT_AUDIT_CD=now();



TRUNCATE TABLE softspm_test.tst_aggregate_remonty;
INSERT INTO softspm_test.tst_aggregate_remonty
SELECT 
null
,PUP_DRS_ID
,PUP_NAME
,PUP_SN_NO
,ENG_DRS_ID
,ENG_NAME
,ENG_SN_NO
,ECB_TYP
,ECB_DLUGOSC
,ECB_OZNAK_01
,ECB_OZNAK_02
,PUP_DEPARTMENT
,706
,NOW()
FROM 
softspm.rep_aggregate_departments;




TRUNCATE TABLE softspm_test.tst_tests;
INSERT INTO softspm_test.tst_tests
SELECT 
TST_ID
,null
,TST_TPL_ID
,TST_PUP_ID
,(SELECT PUP_NAME FROM seg_pumps WHERE PUP_ID=TST_PUP_ID) PUP_NAME
,TST_PUP_SN_NO
,TST_ENG_ID
,(SELECT ENG_NAME FROM seg_engines WHERE ENG_ID=TST_ENG_ID) ENG_NAME
,TST_ENG_SN_NO
,TST_STAN_COLD
,TST_STAN_WARM
,TST_WATER_TEMP_BEFORE
,TST_WATER_TEMP_AFTER
,TST_STATUS
,TST_AUDIT_CU
,TST_AUDIT_CD
FROM softspm.tst_tests;


update softspm_test.tst_tests t1, softspm.stp_stapo t2
SET t1.TST_PRT_ID=t2.stp_stapo_user_id
where t1.TST_PUP_NAME=t2.stp_stapo_typ_p AND t1.TST_PUP_SN_NO=t2.stp_stapo_nr_p

UPDATE softspm_test.tst_tests SET TST_WATER_TEMP_BEFORE=(17+FLOOR(RAND() * 5)),TST_WATER_TEMP_AFTER=(20+FLOOR(RAND() * 5))
UPDATE softspm_test.tst_tests SET TST_STATUS='1', TST_STAN_COLD=50, TST_STAN_WARM=55;


UPDATE softspm_test.tst_tests SET TST_PRT_ID = (select stp_stapo_user_id FROM softspm.stp_stapo WHERE stp_stapo_id=(select MAX(stp_stapo_id) FROM softspm.stp_stapo WHERE stp_stapo_typ_p=TST_PUP_NAME AND stp_stapo_nr_p=TST_PUP_SN_NO));
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=111 WHERE TST_PRT_ID=3;
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=222 WHERE TST_PRT_ID=1;
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=333 WHERE TST_PRT_ID=2;
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=1 WHERE TST_PRT_ID=111;
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=2 WHERE TST_PRT_ID=222;
UPDATE  softspm_test.tst_tests SET TST_PRT_ID=3 WHERE TST_PRT_ID=333;
UPDATE tst_aggregate_remonty SET TAR_DEPARTMENT='o-1/D' WHERE TAR_DEPARTMENT='Dębina';
UPDATE tst_aggregate_remonty SET TAR_DEPARTMENT='o-2' WHERE TAR_DEPARTMENT='P/Szczerców';
UPDATE tst_aggregate_remonty SET TAR_DEPARTMENT='o-1' WHERE TAR_DEPARTMENT='P/Bełchatów';



TRUNCATE TABLE softspm_test.tst_test_details;
INSERT INTO softspm_test.tst_test_details
SELECT * FROM softspm.tst_test_details;