workouttest_server/data/db/update_1_0_23.sql

4 lines
162 B
SQL

ALTER TABLE `exercise_tree`
DROP COLUMN `parent_id`;
UPDATE configuration set config_value = "1.0.23", date_change=CURRENT_DATE WHERE config_key = "db_version";