... | @@ -49,13 +49,13 @@ If *Signatures* and/or *Periodic_metrics* have additional columns but their resp |
... | @@ -49,13 +49,13 @@ If *Signatures* and/or *Periodic_metrics* have additional columns but their resp |
|
Several fields have to be added in this update. To do so, run the following commands to the database's CLI client:
|
|
Several fields have to be added in this update. To do so, run the following commands to the database's CLI client:
|
|
|
|
|
|
```
|
|
```
|
|
ALTER TABLE Signatures ADD COLUMN avg_imc_f BIGINT unsigned AFTER avg_f;
|
|
ALTER TABLE Signatures ADD COLUMN avg_imc_f INT unsigned AFTER avg_f;
|
|
ALTER TABLE Signatures ADD COLUMN perc_MPI DOUBLE AFTER time;
|
|
ALTER TABLE Signatures ADD COLUMN perc_MPI FLOAT AFTER time;
|
|
ALTER TABLE Signatures ADD COLUMN IO_MBS DOUBLE AFTER GBS;
|
|
ALTER TABLE Signatures ADD COLUMN IO_MBS FLOAT AFTER GBS;
|
|
|
|
|
|
ALTER TABLE Learning_signatures ADD COLUMN avg_imc_f BIGINT unsigned AFTER avg_f;
|
|
ALTER TABLE Learning_signatures ADD COLUMN avg_imc_f INT unsigned AFTER avg_f;
|
|
ALTER TABLE Learning_signatures ADD COLUMN perc_MPI DOUBLE AFTER time;
|
|
ALTER TABLE Learning_signatures ADD COLUMN perc_MPI FLOAT AFTER time;
|
|
ALTER TABLE Learning_signatures ADD COLUMN IO_MBS DOUBLE AFTER GBS;
|
|
ALTER TABLE Learning_signatures ADD COLUMN IO_MBS FLOAT AFTER GBS;
|
|
```
|
|
```
|
|
|
|
|
|
|
|
|
... | | ... | |