workouttest_server/data/db/update_1_0_45.sql
2021-06-17 23:30:15 +02:00

9 lines
235 B
SQL

START TRANSACTION;
ALTER TABLE `exercise_type`
ADD COLUMN `buddy_warning` TINYINT NOT NULL DEFAULT 0 AFTER `base`;
UPDATE configuration set config_value = "1.0.45", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;