workouttest_server/data/db/update_1_0_6.sql
2020-09-04 15:58:30 +02:00

6 lines
237 B
SQL

ALTER TABLE `customer`
ADD COLUMN `trainer` TINYINT(4) NULL DEFAULT '0' AFTER `admin`,
ADD COLUMN `trainer_id` INT(11) NULL DEFAULT '0' AFTER `trainer`;
UPDATE configuration set config_value = "1.0.6" WHERE config_key = "db_version";