workouttest_server/data/db/update_1_0_44.sql
2021-06-07 15:26:48 +02:00

9 lines
228 B
SQL

START TRANSACTION;
ALTER TABLE `training_plan`
ADD COLUMN `active` TINYINT NOT NULL DEFAULT 0 AFTER `free`;
UPDATE configuration set config_value = "1.0.44", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;