Swapping Cause and Equipment for Downtime

Owned by Michael Addison
Last updated: Sept 17, 2024
1 min read

How to change the data within these tables.

tblAreaShutdownEquipment

tblAreaShutdownReason

tblAreaShutdown

Step 1 - Duplicate Data

Datagrip, create insert into statements for Equipment and Reason tables for all the data.

For inserts for tblAreaShutdownReason, do a REPLACE

image-20240917-175525.png
image-20240917-175533.png

For inserts for tblAreaShutdownEquipment, do a REPLACE