workouttest_server/data/db/update_1_0_58.sql
2023-01-16 07:54:17 +01:00

11 lines
399 B
SQL

START TRANSACTION;
ALTER TABLE `training_plan_detail`
ADD COLUMN `ecto_resting_time` INT(5) NULL DEFAULT NULL AFTER `ecto_weight`,
ADD COLUMN `endo_resting_time` INT(5) NULL DEFAULT NULL AFTER `endo_weight`,
ADD COLUMN `intensity` DOUBLE NULL DEFAULT NULL AFTER `round_group`;
UPDATE configuration set config_value = "1.0.58", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;