workouttest_server/data/db/update_1_0_16.sql
2020-11-26 18:36:54 +01:00

5 lines
262 B
SQL

ALTER TABLE `exercise_device`
ADD COLUMN `sort` INT NULL DEFAULT '0' AFTER `image_url`,
ADD COLUMN `place` TINYINT NULL DEFAULT '0' AFTER `sort`;
UPDATE configuration set config_value = "1.0.16", date_change=CURRENT_DATE WHERE config_key = "db_version";