t_data_point.sql 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  2. VALUES ('SC.PwrAt.Ra.F32', 2, 3100);
  3. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  4. VALUES ('SC.PwrReact.Ra.F32', 2, 3101);
  5. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  6. VALUES ('SC.PF.Ra.F32', 2, 3102);
  7. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  8. VALUES ('SC.DC.Ra.F32', 2, 3104);
  9. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  10. VALUES ('SC.Other.Ra.F32.day', 2, 3105);
  11. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  12. VALUES ('SC.TotEgyAt.Wt.F32', 2, 3107);
  13. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  14. VALUES ('SC.TurSt.Rs.S.QH', 2, 3099);
  15. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  16. VALUES ('MELT.Temp.Ra.F32', 1, 1105);
  17. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  18. VALUES ('MELT.Hum.Ra.F32', 1, 1107);
  19. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  20. VALUES ('MELT.Pres.Ra.F32', 1, 1106);
  21. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  22. VALUES ('MELT.Wdir.Ra.F32', 1, 1110);
  23. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  24. VALUES ('MELT.WSpd.Ra.F32', 1, 1109);
  25. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  26. VALUES ('MELT.TRadio.Ra.F32', 1, 1101);
  27. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  28. VALUES ('MELT.DRadio.Ra.F32', 1, 1102);
  29. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  30. VALUES ('MELT.SRadio.Ra.F32', 1, 1103);
  31. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  32. VALUES ('MELT.SSHour.Ra.F32.day', 1, 1111);
  33. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  34. VALUES ('MELT.TRadio.Ra.F32.day', 1, 1112);
  35. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  36. VALUES ('MELT.DRadio.Ra.F32.day', 1, 1113);
  37. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  38. VALUES ('MELT.SRadio.Ra.F32.day', 1, 1114);
  39. INSERT INTO t_data_point (C_MEASURING_POINT, C_EQUIPMENT_TYPE, C_EQUIPMENT_ATTRIBUTE_ID)
  40. VALUES ('MELT.Bool.Rd.b0.0004', 1, 1100);