14 lines
488 B
SQL
14 lines
488 B
SQL
START TRANSACTION;
|
|
|
|
ALTER TABLE `exercises`
|
|
ADD COLUMN `training_plan_details_id` INT NULL DEFAULT NULL AFTER `exercise_plan_detail_id`;
|
|
|
|
ALTER TABLE `customer_training_plan_details`
|
|
ADD COLUMN `resting_time` INT(3) NULL DEFAULT NULL,
|
|
ADD COLUMN `parallel` TINYINT(4) NULL DEFAULT NULL,
|
|
ADD COLUMN `day` CHAR(50) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci';
|
|
|
|
UPDATE configuration set config_value = "1.0.42", date_change=CURRENT_DATE WHERE config_key = "db_version";
|
|
|
|
COMMIT;
|