workouttest_server/data/db/update_1_0_35.sql
2021-04-29 08:05:42 +02:00

14 lines
353 B
SQL

START TRANSACTION;
ALTER TABLE `tutorial_steps`
CHANGE COLUMN `error_text` `direction` TEXT NULL DEFAULT NULL AFTER `tutorial_text`;
ALTER TABLE `tutorial_steps`
ADD COLUMN `branch` CHAR(100) NULL DEFAULT NULL AFTER `action`;
UPDATE configuration set config_value = "1.0.35", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;