workouttest_server/data/db/update_1_0_21.sql
2020-12-23 21:07:46 +01:00

5 lines
280 B
SQL

ALTER TABLE `product`
ADD COLUMN `price_ios` FLOAT NULL DEFAULT NULL AFTER `product_id_android`,
ADD COLUMN `price_android` FLOAT NULL DEFAULT NULL AFTER `price_ios`;
UPDATE configuration set config_value = "1.0.21", date_change=CURRENT_DATE WHERE config_key = "db_version";