workouttest_server/data/db/update_1_2_1.sql
2023-03-26 12:28:50 +02:00

7 lines
233 B
SQL

START TRANSACTION;
ALTER TABLE `diet_meal`
ADD COLUMN `meal_date` DATETIME NULL DEFAULT NULL AFTER `quantity_unit`;
UPDATE configuration set config_value = "1.2.1", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;