workouttest_server/data/db/update_1_0_28.sql
2021-03-10 21:14:51 +01:00

13 lines
334 B
SQL

START TRANSACTION;
ALTER TABLE `exercise_tree`
ADD COLUMN `description` TEXT NULL DEFAULT NULL AFTER `name`;
ALTER TABLE `exercise_tree_translation`
ADD COLUMN `description` TEXT NULL DEFAULT NULL AFTER `name`;
UPDATE configuration set config_value = "1.0.28", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;