workouttest_server/data/db/update_1_0_47.sql
Tibor Bossanyi (Freelancer) 10c8dd2319 API 1.0.47 Customer.trialDate
2021-08-09 15:46:10 +02:00

9 lines
234 B
SQL

START TRANSACTION;
ALTER TABLE `customer`
ADD COLUMN `trial_date` DATETIME NULL DEFAULT NULL AFTER `synced_date`;
UPDATE configuration set config_value = "1.0.47", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;