turbine_info_day_three_rate.sql 1.4 KB

12345678910111213141516171819202122232425
  1. -- 运维三率字段(PostgreSQL)
  2. -- 复位及时率、消缺及时率、状态转换率的统计结果写入 turbine_info_day。
  3. ALTER TABLE turbine_info_day
  4. ADD COLUMN IF NOT EXISTS timerate1 double precision,
  5. ADD COLUMN IF NOT EXISTS timerate2 double precision,
  6. ADD COLUMN IF NOT EXISTS timerate3 double precision,
  7. ADD COLUMN IF NOT EXISTS timerate4 double precision,
  8. ADD COLUMN IF NOT EXISTS timerate5 double precision,
  9. ADD COLUMN IF NOT EXISTS timerate6 double precision,
  10. ADD COLUMN IF NOT EXISTS timerate7 double precision,
  11. ADD COLUMN IF NOT EXISTS timerate8 double precision,
  12. ADD COLUMN IF NOT EXISTS timerate9 double precision,
  13. ADD COLUMN IF NOT EXISTS timerate10 double precision,
  14. ADD COLUMN IF NOT EXISTS timerate11 double precision,
  15. ADD COLUMN IF NOT EXISTS timerate12 double precision,
  16. ADD COLUMN IF NOT EXISTS timerate13 double precision,
  17. ADD COLUMN IF NOT EXISTS timerate14 double precision,
  18. ADD COLUMN IF NOT EXISTS timerate15 double precision,
  19. ADD COLUMN IF NOT EXISTS timerate16 double precision,
  20. ADD COLUMN IF NOT EXISTS timerate17 double precision,
  21. ADD COLUMN IF NOT EXISTS timerate18 double precision,
  22. ADD COLUMN IF NOT EXISTS timerate19 double precision,
  23. ADD COLUMN IF NOT EXISTS timerate20 double precision,
  24. ADD COLUMN IF NOT EXISTS timerate21 double precision,
  25. ADD COLUMN IF NOT EXISTS timerate22 double precision;