1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
ALTER TABLE trends RENAME COLUMN value_min TO zbx_old_tmp1;
ALTER TABLE trends RENAME COLUMN value_avg TO zbx_old_tmp2;
ALTER TABLE trends RENAME COLUMN value_max TO zbx_old_tmp3;
ALTER TABLE trends
ADD (value_min BINARY_DOUBLE DEFAULT '0.0000' NOT NULL,
value_avg BINARY_DOUBLE DEFAULT '0.0000' NOT NULL,
value_max BINARY_DOUBLE DEFAULT '0.0000' NOT NULL);
UPDATE trends
SET value_min=zbx_old_tmp1,
value_avg=zbx_old_tmp2,
value_max=zbx_old_tmp3;
ALTER TABLE trends DROP COLUMN zbx_old_tmp1;
ALTER TABLE trends DROP COLUMN zbx_old_tmp2;
ALTER TABLE trends DROP COLUMN zbx_old_tmp3;
ALTER TABLE history RENAME COLUMN value TO zbx_old_tmp1;
ALTER TABLE history ADD value BINARY_DOUBLE DEFAULT '0.0000' NOT NULL;
UPDATE history SET value=zbx_old_tmp1;
ALTER TABLE history DROP COLUMN zbx_old_tmp1;
|
