| 12345678910111213141516171819202122232425 |
- -- 运维三率字段(PostgreSQL)
- -- 复位及时率、消缺及时率、状态转换率的统计结果写入 turbine_info_day。
- ALTER TABLE turbine_info_day
- ADD COLUMN IF NOT EXISTS timerate1 double precision,
- ADD COLUMN IF NOT EXISTS timerate2 double precision,
- ADD COLUMN IF NOT EXISTS timerate3 double precision,
- ADD COLUMN IF NOT EXISTS timerate4 double precision,
- ADD COLUMN IF NOT EXISTS timerate5 double precision,
- ADD COLUMN IF NOT EXISTS timerate6 double precision,
- ADD COLUMN IF NOT EXISTS timerate7 double precision,
- ADD COLUMN IF NOT EXISTS timerate8 double precision,
- ADD COLUMN IF NOT EXISTS timerate9 double precision,
- ADD COLUMN IF NOT EXISTS timerate10 double precision,
- ADD COLUMN IF NOT EXISTS timerate11 double precision,
- ADD COLUMN IF NOT EXISTS timerate12 double precision,
- ADD COLUMN IF NOT EXISTS timerate13 double precision,
- ADD COLUMN IF NOT EXISTS timerate14 double precision,
- ADD COLUMN IF NOT EXISTS timerate15 double precision,
- ADD COLUMN IF NOT EXISTS timerate16 double precision,
- ADD COLUMN IF NOT EXISTS timerate17 double precision,
- ADD COLUMN IF NOT EXISTS timerate18 double precision,
- ADD COLUMN IF NOT EXISTS timerate19 double precision,
- ADD COLUMN IF NOT EXISTS timerate20 double precision,
- ADD COLUMN IF NOT EXISTS timerate21 double precision,
- ADD COLUMN IF NOT EXISTS timerate22 double precision;
|