workouttest_server/data/db/update_1_0_33.sql
2021-04-26 08:38:39 +02:00

15 lines
373 B
SQL

START TRANSACTION;
ALTER TABLE `tutorial_steps`
ADD COLUMN `condition` CHAR(50) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci' AFTER `check_text`;
ALTER TABLE `tutorial_steps`
ADD COLUMN `parent` INT(3) NOT NULL DEFAULT '0' AFTER `condition`;
UPDATE configuration set config_value = "1.0.33", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;