workouttest_server/data/db/update_1_0_52.sql
Tibor Bossanyi (Freelancer) ca0312746e API 1.0.52 customer.phone
2021-10-05 17:48:45 +02:00

11 lines
224 B
SQL

START TRANSACTION;
ALTER TABLE `customer`
ADD COLUMN `phone` CHAR(50) NULL DEFAULT NULL AFTER `lang`;
UPDATE configuration set config_value = "1.0.52", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;