workouttest_server/data/db/update_1_0_20.sql

5 lines
291 B
SQL

ALTER TABLE `product`
ADD COLUMN `product_id_ios` CHAR(50) NULL DEFAULT NULL AFTER `valid_to`,
ADD COLUMN `product_id_android` CHAR(50) NULL DEFAULT NULL AFTER `product_id_ios`;
UPDATE configuration set config_value = "1.0.20", date_change=CURRENT_DATE WHERE config_key = "db_version";