Samuele Locatelli
115a9c3cc3
- Update conf sqlScripts - migration x TaskExec - views/stored creation (maybe)
37 lines
8.3 KiB
SQL
37 lines
8.3 KiB
SQL
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1001,'Mechanical','Whole',1020,'MaintServ','CycleProc01','Maintenance of speed reducers.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1002,'Mechanical','Whole',170,'MaintServ','CycleProc01','Maintenance shaft supports and lubrication.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1003,'Mechanical','Whole',170,'MaintServ','CycleProc01','Maintenance of the linear guides and of the ball screws.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1004,'Mechanical','Whole',1020,'MaintServ','MacPowerOn','Maintenance of transmission belts.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1005,'Mechanical','Whole',1020,'MaintServ','MacPowerOn','Maintenance flexible/rigid couplings.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1006,'Mechanical','Whole',1020,'MaintServ','MacPowerOn','Maintenance locking devices.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1007,'Mechanical','Whole',1020,'MaintServ','MacPowerOn','Maintenance keys and fasteners.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1008,'Mechanical','Whole',2040,'MaintServ','CycleProc01','Inspect and adjust machine geometry. Calibrate systems that require it.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1101,'Electro','Whole',2040,'MaintServ','CycleProc01','Maintenance on the electric motors.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1102,'Electro','Whole',1020,'MaintServ','MacPowerOn','Maintenance of the electrical system.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1103,'Electro','Cabinet',510,'MaintServ','MacPowerOn','Check programmable controller functionality (PLC).', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1104,'Electro','Cabinet',2040,'MaintServ','MacPowerOn','Periodic maintenance of the Cabinet ventilation system.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1105,'Electro','OpPanel',40,'MaintServ','MacPowerOn','Cleaning the control panel air conditioners.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1106,'Electro','Cabinet',510,'MaintServ','MacPowerOn','Checking the auxiliary batteries.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1107,'Electro','Axis',170,'MaintServ','SpindleTorque01','Maintenance of electro-spindle 1.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1108,'Electro','Axis',170,'MaintServ','SpindleTorque02','Maintenance of electro-spindle 2.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1109,'Electro','Axis',170,'MaintServ','SpindleTorque03','Maintenance of electro-spindle 3.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1110,'Electro','Axis',170,'MaintServ','SpindleTorque04','Maintenance of electro-spindle 4.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1201,'Preumo','Whole',1020,'MaintServ','MacPowerOn','Check pressure switch.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1202,'Preumo','Whole',2040,'MaintServ','MacPowerOn','Maintenance of the FR and FRL units.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1203,'Preumo','Whole',2040,'MaintServ','CycleProc01','Maintenance of the pneumatic valves and solenoid valves.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1204,'Preumo','Whole',2040,'MaintServ','CycleProc01','Maintenance of the pneumatic cylinders.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1301,'Lubro','Whole',170,'TrainOp','MacPowerOn','Manually lubricate or grease systems that require it.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1401,'Hydro','Whole',2040,'MaintServ','MacPowerOn','Maintenance of hydraulic system.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1402,'Hydro','Whole','2000','MaintServ','MacPowerOn','Replacing the oil.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1403,'Hydro','Whole',1020,'MaintServ','MacPowerOn','Check piping.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1404,'Hydro','Whole',1020,'MaintServ','MacPowerOn','External inspection of tanks and steel components.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1501,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check the safety signs.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1502,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check emergency buttons.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1503,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check interlock switches with electromagnet and RFID technology and with guard locking.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1504,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check interlock switches for hinges.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1505,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check safety modules.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1506,'Safety','Whole',1020,'MaintServ','MacPowerOn','Check guards.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1507,'Safety','OpPanel',1020,'MaintServ','MacPowerOn','Check PITmode operating mode selector switch.', true, false);
|
|
INSERT INTO PrevMaintTask(MachineId,ExtIdx,PMTCode,PMMGCode,ExpiryVal,PMUTCode,CCode,JobDescription, Protected,IsDisabled) VALUES (1,1508,'Safety','Cabinet',1020,'MaintServ','MacPowerOn','Replace the protection fuses inside Cabinet.', true, false);
|